exec java -Dport=8081 -Xmx256m -agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=9573 -XX:+ExitOnOutOfMemoryError -cp . -jar /usr/verticles/mod-kb-ebsco-java-fat.jar Listening for transport dt_socket at address: 9573 starting rest verticle service.......... 16:13:48 [] [] [] [] INFO Version HV000001: Hibernate Validator null 16:13:48 [] [] [] [] INFO Messages Loading messages from /infra-messages/APIMessages_en.properties ................................ 16:13:48 [] [] [] [] INFO Messages Loading messages from /infra-messages/APIMessages_de.properties ................................ 16:13:48 [] [] [] [] INFO RestVerticle git: https://github.com/folio-org/raml-module-builder.git a70c65db2f827dbe12c93e9447a625c772749ebc 16:13:48 [] [] [] [] INFO PomReader Reading from jar 16:13:48 [] [] [] [] INFO PomReader module name: mod_kb_ebsco_java, version: 3.6.6 16:13:48 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start metrics enabled: false 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/status 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/providers 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials/{id}/root-proxy 16:13:49 [] [] [] [] INFO RestVerticle ^/_/ramls 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/titles/{titleId}/costperuse 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/loading/kb-credentials 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/custom-labels 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials/{id}/access-types 16:13:49 [] [] [] [] INFO RestVerticle ^/admin 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials/{id}/users 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/packages/{packageId}/costperuse 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/packages 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials/{id}/custom-labels 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/proxy-types 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/cache 16:13:49 [] [] [] [] INFO RestVerticle ^/_/jsonSchemas 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/resources/{resourceId}/costperuse 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/currencies 16:13:49 [] [] [] [] INFO RestVerticle ^/_/tenant 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/packages/{packageId}/resources/costperuse 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/user-kb-credential 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/resources 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/tags 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/uc 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/root-proxy 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials/{id}/uc 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/packages/{packageId}/resources/costperuse/export 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials/{id}/proxy-types 16:13:49 [] [] [] [] INFO RestVerticle ^/configurations 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/access-types 16:13:49 [] [] [] [] INFO RestVerticle ^/rmbtests 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/titles 16:13:49 [] [] [] [] INFO RestVerticle 1 verticles deployed 16:13:49 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle runHook One time hook called with implemented class named org.folio.rest.impl.InitAPIImpl 16:13:51 [] [] [] [] INFO eanMethodInterceptor @Bean method ApplicationConfig.placeholderConfigurer is non-static and returns an object assignable to Spring's BeanFactoryPostProcessor interface. This will result in a failure to process annotations such as @Autowired, @Resource and @PostConstruct within the method's declaring @Configuration class. Add the 'static' modifier to this method to avoid these container lifecycle issues; see @Bean javadoc for complete details. 16:13:52 [] [] [] [] INFO RestVerticle init succeeded....... 16:13:52 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle runPeriodicHook no periodic implementation found, continuing with deployment 16:13:53 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle runPostDeployHook no Post Deploy Hook implementation found, continuing with deployment 16:13:53 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start http server for apis and docs started on port 8081. 16:13:53 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start Documentation available at: http://localhost:8081/apidocs/ 16:13:53 [] [] [] [] INFO ? Succeeded in deploying verticle 16:13:54 [] [] [] [] INFO LogUtil 10.0.2.15:55690 GET / null HTTP_1_1 400 28 -1 tid=null Bad Request Invalid URL path requested / 16:13:59 [] [] [] [] INFO PostgresClient DB config read from environment variables 16:13:59 [] [] [] [] INFO PostgresClient postgreSQLClientConfig = {"maxPoolSize":5,"port":5432,"username":"folio_admin","host":"10.0.2.15","database":"okapi_modules","password":"..."} 16:14:00 [] [] [] [] INFO PostgresClient Executing multiple statements with id -1669000529 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} ALTER ROLE diku_mod_kb_ebsco_java SET search_path = "$user"; 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed ALTER ROLE diku_mod_kb_ebsco_java SET search_path = "$user"; 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ BEGIN BEGIN -- This only succeeds if show_trgm, a pg_trgm function, -- has been loaded into public schema. PERFORM public.show_trgm('a'); EXCEPTION WHEN undefined_function THEN BEGIN ALTER EXTENSION pg_trgm SET SCHEMA public; EXCEPTION WHEN undefined_object THEN NULL; END; END; END $$; 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed DO $$ BEGIN BEGIN -- This only succeeds if show_trgm, a pg_trgm function, -- has been loaded into public schema. PERFORM public.show_trgm('a'); EXCEPTION WHEN undefined_function THEN BEGIN ALTER EXTENSION pg_trgm SET SCHEMA public; EXCEPTION WHEN undefined_object THEN NULL; END; END; END $$; 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public; 16:14:00 [] [] [] [] WARN ? 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='1758', routine='CreateExtension', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public; 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public; 16:14:00 [] [] [] [] WARN ? 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='1758', routine='CreateExtension', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public; 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE TABLE IF NOT EXISTS diku_mod_kb_ebsco_java.rmb_job ( id UUID PRIMARY KEY, jsonb JSONB NOT NULL ); 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed CREATE TABLE IF NOT EXISTS diku_mod_kb_ebsco_java.rmb_job ( id UUID PRIMARY KEY, jsonb JSONB NOT NULL ); 16:14:00 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking postTenant 16:14:00 [] [] [] [] INFO LogUtil 10.0.2.15:55700 POST /_/tenant null HTTP_1_1 201 289 2078 tid=diku Created 16:14:00 [] [] [] [] INFO PostgresClient Executing multiple statements with id 545831479 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} SET search_path TO diku_mod_kb_ebsco_java; 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed SET search_path TO diku_mod_kb_ebsco_java; 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE TABLE IF NOT EXISTS diku_mod_kb_ebsco_java.rmb_internal_index ( name text PRIMARY KEY, def text NOT NULL, remove boolean NOT NULL ); 16:14:00 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='42P07', message='relation "rmb_internal_index" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='parse_utilcmd.c', line='209', routine='transformCreateStmt', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed CREATE TABLE IF NOT EXISTS diku_mod_kb_ebsco_java.rmb_internal_index ( name text PRIMARY KEY, def text NOT NULL, remove boolean NOT NULL ); 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} UPDATE diku_mod_kb_ebsco_java.rmb_internal_index SET remove = TRUE; 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed UPDATE diku_mod_kb_ebsco_java.rmb_internal_index SET remove = TRUE; 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE TABLE IF NOT EXISTS rmb_internal_analyze ( tablename text ); 16:14:00 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='42P07', message='relation "rmb_internal_analyze" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='parse_utilcmd.c', line='209', routine='transformCreateStmt', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed CREATE TABLE IF NOT EXISTS rmb_internal_analyze ( tablename text ); 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.count_estimate_smart2(bigint,bigint,text); 16:14:01 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getTenantByOperationId 16:14:01 [] [] [] [] INFO LogUtil 10.0.2.15:55700 GET /_/tenant/ef487f94-ac43-490d-a174-6ee91cd58976 null HTTP_1_1 200 289 91 tid=diku OK 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.count_estimate_smart2(bigint,bigint,text); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE FUNCTION diku_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; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE FUNCTION diku_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; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_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 = diku_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; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_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 = diku_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; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.count_estimate(query text) RETURNS bigint AS $$ DECLARE count bigint; est_count bigint; q text; BEGIN est_count = diku_mod_kb_ebsco_java.count_estimate_smart2(1000, 1000, query); IF est_count > 4*1000 THEN RETURN est_count; END IF; q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x'; EXECUTE q INTO count; IF count < 1000 THEN RETURN count; END IF; IF est_count < 1000 THEN RETURN 1000; END IF; RETURN est_count; END; $$ LANGUAGE plpgsql STABLE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.count_estimate(query text) RETURNS bigint AS $$ DECLARE count bigint; est_count bigint; q text; BEGIN est_count = diku_mod_kb_ebsco_java.count_estimate_smart2(1000, 1000, query); IF est_count > 4*1000 THEN RETURN est_count; END IF; q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x'; EXECUTE q INTO count; IF count < 1000 THEN RETURN count; END IF; IF est_count < 1000 THEN RETURN 1000; END IF; RETURN est_count; END; $$ LANGUAGE plpgsql STABLE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ DECLARE ver integer; BEGIN SELECT current_setting('server_version_num') INTO ver; IF (ver >= 120000) THEN CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.f_unaccent(text) RETURNS text AS $f_unaccent$ SELECT public.unaccent('public.unaccent', $1) -- schema-qualify function and dictionary $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; ELSE CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.f_unaccent(text) RETURNS text AS $f_unaccent$ SELECT regexp_replace(public.unaccent('public.unaccent', $1), E'[\u0300\u0301\u0302\u0303\u0304\u0305\u0306\u0307\u0308\u0309\u030a\u030b\u030c\u030d\u030e\u030f' || E'\u0310\u0311\u0312\u0313\u0314\u0315\u0316\u0317\u0318\u0319\u031a\u031b\u031c\u031d\u031e\u031f' || E'\u0320\u0321\u0322\u0323\u0324\u0325\u0326\u0327\u0328\u0329\u032a\u032b\u032c\u032d\u032e\u032f' || E'\u0330\u0331\u0332\u0333\u0334\u0335\u0336\u0337\u0338\u0339\u033a\u033b\u033c\u033d\u033e\u033f' || E'\u0340\u0341\u0342\u0343\u0344\u0345\u0346\u0347\u0348\u0349\u034a\u034b\u034c\u034d\u034e\u034f' || E'\u0350\u0351\u0352\u0353\u0354\u0355\u0356\u0357\u0358\u0359\u035a\u035b\u035c\u035d\u035e\u035f' || E'\u0360\u0361\u0362' || E'\u20dd\u20de\u20df\u20e0' || E'\u20e2\u20e3\u20e4]', '', 'g') $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; END IF; END $$; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ DECLARE ver integer; BEGIN SELECT current_setting('server_version_num') INTO ver; IF (ver >= 120000) THEN CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.f_unaccent(text) RETURNS text AS $f_unaccent$ SELECT public.unaccent('public.unaccent', $1) -- schema-qualify function and dictionary $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; ELSE CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.f_unaccent(text) RETURNS text AS $f_unaccent$ SELECT regexp_replace(public.unaccent('public.unaccent', $1), E'[\u0300\u0301\u0302\u0303\u0304\u0305\u0306\u0307\u0308\u0309\u030a\u030b\u030c\u030d\u030e\u030f' || E'\u0310\u0311\u0312\u0313\u0314\u0315\u0316\u0317\u0318\u0319\u031a\u031b\u031c\u031d\u031e\u031f' || E'\u0320\u0321\u0322\u0323\u0324\u0325\u0326\u0327\u0328\u0329\u032a\u032b\u032c\u032d\u032e\u032f' || E'\u0330\u0331\u0332\u0333\u0334\u0335\u0336\u0337\u0338\u0339\u033a\u033b\u033c\u033d\u033e\u033f' || E'\u0340\u0341\u0342\u0343\u0344\u0345\u0346\u0347\u0348\u0349\u034a\u034b\u034c\u034d\u034e\u034f' || E'\u0350\u0351\u0352\u0353\u0354\u0355\u0356\u0357\u0358\u0359\u035a\u035b\u035c\u035d\u035e\u035f' || E'\u0360\u0361\u0362' || E'\u20dd\u20de\u20df\u20e0' || E'\u20e2\u20e3\u20e4]', '', 'g') $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; END IF; END $$; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.get_tsvector(text) RETURNS tsvector AS $$ SELECT to_tsvector('simple', translate($1, '&', ',')); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.get_tsvector(text) RETURNS tsvector AS $$ SELECT to_tsvector('simple', translate($1, '&', ',')); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.tsquery_and(text) RETURNS tsquery AS $$ SELECT to_tsquery('simple', string_agg(CASE WHEN length(v) = 0 OR v = '*' THEN '' WHEN right(v, 1) = '*' THEN '''' || left(v, -1) || ''':*' ELSE '''' || v || '''' END, '&')) FROM (SELECT regexp_split_to_table(translate($1, '&''', ',,'), ' +')) AS x(v); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.tsquery_and(text) RETURNS tsquery AS $$ SELECT to_tsquery('simple', string_agg(CASE WHEN length(v) = 0 OR v = '*' THEN '' WHEN right(v, 1) = '*' THEN '''' || left(v, -1) || ''':*' ELSE '''' || v || '''' END, '&')) FROM (SELECT regexp_split_to_table(translate($1, '&''', ',,'), ' +')) AS x(v); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.tsquery_or(text) RETURNS tsquery AS $$ SELECT replace(diku_mod_kb_ebsco_java.tsquery_and($1)::text, '&', '|')::tsquery; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.tsquery_or(text) RETURNS tsquery AS $$ SELECT replace(diku_mod_kb_ebsco_java.tsquery_and($1)::text, '&', '|')::tsquery; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.tsquery_phrase(text) RETURNS tsquery AS $$ SELECT replace(diku_mod_kb_ebsco_java.tsquery_and($1)::text, '&', '<->')::tsquery; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.tsquery_phrase(text) RETURNS tsquery AS $$ SELECT replace(diku_mod_kb_ebsco_java.tsquery_and($1)::text, '&', '<->')::tsquery; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.normalize_digits(text) RETURNS text AS $$ SELECT translate((regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1], E' \t-', '') || CASE WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1] = '' THEN '' WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2] = '' THEN '' ELSE ' ' END || (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2]; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.normalize_digits(text) RETURNS text AS $$ SELECT translate((regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1], E' \t-', '') || CASE WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1] = '' THEN '' WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2] = '' THEN '' ELSE ' ' END || (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2]; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_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'; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_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'; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} create or replace function diku_mod_kb_ebsco_java.concat_space_sql(VARIADIC text[]) RETURNS text AS $$ select concat_ws(' ', VARIADIC $1); $$ LANGUAGE SQL IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed create or replace function diku_mod_kb_ebsco_java.concat_space_sql(VARIADIC text[]) RETURNS text AS $$ select concat_ws(' ', VARIADIC $1); $$ LANGUAGE SQL IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} create or replace function diku_mod_kb_ebsco_java.concat_array_object_values(jsonb_array jsonb, field text) RETURNS text AS $$ SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed create or replace function diku_mod_kb_ebsco_java.concat_array_object_values(jsonb_array jsonb, field text) RETURNS text AS $$ SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} create or replace function diku_mod_kb_ebsco_java.concat_array_object_values( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$ SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1) WHERE value->>$3 = $4; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed create or replace function diku_mod_kb_ebsco_java.concat_array_object_values( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$ SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1) WHERE value->>$3 = $4; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} create or replace function diku_mod_kb_ebsco_java.first_array_object_value( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$ SELECT value->>$2 FROM jsonb_array_elements($1) WHERE value->>$3 = $4 LIMIT 1; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed create or replace function diku_mod_kb_ebsco_java.first_array_object_value( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$ SELECT value->>$2 FROM jsonb_array_elements($1) WHERE value->>$3 = $4 LIMIT 1; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} create or replace function diku_mod_kb_ebsco_java.concat_array_object(jsonb_array jsonb) RETURNS text AS $$ SELECT string_agg(value::text, ' ') FROM jsonb_array_elements_text($1); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed create or replace function diku_mod_kb_ebsco_java.concat_array_object(jsonb_array jsonb) RETURNS text AS $$ SELECT string_agg(value::text, ' ') FROM jsonb_array_elements_text($1); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function rmb_internal_index(text,text,text) does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION rmb_internal_index( atable text, aname text, tops text, newdef text) RETURNS void AS $$ DECLARE olddef text; namep CONSTANT text = concat(aname, '_p'); prepareddef text; BEGIN IF tops = 'DELETE' THEN -- use case insensitive %s, not case sensitive %I -- no SQL injection because the names are hard-coded in schema.json EXECUTE format('DROP INDEX IF EXISTS %s', aname); EXECUTE 'DELETE FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE name = $1' USING aname; RETURN; END IF; SELECT def INTO olddef FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE name = aname; SELECT def INTO prepareddef FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE name = namep; prepareddef = replace(prepareddef, concat(' ', namep, ' ON '), concat(' ', aname, ' ON ')); IF prepareddef = newdef THEN EXECUTE format('DROP INDEX IF EXISTS %s', aname); EXECUTE format('ALTER INDEX IF EXISTS %s RENAME TO %s', namep, aname); EXECUTE 'DELETE FROM rmb_internal_index WHERE name = $1' USING namep; EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable; ELSIF olddef IS DISTINCT FROM newdef THEN EXECUTE format('DROP INDEX IF EXISTS %s', aname); EXECUTE newdef; EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable; END IF; EXECUTE 'INSERT INTO diku_mod_kb_ebsco_java.rmb_internal_index VALUES ($1, $2, FALSE) ' 'ON CONFLICT (name) DO UPDATE SET def = EXCLUDED.def, remove = EXCLUDED.remove' USING aname, newdef; END $$ LANGUAGE plpgsql; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION rmb_internal_index( atable text, aname text, tops text, newdef text) RETURNS void AS $$ DECLARE olddef text; namep CONSTANT text = concat(aname, '_p'); prepareddef text; BEGIN IF tops = 'DELETE' THEN -- use case insensitive %s, not case sensitive %I -- no SQL injection because the names are hard-coded in schema.json EXECUTE format('DROP INDEX IF EXISTS %s', aname); EXECUTE 'DELETE FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE name = $1' USING aname; RETURN; END IF; SELECT def INTO olddef FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE name = aname; SELECT def INTO prepareddef FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE name = namep; prepareddef = replace(prepareddef, concat(' ', namep, ' ON '), concat(' ', aname, ' ON ')); IF prepareddef = newdef THEN EXECUTE format('DROP INDEX IF EXISTS %s', aname); EXECUTE format('ALTER INDEX IF EXISTS %s RENAME TO %s', namep, aname); EXECUTE 'DELETE FROM rmb_internal_index WHERE name = $1' USING namep; EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable; ELSIF olddef IS DISTINCT FROM newdef THEN EXECUTE format('DROP INDEX IF EXISTS %s', aname); EXECUTE newdef; EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable; END IF; EXECUTE 'INSERT INTO diku_mod_kb_ebsco_java.rmb_internal_index VALUES ($1, $2, FALSE) ' 'ON CONFLICT (name) DO UPDATE SET def = EXCLUDED.def, remove = EXCLUDED.remove' USING aname, newdef; END $$ LANGUAGE plpgsql; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ BEGIN -- use advisory lock to prevent "tuple concurrently updated" -- https://issues.folio.org/browse/RMB-744 PERFORM pg_advisory_xact_lock(20201101, 1234567890); REVOKE ALL PRIVILEGES ON SCHEMA public FROM diku_mod_kb_ebsco_java; REVOKE CREATE ON SCHEMA public FROM PUBLIC; END $$; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ BEGIN -- use advisory lock to prevent "tuple concurrently updated" -- https://issues.folio.org/browse/RMB-744 PERFORM pg_advisory_xact_lock(20201101, 1234567890); REVOKE ALL PRIVILEGES ON SCHEMA public FROM diku_mod_kb_ebsco_java; REVOKE CREATE ON SCHEMA public FROM PUBLIC; END $$; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_tags_references ON diku_mod_kb_ebsco_java.tags CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_tags_references" for relation "diku_mod_kb_ebsco_java.tags" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_tags_references ON diku_mod_kb_ebsco_java.tags CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_tags_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_tags_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_tags_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_tags_ol_version_trigger ON diku_mod_kb_ebsco_java.tags CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_tags_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.tags" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_tags_ol_version_trigger ON diku_mod_kb_ebsco_java.tags CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.tags_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.tags_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.tags_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_packages_references ON diku_mod_kb_ebsco_java.packages CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_packages_references" for relation "diku_mod_kb_ebsco_java.packages" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_packages_references ON diku_mod_kb_ebsco_java.packages CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_packages_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_packages_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_packages_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_packages_ol_version_trigger ON diku_mod_kb_ebsco_java.packages CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_packages_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.packages" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_packages_ol_version_trigger ON diku_mod_kb_ebsco_java.packages CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.packages_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.packages_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.packages_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_providers_references ON diku_mod_kb_ebsco_java.providers CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_providers_references" for relation "diku_mod_kb_ebsco_java.providers" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_providers_references ON diku_mod_kb_ebsco_java.providers CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_providers_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_providers_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_providers_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_providers_ol_version_trigger ON diku_mod_kb_ebsco_java.providers CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_providers_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.providers" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_providers_ol_version_trigger ON diku_mod_kb_ebsco_java.providers CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.providers_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.providers_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.providers_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_resources_references ON diku_mod_kb_ebsco_java.resources CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_resources_references" for relation "diku_mod_kb_ebsco_java.resources" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_resources_references ON diku_mod_kb_ebsco_java.resources CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_resources_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_resources_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_resources_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_resources_ol_version_trigger ON diku_mod_kb_ebsco_java.resources CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_resources_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.resources" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_resources_ol_version_trigger ON diku_mod_kb_ebsco_java.resources CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.resources_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.resources_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.resources_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_titles_references ON diku_mod_kb_ebsco_java.titles CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_titles_references" for relation "diku_mod_kb_ebsco_java.titles" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_titles_references ON diku_mod_kb_ebsco_java.titles CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_titles_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_titles_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_titles_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_titles_ol_version_trigger ON diku_mod_kb_ebsco_java.titles CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_titles_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.titles" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_titles_ol_version_trigger ON diku_mod_kb_ebsco_java.titles CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.titles_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.titles_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.titles_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_access_types_references ON diku_mod_kb_ebsco_java.access_types CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_access_types_references" for relation "diku_mod_kb_ebsco_java.access_types" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_access_types_references ON diku_mod_kb_ebsco_java.access_types CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_access_types_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_access_types_ol_version_trigger ON diku_mod_kb_ebsco_java.access_types CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_access_types_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.access_types" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_access_types_ol_version_trigger ON diku_mod_kb_ebsco_java.access_types CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.access_types_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.access_types_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.access_types_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_access_types_mappings_references ON diku_mod_kb_ebsco_java.access_types_mappings CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_access_types_mappings_references" for relation "diku_mod_kb_ebsco_java.access_types_mappings" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_access_types_mappings_references ON diku_mod_kb_ebsco_java.access_types_mappings CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_mappings_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_access_types_mappings_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_mappings_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_access_types_mappings_ol_version_trigger ON diku_mod_kb_ebsco_java.access_types_mappings CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_access_types_mappings_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.access_types_mappings" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_access_types_mappings_ol_version_trigger ON diku_mod_kb_ebsco_java.access_types_mappings CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.access_types_mappings_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getTenantByOperationId 16:14:01 [] [] [] [] INFO LogUtil 10.0.2.15:55700 GET /_/tenant/ef487f94-ac43-490d-a174-6ee91cd58976 null HTTP_1_1 200 289 45 tid=diku OK 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.access_types_mappings_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.access_types_mappings_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_holdings_references ON diku_mod_kb_ebsco_java.holdings CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_holdings_references" for relation "diku_mod_kb_ebsco_java.holdings" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_holdings_references ON diku_mod_kb_ebsco_java.holdings CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_holdings_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_holdings_ol_version_trigger ON diku_mod_kb_ebsco_java.holdings CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_holdings_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.holdings" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_holdings_ol_version_trigger ON diku_mod_kb_ebsco_java.holdings CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.holdings_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.holdings_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.holdings_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_holdings_status_references ON diku_mod_kb_ebsco_java.holdings_status CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_holdings_status_references" for relation "diku_mod_kb_ebsco_java.holdings_status" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_holdings_status_references ON diku_mod_kb_ebsco_java.holdings_status CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_holdings_status_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_holdings_status_ol_version_trigger ON diku_mod_kb_ebsco_java.holdings_status CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_holdings_status_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.holdings_status" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_holdings_status_ol_version_trigger ON diku_mod_kb_ebsco_java.holdings_status CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.holdings_status_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.holdings_status_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.holdings_status_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_holdings_status_audit_references ON diku_mod_kb_ebsco_java.holdings_status_audit CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_holdings_status_audit_references" for relation "diku_mod_kb_ebsco_java.holdings_status_audit" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_holdings_status_audit_references ON diku_mod_kb_ebsco_java.holdings_status_audit CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_audit_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_holdings_status_audit_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_audit_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_holdings_status_audit_ol_version_trigger ON diku_mod_kb_ebsco_java.holdings_status_audit CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_holdings_status_audit_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.holdings_status_audit" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_holdings_status_audit_ol_version_trigger ON diku_mod_kb_ebsco_java.holdings_status_audit CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.holdings_status_audit_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.holdings_status_audit_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.holdings_status_audit_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_retry_status_references ON diku_mod_kb_ebsco_java.retry_status CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_retry_status_references" for relation "diku_mod_kb_ebsco_java.retry_status" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_retry_status_references ON diku_mod_kb_ebsco_java.retry_status CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_retry_status_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_retry_status_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_retry_status_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_retry_status_ol_version_trigger ON diku_mod_kb_ebsco_java.retry_status CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_retry_status_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.retry_status" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_retry_status_ol_version_trigger ON diku_mod_kb_ebsco_java.retry_status CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.retry_status_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.retry_status_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.retry_status_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_transaction_ids_references ON diku_mod_kb_ebsco_java.transaction_ids CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_transaction_ids_references" for relation "diku_mod_kb_ebsco_java.transaction_ids" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_transaction_ids_references ON diku_mod_kb_ebsco_java.transaction_ids CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_transaction_ids_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_transaction_ids_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_transaction_ids_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_transaction_ids_ol_version_trigger ON diku_mod_kb_ebsco_java.transaction_ids CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_transaction_ids_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.transaction_ids" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_transaction_ids_ol_version_trigger ON diku_mod_kb_ebsco_java.transaction_ids CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.transaction_ids_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.transaction_ids_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.transaction_ids_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON tags CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "tags" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON tags CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON packages CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "packages" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON packages CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON providers CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "providers" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON providers CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON resources CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "resources" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON resources CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON titles CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "titles" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON titles CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "holdings" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON retry_status CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "retry_status" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON retry_status CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "holdings_status" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status_audit CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "holdings_status_audit" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status_audit CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON transaction_ids CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "transaction_ids" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON transaction_ids CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "access_types" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types_mappings CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "access_types_mappings" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types_mappings CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON kb_credentials CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "kb_credentials" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON kb_credentials CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON assigned_users CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "assigned_users" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON assigned_users CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION change_owner (table_name varchar, owner varchar) RETURNS VOID AS $$ BEGIN EXECUTE format('ALTER TABLE %s OWNER TO %s', table_name, owner); END; $$ LANGUAGE plpgsql volatile; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION change_owner (table_name varchar, owner varchar) RETURNS VOID AS $$ BEGIN EXECUTE format('ALTER TABLE %s OWNER TO %s', table_name, owner); END; $$ LANGUAGE plpgsql volatile; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION change_owner_all () RETURNS VOID AS $$ DECLARE rec RECORD; BEGIN FOR rec IN (SELECT table_schema || '.' || table_name table_name, 'diku_mod_kb_ebsco_java' as owner FROM information_schema.tables WHERE table_schema = 'diku_mod_kb_ebsco_java') LOOP EXECUTE change_owner(rec.table_name, rec.owner); END LOOP; END; $$ LANGUAGE plpgsql volatile; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION change_owner_all () RETURNS VOID AS $$ DECLARE rec RECORD; BEGIN FOR rec IN (SELECT table_schema || '.' || table_name table_name, 'diku_mod_kb_ebsco_java' as owner FROM information_schema.tables WHERE table_schema = 'diku_mod_kb_ebsco_java') LOOP EXECUTE change_owner(rec.table_name, rec.owner); END LOOP; END; $$ LANGUAGE plpgsql volatile; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ BEGIN EXECUTE change_owner_all(); END $$ language plpgsql; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ BEGIN EXECUTE change_owner_all(); END $$ language plpgsql; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION change_owner_all; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION change_owner_all; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION change_owner; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION change_owner; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ DECLARE rec RECORD; BEGIN FOR rec IN ( SELECT 'ALTER FUNCTION ' || quote_ident(n.nspname) || '.' || quote_ident(p.proname) || '(' || pg_catalog.pg_get_function_identity_arguments(p.oid) || ') OWNER TO ' || n.nspname || ';' AS sql_statement FROM pg_catalog.pg_proc p JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace WHERE n.nspname = 'diku_mod_kb_ebsco_java' ) LOOP EXECUTE rec.sql_statement; END LOOP; END $$ LANGUAGE plpgsql; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ DECLARE rec RECORD; BEGIN FOR rec IN ( SELECT 'ALTER FUNCTION ' || quote_ident(n.nspname) || '.' || quote_ident(p.proname) || '(' || pg_catalog.pg_get_function_identity_arguments(p.oid) || ') OWNER TO ' || n.nspname || ';' AS sql_statement FROM pg_catalog.pg_proc p JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace WHERE n.nspname = 'diku_mod_kb_ebsco_java' ) LOOP EXECUTE rec.sql_statement; END LOOP; END $$ LANGUAGE plpgsql; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ DECLARE aname TEXT; BEGIN FOR aname IN SELECT name FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE remove = TRUE LOOP EXECUTE 'DROP INDEX IF EXISTS ' || aname; END LOOP; END $$; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ DECLARE aname TEXT; BEGIN FOR aname IN SELECT name FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE remove = TRUE LOOP EXECUTE 'DROP INDEX IF EXISTS ' || aname; END LOOP; END $$; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ DECLARE version TEXT; i RECORD; newindexdef TEXT; BEGIN SELECT jsonb->>'rmbVersion' INTO version FROM diku_mod_kb_ebsco_java.rmb_internal; IF version !~ '^(\d\.|1\d\.|2[0-8]\.|29\.[0-3]\.)' THEN -- skip this upgrade if last install/upgrade was made by RMB >= 29.4.x RETURN; END IF; FOR i IN SELECT * FROM pg_catalog.pg_indexes WHERE schemaname = 'diku_mod_kb_ebsco_java' LOOP newindexdef := regexp_replace(i.indexdef, -- \m = beginning of a word, \M = end of a word '\mpublic\.(f_unaccent|concat_space_sql|concat_array_object_values|concat_array_object)\M', 'diku_mod_kb_ebsco_java.\1', 'g'); IF newindexdef <> i.indexdef THEN EXECUTE 'DROP INDEX ' || i.indexname; EXECUTE newindexdef; EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING i.tablename; END IF; END LOOP; END $$; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ DECLARE version TEXT; i RECORD; newindexdef TEXT; BEGIN SELECT jsonb->>'rmbVersion' INTO version FROM diku_mod_kb_ebsco_java.rmb_internal; IF version !~ '^(\d\.|1\d\.|2[0-8]\.|29\.[0-3]\.)' THEN -- skip this upgrade if last install/upgrade was made by RMB >= 29.4.x RETURN; END IF; FOR i IN SELECT * FROM pg_catalog.pg_indexes WHERE schemaname = 'diku_mod_kb_ebsco_java' LOOP newindexdef := regexp_replace(i.indexdef, -- \m = beginning of a word, \M = end of a word '\mpublic\.(f_unaccent|concat_space_sql|concat_array_object_values|concat_array_object)\M', 'diku_mod_kb_ebsco_java.\1', 'g'); IF newindexdef <> i.indexdef THEN EXECUTE 'DROP INDEX ' || i.indexname; EXECUTE newindexdef; EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING i.tablename; END IF; END LOOP; END $$; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ DECLARE t TEXT; BEGIN FOR t IN SELECT DISTINCT tablename FROM rmb_internal_analyze LOOP EXECUTE 'ANALYZE ' || t; END LOOP; END $$; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ DECLARE t TEXT; BEGIN FOR t IN SELECT DISTINCT tablename FROM rmb_internal_analyze LOOP EXECUTE 'ANALYZE ' || t; END LOOP; END $$; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} TRUNCATE rmb_internal_analyze; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed TRUNCATE rmb_internal_analyze; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_kb_ebsco_java TO diku_mod_kb_ebsco_java; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_kb_ebsco_java TO diku_mod_kb_ebsco_java; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} UPDATE diku_mod_kb_ebsco_java.rmb_internal SET jsonb = jsonb || jsonb_build_object( 'rmbVersion', '32.1.0', 'moduleVersion', 'mod-kb-ebsco-java-3.6.6-SNAPSHOT', 'schemaJson', $mainftl${ "tables": [ { "tableName": "tags", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-tags-table.sql" }, { "tableName": "packages", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-packages-table.sql" }, { "tableName": "providers", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-providers-table.sql" }, { "tableName": "resources", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-resources-table.sql" }, { "tableName": "titles", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-titles-table.sql" }, { "tableName": "access_types", "fromModuleVersion": "mod-kb-ebsco-java-3.1.1", "withMetadata": false, "withAuditing": false }, { "tableName": "access_types_mappings", "fromModuleVersion": "mod-kb-ebsco-java-3.1.1", "withMetadata": false, "withAuditing": false }, { "tableName": "holdings", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-holdings-table.sql" }, { "tableName": "holdings_status", "fromModuleVersion": "mod-kb-ebsco-java-3.0.2", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-holdings-status-table.sql" }, { "tableName": "holdings_status_audit", "fromModuleVersion": "mod-kb-ebsco-java-3.0.2", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-holdings-status-audit-table.sql" }, { "tableName": "retry_status", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-retry-status-table.sql" }, { "tableName": "transaction_ids", "fromModuleVersion": "mod-kb-ebsco-java-3.1.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-transaction-ids-table.sql" } ], "scripts": [ { "run": "after", "snippetPath": "update_started_date_before_insertion.sql", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1" }, { "run": "after", "snippetPath": "drop_set_id_in_jsonb.sql" }, { "run": "after", "snippetPath": "change_table_owner.sql" }, { "run": "after", "snippetPath": "change_function_owner.sql" } ] } $mainftl$); 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed UPDATE diku_mod_kb_ebsco_java.rmb_internal SET jsonb = jsonb || jsonb_build_object( 'rmbVersion', '32.1.0', 'moduleVersion', 'mod-kb-ebsco-java-3.6.6-SNAPSHOT', 'schemaJson', $mainftl${ "tables": [ { "tableName": "tags", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-tags-table.sql" }, { "tableName": "packages", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-packages-table.sql" }, { "tableName": "providers", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-providers-table.sql" }, { "tableName": "resources", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-resources-table.sql" }, { "tableName": "titles", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-titles-table.sql" }, { "tableName": "access_types", "fromModuleVersion": "mod-kb-ebsco-java-3.1.1", "withMetadata": false, "withAuditing": false }, { "tableName": "access_types_mappings", "fromModuleVersion": "mod-kb-ebsco-java-3.1.1", "withMetadata": false, "withAuditing": false }, { "tableName": "holdings", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-holdings-table.sql" }, { "tableName": "holdings_status", "fromModuleVersion": "mod-kb-ebsco-java-3.0.2", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-holdings-status-table.sql" }, { "tableName": "holdings_status_audit", "fromModuleVersion": "mod-kb-ebsco-java-3.0.2", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-holdings-status-audit-table.sql" }, { "tableName": "retry_status", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-retry-status-table.sql" }, { "tableName": "transaction_ids", "fromModuleVersion": "mod-kb-ebsco-java-3.1.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-transaction-ids-table.sql" } ], "scripts": [ { "run": "after", "snippetPath": "update_started_date_before_insertion.sql", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1" }, { "run": "after", "snippetPath": "drop_set_id_in_jsonb.sql" }, { "run": "after", "snippetPath": "change_table_owner.sql" }, { "run": "after", "snippetPath": "change_function_owner.sql" } ] } $mainftl$); 16:14:01 [] [] [] [] INFO TenantApiImpl ************ Running schema updates ************ 16:14:01 [] [] [] [] INFO LiquibaseUtil Initializing schema diku_mod_kb_ebsco_java for tenant diku 16:14:01 [] [] [] [] INFO leConnectionProvider Attempting to get connection for diku 16:14:01 [] [] [] [] INFO PostgresClient DB config read from environment variables 16:14:01 [] [] [] [] INFO PostgresClient Using schema: diku 16:14:01 [] [] [] [] INFO PostgresClient postgreSQLClientConfig = {"maxPoolSize":5,"port":5432,"username":"diku_mod_kb_ebsco_java","host":"10.0.2.15","database":"okapi_modules","password":"..."} 16:14:06 [] [] [] [] INFO Slf4jLogger SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.databasechangeloglock 16:14:06 [] [] [] [] INFO Slf4jLogger SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.databasechangeloglock 16:14:06 [] [] [] [] INFO Slf4jLogger SELECT LOCKED FROM diku_mod_kb_ebsco_java.databasechangeloglock WHERE ID=1 16:14:06 [] [] [] [] INFO Slf4jLogger Successfully acquired change log lock 16:14:11 [] [] [] [] INFO Slf4jLogger SELECT MD5SUM FROM diku_mod_kb_ebsco_java.databasechangelog WHERE MD5SUM IS NOT NULL LIMIT 1 16:14:11 [] [] [] [] INFO Slf4jLogger SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.databasechangelog 16:14:11 [] [] [] [] INFO Slf4jLogger Reading from diku_mod_kb_ebsco_java.databasechangelog 16:14:11 [] [] [] [] INFO Slf4jLogger SELECT * FROM diku_mod_kb_ebsco_java.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC 16:14:11 [] [] [] [] INFO Slf4jLogger CREATE TABLE diku_mod_kb_ebsco_java.currencies (code VARCHAR(3) NOT NULL, description VARCHAR(100) NOT NULL, CONSTRAINT pk_currencies PRIMARY KEY (code)) 16:14:11 [] [] [] [] INFO Slf4jLogger Table currencies created 16:14:11 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-currencies-table.xml::MODKBEKBJ-492@@create-currencies-table::psmagin ran successfully in 16ms 16:14:11 [] [] [] [] INFO Slf4jLogger SELECT MAX(ORDEREXECUTED) FROM diku_mod_kb_ebsco_java.databasechangelog 16:14:11 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-492@@create-currencies-table', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-currencies-table.xml', NOW(), 108, '8:d07d5833264dd93c36c0abf4752cb3a3', 'createTable tableName=currencies', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:11 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.currencies(code, description) VALUES(?, ?) 16:14:11 [] [] [] [] INFO Slf4jLogger Executing JDBC DML batch was successful. 178 operations were executed, 1 individual UPDATE events were confirmed by the database. 16:14:11 [] [] [] [] INFO Slf4jLogger Data loaded from data/currencies.csv into currencies 16:14:11 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-currencies-table.xml::MODKBEKBJ-492@@populate-currencies::psmagin ran successfully in 42ms 16:14:11 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-492@@populate-currencies', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-currencies-table.xml', NOW(), 109, '8:0b3fb77ac6c89b6da7e5e7e69c2bfa4f', 'loadData tableName=currencies', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:11 [] [] [] [] INFO Slf4jLogger CREATE TABLE diku_mod_kb_ebsco_java.usage_consolidation_settings (id UUID NOT NULL, kb_credentials_id UUID NOT NULL, customer_key VARCHAR(100) NOT NULL, start_month VARCHAR(3) NOT NULL, currency VARCHAR(3) NOT NULL, platform_type VARCHAR(12) NOT NULL, created_date TIMESTAMP WITH TIME ZONE DEFAULT NOW() NOT NULL, created_by_user_id UUID NOT NULL, created_by_user_name VARCHAR(100) NOT NULL, updated_date TIMESTAMP WITH TIME ZONE, updated_by_user_id UUID, updated_by_user_name VARCHAR(100), CONSTRAINT pk_usage_consolidation_settings PRIMARY KEY (id), UNIQUE (kb_credentials_id)) 16:14:11 [] [] [] [] INFO Slf4jLogger Table usage_consolidation_settings created 16:14:11 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml::MODKBEKBJ-494@@create-usage-consolidation-settings-table::psmagin ran successfully in 30ms 16:14:11 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-494@@create-usage-consolidation-settings-table', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml', NOW(), 110, '8:abef055da8796b1a70602f2cc846a511', 'createTable tableName=usage_consolidation_settings', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:11 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.usage_consolidation_settings ADD CONSTRAINT fk_usage_consolidation_settings_kb_credentials FOREIGN KEY (kb_credentials_id) REFERENCES diku_mod_kb_ebsco_java.kb_credentials (id) ON UPDATE RESTRICT ON DELETE CASCADE 16:14:11 [] [] [] [] INFO Slf4jLogger Foreign key constraint added to usage_consolidation_settings (kb_credentials_id) 16:14:11 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml::MODKBEKBJ-494@@add-foreign-key-from-usage-consolidation-settings-to-kb-credentials::psmagin ran successfully in 24ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-494@@add-foreign-key-from-usage-consolidation-settings-to-kb-credentials', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml', NOW(), 111, '8:e0603675a51fd552e987b5e7f57dc97b', 'addForeignKeyConstraint baseTableName=usage_consolidation_settings, constraintName=fk_usage_consolidation_settings_kb_credentials, referencedTableName=kb_credentials', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.usage_consolidation_settings ADD CONSTRAINT fk_usage_consolidation_settings_currency FOREIGN KEY (currency) REFERENCES diku_mod_kb_ebsco_java.currencies (code) ON UPDATE RESTRICT ON DELETE RESTRICT 16:14:12 [] [] [] [] INFO Slf4jLogger Foreign key constraint added to usage_consolidation_settings (currency) 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml::MODKBEKBJ-494@@add-foreign-key-from-usage-consolidation-settings-to-currencies::psmagin ran successfully in 11ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-494@@add-foreign-key-from-usage-consolidation-settings-to-currencies', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml', NOW(), 112, '8:f9c3ee3962bad187f3f35aceb3240f43', 'addForeignKeyConstraint baseTableName=usage_consolidation_settings, constraintName=fk_usage_consolidation_settings_currency, referencedTableName=currencies', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.usage_consolidation_settings ADD CONSTRAINT chk_usage_consolidation_settings_start_month CHECK (start_month IN ('jan', 'feb', 'mar', 'apr', 'may', 'jun', 'jul', 'aug', 'sep', 'oct', 'nov', 'dec')) 16:14:12 [] [] [] [] INFO Slf4jLogger Custom SQL executed 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml::MODKBEKBJ-494@@add-check-for-usage-consolidation-settings-start-month::psmagin ran successfully in 12ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-494@@add-check-for-usage-consolidation-settings-start-month', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml', NOW(), 113, '8:adf0a74361b9bab3bf87202578a5679e', 'sql', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.usage_consolidation_settings ADD CONSTRAINT chk_usage_consolidation_settings_platform_type CHECK (platform_type IN ('all', 'publisher', 'nonPublisher')) 16:14:12 [] [] [] [] INFO Slf4jLogger Custom SQL executed 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml::MODKBEKBJ-494@@add-check-for-usage-consolidation-settings-platform-type::psmagin ran successfully in 9ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-494@@add-check-for-usage-consolidation-settings-platform-type', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml', NOW(), 114, '8:4a08621e61f9abfae480f0b5c83d2a58', 'sql', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger DROP VIEW diku_mod_kb_ebsco_java.access_types_view 16:14:12 [] [] [] [] INFO Slf4jLogger View access_types_view dropped 16:14:12 [] [] [] [] INFO Slf4jLogger CREATE VIEW diku_mod_kb_ebsco_java.access_types_view AS SELECT a.id AS id, a.credentials_id AS credentials_id, a.name AS name, a.description AS description, a.created_date AS created_date, a.created_by_user_id AS created_by_user_id, u1.user_name AS created_by_user_name, u1.last_name AS created_by_last_name, u1.first_name AS created_by_first_name, u1.middle_name AS created_by_middle_name, a.updated_date AS updated_date, a.updated_by_user_id AS updated_by_user_id, u2.user_name AS updated_by_user_name, u2.last_name AS updated_by_last_name, u2.first_name AS updated_by_first_name, u2.middle_name AS updated_by_middle_name, am.usage_number AS usage_number FROM access_types a LEFT JOIN kb_users u1 ON a.created_by_user_id = u1.id LEFT JOIN kb_users u2 ON a.updated_by_user_id = u2.id LEFT JOIN (SELECT access_type_id, COUNT(access_type_id) AS usage_number FROM access_types_mappings GROUP BY access_type_id) as am ON a.id = am.access_type_id ORDER BY a.created_date ASC 16:14:12 [] [] [] [] INFO Slf4jLogger View access_types_view created 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/update-access-types-view-user-name-column.xml::MODKBEKBJ-435@@update-access-types-view-user-name-column-name::psmagin ran successfully in 54ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-435@@update-access-types-view-user-name-column-name', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/update-access-types-view-user-name-column.xml', NOW(), 115, '8:ffbb125f81df98ea2dd89dfa29a1982a', 'dropView viewName=access_types_view; createView viewName=access_types_view', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger CREATE TABLE diku_mod_kb_ebsco_java.usage_consolidation_credentials (client_id VARCHAR(100) NOT NULL, client_secret VARCHAR(100) NOT NULL) 16:14:12 [] [] [] [] INFO Slf4jLogger Table usage_consolidation_credentials created 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-credentials-table.xml::MODKBEKBJ-496@@create-usage-consolidation-settings-table::psmagin ran successfully in 15ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-496@@create-usage-consolidation-settings-table', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-credentials-table.xml', NOW(), 116, '8:8368f0ab610997f131ab2aee7ab03928', 'createTable tableName=usage_consolidation_credentials', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.check_single_uc_credentials() RETURNS TRIGGER AS $$ BEGIN IF (TG_OP = 'INSERT') THEN IF ((SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.usage_consolidation_credentials) = 1) THEN RAISE EXCEPTION 'Only one credentials can exist'; END IF; END IF; RETURN NEW; END; $$ LANGUAGE plpgsql 16:14:12 [] [] [] [] INFO Slf4jLogger Stored procedure created 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-credentials-table.xml::MODKBEKBJ-496@@create-check-only-single-uc-credentials-trigger::psmagin ran successfully in 9ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-496@@create-check-only-single-uc-credentials-trigger', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-credentials-table.xml', NOW(), 117, '8:8e122110355d8042023705652c522266', 'createProcedure', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger CREATE TRIGGER check_single_uc_credentials_trigger BEFORE INSERT ON diku_mod_kb_ebsco_java.usage_consolidation_credentials FOR EACH ROW EXECUTE PROCEDURE diku_mod_kb_ebsco_java.check_single_uc_credentials() 16:14:12 [] [] [] [] INFO Slf4jLogger Custom SQL executed 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-credentials-table.xml::MODKBEKBJ-496@@enable-check-only-single-uc-credentials-trigger::psmagin ran successfully in 5ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-496@@enable-check-only-single-uc-credentials-trigger', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-credentials-table.xml', NOW(), 118, '8:a18bf4c70509885eaa06fee5fb279e20', 'sql', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger CREATE INDEX holdings_package_id_idx ON diku_mod_kb_ebsco_java.holdings(package_id) 16:14:12 [] [] [] [] INFO Slf4jLogger Index holdings_package_id_idx created 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-holdings-package-id-index.xml::MODKBEKBJ-487@@create-holdings-package-id-index::psmagin ran successfully in 10ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-487@@create-holdings-package-id-index', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-holdings-package-id-index.xml', NOW(), 119, '8:fcde0f6157fbf42e9c96f5412a0a3b6b', 'createIndex indexName=holdings_package_id_idx, tableName=holdings', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.holdings ALTER COLUMN package_id TYPE INTEGER USING (package_id::INTEGER) 16:14:12 [] [] [] [] INFO Slf4jLogger holdings.package_id datatype was changed to integer 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/alter-holdings-types.xml::MODKBEKBJ-527@@change-holdings-package-id-type-to-integer::psmagin ran successfully in 23ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-527@@change-holdings-package-id-type-to-integer', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/alter-holdings-types.xml', NOW(), 120, '8:9cb44ff347bec1da696b8204a671b351', 'modifyDataType columnName=package_id, tableName=holdings', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.holdings ALTER COLUMN title_id TYPE INTEGER USING (title_id::INTEGER) 16:14:12 [] [] [] [] INFO Slf4jLogger holdings.title_id datatype was changed to integer 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/alter-holdings-types.xml::MODKBEKBJ-527@@change-holdings-title-id-type-to-integer::psmagin ran successfully in 15ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-527@@change-holdings-title-id-type-to-integer', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/alter-holdings-types.xml', NOW(), 121, '8:7af885ebebe54e9801bdfb40c22bfcee', 'modifyDataType columnName=title_id, tableName=holdings', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.holdings ALTER COLUMN vendor_id TYPE INTEGER USING (vendor_id::INTEGER) 16:14:12 [] [] [] [] INFO Slf4jLogger holdings.vendor_id datatype was changed to integer 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/alter-holdings-types.xml::MODKBEKBJ-527@@change-holdings-vendor-id-type-to-integer::psmagin ran successfully in 19ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-527@@change-holdings-vendor-id-type-to-integer', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/alter-holdings-types.xml', NOW(), 122, '8:f9fa21da0b115cda9246dfda63a5cfbe', 'modifyDataType columnName=vendor_id, tableName=holdings', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.get_single_credentials_id() RETURNS uuid AS $$ DECLARE rowCount int; BEGIN rowCount = (SELECT count(*) FROM diku_mod_kb_ebsco_java.kb_credentials); IF rowCount = 1 THEN RETURN (SELECT id FROM diku_mod_kb_ebsco_java.kb_credentials); ELSE RAISE EXCEPTION 'Single credentials record expected but % found', rowCount; END IF; END; $$ LANGUAGE 'plpgsql' 16:14:12 [] [] [] [] INFO Slf4jLogger Stored procedure created 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml::MODKBEKBJ-556@@create-get-single-credentials-id-function::psmagin ran successfully in 6ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-556@@create-get-single-credentials-id-function', 'psmagin', 'liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml', NOW(), 123, '8:aab923f2ba1b92e8e3c8535c5de23ebc', 'createProcedure', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger SELECT count(*) FROM diku_mod_kb_ebsco_java.holdings_status WHERE credentials_id = (SELECT diku_mod_kb_ebsco_java.get_single_credentials_id()) 16:14:12 [] [] [] [] INFO Slf4jLogger Marking ChangeSet: liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml::MODKBEKBJ-556@@save-status-not-started-for-dummy-credentials::psmagin ran despite precondition failure due to onFail='MARK_RAN': liquibase/tenant/changelog.xml : SQL Precondition failed. Expected '0' got '1' 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-556@@save-status-not-started-for-dummy-credentials', 'psmagin', 'liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml', NOW(), 124, '8:1e3d35c03dc310a4b9f6d8c487381114', 'sql', '', 'MARK_RAN', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger SELECT count(*) FROM diku_mod_kb_ebsco_java.retry_status WHERE credentials_id = (SELECT diku_mod_kb_ebsco_java.get_single_credentials_id()) 16:14:12 [] [] [] [] INFO Slf4jLogger Marking ChangeSet: liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml::MODKBEKBJ-556@@save-retry-status-for-dummy-credentials::psmagin ran despite precondition failure due to onFail='MARK_RAN': liquibase/tenant/changelog.xml : SQL Precondition failed. Expected '0' got '1' 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-556@@save-retry-status-for-dummy-credentials', 'psmagin', 'liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml', NOW(), 125, '8:6c0bc3f0b145670dc86ed7a27b4deccb', 'sql', '', 'MARK_RAN', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.get_single_credentials_id() 16:14:12 [] [] [] [] INFO Slf4jLogger Custom SQL executed 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml::MODKBEKBJ-556@@drop-get-single-credentials-id-function::psmagin ran successfully in 5ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-556@@drop-get-single-credentials-id-function', 'psmagin', 'liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml', NOW(), 126, '8:9dc519722530b02d87b55472fded5d79', 'sql', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger Successfully released change log lock 16:14:12 [] [] [] [] INFO LiquibaseUtil Schema is initialized for tenant diku 16:14:12 [] [] [] [] INFO TenantApiImpl Schema updated for tenant: diku 16:14:12 [] [] [] [] INFO PostgresClient Executing multiple statements with id 1986706864 16:14:12 [] [] [] [] INFO TenantApiImpl Received flag to initialize test data. Check the server log for details. 16:14:12 [] [] [] [] INFO TenantApiImpl ************ Creating test data ************ 16:14:12 [] [] [] [] INFO PostgresClient trying to execute: {} INSERT INTO diku_mod_kb_ebsco_java.tags (id, record_id, record_type, tag) VALUES ('9c1e6f3c-682d-4af4-bd6b-20dad912ff94', '53-2767121-90099', 'resource', 'EBSCO'), ('103d6152-ce59-4793-b079-f2d216af7792', '53-2767121', 'package', 'folio'), ('ed0fdcac-1292-4354-adc2-7b80b58638e3', '413-1988660', 'package', 'spitfire'), ('52687cb3-ecd6-4570-a2e2-3e212f26bef8', '36-2728041', 'package', 'EBSCO') ON CONFLICT DO NOTHING; 16:14:12 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getTenantByOperationId 16:14:12 [] [] [] [] INFO LogUtil 10.0.2.15:55700 GET /_/tenant/ef487f94-ac43-490d-a174-6ee91cd58976 null HTTP_1_1 200 289 22 tid=diku OK 16:14:12 [] [] [] [] INFO PostgresClient Successfully executed INSERT INTO diku_mod_kb_ebsco_java.tags (id, record_id, record_type, tag) VALUES ('9c1e6f3c-682d-4af4-bd6b-20dad912ff94', '53-2767121-90099', 'resource', 'EBSCO'), ('103d6152-ce59-4793-b079-f2d216af7792', '53-2767121', 'package', 'folio'), ('ed0fdcac-1292-4354-adc2-7b80b58638e3', '413-1988660', 'package', 'spitfire'), ('52687cb3-ecd6-4570-a2e2-3e212f26bef8', '36-2728041', 'package', 'EBSCO') ON CONFLICT DO NOTHING; 16:14:12 [] [] [] [] INFO TenantAPI job ef487f94-ac43-490d-a174-6ee91cd58976 completed 16:14:12 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getTenantByOperationId 16:14:12 [] [] [] [] INFO LogUtil 10.0.2.15:55700 GET /_/tenant/ef487f94-ac43-490d-a174-6ee91cd58976 null HTTP_1_1 200 288 10 tid=diku OK 16:14:12 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking deleteTenantByOperationId 16:14:12 [] [] [] [] INFO LogUtil 10.0.2.15:55700 DELETE /_/tenant/ef487f94-ac43-490d-a174-6ee91cd58976 null HTTP_1_1 204 0 24 tid=diku No Content