2025-05-07T01:51:30.964Z 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:30.972Z 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:30.974Z 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:30.976Z 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:30.979Z 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:30.983Z 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:30.985Z 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.id=?
2025-05-07T01:51:30.986Z INFO 2502 --- [Pool-1-worker-1] c.s.s.s.NotificationRetrievalService : Updating notification record for 0196a870-dc2c-743f-8bb2-b8c307681ef5 from 2025-05-07T01:51:30.860022Z to 2025-05-08T07:51:30.733313798Z
2025-05-07T01:51:30.987Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : update notification set last_sent=? where user_id=?
2025-05-07T01:51:30.990Z 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:30.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:30.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:30.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:31.004Z 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.009Z 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.012Z 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.015Z 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.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:31.023Z 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.027Z 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.028Z 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.031Z 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.034Z 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.035Z DEBUG 2502 --- [Pool-1-worker-4] 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:31.037Z 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.040Z 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.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:31.045Z 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.050Z 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.051Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:31.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:31.053Z 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.055Z 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.057Z 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.057Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:31.058Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:31.059Z DEBUG 2502 --- [Pool-1-worker-4] 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 offset ? rows fetch first ? rows only
2025-05-07T01:51:31.062Z 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.064Z DEBUG 2502 --- [Pool-1-worker-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:31.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:31.067Z DEBUG 2502 --- [Pool-1-worker-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:31.069Z 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.id=?
2025-05-07T01:51:31.070Z DEBUG 2502 --- [Pool-1-worker-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.public_id=?
2025-05-07T01:51:31.070Z INFO 2502 --- [Pool-1-worker-1] c.s.s.s.NotificationRetrievalService : Updating notification record for 0196a870-dc2c-743f-8bb2-b8c307681ef5 from 2025-05-08T07:51:30.733314Z to 2025-05-09T08:51:30.733313798Z
2025-05-07T01:51:31.073Z DEBUG 2502 --- [Pool-1-worker-5] 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.073Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : update notification set last_sent=? where user_id=?
2025-05-07T01:51:31.074Z INFO 2502 --- [Pool-1-worker-5] org.hibernate.orm.jdbc.batch : HHH100503: On release of batch it still contained JDBC statements
2025-05-07T01:51:31.074Z WARN 2502 --- [Pool-1-worker-5] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 23514
2025-05-07T01:51:31.074Z ERROR 2502 --- [Pool-1-worker-5] o.h.engine.jdbc.spi.SqlExceptionHelper : Batch entry 0 insert into sleep_session (minutes_asleep,minutes_awake,notes,start_time,stop_time,user_id,zone_id,id) values (('60'::int4),('0'::int4),(''),('2025-05-07 01:51:00+00'),('2025-05-07 00:51:00+00'),('27'::int8),('America/New_York'),('123'::int8)) was aborted: ERROR: new row for relation "sleep_session" violates check constraint "stop_after_start"
Detail: Failing row contains (123, 27, 2025-05-07 01:51:00, 2025-05-07 00:51:00, 0, 60, , America/New_York). Call getNextException to see other errors in the batch.
2025-05-07T01:51:31.074Z ERROR 2502 --- [Pool-1-worker-5] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: new row for relation "sleep_session" violates check constraint "stop_after_start"
Detail: Failing row contains (123, 27, 2025-05-07 01:51:00, 2025-05-07 00:51:00, 0, 60, , America/New_York).
2025-05-07T01:51:31.075Z 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.085Z 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