timestamp,message 1634919068754,"16:11:08.753 [vert.x-eventloop-thread-1] ERROR ExceptionHelper [349588950eqId] { ""message"": ""column records_lb.external_id does not exist"", ""severity"": ""ERROR"", ""code"": ""42703"", ""position"": ""57"", ""file"": ""parse_relation.c"", ""line"": ""3359"", ""routine"": ""errorMissingColumn"" }" 1634919068754,"io.vertx.pgclient.PgException: { ""message"": ""column records_lb.external_id does not exist"", ""severity"": ""ERROR"", ""code"": ""42703"", ""position"": ""57"", ""file"": ""parse_relation.c"", ""line"": ""3359"", ""routine"": ""errorMissingColumn"" }" 1634919068754, at io.vertx.pgclient.impl.codec.ErrorResponse.toException(ErrorResponse.java:31) ~[ms.jar:?] 1634919068754, at io.vertx.pgclient.impl.codec.PrepareStatementCommandCodec.handleErrorResponse(PrepareStatementCommandCodec.java:88) [ms.jar:?] 1634919068754, at io.vertx.pgclient.impl.codec.PgDecoder.decodeError(PgDecoder.java:246) ~[ms.jar:?] 1634919068754, at io.vertx.pgclient.impl.codec.PgDecoder.decodeMessage(PgDecoder.java:131) [ms.jar:?] 1634919068754, at io.vertx.pgclient.impl.codec.PgDecoder.channelRead(PgDecoder.java:111) [ms.jar:?] 1634919068754, at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:251) [ms.jar:?] 1634919068754, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 1634919068754, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 1634919068754, at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [ms.jar:?] 1634919068754, at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286) [ms.jar:?] 1634919068754, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 1634919068754, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 1634919068754, at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [ms.jar:?] 1634919068754, at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) [ms.jar:?] 1634919068754, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 1634919068754, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 1634919068754, at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) [ms.jar:?] 1634919068754, at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166) [ms.jar:?] 1634919068754, at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:719) [ms.jar:?] 1634919068754, at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:655) [ms.jar:?] 1634919068754, at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:581) [ms.jar:?] 1634919068754, at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493) [ms.jar:?] 1634919068754, at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) [ms.jar:?] 1634919068754, at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) [ms.jar:?] 1634919068754, at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?] 1634919068754, at java.lang.Thread.run(Thread.java:829) [?:?] 1634919068755,16:11:08.755 [vert.x-eventloop-thread-1] INFO LogUtil [349588952eqId] 127.0.0.1:33296 POST /source-storage/source-records idType=INSTANCE HTTP_1_1 500 0 8 tid=fs09000000 Internal Server Error 1634919078763,16:11:18.763 [vert.x-eventloop-thread-1] INFO RestRouting [349598960eqId] invoking getAdminHealth 1634919078768,16:11:18.768 [vert.x-eventloop-thread-1] INFO LogUtil [349598965eqId] 127.0.0.1:33386 GET /admin/health null HTTP_1_1 200 4 21 tid=null OK 1634919089875,16:11:29.875 [vert.x-eventloop-thread-1] INFO RestRouting [349610072eqId] invoking getAdminHealth 1634919089880,16:11:29.880 [vert.x-eventloop-thread-1] INFO LogUtil [349610077eqId] 127.0.0.1:33472 GET /admin/health null HTTP_1_1 200 4 22 tid=null OK 1634919094101,16:11:34.101 [vert.x-eventloop-thread-1] INFO RestRouting [349614298eqId] invoking getAdminHealth 1634919094101,16:11:34.101 [vert.x-eventloop-thread-1] INFO LogUtil [349614298eqId] 127.0.0.1:33492 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 1634919098676,16:11:38.676 [vert.x-eventloop-thread-1] INFO RestRouting [349618873eqId] invoking getAdminHealth 1634919098677,16:11:38.676 [vert.x-eventloop-thread-1] INFO LogUtil [349618873eqId] 127.0.0.1:33562 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 1634919108778,16:11:48.778 [vert.x-eventloop-thread-1] INFO RestRouting [349628975eqId] invoking getAdminHealth 1634919108783,16:11:48.783 [vert.x-eventloop-thread-1] INFO LogUtil [349628980eqId] 127.0.0.1:33670 GET /admin/health null HTTP_1_1 200 4 23 tid=null OK 1634919119883,16:11:59.883 [vert.x-eventloop-thread-1] INFO RestRouting [349640080eqId] invoking getAdminHealth 1634919119888,16:11:59.888 [vert.x-eventloop-thread-1] INFO LogUtil [349640085eqId] 127.0.0.1:33752 GET /admin/health null HTTP_1_1 200 4 22 tid=null OK 1634919124117,16:12:04.117 [vert.x-eventloop-thread-1] INFO RestRouting [349644314eqId] invoking getAdminHealth 1634919124117,16:12:04.117 [vert.x-eventloop-thread-1] INFO LogUtil [349644314eqId] 127.0.0.1:33772 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 1634919128696,16:12:08.696 [vert.x-eventloop-thread-1] INFO RestRouting [349648893eqId] invoking getAdminHealth 1634919128696,16:12:08.696 [vert.x-eventloop-thread-1] INFO LogUtil [349648893eqId] 127.0.0.1:33854 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 1634919138787,16:12:18.787 [vert.x-eventloop-thread-1] INFO RestRouting [349658984eqId] invoking getAdminHealth 1634919138792,16:12:18.792 [vert.x-eventloop-thread-1] INFO LogUtil [349658989eqId] 127.0.0.1:33942 GET /admin/health null HTTP_1_1 200 4 22 tid=null OK 1634919149879,16:12:29.879 [vert.x-eventloop-thread-1] INFO RestRouting [349670076eqId] invoking getAdminHealth 1634919149884,16:12:29.883 [vert.x-eventloop-thread-1] INFO LogUtil [349670080eqId] 127.0.0.1:34030 GET /admin/health null HTTP_1_1 200 4 21 tid=null OK 1634919154134,16:12:34.134 [vert.x-eventloop-thread-1] INFO RestRouting [349674331eqId] invoking getAdminHealth 1634919154135,16:12:34.134 [vert.x-eventloop-thread-1] INFO LogUtil [349674331eqId] 127.0.0.1:34050 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 1634919158725,16:12:38.725 [vert.x-eventloop-thread-1] INFO RestRouting [349678922eqId] invoking getAdminHealth 1634919158730,16:12:38.730 [vert.x-eventloop-thread-1] INFO LogUtil [349678927eqId] 127.0.0.1:34126 GET /admin/health null HTTP_1_1 200 4 22 tid=null OK 1634919168776,16:12:48.776 [vert.x-eventloop-thread-1] INFO RestRouting [349688973eqId] invoking getAdminHealth 1634919168777,16:12:48.776 [vert.x-eventloop-thread-1] INFO LogUtil [349688973eqId] 127.0.0.1:34220 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 1634919179880,16:12:59.880 [vert.x-eventloop-thread-1] INFO RestRouting [349700077eqId] invoking getAdminHealth 1634919179885,16:12:59.885 [vert.x-eventloop-thread-1] INFO LogUtil [349700082eqId] 127.0.0.1:34294 GET /admin/health null HTTP_1_1 200 4 22 tid=null OK 1634919184146,16:13:04.146 [vert.x-eventloop-thread-1] INFO RestRouting [349704343eqId] invoking getAdminHealth 1634919184152,16:13:04.151 [vert.x-eventloop-thread-1] INFO LogUtil [349704348eqId] 127.0.0.1:34318 GET /admin/health null HTTP_1_1 200 4 22 tid=null OK 1634919188733,16:13:08.733 [vert.x-eventloop-thread-1] INFO RestRouting [349708930eqId] invoking getAdminHealth 1634919188738,16:13:08.738 [vert.x-eventloop-thread-1] INFO LogUtil [349708935eqId] 127.0.0.1:34396 GET /admin/health null HTTP_1_1 200 4 22 tid=null OK 1634919198787,16:13:18.786 [vert.x-eventloop-thread-1] INFO RestRouting [349718983eqId] invoking getAdminHealth 1634919198787,16:13:18.786 [vert.x-eventloop-thread-1] INFO LogUtil [349718983eqId] 127.0.0.1:34486 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 1634919209880,16:13:29.880 [vert.x-eventloop-thread-1] INFO RestRouting [349730077eqId] invoking getAdminHealth 1634919209885,16:13:29.885 [vert.x-eventloop-thread-1] INFO LogUtil [349730082eqId] 127.0.0.1:34576 GET /admin/health null HTTP_1_1 200 4 22 tid=null OK 1634919214177,16:13:34.173 [vert.x-eventloop-thread-1] INFO RestRouting [349734370eqId] invoking getAdminHealth 1634919214179,16:13:34.178 [vert.x-eventloop-thread-1] INFO LogUtil [349734375eqId] 127.0.0.1:34596 GET /admin/health null HTTP_1_1 200 4 23 tid=null OK 1634919218715,16:13:38.715 [vert.x-eventloop-thread-1] INFO RestRouting [349738912eqId] invoking getAdminHealth 1634919218716,16:13:38.715 [vert.x-eventloop-thread-1] INFO LogUtil [349738912eqId] 127.0.0.1:34674 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 1634919228820,16:13:48.818 [vert.x-eventloop-thread-1] INFO RestRouting [349749015eqId] invoking getAdminHealth 1634919228825,16:13:48.825 [vert.x-eventloop-thread-1] INFO LogUtil [349749022eqId] 127.0.0.1:34772 GET /admin/health null HTTP_1_1 200 4 28 tid=null OK 1634919239880,16:13:59.880 [vert.x-eventloop-thread-1] INFO RestRouting [349760077eqId] invoking getAdminHealth 1634919239885,16:13:59.885 [vert.x-eventloop-thread-1] INFO LogUtil [349760082eqId] 127.0.0.1:34858 GET /admin/health null HTTP_1_1 200 4 21 tid=null OK 1634919244158,16:14:04.158 [vert.x-eventloop-thread-1] INFO RestRouting [349764355eqId] invoking getAdminHealth 1634919244158,16:14:04.158 [vert.x-eventloop-thread-1] INFO LogUtil [349764355eqId] 127.0.0.1:34876 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 1634919248741,16:14:08.741 [vert.x-eventloop-thread-1] INFO RestRouting [349768938eqId] invoking getAdminHealth 1634919248746,16:14:08.746 [vert.x-eventloop-thread-1] INFO LogUtil [349768943eqId] 127.0.0.1:34958 GET /admin/health null HTTP_1_1 200 4 21 tid=null OK 1634919258796,16:14:18.796 [vert.x-eventloop-thread-1] INFO RestRouting [349778993eqId] invoking getAdminHealth 1634919258797,16:14:18.797 [vert.x-eventloop-thread-1] INFO LogUtil [349778994eqId] 127.0.0.1:35042 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 1634919269879,16:14:29.879 [vert.x-eventloop-thread-1] INFO RestRouting [349790076eqId] invoking getAdminHealth 1634919269883,16:14:29.883 [vert.x-eventloop-thread-1] INFO LogUtil [349790080eqId] 127.0.0.1:35134 GET /admin/health null HTTP_1_1 200 4 20 tid=null OK 1634919274186,16:14:34.185 [vert.x-eventloop-thread-1] INFO RestRouting [349794382eqId] invoking getAdminHealth 1634919274190,16:14:34.190 [vert.x-eventloop-thread-1] INFO LogUtil [349794387eqId] 127.0.0.1:35156 GET /admin/health null HTTP_1_1 200 4 21 tid=null OK 1634919278737,16:14:38.737 [vert.x-eventloop-thread-1] INFO RestRouting [349798934eqId] invoking getAdminHealth 1634919278737,16:14:38.737 [vert.x-eventloop-thread-1] INFO LogUtil [349798934eqId] 127.0.0.1:35232 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 1634919288830,16:14:48.830 [vert.x-eventloop-thread-1] INFO RestRouting [349809027eqId] invoking getAdminHealth 1634919288835,16:14:48.835 [vert.x-eventloop-thread-1] INFO LogUtil [349809032eqId] 127.0.0.1:35324 GET /admin/health null HTTP_1_1 200 4 21 tid=null OK 1634919299881,16:14:59.881 [vert.x-eventloop-thread-1] INFO RestRouting [349820078eqId] invoking getAdminHealth 1634919299886,16:14:59.886 [vert.x-eventloop-thread-1] INFO LogUtil [349820083eqId] 127.0.0.1:35404 GET /admin/health null HTTP_1_1 200 4 22 tid=null OK 1634919304216,16:15:04.216 [vert.x-eventloop-thread-1] INFO RestRouting [349824413eqId] invoking getAdminHealth 1634919304221,16:15:04.221 [vert.x-eventloop-thread-1] INFO LogUtil [349824418eqId] 127.0.0.1:35428 GET /admin/health null HTTP_1_1 200 4 23 tid=null OK 1634919308751,16:15:08.751 [vert.x-eventloop-thread-1] INFO RestRouting [349828948eqId] invoking getAdminHealth 1634919308752,16:15:08.752 [vert.x-eventloop-thread-1] INFO LogUtil [349828949eqId] 127.0.0.1:35510 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 1634919318817,16:15:18.816 [vert.x-eventloop-thread-1] INFO RestRouting [349839013eqId] invoking getAdminHealth 1634919318817,16:15:18.817 [vert.x-eventloop-thread-1] INFO LogUtil [349839014eqId] 127.0.0.1:35628 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 1634919324523,16:15:24.523 [vert.x-eventloop-thread-1] INFO RestRouting [349844720eqId] invoking putSourceStorageSnapshotsByJobExecutionId 1634919324568,16:15:24.568 [vert.x-eventloop-thread-1] INFO LogUtil [349844765eqId] 127.0.0.1:35682 PUT /source-storage/snapshots/17e8f8b8-9a97-4b15-abd4-a1ada1fa827d HTTP_1_1 200 412 65 tid=fs09000000 OK 1634919325858,16:15:25.858 [vert.x-eventloop-thread-1] INFO RestRouting [349846055eqId] invoking putSourceStorageSnapshotsByJobExecutionId 1634919325868,16:15:25.868 [vert.x-eventloop-thread-1] INFO LogUtil [349846065eqId] 127.0.0.1:35724 PUT /source-storage/snapshots/17e8f8b8-9a97-4b15-abd4-a1ada1fa827d HTTP_1_1 200 412 10 tid=fs09000000 OK 1634919326193,"16:15:26.193 [vert.x-worker-thread-0] DEBUG KafkaConsumerWrapper [349846390eqId] Consumer - id: 0 subscriptionPattern: SubscriptionDefinition(eventType=DI_RAW_RECORDS_CHUNK_PARSED, subscriptionPattern=kcp1\.Default\.\w{1,}\.DI_RAW_RECORDS_CHUNK_PARSED) a Record has been received. key: 3 currentLoad: 1 globalLoad: 1" 1634919326198,"16:15:26.197 [vert.x-worker-thread-0] DEBUG rdChunksKafkaHandler [349846394eqId] RecordCollection has been received, correlationId: b2c726bd-8d1d-4fb8-a70a-856251df32e0, starting processing... chunkNumber 403-3" 1634919326251,"16:15:26.251 [vert.x-worker-thread-0] WARN RecordDaoImpl [349846448eqId] Error occurred on batch execution: ERROR: column ""external_id"" of relation ""records_lb"" does not exist" 1634919326251, Position: 91 1634919326260,16:15:26.259 [vert.x-worker-thread-0] ERROR RecordDaoImpl [349846456eqId] Failed to save records 1634919326260,"org.jooq.exception.DataAccessException: SQL [null]; ERROR: insert or update on table ""raw_records_lb"" violates foreign key constraint ""fk_raw_records_records""" 1634919326260," Detail: Key (id)=(282d4872-7816-4481-a1d1-0517b9a66010) is not present in table ""records_lb""." 1634919326260, at org.jooq.impl.Tools.translate(Tools.java:2753) ~[ms.jar:?] 1634919326260, at org.jooq.impl.LoaderImpl.executeRows(LoaderImpl.java:723) ~[ms.jar:?] 1634919326260, at org.jooq.impl.LoaderImpl.execute(LoaderImpl.java:649) ~[ms.jar:?] 1634919326260, at org.jooq.impl.LoaderImpl.execute(LoaderImpl.java:97) ~[ms.jar:?] 1634919326260, at org.folio.dao.RecordDaoImpl.lambda$24(RecordDaoImpl.java:453) ~[ms.jar:?] 1634919326260, at org.jooq.impl.DefaultDSLContext$3.run(DefaultDSLContext.java:636) ~[ms.jar:?] 1634919326260, at org.jooq.impl.DefaultDSLContext$3.run(DefaultDSLContext.java:633) ~[ms.jar:?] 1634919326260, at org.jooq.impl.DefaultDSLContext.lambda$transactionResult0$0(DefaultDSLContext.java:564) ~[ms.jar:?] 1634919326260, at org.jooq.impl.Tools$12$1.block(Tools.java:4926) ~[ms.jar:?] 1634919326260, at java.util.concurrent.ForkJoinPool.managedBlock(ForkJoinPool.java:3128) ~[?:?] 1634919326260, at org.jooq.impl.Tools$12.get(Tools.java:4923) ~[ms.jar:?] 1634919326260, at org.jooq.impl.DefaultDSLContext.transactionResult0(DefaultDSLContext.java:616) ~[ms.jar:?] 1634919326260, at org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:533) ~[ms.jar:?] 1634919326260, at org.jooq.impl.DefaultDSLContext.transaction(DefaultDSLContext.java:633) ~[ms.jar:?] 1634919326260, at org.folio.dao.RecordDaoImpl.saveRecords(RecordDaoImpl.java:377) ~[ms.jar:?] 1634919326260, at org.folio.services.RecordServiceImpl.saveRecords(RecordServiceImpl.java:119) ~[ms.jar:?] 1634919326260, at org.folio.services.ParsedRecordChunksKafkaHandler.handle(ParsedRecordChunksKafkaHandler.java:87) ~[ms.jar:?] 1634919326260, at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:171) ~[ms.jar:?] 1634919326260, at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:24) ~[ms.jar:?] 1634919326260, at io.vertx.kafka.client.consumer.impl.KafkaConsumerImpl.lambda$handler$1(KafkaConsumerImpl.java:81) ~[ms.jar:?] 1634919326260, at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.run(KafkaReadStreamImpl.java:237) ~[ms.jar:?] 1634919326260, at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.lambda$schedule$8(KafkaReadStreamImpl.java:192) ~[ms.jar:?] 1634919326260, at io.vertx.core.impl.AbstractContext.dispatch(AbstractContext.java:96) ~[ms.jar:?] 1634919326260, at io.vertx.core.impl.WorkerContext.lambda$run$1(WorkerContext.java:82) ~[ms.jar:?] 1634919326260, at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76) ~[ms.jar:?] 1634919326260, at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] 1634919326260, at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] 1634919326260, at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?] 1634919326260, at java.lang.Thread.run(Thread.java:829) [?:?] 1634919326260,"Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table ""raw_records_lb"" violates foreign key constraint ""fk_raw_records_records""" 1634919326260," Detail: Key (id)=(282d4872-7816-4481-a1d1-0517b9a66010) is not present in table ""records_lb""." 1634919326260, at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[ms.jar:?] 1634919326260, at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[ms.jar:?] 1634919326260, at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[ms.jar:?] 1634919326260, at org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:857) ~[ms.jar:?] 1634919326260, at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:879) ~[ms.jar:?] 1634919326260, at jdk.internal.reflect.GeneratedMethodAccessor89.invoke(Unknown Source) ~[?:?] 1634919326260, at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] 1634919326260, at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] 1634919326260, at org.postgresql.ds.PGPooledConnection$ConnectionHandler.invoke(PGPooledConnection.java:348) ~[ms.jar:?] 1634919326260, at com.sun.proxy.$Proxy87.commit(Unknown Source) ~[?:?] 1634919326260, at org.jooq.impl.LoaderImpl.commit(LoaderImpl.java:914) ~[ms.jar:?] 1634919326260, at org.jooq.impl.LoaderImpl.executeSQL(LoaderImpl.java:902) ~[ms.jar:?] 1634919326260, at org.jooq.impl.LoaderImpl.executeRows(LoaderImpl.java:717) ~[ms.jar:?] 1634919326260, ... 27 more 1634919326262,"16:15:26.261 [vert.x-worker-thread-0] ERROR rdChunksKafkaHandler [349846458eqId] RecordCollection processing has failed with errors... correlationId: b2c726bd-8d1d-4fb8-a70a-856251df32e0, chunkNumber 403-3" 1634919326262,"org.jooq.exception.DataAccessException: SQL [null]; ERROR: insert or update on table ""raw_records_lb"" violates foreign key constraint ""fk_raw_records_records""" 1634919326262," Detail: Key (id)=(282d4872-7816-4481-a1d1-0517b9a66010) is not present in table ""records_lb""." 1634919326262, at org.jooq.impl.Tools.translate(Tools.java:2753) ~[ms.jar:?] 1634919326262, at org.jooq.impl.LoaderImpl.executeRows(LoaderImpl.java:723) ~[ms.jar:?] 1634919326262, at org.jooq.impl.LoaderImpl.execute(LoaderImpl.java:649) ~[ms.jar:?] 1634919326262, at org.jooq.impl.LoaderImpl.execute(LoaderImpl.java:97) ~[ms.jar:?] 1634919326262, at org.folio.dao.RecordDaoImpl.lambda$24(RecordDaoImpl.java:453) ~[ms.jar:?] 1634919326262, at org.jooq.impl.DefaultDSLContext$3.run(DefaultDSLContext.java:636) ~[ms.jar:?] 1634919326262, at org.jooq.impl.DefaultDSLContext$3.run(DefaultDSLContext.java:633) ~[ms.jar:?] 1634919326262, at org.jooq.impl.DefaultDSLContext.lambda$transactionResult0$0(DefaultDSLContext.java:564) ~[ms.jar:?] 1634919326262, at org.jooq.impl.Tools$12$1.block(Tools.java:4926) ~[ms.jar:?] 1634919326262, at java.util.concurrent.ForkJoinPool.managedBlock(ForkJoinPool.java:3128) ~[?:?] 1634919326262, at org.jooq.impl.Tools$12.get(Tools.java:4923) ~[ms.jar:?] 1634919326262, at org.jooq.impl.DefaultDSLContext.transactionResult0(DefaultDSLContext.java:616) ~[ms.jar:?] 1634919326262, at org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:533) ~[ms.jar:?] 1634919326262, at org.jooq.impl.DefaultDSLContext.transaction(DefaultDSLContext.java:633) ~[ms.jar:?] 1634919326262, at org.folio.dao.RecordDaoImpl.saveRecords(RecordDaoImpl.java:377) ~[ms.jar:?] 1634919326262, at org.folio.services.RecordServiceImpl.saveRecords(RecordServiceImpl.java:119) ~[ms.jar:?] 1634919326262, at org.folio.services.ParsedRecordChunksKafkaHandler.handle(ParsedRecordChunksKafkaHandler.java:87) ~[ms.jar:?] 1634919326262, at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:171) ~[ms.jar:?] 1634919326262, at org.folio.kafka.KafkaConsumerWrapper.handle(KafkaConsumerWrapper.java:24) ~[ms.jar:?] 1634919326262, at io.vertx.kafka.client.consumer.impl.KafkaConsumerImpl.lambda$handler$1(KafkaConsumerImpl.java:81) ~[ms.jar:?] 1634919326262, at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.run(KafkaReadStreamImpl.java:237) ~[ms.jar:?] 1634919326262, at io.vertx.kafka.client.consumer.impl.KafkaReadStreamImpl.lambda$schedule$8(KafkaReadStreamImpl.java:192) ~[ms.jar:?] 1634919326262, at io.vertx.core.impl.AbstractContext.dispatch(AbstractContext.java:96) ~[ms.jar:?] 1634919326262, at io.vertx.core.impl.WorkerContext.lambda$run$1(WorkerContext.java:82) ~[ms.jar:?] 1634919326262, at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76) ~[ms.jar:?] 1634919326262, at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] 1634919326262, at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] 1634919326262, at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?] 1634919326262, at java.lang.Thread.run(Thread.java:829) [?:?] 1634919326262,"Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table ""raw_records_lb"" violates foreign key constraint ""fk_raw_records_records""" 1634919326262," Detail: Key (id)=(282d4872-7816-4481-a1d1-0517b9a66010) is not present in table ""records_lb""." 1634919326262, at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[ms.jar:?] 1634919326262, at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[ms.jar:?] 1634919326262, at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[ms.jar:?] 1634919326262, at org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:857) ~[ms.jar:?] 1634919326262, at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:879) ~[ms.jar:?] 1634919326262, at jdk.internal.reflect.GeneratedMethodAccessor89.invoke(Unknown Source) ~[?:?] 1634919326262, at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] 1634919326262, at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] 1634919326262, at org.postgresql.ds.PGPooledConnection$ConnectionHandler.invoke(PGPooledConnection.java:348) ~[ms.jar:?] 1634919326262, at com.sun.proxy.$Proxy87.commit(Unknown Source) ~[?:?] 1634919326262, at org.jooq.impl.LoaderImpl.commit(LoaderImpl.java:914) ~[ms.jar:?] 1634919326262, at org.jooq.impl.LoaderImpl.executeSQL(LoaderImpl.java:902) ~[ms.jar:?] 1634919326262, at org.jooq.impl.LoaderImpl.executeRows(LoaderImpl.java:717) ~[ms.jar:?] 1634919326262, ... 27 more 1634919326262,16:15:26.262 [vert.x-worker-thread-0] INFO AbstractConfig [349846459eqId] ProducerConfig values: