2023-04-13 16:03:17.817 DEBUG 26236 --- [nio-8080-exec-1] o.j.s.OpenEntityManagerInViewInterceptor : Opening JPA EntityManager in OpenEntityManagerInViewInterceptor 2023-04-13 16:03:17.960 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Found thread-bound EntityManager [SessionImpl(1369535524)] for JPA transaction 2023-04-13 16:03:17.960 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Creating new transaction with name [de.usu.vmx.core.server.datafetcher.experimental.DemoDataCreator.populateDemoData]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT [747][success][0ms][conn=1] ProxyDataSource#getConnection() [748][success][0ms][conn=1] HikariProxyConnection#getAutoCommit() [749][success][0ms][conn=1] HikariProxyConnection#setAutoCommit(false) 2023-04-13 16:03:17.961 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Exposing JPA transaction as JDBC [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@69d6604f] 2023-04-13 16:03:17.972 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Found thread-bound EntityManager [SessionImpl(1369535524)] for JPA transaction 2023-04-13 16:03:17.973 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Participating in existing transaction [750][success][0ms][conn=1] HikariProxyConnection#prepareStatement("select nextval(usu_servicedesk_agent_sys_pk_seq)") [751][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() 2023-04-13 16:03:18.004 DEBUG 26236 --- [nio-8080-exec-1] d.u.v.core.config.logging.sql.SqlLogger : Connection:1, Time:0, Query: select nextval(usu_servicedesk_agent_sys_pk_seq) [752][success][1ms][conn=1] HikariProxyPreparedStatement#executeQuery() [753][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [754][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [755][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [756][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [757][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [758][success][0ms][conn=1] HikariProxyPreparedStatement#getMaxRows() [759][success][0ms][conn=1] HikariProxyPreparedStatement#getQueryTimeout() [760][success][0ms][conn=1] HikariProxyPreparedStatement#close() 2023-04-13 16:03:18.045 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Found thread-bound EntityManager [SessionImpl(1369535524)] for JPA transaction 2023-04-13 16:03:18.045 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Participating in existing transaction [761][success][0ms][conn=1] HikariProxyConnection#prepareStatement("select nextval(usu_servicedesk_agent_sys_pk_seq)") [762][success][1ms][conn=1] HikariProxyPreparedStatement#hashCode() 2023-04-13 16:03:18.073 DEBUG 26236 --- [nio-8080-exec-1] d.u.v.core.config.logging.sql.SqlLogger : Connection:1, Time:0, Query: select nextval(usu_servicedesk_agent_sys_pk_seq) [763][success][0ms][conn=1] HikariProxyPreparedStatement#executeQuery() [764][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [765][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [766][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [767][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [768][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [769][success][0ms][conn=1] HikariProxyPreparedStatement#getMaxRows() [770][success][0ms][conn=1] HikariProxyPreparedStatement#getQueryTimeout() [771][success][0ms][conn=1] HikariProxyPreparedStatement#close() 2023-04-13 16:03:18.074 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Found thread-bound EntityManager [SessionImpl(1369535524)] for JPA transaction 2023-04-13 16:03:18.074 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Participating in existing transaction [772][success][0ms][conn=1] HikariProxyConnection#prepareStatement("select nextval(usu_servicedesk_agent_sys_pk_seq)") [773][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() 2023-04-13 16:03:18.075 DEBUG 26236 --- [nio-8080-exec-1] d.u.v.core.config.logging.sql.SqlLogger : Connection:1, Time:1, Query: select nextval(usu_servicedesk_agent_sys_pk_seq) [774][success][1ms][conn=1] HikariProxyPreparedStatement#executeQuery() [775][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [776][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [777][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [778][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [779][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [780][success][0ms][conn=1] HikariProxyPreparedStatement#getMaxRows() [781][success][0ms][conn=1] HikariProxyPreparedStatement#getQueryTimeout() [782][success][0ms][conn=1] HikariProxyPreparedStatement#close() 2023-04-13 16:03:18.075 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Found thread-bound EntityManager [SessionImpl(1369535524)] for JPA transaction 2023-04-13 16:03:18.075 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Participating in existing transaction [783][success][0ms][conn=1] HikariProxyConnection#prepareStatement("select nextval(usu_servicedesk_agent_sys_pk_seq)") [784][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() 2023-04-13 16:03:18.076 DEBUG 26236 --- [nio-8080-exec-1] d.u.v.core.config.logging.sql.SqlLogger : Connection:1, Time:0, Query: select nextval(usu_servicedesk_agent_sys_pk_seq) [785][success][0ms][conn=1] HikariProxyPreparedStatement#executeQuery() [786][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [787][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [788][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [789][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [790][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [791][success][0ms][conn=1] HikariProxyPreparedStatement#getMaxRows() [792][success][0ms][conn=1] HikariProxyPreparedStatement#getQueryTimeout() [793][success][0ms][conn=1] HikariProxyPreparedStatement#close() 2023-04-13 16:03:18.077 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Found thread-bound EntityManager [SessionImpl(1369535524)] for JPA transaction 2023-04-13 16:03:18.077 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Participating in existing transaction [794][success][0ms][conn=1] HikariProxyConnection#prepareStatement("select nextval(usu_servicedesk_agent_sys_pk_seq)") [795][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() 2023-04-13 16:03:18.079 DEBUG 26236 --- [nio-8080-exec-1] d.u.v.core.config.logging.sql.SqlLogger : Connection:1, Time:0, Query: select nextval(usu_servicedesk_agent_sys_pk_seq) [796][success][0ms][conn=1] HikariProxyPreparedStatement#executeQuery() [797][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [798][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [799][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [800][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [801][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [802][success][0ms][conn=1] HikariProxyPreparedStatement#getMaxRows() [803][success][0ms][conn=1] HikariProxyPreparedStatement#getQueryTimeout() [804][success][0ms][conn=1] HikariProxyPreparedStatement#close() 2023-04-13 16:03:18.079 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Found thread-bound EntityManager [SessionImpl(1369535524)] for JPA transaction 2023-04-13 16:03:18.079 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Participating in existing transaction [805][success][0ms][conn=1] HikariProxyConnection#prepareStatement("select nextval(usu_servicedesk_agent_sys_pk_seq)") [806][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() 2023-04-13 16:03:18.082 DEBUG 26236 --- [nio-8080-exec-1] d.u.v.core.config.logging.sql.SqlLogger : Connection:1, Time:0, Query: select nextval(usu_servicedesk_agent_sys_pk_seq) [807][success][0ms][conn=1] HikariProxyPreparedStatement#executeQuery() [808][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [809][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [810][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [811][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [812][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [813][success][0ms][conn=1] HikariProxyPreparedStatement#getMaxRows() [814][success][0ms][conn=1] HikariProxyPreparedStatement#getQueryTimeout() [815][success][0ms][conn=1] HikariProxyPreparedStatement#close() 2023-04-13 16:03:18.083 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Found thread-bound EntityManager [SessionImpl(1369535524)] for JPA transaction 2023-04-13 16:03:18.083 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Participating in existing transaction [816][success][0ms][conn=1] HikariProxyConnection#prepareStatement("select nextval(usu_servicedesk_agent_sys_pk_seq)") [817][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() 2023-04-13 16:03:18.084 DEBUG 26236 --- [nio-8080-exec-1] d.u.v.core.config.logging.sql.SqlLogger : Connection:1, Time:0, Query: select nextval(usu_servicedesk_agent_sys_pk_seq) [818][success][1ms][conn=1] HikariProxyPreparedStatement#executeQuery() [819][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [820][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [821][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [822][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [823][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [824][success][0ms][conn=1] HikariProxyPreparedStatement#getMaxRows() [825][success][0ms][conn=1] HikariProxyPreparedStatement#getQueryTimeout() [826][success][0ms][conn=1] HikariProxyPreparedStatement#close() 2023-04-13 16:03:18.084 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Initiating transaction commit 2023-04-13 16:03:18.084 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Committing JPA transaction on EntityManager [SessionImpl(1369535524)] [827][success][0ms][conn=1] HikariProxyConnection#prepareStatement("insert into usu_servicedesk_agent (sys_change_count, sys_id, sys_user_changed, sys_user_created, sys_when_changed, sys_when_created, availability, email, first_name, last_name, phone, sys_user_id, title, sys_pk) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)") [828][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [829][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(1,0) [830][success][0ms][conn=1] HikariProxyPreparedStatement#setBytes(2,[B@7753ef37) [831][success][0ms][conn=1] HikariProxyPreparedStatement#setString(3,"Somebody DevMode") [832][success][0ms][conn=1] HikariProxyPreparedStatement#setString(4,"Somebody DevMode") [833][success][1ms][conn=1] HikariProxyPreparedStatement#setTimestamp(5,2023-04-13 16:03:18.0270854,java.util.GregorianCalendar[time=1681394598137,...) [834][success][0ms][conn=1] HikariProxyPreparedStatement#setTimestamp(6,2023-04-13 16:03:18.0270854,java.util.GregorianCalendar[time=1681394598138,...) [835][success][0ms][conn=1] HikariProxyPreparedStatement#setString(7,"OFFLINE") [836][success][0ms][conn=1] HikariProxyPreparedStatement#setString(8,"kenny.roggers@singers.com") [837][success][0ms][conn=1] HikariProxyPreparedStatement#setString(9,"Kenny") [838][success][0ms][conn=1] HikariProxyPreparedStatement#setString(10,"Roggers") [839][success][0ms][conn=1] HikariProxyPreparedStatement#setNull(11,12) [840][success][0ms][conn=1] HikariProxyPreparedStatement#setString(12,"b154a0d6-aea8-4b91-be89-d1f76e4e2d09") [841][success][0ms][conn=1] HikariProxyPreparedStatement#setString(13,"MR") [842][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(14,1022) [843][success][0ms][conn=1] HikariProxyPreparedStatement#addBatch() [844][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(1,0) [845][success][0ms][conn=1] HikariProxyPreparedStatement#setBytes(2,[B@6e4f891a) [846][success][0ms][conn=1] HikariProxyPreparedStatement#setString(3,"Somebody DevMode") [847][success][0ms][conn=1] HikariProxyPreparedStatement#setString(4,"Somebody DevMode") [848][success][0ms][conn=1] HikariProxyPreparedStatement#setTimestamp(5,2023-04-13 16:03:18.0735957,java.util.GregorianCalendar[time=1681394598140,...) [849][success][0ms][conn=1] HikariProxyPreparedStatement#setTimestamp(6,2023-04-13 16:03:18.0735957,java.util.GregorianCalendar[time=1681394598140,...) [850][success][0ms][conn=1] HikariProxyPreparedStatement#setString(7,"OFFLINE") [851][success][0ms][conn=1] HikariProxyPreparedStatement#setString(8,"mark.knopfler@singers.com") [852][success][0ms][conn=1] HikariProxyPreparedStatement#setString(9,"Mark") [853][success][0ms][conn=1] HikariProxyPreparedStatement#setString(10,"Knopfler") [854][success][0ms][conn=1] HikariProxyPreparedStatement#setString(11,"+493012345678") [855][success][0ms][conn=1] HikariProxyPreparedStatement#setString(12,"f0a5f4c5-70d1-4d42-9563-aabedf6c535b") [856][success][0ms][conn=1] HikariProxyPreparedStatement#setString(13,"MR") [857][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(14,1023) [858][success][0ms][conn=1] HikariProxyPreparedStatement#addBatch() [859][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(1,0) [860][success][0ms][conn=1] HikariProxyPreparedStatement#setBytes(2,[B@2b2f6622) [861][success][0ms][conn=1] HikariProxyPreparedStatement#setString(3,"Somebody DevMode") [862][success][0ms][conn=1] HikariProxyPreparedStatement#setString(4,"Somebody DevMode") [863][success][0ms][conn=1] HikariProxyPreparedStatement#setTimestamp(5,2023-04-13 16:03:18.0755702,java.util.GregorianCalendar[time=1681394598141,...) [864][success][0ms][conn=1] HikariProxyPreparedStatement#setTimestamp(6,2023-04-13 16:03:18.0755702,java.util.GregorianCalendar[time=1681394598141,...) [865][success][0ms][conn=1] HikariProxyPreparedStatement#setString(7,"OFFLINE") [866][success][0ms][conn=1] HikariProxyPreparedStatement#setString(8,"kurt.cobain@singers.com") [867][success][0ms][conn=1] HikariProxyPreparedStatement#setString(9,"Kurt") [868][success][0ms][conn=1] HikariProxyPreparedStatement#setString(10,"Cobain") [869][success][0ms][conn=1] HikariProxyPreparedStatement#setString(11,"+493012345678") [870][success][0ms][conn=1] HikariProxyPreparedStatement#setString(12,"3e36215a-307e-4e30-b6a2-bfbaf4d8b302") [871][success][0ms][conn=1] HikariProxyPreparedStatement#setString(13,"MR") [872][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(14,1024) [873][success][0ms][conn=1] HikariProxyPreparedStatement#addBatch() [874][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(1,0) [875][success][0ms][conn=1] HikariProxyPreparedStatement#setBytes(2,[B@b9cbf1a) [876][success][0ms][conn=1] HikariProxyPreparedStatement#setString(3,"Somebody DevMode") [877][success][0ms][conn=1] HikariProxyPreparedStatement#setString(4,"Somebody DevMode") [878][success][0ms][conn=1] HikariProxyPreparedStatement#setTimestamp(5,2023-04-13 16:03:18.0775789,java.util.GregorianCalendar[time=1681394598141,...) [879][success][0ms][conn=1] HikariProxyPreparedStatement#setTimestamp(6,2023-04-13 16:03:18.0775789,java.util.GregorianCalendar[time=1681394598141,...) [880][success][0ms][conn=1] HikariProxyPreparedStatement#setString(7,"OFFLINE") [881][success][0ms][conn=1] HikariProxyPreparedStatement#setString(8,"alanis.morissette@singers.com") [882][success][0ms][conn=1] HikariProxyPreparedStatement#setString(9,"Alanis") [883][success][0ms][conn=1] HikariProxyPreparedStatement#setString(10,"Morissette") [884][success][0ms][conn=1] HikariProxyPreparedStatement#setString(11,"+493012345678") [885][success][0ms][conn=1] HikariProxyPreparedStatement#setString(12,"f7d7d282-92e0-4ed9-bc9e-f7bf53cd8eb6") [886][success][0ms][conn=1] HikariProxyPreparedStatement#setString(13,"MR") [887][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(14,1025) [888][success][0ms][conn=1] HikariProxyPreparedStatement#addBatch() [889][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(1,0) [890][success][0ms][conn=1] HikariProxyPreparedStatement#setBytes(2,[B@743c87a4) [891][success][0ms][conn=1] HikariProxyPreparedStatement#setString(3,"Somebody DevMode") [892][success][0ms][conn=1] HikariProxyPreparedStatement#setString(4,"Somebody DevMode") [893][success][0ms][conn=1] HikariProxyPreparedStatement#setTimestamp(5,2023-04-13 16:03:18.0795689,java.util.GregorianCalendar[time=1681394598142,...) [894][success][0ms][conn=1] HikariProxyPreparedStatement#setTimestamp(6,2023-04-13 16:03:18.0795689,java.util.GregorianCalendar[time=1681394598142,...) [895][success][0ms][conn=1] HikariProxyPreparedStatement#setString(7,"OFFLINE") [896][success][0ms][conn=1] HikariProxyPreparedStatement#setString(8,"dolly.parton@singers.com") [897][success][0ms][conn=1] HikariProxyPreparedStatement#setString(9,"Dolly") [898][success][0ms][conn=1] HikariProxyPreparedStatement#setString(10,"Parton") [899][success][0ms][conn=1] HikariProxyPreparedStatement#setString(11,"+493012345678") [900][success][0ms][conn=1] HikariProxyPreparedStatement#setString(12,"47392abd-861a-414b-bc32-87b0e5272e6d") [901][success][0ms][conn=1] HikariProxyPreparedStatement#setString(13,"MS") [902][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(14,1026) [903][success][0ms][conn=1] HikariProxyPreparedStatement#addBatch() [904][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(1,0) [905][success][0ms][conn=1] HikariProxyPreparedStatement#setBytes(2,[B@5ea19412) [906][success][0ms][conn=1] HikariProxyPreparedStatement#setString(3,"Somebody DevMode") [907][success][0ms][conn=1] HikariProxyPreparedStatement#setString(4,"Somebody DevMode") [908][success][0ms][conn=1] HikariProxyPreparedStatement#setTimestamp(5,2023-04-13 16:03:18.0825704,java.util.GregorianCalendar[time=1681394598142,...) [909][success][0ms][conn=1] HikariProxyPreparedStatement#setTimestamp(6,2023-04-13 16:03:18.0825704,java.util.GregorianCalendar[time=1681394598142,...) [910][success][0ms][conn=1] HikariProxyPreparedStatement#setString(7,"OFFLINE") [911][success][0ms][conn=1] HikariProxyPreparedStatement#setString(8,"waldemar.matuska@singers.com") [912][success][0ms][conn=1] HikariProxyPreparedStatement#setString(9,"Waldemar") [913][success][0ms][conn=1] HikariProxyPreparedStatement#setString(10,"Matuška") [914][success][0ms][conn=1] HikariProxyPreparedStatement#setString(11,"+420582319111") [915][success][0ms][conn=1] HikariProxyPreparedStatement#setString(12,"22f75839-c62c-46cd-bc2b-ff8403498774") [916][success][0ms][conn=1] HikariProxyPreparedStatement#setString(13,"MR") [917][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(14,1027) [918][success][0ms][conn=1] HikariProxyPreparedStatement#addBatch() [919][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(1,0) [920][success][0ms][conn=1] HikariProxyPreparedStatement#setBytes(2,[B@53d6b789) [921][success][0ms][conn=1] HikariProxyPreparedStatement#setString(3,"Somebody DevMode") [922][success][0ms][conn=1] HikariProxyPreparedStatement#setString(4,"Somebody DevMode") [923][success][0ms][conn=1] HikariProxyPreparedStatement#setTimestamp(5,2023-04-13 16:03:18.0846134,java.util.GregorianCalendar[time=1681394598143,...) [924][success][0ms][conn=1] HikariProxyPreparedStatement#setTimestamp(6,2023-04-13 16:03:18.0846134,java.util.GregorianCalendar[time=1681394598143,...) [925][success][0ms][conn=1] HikariProxyPreparedStatement#setString(7,"OFFLINE") [926][success][0ms][conn=1] HikariProxyPreparedStatement#setString(8,"yvonne.prenosilova@singers.com") [927][success][0ms][conn=1] HikariProxyPreparedStatement#setString(9,"Yvonne") [928][success][0ms][conn=1] HikariProxyPreparedStatement#setString(10,"Prenosilová") [929][success][0ms][conn=1] HikariProxyPreparedStatement#setString(11,"+493012345678") [930][success][0ms][conn=1] HikariProxyPreparedStatement#setString(12,"570e6127-6302-4370-8743-2b86bd212be3") [931][success][0ms][conn=1] HikariProxyPreparedStatement#setString(13,"MS") [932][success][0ms][conn=1] HikariProxyPreparedStatement#setInt(14,1028) [933][success][0ms][conn=1] HikariProxyPreparedStatement#addBatch() 2023-04-13 16:03:18.151 WARN 26236 --- [nio-8080-exec-1] o.m.jdbc.message.server.ErrorPacket : Error: 1062-23000: Duplicate entry 'b154a0d6-aea8-4b91-be89-d1f76e4e2d09' for key 'sys_user_id' ----------------------- failed SQL: --------------------------------------- 2023-04-13 16:03:18.155 ERROR 26236 --- [nio-8080-exec-1] d.u.v.core.config.logging.sql.SqlLogger : Connection:1, Time:7, Query: insert into usu_servicedesk_agent (sys_change_count, sys_id, sys_user_changed, sys_user_created, sys_when_changed, sys_when_created, availability, email, first_name, last_name, phone, sys_user_id, title, sys_pk) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), Params:[(0,X'2B08A219B2A24DE78A0C2477DAD20EFF' /* 2b08a219-b2a2-4de7-8a0c-2477dad20eff */,'Somebody DevMode','Somebody DevMode',TIMESTAMP '2023-04-13 16:03:18.0270854',TIMESTAMP '2023-04-13 16:03:18.0270854','OFFLINE','kenny.roggers@singers.com','Kenny','Roggers',NULL,'b154a0d6-aea8-4b91-be89-d1f76e4e2d09','MR',1022),(0,X'C4FA2F916160499697F82650629FBD66' /* c4fa2f91-6160-4996-97f8-2650629fbd66 */,'Somebody DevMode','Somebody DevMode',TIMESTAMP '2023-04-13 16:03:18.0735957',TIMESTAMP '2023-04-13 16:03:18.0735957','OFFLINE','mark.knopfler@singers.com','Mark','Knopfler','+493012345678','f0a5f4c5-70d1-4d42-9563-aabedf6c535b','MR',1023),(0,X'929BBCA2C5B94B5F9091ABFAFFC76C3A' /* 929bbca2-c5b9-4b5f-9091-abfaffc76c3a */,'Somebody DevMode','Somebody DevMode',TIMESTAMP '2023-04-13 16:03:18.0755702',TIMESTAMP '2023-04-13 16:03:18.0755702','OFFLINE','kurt.cobain@singers.com','Kurt','Cobain','+493012345678','3e36215a-307e-4e30-b6a2-bfbaf4d8b302','MR',1024),(0,X'D43ADD0275004A7DBFE92A3566D80729' /* d43add02-7500-4a7d-bfe9-2a3566d80729 */,'Somebody DevMode','Somebody DevMode',TIMESTAMP '2023-04-13 16:03:18.0775789',TIMESTAMP '2023-04-13 16:03:18.0775789','OFFLINE','alanis.morissette@singers.com','Alanis','Morissette','+493012345678','f7d7d282-92e0-4ed9-bc9e-f7bf53cd8eb6','MR',1025),(0,X'EF71438807E84E489C866E42C0297E5A' /* ef714388-07e8-4e48-9c86-6e42c0297e5a */,'Somebody DevMode','Somebody DevMode',TIMESTAMP '2023-04-13 16:03:18.0795689',TIMESTAMP '2023-04-13 16:03:18.0795689','OFFLINE','dolly.parton@singers.com','Dolly','Parton','+493012345678','47392abd-861a-414b-bc32-87b0e5272e6d','MS',1026),(0,X'850F24B6FEAB4D128F325A5340606B1A' /* 850f24b6-feab-4d12-8f32-5a5340606b1a */,'Somebody DevMode','Somebody DevMode',TIMESTAMP '2023-04-13 16:03:18.0825704',TIMESTAMP '2023-04-13 16:03:18.0825704','OFFLINE','waldemar.matuska@singers.com','Waldemar','Matuška','+420582319111','22f75839-c62c-46cd-bc2b-ff8403498774','MR',1027),(0,X'0CFE4179CB8E4D41B993F6AF57299F7B' /* 0cfe4179-cb8e-4d41-b993-f6af57299f7b */,'Somebody DevMode','Somebody DevMode',TIMESTAMP '2023-04-13 16:03:18.0846134',TIMESTAMP '2023-04-13 16:03:18.0846134','OFFLINE','yvonne.prenosilova@singers.com','Yvonne','Prenosilová','+493012345678','570e6127-6302-4370-8743-2b86bd212be3','MS',1028)] [934][fail][11ms][conn=1][error=(conn=1176) Duplicate entry 'b154a0d6-aea8-4b91-be89-d1f76e4e2d09' for key 'sys_user_id'] HikariProxyPreparedStatement#executeBatch() 2023-04-13 16:03:18.155 INFO 26236 --- [nio-8080-exec-1] o.h.e.j.b.internal.AbstractBatchImpl : HHH000010: On release of batch it still contained JDBC statements [935][success][0ms][conn=1] HikariProxyPreparedStatement#isClosed() [936][success][1ms][conn=1] HikariProxyPreparedStatement#clearBatch() [937][success][0ms][conn=1] HikariProxyPreparedStatement#hashCode() [938][success][0ms][conn=1] HikariProxyPreparedStatement#getMaxRows() [939][success][0ms][conn=1] HikariProxyPreparedStatement#getQueryTimeout() [940][success][1ms][conn=1] HikariProxyPreparedStatement#close() 2023-04-13 16:03:18.157 ERROR 26236 --- [nio-8080-exec-1] o.h.e.jdbc.batch.internal.BatchingBatch : HHH000315: Exception executing batch [java.sql.BatchUpdateException: (conn=1176) Duplicate entry 'b154a0d6-aea8-4b91-be89-d1f76e4e2d09' for key 'sys_user_id'], SQL: insert into usu_servicedesk_agent (sys_change_count, sys_id, sys_user_changed, sys_user_created, sys_when_changed, sys_when_created, availability, email, first_name, last_name, phone, sys_user_id, title, sys_pk) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 2023-04-13 16:03:18.158 WARN 26236 --- [nio-8080-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 1062, SQLState: 23000 2023-04-13 16:03:18.158 ERROR 26236 --- [nio-8080-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper : (conn=1176) Duplicate entry 'b154a0d6-aea8-4b91-be89-d1f76e4e2d09' for key 'sys_user_id' 2023-04-13 16:03:18.162 WARN 26236 --- [nio-8080-exec-1] o.m.jdbc.message.server.ErrorPacket : Error: 1062-23000: Duplicate entry 'f0a5f4c5-70d1-4d42-9563-aabedf6c535b' for key 'sys_user_id' [941][fail][2ms][conn=1][error=(conn=1176) Duplicate entry 'f0a5f4c5-70d1-4d42-9563-aabedf6c535b' for key 'sys_user_id'] HikariProxyConnection#rollback() 2023-04-13 16:03:18.171 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Initiating transaction rollback after commit exception org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into usu_servicedesk_agent (sys_change_count, sys_id, sys_user_changed, sys_user_created, sys_when_changed, sys_when_created, availability, email, first_name, last_name, phone, sys_user_id, title, sys_pk) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [sys_user_id]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute batch at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:276) ~[spring-orm-5.3.25.jar:5.3.25] at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:233) ~[spring-orm-5.3.25.jar:5.3.25] at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:566) ~[spring-orm-5.3.25.jar:5.3.25] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743) ~[spring-tx-5.3.25.jar:5.3.25] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711) ~[spring-tx-5.3.25.jar:5.3.25] at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:654) ~[spring-tx-5.3.25.jar:5.3.25] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:407) ~[spring-tx-5.3.25.jar:5.3.25] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.25.jar:5.3.25] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.25.jar:5.3.25] at de.usu.vmx.core.server.datafetcher.experimental.DemoDataCreator$$EnhancerBySpringCGLIB$$6f8f02db.populateDemoData() ~[classes/:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[na:na] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na] at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na] at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:282) ~[spring-core-5.3.25.jar:5.3.25] at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:266) ~[spring-core-5.3.25.jar:5.3.25] at com.netflix.graphql.dgs.internal.DataFetcherInvoker.get(DataFetcherInvoker.kt:53) ~[graphql-dgs-5.5.1.jar:5.5.1] at graphql.schema.DataFetcherFactories.lambda$wrapDataFetcher$2(DataFetcherFactories.java:37) ~[graphql-java-19.2.jar:na] at graphql.execution.instrumentation.dataloader.DataLoaderDispatcherInstrumentation.lambda$instrumentDataFetcher$0(DataLoaderDispatcherInstrumentation.java:86) ~[graphql-java-19.2.jar:na] at graphql.execution.ExecutionStrategy.fetchField(ExecutionStrategy.java:282) ~[graphql-java-19.2.jar:na] at graphql.execution.ExecutionStrategy.resolveFieldWithInfo(ExecutionStrategy.java:211) ~[graphql-java-19.2.jar:na] at graphql.execution.ExecutionStrategy.resolveField(ExecutionStrategy.java:183) ~[graphql-java-19.2.jar:na] at graphql.execution.AsyncSerialExecutionStrategy.lambda$execute$1(AsyncSerialExecutionStrategy.java:47) ~[graphql-java-19.2.jar:na] at graphql.execution.Async.eachSequentiallyImpl(Async.java:191) ~[graphql-java-19.2.jar:na] at graphql.execution.Async.eachSequentially(Async.java:180) ~[graphql-java-19.2.jar:na] at graphql.execution.AsyncSerialExecutionStrategy.execute(AsyncSerialExecutionStrategy.java:42) ~[graphql-java-19.2.jar:na] at graphql.execution.Execution.executeOperation(Execution.java:159) ~[graphql-java-19.2.jar:na] at graphql.execution.Execution.execute(Execution.java:105) ~[graphql-java-19.2.jar:na] at graphql.GraphQL.execute(GraphQL.java:645) ~[graphql-java-19.2.jar:na] at graphql.GraphQL.lambda$parseValidateAndExecute$11(GraphQL.java:564) ~[graphql-java-19.2.jar:na] at java.base/java.util.concurrent.CompletableFuture.uniComposeStage(CompletableFuture.java:1187) ~[na:na] at java.base/java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:2309) ~[na:na] at graphql.GraphQL.parseValidateAndExecute(GraphQL.java:559) ~[graphql-java-19.2.jar:na] at graphql.GraphQL.executeAsync(GraphQL.java:527) ~[graphql-java-19.2.jar:na] at com.netflix.graphql.dgs.internal.BaseDgsQueryExecutor.baseExecute(BaseDgsQueryExecutor.kt:127) ~[graphql-dgs-5.5.1.jar:5.5.1] at com.netflix.graphql.dgs.internal.DefaultDgsQueryExecutor.execute(DefaultDgsQueryExecutor.kt:79) ~[graphql-dgs-5.5.1.jar:5.5.1] at com.netflix.graphql.dgs.mvc.DgsRestController$graphql$executionResult$1.invoke(DgsRestController.kt:206) ~[graphql-dgs-spring-webmvc-5.5.1.jar:5.5.1] at com.netflix.graphql.dgs.mvc.DgsRestController$graphql$executionResult$1.invoke(DgsRestController.kt:204) ~[graphql-dgs-spring-webmvc-5.5.1.jar:5.5.1] at com.netflix.graphql.dgs.internal.utils.TimeTracer.logTime(TimeTracer.kt:24) ~[graphql-dgs-5.5.1.jar:5.5.1] at com.netflix.graphql.dgs.mvc.DgsRestController.graphql(DgsRestController.kt:204) ~[graphql-dgs-spring-webmvc-5.5.1.jar:5.5.1] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[na:na] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na] at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-5.3.25.jar:5.3.25] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) ~[spring-web-5.3.25.jar:5.3.25] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) ~[spring-webmvc-5.3.25.jar:5.3.25] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.3.25.jar:5.3.25] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.25.jar:5.3.25] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.25.jar:5.3.25] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071) ~[spring-webmvc-5.3.25.jar:5.3.25] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964) ~[spring-webmvc-5.3.25.jar:5.3.25] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.3.25.jar:5.3.25] at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) ~[spring-webmvc-5.3.25.jar:5.3.25] at javax.servlet.http.HttpServlet.service(HttpServlet.java:696) ~[tomcat-embed-core-9.0.71.jar:4.0.FR] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.25.jar:5.3.25] at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) ~[tomcat-embed-core-9.0.71.jar:4.0.FR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.71.jar:9.0.71] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at de.usu.vmx.core.config.security.DevModeAuthenticationFilter.doFilter(DevModeAuthenticationFilter.kt:50) ~[classes/:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.zalando.logbook.servlet.LogbookFilter.doFilter(LogbookFilter.java:74) ~[logbook-servlet-2.14.0.jar:na] at org.zalando.logbook.servlet.HttpFilter.doFilter(HttpFilter.java:31) ~[logbook-servlet-2.14.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:337) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:109) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.oauth2.server.resource.web.BearerTokenAuthenticationFilter.doFilterInternal(BearerTokenAuthenticationFilter.java:125) ~[spring-security-oauth2-resource-server-5.7.7.jar:5.7.7] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.25.jar:5.3.25] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91) ~[spring-web-5.3.25.jar:5.3.25] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.25.jar:5.3.25] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.25.jar:5.3.25] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:112) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:82) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.25.jar:5.3.25] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.session.DisableEncodeUrlFilter.doFilterInternal(DisableEncodeUrlFilter.java:42) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.25.jar:5.3.25] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:221) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:186) ~[spring-security-web-5.7.7.jar:5.7.7] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) ~[spring-web-5.3.25.jar:5.3.25] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) ~[spring-web-5.3.25.jar:5.3.25] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.3.25.jar:5.3.25] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.25.jar:5.3.25] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.3.25.jar:5.3.25] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.25.jar:5.3.25] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.zalando.logbook.servlet.LogbookFilter.doFilter(LogbookFilter.java:74) ~[logbook-servlet-2.14.0.jar:na] at org.zalando.logbook.servlet.SecureLogbookFilter.doFilter(SecureLogbookFilter.java:32) ~[logbook-servlet-2.14.0.jar:na] at org.zalando.logbook.servlet.HttpFilter.doFilter(HttpFilter.java:31) ~[logbook-servlet-2.14.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96) ~[spring-boot-actuator-2.7.9.jar:2.7.9] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.25.jar:5.3.25] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.3.25.jar:5.3.25] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.25.jar:5.3.25] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.71.jar:9.0.71] at java.base/java.lang.Thread.run(Thread.java:833) ~[na:na] Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:109) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:135) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:110) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:153) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:198) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:633) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:721) ~[na:na] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:489) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3303) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2438) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:449) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:562) ~[spring-orm-5.3.25.jar:5.3.25] ... 149 common frames omitted Caused by: java.sql.BatchUpdateException: (conn=1176) Duplicate entry 'b154a0d6-aea8-4b91-be89-d1f76e4e2d09' for key 'sys_user_id' at org.mariadb.jdbc.export.ExceptionFactory.createBatchUpdate(ExceptionFactory.java:181) ~[mariadb-java-client-3.0.10.jar:na] at org.mariadb.jdbc.ClientPreparedStatement.executeBatchBulk(ClientPreparedStatement.java:179) ~[mariadb-java-client-3.0.10.jar:na] at org.mariadb.jdbc.ClientPreparedStatement.executeInternalPreparedBatch(ClientPreparedStatement.java:115) ~[mariadb-java-client-3.0.10.jar:na] at org.mariadb.jdbc.ClientPreparedStatement.executeBatch(ClientPreparedStatement.java:466) ~[mariadb-java-client-3.0.10.jar:na] at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) ~[HikariCP-4.0.3.jar:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[na:na] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na] at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na] at net.ttddyy.dsproxy.proxy.StatementProxyLogic.performQueryExecutionListener(StatementProxyLogic.java:316) ~[datasource-proxy-1.7.jar:na] at net.ttddyy.dsproxy.proxy.StatementProxyLogic.access$700(StatementProxyLogic.java:37) ~[datasource-proxy-1.7.jar:na] at net.ttddyy.dsproxy.proxy.StatementProxyLogic$1.execute(StatementProxyLogic.java:123) ~[datasource-proxy-1.7.jar:na] at net.ttddyy.dsproxy.listener.MethodExecutionListenerUtils.invoke(MethodExecutionListenerUtils.java:42) ~[datasource-proxy-1.7.jar:na] at net.ttddyy.dsproxy.proxy.StatementProxyLogic.invoke(StatementProxyLogic.java:120) ~[datasource-proxy-1.7.jar:na] at net.ttddyy.dsproxy.proxy.jdk.PreparedStatementInvocationHandler.invoke(PreparedStatementInvocationHandler.java:37) ~[datasource-proxy-1.7.jar:na] at jdk.proxy2/jdk.proxy2.$Proxy197.executeBatch(Unknown Source) ~[na:na] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:125) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final] ... 169 common frames omitted Caused by: java.sql.BatchUpdateException: (conn=1176) Duplicate entry 'b154a0d6-aea8-4b91-be89-d1f76e4e2d09' for key 'sys_user_id' at org.mariadb.jdbc.export.ExceptionFactory.createBatchUpdate(ExceptionFactory.java:215) ~[mariadb-java-client-3.0.10.jar:na] at org.mariadb.jdbc.client.impl.StandardClient.executePipeline(StandardClient.java:624) ~[mariadb-java-client-3.0.10.jar:na] at org.mariadb.jdbc.ClientPreparedStatement.executeBatchBulk(ClientPreparedStatement.java:148) ~[mariadb-java-client-3.0.10.jar:na] ... 185 common frames omitted Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn=1176) Duplicate entry 'b154a0d6-aea8-4b91-be89-d1f76e4e2d09' for key 'sys_user_id' at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:290) ~[mariadb-java-client-3.0.10.jar:na] at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:370) ~[mariadb-java-client-3.0.10.jar:na] at org.mariadb.jdbc.message.ClientMessage.readPacket(ClientMessage.java:137) ~[mariadb-java-client-3.0.10.jar:na] at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:840) ~[mariadb-java-client-3.0.10.jar:na] at org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:779) ~[mariadb-java-client-3.0.10.jar:na] at org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:698) ~[mariadb-java-client-3.0.10.jar:na] at org.mariadb.jdbc.client.impl.StandardClient.executePipeline(StandardClient.java:575) ~[mariadb-java-client-3.0.10.jar:na] ... 186 common frames omitted 2023-04-13 16:03:18.172 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Rolling back JPA transaction on EntityManager [SessionImpl(1369535524)] 2023-04-13 16:03:18.173 DEBUG 26236 --- [nio-8080-exec-1] o.s.orm.jpa.JpaTransactionManager : Not closing pre-bound JPA EntityManager after transaction