2025-05-07T01:51:29.744Z 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:29.749Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:29.753Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:29.758Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:29.760Z 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:29.764Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:29.767Z 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:29.772Z 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:29.768Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:29.773Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:29.776Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:29.776Z 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:29.779Z 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:29.783Z 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:29.792Z 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:29.798Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:29.800Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : update app_user set display_name=?,email=?,notifications_enabled=?,password=?,registration_time=? where id=?
2025-05-07T01:51:29.801Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:29.803Z 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:29.805Z 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:29.810Z 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:29.811Z 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:29.814Z 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:29.816Z 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:29.821Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:29.822Z 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:29.824Z 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:29.846Z 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:29.852Z 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:29.856Z WARN 2502 --- [Pool-1-worker-5] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 23514
2025-05-07T01:51:29.856Z ERROR 2502 --- [Pool-1-worker-5] o.h.engine.jdbc.spi.SqlExceptionHelper : Batch entry 0 insert into challenge (description,finish,name,start,user_id,id) values ((''),('2025-04-30 +00'),('title'),('2025-05-07 +00'),('10'::int8),('57'::int8)) was aborted: ERROR: new row for relation "challenge" violates check constraint "stop_after_start"
Detail: Failing row contains (57, 10, 2025-05-07, 2025-04-30, title, ). Call getNextException to see other errors in the batch.
2025-05-07T01:51:29.857Z ERROR 2502 --- [Pool-1-worker-5] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: new row for relation "challenge" violates check constraint "stop_after_start"
Detail: Failing row contains (57, 10, 2025-05-07, 2025-04-30, title, ).
2025-05-07T01:51:29.857Z 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:29.862Z 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:29.864Z 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:29.869Z 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:29.871Z 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:29.876Z 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:29.881Z 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:29.883Z 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