2025-05-07T01:51:31.805Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.806Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.808Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.808Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:31.810Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.813Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.814Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.818Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.820Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.951Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:31.953Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:31.955Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:31.958Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:31.959Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:31.962Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:31.965Z DEBUG 2502 --- [Pool-1-worker-7] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:31.966Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:31.969Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into sleep_session (minutes_asleep,minutes_awake,notes,start_time,stop_time,user_id,zone_id,id) values (?,?,?,?,?,?,?,?)
2025-05-07T01:51:31.972Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:31.976Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into sleep_session (minutes_asleep,minutes_awake,notes,start_time,stop_time,user_id,zone_id,id) values (?,?,?,?,?,?,?,?)
2025-05-07T01:51:31.977Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.981Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.984Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.988Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.989Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.992Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.993Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.996Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:31.997Z WARN 2502 --- [o-auto-1-exec-2] c.s.server.security.WebSecurityConfig : org.springframework.security.authentication.InsufficientAuthenticationException: Full authentication is required to access this resource at /api/login
2025-05-07T01:51:31.998Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.002Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.006Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.007Z DEBUG 2502 --- [o-auto-1-exec-2] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time,r1_0.user_id,r1_0.role_id from app_user u1_0 join user_role r1_0 on u1_0.id=r1_0.user_id where u1_0.email=?
2025-05-07T01:51:32.007Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.010Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.011Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.014Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.016Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.019Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.020Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.024Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.025Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.026Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.030Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.032Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.036Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.038Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.042Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.043Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.047Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.051Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.052Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.056Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.060Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.063Z DEBUG 2502 --- [o-auto-1-exec-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time,r1_0.user_id,r1_0.role_id from app_user u1_0 join user_role r1_0 on u1_0.id=r1_0.user_id where u1_0.email=?
2025-05-07T01:51:32.063Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.066Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.068Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.073Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.076Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.081Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.082Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.083Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.086Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.087Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.091Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.095Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.100Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.101Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.104Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.108Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.112Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.113Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.115Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.116Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.117Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.119Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.120Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.121Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.122Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.124Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.125Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.127Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.128Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.129Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.131Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.132Z WARN 2502 --- [o-auto-1-exec-3] o.s.s.a.event.LoggerListener : Authentication event AuthenticationFailureBadCredentialsEvent: herschel.bahringer@yahoo.com; details: WebAuthenticationDetails [RemoteIpAddress=127.0.0.1, SessionId=null]; exception: Bad credentials
2025-05-07T01:51:32.132Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.136Z DEBUG 2502 --- [Pool-1-worker-7] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:32.137Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.138Z DEBUG 2502 --- [Pool-1-worker-7] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:32.140Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.141Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.142Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.143Z DEBUG 2502 --- [Pool-1-worker-7] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:32.144Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.145Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.146Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.147Z DEBUG 2502 --- [Pool-1-worker-7] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:32.148Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:32.150Z DEBUG 2502 --- [Pool-1-worker-7] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.158Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:32.177Z WARN 2502 --- [o-auto-1-exec-3] c.s.server.security.WebSecurityConfig : org.springframework.security.authentication.InsufficientAuthenticationException: Full authentication is required to access this resource at /error
2025-05-07T01:51:32.180Z DEBUG 2502 --- [Pool-1-worker-8] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:32.207Z WARN 2502 --- [o-auto-1-exec-4] c.s.server.security.WebSecurityConfig : org.springframework.security.authentication.InsufficientAuthenticationException: Full authentication is required to access this resource at /api/login
2025-05-07T01:51:32.215Z DEBUG 2502 --- [o-auto-1-exec-3] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time,r1_0.user_id,r1_0.role_id from app_user u1_0 join user_role r1_0 on u1_0.id=r1_0.user_id where u1_0.email=?
2025-05-07T01:51:32.216Z WARN 2502 --- [o-auto-1-exec-2] o.s.s.a.event.LoggerListener : Authentication event AuthenticationSuccessEvent: chris.simonis@yahoo.com; details: WebAuthenticationDetails [RemoteIpAddress=127.0.0.1, SessionId=null]
2025-05-07T01:51:32.246Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:32.286Z WARN 2502 --- [o-auto-1-exec-1] o.s.s.a.event.LoggerListener : Authentication event AuthenticationSuccessEvent: joan.grant@gmail.com; details: WebAuthenticationDetails [RemoteIpAddress=127.0.0.1, SessionId=null]
2025-05-07T01:51:32.327Z DEBUG 2502 --- [o-auto-1-exec-2] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:32.328Z DEBUG 2502 --- [o-auto-1-exec-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:32.329Z DEBUG 2502 --- [o-auto-1-exec-1] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.332Z DEBUG 2502 --- [o-auto-1-exec-2] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.338Z DEBUG 2502 --- [Pool-1-worker-8] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:32.341Z DEBUG 2502 --- [Pool-1-worker-8] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:32.342Z DEBUG 2502 --- [Pool-1-worker-8] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:32.344Z DEBUG 2502 --- [Pool-1-worker-8] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:32.346Z DEBUG 2502 --- [Pool-1-worker-8] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.351Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:32.356Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:32.357Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:32.360Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:32.363Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.373Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:32.380Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:32.383Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:32.383Z WARN 2502 --- [o-auto-1-exec-3] o.s.s.a.event.LoggerListener : Authentication event AuthenticationSuccessEvent: fernando.macgyver@hotmail.com; details: WebAuthenticationDetails [RemoteIpAddress=127.0.0.1, SessionId=null]
2025-05-07T01:51:32.385Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:32.388Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.391Z DEBUG 2502 --- [Pool-1-worker-9] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:32.396Z DEBUG 2502 --- [o-auto-1-exec-3] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:32.399Z WARN 2502 --- [o-auto-1-exec-5] c.s.server.security.WebSecurityConfig : org.springframework.security.authentication.InsufficientAuthenticationException: Full authentication is required to access this resource at /api/login
2025-05-07T01:51:32.403Z DEBUG 2502 --- [o-auto-1-exec-3] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.408Z DEBUG 2502 --- [o-auto-1-exec-5] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time,r1_0.user_id,r1_0.role_id from app_user u1_0 join user_role r1_0 on u1_0.id=r1_0.user_id where u1_0.email=?
2025-05-07T01:51:32.420Z DEBUG 2502 --- [ool-1-worker-10] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:32.436Z WARN 2502 --- [o-auto-1-exec-4] c.s.server.security.WebSecurityConfig : org.springframework.security.authentication.InsufficientAuthenticationException: Full authentication is required to access this resource at /api/login
2025-05-07T01:51:32.451Z WARN 2502 --- [o-auto-1-exec-6] c.s.server.security.WebSecurityConfig : org.springframework.security.authentication.InsufficientAuthenticationException: Full authentication is required to access this resource at /api/login
2025-05-07T01:51:32.457Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select pl1_0.series,pl1_0.last_used,pl1_0.token,pl1_0.username from persistent_logins pl1_0 where pl1_0.username=?
2025-05-07T01:51:32.465Z DEBUG 2502 --- [o-auto-1-exec-7] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time,r1_0.user_id,r1_0.role_id from app_user u1_0 join user_role r1_0 on u1_0.id=r1_0.user_id where u1_0.email=?
2025-05-07T01:51:32.468Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:32.565Z WARN 2502 --- [o-auto-1-exec-5] o.s.s.a.event.LoggerListener : Authentication event AuthenticationSuccessEvent: nena.mueller@hotmail.com; details: WebAuthenticationDetails [RemoteIpAddress=127.0.0.1, SessionId=null]
2025-05-07T01:51:32.569Z DEBUG 2502 --- [o-auto-1-exec-5] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:32.573Z DEBUG 2502 --- [o-auto-1-exec-5] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.587Z DEBUG 2502 --- [Pool-1-worker-9] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:32.589Z DEBUG 2502 --- [Pool-1-worker-9] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:32.590Z DEBUG 2502 --- [Pool-1-worker-9] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:32.591Z DEBUG 2502 --- [Pool-1-worker-9] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:32.592Z DEBUG 2502 --- [Pool-1-worker-8] org.hibernate.SQL : select count(pl1_0.series) from persistent_logins pl1_0 where pl1_0.username=?
2025-05-07T01:51:32.593Z DEBUG 2502 --- [Pool-1-worker-9] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.599Z DEBUG 2502 --- [o-auto-1-exec-3] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:32.599Z DEBUG 2502 --- [o-auto-1-exec-2] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:32.601Z DEBUG 2502 --- [o-auto-1-exec-2] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.602Z DEBUG 2502 --- [o-auto-1-exec-3] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.602Z DEBUG 2502 --- [o-auto-1-exec-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:32.606Z DEBUG 2502 --- [o-auto-1-exec-1] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.620Z DEBUG 2502 --- [ool-1-worker-10] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:32.624Z DEBUG 2502 --- [Pool-1-worker-7] org.hibernate.SQL : select count(pl1_0.series) from persistent_logins pl1_0 where pl1_0.username=?
2025-05-07T01:51:32.624Z DEBUG 2502 --- [ool-1-worker-10] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:32.626Z DEBUG 2502 --- [ool-1-worker-10] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:32.630Z DEBUG 2502 --- [ool-1-worker-10] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:32.631Z DEBUG 2502 --- [ool-1-worker-10] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.638Z WARN 2502 --- [o-auto-1-exec-6] o.s.s.a.event.LoggerListener : Authentication event LogoutSuccessEvent: nena.mueller@hotmail.com; details: WebAuthenticationDetails [RemoteIpAddress=127.0.0.1, SessionId=null]
2025-05-07T01:51:32.645Z WARN 2502 --- [o-auto-1-exec-1] c.s.server.security.WebSecurityConfig : org.springframework.security.authentication.InsufficientAuthenticationException: Full authentication is required to access this resource at /api/user/0196a870-e2eb-768b-9695-24fd3475489a
2025-05-07T01:51:32.645Z DEBUG 2502 --- [Pool-1-worker-8] org.hibernate.SQL : select count(pl1_0.series) from persistent_logins pl1_0 where pl1_0.username=?
2025-05-07T01:51:32.666Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:32.669Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:32.670Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:32.672Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:32.674Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.680Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:32.680Z WARN 2502 --- [o-auto-1-exec-2] c.s.server.security.WebSecurityConfig : org.springframework.security.authentication.InsufficientAuthenticationException: Full authentication is required to access this resource at /api/login
2025-05-07T01:51:32.685Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into message (text,time,type_id,user_id) values (?,?,?,?)
2025-05-07T01:51:32.685Z DEBUG 2502 --- [o-auto-1-exec-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time,r1_0.user_id,r1_0.role_id from app_user u1_0 join user_role r1_0 on u1_0.id=r1_0.user_id where u1_0.email=?
2025-05-07T01:51:32.688Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into message (text,time,type_id,user_id) values (?,?,?,?)
2025-05-07T01:51:32.692Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select me1_0.text,me1_0.type_id from message me1_0 join app_user u1_0 on u1_0.id=me1_0.user_id where u1_0.public_id=? and me1_0.time>=? order by me1_0.time
2025-05-07T01:51:32.727Z WARN 2502 --- [o-auto-1-exec-8] c.s.server.security.WebSecurityConfig : org.springframework.security.authentication.InsufficientAuthenticationException: Full authentication is required to access this resource at /api/login
2025-05-07T01:51:32.736Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : select count(pl1_0.series) from persistent_logins pl1_0 where pl1_0.username=?
2025-05-07T01:51:32.740Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : delete from message me1_0 where exists(select 1 from (values(0)) d_ join app_user u1_0 on u1_0.id=me1_0.user_id where u1_0.public_id=?)
2025-05-07T01:51:32.748Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select me1_0.text,me1_0.type_id from message me1_0 join app_user u1_0 on u1_0.id=me1_0.user_id where u1_0.public_id=? and me1_0.time>=? order by me1_0.time
2025-05-07T01:51:32.752Z WARN 2502 --- [o-auto-1-exec-7] o.s.s.a.event.LoggerListener : Authentication event AuthenticationSuccessEvent: harry.hettinger@yahoo.com; details: WebAuthenticationDetails [RemoteIpAddress=127.0.0.1, SessionId=null]
2025-05-07T01:51:32.830Z WARN 2502 --- [o-auto-1-exec-1] o.s.s.a.event.LoggerListener : Authentication event AuthenticationSuccessEvent: al.collier@yahoo.com; details: WebAuthenticationDetails [RemoteIpAddress=127.0.0.1, SessionId=null]
2025-05-07T01:51:32.834Z DEBUG 2502 --- [o-auto-1-exec-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:32.835Z DEBUG 2502 --- [o-auto-1-exec-1] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.842Z DEBUG 2502 --- [ool-1-worker-10] org.hibernate.SQL : select count(pl1_0.series) from persistent_logins pl1_0 where pl1_0.username=?
2025-05-07T01:51:32.869Z DEBUG 2502 --- [o-auto-1-exec-6] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:32.870Z DEBUG 2502 --- [o-auto-1-exec-6] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:32.879Z DEBUG 2502 --- [o-auto-1-exec-3] org.hibernate.SQL : update app_user set display_name=?,email=?,notifications_enabled=?,password=?,registration_time=? where id=?
2025-05-07T01:51:32.899Z WARN 2502 --- [o-auto-1-exec-7] c.s.server.security.WebSecurityConfig : org.springframework.security.authentication.InsufficientAuthenticationException: Full authentication is required to access this resource at /api/login
2025-05-07T01:51:32.904Z DEBUG 2502 --- [o-auto-1-exec-6] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time,r1_0.user_id,r1_0.role_id from app_user u1_0 join user_role r1_0 on u1_0.id=r1_0.user_id where u1_0.email=?
2025-05-07T01:51:32.984Z WARN 2502 --- [o-auto-1-exec-6] o.s.s.a.event.LoggerListener : Authentication event AuthenticationSuccessEvent: joan.grant@gmail.com; details: WebAuthenticationDetails [RemoteIpAddress=127.0.0.1, SessionId=null]
2025-05-07T01:51:32.986Z DEBUG 2502 --- [o-auto-1-exec-6] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:32.987Z DEBUG 2502 --- [o-auto-1-exec-6] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:33.010Z DEBUG 2502 --- [o-auto-1-exec-8] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:33.011Z DEBUG 2502 --- [o-auto-1-exec-8] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:33.650Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select pl1_0.series,pl1_0.last_used,pl1_0.token,pl1_0.username from persistent_logins pl1_0 where pl1_0.username=?
2025-05-07T01:51:34.879Z DEBUG 2502 --- [ool-1-worker-10] org.hibernate.SQL : select count(pl1_0.series) from persistent_logins pl1_0 where pl1_0.username=?
2025-05-07T01:51:34.881Z DEBUG 2502 --- [ool-1-worker-10] org.hibernate.SQL : select pl1_0.series,pl1_0.last_used,pl1_0.token,pl1_0.username from persistent_logins pl1_0 where pl1_0.last_used<?
2025-05-07T01:51:34.882Z DEBUG 2502 --- [ool-1-worker-10] org.hibernate.SQL : delete from persistent_logins where series=?
2025-05-07T01:51:34.884Z DEBUG 2502 --- [ool-1-worker-10] org.hibernate.SQL : select count(pl1_0.series) from persistent_logins pl1_0 where pl1_0.username=?
2025-05-07T01:51:34.890Z WARN 2502 --- [o-auto-1-exec-3] c.s.server.security.WebSecurityConfig : Session expired or invalid. Request cookie: remember-me=NHczJTJGVk9rTU01TiUyQjNsNmhmalFVRkElM0QlM0Q6WEV4eEpkVyUyQnlIMkdOZ2R3VzBtd1V3JTNEJTNE; SESSION=MGIzZjBhMTMtMmNlMS00ODg5LWExNzItNzkzMjcwZmIwOTE2 accessing /api/user/0196a870-e30c-7ef5-b87b-590a512a8eeb
2025-05-07T01:51:34.895Z WARN 2502 --- [o-auto-1-exec-1] c.s.server.security.WebSecurityConfig : Session expired or invalid. Request cookie: SESSION=MGIzZjBhMTMtMmNlMS00ODg5LWExNzItNzkzMjcwZmIwOTE2 accessing /api/user/0196a870-e30c-7ef5-b87b-590a512a8eeb