Uploaded image for project: 'mod-source-record-storage'
  1. mod-source-record-storage
  2. MODSOURCE-456

SQL exceptions when running CREATE import (Lotus)

    XMLWordPrintable

Details

    • 0
    • Folijet Support
    • Lotus R1 2022
    • Low
    • Third party component integration

    Description

      Overview: 

      When doing a CREATE data import, out of the blue SQL errors occurred in mod-source-record-storage and the current job and subsequent jobs trip over the same errors. Jobs therefore became stuck at some point in the import.  This does not happen consistently, but once the error happened then subsequent jobs would fail. The workaround is to restart mod-srs and if that doesn't work restart all DI modules.

      Steps to Reproduce:

      1. Log into https://pre-kiwi-cap1.int.aws.folio.org/data-import 
      2. Do a 20K Create import using the profile PTF - Create Success 2.  
      3. The job could get stuck at some point, or not. 

      Expected Results:

      Import job succeeds
      Actual Results:

      Errors found and the job is stuck.
      Additional Information:

      We used the attached file to do a 20K Create import.

      Exceptions: 

      02:36:35.310 [vert.x-worker-thread-6] ERROR RecordDaoImpl        [272515514eqId] Failed to save records02:36:35.310 [vert.x-worker-thread-6] ERROR RecordDaoImpl        [272515514eqId] Failed to save records02:36:35.310 [vert.x-worker-thread-6] ERROR RecordDaoImpl [272515514eqId] Failed to save records2022-01-10T02:36:35.312Z 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 command2022-01-10T02:36:35.312Z at org.jooq_3.13.6.POSTGRES.debug(Unknown Source) ~[?:?]2022-01-10T02:36:35.312Z at org.jooq.impl.Tools.translate(Tools.java:2753) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:755) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:385) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:502) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:471) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractResultQuery.fetchLazyNonAutoClosing(AbstractResultQuery.java:485) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractResultQuery.fetchOne(AbstractResultQuery.java:654) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractResultQuery.fetchOptional(AbstractResultQuery.java:840) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.SelectImpl.fetchOptional(SelectImpl.java:3065) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.dao.RecordDaoImpl.lambda$24(RecordDaoImpl.java:384) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext$3.run(DefaultDSLContext.java:636) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext$3.run(DefaultDSLContext.java:633) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext.lambda$transactionResult0$0(DefaultDSLContext.java:564) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.Tools$12$1.block(Tools.java:4926) ~[ms.jar:?]2022-01-10T02:36:35.312Z at java.util.concurrent.ForkJoinPool.managedBlock(ForkJoinPool.java:3128) ~[?:?]2022-01-10T02:36:35.312Z at org.jooq.impl.Tools$12.get(Tools.java:4923) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext.transactionResult0(DefaultDSLContext.java:616) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:533) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext.transaction(DefaultDSLContext.java:633) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.dao.RecordDaoImpl.saveRecords(RecordDaoImpl.java:378) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.services.RecordServiceImpl.saveRecords(RecordServiceImpl.java:119) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.services.ParsedRecordChunksKafkaHandler.handle(ParsedRecordChunksKafkaHandler.java:89) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:171) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:24) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.kafka.client.consumer.impl.KafkaConsumerImpl.lambda$handler$1(KafkaConsumerImpl.java:81) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.run(KafkaReadStreamImpl.java:237) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.lambda$schedule$8(KafkaReadStreamImpl.java:192) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.core.impl.AbstractContext.dispatch(AbstractContext.java:96) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.core.impl.WorkerContext.lambda$run$1(WorkerContext.java:82) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76) ~[ms.jar:?]2022-01-10T02:36:35.312Z at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]2022-01-10T02:36:35.312Z at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]2022-01-10T02:36:35.312Z at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?]2022-01-10T02:36:35.312Z at java.lang.Thread.run(Thread.java:829) [?:?]2022-01-10T02:36:35.312Z Suppressed: org.jooq.exception.DataAccessException: Cannot set autoCommit2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultConnectionProvider.setAutoCommit(DefaultConnectionProvider.java:217) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultTransactionProvider.brace(DefaultTransactionProvider.java:246) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultTransactionProvider.rollback(DefaultTransactionProvider.java:229) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext.lambda$transactionResult0$0(DefaultDSLContext.java:588) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.Tools$12$1.block(Tools.java:4926) ~[ms.jar:?]2022-01-10T02:36:35.312Z at java.util.concurrent.ForkJoinPool.managedBlock(ForkJoinPool.java:3128) ~[?:?]2022-01-10T02:36:35.312Z at org.jooq.impl.Tools$12.get(Tools.java:4923) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext.transactionResult0(DefaultDSLContext.java:616) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:533) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext.transaction(DefaultDSLContext.java:633) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.dao.RecordDaoImpl.saveRecords(RecordDaoImpl.java:378) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.services.RecordServiceImpl.saveRecords(RecordServiceImpl.java:119) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.services.ParsedRecordChunksKafkaHandler.handle(ParsedRecordChunksKafkaHandler.java:89) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:171) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:24) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.kafka.client.consumer.impl.KafkaConsumerImpl.lambda$handler$1(KafkaConsumerImpl.java:81) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.run(KafkaReadStreamImpl.java:237) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.lambda$schedule$8(KafkaReadStreamImpl.java:192) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.core.impl.AbstractContext.dispatch(AbstractContext.java:96) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.core.impl.WorkerContext.lambda$run$1(WorkerContext.java:82) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76) ~[ms.jar:?]2022-01-10T02:36:35.312Z at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]2022-01-10T02:36:35.312Z at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]2022-01-10T02:36:35.312Z at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?]2022-01-10T02:36:35.312Z at java.lang.Thread.run(Thread.java:829) [?:?]2022-01-10T02:36:35.312Z Caused by: org.postgresql.util.PSQLException: Connection has been closed.2022-01-10T02:36:35.312Z at org.postgresql.ds.PGPooledConnection$ConnectionHandler.invoke(PGPooledConnection.java:326) ~[ms.jar:?]2022-01-10T02:36:35.312Z at com.sun.proxy.$Proxy87.setAutoCommit(Unknown Source) ~[?:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultConnectionProvider.setAutoCommit(DefaultConnectionProvider.java:214) ~[ms.jar:?]2022-01-10T02:36:35.312Z ... 24 more2022-01-10T02:36:35.312Z Caused by: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command2022-01-10T02:36:35.312Z at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:153) ~[ms.jar:?]2022-01-10T02:36:35.312Z at jdk.internal.reflect.GeneratedMethodAccessor166.invoke(Unknown Source) ~[?:?]2022-01-10T02:36:35.312Z at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]2022-01-10T02:36:35.312Z at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]2022-01-10T02:36:35.312Z at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[ms.jar:?]2022-01-10T02:36:35.312Z at com.sun.proxy.$Proxy88.execute(Unknown Source) ~[?:?]2022-01-10T02:36:35.312Z at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:209) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:3992) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:295) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:371) ~[ms.jar:?]2022-01-10T02:36:35.312Z ... 31 more2022-01-10T02:36:35.312Z 02:36:35.312 [vert.x-worker-thread-6] ERROR rdChunksKafkaHandler [272515516eqId] RecordCollection processing has failed with errors... correlationId: 50d60ba5-fd9d-40fc-9439-d99c0be0b921, chunkNumber 2422-222022-01-10T02:36:35.312Z 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 command2022-01-10T02:36:35.312Z at org.jooq_3.13.6.POSTGRES.debug(Unknown Source) ~[?:?]2022-01-10T02:36:35.312Z at org.jooq.impl.Tools.translate(Tools.java:2753) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:755) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:385) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:502) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:471) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractResultQuery.fetchLazyNonAutoClosing(AbstractResultQuery.java:485) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractResultQuery.fetchOne(AbstractResultQuery.java:654) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.AbstractResultQuery.fetchOptional(AbstractResultQuery.java:840) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.SelectImpl.fetchOptional(SelectImpl.java:3065) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.dao.RecordDaoImpl.lambda$24(RecordDaoImpl.java:384) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext$3.run(DefaultDSLContext.java:636) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext$3.run(DefaultDSLContext.java:633) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext.lambda$transactionResult0$0(DefaultDSLContext.java:564) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.Tools$12$1.block(Tools.java:4926) ~[ms.jar:?]2022-01-10T02:36:35.312Z at java.util.concurrent.ForkJoinPool.managedBlock(ForkJoinPool.java:3128) ~[?:?]2022-01-10T02:36:35.312Z at org.jooq.impl.Tools$12.get(Tools.java:4923) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext.transactionResult0(DefaultDSLContext.java:616) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:533) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultDSLContext.transaction(DefaultDSLContext.java:633) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.dao.RecordDaoImpl.saveRecords(RecordDaoImpl.java:378) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.services.RecordServiceImpl.saveRecords(RecordServiceImpl.java:119) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.services.ParsedRecordChunksKafkaHandler.handle(ParsedRecordChunksKafkaHandler.java:89) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:171) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:24) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.kafka.client.consumer.impl.KafkaConsumerImpl.lambda$handler$1(KafkaConsumerImpl.java:81) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.run(KafkaReadStreamImpl.java:237) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.lambda$schedule$8(KafkaReadStreamImpl.java:192) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.core.impl.AbstractContext.dispatch(AbstractContext.java:96) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.core.impl.WorkerContext.lambda$run$1(WorkerContext.java:82) ~[ms.jar:?]2022-01-10T02:36:35.312Z at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76) ~[ms.jar:?]2022-01-10T02:36:35.312Z at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]2022-01-10T02:36:35.312Z at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]2022-01-10T02:36:35.312Z at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?]2022-01-10T02:36:35.312Z at java.lang.Thread.run(Thread.java:829) [?:?]2022-01-10T02:36:35.312Z Suppressed: org.jooq.exception.DataAccessException: Cannot set autoCommit2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultConnectionProvider.setAutoCommit(DefaultConnectionProvider.java:217) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultTransactionProvider.brace(DefaultTransactionProvider.java:246) ~[ms.jar:?]2022-01-10T02:36:35.312Z at org.jooq.impl.DefaultTransactionProvider.rollback(DefaultTransactionProvider.java:229) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.jooq.impl.DefaultDSLContext.lambda$transactionResult0$0(DefaultDSLContext.java:588) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.jooq.impl.Tools$12$1.block(Tools.java:4926) ~[ms.jar:?]2022-01-10T02:36:35.313Z at java.util.concurrent.ForkJoinPool.managedBlock(ForkJoinPool.java:3128) ~[?:?]2022-01-10T02:36:35.313Z at org.jooq.impl.Tools$12.get(Tools.java:4923) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.jooq.impl.DefaultDSLContext.transactionResult0(DefaultDSLContext.java:616) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:533) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.jooq.impl.DefaultDSLContext.transaction(DefaultDSLContext.java:633) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.folio.dao.RecordDaoImpl.saveRecords(RecordDaoImpl.java:378) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.folio.services.RecordServiceImpl.saveRecords(RecordServiceImpl.java:119) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.folio.services.ParsedRecordChunksKafkaHandler.handle(ParsedRecordChunksKafkaHandler.java:89) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:171) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:24) ~[ms.jar:?]2022-01-10T02:36:35.313Z at io.vertx.kafka.client.consumer.impl.KafkaConsumerImpl.lambda$handler$1(KafkaConsumerImpl.java:81) ~[ms.jar:?]2022-01-10T02:36:35.313Z at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.run(KafkaReadStreamImpl.java:237) ~[ms.jar:?]2022-01-10T02:36:35.313Z at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.lambda$schedule$8(KafkaReadStreamImpl.java:192) ~[ms.jar:?]2022-01-10T02:36:35.313Z at io.vertx.core.impl.AbstractContext.dispatch(AbstractContext.java:96) ~[ms.jar:?]2022-01-10T02:36:35.313Z at io.vertx.core.impl.WorkerContext.lambda$run$1(WorkerContext.java:82) ~[ms.jar:?]2022-01-10T02:36:35.313Z at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76) ~[ms.jar:?]2022-01-10T02:36:35.313Z at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]2022-01-10T02:36:35.313Z at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]2022-01-10T02:36:35.313Z at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?]2022-01-10T02:36:35.313Z at java.lang.Thread.run(Thread.java:829) [?:?]2022-01-10T02:36:35.313Z Caused by: org.postgresql.util.PSQLException: Connection has been closed.2022-01-10T02:36:35.313Z at org.postgresql.ds.PGPooledConnection$ConnectionHandler.invoke(PGPooledConnection.java:326) ~[ms.jar:?]2022-01-10T02:36:35.313Z at com.sun.proxy.$Proxy87.setAutoCommit(Unknown Source) ~[?:?]2022-01-10T02:36:35.313Z at org.jooq.impl.DefaultConnectionProvider.setAutoCommit(DefaultConnectionProvider.java:214) ~[ms.jar:?]2022-01-10T02:36:35.313Z ... 24 more2022-01-10T02:36:35.313Z Caused by: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command2022-01-10T02:36:35.313Z at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:153) ~[ms.jar:?]2022-01-10T02:36:35.313Z at jdk.internal.reflect.GeneratedMethodAccessor166.invoke(Unknown Source) ~[?:?]2022-01-10T02:36:35.313Z at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]2022-01-10T02:36:35.313Z at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]2022-01-10T02:36:35.313Z at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[ms.jar:?]2022-01-10T02:36:35.313Z at com.sun.proxy.$Proxy88.execute(Unknown Source) ~[?:?]2022-01-10T02:36:35.313Z at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:209) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:3992) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:295) ~[ms.jar:?]2022-01-10T02:36:35.313Z at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:371) ~[ms.jar:?]2022-01-10T02:36:35.313Z ... 31 more

      Interested parties:

      abreaux Kateryna Senchenko

       

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Task - A task that needs to be done. MODSOURCE-430 Release v5.3.0 (R1 Lotus)

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            clones

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-438 SPIKE: SQL exceptions when running CREATE import (Kiwi HF#2)

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            defines

            New Feature - New feature requests UXPROD-3463 NFR: Data Import R1 2022 Lotus Support Bug Work

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Activity

              People

                ruslan_lavrov Ruslan Lavrov
                ruslan_lavrov Ruslan Lavrov
                Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases