18 Mar 2020 14:27:25:020 INFO TenantAPI [2088821eqId] sending... postTenant for fs09000000 18 Mar 2020 14:27:25:022 INFO PostgresClient [2088823eqId] DB config read from environment variables 18 Mar 2020 14:27:25:040 INFO PostgresClient [2088841eqId] postgreSQLClientConfig = { "port": 5432, "username": "...", "host": "...", "database": "...", "password": "...", "connectionReleaseDelay": 60000 } 18 Mar 2020 14:27:25:049 INFO BaseSQLClient [2088850eqId] Creating configuration for db.q1b.folio-eis.us-east-1:5432 18 Mar 2020 14:27:25:134 INFO NettyUtils [2088935eqId] jasync selected transport - nio 18 Mar 2020 14:27:25:542 INFO PostgresClient [2089343eqId] Executing multiple statements with id -1909952253 18 Mar 2020 14:27:25:602 INFO PostgresClient [2089403eqId] trying to execute: SET search_path TO fs09000000_mod_kb_ebsco_java, public 18 Mar 2020 14:27:25:604 INFO PostgresClient [2089405eqId] Successfully executed: SET search_path TO fs09000000_mod_kb_ebsco_java, public 18 Mar 2020 14:27:25:605 INFO PostgresClient [2089406eqId] trying to execute: SET search_path TO public, fs09000000_mod_kb_ebsco_java 18 Mar 2020 14:27:25:606 INFO PostgresClient [2089407eqId] Successfully executed: SET search_path TO public, fs09000000_mod_kb_ebsco_java 18 Mar 2020 14:27:25:606 INFO PostgresClient [2089407eqId] trying to execute: DROP FUNCTION IF EXISTS fs09000000_mod_kb_ebsco_java.count_estimate_smart2(bigint,bigint,text) 18 Mar 2020 14:27:25:610 INFO PostgresClient [2089411eqId] Successfully executed: DROP FUNCTION IF EXISTS fs09000000_mod_kb_ebsco_java.count_estimate_smart2(bigint,bigint,text) 18 Mar 2020 14:27:25:610 INFO PostgresClient [2089411eqId] trying to execute: CREATE FUNCTION fs09000000_mod_kb_ebsco_java.count_estimate_smart2(rows bigint, lim bigint, query text) RETURNS bigint AS $$ DECLARE rec record; cnt bigint; BEGIN IF rows = lim THEN FOR rec IN EXECUTE 'EXPLAIN ' || query LOOP cnt := substring(rec."QUERY PLAN" FROM ' rows=([[:digit:]]+)'); EXIT WHEN cnt IS NOT NULL; END LOOP; RETURN cnt; END IF; RETURN rows; END; $$ LANGUAGE plpgsql VOLATILE STRICT 18 Mar 2020 14:27:25:612 INFO PostgresClient [2089413eqId] Successfully executed: CREATE FUNCTION fs09000000_mod_kb_ebsco_java.count_estimate_smart2(rows bigint, lim bigint, query text) RETURNS bigint AS $$ DECLARE rec record; cnt bigint; BEGIN IF rows = lim THEN FOR rec IN EXECUTE 'EXPLAIN ' || query LOOP cnt := substring(rec."QUERY PLAN" FROM ' rows=([[:digit:]]+)'); EXIT WHEN cnt IS NOT NULL; END LOOP; RETURN cnt; END IF; RETURN 18 Mar 2020 14:27:25:612 INFO PostgresClient [2089413eqId] trying to execute: CREATE OR REPLACE FUNCTION fs09000000_mod_kb_ebsco_java.count_estimate_default(query text) RETURNS bigint AS $$ DECLARE rows bigint; q text; BEGIN q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x'; EXECUTE q INTO rows; IF rows < 1000 THEN return rows; END IF; rows = fs09000000_mod_kb_ebsco_java.count_estimate_smart2(1000, 1000, query); IF rows < 1000 THEN return 1000; END IF; RETURN rows; END; $$ LANGUAGE plpgsql IMMUTABLE STRICT 18 Mar 2020 14:27:25:613 INFO PostgresClient [2089414eqId] Successfully executed: CREATE OR REPLACE FUNCTION fs09000000_mod_kb_ebsco_java.count_estimate_default(query text) RETURNS bigint AS $$ DECLARE rows bigint; q text; BEGIN q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x'; EXECUTE q INTO rows; IF rows < 1000 THEN return rows; END IF; rows = fs09000000_mod_kb_ebsco_java.count_estimate_smart2(1000, 1000, query); IF rows < 1000 THEN return 10 18 Mar 2020 14:27:25:614 INFO PostgresClient [2089415eqId] trying to execute: CREATE OR REPLACE FUNCTION f_unaccent(text) RETURNS text AS $func$ SELECT public.unaccent('public.unaccent', $1) -- schema-qualify function and dictionary $func$ LANGUAGE sql IMMUTABLE 18 Mar 2020 14:27:25:614 INFO PostgresClient [2089415eqId] Successfully executed: CREATE OR REPLACE FUNCTION f_unaccent(text) RETURNS text AS $func$ SELECT public.unaccent('public.unaccent', $1) -- schema-qualify function and dictionary $func$ LANGUAGE sql IMMUTABLE 18 Mar 2020 14:27:25:615 INFO PostgresClient [2089416eqId] trying to execute: CREATE OR REPLACE FUNCTION fs09000000_mod_kb_ebsco_java.set_id_in_jsonb() RETURNS TRIGGER AS $$ BEGIN NEW.jsonb = jsonb_set(NEW.jsonb, '{id}', to_jsonb(NEW.id)); RETURN NEW; END; $$ language 'plpgsql' 18 Mar 2020 14:27:25:615 INFO PostgresClient [2089416eqId] Successfully executed: CREATE OR REPLACE FUNCTION fs09000000_mod_kb_ebsco_java.set_id_in_jsonb() RETURNS TRIGGER AS $$ BEGIN NEW.jsonb = jsonb_set(NEW.jsonb, '{id}', to_jsonb(NEW.id)); RETURN NEW; END; $$ language 'plpgsql' 18 Mar 2020 14:27:25:615 INFO PostgresClient [2089416eqId] trying to execute: create or replace function concat_space_sql(VARIADIC text[]) RETURNS text AS $$ select concat_ws(' ', VARIADIC $1); $$ LANGUAGE SQL IMMUTABLE 18 Mar 2020 14:27:25:616 INFO PostgresClient [2089417eqId] Successfully executed: create or replace function concat_space_sql(VARIADIC text[]) RETURNS text AS $$ select concat_ws(' ', VARIADIC $1); $$ LANGUAGE SQL IMMUTABLE 18 Mar 2020 14:27:25:616 INFO PostgresClient [2089417eqId] trying to execute: create or replace function concat_array_object_values(jsonb_data jsonb, field text) RETURNS text AS $$ SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1); $$ LANGUAGE sql IMMUTABLE 18 Mar 2020 14:27:25:617 INFO PostgresClient [2089418eqId] Successfully executed: create or replace function concat_array_object_values(jsonb_data jsonb, field text) RETURNS text AS $$ SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1); $$ LANGUAGE sql IMMUTABLE 18 Mar 2020 14:27:25:617 INFO PostgresClient [2089418eqId] trying to execute: create or replace function concat_array_object(jsonb_data jsonb) RETURNS text AS $$ SELECT string_agg(value::text, ' ') FROM jsonb_array_elements_text($1); $$ LANGUAGE sql IMMUTABLE 18 Mar 2020 14:27:25:618 INFO PostgresClient [2089419eqId] Successfully executed: create or replace function concat_array_object(jsonb_data jsonb) RETURNS text AS $$ SELECT string_agg(value::text, ' ') FROM jsonb_array_elements_text($1); $$ LANGUAGE sql IMMUTABLE 18 Mar 2020 14:27:25:618 INFO PostgresClient [2089419eqId] trying to execute: SET search_path TO fs09000000_mod_kb_ebsco_java, public 18 Mar 2020 14:27:25:618 INFO PostgresClient [2089419eqId] Successfully executed: SET search_path TO fs09000000_mod_kb_ebsco_java, public 18 Mar 2020 14:27:25:619 INFO PostgresClient [2089420eqId] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON tags CASCADE 18 Mar 2020 14:27:25:620 INFO PostgresClient [2089421eqId] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON tags CASCADE 18 Mar 2020 14:27:25:620 INFO PostgresClient [2089421eqId] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON packages CASCADE 18 Mar 2020 14:27:25:620 INFO PostgresClient [2089421eqId] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON packages CASCADE 18 Mar 2020 14:27:25:621 INFO PostgresClient [2089422eqId] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON providers CASCADE 18 Mar 2020 14:27:25:621 INFO PostgresClient [2089422eqId] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON providers CASCADE 18 Mar 2020 14:27:25:621 INFO PostgresClient [2089422eqId] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON resources CASCADE 18 Mar 2020 14:27:25:622 INFO PostgresClient [2089423eqId] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON resources CASCADE 18 Mar 2020 14:27:25:622 INFO PostgresClient [2089423eqId] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON titles CASCADE 18 Mar 2020 14:27:25:622 INFO PostgresClient [2089423eqId] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON titles CASCADE 18 Mar 2020 14:27:25:622 INFO PostgresClient [2089423eqId] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings CASCADE 18 Mar 2020 14:27:25:623 INFO PostgresClient [2089424eqId] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings CASCADE 18 Mar 2020 14:27:25:623 INFO PostgresClient [2089424eqId] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON retry_status CASCADE 18 Mar 2020 14:27:25:624 INFO PostgresClient [2089425eqId] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON retry_status CASCADE 18 Mar 2020 14:27:25:624 INFO PostgresClient [2089425eqId] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status CASCADE 18 Mar 2020 14:27:25:625 INFO PostgresClient [2089426eqId] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status CASCADE 18 Mar 2020 14:27:25:626 INFO PostgresClient [2089427eqId] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status_audit CASCADE 18 Mar 2020 14:27:25:626 INFO PostgresClient [2089427eqId] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status_audit CASCADE 18 Mar 2020 14:27:25:626 INFO PostgresClient [2089427eqId] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON transaction_ids CASCADE 18 Mar 2020 14:27:25:627 INFO PostgresClient [2089428eqId] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON transaction_ids CASCADE 18 Mar 2020 14:27:25:627 INFO PostgresClient [2089428eqId] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types_mapping CASCADE 18 Mar 2020 14:27:25:628 INFO PostgresClient [2089429eqId] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types_mapping CASCADE 18 Mar 2020 14:27:25:628 INFO PostgresClient [2089429eqId] trying to execute: GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA fs09000000_mod_kb_ebsco_java TO fs09000000_mod_kb_ebsco_java 18 Mar 2020 14:27:25:633 INFO PostgresClient [2089434eqId] Successfully executed: GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA fs09000000_mod_kb_ebsco_java TO fs09000000_mod_kb_ebsco_java 18 Mar 2020 14:27:25:637 INFO PostgresClient [2089438eqId] Successfully committed: -1909952253 18 Mar 2020 14:27:25:638 INFO TenantApiImpl [2089439eqId] Test data will not be initialized. 18 Mar 2020 14:27:25:666 INFO HoldingsStatusRepositoryImpl [2089467eqId] Do insert query = INSERT INTO fs09000000_mod_kb_ebsco_java.holdings_status (id, jsonb, process_id) VALUES (?,?,?) ON CONFLICT DO NOTHING; 18 Mar 2020 14:27:25:667 INFO PostgresClient [2089468eqId] DB config read from environment variables 18 Mar 2020 14:27:25:667 INFO PostgresClient [2089468eqId] Using schema: fs09000000 18 Mar 2020 14:27:25:668 INFO PostgresClient [2089469eqId] postgreSQLClientConfig = { "port": 5432, "username": "...", "host": "...", "database": "...", "password": "...", "connectionReleaseDelay": 60000 } 18 Mar 2020 14:27:25:668 INFO BaseSQLClient [2089469eqId] Creating configuration for db.q1b.folio-eis.us-east-1:5432 18 Mar 2020 14:27:25:712 INFO RetryStatusRepositoryImpl [2089513eqId] Do delete query = DELETE FROM fs09000000_mod_kb_ebsco_java.retry_status; 18 Mar 2020 14:27:25:728 INFO RetryStatusRepositoryImpl [2089529eqId] Do insert query = INSERT INTO fs09000000_mod_kb_ebsco_java.retry_status (id, attempts_left, timer_id) VALUES (?,?,?); 18 Mar 2020 14:27:25:737 INFO LogUtil [2089538eqId] org.folio.rest.RestVerticle start invoking postTenant 18 Mar 2020 14:27:25:738 INFO LogUtil [2089539eqId] 127.0.0.1:51820 POST /_/tenant null HTTP_1_1 200 2 1043 tid=fs09000000 OK 18 Mar 2020 14:27:28:899 INFO LogUtil [2092700eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 18 Mar 2020 14:27:28:900 INFO LogUtil [2092701eqId] 127.0.0.1:52182 GET /admin/health null HTTP_1_1 200 4