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

SPIKE: SQL exceptions when running CREATE import (Kiwi HF#2)

    XMLWordPrintable

    Details

    • Template:
      Standard Bug Write-Up Format
    • Story Points:
      5
    • Development Team:
      Folijet Support
    • Release:
      Kiwi (R3 2021) Hot Fix #2
    • Hot Fix Approved by Cap Planning?:
      Yes
    • Hot Fix Approval Comments:
      Kiwi HF approved by Mike G and Jakub on Slack release-bug-triage channel, 24 Jan 2022
    • Front-End Confidence factor:
      Low
    • RCA Group:
      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:

      Ann-Marie Breaux Kateryna Senchenko

       

        TestRail: Results

          Attachments

          1. 20160919.mrc
            171 kB
          2. 20K.zip
            2.82 MB
          3. Kiwi BF HRID Assignment.mp4
            13.17 MB
          4. Update prefixes.png
            Update prefixes.png
            213 kB

            Issue Links

              Activity

                People

                Assignee:
                ruslan_lavrov Ruslan Lavrov
                Reporter:
                mtraneis Martin Tran
                Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases