@timestamp,@message,@logStream 2021-10-12 20:33:17.740,20:33:17.740 [vert.x-eventloop-thread-1] INFO RestRouting [10204346eqId] invoking postTenant,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:17.752,20:33:17.752 [vert.x-eventloop-thread-1] INFO PostgresClient [10204358eqId] DB config read from environment variables,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:17.768,"20:33:17.768 [vert.x-eventloop-thread-1] INFO PostgresClient [10204374eqId] postgreSQLClientConfig = {""maxPoolSize"":20,""port"":5432,""username"":""folio"",""host"":""db.kbf.folio-eis.us-east-1"",""database"":""folio"",""password"":""..."",""postgres_tester"":false}",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.221,20:33:18.221 [vert.x-eventloop-thread-1] INFO PostgresClient [10204827eqId] Executing multiple statements with id 1533696205,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.236,"20:33:18.236 [vert.x-eventloop-thread-1] INFO PostgresClient [10204842eqId] trying to execute: {} ALTER ROLE fs09000000_mod_source_record_storage SET search_path = ""$user"";",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.237,"20:33:18.237 [vert.x-eventloop-thread-1] INFO PostgresClient [10204843eqId] Successfully executed ALTER ROLE fs09000000_mod_source_record_storage SET search_path = ""$user"";",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238,20:33:18.237 [vert.x-eventloop-thread-1] INFO PostgresClient [10204843eqId] trying to execute: {} DO $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238, BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238," -- This only succeeds if show_trgm, a pg_trgm function,",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238, -- has been loaded into public schema.,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238, PERFORM public.show_trgm('a');,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238, EXCEPTION,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238, WHEN undefined_function THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238, BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238, ALTER EXTENSION pg_trgm SET SCHEMA public;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238, EXCEPTION,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238, WHEN undefined_object THEN NULL;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238, END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238, END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.238,END $$;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241,20:33:18.241 [vert.x-eventloop-thread-1] INFO PostgresClient [10204847eqId] Successfully executed DO $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241, BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241," -- This only succeeds if show_trgm, a pg_trgm function,",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241, -- has been loaded into public schema.,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241, PERFORM public.show_trgm('a');,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241, EXCEPTION,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241, WHEN undefined_function THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241, BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241, ALTER EXTENSION pg_trgm SET SCHEMA public;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241, EXCEPTION,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241, WHEN undefined_object THEN NULL;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241, END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241, END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241,END $$;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.241,20:33:18.241 [vert.x-eventloop-thread-1] INFO PostgresClient [10204847eqId] trying to execute: {} CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.243,"20:33:18.243 [vert.x-eventloop-thread-1] WARN ? [10204849eqId] 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='1672', routine='CreateExtension', schema='null', table='null', column='null', dataType='null', constraint='null'",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.243,20:33:18.243 [vert.x-eventloop-thread-1] INFO PostgresClient [10204849eqId] Successfully executed CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.243,20:33:18.243 [vert.x-eventloop-thread-1] INFO PostgresClient [10204849eqId] trying to execute: {} CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.244,"20:33:18.244 [vert.x-eventloop-thread-1] WARN ? [10204850eqId] 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='1672', routine='CreateExtension', schema='null', table='null', column='null', dataType='null', constraint='null'",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.245,20:33:18.245 [vert.x-eventloop-thread-1] INFO PostgresClient [10204851eqId] Successfully executed CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.245,"20:33:18.245 [vert.x-eventloop-thread-1] INFO PostgresClient [10204851eqId] trying to execute: {} CREATE TABLE IF NOT EXISTS fs09000000_mod_source_record_storage.rmb_job ( id UUID PRIMARY KEY, jsonb JSONB NOT NULL );",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.246,"20:33:18.246 [vert.x-eventloop-thread-1] WARN ? [10204852eqId] 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='212', routine='transformCreateStmt', schema='null', table='null', column='null', dataType='null', constraint='null'",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.246,"20:33:18.246 [vert.x-eventloop-thread-1] INFO PostgresClient [10204852eqId] Successfully executed CREATE TABLE IF NOT EXISTS fs09000000_mod_source_record_storage.rmb_job ( id UUID PRIMARY KEY, jsonb JSONB NOT NULL );",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.288,20:33:18.288 [vert.x-eventloop-thread-1] INFO LogUtil [10204894eqId] 127.0.0.1:57980 POST /_/tenant null HTTP_1_1 201 302 763 tid=fs09000000 Created ,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.324,20:33:18.324 [vert.x-eventloop-thread-1] INFO PostgresClient [10204930eqId] Executing multiple statements with id -2045080962,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.330,20:33:18.330 [vert.x-eventloop-thread-1] INFO RestRouting [10204936eqId] invoking getTenantByOperationId,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.337,20:33:18.337 [vert.x-eventloop-thread-1] INFO PostgresClient [10204943eqId] trying to execute: {} SET search_path TO fs09000000_mod_source_record_storage;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.338,20:33:18.338 [vert.x-eventloop-thread-1] INFO PostgresClient [10204944eqId] Successfully executed SET search_path TO fs09000000_mod_source_record_storage;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.338,"20:33:18.338 [vert.x-eventloop-thread-1] INFO PostgresClient [10204944eqId] trying to execute: {} CREATE TABLE IF NOT EXISTS fs09000000_mod_source_record_storage.rmb_internal_index ( name text PRIMARY KEY, def text NOT NULL, remove boolean NOT NULL );",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.340,"20:33:18.340 [vert.x-eventloop-thread-1] WARN ? [10204946eqId] 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='212', routine='transformCreateStmt', schema='null', table='null', column='null', dataType='null', constraint='null'",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.340,"20:33:18.340 [vert.x-eventloop-thread-1] INFO PostgresClient [10204946eqId] Successfully executed CREATE TABLE IF NOT EXISTS fs09000000_mod_source_record_storage.rmb_internal_index ( name text PRIMARY KEY, def text NOT NULL, remove boolean NOT NULL );",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.340,20:33:18.340 [vert.x-eventloop-thread-1] INFO PostgresClient [10204946eqId] trying to execute: {} UPDATE fs09000000_mod_source_record_storage.rmb_internal_index SET remove = TRUE;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.344,20:33:18.344 [vert.x-eventloop-thread-1] INFO PostgresClient [10204950eqId] Successfully executed UPDATE fs09000000_mod_source_record_storage.rmb_internal_index SET remove = TRUE;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.344,20:33:18.344 [vert.x-eventloop-thread-1] INFO PostgresClient [10204950eqId] trying to execute: {} CREATE TABLE IF NOT EXISTS rmb_internal_analyze ( tablename text );,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.345,"20:33:18.345 [vert.x-eventloop-thread-1] WARN ? [10204951eqId] 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='212', routine='transformCreateStmt', schema='null', table='null', column='null', dataType='null', constraint='null'",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.345,20:33:18.345 [vert.x-eventloop-thread-1] INFO PostgresClient [10204951eqId] Successfully executed CREATE TABLE IF NOT EXISTS rmb_internal_analyze ( tablename text );,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.345,"20:33:18.345 [vert.x-eventloop-thread-1] INFO PostgresClient [10204951eqId] trying to execute: {} DROP FUNCTION IF EXISTS fs09000000_mod_source_record_storage.count_estimate_smart2(bigint,bigint,text);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348,"20:33:18.348 [vert.x-eventloop-thread-1] INFO PostgresClient [10204954eqId] Successfully executed DROP FUNCTION IF EXISTS fs09000000_mod_source_record_storage.count_estimate_smart2(bigint,bigint,text);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348,"20:33:18.348 [vert.x-eventloop-thread-1] INFO PostgresClient [10204954eqId] trying to execute: {} CREATE FUNCTION fs09000000_mod_source_record_storage.count_estimate_smart2(rows bigint, lim bigint, query text) RETURNS bigint AS $$",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348, rec record;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348, cnt bigint;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348, IF rows = lim THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348, FOR rec IN EXECUTE 'EXPLAIN ' || query LOOP,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348," cnt := substring(rec.""QUERY PLAN"" FROM ' rows=([[:digit:]]+)');",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348, EXIT WHEN cnt IS NOT NULL;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348, END LOOP;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348, RETURN cnt;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348, RETURN rows;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348,END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.348,$$ LANGUAGE plpgsql VOLATILE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355,20:33:18.355 [vert.x-eventloop-thread-1] INFO LogUtil [10204961eqId] 127.0.0.1:57992 GET /_/tenant/4d194198-3b26-4820-955d-7786657d0187 null HTTP_1_1 200 302 25 tid=fs09000000 OK ,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355,"20:33:18.355 [vert.x-eventloop-thread-1] INFO PostgresClient [10204961eqId] Successfully executed CREATE FUNCTION fs09000000_mod_source_record_storage.count_estimate_smart2(rows bigint, lim bigint, query text) RETURNS bigint AS $$",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, rec record;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, cnt bigint;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, IF rows = lim THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, FOR rec IN EXECUTE 'EXPLAIN ' || query LOOP,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355," cnt := substring(rec.""QUERY PLAN"" FROM ' rows=([[:digit:]]+)');",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, EXIT WHEN cnt IS NOT NULL;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, END LOOP;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, RETURN cnt;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, RETURN rows;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355,END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355,$$ LANGUAGE plpgsql VOLATILE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355,20:33:18.355 [vert.x-eventloop-thread-1] INFO PostgresClient [10204961eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.count_estimate_default(query text) RETURNS bigint AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, rows bigint;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, q text;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x';,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, EXECUTE q INTO rows;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, IF rows < 1000 THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, return rows;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355," rows = fs09000000_mod_source_record_storage.count_estimate_smart2(1000, 1000, query);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, IF rows < 1000 THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, return 1000;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355, RETURN rows;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355,END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.355,$$ LANGUAGE plpgsql IMMUTABLE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358,20:33:18.358 [vert.x-eventloop-thread-1] INFO PostgresClient [10204964eqId] Successfully executed CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.count_estimate_default(query text) RETURNS bigint AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, rows bigint;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, q text;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x';,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, EXECUTE q INTO rows;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, IF rows < 1000 THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, return rows;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358," rows = fs09000000_mod_source_record_storage.count_estimate_smart2(1000, 1000, query);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, IF rows < 1000 THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, return 1000;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, RETURN rows;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358,END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358,$$ LANGUAGE plpgsql IMMUTABLE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358,20:33:18.358 [vert.x-eventloop-thread-1] INFO PostgresClient [10204964eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.count_estimate(query text) RETURNS bigint AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, count bigint;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, est_count bigint;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, q text;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358," est_count = fs09000000_mod_source_record_storage.count_estimate_smart2(1000, 1000, query);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, IF est_count > 4*1000 THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, RETURN est_count;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x';,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, EXECUTE q INTO count;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, IF count < 1000 THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, RETURN count;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, IF est_count < 1000 THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, RETURN 1000;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358, RETURN est_count;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358,END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.358,$$ LANGUAGE plpgsql STABLE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359,20:33:18.359 [vert.x-eventloop-thread-1] INFO PostgresClient [10204965eqId] Successfully executed CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.count_estimate(query text) RETURNS bigint AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, count bigint;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, est_count bigint;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, q text;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359," est_count = fs09000000_mod_source_record_storage.count_estimate_smart2(1000, 1000, query);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, IF est_count > 4*1000 THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, RETURN est_count;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x';,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, EXECUTE q INTO count;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, IF count < 1000 THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, RETURN count;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, IF est_count < 1000 THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, RETURN 1000;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, RETURN est_count;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359,END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359,$$ LANGUAGE plpgsql STABLE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359,"20:33:18.359 [vert.x-eventloop-thread-1] INFO PostgresClient [10204965eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.upsert(text, uuid, anyelement) RETURNS uuid AS $$",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, ret uuid;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359," EXECUTE format('UPDATE fs09000000_mod_source_record_storage.%I SET jsonb=$3 WHERE id=$2 RETURNING id', $1)",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359," USING $1, $2, $3 INTO ret;",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, IF ret IS NOT NULL THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, RETURN ret;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359," EXECUTE format('INSERT INTO fs09000000_mod_source_record_storage.%I (id, jsonb) VALUES ($2, $3) RETURNING id', $1)",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359," USING $1, $2, $3 INTO STRICT ret;",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359, RETURN ret;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359,END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.359,$$ LANGUAGE plpgsql;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361,"20:33:18.361 [vert.x-eventloop-thread-1] INFO PostgresClient [10204967eqId] Successfully executed CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.upsert(text, uuid, anyelement) RETURNS uuid AS $$",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, ret uuid;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361," EXECUTE format('UPDATE fs09000000_mod_source_record_storage.%I SET jsonb=$3 WHERE id=$2 RETURNING id', $1)",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361," USING $1, $2, $3 INTO ret;",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, IF ret IS NOT NULL THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, RETURN ret;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361," EXECUTE format('INSERT INTO fs09000000_mod_source_record_storage.%I (id, jsonb) VALUES ($2, $3) RETURNING id', $1)",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361," USING $1, $2, $3 INTO STRICT ret;",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, RETURN ret;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361,END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361,$$ LANGUAGE plpgsql;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361,20:33:18.361 [vert.x-eventloop-thread-1] INFO PostgresClient [10204967eqId] trying to execute: {} DO $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, DECLARE ver integer;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, SELECT current_setting('server_version_num') INTO ver;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, IF (ver >= 120000) THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.f_unaccent(text),kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, RETURNS text AS,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, $f_unaccent$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361," SELECT public.unaccent('public.unaccent', $1) -- schema-qualify function and dictionary",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, ELSE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.f_unaccent(text),kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, RETURNS text AS,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, $f_unaccent$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361," SELECT regexp_replace(public.unaccent('public.unaccent', $1),",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, E'[\u0300\u0301\u0302\u0303\u0304\u0305\u0306\u0307\u0308\u0309\u030a\u030b\u030c\u030d\u030e\u030f' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, E'\u0310\u0311\u0312\u0313\u0314\u0315\u0316\u0317\u0318\u0319\u031a\u031b\u031c\u031d\u031e\u031f' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, E'\u0320\u0321\u0322\u0323\u0324\u0325\u0326\u0327\u0328\u0329\u032a\u032b\u032c\u032d\u032e\u032f' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, E'\u0330\u0331\u0332\u0333\u0334\u0335\u0336\u0337\u0338\u0339\u033a\u033b\u033c\u033d\u033e\u033f' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, E'\u0340\u0341\u0342\u0343\u0344\u0345\u0346\u0347\u0348\u0349\u034a\u034b\u034c\u034d\u034e\u034f' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, E'\u0350\u0351\u0352\u0353\u0354\u0355\u0356\u0357\u0358\u0359\u035a\u035b\u035c\u035d\u035e\u035f' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, E'\u0360\u0361\u0362' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, E'\u20dd\u20de\u20df\u20e0' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361," E'\u20e2\u20e3\u20e4]',",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361," '',",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, 'g'),kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361, END,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.361,$$;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363,20:33:18.363 [vert.x-eventloop-thread-1] INFO PostgresClient [10204969eqId] Successfully executed DO $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, DECLARE ver integer;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, SELECT current_setting('server_version_num') INTO ver;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, IF (ver >= 120000) THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.f_unaccent(text),kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, RETURNS text AS,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, $f_unaccent$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363," SELECT public.unaccent('public.unaccent', $1) -- schema-qualify function and dictionary",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, ELSE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.f_unaccent(text),kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, RETURNS text AS,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, $f_unaccent$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363," SELECT regexp_replace(public.unaccent('public.unaccent', $1),",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, E'[\u0300\u0301\u0302\u0303\u0304\u0305\u0306\u0307\u0308\u0309\u030a\u030b\u030c\u030d\u030e\u030f' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, E'\u0310\u0311\u0312\u0313\u0314\u0315\u0316\u0317\u0318\u0319\u031a\u031b\u031c\u031d\u031e\u031f' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, E'\u0320\u0321\u0322\u0323\u0324\u0325\u0326\u0327\u0328\u0329\u032a\u032b\u032c\u032d\u032e\u032f' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, E'\u0330\u0331\u0332\u0333\u0334\u0335\u0336\u0337\u0338\u0339\u033a\u033b\u033c\u033d\u033e\u033f' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, E'\u0340\u0341\u0342\u0343\u0344\u0345\u0346\u0347\u0348\u0349\u034a\u034b\u034c\u034d\u034e\u034f' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, E'\u0350\u0351\u0352\u0353\u0354\u0355\u0356\u0357\u0358\u0359\u035a\u035b\u035c\u035d\u035e\u035f' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, E'\u0360\u0361\u0362' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, E'\u20dd\u20de\u20df\u20e0' ||,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363," E'\u20e2\u20e3\u20e4]',",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363," '',",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, 'g'),kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363, END,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363,$$;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363,20:33:18.363 [vert.x-eventloop-thread-1] INFO PostgresClient [10204969eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.get_tsvector(text) RETURNS tsvector AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363," SELECT to_tsvector('simple', translate($1, '&', ','));",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.363,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.365,20:33:18.365 [vert.x-eventloop-thread-1] INFO PostgresClient [10204971eqId] Successfully executed CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.get_tsvector(text) RETURNS tsvector AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.365," SELECT to_tsvector('simple', translate($1, '&', ','));",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.365,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.365,20:33:18.365 [vert.x-eventloop-thread-1] INFO PostgresClient [10204971eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.tsquery_and(text) RETURNS tsquery AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.365," SELECT to_tsquery('simple', string_agg(CASE WHEN length(v) = 0 OR v = '*' THEN ''",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.365," WHEN right(v, 1) = '*' THEN '''' || left(v, -1) || ''':*'",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.365," ELSE '''' || v || '''' END,",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.365, '&')),kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.365," FROM (SELECT regexp_split_to_table(translate($1, '&''', ',,'), ' +')) AS x(v);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.365,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.367,20:33:18.367 [vert.x-eventloop-thread-1] INFO PostgresClient [10204973eqId] Successfully executed CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.tsquery_and(text) RETURNS tsquery AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.367," SELECT to_tsquery('simple', string_agg(CASE WHEN length(v) = 0 OR v = '*' THEN ''",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.367," WHEN right(v, 1) = '*' THEN '''' || left(v, -1) || ''':*'",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.367," ELSE '''' || v || '''' END,",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.367, '&')),kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.367," FROM (SELECT regexp_split_to_table(translate($1, '&''', ',,'), ' +')) AS x(v);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.367,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.368,20:33:18.367 [vert.x-eventloop-thread-1] INFO PostgresClient [10204973eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.tsquery_or(text) RETURNS tsquery AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.368," SELECT replace(fs09000000_mod_source_record_storage.tsquery_and($1)::text, '&', '|')::tsquery;",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.368,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.369,20:33:18.369 [vert.x-eventloop-thread-1] INFO PostgresClient [10204975eqId] Successfully executed CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.tsquery_or(text) RETURNS tsquery AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.369," SELECT replace(fs09000000_mod_source_record_storage.tsquery_and($1)::text, '&', '|')::tsquery;",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.369,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.369,20:33:18.369 [vert.x-eventloop-thread-1] INFO PostgresClient [10204975eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.tsquery_phrase(text) RETURNS tsquery AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.369," SELECT replace(fs09000000_mod_source_record_storage.tsquery_and($1)::text, '&', '<->')::tsquery;",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.369,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.371,20:33:18.371 [vert.x-eventloop-thread-1] INFO PostgresClient [10204977eqId] Successfully executed CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.tsquery_phrase(text) RETURNS tsquery AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.371," SELECT replace(fs09000000_mod_source_record_storage.tsquery_and($1)::text, '&', '<->')::tsquery;",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.371,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.371,20:33:18.371 [vert.x-eventloop-thread-1] INFO PostgresClient [10204977eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.normalize_digits(text) RETURNS text AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.371," SELECT translate((regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1], E' \t-', '')",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.371," || CASE WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1] = '' THEN ''",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.371," WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2] = '' THEN ''",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.371, ELSE ' ',kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.371, END,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.371," || (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2];",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.371,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375,20:33:18.375 [vert.x-eventloop-thread-1] INFO PostgresClient [10204981eqId] Successfully executed CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.normalize_digits(text) RETURNS text AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375," SELECT translate((regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1], E' \t-', '')",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375," || CASE WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1] = '' THEN ''",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375," WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2] = '' THEN ''",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375, ELSE ' ',kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375, END,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375," || (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2];",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375,20:33:18.375 [vert.x-eventloop-thread-1] INFO PostgresClient [10204981eqId] trying to execute: {} CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.set_id_in_jsonb() RETURNS TRIGGER AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375," NEW.jsonb = jsonb_set(NEW.jsonb, '{id}', to_jsonb(NEW.id));",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375, RETURN NEW;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375,END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.375,$$ language 'plpgsql';,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.377,20:33:18.377 [vert.x-eventloop-thread-1] INFO PostgresClient [10204983eqId] Successfully executed CREATE OR REPLACE FUNCTION fs09000000_mod_source_record_storage.set_id_in_jsonb() RETURNS TRIGGER AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.377,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.377," NEW.jsonb = jsonb_set(NEW.jsonb, '{id}', to_jsonb(NEW.id));",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.377, RETURN NEW;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.377,END;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.377,$$ language 'plpgsql';,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.377,"20:33:18.377 [vert.x-eventloop-thread-1] INFO PostgresClient [10204983eqId] trying to execute: {} create or replace function fs09000000_mod_source_record_storage.concat_space_sql(VARIADIC text[]) RETURNS text AS $$ select concat_ws(' ', VARIADIC $1);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.377,$$ LANGUAGE SQL IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.379,"20:33:18.379 [vert.x-eventloop-thread-1] INFO PostgresClient [10204985eqId] Successfully executed create or replace function fs09000000_mod_source_record_storage.concat_space_sql(VARIADIC text[]) RETURNS text AS $$ select concat_ws(' ', VARIADIC $1);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.379,$$ LANGUAGE SQL IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.379,"20:33:18.379 [vert.x-eventloop-thread-1] INFO PostgresClient [10204985eqId] trying to execute: {} create or replace function fs09000000_mod_source_record_storage.concat_array_object_values(jsonb_array jsonb, field text) RETURNS text AS $$",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.379," SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.379,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.381,"20:33:18.380 [vert.x-eventloop-thread-1] INFO PostgresClient [10204986eqId] Successfully executed create or replace function fs09000000_mod_source_record_storage.concat_array_object_values(jsonb_array jsonb, field text) RETURNS text AS $$",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.381," SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.381,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.381,"20:33:18.381 [vert.x-eventloop-thread-1] INFO PostgresClient [10204987eqId] trying to execute: {} create or replace function fs09000000_mod_source_record_storage.concat_array_object_values( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.381,"SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1) WHERE value->>$3 = $4;",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.381,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.382,"20:33:18.382 [vert.x-eventloop-thread-1] INFO PostgresClient [10204988eqId] Successfully executed create or replace function fs09000000_mod_source_record_storage.concat_array_object_values( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.382,"SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1) WHERE value->>$3 = $4;",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.382,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.382,"20:33:18.382 [vert.x-eventloop-thread-1] INFO PostgresClient [10204988eqId] trying to execute: {} create or replace function fs09000000_mod_source_record_storage.first_array_object_value( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.382,SELECT value->>$2 FROM jsonb_array_elements($1) WHERE value->>$3 = $4 LIMIT 1;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.382,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.384,"20:33:18.384 [vert.x-eventloop-thread-1] INFO PostgresClient [10204990eqId] Successfully executed create or replace function fs09000000_mod_source_record_storage.first_array_object_value( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.384,SELECT value->>$2 FROM jsonb_array_elements($1) WHERE value->>$3 = $4 LIMIT 1;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.384,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.384,20:33:18.384 [vert.x-eventloop-thread-1] INFO PostgresClient [10204990eqId] trying to execute: {} create or replace function fs09000000_mod_source_record_storage.concat_array_object(jsonb_array jsonb) RETURNS text AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.384," SELECT string_agg(value::text, ' ') FROM jsonb_array_elements_text($1);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.384,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.385,20:33:18.385 [vert.x-eventloop-thread-1] INFO PostgresClient [10204991eqId] Successfully executed create or replace function fs09000000_mod_source_record_storage.concat_array_object(jsonb_array jsonb) RETURNS text AS $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.385," SELECT string_agg(value::text, ' ') FROM jsonb_array_elements_text($1);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.385,$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.385,"20:33:18.385 [vert.x-eventloop-thread-1] INFO PostgresClient [10204991eqId] trying to execute: {} DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387,"20:33:18.387 [vert.x-eventloop-thread-1] WARN ? [10204993eqId] 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='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387,"20:33:18.387 [vert.x-eventloop-thread-1] INFO PostgresClient [10204993eqId] Successfully executed DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387,"20:33:18.387 [vert.x-eventloop-thread-1] INFO PostgresClient [10204993eqId] trying to execute: {} CREATE OR REPLACE FUNCTION rmb_internal_index( atable text, aname text, tops text, newdef text) RETURNS void AS $$",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, olddef text;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387," namep CONSTANT text = concat(aname, '_p');",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, prepareddef text;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, IF tops = 'DELETE' THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387," -- use case insensitive %s, not case sensitive %I",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, -- no SQL injection because the names are hard-coded in schema.json,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387," EXECUTE format('DROP INDEX IF EXISTS %s', aname);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, EXECUTE 'DELETE FROM fs09000000_mod_source_record_storage.rmb_internal_index WHERE name = $1' USING aname;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, RETURN;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, SELECT def INTO olddef FROM fs09000000_mod_source_record_storage.rmb_internal_index WHERE name = aname;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, SELECT def INTO prepareddef FROM fs09000000_mod_source_record_storage.rmb_internal_index WHERE name = namep;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387," prepareddef = replace(prepareddef, concat(' ', namep, ' ON '), concat(' ', aname, ' ON '));",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, IF prepareddef = newdef THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387," EXECUTE format('DROP INDEX IF EXISTS %s', aname);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387," EXECUTE format('ALTER INDEX IF EXISTS %s RENAME TO %s', namep, aname);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, EXECUTE 'DELETE FROM rmb_internal_index WHERE name = $1' USING namep;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, ELSIF olddef IS DISTINCT FROM newdef THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387," EXECUTE format('DROP INDEX IF EXISTS %s', aname);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, EXECUTE newdef;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387," EXECUTE 'INSERT INTO fs09000000_mod_source_record_storage.rmb_internal_index VALUES ($1, $2, FALSE) '",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387," 'ON CONFLICT (name) DO UPDATE SET def = EXCLUDED.def, remove = EXCLUDED.remove' USING aname, newdef;",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387,END,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.387,$$ LANGUAGE plpgsql;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389,"20:33:18.388 [vert.x-eventloop-thread-1] INFO PostgresClient [10204994eqId] Successfully executed CREATE OR REPLACE FUNCTION rmb_internal_index( atable text, aname text, tops text, newdef text) RETURNS void AS $$",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, olddef text;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389," namep CONSTANT text = concat(aname, '_p');",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, prepareddef text;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, IF tops = 'DELETE' THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389," -- use case insensitive %s, not case sensitive %I",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, -- no SQL injection because the names are hard-coded in schema.json,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389," EXECUTE format('DROP INDEX IF EXISTS %s', aname);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, EXECUTE 'DELETE FROM fs09000000_mod_source_record_storage.rmb_internal_index WHERE name = $1' USING aname;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, RETURN;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, SELECT def INTO olddef FROM fs09000000_mod_source_record_storage.rmb_internal_index WHERE name = aname;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, SELECT def INTO prepareddef FROM fs09000000_mod_source_record_storage.rmb_internal_index WHERE name = namep;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389," prepareddef = replace(prepareddef, concat(' ', namep, ' ON '), concat(' ', aname, ' ON '));",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, IF prepareddef = newdef THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389," EXECUTE format('DROP INDEX IF EXISTS %s', aname);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389," EXECUTE format('ALTER INDEX IF EXISTS %s RENAME TO %s', namep, aname);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, EXECUTE 'DELETE FROM rmb_internal_index WHERE name = $1' USING namep;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, ELSIF olddef IS DISTINCT FROM newdef THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389," EXECUTE format('DROP INDEX IF EXISTS %s', aname);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, EXECUTE newdef;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389," EXECUTE 'INSERT INTO fs09000000_mod_source_record_storage.rmb_internal_index VALUES ($1, $2, FALSE) '",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389," 'ON CONFLICT (name) DO UPDATE SET def = EXCLUDED.def, remove = EXCLUDED.remove' USING aname, newdef;",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389,END,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389,$$ LANGUAGE plpgsql;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389,20:33:18.389 [vert.x-eventloop-thread-1] INFO PostgresClient [10204995eqId] trying to execute: {} DO $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389," -- use advisory lock to prevent ""tuple concurrently updated""",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, -- https://issues.folio.org/browse/RMB-744,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389," PERFORM pg_advisory_xact_lock(20201101, 1234567890);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, REVOKE ALL PRIVILEGES ON SCHEMA public FROM fs09000000_mod_source_record_storage;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389, REVOKE CREATE ON SCHEMA public FROM PUBLIC;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.389,END $$;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391,20:33:18.391 [vert.x-eventloop-thread-1] INFO PostgresClient [10204997eqId] Successfully executed DO $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391," -- use advisory lock to prevent ""tuple concurrently updated""",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391, -- https://issues.folio.org/browse/RMB-744,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391," PERFORM pg_advisory_xact_lock(20201101, 1234567890);",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391, REVOKE ALL PRIVILEGES ON SCHEMA public FROM fs09000000_mod_source_record_storage;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391, REVOKE CREATE ON SCHEMA public FROM PUBLIC;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391,END $$;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391,20:33:18.391 [vert.x-eventloop-thread-1] INFO PostgresClient [10204997eqId] trying to execute: {} DO $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391, aname TEXT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391, FOR aname IN SELECT name FROM fs09000000_mod_source_record_storage.rmb_internal_index WHERE remove = TRUE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391, LOOP,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391, EXECUTE 'DROP INDEX IF EXISTS ' || aname;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391, END LOOP;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.391,END $$;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392,20:33:18.392 [vert.x-eventloop-thread-1] INFO PostgresClient [10204998eqId] Successfully executed DO $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, aname TEXT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, FOR aname IN SELECT name FROM fs09000000_mod_source_record_storage.rmb_internal_index WHERE remove = TRUE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, LOOP,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, EXECUTE 'DROP INDEX IF EXISTS ' || aname;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, END LOOP;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392,END $$;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392,20:33:18.392 [vert.x-eventloop-thread-1] INFO PostgresClient [10204998eqId] trying to execute: {} DO $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, version TEXT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, i RECORD;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, newindexdef TEXT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, SELECT jsonb->>'rmbVersion' INTO version FROM fs09000000_mod_source_record_storage.rmb_internal;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, IF version !~ '^(\d\.|1\d\.|2[0-8]\.|29\.[0-3]\.)' THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, -- skip this upgrade if last install/upgrade was made by RMB >= 29.4.x,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, RETURN;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, FOR i IN SELECT * FROM pg_catalog.pg_indexes WHERE schemaname = 'fs09000000_mod_source_record_storage',kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, LOOP,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392," newindexdef := regexp_replace(i.indexdef,",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392," -- \m = beginning of a word, \M = end of a word",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392," '\mpublic\.(f_unaccent|concat_space_sql|concat_array_object_values|concat_array_object)\M',",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392," 'fs09000000_mod_source_record_storage.\1',",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, 'g');,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, IF newindexdef <> i.indexdef THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, EXECUTE 'DROP INDEX ' || i.indexname;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, EXECUTE newindexdef;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING i.tablename;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392, END LOOP;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.392,END $$;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394,20:33:18.394 [vert.x-eventloop-thread-1] INFO PostgresClient [10205000eqId] Successfully executed DO $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, version TEXT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, i RECORD;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, newindexdef TEXT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, SELECT jsonb->>'rmbVersion' INTO version FROM fs09000000_mod_source_record_storage.rmb_internal;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, IF version !~ '^(\d\.|1\d\.|2[0-8]\.|29\.[0-3]\.)' THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, -- skip this upgrade if last install/upgrade was made by RMB >= 29.4.x,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, RETURN;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, FOR i IN SELECT * FROM pg_catalog.pg_indexes WHERE schemaname = 'fs09000000_mod_source_record_storage',kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, LOOP,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394," newindexdef := regexp_replace(i.indexdef,",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394," -- \m = beginning of a word, \M = end of a word",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394," '\mpublic\.(f_unaccent|concat_space_sql|concat_array_object_values|concat_array_object)\M',",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394," 'fs09000000_mod_source_record_storage.\1',",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, 'g');,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, IF newindexdef <> i.indexdef THEN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, EXECUTE 'DROP INDEX ' || i.indexname;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, EXECUTE newindexdef;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING i.tablename;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, END IF;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, END LOOP;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394,END $$;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394,20:33:18.394 [vert.x-eventloop-thread-1] INFO PostgresClient [10205000eqId] trying to execute: {} DO $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, t TEXT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, FOR t IN SELECT DISTINCT tablename FROM rmb_internal_analyze,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, LOOP,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, EXECUTE 'ANALYZE ' || t;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394, END LOOP;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.394,END $$;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.396,20:33:18.396 [vert.x-eventloop-thread-1] INFO PostgresClient [10205002eqId] Successfully executed DO $$,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.396,DECLARE,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.396, t TEXT;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.396,BEGIN,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.396, FOR t IN SELECT DISTINCT tablename FROM rmb_internal_analyze,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.396, LOOP,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.396, EXECUTE 'ANALYZE ' || t;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.396, END LOOP;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.396,END $$;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.396,20:33:18.396 [vert.x-eventloop-thread-1] INFO PostgresClient [10205002eqId] trying to execute: {} TRUNCATE rmb_internal_analyze;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.409,20:33:18.409 [vert.x-eventloop-thread-1] INFO PostgresClient [10205015eqId] Successfully executed TRUNCATE rmb_internal_analyze;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.409,20:33:18.409 [vert.x-eventloop-thread-1] INFO PostgresClient [10205015eqId] trying to execute: {} GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA fs09000000_mod_source_record_storage TO fs09000000_mod_source_record_storage;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.490,20:33:18.490 [vert.x-eventloop-thread-1] INFO PostgresClient [10205096eqId] Successfully executed GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA fs09000000_mod_source_record_storage TO fs09000000_mod_source_record_storage;,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.491,"20:33:18.490 [vert.x-eventloop-thread-1] INFO PostgresClient [10205096eqId] trying to execute: {} UPDATE fs09000000_mod_source_record_storage.rmb_internal SET jsonb = jsonb || jsonb_build_object( 'rmbVersion', '33.0.2', 'moduleVersion', 'mod-source-record-storage-5.2.0', 'schemaJson', $mainftl${}",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.491,$mainftl$);,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.493,"20:33:18.493 [vert.x-eventloop-thread-1] INFO PostgresClient [10205099eqId] Successfully executed UPDATE fs09000000_mod_source_record_storage.rmb_internal SET jsonb = jsonb || jsonb_build_object( 'rmbVersion', '33.0.2', 'moduleVersion', 'mod-source-record-storage-5.2.0', 'schemaJson', $mainftl${}",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.493,$mainftl$);,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.510,20:33:18.510 [vert.x-eventloop-thread-1] INFO LiquibaseUtil [10205116eqId] Initializing schema fs09000000_mod_source_record_storage for tenant fs09000000,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.511,20:33:18.510 [vert.x-eventloop-thread-1] INFO leConnectionProvider [10205116eqId] Attempting to get connection for fs09000000,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.511,20:33:18.511 [vert.x-eventloop-thread-1] INFO PostgresClient [10205117eqId] DB config read from environment variables,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.511,20:33:18.511 [vert.x-eventloop-thread-1] INFO PostgresClient [10205117eqId] Using schema: fs09000000,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:18.511,"20:33:18.511 [vert.x-eventloop-thread-1] INFO PostgresClient [10205117eqId] postgreSQLClientConfig = {""maxPoolSize"":20,""port"":5432,""username"":""fs09000000_mod_source_record_storage"",""host"":""db.kbf.folio-eis.us-east-1"",""database"":""folio"",""password"":""..."",""postgres_tester"":false}",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:19.006,"140.234.254.225, 10.23.36.140, 10.23.38.98, 10.23.36.253, 10.23.36.41 - 10.23.38.98 - - [12/Oct/2021:20:33:18 +0000] ""POST /mod-source-record-storage/_/tenant HTTP/1.1"" 201 314 rt=0.766 uct=""0.000"" uht=""0.768"" urt=""0.768"" ""Vert.x-WebClient/4.1.4"" ""fs09000000"" ""-"" ""674455/proxy;779391/tenant""",kbf/mod-source-record-storage/nginx/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:19.007,"140.234.254.225, 10.23.36.140, 10.23.38.98, 10.23.36.253, 10.23.36.41 - 10.23.38.98 - - [12/Oct/2021:20:33:18 +0000] ""GET /mod-source-record-storage/_/tenant/4d194198-3b26-4820-955d-7786657d0187 HTTP/1.1"" 200 314 rt=0.060 uct=""0.000"" uht=""0.060"" urt=""0.060"" ""Vert.x-WebClient/4.1.4"" ""fs09000000"" ""-"" ""674455/proxy;186037/tenant""",kbf/mod-source-record-storage/nginx/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:21.363,20:33:21.363 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10207969eqId] SELECT COUNT(*) FROM fs09000000_mod_source_record_storage.databasechangeloglock,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:21.371,20:33:21.371 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10207977eqId] SELECT COUNT(*) FROM fs09000000_mod_source_record_storage.databasechangeloglock,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:21.374,20:33:21.374 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10207980eqId] SELECT LOCKED FROM fs09000000_mod_source_record_storage.databasechangeloglock WHERE ID=1,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:21.393,20:33:21.393 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10207999eqId] Successfully acquired change log lock,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:24.950,20:33:24.950 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211556eqId] SELECT MD5SUM FROM fs09000000_mod_source_record_storage.databasechangelog WHERE MD5SUM IS NOT NULL LIMIT 1,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:24.954,20:33:24.954 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211560eqId] SELECT COUNT(*) FROM fs09000000_mod_source_record_storage.databasechangelog,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:24.962,20:33:24.962 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211568eqId] Reading from fs09000000_mod_source_record_storage.databasechangelog,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:24.962,"20:33:24.962 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211568eqId] SELECT * FROM fs09000000_mod_source_record_storage.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.038,20:33:25.038 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211644eqId] ALTER TABLE fs09000000_mod_source_record_storage.records_lb RENAME COLUMN instance_hrid TO external_hrid,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.044,20:33:25.044 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211650eqId] Column records_lb.instance_hrid renamed to external_hrid,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.048,20:33:25.048 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211654eqId] ChangeSet liquibase/tenant/scripts/v-5.0.6-5.1.3-5.2.0/2021-08-04--16-00-rename-instance-hrid.xml::2021-08-04--16-00-rename-instance-hrid.xml::psmahin ran successfully in 10ms,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.049,20:33:25.048 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211654eqId] SELECT MAX(ORDEREXECUTED) FROM fs09000000_mod_source_record_storage.databasechangelog,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.051,"20:33:25.051 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211657eqId] INSERT INTO fs09000000_mod_source_record_storage.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2021-08-04--16-00-rename-instance-hrid.xml', 'psmahin', 'liquibase/tenant/scripts/v-5.0.6-5.1.3-5.2.0/2021-08-04--16-00-rename-instance-hrid.xml', NOW(), 146, '8:d16761a03fdc241eace015c0838a3678', 'renameColumn newColumnName=external_hrid, oldColumnName=instance_hrid, tableName=records_lb', '', 'EXECUTED', NULL, NULL, '3.8.9', '4070804975')",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.058,20:33:25.058 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211664eqId] ALTER INDEX fs09000000_mod_source_record_storage.idx_records_instance_hrid,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.058, RENAME TO idx_records_external_hrid,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.062,20:33:25.062 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211668eqId] Custom SQL executed,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.066,20:33:25.066 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211672eqId] ChangeSet liquibase/tenant/scripts/v-5.0.6-5.1.3-5.2.0/2021-08-04--16-00-rename-instance-hrid.xml::2021-08-04--16-00-rename-instance-hrid-index.xml::psmahin ran successfully in 9ms,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.067,"20:33:25.067 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211673eqId] INSERT INTO fs09000000_mod_source_record_storage.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2021-08-04--16-00-rename-instance-hrid-index.xml', 'psmahin', 'liquibase/tenant/scripts/v-5.0.6-5.1.3-5.2.0/2021-08-04--16-00-rename-instance-hrid.xml', NOW(), 147, '8:4cf3f835cc7003e5c53c53d8792401af', 'sql', '', 'EXECUTED', NULL, NULL, '3.8.9', '4070804975')",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.072,20:33:25.072 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211678eqId] ALTER TABLE fs09000000_mod_source_record_storage.records_lb RENAME COLUMN instance_id TO external_id,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.075,20:33:25.075 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211681eqId] Column records_lb.instance_id renamed to external_id,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.079,20:33:25.079 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211685eqId] ChangeSet liquibase/tenant/scripts/v-5.0.6-5.1.3-5.2.0/2021-08-04--16-00-rename-instance-id.xml::2021-08-04--16-00-rename-instance-id.xml::psmahin ran successfully in 7ms,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.079,"20:33:25.079 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211685eqId] INSERT INTO fs09000000_mod_source_record_storage.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2021-08-04--16-00-rename-instance-id.xml', 'psmahin', 'liquibase/tenant/scripts/v-5.0.6-5.1.3-5.2.0/2021-08-04--16-00-rename-instance-id.xml', NOW(), 148, '8:31553b19515b802f8eeebdb887d6a08a', 'renameColumn newColumnName=external_id, oldColumnName=instance_id, tableName=records_lb', '', 'EXECUTED', NULL, NULL, '3.8.9', '4070804975')",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.084,20:33:25.084 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211690eqId] ALTER INDEX fs09000000_mod_source_record_storage.idx_records_instance_id,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.084, RENAME TO idx_records_external_id,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.087,20:33:25.087 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211693eqId] Custom SQL executed,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.091,20:33:25.090 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211696eqId] ChangeSet liquibase/tenant/scripts/v-5.0.6-5.1.3-5.2.0/2021-08-04--16-00-rename-instance-id.xml::2021-08-04--16-00-rename-instance-id-index.xml::psmahin ran successfully in 6ms,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.092,"20:33:25.091 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211697eqId] INSERT INTO fs09000000_mod_source_record_storage.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2021-08-04--16-00-rename-instance-id-index.xml', 'psmahin', 'liquibase/tenant/scripts/v-5.0.6-5.1.3-5.2.0/2021-08-04--16-00-rename-instance-id.xml', NOW(), 149, '8:2afdbfa2aaddf31e18186596d4472749', 'sql', '', 'EXECUTED', NULL, NULL, '3.8.9', '4070804975')",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.100,20:33:25.100 [vert.x-eventloop-thread-1] INFO Slf4jLogger [10211706eqId] Successfully released change log lock,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.103,20:33:25.103 [vert.x-eventloop-thread-1] INFO LiquibaseUtil [10211709eqId] Schema is initialized for tenant fs09000000,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.104,20:33:25.104 [vert.x-eventloop-thread-1] INFO ModTenantAPI [10211710eqId] Module is being deployed in production mode,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.104,20:33:25.104 [vert.x-eventloop-thread-1] INFO TenantAPI [10211710eqId] job 4d194198-3b26-4820-955d-7786657d0187 completed,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.109,20:33:25.109 [vert.x-eventloop-thread-1] INFO RestRouting [10211715eqId] invoking getTenantByOperationId,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.140,20:33:25.140 [vert.x-eventloop-thread-1] INFO LogUtil [10211746eqId] 127.0.0.1:58004 GET /_/tenant/4d194198-3b26-4820-955d-7786657d0187 null HTTP_1_1 200 301 31 tid=fs09000000 OK ,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.148,20:33:25.148 [vert.x-eventloop-thread-1] INFO RestRouting [10211754eqId] invoking deleteTenantByOperationId,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:25.178,20:33:25.178 [vert.x-eventloop-thread-1] INFO LogUtil [10211784eqId] 127.0.0.1:58048 DELETE /_/tenant/4d194198-3b26-4820-955d-7786657d0187 null HTTP_1_1 204 0 30 tid=fs09000000 No Content ,kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:26.008,"140.234.254.225, 10.23.36.140, 10.23.38.98, 10.23.36.253, 10.23.36.41 - 10.23.38.98 - - [12/Oct/2021:20:33:25 +0000] ""GET /mod-source-record-storage/_/tenant/4d194198-3b26-4820-955d-7786657d0187 HTTP/1.1"" 200 313 rt=6.479 uct=""0.000"" uht=""6.480"" urt=""6.480"" ""Vert.x-WebClient/4.1.4"" ""fs09000000"" ""-"" ""674455/proxy;037108/tenant""",kbf/mod-source-record-storage/nginx/9404e986c2ac419e8442540416a428f5 2021-10-12 20:33:26.008,"140.234.254.225, 10.23.36.140, 10.23.38.98, 10.23.36.253, 10.23.36.41 - 10.23.38.98 - - [12/Oct/2021:20:33:25 +0000] ""DELETE /mod-source-record-storage/_/tenant/4d194198-3b26-4820-955d-7786657d0187 HTTP/1.1"" 204 0 rt=0.032 uct=""0.000"" uht=""0.032"" urt=""0.032"" ""Vert.x-WebClient/4.1.4"" ""fs09000000"" ""-"" ""674455/proxy;440953/tenant""",kbf/mod-source-record-storage/nginx/9404e986c2ac419e8442540416a428f5 2021-10-12 20:36:24.866,"20:36:24.866 [vert.x-kafka-consumer-thread-2] INFO ConsumerCoordinator [10391472eqId] [Consumer clientId=consumer-QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle-2, groupId=QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle] Revoke previously assigned partitions ",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:36:24.866,"20:36:24.866 [vert.x-kafka-consumer-thread-2] INFO AbstractCoordinator [10391472eqId] [Consumer clientId=consumer-QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle-2, groupId=QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle] (Re-)joining group",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:36:24.868,"20:36:24.868 [vert.x-kafka-consumer-thread-2] INFO ConsumerCoordinator [10391474eqId] [Consumer clientId=consumer-QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle-2, groupId=QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle] Finished assignment for group at generation 2: {consumer-QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle-2-c8f9b55b-7d5f-450e-b9ea-88d0c49974f2=Assignment(partitions=[kbf.Default.fs09000000.QM_RECORD_UPDATED-0])}",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:36:24.871,"20:36:24.870 [vert.x-kafka-consumer-thread-2] INFO bstractCoordinator$2 [10391476eqId] [Consumer clientId=consumer-QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle-2, groupId=QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle] Successfully joined group with generation 2",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:36:24.871,"20:36:24.871 [vert.x-kafka-consumer-thread-2] INFO ConsumerCoordinator [10391477eqId] [Consumer clientId=consumer-QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle-2, groupId=QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle] Adding newly assigned partitions: kbf.Default.fs09000000.QM_RECORD_UPDATED-0",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:36:24.873,"20:36:24.873 [vert.x-kafka-consumer-thread-2] INFO FetchResponseHandler [10391479eqId] [Consumer clientId=consumer-QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle-2, groupId=QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle] Found no committed offset for partition kbf.Default.fs09000000.QM_RECORD_UPDATED-0",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5 2021-10-12 20:36:24.877,"20:36:24.877 [vert.x-kafka-consumer-thread-2] INFO SubscriptionState [10391483eqId] [Consumer clientId=consumer-QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle-2, groupId=QM_RECORD_UPDATED.mod-source-record-storage-5.2.0_QuickMarcConsumersVerticle] Resetting offset for partition kbf.Default.fs09000000.QM_RECORD_UPDATED-0 to offset 0.",kbf/mod-source-record-storage/9404e986c2ac419e8442540416a428f5