2025-05-07T01:51:29.167Z INFO 2502 --- [Pool-1-worker-2] c.s.s.c.EndToEndIntegrationTest :
2025-05-07T01:51:29.167Z INFO 2502 --- [Pool-1-worker-2] c.s.s.c.EndToEndIntegrationTest : =======================================================================================
2025-05-07T01:51:29.167Z INFO 2502 --- [Pool-1-worker-2] c.s.s.c.EndToEndIntegrationTest : Creating test data
2025-05-07T01:51:29.167Z INFO 2502 --- [Pool-1-worker-2] c.s.s.c.EndToEndIntegrationTest :
2025-05-07T01:51:29.232Z DEBUG 2502 --- [Pool-1-worker-2] 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.236Z 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.323Z DEBUG 2502 --- [Pool-1-worker-2] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:29.324Z 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.327Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:29.328Z DEBUG 2502 --- [Pool-1-worker-2] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:29.329Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:29.330Z DEBUG 2502 --- [Pool-1-worker-2] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:29.335Z 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.334Z DEBUG 2502 --- [Pool-1-worker-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:29.338Z DEBUG 2502 --- [Pool-1-worker-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:29.531Z 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.534Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:29.535Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:29.540Z 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:30.210Z 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:30.210Z 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:30.216Z 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:30.218Z 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:30.233Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.233Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.240Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.240Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.241Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.241Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.246Z DEBUG 2502 --- [Pool-1-worker-6] 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:30.249Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select ss1_0.id,ss1_0.minutes_asleep,ss1_0.notes,ss1_0.minutes_awake,ss1_0.start_time,ss1_0.stop_time,ss1_0.zone_id from sleep_session ss1_0 join app_user u1_0 on u1_0.id=ss1_0.user_id where u1_0.public_id=? order by ss1_0.stop_time
2025-05-07T01:51:30.256Z 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:30.258Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select c1_0.id,c1_0.name,c1_0.description,c1_0.start,c1_0.finish from challenge c1_0 join app_user u1_0 on u1_0.id=c1_0.user_id where u1_0.public_id=? order by c1_0.finish
2025-05-07T01:51:30.259Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:30.260Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:30.263Z 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:30.264Z 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:30.268Z 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:30.275Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.276Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.276Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.277Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.277Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.278Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.282Z DEBUG 2502 --- [Pool-1-worker-6] 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:30.286Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select ss1_0.id,ss1_0.minutes_asleep,ss1_0.notes,ss1_0.minutes_awake,ss1_0.start_time,ss1_0.stop_time,ss1_0.zone_id from sleep_session ss1_0 join app_user u1_0 on u1_0.id=ss1_0.user_id where u1_0.public_id=? order by ss1_0.stop_time
2025-05-07T01:51:30.290Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select c1_0.id,c1_0.name,c1_0.description,c1_0.start,c1_0.finish from challenge c1_0 join app_user u1_0 on u1_0.id=c1_0.user_id where u1_0.public_id=? order by c1_0.finish
2025-05-07T01:51:30.734Z 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:30.752Z INFO 2502 --- [o-auto-1-exec-3] o.s.web.servlet.DispatcherServlet : Completed initialization in 328 ms
2025-05-07T01:51:30.794Z 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:30.796Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:30.799Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:30.803Z 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:30.838Z 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:30.842Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:30.843Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:30.849Z 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:30.852Z 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:30.856Z 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:30.860Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.860Z 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:30.862Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:30.864Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:30.864Z 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:30.866Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.868Z 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:30.868Z 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:30.868Z WARN 2502 --- [Pool-1-worker-5] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 23505
2025-05-07T01:51:30.868Z 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 (('Dolores quaerat nisi illo assumenda quam. Ipsum facilis deserunt architecto eaque libero. Voluptatibus porro accusamus.'),('2025-05-20 +00'),('Khitomer b7c00e4c-00bf-43b6-be77-c0937b14d3f8'),('2025-05-06 +00'),('24'::int8),('75'::int8)) was aborted: ERROR: duplicate key value violates unique constraint "challenge_user_id_name_key"
Detail: Key (user_id, name)=(24, Khitomer b7c00e4c-00bf-43b6-be77-c0937b14d3f8) already exists. Call getNextException to see other errors in the batch.
2025-05-07T01:51:30.868Z ERROR 2502 --- [Pool-1-worker-5] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: duplicate key value violates unique constraint "challenge_user_id_name_key"
Detail: Key (user_id, name)=(24, Khitomer b7c00e4c-00bf-43b6-be77-c0937b14d3f8) already exists.
2025-05-07T01:51:30.870Z 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:30.874Z 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:30.876Z 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.154Z 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:31.187Z 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:31.190Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:31.191Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:31.194Z 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 where u1_0.email=?
2025-05-07T01:51:31.197Z DEBUG 2502 --- [Pool-1-worker-4] 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.201Z DEBUG 2502 --- [Pool-1-worker-4] 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:31.211Z 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.213Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:31.214Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:31.215Z 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.218Z 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.231Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select ss1_0.id,ss1_0.minutes_asleep,ss1_0.notes,ss1_0.minutes_awake,ss1_0.start_time,ss1_0.stop_time,ss1_0.zone_id from sleep_session ss1_0 join app_user u1_0 on u1_0.id=ss1_0.user_id where u1_0.public_id=? order by ss1_0.stop_time desc fetch first ? rows only
2025-05-07T01:51:31.237Z 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.241Z 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.243Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select ss1_0.id,ss1_0.minutes_asleep,ss1_0.notes,ss1_0.minutes_awake,ss1_0.start_time,ss1_0.stop_time,ss1_0.zone_id from sleep_session ss1_0 join app_user u1_0 on u1_0.id=ss1_0.user_id where u1_0.public_id=? order by ss1_0.stop_time desc fetch first ? rows only
2025-05-07T01:51:31.248Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select ss1_0.id,ss1_0.minutes_asleep,ss1_0.minutes_awake,ss1_0.notes,ss1_0.start_time,ss1_0.stop_time,ss1_0.user_id,ss1_0.zone_id from sleep_session ss1_0 join app_user u1_0 on u1_0.id=ss1_0.user_id where u1_0.public_id=? and ss1_0.id=?
2025-05-07T01:51:31.251Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : delete from sleep_session where id=?
2025-05-07T01:51:31.252Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select ss1_0.id,ss1_0.minutes_asleep,ss1_0.notes,ss1_0.minutes_awake,ss1_0.start_time,ss1_0.stop_time,ss1_0.zone_id from sleep_session ss1_0 join app_user u1_0 on u1_0.id=ss1_0.user_id where u1_0.public_id=? order by ss1_0.stop_time desc fetch first ? rows only
2025-05-07T01:51:31.510Z 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:31.512Z 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.514Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:31.515Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:31.517Z 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.518Z 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.521Z 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.523Z 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.525Z 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.527Z 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.531Z 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.532Z 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.536Z 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.539Z 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.544Z 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.546Z 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.548Z 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.550Z 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.553Z 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.556Z 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.559Z 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.561Z 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.563Z 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.565Z 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.566Z 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.568Z 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.571Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select ss1_0.minutes_asleep from sleep_session ss1_0 join app_user u1_0 on u1_0.id=ss1_0.user_id where u1_0.public_id=? and ss1_0.stop_time>=? and ss1_0.stop_time<=? order by ss1_0.stop_time
2025-05-07T01:51:31.573Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select ss1_0.minutes_asleep from sleep_session ss1_0 join app_user u1_0 on u1_0.id=ss1_0.user_id where u1_0.public_id=? and ss1_0.stop_time>=? and ss1_0.stop_time<=? order by ss1_0.stop_time
2025-05-07T01:51:31.574Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select ss1_0.minutes_asleep from sleep_session ss1_0 join app_user u1_0 on u1_0.id=ss1_0.user_id where u1_0.public_id=? and ss1_0.stop_time>=? and ss1_0.stop_time<=? order by ss1_0.stop_time
2025-05-07T01:51:31.828Z 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:31.830Z 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.910Z 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.918Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:31.919Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:31.923Z 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.928Z 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.942Z 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:31.942Z 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:31.945Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:31.946Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:31.949Z 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=?