Bug: Erster Antrag schlägt fehl.
Log von Heiko: log-nocolor.txt
Ich vermute daran dass es an der Async-Geschichte liegt: https://stackoverflow.com/questions/62560368/spring-boot-async-resultset-is-closed
Exception:
zustelldienst_1 | 2021-12-14 09:15:58.878 INFO 1 --- [nio-8080-exec-3] d.f.z.service.SubmissionService : Marked submission 7e28603d-9b46-4261-ac3b-27f8f4536202 as completed
zustelldienst_1 | Hibernate: select destinatio0_.id as id1_4_, destinatio0_.callback_id as callback8_4_, destinatio0_.destination_id as destinat2_4_, destinatio0_.encryption_kid as encrypti3_4_, destinatio0_.metadata_versions as metadata4_4_, destinatio0_.reply_channels as reply_ch5_4_, destinatio0_.status as status6_4_, destinatio0_.status_since as status_s7_4_ from destination destinatio0_ where destinatio0_.destination_id=?
zustelldienst_1 | Hibernate: insert into event_log (event, fk_submission, token, token_id, id) values (?, ?, ?, ?, ?)
zustelldienst_1 | Hibernate: update submission set callback_id=?, case_id=?, current_status=?, destination_id=?, encrypted_data=?, encrypted_metadata=?, service_type_id=?, state_changed_at=? where id=?
zustelldienst_1 | Hibernate: update event_log set event=?, fk_submission=?, token=?, token_id=? where id=?
zustelldienst_1 | Hibernate: select callbacken0_.id as id1_1_0_, callbacken0_.secret as secret2_1_0_, callbacken0_.url as url3_1_0_ from callback callbacken0_ where callbacken0_.id=?
zustelldienst_1 | 2021-12-14 09:15:59.035 WARN 1 --- [ task-3] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 55000
zustelldienst_1 | 2021-12-14 09:15:59.036 ERROR 1 --- [ task-3] o.h.engine.jdbc.spi.SqlExceptionHelper : This statement has been closed.
zustelldienst_1 | 2021-12-14 09:15:59.049 INFO 1 --- [ task-3] o.h.e.internal.DefaultLoadEventListener : HHH000327: Error performing load command
zustelldienst_1 |
zustelldienst_1 | org.hibernate.exception.GenericJDBCException: could not extract ResultSet
zustelldienst_1 | at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
zustelldienst_1 | at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
zustelldienst_1 | at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
zustelldienst_1 | at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
zustelldienst_1 | at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:390)
zustelldienst_1 | at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:163)
zustelldienst_1 | at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:104)
zustelldienst_1 | at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:285)
zustelldienst_1 | at org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:4437)
zustelldienst_1 | at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4427)
zustelldienst_1 | at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:576)
zustelldienst_1 | at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:544)
zustelldienst_1 | at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:208)
zustelldienst_1 | at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:103)
zustelldienst_1 | at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:74)
zustelldienst_1 | at org.hibernate.internal.SessionImpl$$Lambda$1392/0x0000000048128870.applyEventToListener(Unknown Source)
zustelldienst_1 | at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:110)
zustelldienst_1 | at org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1186)
zustelldienst_1 | at org.hibernate.internal.SessionImpl.immediateLoad(SessionImpl.java:1005)
zustelldienst_1 | at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:179)
zustelldienst_1 | at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:310)
zustelldienst_1 | at org.hibernate.proxy.pojo.bytebuddy.ByteBuddyInterceptor.intercept(ByteBuddyInterceptor.java:45)
zustelldienst_1 | at org.hibernate.proxy.ProxyConfiguration$InterceptorDispatcher.intercept(ProxyConfiguration.java:95)
zustelldienst_1 | at de.fiep.zustelldienst.callbacks.CallbackEntity$HibernateProxy$baN9uB3u.getSecret(Unknown Source)
zustelldienst_1 | at de.fiep.zustelldienst.callbacks.CallbackService.createCallbackHeaders(CallbackService.java:135)
zustelldienst_1 | at de.fiep.zustelldienst.callbacks.CallbackService.sendCallback(CallbackService.java:102)
zustelldienst_1 | at de.fiep.zustelldienst.callbacks.CallbackService.triggerCallbackForNewSubmissions(CallbackService.java:77)
zustelldienst_1 | at de.fiep.zustelldienst.callbacks.CallbackService.asyncCallbackForNewSubmissionsAndLogEvent(CallbackService.java:82)
zustelldienst_1 | at de.fiep.zustelldienst.callbacks.CallbackService$$FastClassBySpringCGLIB$$fbd23267.invoke(<generated>)
zustelldienst_1 | at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
zustelldienst_1 | at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
zustelldienst_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
zustelldienst_1 | at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
zustelldienst_1 | at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115)
zustelldienst_1 | at org.springframework.aop.interceptor.AsyncExecutionInterceptor$$Lambda$1427/0x00000000481428d0.call(Unknown Source)
zustelldienst_1 | at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
zustelldienst_1 | at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
zustelldienst_1 | at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
zustelldienst_1 | at java.base/java.lang.Thread.run(Unknown Source)
zustelldienst_1 | Caused by: org.postgresql.util.PSQLException: This statement has been closed.
zustelldienst_1 | at org.postgresql.jdbc.PgStatement.checkClosed(PgStatement.java:727)
zustelldienst_1 | at org.postgresql.jdbc.PgStatement.getMaxRows(PgStatement.java:528)
zustelldienst_1 | at org.postgresql.jdbc.PgStatement.createResultSet(PgStatement.java:164)
zustelldienst_1 | at org.postgresql.jdbc.PgStatement$StatementResultHandler.handleResultRows(PgStatement.java:215)
zustelldienst_1 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2238)
zustelldienst_1 | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:322)
zustelldienst_1 | at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481)
zustelldienst_1 | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401)
zustelldienst_1 | at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
zustelldienst_1 | at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
zustelldienst_1 | at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
zustelldienst_1 | at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
zustelldienst_1 | at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
zustelldienst_1 | ... 35 common frames omitted
zustelldienst_1 |
zustelldienst_1 | 2021-12-14 09:15:59.055 ERROR 1 --- [ task-3] .a.i.SimpleAsyncUncaughtExceptionHandler : Unexpected exception occurred invoking async method: public void de.fiep.zustelldienst.callbacks.CallbackService.asyncCallbackForNewSubmissionsAndLogEvent(de.fiep.zustelldienst.model.destination.Destination,de.fiep.zustelldienst.model.submission.Submission,de.fiep.zustelldienst.service.EventService)
zustelldienst_1 |
zustelldienst_1 | org.hibernate.exception.GenericJDBCException: could not extract ResultSet
zustelldienst_1 | at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
zustelldienst_1 | at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
zustelldienst_1 | at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
zustelldienst_1 | at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
zustelldienst_1 | at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:390)
zustelldienst_1 | at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:163)
zustelldienst_1 | at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:104)
zustelldienst_1 | at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:285)
zustelldienst_1 | at org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:4437)
zustelldienst_1 | at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4427)
zustelldienst_1 | at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:576)
zustelldienst_1 | at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:544)
zustelldienst_1 | at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:208)
zustelldienst_1 | at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:103)
zustelldienst_1 | at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:74)
zustelldienst_1 | at org.hibernate.internal.SessionImpl$$Lambda$1392/0x0000000048128870.applyEventToListener(Unknown Source)
zustelldienst_1 | at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:110)
zustelldienst_1 | at org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1186)
zustelldienst_1 | at org.hibernate.internal.SessionImpl.immediateLoad(SessionImpl.java:1005)
zustelldienst_1 | at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:179)
zustelldienst_1 | at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:310)
zustelldienst_1 | at org.hibernate.proxy.pojo.bytebuddy.ByteBuddyInterceptor.intercept(ByteBuddyInterceptor.java:45)
zustelldienst_1 | at org.hibernate.proxy.ProxyConfiguration$InterceptorDispatcher.intercept(ProxyConfiguration.java:95)
zustelldienst_1 | at de.fiep.zustelldienst.callbacks.CallbackEntity$HibernateProxy$baN9uB3u.getSecret(Unknown Source)
zustelldienst_1 | at de.fiep.zustelldienst.callbacks.CallbackService.createCallbackHeaders(CallbackService.java:135)
zustelldienst_1 | at de.fiep.zustelldienst.callbacks.CallbackService.sendCallback(CallbackService.java:102)
zustelldienst_1 | at de.fiep.zustelldienst.callbacks.CallbackService.triggerCallbackForNewSubmissions(CallbackService.java:77)
zustelldienst_1 | at de.fiep.zustelldienst.callbacks.CallbackService.asyncCallbackForNewSubmissionsAndLogEvent(CallbackService.java:82)
zustelldienst_1 | at de.fiep.zustelldienst.callbacks.CallbackService$$FastClassBySpringCGLIB$$fbd23267.invoke(<generated>)
zustelldienst_1 | at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
zustelldienst_1 | at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
zustelldienst_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
zustelldienst_1 | at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
zustelldienst_1 | at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115)
zustelldienst_1 | at org.springframework.aop.interceptor.AsyncExecutionInterceptor$$Lambda$1427/0x00000000481428d0.call(Unknown Source)
zustelldienst_1 | at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
zustelldienst_1 | at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
zustelldienst_1 | at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
zustelldienst_1 | at java.base/java.lang.Thread.run(Unknown Source)
zustelldienst_1 | Caused by: org.postgresql.util.PSQLException: This statement has been closed.
zustelldienst_1 | at org.postgresql.jdbc.PgStatement.checkClosed(PgStatement.java:727)
zustelldienst_1 | at org.postgresql.jdbc.PgStatement.getMaxRows(PgStatement.java:528)
zustelldienst_1 | at org.postgresql.jdbc.PgStatement.createResultSet(PgStatement.java:164)
zustelldienst_1 | at org.postgresql.jdbc.PgStatement$StatementResultHandler.handleResultRows(PgStatement.java:215)
zustelldienst_1 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2238)
zustelldienst_1 | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:322)
zustelldienst_1 | at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481)
zustelldienst_1 | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401)
zustelldienst_1 | at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
zustelldienst_1 | at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
zustelldienst_1 | at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
zustelldienst_1 | at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
zustelldienst_1 | at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
zustelldienst_1 | ... 35 common frames omitted
zustelldienst_1 | Edited by Jonas Gröger