2021-08-26T11:20:06.508Z 11:20:06.508 [vert.x-eventloop-thread-1] INFO LogUtil [185791471eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2021-08-26T11:20:06.511Z 11:20:06.511 [vert.x-eventloop-thread-1] INFO LogUtil [185791474eqId] 127.0.0.1:59718 GET /admin/health null HTTP_1_1 200 4 48 tid=null OK 2021-08-26T11:20:17.565Z 11:20:17.564 [vert.x-eventloop-thread-1] INFO LogUtil [185802527eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2021-08-26T11:20:17.568Z 11:20:17.568 [vert.x-eventloop-thread-1] INFO LogUtil [185802531eqId] 127.0.0.1:59770 GET /admin/health null HTTP_1_1 200 4 49 tid=null OK 2021-08-26T11:20:50.945Z 11:20:50.943 [vert.x-eventloop-thread-1] ERROR ? [185835906eqId] Unhandled exception 2021-08-26T11:20:50.945Z java.lang.NullPointerException: null 2021-08-26T11:20:50.945Z at org.folio.util.pubsub.PubSubClientUtils.lambda$registerEventTypes$3(PubSubClientUtils.java:117) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.ext.web.client.impl.HttpContext.handleFailure(HttpContext.java:350) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.ext.web.client.impl.HttpContext.execute(HttpContext.java:344) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.ext.web.client.impl.HttpContext.next(HttpContext.java:322) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.ext.web.client.impl.HttpContext.fire(HttpContext.java:289) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.ext.web.client.impl.HttpContext.fail(HttpContext.java:270) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.ext.web.client.impl.HttpContext.lambda$handleSendRequest$14(HttpContext.java:570) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.impl.future.FutureImpl$3.onFailure(FutureImpl.java:129) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.impl.future.FutureBase.lambda$emitFailure$1(FutureBase.java:70) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.impl.EventLoopContext.execute(EventLoopContext.java:83) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.impl.ContextImpl.execute(ContextImpl.java:280) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.impl.EventLoopContext.execute(EventLoopContext.java:24) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.impl.future.FutureBase.emitFailure(FutureBase.java:67) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.impl.future.FutureImpl.tryFail(FutureImpl.java:199) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.impl.future.PromiseImpl.tryFail(PromiseImpl.java:23) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.http.impl.HttpClientImpl.lambda$request$8(HttpClientImpl.java:627) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.net.impl.clientconnection.Endpoint.lambda$getConnection$0(Endpoint.java:56) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.net.impl.clientconnection.Pool.connectFailed(Pool.java:389) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.net.impl.clientconnection.Pool.access$600(Pool.java:89) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.net.impl.clientconnection.Pool$Holder.lambda$connect$0(Pool.java:130) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.impl.future.FutureImpl$3.onFailure(FutureImpl.java:129) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.impl.future.FutureBase.emitFailure(FutureBase.java:78) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.impl.future.FutureImpl.tryFail(FutureImpl.java:199) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.impl.future.PromiseImpl.tryFail(PromiseImpl.java:23) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.http.impl.HttpChannelConnector.connectFailed(HttpChannelConnector.java:270) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.http.impl.HttpChannelConnector.lambda$doConnect$0(HttpChannelConnector.java:183) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:577) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:551) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:490) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:615) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.DefaultPromise.setFailure0(DefaultPromise.java:608) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.DefaultPromise.setFailure(DefaultPromise.java:109) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.vertx.core.net.impl.ChannelProvider.lambda$handleConnect$0(ChannelProvider.java:142) ~[ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:577) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:570) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:549) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:490) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:615) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.DefaultPromise.setFailure0(DefaultPromise.java:608) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:117) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe$1.run(AbstractNioChannel.java:263) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.PromiseTask.runTask(PromiseTask.java:98) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:170) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:164) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:472) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:500) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) [ms.jar:?] 2021-08-26T11:20:50.945Z at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?] 2021-08-26T11:20:50.945Z at java.lang.Thread.run(Thread.java:829) [?:?] 2021-08-26T11:20:50.949Z 11:20:50.946 [vert.x-eventloop-thread-1] ERROR ? [185835909eqId] Unhandled exception 2021-08-26T11:20:50.949Z java.lang.NullPointerException: null 2021-08-26T11:20:50.949Z at org.folio.util.pubsub.PubSubClientUtils.lambda$registerEventTypes$3(PubSubClientUtils.java:117) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.ext.web.client.impl.HttpContext.handleFailure(HttpContext.java:350) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.ext.web.client.impl.HttpContext.execute(HttpContext.java:344) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.ext.web.client.impl.HttpContext.next(HttpContext.java:322) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.ext.web.client.impl.HttpContext.fire(HttpContext.java:289) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.ext.web.client.impl.HttpContext.fail(HttpContext.java:270) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.ext.web.client.impl.HttpContext.lambda$handleSendRequest$14(HttpContext.java:570) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.impl.future.FutureImpl$3.onFailure(FutureImpl.java:129) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.impl.future.FutureBase.lambda$emitFailure$1(FutureBase.java:70) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.impl.EventLoopContext.execute(EventLoopContext.java:83) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.impl.ContextImpl.execute(ContextImpl.java:280) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.impl.EventLoopContext.execute(EventLoopContext.java:24) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.impl.future.FutureBase.emitFailure(FutureBase.java:67) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.impl.future.FutureImpl.tryFail(FutureImpl.java:199) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.impl.future.PromiseImpl.tryFail(PromiseImpl.java:23) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.http.impl.HttpClientImpl.lambda$request$8(HttpClientImpl.java:627) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.net.impl.clientconnection.Endpoint.lambda$getConnection$0(Endpoint.java:56) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.net.impl.clientconnection.Pool.connectFailed(Pool.java:389) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.net.impl.clientconnection.Pool.access$600(Pool.java:89) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.net.impl.clientconnection.Pool$Holder.lambda$connect$0(Pool.java:130) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.impl.future.FutureImpl$3.onFailure(FutureImpl.java:129) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.impl.future.FutureBase.emitFailure(FutureBase.java:78) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.impl.future.FutureImpl.tryFail(FutureImpl.java:199) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.impl.future.PromiseImpl.tryFail(PromiseImpl.java:23) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.http.impl.HttpChannelConnector.connectFailed(HttpChannelConnector.java:270) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.http.impl.HttpChannelConnector.lambda$doConnect$0(HttpChannelConnector.java:183) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:577) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:551) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:490) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:615) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.DefaultPromise.setFailure0(DefaultPromise.java:608) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.DefaultPromise.setFailure(DefaultPromise.java:109) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.vertx.core.net.impl.ChannelProvider.lambda$handleConnect$0(ChannelProvider.java:142) ~[ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:577) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:570) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:549) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:490) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:615) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.DefaultPromise.setFailure0(DefaultPromise.java:608) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:117) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe$1.run(AbstractNioChannel.java:263) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.PromiseTask.runTask(PromiseTask.java:98) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:170) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:164) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:472) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:500) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) [ms.jar:?] 2021-08-26T11:20:50.949Z at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?] 2021-08-26T11:20:50.949Z at java.lang.Thread.run(Thread.java:829) [?:?] 2021-08-26T11:21:17.585Z 11:21:17.585 [vert.x-eventloop-thread-1] INFO LogUtil [185862548eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2021-08-26T11:21:17.589Z 11:21:17.589 [vert.x-eventloop-thread-1] INFO LogUtil [185862552eqId] 127.0.0.1:59968 GET /admin/health null HTTP_1_1 200 4 48 tid=null OK 2021-08-26T11:20:36.534Z 11:20:36.534 [vert.x-eventloop-thread-1] INFO LogUtil [185821497eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2021-08-26T11:20:36.538Z 11:20:36.537 [vert.x-eventloop-thread-1] INFO LogUtil [185821500eqId] 127.0.0.1:59816 GET /admin/health null HTTP_1_1 200 4 48 tid=null OK 2021-08-26T11:20:39.563Z 11:20:39.563 [vert.x-eventloop-thread-1] INFO PostgresClient [185824526eqId] Executing multiple statements with id -1387371567 2021-08-26T11:20:39.565Z 11:20:39.564 [vert.x-eventloop-thread-1] INFO PostgresClient [185824527eqId] trying to execute: {} ALTER ROLE fs00001019_mod_source_record_storage SET search_path = "$user"; 2021-08-26T11:20:39.566Z 11:20:39.566 [vert.x-eventloop-thread-1] INFO PostgresClient [185824529eqId] Successfully executed ALTER ROLE fs00001019_mod_source_record_storage SET search_path = "$user"; 2021-08-26T11:20:39.566Z 11:20:39.566 [vert.x-eventloop-thread-1] INFO PostgresClient [185824529eqId] trying to execute: {} DO $$ 2021-08-26T11:20:39.566Z BEGIN 2021-08-26T11:20:39.566Z BEGIN 2021-08-26T11:20:39.566Z -- This only succeeds if show_trgm, a pg_trgm function, 2021-08-26T11:20:39.566Z -- has been loaded into public schema. 2021-08-26T11:20:39.566Z PERFORM public.show_trgm('a'); 2021-08-26T11:20:39.566Z EXCEPTION 2021-08-26T11:20:39.566Z WHEN undefined_function THEN 2021-08-26T11:20:39.566Z BEGIN 2021-08-26T11:20:39.566Z ALTER EXTENSION pg_trgm SET SCHEMA public; 2021-08-26T11:20:39.566Z EXCEPTION 2021-08-26T11:20:39.566Z WHEN undefined_object THEN NULL; 2021-08-26T11:20:39.566Z END; 2021-08-26T11:20:39.566Z END; 2021-08-26T11:20:39.566Z END $$; 2021-08-26T11:20:39.568Z 11:20:39.568 [vert.x-eventloop-thread-1] INFO PostgresClient [185824531eqId] Successfully executed DO $$ 2021-08-26T11:20:39.568Z BEGIN 2021-08-26T11:20:39.568Z BEGIN 2021-08-26T11:20:39.568Z -- This only succeeds if show_trgm, a pg_trgm function, 2021-08-26T11:20:39.568Z -- has been loaded into public schema. 2021-08-26T11:20:39.568Z PERFORM public.show_trgm('a'); 2021-08-26T11:20:39.568Z EXCEPTION 2021-08-26T11:20:39.568Z WHEN undefined_function THEN 2021-08-26T11:20:39.568Z BEGIN 2021-08-26T11:20:39.568Z ALTER EXTENSION pg_trgm SET SCHEMA public; 2021-08-26T11:20:39.568Z EXCEPTION 2021-08-26T11:20:39.568Z WHEN undefined_object THEN NULL; 2021-08-26T11:20:39.568Z END; 2021-08-26T11:20:39.568Z END; 2021-08-26T11:20:39.568Z END $$; 2021-08-26T11:20:39.569Z 11:20:39.569 [vert.x-eventloop-thread-1] INFO PostgresClient [185824532eqId] trying to execute: {} CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public; 2021-08-26T11:20:39.571Z 11:20:39.570 [vert.x-eventloop-thread-1] WARN ? [185824533eqId] Backend notice: severity='NOTICE', code='42710', message='extension "unaccent" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='extension.c', line='1669', routine='CreateExtension', schema='null', table='null', column='null', dataType='null', constraint='null' 2021-08-26T11:20:39.572Z 11:20:39.571 [vert.x-eventloop-thread-1] INFO PostgresClient [185824534eqId] Successfully executed CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public; 2021-08-26T11:20:39.572Z 11:20:39.572 [vert.x-eventloop-thread-1] INFO PostgresClient [185824535eqId] trying to execute: {} CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public; 2021-08-26T11:20:39.573Z 11:20:39.573 [vert.x-eventloop-thread-1] WARN ? [185824536eqId] Backend notice: severity='NOTICE', code='42710', message='extension "pg_trgm" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='extension.c', line='1669', routine='CreateExtension', schema='null', table='null', column='null', dataType='null', constraint='null' 2021-08-26T11:20:39.574Z 11:20:39.573 [vert.x-eventloop-thread-1] INFO PostgresClient [185824536eqId] Successfully executed CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public; 2021-08-26T11:20:39.574Z 11:20:39.574 [vert.x-eventloop-thread-1] INFO PostgresClient [185824537eqId] trying to execute: {} CREATE TABLE IF NOT EXISTS fs00001019_mod_source_record_storage.rmb_job ( id UUID PRIMARY KEY, jsonb JSONB NOT NULL ); 2021-08-26T11:20:39.575Z 11:20:39.575 [vert.x-eventloop-thread-1] WARN ? [185824538eqId] Backend notice: severity='NOTICE', code='42P07', message='relation "rmb_job" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='parse_utilcmd.c', line='209', routine='transformCreateStmt', schema='null', table='null', column='null', dataType='null', constraint='null' 2021-08-26T11:20:39.576Z 11:20:39.576 [vert.x-eventloop-thread-1] INFO PostgresClient [185824539eqId] Successfully executed CREATE TABLE IF NOT EXISTS fs00001019_mod_source_record_storage.rmb_job ( id UUID PRIMARY KEY, jsonb JSONB NOT NULL ); 2021-08-26T11:20:39.582Z 11:20:39.582 [vert.x-eventloop-thread-1] INFO LogUtil [185824545eqId] org.folio.rest.RestVerticle start invoking postTenant 2021-08-26T11:20:39.586Z 11:20:39.586 [vert.x-eventloop-thread-1] INFO LogUtil [185824549eqId] 127.0.0.1:59824 POST /_/tenant null HTTP_1_1 201 348 55 tid=fs00001019 Created 2021-08-26T11:20:39.605Z 11:20:39.605 [vert.x-eventloop-thread-1] INFO PostgresClient [185824568eqId] Executing multiple statements with id -593984378 2021-08-26T11:20:39.607Z 11:20:39.606 [vert.x-eventloop-thread-1] INFO PostgresClient [185824569eqId] trying to execute: {} SET search_path TO fs00001019_mod_source_record_storage; 2021-08-26T11:20:39.607Z 11:20:39.607 [vert.x-eventloop-thread-1] INFO PostgresClient [185824570eqId] Successfully executed SET search_path TO fs00001019_mod_source_record_storage; 2021-08-26T11:20:39.608Z 11:20:39.608 [vert.x-eventloop-thread-1] INFO PostgresClient [185824571eqId] trying to execute: {} CREATE TABLE IF NOT EXISTS fs00001019_mod_source_record_storage.rmb_internal_index ( name text PRIMARY KEY, def text NOT NULL, remove boolean NOT NULL ); 2021-08-26T11:20:39.609Z 11:20:39.609 [vert.x-eventloop-thread-1] WARN ? [185824572eqId] Backend notice: severity='NOTICE', code='42P07', message='relation "rmb_internal_index" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='parse_utilcmd.c', line='209', routine='transformCreateStmt', schema='null', table='null', column='null', dataType='null', constraint='null' 2021-08-26T11:20:39.610Z 11:20:39.610 [vert.x-eventloop-thread-1] INFO PostgresClient [185824573eqId] Successfully executed CREATE TABLE IF NOT EXISTS fs00001019_mod_source_record_storage.rmb_internal_index ( name text PRIMARY KEY, def text NOT NULL, remove boolean NOT NULL ); 2021-08-26T11:20:39.610Z 11:20:39.610 [vert.x-eventloop-thread-1] INFO PostgresClient [185824573eqId] trying to execute: {} UPDATE fs00001019_mod_source_record_storage.rmb_internal_index SET remove = TRUE; 2021-08-26T11:20:39.611Z 11:20:39.611 [vert.x-eventloop-thread-1] INFO PostgresClient [185824574eqId] Successfully executed UPDATE fs00001019_mod_source_record_storage.rmb_internal_index SET remove = TRUE; 2021-08-26T11:20:39.611Z 11:20:39.611 [vert.x-eventloop-thread-1] INFO PostgresClient [185824574eqId] trying to execute: {} CREATE TABLE IF NOT EXISTS rmb_internal_analyze ( tablename text ); 2021-08-26T11:20:39.613Z 11:20:39.612 [vert.x-eventloop-thread-1] WARN ? [185824575eqId] Backend notice: severity='NOTICE', code='42P07', message='relation "rmb_internal_analyze" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='parse_utilcmd.c', line='209', routine='transformCreateStmt', schema='null', table='null', column='null', dataType='null', constraint='null' 2021-08-26T11:20:39.613Z 11:20:39.613 [vert.x-eventloop-thread-1] INFO PostgresClient [185824576eqId] Successfully executed CREATE TABLE IF NOT EXISTS rmb_internal_analyze ( tablename text ); 2021-08-26T11:20:39.613Z 11:20:39.613 [vert.x-eventloop-thread-1] INFO PostgresClient [185824576eqId] trying to execute: {} DROP FUNCTION IF EXISTS fs00001019_mod_source_record_storage.count_estimate_smart2(bigint,bigint,text); 2021-08-26T11:20:39.615Z 11:20:39.615 [vert.x-eventloop-thread-1] INFO PostgresClient [185824578eqId] Successfully executed DROP FUNCTION IF EXISTS fs00001019_mod_source_record_storage.count_estimate_smart2(bigint,bigint,text); 2021-08-26T11:20:39.615Z 11:20:39.615 [vert.x-eventloop-thread-1] INFO PostgresClient [185824578eqId] trying to execute: {} CREATE FUNCTION fs00001019_mod_source_record_storage.count_estimate_smart2(rows bigint, lim bigint, query text) RETURNS bigint AS $$ 2021-08-26T11:20:39.615Z DECLARE 2021-08-26T11:20:39.615Z rec record; 2021-08-26T11:20:39.615Z cnt bigint; 2021-08-26T11:20:39.615Z BEGIN 2021-08-26T11:20:39.615Z IF rows = lim THEN 2021-08-26T11:20:39.615Z FOR rec IN EXECUTE 'EXPLAIN ' || query LOOP 2021-08-26T11:20:39.615Z cnt := substring(rec."QUERY PLAN" FROM ' rows=([[:digit:]]+)'); 2021-08-26T11:20:39.615Z EXIT WHEN cnt IS NOT NULL; 2021-08-26T11:20:39.615Z END LOOP; 2021-08-26T11:20:39.615Z RETURN cnt; 2021-08-26T11:20:39.615Z END IF; 2021-08-26T11:20:39.615Z RETURN rows; 2021-08-26T11:20:39.615Z END; 2021-08-26T11:20:39.615Z $$ LANGUAGE plpgsql VOLATILE STRICT; 2021-08-26T11:20:39.617Z 11:20:39.617 [vert.x-eventloop-thread-1] INFO PostgresClient [185824580eqId] Successfully executed CREATE FUNCTION fs00001019_mod_source_record_storage.count_estimate_smart2(rows bigint, lim bigint, query text) RETURNS bigint AS $$ 2021-08-26T11:20:39.617Z DECLARE 2021-08-26T11:20:39.617Z rec record; 2021-08-26T11:20:39.617Z cnt bigint; 2021-08-26T11:20:39.617Z BEGIN 2021-08-26T11:20:39.617Z IF rows = lim THEN 2021-08-26T11:20:39.617Z FOR rec IN EXECUTE 'EXPLAIN ' || query LOOP 2021-08-26T11:20:39.617Z cnt := substring(rec."QUERY PLAN" FROM ' rows=([[:digit:]]+)'); 2021-08-26T11:20:39.617Z EXIT WHEN cnt IS NOT NULL; 2021-08-26T11:20:39.617Z END LOOP; 2021-08-26T11:20:39.617Z RETURN cnt; 2021-08-26T11:20:39.617Z END IF; 2021-08-26T11:20:39.617Z RETURN rows; 2021-08-26T11:20:39.617Z END; 2021-08-26T11:20:39.617Z $$ LANGUAGE plpgsql VOLATILE STRICT; 2021-08-26T11:20:39.617Z 11:20:39.617 [vert.x-eventloop-thread-1] INFO PostgresClient [185824580eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.count_estimate_default(query text) RETURNS bigint AS $$ 2021-08-26T11:20:39.617Z DECLARE 2021-08-26T11:20:39.617Z rows bigint; 2021-08-26T11:20:39.617Z q text; 2021-08-26T11:20:39.617Z BEGIN 2021-08-26T11:20:39.617Z q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x'; 2021-08-26T11:20:39.617Z EXECUTE q INTO rows; 2021-08-26T11:20:39.617Z IF rows < 1000 THEN 2021-08-26T11:20:39.617Z return rows; 2021-08-26T11:20:39.617Z END IF; 2021-08-26T11:20:39.617Z rows = fs00001019_mod_source_record_storage.count_estimate_smart2(1000, 1000, query); 2021-08-26T11:20:39.617Z IF rows < 1000 THEN 2021-08-26T11:20:39.617Z return 1000; 2021-08-26T11:20:39.617Z END IF; 2021-08-26T11:20:39.617Z RETURN rows; 2021-08-26T11:20:39.617Z END; 2021-08-26T11:20:39.617Z $$ LANGUAGE plpgsql IMMUTABLE STRICT; 2021-08-26T11:20:39.618Z 11:20:39.618 [vert.x-eventloop-thread-1] INFO PostgresClient [185824581eqId] Successfully executed CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.count_estimate_default(query text) RETURNS bigint AS $$ 2021-08-26T11:20:39.618Z DECLARE 2021-08-26T11:20:39.618Z rows bigint; 2021-08-26T11:20:39.618Z q text; 2021-08-26T11:20:39.618Z BEGIN 2021-08-26T11:20:39.618Z q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x'; 2021-08-26T11:20:39.618Z EXECUTE q INTO rows; 2021-08-26T11:20:39.618Z IF rows < 1000 THEN 2021-08-26T11:20:39.618Z return rows; 2021-08-26T11:20:39.618Z END IF; 2021-08-26T11:20:39.618Z rows = fs00001019_mod_source_record_storage.count_estimate_smart2(1000, 1000, query); 2021-08-26T11:20:39.618Z IF rows < 1000 THEN 2021-08-26T11:20:39.618Z return 1000; 2021-08-26T11:20:39.618Z END IF; 2021-08-26T11:20:39.618Z RETURN rows; 2021-08-26T11:20:39.618Z END; 2021-08-26T11:20:39.618Z $$ LANGUAGE plpgsql IMMUTABLE STRICT; 2021-08-26T11:20:39.619Z 11:20:39.619 [vert.x-eventloop-thread-1] INFO PostgresClient [185824582eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.count_estimate(query text) RETURNS bigint AS $$ 2021-08-26T11:20:39.619Z DECLARE 2021-08-26T11:20:39.619Z count bigint; 2021-08-26T11:20:39.619Z est_count bigint; 2021-08-26T11:20:39.619Z q text; 2021-08-26T11:20:39.619Z BEGIN 2021-08-26T11:20:39.619Z est_count = fs00001019_mod_source_record_storage.count_estimate_smart2(1000, 1000, query); 2021-08-26T11:20:39.619Z IF est_count > 4*1000 THEN 2021-08-26T11:20:39.619Z RETURN est_count; 2021-08-26T11:20:39.619Z END IF; 2021-08-26T11:20:39.619Z q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x'; 2021-08-26T11:20:39.619Z EXECUTE q INTO count; 2021-08-26T11:20:39.619Z IF count < 1000 THEN 2021-08-26T11:20:39.619Z RETURN count; 2021-08-26T11:20:39.619Z END IF; 2021-08-26T11:20:39.619Z IF est_count < 1000 THEN 2021-08-26T11:20:39.619Z RETURN 1000; 2021-08-26T11:20:39.619Z END IF; 2021-08-26T11:20:39.619Z RETURN est_count; 2021-08-26T11:20:39.619Z END; 2021-08-26T11:20:39.619Z $$ LANGUAGE plpgsql STABLE STRICT; 2021-08-26T11:20:39.620Z 11:20:39.620 [vert.x-eventloop-thread-1] INFO PostgresClient [185824583eqId] Successfully executed CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.count_estimate(query text) RETURNS bigint AS $$ 2021-08-26T11:20:39.620Z DECLARE 2021-08-26T11:20:39.620Z count bigint; 2021-08-26T11:20:39.620Z est_count bigint; 2021-08-26T11:20:39.620Z q text; 2021-08-26T11:20:39.620Z BEGIN 2021-08-26T11:20:39.620Z est_count = fs00001019_mod_source_record_storage.count_estimate_smart2(1000, 1000, query); 2021-08-26T11:20:39.620Z IF est_count > 4*1000 THEN 2021-08-26T11:20:39.620Z RETURN est_count; 2021-08-26T11:20:39.620Z END IF; 2021-08-26T11:20:39.620Z q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x'; 2021-08-26T11:20:39.620Z EXECUTE q INTO count; 2021-08-26T11:20:39.620Z IF count < 1000 THEN 2021-08-26T11:20:39.620Z RETURN count; 2021-08-26T11:20:39.620Z END IF; 2021-08-26T11:20:39.620Z IF est_count < 1000 THEN 2021-08-26T11:20:39.620Z RETURN 1000; 2021-08-26T11:20:39.620Z END IF; 2021-08-26T11:20:39.620Z RETURN est_count; 2021-08-26T11:20:39.620Z END; 2021-08-26T11:20:39.620Z $$ LANGUAGE plpgsql STABLE STRICT; 2021-08-26T11:20:39.621Z 11:20:39.621 [vert.x-eventloop-thread-1] INFO PostgresClient [185824584eqId] trying to execute: {} DO $$ 2021-08-26T11:20:39.621Z DECLARE ver integer; 2021-08-26T11:20:39.621Z BEGIN 2021-08-26T11:20:39.621Z SELECT current_setting('server_version_num') INTO ver; 2021-08-26T11:20:39.621Z IF (ver >= 120000) THEN 2021-08-26T11:20:39.621Z CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.f_unaccent(text) 2021-08-26T11:20:39.621Z RETURNS text AS 2021-08-26T11:20:39.621Z $f_unaccent$ 2021-08-26T11:20:39.621Z SELECT public.unaccent('public.unaccent', $1) -- schema-qualify function and dictionary 2021-08-26T11:20:39.621Z $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.621Z ELSE 2021-08-26T11:20:39.621Z CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.f_unaccent(text) 2021-08-26T11:20:39.621Z RETURNS text AS 2021-08-26T11:20:39.621Z $f_unaccent$ 2021-08-26T11:20:39.621Z SELECT regexp_replace(public.unaccent('public.unaccent', $1), 2021-08-26T11:20:39.621Z E'[\u0300\u0301\u0302\u0303\u0304\u0305\u0306\u0307\u0308\u0309\u030a\u030b\u030c\u030d\u030e\u030f' || 2021-08-26T11:20:39.621Z E'\u0310\u0311\u0312\u0313\u0314\u0315\u0316\u0317\u0318\u0319\u031a\u031b\u031c\u031d\u031e\u031f' || 2021-08-26T11:20:39.621Z E'\u0320\u0321\u0322\u0323\u0324\u0325\u0326\u0327\u0328\u0329\u032a\u032b\u032c\u032d\u032e\u032f' || 2021-08-26T11:20:39.621Z E'\u0330\u0331\u0332\u0333\u0334\u0335\u0336\u0337\u0338\u0339\u033a\u033b\u033c\u033d\u033e\u033f' || 2021-08-26T11:20:39.621Z E'\u0340\u0341\u0342\u0343\u0344\u0345\u0346\u0347\u0348\u0349\u034a\u034b\u034c\u034d\u034e\u034f' || 2021-08-26T11:20:39.621Z E'\u0350\u0351\u0352\u0353\u0354\u0355\u0356\u0357\u0358\u0359\u035a\u035b\u035c\u035d\u035e\u035f' || 2021-08-26T11:20:39.621Z E'\u0360\u0361\u0362' || 2021-08-26T11:20:39.621Z E'\u20dd\u20de\u20df\u20e0' || 2021-08-26T11:20:39.621Z E'\u20e2\u20e3\u20e4]', 2021-08-26T11:20:39.621Z '', 2021-08-26T11:20:39.621Z 'g') 2021-08-26T11:20:39.621Z $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.621Z END IF; 2021-08-26T11:20:39.621Z END 2021-08-26T11:20:39.621Z $$; 2021-08-26T11:20:39.622Z 11:20:39.622 [vert.x-eventloop-thread-1] INFO PostgresClient [185824585eqId] Successfully executed DO $$ 2021-08-26T11:20:39.622Z DECLARE ver integer; 2021-08-26T11:20:39.622Z BEGIN 2021-08-26T11:20:39.622Z SELECT current_setting('server_version_num') INTO ver; 2021-08-26T11:20:39.622Z IF (ver >= 120000) THEN 2021-08-26T11:20:39.622Z CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.f_unaccent(text) 2021-08-26T11:20:39.622Z RETURNS text AS 2021-08-26T11:20:39.622Z $f_unaccent$ 2021-08-26T11:20:39.622Z SELECT public.unaccent('public.unaccent', $1) -- schema-qualify function and dictionary 2021-08-26T11:20:39.622Z $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.622Z ELSE 2021-08-26T11:20:39.622Z CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.f_unaccent(text) 2021-08-26T11:20:39.622Z RETURNS text AS 2021-08-26T11:20:39.622Z $f_unaccent$ 2021-08-26T11:20:39.622Z SELECT regexp_replace(public.unaccent('public.unaccent', $1), 2021-08-26T11:20:39.622Z E'[\u0300\u0301\u0302\u0303\u0304\u0305\u0306\u0307\u0308\u0309\u030a\u030b\u030c\u030d\u030e\u030f' || 2021-08-26T11:20:39.622Z E'\u0310\u0311\u0312\u0313\u0314\u0315\u0316\u0317\u0318\u0319\u031a\u031b\u031c\u031d\u031e\u031f' || 2021-08-26T11:20:39.622Z E'\u0320\u0321\u0322\u0323\u0324\u0325\u0326\u0327\u0328\u0329\u032a\u032b\u032c\u032d\u032e\u032f' || 2021-08-26T11:20:39.622Z E'\u0330\u0331\u0332\u0333\u0334\u0335\u0336\u0337\u0338\u0339\u033a\u033b\u033c\u033d\u033e\u033f' || 2021-08-26T11:20:39.622Z E'\u0340\u0341\u0342\u0343\u0344\u0345\u0346\u0347\u0348\u0349\u034a\u034b\u034c\u034d\u034e\u034f' || 2021-08-26T11:20:39.622Z E'\u0350\u0351\u0352\u0353\u0354\u0355\u0356\u0357\u0358\u0359\u035a\u035b\u035c\u035d\u035e\u035f' || 2021-08-26T11:20:39.622Z E'\u0360\u0361\u0362' || 2021-08-26T11:20:39.622Z E'\u20dd\u20de\u20df\u20e0' || 2021-08-26T11:20:39.622Z E'\u20e2\u20e3\u20e4]', 2021-08-26T11:20:39.622Z '', 2021-08-26T11:20:39.622Z 'g') 2021-08-26T11:20:39.622Z $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.622Z END IF; 2021-08-26T11:20:39.622Z END 2021-08-26T11:20:39.622Z $$; 2021-08-26T11:20:39.623Z 11:20:39.623 [vert.x-eventloop-thread-1] INFO PostgresClient [185824586eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.get_tsvector(text) RETURNS tsvector AS $$ 2021-08-26T11:20:39.623Z SELECT to_tsvector('simple', translate($1, '&', ',')); 2021-08-26T11:20:39.623Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.624Z 11:20:39.624 [vert.x-eventloop-thread-1] INFO PostgresClient [185824587eqId] Successfully executed CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.get_tsvector(text) RETURNS tsvector AS $$ 2021-08-26T11:20:39.624Z SELECT to_tsvector('simple', translate($1, '&', ',')); 2021-08-26T11:20:39.624Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.625Z 11:20:39.625 [vert.x-eventloop-thread-1] INFO PostgresClient [185824588eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.tsquery_and(text) RETURNS tsquery AS $$ 2021-08-26T11:20:39.625Z SELECT to_tsquery('simple', string_agg(CASE WHEN length(v) = 0 OR v = '*' THEN '' 2021-08-26T11:20:39.625Z WHEN right(v, 1) = '*' THEN '''' || left(v, -1) || ''':*' 2021-08-26T11:20:39.625Z ELSE '''' || v || '''' END, 2021-08-26T11:20:39.625Z '&')) 2021-08-26T11:20:39.625Z FROM (SELECT regexp_split_to_table(translate($1, '&''', ',,'), ' +')) AS x(v); 2021-08-26T11:20:39.625Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.627Z 11:20:39.627 [vert.x-eventloop-thread-1] INFO PostgresClient [185824590eqId] Successfully executed CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.tsquery_and(text) RETURNS tsquery AS $$ 2021-08-26T11:20:39.627Z SELECT to_tsquery('simple', string_agg(CASE WHEN length(v) = 0 OR v = '*' THEN '' 2021-08-26T11:20:39.627Z WHEN right(v, 1) = '*' THEN '''' || left(v, -1) || ''':*' 2021-08-26T11:20:39.627Z ELSE '''' || v || '''' END, 2021-08-26T11:20:39.627Z '&')) 2021-08-26T11:20:39.627Z FROM (SELECT regexp_split_to_table(translate($1, '&''', ',,'), ' +')) AS x(v); 2021-08-26T11:20:39.627Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.627Z 11:20:39.627 [vert.x-eventloop-thread-1] INFO PostgresClient [185824590eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.tsquery_or(text) RETURNS tsquery AS $$ 2021-08-26T11:20:39.627Z SELECT replace(fs00001019_mod_source_record_storage.tsquery_and($1)::text, '&', '|')::tsquery; 2021-08-26T11:20:39.627Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.628Z 11:20:39.628 [vert.x-eventloop-thread-1] INFO PostgresClient [185824591eqId] Successfully executed CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.tsquery_or(text) RETURNS tsquery AS $$ 2021-08-26T11:20:39.628Z SELECT replace(fs00001019_mod_source_record_storage.tsquery_and($1)::text, '&', '|')::tsquery; 2021-08-26T11:20:39.628Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.629Z 11:20:39.629 [vert.x-eventloop-thread-1] INFO PostgresClient [185824592eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.tsquery_phrase(text) RETURNS tsquery AS $$ 2021-08-26T11:20:39.629Z SELECT replace(fs00001019_mod_source_record_storage.tsquery_and($1)::text, '&', '<->')::tsquery; 2021-08-26T11:20:39.629Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.630Z 11:20:39.630 [vert.x-eventloop-thread-1] INFO PostgresClient [185824593eqId] Successfully executed CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.tsquery_phrase(text) RETURNS tsquery AS $$ 2021-08-26T11:20:39.630Z SELECT replace(fs00001019_mod_source_record_storage.tsquery_and($1)::text, '&', '<->')::tsquery; 2021-08-26T11:20:39.630Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.631Z 11:20:39.631 [vert.x-eventloop-thread-1] INFO PostgresClient [185824594eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.normalize_digits(text) RETURNS text AS $$ 2021-08-26T11:20:39.631Z SELECT translate((regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1], E' \t-', '') 2021-08-26T11:20:39.631Z || CASE WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1] = '' THEN '' 2021-08-26T11:20:39.631Z WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2] = '' THEN '' 2021-08-26T11:20:39.631Z ELSE ' ' 2021-08-26T11:20:39.631Z END 2021-08-26T11:20:39.631Z || (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2]; 2021-08-26T11:20:39.631Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.632Z 11:20:39.632 [vert.x-eventloop-thread-1] INFO PostgresClient [185824595eqId] Successfully executed CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.normalize_digits(text) RETURNS text AS $$ 2021-08-26T11:20:39.632Z SELECT translate((regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1], E' \t-', '') 2021-08-26T11:20:39.632Z || CASE WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1] = '' THEN '' 2021-08-26T11:20:39.632Z WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2] = '' THEN '' 2021-08-26T11:20:39.632Z ELSE ' ' 2021-08-26T11:20:39.632Z END 2021-08-26T11:20:39.632Z || (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2]; 2021-08-26T11:20:39.632Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.632Z 11:20:39.632 [vert.x-eventloop-thread-1] INFO PostgresClient [185824595eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.set_id_in_jsonb() RETURNS TRIGGER AS $$ 2021-08-26T11:20:39.632Z BEGIN 2021-08-26T11:20:39.632Z NEW.jsonb = jsonb_set(NEW.jsonb, '{id}', to_jsonb(NEW.id)); 2021-08-26T11:20:39.632Z RETURN NEW; 2021-08-26T11:20:39.632Z END; 2021-08-26T11:20:39.632Z $$ language 'plpgsql'; 2021-08-26T11:20:39.633Z 11:20:39.633 [vert.x-eventloop-thread-1] INFO PostgresClient [185824596eqId] Successfully executed CREATE OR REPLACE FUNCTION fs00001019_mod_source_record_storage.set_id_in_jsonb() RETURNS TRIGGER AS $$ 2021-08-26T11:20:39.633Z BEGIN 2021-08-26T11:20:39.633Z NEW.jsonb = jsonb_set(NEW.jsonb, '{id}', to_jsonb(NEW.id)); 2021-08-26T11:20:39.633Z RETURN NEW; 2021-08-26T11:20:39.633Z END; 2021-08-26T11:20:39.633Z $$ language 'plpgsql'; 2021-08-26T11:20:39.634Z 11:20:39.634 [vert.x-eventloop-thread-1] INFO PostgresClient [185824597eqId] trying to execute: {} create or replace function fs00001019_mod_source_record_storage.concat_space_sql(VARIADIC text[]) RETURNS text AS $$ select concat_ws(' ', VARIADIC $1); 2021-08-26T11:20:39.634Z $$ LANGUAGE SQL IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.635Z 11:20:39.635 [vert.x-eventloop-thread-1] INFO PostgresClient [185824598eqId] Successfully executed create or replace function fs00001019_mod_source_record_storage.concat_space_sql(VARIADIC text[]) RETURNS text AS $$ select concat_ws(' ', VARIADIC $1); 2021-08-26T11:20:39.635Z $$ LANGUAGE SQL IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.635Z 11:20:39.635 [vert.x-eventloop-thread-1] INFO PostgresClient [185824598eqId] trying to execute: {} create or replace function fs00001019_mod_source_record_storage.concat_array_object_values(jsonb_array jsonb, field text) RETURNS text AS $$ 2021-08-26T11:20:39.635Z SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1); 2021-08-26T11:20:39.635Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.636Z 11:20:39.636 [vert.x-eventloop-thread-1] INFO PostgresClient [185824599eqId] Successfully executed create or replace function fs00001019_mod_source_record_storage.concat_array_object_values(jsonb_array jsonb, field text) RETURNS text AS $$ 2021-08-26T11:20:39.636Z SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1); 2021-08-26T11:20:39.636Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.637Z 11:20:39.637 [vert.x-eventloop-thread-1] INFO PostgresClient [185824600eqId] trying to execute: {} create or replace function fs00001019_mod_source_record_storage.concat_array_object_values( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$ 2021-08-26T11:20:39.637Z SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1) WHERE value->>$3 = $4; 2021-08-26T11:20:39.637Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.638Z 11:20:39.638 [vert.x-eventloop-thread-1] INFO PostgresClient [185824601eqId] Successfully executed create or replace function fs00001019_mod_source_record_storage.concat_array_object_values( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$ 2021-08-26T11:20:39.638Z SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1) WHERE value->>$3 = $4; 2021-08-26T11:20:39.638Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.639Z 11:20:39.639 [vert.x-eventloop-thread-1] INFO PostgresClient [185824602eqId] trying to execute: {} create or replace function fs00001019_mod_source_record_storage.first_array_object_value( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$ 2021-08-26T11:20:39.639Z SELECT value->>$2 FROM jsonb_array_elements($1) WHERE value->>$3 = $4 LIMIT 1; 2021-08-26T11:20:39.639Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.640Z 11:20:39.640 [vert.x-eventloop-thread-1] INFO PostgresClient [185824603eqId] Successfully executed create or replace function fs00001019_mod_source_record_storage.first_array_object_value( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$ 2021-08-26T11:20:39.640Z SELECT value->>$2 FROM jsonb_array_elements($1) WHERE value->>$3 = $4 LIMIT 1; 2021-08-26T11:20:39.640Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.640Z 11:20:39.640 [vert.x-eventloop-thread-1] INFO PostgresClient [185824603eqId] trying to execute: {} create or replace function fs00001019_mod_source_record_storage.concat_array_object(jsonb_array jsonb) RETURNS text AS $$ 2021-08-26T11:20:39.640Z SELECT string_agg(value::text, ' ') FROM jsonb_array_elements_text($1); 2021-08-26T11:20:39.640Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.641Z 11:20:39.641 [vert.x-eventloop-thread-1] INFO PostgresClient [185824604eqId] Successfully executed create or replace function fs00001019_mod_source_record_storage.concat_array_object(jsonb_array jsonb) RETURNS text AS $$ 2021-08-26T11:20:39.641Z SELECT string_agg(value::text, ' ') FROM jsonb_array_elements_text($1); 2021-08-26T11:20:39.641Z $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 2021-08-26T11:20:39.642Z 11:20:39.642 [vert.x-eventloop-thread-1] INFO PostgresClient [185824605eqId] trying to execute: {} DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text); 2021-08-26T11:20:39.643Z 11:20:39.643 [vert.x-eventloop-thread-1] WARN ? [185824606eqId] Backend notice: severity='NOTICE', code='00000', message='function rmb_internal_index(text,text,text) does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 2021-08-26T11:20:39.644Z 11:20:39.643 [vert.x-eventloop-thread-1] INFO PostgresClient [185824606eqId] Successfully executed DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text); 2021-08-26T11:20:39.644Z 11:20:39.644 [vert.x-eventloop-thread-1] INFO PostgresClient [185824607eqId] trying to execute: {} CREATE OR REPLACE FUNCTION rmb_internal_index( atable text, aname text, tops text, newdef text) RETURNS void AS $$ 2021-08-26T11:20:39.644Z DECLARE 2021-08-26T11:20:39.644Z olddef text; 2021-08-26T11:20:39.644Z namep CONSTANT text = concat(aname, '_p'); 2021-08-26T11:20:39.644Z prepareddef text; 2021-08-26T11:20:39.644Z BEGIN 2021-08-26T11:20:39.644Z IF tops = 'DELETE' THEN 2021-08-26T11:20:39.644Z -- use case insensitive %s, not case sensitive %I 2021-08-26T11:20:39.644Z -- no SQL injection because the names are hard-coded in schema.json 2021-08-26T11:20:39.644Z EXECUTE format('DROP INDEX IF EXISTS %s', aname); 2021-08-26T11:20:39.644Z EXECUTE 'DELETE FROM fs00001019_mod_source_record_storage.rmb_internal_index WHERE name = $1' USING aname; 2021-08-26T11:20:39.644Z RETURN; 2021-08-26T11:20:39.644Z END IF; 2021-08-26T11:20:39.644Z SELECT def INTO olddef FROM fs00001019_mod_source_record_storage.rmb_internal_index WHERE name = aname; 2021-08-26T11:20:39.644Z SELECT def INTO prepareddef FROM fs00001019_mod_source_record_storage.rmb_internal_index WHERE name = namep; 2021-08-26T11:20:39.644Z prepareddef = replace(prepareddef, concat(' ', namep, ' ON '), concat(' ', aname, ' ON ')); 2021-08-26T11:20:39.644Z IF prepareddef = newdef THEN 2021-08-26T11:20:39.644Z EXECUTE format('DROP INDEX IF EXISTS %s', aname); 2021-08-26T11:20:39.644Z EXECUTE format('ALTER INDEX IF EXISTS %s RENAME TO %s', namep, aname); 2021-08-26T11:20:39.644Z EXECUTE 'DELETE FROM rmb_internal_index WHERE name = $1' USING namep; 2021-08-26T11:20:39.644Z EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable; 2021-08-26T11:20:39.644Z ELSIF olddef IS DISTINCT FROM newdef THEN 2021-08-26T11:20:39.644Z EXECUTE format('DROP INDEX IF EXISTS %s', aname); 2021-08-26T11:20:39.644Z EXECUTE newdef; 2021-08-26T11:20:39.644Z EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable; 2021-08-26T11:20:39.644Z END IF; 2021-08-26T11:20:39.644Z EXECUTE 'INSERT INTO fs00001019_mod_source_record_storage.rmb_internal_index VALUES ($1, $2, FALSE) ' 2021-08-26T11:20:39.644Z 'ON CONFLICT (name) DO UPDATE SET def = EXCLUDED.def, remove = EXCLUDED.remove' USING aname, newdef; 2021-08-26T11:20:39.644Z END 2021-08-26T11:20:39.644Z $$ LANGUAGE plpgsql; 2021-08-26T11:20:39.645Z 11:20:39.645 [vert.x-eventloop-thread-1] INFO PostgresClient [185824608eqId] Successfully executed CREATE OR REPLACE FUNCTION rmb_internal_index( atable text, aname text, tops text, newdef text) RETURNS void AS $$ 2021-08-26T11:20:39.645Z DECLARE 2021-08-26T11:20:39.645Z olddef text; 2021-08-26T11:20:39.645Z namep CONSTANT text = concat(aname, '_p'); 2021-08-26T11:20:39.645Z prepareddef text; 2021-08-26T11:20:39.645Z BEGIN 2021-08-26T11:20:39.645Z IF tops = 'DELETE' THEN 2021-08-26T11:20:39.645Z -- use case insensitive %s, not case sensitive %I 2021-08-26T11:20:39.645Z -- no SQL injection because the names are hard-coded in schema.json 2021-08-26T11:20:39.645Z EXECUTE format('DROP INDEX IF EXISTS %s', aname); 2021-08-26T11:20:39.645Z EXECUTE 'DELETE FROM fs00001019_mod_source_record_storage.rmb_internal_index WHERE name = $1' USING aname; 2021-08-26T11:20:39.645Z RETURN; 2021-08-26T11:20:39.645Z END IF; 2021-08-26T11:20:39.645Z SELECT def INTO olddef FROM fs00001019_mod_source_record_storage.rmb_internal_index WHERE name = aname; 2021-08-26T11:20:39.645Z SELECT def INTO prepareddef FROM fs00001019_mod_source_record_storage.rmb_internal_index WHERE name = namep; 2021-08-26T11:20:39.645Z prepareddef = replace(prepareddef, concat(' ', namep, ' ON '), concat(' ', aname, ' ON ')); 2021-08-26T11:20:39.645Z IF prepareddef = newdef THEN 2021-08-26T11:20:39.645Z EXECUTE format('DROP INDEX IF EXISTS %s', aname); 2021-08-26T11:20:39.645Z EXECUTE format('ALTER INDEX IF EXISTS %s RENAME TO %s', namep, aname); 2021-08-26T11:20:39.645Z EXECUTE 'DELETE FROM rmb_internal_index WHERE name = $1' USING namep; 2021-08-26T11:20:39.645Z EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable; 2021-08-26T11:20:39.645Z ELSIF olddef IS DISTINCT FROM newdef THEN 2021-08-26T11:20:39.645Z EXECUTE format('DROP INDEX IF EXISTS %s', aname); 2021-08-26T11:20:39.645Z EXECUTE newdef; 2021-08-26T11:20:39.645Z EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable; 2021-08-26T11:20:39.645Z END IF; 2021-08-26T11:20:39.645Z EXECUTE 'INSERT INTO fs00001019_mod_source_record_storage.rmb_internal_index VALUES ($1, $2, FALSE) ' 2021-08-26T11:20:39.645Z 'ON CONFLICT (name) DO UPDATE SET def = EXCLUDED.def, remove = EXCLUDED.remove' USING aname, newdef; 2021-08-26T11:20:39.645Z END 2021-08-26T11:20:39.645Z $$ LANGUAGE plpgsql; 2021-08-26T11:20:39.646Z 11:20:39.646 [vert.x-eventloop-thread-1] INFO PostgresClient [185824609eqId] trying to execute: {} DO $$ 2021-08-26T11:20:39.646Z BEGIN 2021-08-26T11:20:39.646Z -- use advisory lock to prevent "tuple concurrently updated" 2021-08-26T11:20:39.646Z -- https://issues.folio.org/browse/RMB-744 2021-08-26T11:20:39.646Z PERFORM pg_advisory_xact_lock(20201101, 1234567890); 2021-08-26T11:20:39.646Z REVOKE ALL PRIVILEGES ON SCHEMA public FROM fs00001019_mod_source_record_storage; 2021-08-26T11:20:39.646Z REVOKE CREATE ON SCHEMA public FROM PUBLIC; 2021-08-26T11:20:39.646Z END $$; 2021-08-26T11:20:39.647Z 11:20:39.647 [vert.x-eventloop-thread-1] INFO PostgresClient [185824610eqId] Successfully executed DO $$ 2021-08-26T11:20:39.647Z BEGIN 2021-08-26T11:20:39.647Z -- use advisory lock to prevent "tuple concurrently updated" 2021-08-26T11:20:39.647Z -- https://issues.folio.org/browse/RMB-744 2021-08-26T11:20:39.647Z PERFORM pg_advisory_xact_lock(20201101, 1234567890); 2021-08-26T11:20:39.647Z REVOKE ALL PRIVILEGES ON SCHEMA public FROM fs00001019_mod_source_record_storage; 2021-08-26T11:20:39.647Z REVOKE CREATE ON SCHEMA public FROM PUBLIC; 2021-08-26T11:20:39.647Z END $$; 2021-08-26T11:20:39.648Z 11:20:39.648 [vert.x-eventloop-thread-1] INFO PostgresClient [185824611eqId] trying to execute: {} DO $$ 2021-08-26T11:20:39.648Z DECLARE 2021-08-26T11:20:39.648Z aname TEXT; 2021-08-26T11:20:39.648Z BEGIN 2021-08-26T11:20:39.648Z FOR aname IN SELECT name FROM fs00001019_mod_source_record_storage.rmb_internal_index WHERE remove = TRUE 2021-08-26T11:20:39.648Z LOOP 2021-08-26T11:20:39.648Z EXECUTE 'DROP INDEX IF EXISTS ' || aname; 2021-08-26T11:20:39.648Z END LOOP; 2021-08-26T11:20:39.648Z END $$; 2021-08-26T11:20:39.649Z 11:20:39.648 [vert.x-eventloop-thread-1] INFO PostgresClient [185824611eqId] Successfully executed DO $$ 2021-08-26T11:20:39.649Z DECLARE 2021-08-26T11:20:39.649Z aname TEXT; 2021-08-26T11:20:39.649Z BEGIN 2021-08-26T11:20:39.649Z FOR aname IN SELECT name FROM fs00001019_mod_source_record_storage.rmb_internal_index WHERE remove = TRUE 2021-08-26T11:20:39.649Z LOOP 2021-08-26T11:20:39.649Z EXECUTE 'DROP INDEX IF EXISTS ' || aname; 2021-08-26T11:20:39.649Z END LOOP; 2021-08-26T11:20:39.649Z END $$; 2021-08-26T11:20:39.649Z 11:20:39.649 [vert.x-eventloop-thread-1] INFO PostgresClient [185824612eqId] trying to execute: {} DO $$ 2021-08-26T11:20:39.649Z DECLARE 2021-08-26T11:20:39.649Z version TEXT; 2021-08-26T11:20:39.649Z i RECORD; 2021-08-26T11:20:39.649Z newindexdef TEXT; 2021-08-26T11:20:39.649Z BEGIN 2021-08-26T11:20:39.649Z SELECT jsonb->>'rmbVersion' INTO version FROM fs00001019_mod_source_record_storage.rmb_internal; 2021-08-26T11:20:39.649Z IF version !~ '^(\d\.|1\d\.|2[0-8]\.|29\.[0-3]\.)' THEN 2021-08-26T11:20:39.649Z -- skip this upgrade if last install/upgrade was made by RMB >= 29.4.x 2021-08-26T11:20:39.649Z RETURN; 2021-08-26T11:20:39.649Z END IF; 2021-08-26T11:20:39.649Z FOR i IN SELECT * FROM pg_catalog.pg_indexes WHERE schemaname = 'fs00001019_mod_source_record_storage' 2021-08-26T11:20:39.649Z LOOP 2021-08-26T11:20:39.649Z newindexdef := regexp_replace(i.indexdef, 2021-08-26T11:20:39.649Z -- \m = beginning of a word, \M = end of a word 2021-08-26T11:20:39.649Z '\mpublic\.(f_unaccent|concat_space_sql|concat_array_object_values|concat_array_object)\M', 2021-08-26T11:20:39.649Z 'fs00001019_mod_source_record_storage.\1', 2021-08-26T11:20:39.649Z 'g'); 2021-08-26T11:20:39.649Z IF newindexdef <> i.indexdef THEN 2021-08-26T11:20:39.649Z EXECUTE 'DROP INDEX ' || i.indexname; 2021-08-26T11:20:39.649Z EXECUTE newindexdef; 2021-08-26T11:20:39.649Z EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING i.tablename; 2021-08-26T11:20:39.649Z END IF; 2021-08-26T11:20:39.649Z END LOOP; 2021-08-26T11:20:39.649Z END $$; 2021-08-26T11:20:39.651Z 11:20:39.650 [vert.x-eventloop-thread-1] INFO PostgresClient [185824613eqId] Successfully executed DO $$ 2021-08-26T11:20:39.651Z DECLARE 2021-08-26T11:20:39.651Z version TEXT; 2021-08-26T11:20:39.651Z i RECORD; 2021-08-26T11:20:39.651Z newindexdef TEXT; 2021-08-26T11:20:39.651Z BEGIN 2021-08-26T11:20:39.651Z SELECT jsonb->>'rmbVersion' INTO version FROM fs00001019_mod_source_record_storage.rmb_internal; 2021-08-26T11:20:39.651Z IF version !~ '^(\d\.|1\d\.|2[0-8]\.|29\.[0-3]\.)' THEN 2021-08-26T11:20:39.651Z -- skip this upgrade if last install/upgrade was made by RMB >= 29.4.x 2021-08-26T11:20:39.651Z RETURN; 2021-08-26T11:20:39.651Z END IF; 2021-08-26T11:20:39.651Z FOR i IN SELECT * FROM pg_catalog.pg_indexes WHERE schemaname = 'fs00001019_mod_source_record_storage' 2021-08-26T11:20:39.651Z LOOP 2021-08-26T11:20:39.651Z newindexdef := regexp_replace(i.indexdef, 2021-08-26T11:20:39.651Z -- \m = beginning of a word, \M = end of a word 2021-08-26T11:20:39.651Z '\mpublic\.(f_unaccent|concat_space_sql|concat_array_object_values|concat_array_object)\M', 2021-08-26T11:20:39.651Z 'fs00001019_mod_source_record_storage.\1', 2021-08-26T11:20:39.651Z 'g'); 2021-08-26T11:20:39.651Z IF newindexdef <> i.indexdef THEN 2021-08-26T11:20:39.651Z EXECUTE 'DROP INDEX ' || i.indexname; 2021-08-26T11:20:39.651Z EXECUTE newindexdef; 2021-08-26T11:20:39.651Z EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING i.tablename; 2021-08-26T11:20:39.651Z END IF; 2021-08-26T11:20:39.651Z END LOOP; 2021-08-26T11:20:39.651Z END $$; 2021-08-26T11:20:39.651Z 11:20:39.651 [vert.x-eventloop-thread-1] INFO PostgresClient [185824614eqId] trying to execute: {} DO $$ 2021-08-26T11:20:39.651Z DECLARE 2021-08-26T11:20:39.651Z t TEXT; 2021-08-26T11:20:39.651Z BEGIN 2021-08-26T11:20:39.651Z FOR t IN SELECT DISTINCT tablename FROM rmb_internal_analyze 2021-08-26T11:20:39.651Z LOOP 2021-08-26T11:20:39.651Z EXECUTE 'ANALYZE ' || t; 2021-08-26T11:20:39.651Z END LOOP; 2021-08-26T11:20:39.651Z END $$; 2021-08-26T11:20:39.653Z 11:20:39.653 [vert.x-eventloop-thread-1] INFO PostgresClient [185824616eqId] Successfully executed DO $$ 2021-08-26T11:20:39.653Z DECLARE 2021-08-26T11:20:39.653Z t TEXT; 2021-08-26T11:20:39.653Z BEGIN 2021-08-26T11:20:39.653Z FOR t IN SELECT DISTINCT tablename FROM rmb_internal_analyze 2021-08-26T11:20:39.653Z LOOP 2021-08-26T11:20:39.653Z EXECUTE 'ANALYZE ' || t; 2021-08-26T11:20:39.653Z END LOOP; 2021-08-26T11:20:39.653Z END $$; 2021-08-26T11:20:39.653Z 11:20:39.653 [vert.x-eventloop-thread-1] INFO PostgresClient [185824616eqId] trying to execute: {} TRUNCATE rmb_internal_analyze; 2021-08-26T11:20:39.659Z 11:20:39.659 [vert.x-eventloop-thread-1] INFO PostgresClient [185824622eqId] Successfully executed TRUNCATE rmb_internal_analyze; 2021-08-26T11:20:39.660Z 11:20:39.660 [vert.x-eventloop-thread-1] INFO PostgresClient [185824623eqId] trying to execute: {} GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA fs00001019_mod_source_record_storage TO fs00001019_mod_source_record_storage; 2021-08-26T11:20:39.661Z 11:20:39.661 [vert.x-eventloop-thread-1] INFO PostgresClient [185824624eqId] Successfully executed GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA fs00001019_mod_source_record_storage TO fs00001019_mod_source_record_storage; 2021-08-26T11:20:39.662Z 11:20:39.662 [vert.x-eventloop-thread-1] INFO PostgresClient [185824625eqId] trying to execute: {} UPDATE fs00001019_mod_source_record_storage.rmb_internal SET jsonb = jsonb || jsonb_build_object( 'rmbVersion', '32.1.0', 'moduleVersion', 'mod-source-record-storage-5.0.6', 'schemaJson', $mainftl${} 2021-08-26T11:20:39.662Z $mainftl$); 2021-08-26T11:20:39.663Z 11:20:39.663 [vert.x-eventloop-thread-1] INFO PostgresClient [185824626eqId] Successfully executed UPDATE fs00001019_mod_source_record_storage.rmb_internal SET jsonb = jsonb || jsonb_build_object( 'rmbVersion', '32.1.0', 'moduleVersion', 'mod-source-record-storage-5.0.6', 'schemaJson', $mainftl${} 2021-08-26T11:20:39.663Z $mainftl$); 2021-08-26T11:20:39.667Z 11:20:39.667 [vert.x-eventloop-thread-1] INFO LiquibaseUtil [185824630eqId] Initializing schema fs00001019_mod_source_record_storage for tenant fs00001019 2021-08-26T11:20:39.668Z 11:20:39.668 [vert.x-eventloop-thread-1] INFO leConnectionProvider [185824631eqId] Attempting to get connection for fs00001019 2021-08-26T11:20:39.749Z 11:20:39.749 [vert.x-eventloop-thread-1] INFO Slf4jLogger [185824712eqId] SELECT COUNT(*) FROM fs00001019_mod_source_record_storage.databasechangeloglock 2021-08-26T11:20:39.752Z 11:20:39.752 [vert.x-eventloop-thread-1] INFO Slf4jLogger [185824715eqId] SELECT COUNT(*) FROM fs00001019_mod_source_record_storage.databasechangeloglock 2021-08-26T11:20:39.804Z 11:20:39.804 [vert.x-eventloop-thread-1] INFO Slf4jLogger [185824767eqId] SELECT LOCKED FROM fs00001019_mod_source_record_storage.databasechangeloglock WHERE ID=1 2021-08-26T11:20:39.814Z 11:20:39.814 [vert.x-eventloop-thread-1] INFO Slf4jLogger [185824777eqId] Successfully acquired change log lock 2021-08-26T11:20:41.550Z 11:20:41.550 [vert.x-eventloop-thread-1] INFO Slf4jLogger [185826513eqId] SELECT MD5SUM FROM fs00001019_mod_source_record_storage.databasechangelog WHERE MD5SUM IS NOT NULL LIMIT 1 2021-08-26T11:20:41.555Z 11:20:41.555 [vert.x-eventloop-thread-1] INFO Slf4jLogger [185826518eqId] SELECT COUNT(*) FROM fs00001019_mod_source_record_storage.databasechangelog 2021-08-26T11:20:41.558Z 11:20:41.558 [vert.x-eventloop-thread-1] INFO Slf4jLogger [185826521eqId] Reading from fs00001019_mod_source_record_storage.databasechangelog 2021-08-26T11:20:41.559Z 11:20:41.559 [vert.x-eventloop-thread-1] INFO Slf4jLogger [185826522eqId] SELECT * FROM fs00001019_mod_source_record_storage.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC 2021-08-26T11:20:41.687Z 11:20:41.687 [vert.x-eventloop-thread-1] INFO Slf4jLogger [185826650eqId] UPDATE fs00001019_mod_source_record_storage.records_lb 2021-08-26T11:20:41.687Z SET instance_hrid = 2021-08-26T11:20:41.687Z (SELECT fields 2021-08-26T11:20:41.687Z FROM fs00001019_mod_source_record_storage.marc_records_lb 2021-08-26T11:20:41.687Z CROSS JOIN LATERAL jsonb_array_elements((marc_records_lb.content #>> '{}')::jsonb -> 'fields') AS fields 2021-08-26T11:20:41.687Z WHERE fields ? '001' AND records_lb.id = fs00001019_mod_source_record_storage.marc_records_lb.id) ->> '001' 2021-08-26T11:20:41.687Z WHERE records_lb.instance_id NOTNULL 2021-08-26T11:21:06.537Z 11:21:06.537 [vert.x-eventloop-thread-1] INFO LogUtil [185851500eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2021-08-26T11:21:06.540Z 11:21:06.540 [vert.x-eventloop-thread-1] INFO LogUtil [185851503eqId] 127.0.0.1:59916 GET /admin/health null HTTP_1_1 200 4 49 tid=null OK 2021-08-26T11:21:36.565Z 11:21:36.565 [vert.x-eventloop-thread-1] INFO LogUtil [185881528eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2021-08-26T11:21:36.568Z 11:21:36.568 [vert.x-eventloop-thread-1] INFO LogUtil [185881531eqId] 127.0.0.1:60010 GET /admin/health null HTTP_1_1 200 4 49 tid=null OK 2021-08-26T11:21:47.613Z 11:21:47.613 [vert.x-eventloop-thread-1] INFO LogUtil [185892576eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2021-08-26T11:21:47.617Z 11:21:47.616 [vert.x-eventloop-thread-1] INFO LogUtil [185892579eqId] 127.0.0.1:60050 GET /admin/health null HTTP_1_1 200 4 48 tid=null OK 2021-08-26T11:20:48.810Z 11:20:48.810 [vert.x-eventloop-thread-1] ERROR Slf4jLogger [185833773eqId] Change Set liquibase/tenant/scripts/v-0.0.2/2020-09-09--15-00-fill-instance-hrid.xml::2020-09-09--15-00-fill-instance-hrid::VolodymyrRohach failed. Error: ERROR: more than one row returned by a subquery used as an expression [Failed SQL: (0) UPDATE fs00001019_mod_source_record_storage.records_lb 2021-08-26T11:20:48.810Z SET instance_hrid = 2021-08-26T11:20:48.810Z (SELECT fields 2021-08-26T11:20:48.810Z FROM fs00001019_mod_source_record_storage.marc_records_lb 2021-08-26T11:20:48.810Z CROSS JOIN LATERAL jsonb_array_elements((marc_records_lb.content #>> '{}')::jsonb -> 'fields') AS fields 2021-08-26T11:20:48.810Z WHERE fields ? '001' AND records_lb.id = fs00001019_mod_source_record_storage.marc_records_lb.id) ->> '001' 2021-08-26T11:20:48.810Z WHERE records_lb.instance_id NOTNULL] 2021-08-26T11:20:48.834Z 11:20:48.834 [vert.x-eventloop-thread-1] INFO Slf4jLogger [185833797eqId] Successfully released change log lock 2021-08-26T11:20:48.839Z 11:20:48.837 [vert.x-eventloop-thread-1] ERROR LiquibaseUtil [185833800eqId] Error while initializing schema fs00001019_mod_source_record_storage for tenant fs00001019 2021-08-26T11:20:48.839Z liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/tenant/scripts/v-0.0.2/2020-09-09--15-00-fill-instance-hrid.xml::2020-09-09--15-00-fill-instance-hrid::VolodymyrRohach: 2021-08-26T11:20:48.839Z Reason: liquibase.exception.DatabaseException: ERROR: more than one row returned by a subquery used as an expression [Failed SQL: (0) UPDATE fs00001019_mod_source_record_storage.records_lb 2021-08-26T11:20:48.839Z SET instance_hrid = 2021-08-26T11:20:48.839Z (SELECT fields 2021-08-26T11:20:48.839Z FROM fs00001019_mod_source_record_storage.marc_records_lb 2021-08-26T11:20:48.839Z CROSS JOIN LATERAL jsonb_array_elements((marc_records_lb.content #>> '{}')::jsonb -> 'fields') AS fields 2021-08-26T11:20:48.839Z WHERE fields ? '001' AND records_lb.id = fs00001019_mod_source_record_storage.marc_records_lb.id) ->> '001' 2021-08-26T11:20:48.839Z WHERE records_lb.instance_id NOTNULL] 2021-08-26T11:20:48.839Z at liquibase.changelog.ChangeSet.execute(ChangeSet.java:646) ~[ms.jar:?] 2021-08-26T11:20:48.839Z at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) ~[ms.jar:?] 2021-08-26T11:20:48.839Z at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:83) ~[ms.jar:?] 2021-08-26T11:20:48.839Z at liquibase.Liquibase.update(Liquibase.java:202) ~[ms.jar:?] 2021-08-26T11:20:48.839Z at liquibase.Liquibase.update(Liquibase.java:179) ~[ms.jar:?] 2021-08-26T11:20:48.839Z at liquibase.Liquibase.update(Liquibase.java:175) ~[ms.jar:?] 2021-08-26T11:20:48.839Z at org.folio.liquibase.LiquibaseUtil.runScripts(LiquibaseUtil.java:82) ~[ms.jar:?] 2021-08-26T11:20:48.839Z at org.folio.liquibase.LiquibaseUtil.initializeSchemaForTenant(LiquibaseUtil.java:61) ~[ms.jar:?] 2021-08-26T11:20:48.839Z at org.folio.rest.impl.ModTenantAPI.lambda$0(ModTenantAPI.java:60) ~[ms.jar:?] 2021-08-26T11:20:48.839Z at io.vertx.core.impl.future.ComposeTransformation.onSuccess(ComposeTransformation.java:38) ~[ms.jar:?] 2021-08-26T11:20:48.839Z at io.vertx.core.impl.future.FutureBase.emitSuccess(FutureBase.java:61) ~[ms.jar:?] 2021-08-26T11:20:48.839Z at io.vertx.core.impl.future.SucceededFuture.addListener(SucceededFuture.java:82) ~[ms.jar:?] 2021-08-26T11:20:48.839Z at io.vertx.core.impl.future.FutureBase.compose(FutureBase.java:104) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.SucceededFuture.compose(SucceededFuture.java:27) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.Future.compose(Future.java:199) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at org.folio.rest.impl.ModTenantAPI.loadData(ModTenantAPI.java:58) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at org.folio.rest.impl.TenantAPI.lambda$14(TenantAPI.java:284) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.ComposeTransformation.onSuccess(ComposeTransformation.java:38) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureBase.emitSuccess(FutureBase.java:61) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureImpl.tryComplete(FutureImpl.java:180) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.PromiseImpl.tryComplete(PromiseImpl.java:23) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.PromiseImpl.onSuccess(PromiseImpl.java:49) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.PromiseImpl.handle(PromiseImpl.java:41) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.PromiseImpl.handle(PromiseImpl.java:23) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at org.folio.rest.persist.PostgresClient.lambda$112(PostgresClient.java:3730) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureImpl$3.onSuccess(FutureImpl.java:125) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureBase.emitSuccess(FutureBase.java:61) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureImpl.tryComplete(FutureImpl.java:180) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.ComposeTransformation$1.onSuccess(ComposeTransformation.java:62) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureBase.emitSuccess(FutureBase.java:61) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureImpl.tryComplete(FutureImpl.java:180) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.ComposeTransformation$1.onSuccess(ComposeTransformation.java:62) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureBase.emitSuccess(FutureBase.java:61) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureImpl.tryComplete(FutureImpl.java:180) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.EventuallyTransformation$1.onSuccess(EventuallyTransformation.java:60) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureBase.emitSuccess(FutureBase.java:61) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureImpl.addListener(FutureImpl.java:165) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.PromiseImpl.addListener(PromiseImpl.java:23) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.EventuallyTransformation.onSuccess(EventuallyTransformation.java:41) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureBase.emitSuccess(FutureBase.java:61) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureImpl.tryComplete(FutureImpl.java:180) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.ComposeTransformation$1.onSuccess(ComposeTransformation.java:62) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureBase.emitSuccess(FutureBase.java:61) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureImpl.tryComplete(FutureImpl.java:180) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.PromiseImpl.tryComplete(PromiseImpl.java:23) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.PromiseImpl.onSuccess(PromiseImpl.java:49) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.PromiseImpl.handle(PromiseImpl.java:41) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.sqlclient.impl.TransactionImpl.lambda$txCommand$2(TransactionImpl.java:169) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureImpl$3.onSuccess(FutureImpl.java:125) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureBase.lambda$emitSuccess$0(FutureBase.java:53) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.EventLoopContext.execute(EventLoopContext.java:83) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.DuplicatedContext.execute(DuplicatedContext.java:199) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureBase.emitSuccess(FutureBase.java:50) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.FutureImpl.tryComplete(FutureImpl.java:180) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.PromiseImpl.tryComplete(PromiseImpl.java:23) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.PromiseImpl.onSuccess(PromiseImpl.java:49) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.PromiseImpl.handle(PromiseImpl.java:41) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.future.PromiseImpl.handle(PromiseImpl.java:23) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.pgclient.impl.PgSocketConnection.lambda$doSchedule$2(PgSocketConnection.java:154) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.sqlclient.impl.command.CommandResponse.fire(CommandResponse.java:46) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.sqlclient.impl.SocketConnectionBase.handleMessage(SocketConnectionBase.java:257) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.pgclient.impl.PgSocketConnection.handleMessage(PgSocketConnection.java:99) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.sqlclient.impl.SocketConnectionBase.lambda$init$0(SocketConnectionBase.java:95) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.net.impl.NetSocketImpl.lambda$new$2(NetSocketImpl.java:97) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.streams.impl.InboundBuffer.handleEvent(InboundBuffer.java:240) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.streams.impl.InboundBuffer.write(InboundBuffer.java:130) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.net.impl.NetSocketImpl.lambda$handleMessage$10(NetSocketImpl.java:382) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.EventLoopContext.emit(EventLoopContext.java:52) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.impl.DuplicatedContext.emit(DuplicatedContext.java:194) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.net.impl.NetSocketImpl.handleMessage(NetSocketImpl.java:381) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.net.impl.ConnectionBase.read(ConnectionBase.java:151) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.core.net.impl.VertxHandler.channelRead(VertxHandler.java:144) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.CombinedChannelDuplexHandler$DelegatingChannelHandlerContext.fireChannelRead(CombinedChannelDuplexHandler.java:436) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.pgclient.impl.codec.PgEncoder.lambda$write$0(PgEncoder.java:79) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.pgclient.impl.codec.PgCommandCodec.handleReadyForQuery(PgCommandCodec.java:139) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.pgclient.impl.codec.PgDecoder.decodeReadyForQuery(PgDecoder.java:226) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.vertx.pgclient.impl.codec.PgDecoder.channelRead(PgDecoder.java:86) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:251) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:163) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:714) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:650) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:576) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) [ms.jar:?] 2021-08-26T11:20:48.840Z at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?] 2021-08-26T11:20:48.840Z at java.lang.Thread.run(Thread.java:829) [?:?] 2021-08-26T11:20:48.840Z Caused by: liquibase.exception.DatabaseException: ERROR: more than one row returned by a subquery used as an expression [Failed SQL: (0) UPDATE fs00001019_mod_source_record_storage.records_lb 2021-08-26T11:20:48.840Z SET instance_hrid = 2021-08-26T11:20:48.840Z (SELECT fields 2021-08-26T11:20:48.840Z FROM fs00001019_mod_source_record_storage.marc_records_lb 2021-08-26T11:20:48.840Z CROSS JOIN LATERAL jsonb_array_elements((marc_records_lb.content #>> '{}')::jsonb -> 'fields') AS fields 2021-08-26T11:20:48.840Z WHERE fields ? '001' AND records_lb.id = fs00001019_mod_source_record_storage.marc_records_lb.id) ->> '001' 2021-08-26T11:20:48.840Z WHERE records_lb.instance_id NOTNULL] 2021-08-26T11:20:48.840Z at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:402) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:59) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:131) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1276) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1258) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at liquibase.changelog.ChangeSet.execute(ChangeSet.java:609) ~[ms.jar:?] 2021-08-26T11:20:48.840Z ... 96 more 2021-08-26T11:20:48.840Z Caused by: org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression 2021-08-26T11:20:48.840Z at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:398) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:59) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:131) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1276) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1258) ~[ms.jar:?] 2021-08-26T11:20:48.840Z at liquibase.changelog.ChangeSet.execute(ChangeSet.java:609) ~[ms.jar:?] 2021-08-26T11:20:48.840Z ... 96 more 2021-08-26T11:20:48.871Z 11:20:48.871 [vert.x-eventloop-thread-1] INFO ModTenantAPI [185833834eqId] Module is being deployed in test mode, stub snapshot will be created. Check the server log for details. 2021-08-26T11:20:48.904Z 11:20:48.903 [vert.x-eventloop-thread-1] INFO LogUtil [185833866eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2021-08-26T11:20:48.906Z 11:20:48.906 [vert.x-eventloop-thread-1] INFO LogUtil [185833869eqId] 127.0.0.1:59864 GET /admin/health null HTTP_1_1 200 4 31 tid=null OK 2021-08-26T11:20:48.928Z 11:20:48.928 [vert.x-eventloop-thread-1] INFO PubSubClientUtils [185833891eqId] Reading MessagingDescriptor.json 2021-08-26T11:20:48.931Z 11:20:48.931 [vert.x-eventloop-thread-1] INFO PubSubClientUtils [185833894eqId] Registering events for publishers