Error loading MappingParametersSnapshot (Kiwi HF2)

2021-11-22T16:19:59.891-05:00 WARNING: Exception thrown during asynchronous load 2021-11-22T16:19:59.891-05:00 WARNING: Exception thrown during asynchronous load 2021-11-22T16:19:59.891-05:00 java.util.concurrent.CompletionException: org.folio.services.exceptions.CacheLoadingException: Error loading MappingParametersSnapshot by jobExecutionId: '4a13fa36-ce19-48ed-a66b-f9d2bd5ce1fd', status code: 500, response message: Internal Server Error, Please contact System Administrator or try again021-11-22T16:19:59.891-05:00 at java.base/java.util.concurrent.CompletableFuture.encodeRelay(CompletableFuture.java:367)2021-11-22T16:19:59.891-05:00 at java.base/java.util.concurrent.CompletableFuture.completeRelay(CompletableFuture.java:376)2021-11-22T16:19:59.891-05:00 at java.base/java.util.concurrent.CompletableFuture$UniCompose.tryFire(CompletableFuture.java:1074)2021-11-22T16:19:59.891-05:00 at java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)2021-11-22T16:19:59.891-05:00 at java.base/java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:2073)2021-11-22T16:19:59.891-05:00 at io.vertx.core.Future.lambda$toCompletionStage$2(Future.java:360)2021-11-22T16:19:59.891-05:00 at io.vertx.core.impl.future.FutureImpl$3.onSuccess(FutureImpl.java:124)2021-11-22T16:19:59.891-05:00 at io.vertx.core.impl.future.FutureBase.emitSuccess(FutureBase.java:62)2021-11-22T16:19:59.891-05:00 at io.vertx.core.impl.future.FutureImpl.tryComplete(FutureImpl.java:179)2021-11-22T16:19:59.891-05:00 at io.vertx.core.impl.future.PromiseImpl.tryComplete(PromiseImpl.java:23)2021-11-22T16:19:59.891-05:00 at io.vertx.core.Promise.complete(Promise.java:66)2021-11-22T16:19:59.891-05:00 at org.folio.dataimport.util.RestUtil.lambda$handleResponse$0(RestUtil.java:182)2021-11-22T16:19:59.891-05:00 at io.vertx.ext.web.client.impl.HttpContext.handleDispatchResponse(HttpContext.java:371)2021-11-22T16:19:59.891-05:00 at io.vertx.ext.web.client.impl.HttpContext.execute(HttpContext.java:358)2021-11-22T16:19:59.891-05:00 at io.vertx.ext.web.client.impl.HttpContext.next(HttpContext.java:336)2021-11-22T16:19:59.891-05:00 at io.vertx.ext.web.client.impl.HttpContext.fire(HttpContext.java:303)2021-11-22T16:19:59.891-05:00 at io.vertx.ext.web.client.impl.HttpContext.dispatchResponse(HttpContext.java:265)2021-11-22T16:19:59.891-05:00 at io.vertx.ext.web.client.impl.HttpContext.lambda$null$8(HttpContext.java:528)2021-11-22T16:19:59.891-05:00 at io.vertx.core.impl.AbstractContext.dispatch(AbstractContext.java:96)2021-11-22T16:19:59.891-05:00 at io.vertx.core.impl.WorkerContext.lambda$run$1(WorkerContext.java:82)2021-11-22T16:19:59.891-05:00 at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76)2021-11-22T16:19:59.891-05:00 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)2021-11-22T16:19:59.891-05:00 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)2021-11-22T16:19:59.891-05:00 at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)2021-11-22T16:19:59.891-05:00 at java.base/java.lang.Thread.run(Thread.java:829)2021-11-22T16:19:59.891-05:00 Caused by: org.folio.services.exceptions.CacheLoadingException: Error loading MappingParametersSnapshot by jobExecutionId: '4a13fa36-ce19-48ed-a66b-f9d2bd5ce1fd', status code: 500, response message: Internal Server Error, Please contact System Administrator or try again2021-11-22T16:19:59.891-05:00 at org.folio.services.caches.MappingParametersSnapshotCache.lambda$3(MappingParametersSnapshotCache.java:66)2021-11-22T16:19:59.891-05:00 at java.base/java.util.concurrent.CompletableFuture$UniCompose.tryFire(CompletableFuture.java:1072)2021-11-22T16:19:59.891-05:00 ... 22 more2021-11-22T16:19:59.892-05:00 21:19:59.892 [vert.x-worker-thread-17] ERROR ocessingEventHandler [1044351405eqId] Failed to handle event DI_INVENTORY_INSTANCE_CREATED_READY_FOR_POST_PROCESSING2021-11-22T16:19:59.892-05:00 java.util.concurrent.CompletionException: org.folio.services.exceptions.CacheLoadingException: Error loading MappingParametersSnapshot by jobExecutionId: '4a13fa36-ce19-48ed-a66b-f9d2bd5ce1fd', status code: 500, response message: Internal Server Error, Please contact System Administrator or try again2021-11-22T16:19:59.892-05:00 at java.util.concurrent.CompletableFuture.encodeRelay(CompletableFuture.java:367) ~[?:?]2021-11-22T16:19:59.892-05:00 at java.util.concurrent.CompletableFuture.completeRelay(CompletableFuture.java:376) ~[?:?]2021-11-22T16:19:59.892-05:00 at java.util.concurrent.CompletableFuture$UniCompose.tryFire(CompletableFuture.java:1074) ~[?:?]2021-11-22T16:19:59.892-05:00 at java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506) ~[?:?]2021-11-22T16:19:59.892-05:00 at java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:2073) ~[?:?]2021-11-22T16:19:59.892-05:00 at io.vertx.core.Future.lambda$toCompletionStage$2(Future.java:360) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.core.impl.future.FutureImpl$3.onSuccess(FutureImpl.java:124) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.core.impl.future.FutureBase.emitSuccess(FutureBase.java:62) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.core.impl.future.FutureImpl.tryComplete(FutureImpl.java:179) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.core.impl.future.PromiseImpl.tryComplete(PromiseImpl.java:23) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.core.Promise.complete(Promise.java:66) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at org.folio.dataimport.util.RestUtil.lambda$handleResponse$0(RestUtil.java:182) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.ext.web.client.impl.HttpContext.handleDispatchResponse(HttpContext.java:371) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.ext.web.client.impl.HttpContext.execute(HttpContext.java:358) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.ext.web.client.impl.HttpContext.next(HttpContext.java:336) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.ext.web.client.impl.HttpContext.fire(HttpContext.java:303) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.ext.web.client.impl.HttpContext.dispatchResponse(HttpContext.java:265) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.ext.web.client.impl.HttpContext.lambda$null$8(HttpContext.java:528) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.core.impl.AbstractContext.dispatch(AbstractContext.java:96) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.core.impl.WorkerContext.lambda$run$1(WorkerContext.java:82) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]2021-11-22T16:19:59.892-05:00 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]2021-11-22T16:19:59.892-05:00 at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?]2021-11-22T16:19:59.892-05:00 at java.lang.Thread.run(Thread.java:829) [?:?]2021-11-22T16:19:59.892-05:00 Caused by: org.folio.services.exceptions.CacheLoadingException: Error loading MappingParametersSnapshot by jobExecutionId: '4a13fa36-ce19-48ed-a66b-f9d2bd5ce1fd', status code: 500, response message: Internal Server Error, Please contact System Administrator or try again2021-11-22T16:19:59.892-05:00 at org.folio.services.caches.MappingParametersSnapshotCache.lambda$3(MappingParametersSnapshotCache.java:66) ~[ms.jar:?]2021-11-22T16:19:59.892-05:00 at java.util.concurrent.CompletableFuture$UniCompose.tryFire(CompletableFuture.java:1072) ~[?:?]2021-11-22T16:19:59.892-05:00 ... 22 more

 21:13:00.627 [vert.x-worker-thread-4] ERROR RecordDaoImpl [1043926504eqId] Failed to save records 21:13:00.627 [vert.x-worker-thread-4] ERROR RecordDaoImpl [1043926504eqId] Failed to save records2021-11-22T16:13:00.628-05:00 org.jooq.exception.DataAccessException: SQL [select "snapshots_lb"."id", "snapshots_lb"."status", "snapshots_lb"."processing_started_date", "snapshots_lb"."created_by_user_id", "snapshots_lb"."created_date", "snapshots_lb"."updated_by_user_id", "snapshots_lb"."updated_date" from "snapshots_lb" where "snapshots_lb"."id" = cast(? as uuid)]; FATAL: terminating connection due to administrator command2021-11-22T16:13:00.628-05:00 at org.jooq_3.13.6.POSTGRES.debug(Unknown Source) ~[?:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.Tools.translate(Tools.java:2753) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:755) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:385) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:502) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:471) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.AbstractResultQuery.fetchLazyNonAutoClosing(AbstractResultQuery.java:485) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.AbstractResultQuery.fetchOne(AbstractResultQuery.java:654) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.AbstractResultQuery.fetchOptional(AbstractResultQuery.java:840) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.SelectImpl.fetchOptional(SelectImpl.java:3065) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.folio.dao.RecordDaoImpl.lambda$24(RecordDaoImpl.java:383) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultDSLContext$3.run(DefaultDSLContext.java:636) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultDSLContext$3.run(DefaultDSLContext.java:633) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultDSLContext.lambda$transactionResult0$0(DefaultDSLContext.java:564) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.Tools$12$1.block(Tools.java:4926) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at java.util.concurrent.ForkJoinPool.managedBlock(ForkJoinPool.java:3128) ~[?:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.Tools$12.get(Tools.java:4923) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultDSLContext.transactionResult0(DefaultDSLContext.java:616) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:533) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultDSLContext.transaction(DefaultDSLContext.java:633) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.folio.dao.RecordDaoImpl.saveRecords(RecordDaoImpl.java:377) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.folio.services.RecordServiceImpl.saveRecords(RecordServiceImpl.java:119) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.folio.services.ParsedRecordChunksKafkaHandler.handle(ParsedRecordChunksKafkaHandler.java:87) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:171) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:24) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at io.vertx.kafka.client.consumer.impl.KafkaConsumerImpl.lambda$handler$1(KafkaConsumerImpl.java:81) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.run(KafkaReadStreamImpl.java:237) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.lambda$schedule$8(KafkaReadStreamImpl.java:192) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at io.vertx.core.impl.AbstractContext.dispatch(AbstractContext.java:96) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at io.vertx.core.impl.WorkerContext.lambda$run$1(WorkerContext.java:82) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]2021-11-22T16:13:00.628-05:00 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]2021-11-22T16:13:00.628-05:00 at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?]2021-11-22T16:13:00.628-05:00 at java.lang.Thread.run(Thread.java:829) [?:?]2021-11-22T16:13:00.628-05:00 Suppressed: org.jooq.exception.DataAccessException: Cannot set autoCommit2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultConnectionProvider.setAutoCommit(DefaultConnectionProvider.java:217) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultTransactionProvider.brace(DefaultTransactionProvider.java:246) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultTransactionProvider.rollback(DefaultTransactionProvider.java:229) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultDSLContext.lambda$transactionResult0$0(DefaultDSLContext.java:588) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.Tools$12$1.block(Tools.java:4926) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at java.util.concurrent.ForkJoinPool.managedBlock(ForkJoinPool.java:3128) ~[?:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.Tools$12.get(Tools.java:4923) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultDSLContext.transactionResult0(DefaultDSLContext.java:616) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:533) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultDSLContext.transaction(DefaultDSLContext.java:633) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.folio.dao.RecordDaoImpl.saveRecords(RecordDaoImpl.java:377) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.folio.services.RecordServiceImpl.saveRecords(RecordServiceImpl.java:119) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.folio.services.ParsedRecordChunksKafkaHandler.handle(ParsedRecordChunksKafkaHandler.java:87) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:171) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:24) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at io.vertx.kafka.client.consumer.impl.KafkaConsumerImpl.lambda$handler$1(KafkaConsumerImpl.java:81) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.run(KafkaReadStreamImpl.java:237) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.lambda$schedule$8(KafkaReadStreamImpl.java:192) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at io.vertx.core.impl.AbstractContext.dispatch(AbstractContext.java:96) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at io.vertx.core.impl.WorkerContext.lambda$run$1(WorkerContext.java:82) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]2021-11-22T16:13:00.628-05:00 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]2021-11-22T16:13:00.628-05:00 at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?]2021-11-22T16:13:00.628-05:00 at java.lang.Thread.run(Thread.java:829) [?:?]2021-11-22T16:13:00.628-05:00 Caused by: org.postgresql.util.PSQLException: Connection has been closed.2021-11-22T16:13:00.628-05:00 at org.postgresql.ds.PGPooledConnection$ConnectionHandler.invoke(PGPooledConnection.java:326) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at com.sun.proxy.$Proxy87.setAutoCommit(Unknown Source) ~[?:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.DefaultConnectionProvider.setAutoCommit(DefaultConnectionProvider.java:214) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 ... 24 more2021-11-22T16:13:00.628-05:00 Caused by: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command2021-11-22T16:13:00.628-05:00 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:153) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at jdk.internal.reflect.GeneratedMethodAccessor97.invoke(Unknown Source) ~[?:?]2021-11-22T16:13:00.628-05:00 at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]2021-11-22T16:13:00.628-05:00 at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]2021-11-22T16:13:00.628-05:00 at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at com.sun.proxy.$Proxy88.execute(Unknown Source) ~[?:?]2021-11-22T16:13:00.628-05:00 at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:209) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:3992) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:295) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:371) ~[ms.jar:?]2021-11-22T16:13:00.628-05:00 ... 31 more2021-11-22T16:13:00.630-05:00 21:13:00.629 [vert.x-worker-thread-4] ERROR rdChunksKafkaHandler [1043926506eqId] RecordCollection processing has failed with errors... correlationId: 255a9369-aa66-4007-aafb-d93008e15a30, chunkNumber 4503-42021-11-22T16:13:00.630-05:00 org.jooq.exception.DataAccessException: SQL [select "snapshots_lb"."id", "snapshots_lb"."status", "snapshots_lb"."processing_started_date", "snapshots_lb"."created_by_user_id", "snapshots_lb"."created_date", "snapshots_lb"."updated_by_user_id", "snapshots_lb"."updated_date" from "snapshots_lb" where "snapshots_lb"."id" = cast(? as uuid)]; FATAL: terminating connection due to administrator command2021-11-22T16:13:00.630-05:00 at org.jooq_3.13.6.POSTGRES.debug(Unknown Source) ~[?:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.Tools.translate(Tools.java:2753) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:755) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:385) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:502) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:471) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.AbstractResultQuery.fetchLazyNonAutoClosing(AbstractResultQuery.java:485) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.AbstractResultQuery.fetchOne(AbstractResultQuery.java:654) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.AbstractResultQuery.fetchOptional(AbstractResultQuery.java:840) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.SelectImpl.fetchOptional(SelectImpl.java:3065) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.folio.dao.RecordDaoImpl.lambda$24(RecordDaoImpl.java:383) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultDSLContext$3.run(DefaultDSLContext.java:636) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultDSLContext$3.run(DefaultDSLContext.java:633) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultDSLContext.lambda$transactionResult0$0(DefaultDSLContext.java:564) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.Tools$12$1.block(Tools.java:4926) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at java.util.concurrent.ForkJoinPool.managedBlock(ForkJoinPool.java:3128) ~[?:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.Tools$12.get(Tools.java:4923) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultDSLContext.transactionResult0(DefaultDSLContext.java:616) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:533) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultDSLContext.transaction(DefaultDSLContext.java:633) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.folio.dao.RecordDaoImpl.saveRecords(RecordDaoImpl.java:377) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.folio.services.RecordServiceImpl.saveRecords(RecordServiceImpl.java:119) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.folio.services.ParsedRecordChunksKafkaHandler.handle(ParsedRecordChunksKafkaHandler.java:87) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:171) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:24) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at io.vertx.kafka.client.consumer.impl.KafkaConsumerImpl.lambda$handler$1(KafkaConsumerImpl.java:81) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.run(KafkaReadStreamImpl.java:237) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.lambda$schedule$8(KafkaReadStreamImpl.java:192) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at io.vertx.core.impl.AbstractContext.dispatch(AbstractContext.java:96) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at io.vertx.core.impl.WorkerContext.lambda$run$1(WorkerContext.java:82) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]2021-11-22T16:13:00.630-05:00 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]2021-11-22T16:13:00.630-05:00 at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?]2021-11-22T16:13:00.630-05:00 at java.lang.Thread.run(Thread.java:829) [?:?]2021-11-22T16:13:00.630-05:00 Suppressed: org.jooq.exception.DataAccessException: Cannot set autoCommit2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultConnectionProvider.setAutoCommit(DefaultConnectionProvider.java:217) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultTransactionProvider.brace(DefaultTransactionProvider.java:246) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultTransactionProvider.rollback(DefaultTransactionProvider.java:229) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultDSLContext.lambda$transactionResult0$0(DefaultDSLContext.java:588) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.Tools$12$1.block(Tools.java:4926) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at java.util.concurrent.ForkJoinPool.managedBlock(ForkJoinPool.java:3128) ~[?:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.Tools$12.get(Tools.java:4923) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultDSLContext.transactionResult0(DefaultDSLContext.java:616) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:533) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultDSLContext.transaction(DefaultDSLContext.java:633) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.folio.dao.RecordDaoImpl.saveRecords(RecordDaoImpl.java:377) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.folio.services.RecordServiceImpl.saveRecords(RecordServiceImpl.java:119) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.folio.services.ParsedRecordChunksKafkaHandler.handle(ParsedRecordChunksKafkaHandler.java:87) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:171) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:24) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at io.vertx.kafka.client.consumer.impl.KafkaConsumerImpl.lambda$handler$1(KafkaConsumerImpl.java:81) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.run(KafkaReadStreamImpl.java:237) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.lambda$schedule$8(KafkaReadStreamImpl.java:192) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at io.vertx.core.impl.AbstractContext.dispatch(AbstractContext.java:96) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at io.vertx.core.impl.WorkerContext.lambda$run$1(WorkerContext.java:82) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]2021-11-22T16:13:00.630-05:00 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]2021-11-22T16:13:00.630-05:00 at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?]2021-11-22T16:13:00.630-05:00 at java.lang.Thread.run(Thread.java:829) [?:?]2021-11-22T16:13:00.630-05:00 Caused by: org.postgresql.util.PSQLException: Connection has been closed.2021-11-22T16:13:00.630-05:00 at org.postgresql.ds.PGPooledConnection$ConnectionHandler.invoke(PGPooledConnection.java:326) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at com.sun.proxy.$Proxy87.setAutoCommit(Unknown Source) ~[?:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.DefaultConnectionProvider.setAutoCommit(DefaultConnectionProvider.java:214) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 ... 24 more2021-11-22T16:13:00.630-05:00 Caused by: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command2021-11-22T16:13:00.630-05:00 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:153) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at jdk.internal.reflect.GeneratedMethodAccessor97.invoke(Unknown Source) ~[?:?]2021-11-22T16:13:00.630-05:00 at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]2021-11-22T16:13:00.630-05:00 at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]2021-11-22T16:13:00.630-05:00 at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at com.sun.proxy.$Proxy88.execute(Unknown Source) ~[?:?]2021-11-22T16:13:00.630-05:00 at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:209) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:3992) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:295) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:371) ~[ms.jar:?]2021-11-22T16:13:00.630-05:00 ... 31 more