exec java -Xmx256m -agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=5007 -XX:+ExitOnOutOfMemoryError -cp . -jar /usr/verticles/mod-kb-ebsco-java-fat.jar Listening for transport dt_socket at address: 5007 WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance. starting rest verticle service.......... 09 Oct 2020 14:45:26:325 INFO Version [] HV000001: Hibernate Validator null 09 Oct 2020 14:45:26:599 INFO Messages [] Loading messages from /infra-messages/APIMessages_de.properties ................................ 09 Oct 2020 14:45:26:600 INFO Messages [] Loading messages from /infra-messages/APIMessages_en.properties ................................ 09 Oct 2020 14:45:26:626 INFO RestVerticle [] git: https://github.com/folio-org/raml-module-builder.git 1f82ec6b096e421278817f22637eda00e32c89f0 09 Oct 2020 14:45:26:649 INFO PomReader [] Reading from jar 09 Oct 2020 14:45:26:687 INFO PomReader [] module name: mod_kb_ebsco_java, version: 3.5.4 09 Oct 2020 14:45:26:711 INFO LogUtil [] org.folio.rest.RestVerticle start metrics enabled: false 09 Oct 2020 14:45:26:934 INFO RestVerticle [] ^/eholdings/access-types 09 Oct 2020 14:45:26:950 INFO RestVerticle [] ^/eholdings/cache 09 Oct 2020 14:45:26:951 INFO RestVerticle [] ^/eholdings/kb-credentials/{id}/access-types 09 Oct 2020 14:45:26:952 INFO RestVerticle [] ^/eholdings/titles 09 Oct 2020 14:45:26:952 INFO RestVerticle [] ^/eholdings/custom-labels 09 Oct 2020 14:45:26:952 INFO RestVerticle [] ^/eholdings/kb-credentials/{id}/proxy-types 09 Oct 2020 14:45:26:953 INFO RestVerticle [] ^/eholdings/kb-credentials/{id}/root-proxy 09 Oct 2020 14:45:26:953 INFO RestVerticle [] ^/eholdings/packages 09 Oct 2020 14:45:26:953 INFO RestVerticle [] ^/eholdings/resources 09 Oct 2020 14:45:26:953 INFO RestVerticle [] ^/_/jsonSchemas 09 Oct 2020 14:45:26:954 INFO RestVerticle [] ^/eholdings/providers 09 Oct 2020 14:45:26:954 INFO RestVerticle [] ^/rmbtests 09 Oct 2020 14:45:26:954 INFO RestVerticle [] ^/admin 09 Oct 2020 14:45:26:955 INFO RestVerticle [] ^/eholdings/kb-credentials/{id}/users 09 Oct 2020 14:45:26:955 INFO RestVerticle [] ^/eholdings/status 09 Oct 2020 14:45:26:955 INFO RestVerticle [] ^/eholdings/kb-credentials 09 Oct 2020 14:45:26:956 INFO RestVerticle [] ^/eholdings/tags 09 Oct 2020 14:45:26:956 INFO RestVerticle [] ^/_/tenant 09 Oct 2020 14:45:26:956 INFO RestVerticle [] ^/eholdings/proxy-types 09 Oct 2020 14:45:26:956 INFO RestVerticle [] ^/eholdings/root-proxy 09 Oct 2020 14:45:26:957 INFO RestVerticle [] ^/eholdings/loading/kb-credentials 09 Oct 2020 14:45:26:957 INFO RestVerticle [] ^/eholdings/kb-credentials/{id}/custom-labels 09 Oct 2020 14:45:26:957 INFO RestVerticle [] ^configurations 09 Oct 2020 14:45:26:958 INFO RestVerticle [] ^/_/ramls 09 Oct 2020 14:45:26:958 INFO RestVerticle [] ^/eholdings/user-kb-credential 09 Oct 2020 14:45:26:970 INFO RestVerticle [] 1 verticles deployed 09 Oct 2020 14:45:27:102 INFO LogUtil [] org.folio.rest.RestVerticle runHook One time hook called with implemented class named org.folio.rest.impl.InitAPIImpl 09 Oct 2020 14:45:27:815 INFO ConfigurationClassEnhancer$BeanMethodInterceptor [] @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. 09 Oct 2020 14:45:28:548 INFO RestVerticle [] init succeeded....... 09 Oct 2020 14:45:28:627 INFO LogUtil [] org.folio.rest.RestVerticle runPeriodicHook no periodic implementation found, continuing with deployment 09 Oct 2020 14:45:28:883 INFO LogUtil [] org.folio.rest.RestVerticle runPostDeployHook no Post Deploy Hook implementation found, continuing with deployment 09 Oct 2020 14:45:28:884 INFO LogUtil [] org.folio.rest.RestVerticle start http server for apis and docs started on port 8081. 09 Oct 2020 14:45:28:885 INFO LogUtil [] org.folio.rest.RestVerticle start Documentation available at: http://localhost:8081/apidocs/ 09 Oct 2020 14:45:28:892 INFO VertxIsolatedDeployer [] Succeeded in deploying verticle 09 Oct 2020 14:46:27:938 INFO TenantAPI [] sending... postTenant for diku 09 Oct 2020 14:46:27:941 INFO PostgresClient [] DB config read from environment variables 09 Oct 2020 14:46:27:968 INFO PostgresClient [] postgreSQLClientConfig = {"maxPoolSize":5,"port":5432,"username":"folio_admin","host":"10.0.2.15","database":"okapi_modules","password":"..."} 09 Oct 2020 14:46:28:508 INFO PostgresClient [] Executing multiple statements with id 2032374816 09 Oct 2020 14:46:28:587 INFO PostgresClient [] trying to execute: ALTER ROLE diku_mod_kb_ebsco_java SET search_path = "$user" 09 Oct 2020 14:46:28:589 INFO PostgresClient [] Successfully executed: ALTER ROLE diku_mod_kb_ebsco_java SET search_path = "$user" 09 Oct 2020 14:46:28:590 INFO PostgresClient [] trying to execute: SET search_path TO diku_mod_kb_ebsco_java 09 Oct 2020 14:46:28:591 INFO PostgresClient [] Successfully executed: SET search_path TO diku_mod_kb_ebsco_java 09 Oct 2020 14:46:28:591 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 $$ 09 Oct 2020 14:46:28:596 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 $$ 09 Oct 2020 14:46:28:597 INFO PostgresClient [] trying to execute: CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public 09 Oct 2020 14:46:28:600 INFO PostgresClient [] Successfully executed: CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public 09 Oct 2020 14:46:28:600 INFO PostgresClient [] trying to execute: CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public 09 Oct 2020 14:46:28:601 INFO PostgresClient [] Successfully executed: CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public 09 Oct 2020 14:46:28:602 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 ) 09 Oct 2020 14:46:28:602 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 ) 09 Oct 2020 14:46:28:603 INFO PostgresClient [] trying to execute: UPDATE diku_mod_kb_ebsco_java.rmb_internal_index SET remove = TRUE 09 Oct 2020 14:46:28:606 INFO PostgresClient [] Successfully executed: UPDATE diku_mod_kb_ebsco_java.rmb_internal_index SET remove = TRUE 09 Oct 2020 14:46:28:607 INFO PostgresClient [] trying to execute: CREATE TABLE IF NOT EXISTS rmb_internal_analyze ( tablename text ) 09 Oct 2020 14:46:28:608 INFO PostgresClient [] Successfully executed: CREATE TABLE IF NOT EXISTS rmb_internal_analyze ( tablename text ) 09 Oct 2020 14:46:28:608 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.count_estimate_smart2(bigint,bigint,text) 09 Oct 2020 14:46:28:611 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.count_estimate_smart2(bigint,bigint,text) 09 Oct 2020 14:46:28:612 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 09 Oct 2020 14:46:28:617 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; 09 Oct 2020 14:46:28:618 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 09 Oct 2020 14:46:28:620 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 09 Oct 2020 14:46:28:620 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 09 Oct 2020 14:46:28:624 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 < 100 09 Oct 2020 14:46:28:624 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\u033 09 Oct 2020 14:46:28:627 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 STRIC 09 Oct 2020 14:46:28:627 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 09 Oct 2020 14:46:28:631 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 09 Oct 2020 14:46:28:631 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 09 Oct 2020 14:46:28:633 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, '&')) 09 Oct 2020 14:46:28:633 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 09 Oct 2020 14:46:28:634 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 09 Oct 2020 14:46:28:635 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 09 Oct 2020 14:46:28:635 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 09 Oct 2020 14:46:28:636 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 09 Oct 2020 14:46:28:636 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 ' ' 09 Oct 2020 14:46:28:636 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' 09 Oct 2020 14:46:28:637 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' 09 Oct 2020 14:46:28:638 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 09 Oct 2020 14:46:28:638 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 09 Oct 2020 14:46:28:638 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 09 Oct 2020 14:46:28:639 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 09 Oct 2020 14:46:28:639 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 09 Oct 2020 14:46:28:646 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 09 Oct 2020 14:46:28:648 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 09 Oct 2020 14:46:28:652 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 09 Oct 2020 14:46:28:653 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 09 Oct 2020 14:46:28:654 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 09 Oct 2020 14:46:28:654 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text) 09 Oct 2020 14:46:28:655 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text) 09 Oct 2020 14:46:28:655 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 'DE 09 Oct 2020 14:46:28:658 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 EX 09 Oct 2020 14:46:28:658 INFO PostgresClient [] trying to execute: REVOKE ALL PRIVILEGES ON SCHEMA public FROM diku_mod_kb_ebsco_java 09 Oct 2020 14:46:28:659 INFO PostgresClient [] Successfully executed: REVOKE ALL PRIVILEGES ON SCHEMA public FROM diku_mod_kb_ebsco_java 09 Oct 2020 14:46:28:659 INFO PostgresClient [] trying to execute: REVOKE CREATE ON SCHEMA public FROM PUBLIC 09 Oct 2020 14:46:28:660 INFO PostgresClient [] Successfully executed: REVOKE CREATE ON SCHEMA public FROM PUBLIC 09 Oct 2020 14:46:28:660 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_tags_references ON diku_mod_kb_ebsco_java.tags CASCADE 09 Oct 2020 14:46:28:662 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_tags_references ON diku_mod_kb_ebsco_java.tags CASCADE 09 Oct 2020 14:46:28:662 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_tags_references() 09 Oct 2020 14:46:28:665 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_tags_references() 09 Oct 2020 14:46:28:666 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_packages_references ON diku_mod_kb_ebsco_java.packages CASCADE 09 Oct 2020 14:46:28:666 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_packages_references ON diku_mod_kb_ebsco_java.packages CASCADE 09 Oct 2020 14:46:28:670 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_packages_references() 09 Oct 2020 14:46:28:670 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_packages_references() 09 Oct 2020 14:46:28:671 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_providers_references ON diku_mod_kb_ebsco_java.providers CASCADE 09 Oct 2020 14:46:28:671 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_providers_references ON diku_mod_kb_ebsco_java.providers CASCADE 09 Oct 2020 14:46:28:671 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_providers_references() 09 Oct 2020 14:46:28:672 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_providers_references() 09 Oct 2020 14:46:28:672 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_resources_references ON diku_mod_kb_ebsco_java.resources CASCADE 09 Oct 2020 14:46:28:673 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_resources_references ON diku_mod_kb_ebsco_java.resources CASCADE 09 Oct 2020 14:46:28:673 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_resources_references() 09 Oct 2020 14:46:28:673 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_resources_references() 09 Oct 2020 14:46:28:673 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_titles_references ON diku_mod_kb_ebsco_java.titles CASCADE 09 Oct 2020 14:46:28:674 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_titles_references ON diku_mod_kb_ebsco_java.titles CASCADE 09 Oct 2020 14:46:28:674 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_titles_references() 09 Oct 2020 14:46:28:674 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_titles_references() 09 Oct 2020 14:46:28:675 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_access_types_references ON diku_mod_kb_ebsco_java.access_types CASCADE 09 Oct 2020 14:46:28:675 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_access_types_references ON diku_mod_kb_ebsco_java.access_types CASCADE 09 Oct 2020 14:46:28:675 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_references() 09 Oct 2020 14:46:28:676 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_references() 09 Oct 2020 14:46:28:677 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_access_types_mappings_references ON diku_mod_kb_ebsco_java.access_types_mappings CASCADE 09 Oct 2020 14:46:28:678 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_access_types_mappings_references ON diku_mod_kb_ebsco_java.access_types_mappings CASCADE 09 Oct 2020 14:46:28:679 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_mappings_references() 09 Oct 2020 14:46:28:680 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_mappings_references() 09 Oct 2020 14:46:28:681 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_holdings_references ON diku_mod_kb_ebsco_java.holdings CASCADE 09 Oct 2020 14:46:28:683 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_holdings_references ON diku_mod_kb_ebsco_java.holdings CASCADE 09 Oct 2020 14:46:28:683 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_references() 09 Oct 2020 14:46:28:686 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_references() 09 Oct 2020 14:46:28:686 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_holdings_status_references ON diku_mod_kb_ebsco_java.holdings_status CASCADE 09 Oct 2020 14:46:28:687 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_holdings_status_references ON diku_mod_kb_ebsco_java.holdings_status CASCADE 09 Oct 2020 14:46:28:687 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_references() 09 Oct 2020 14:46:28:688 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_references() 09 Oct 2020 14:46:28:688 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_holdings_status_audit_references ON diku_mod_kb_ebsco_java.holdings_status_audit CASCADE 09 Oct 2020 14:46:28:688 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_holdings_status_audit_references ON diku_mod_kb_ebsco_java.holdings_status_audit CASCADE 09 Oct 2020 14:46:28:689 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_audit_references() 09 Oct 2020 14:46:28:689 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_audit_references() 09 Oct 2020 14:46:28:689 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_retry_status_references ON diku_mod_kb_ebsco_java.retry_status CASCADE 09 Oct 2020 14:46:28:690 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_retry_status_references ON diku_mod_kb_ebsco_java.retry_status CASCADE 09 Oct 2020 14:46:28:690 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_retry_status_references() 09 Oct 2020 14:46:28:690 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_retry_status_references() 09 Oct 2020 14:46:28:691 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_transaction_ids_references ON diku_mod_kb_ebsco_java.transaction_ids CASCADE 09 Oct 2020 14:46:28:691 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_transaction_ids_references ON diku_mod_kb_ebsco_java.transaction_ids CASCADE 09 Oct 2020 14:46:28:691 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_transaction_ids_references() 09 Oct 2020 14:46:28:692 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_transaction_ids_references() 09 Oct 2020 14:46:28:692 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON tags CASCADE 09 Oct 2020 14:46:28:693 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON tags CASCADE 09 Oct 2020 14:46:28:693 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON packages CASCADE 09 Oct 2020 14:46:28:695 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON packages CASCADE 09 Oct 2020 14:46:28:695 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON providers CASCADE 09 Oct 2020 14:46:28:696 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON providers CASCADE 09 Oct 2020 14:46:28:696 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON resources CASCADE 09 Oct 2020 14:46:28:697 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON resources CASCADE 09 Oct 2020 14:46:28:697 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON titles CASCADE 09 Oct 2020 14:46:28:698 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON titles CASCADE 09 Oct 2020 14:46:28:699 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings CASCADE 09 Oct 2020 14:46:28:699 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings CASCADE 09 Oct 2020 14:46:28:700 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON retry_status CASCADE 09 Oct 2020 14:46:28:700 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON retry_status CASCADE 09 Oct 2020 14:46:28:701 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status CASCADE 09 Oct 2020 14:46:28:701 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status CASCADE 09 Oct 2020 14:46:28:701 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status_audit CASCADE 09 Oct 2020 14:46:28:702 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status_audit CASCADE 09 Oct 2020 14:46:28:702 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON transaction_ids CASCADE 09 Oct 2020 14:46:28:703 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON transaction_ids CASCADE 09 Oct 2020 14:46:28:703 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types CASCADE 09 Oct 2020 14:46:28:703 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types CASCADE 09 Oct 2020 14:46:28:704 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types_mappings CASCADE 09 Oct 2020 14:46:28:705 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types_mappings CASCADE 09 Oct 2020 14:46:28:706 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON kb_credentials CASCADE 09 Oct 2020 14:46:28:706 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON kb_credentials CASCADE 09 Oct 2020 14:46:28:707 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON assigned_users CASCADE 09 Oct 2020 14:46:28:708 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON assigned_users CASCADE 09 Oct 2020 14:46:28:709 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 09 Oct 2020 14:46:28:713 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 09 Oct 2020 14:46:28:714 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 09 Oct 2020 14:46:28:716 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; $$ LA 09 Oct 2020 14:46:28:718 INFO PostgresClient [] trying to execute: DO $$ BEGIN EXECUTE change_owner_all(); END $$ language plpgsql 09 Oct 2020 14:46:28:723 INFO PostgresClient [] Successfully executed: DO $$ BEGIN EXECUTE change_owner_all(); END $$ language plpgsql 09 Oct 2020 14:46:28:723 INFO PostgresClient [] trying to execute: DROP FUNCTION change_owner_all 09 Oct 2020 14:46:28:723 INFO PostgresClient [] Successfully executed: DROP FUNCTION change_owner_all 09 Oct 2020 14:46:28:723 INFO PostgresClient [] trying to execute: DROP FUNCTION change_owner 09 Oct 2020 14:46:28:724 INFO PostgresClient [] Successfully executed: DROP FUNCTION change_owner 09 Oct 2020 14:46:28:724 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 09 Oct 2020 14:46:28:728 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 09 Oct 2020 14:46:28:728 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 $$ 09 Oct 2020 14:46:28:730 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 $$ 09 Oct 2020 14:46:28:730 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 $$ 09 Oct 2020 14:46:28:732 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' 09 Oct 2020 14:46:28:733 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 $$ 09 Oct 2020 14:46:28:734 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 $$ 09 Oct 2020 14:46:28:734 INFO PostgresClient [] trying to execute: TRUNCATE rmb_internal_analyze 09 Oct 2020 14:46:28:740 INFO PostgresClient [] Successfully executed: TRUNCATE rmb_internal_analyze 09 Oct 2020 14:46:28:740 INFO PostgresClient [] trying to execute: GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_kb_ebsco_java TO diku_mod_kb_ebsco_java 09 Oct 2020 14:46:28:745 INFO PostgresClient [] Successfully executed: GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_kb_ebsco_java TO diku_mod_kb_ebsco_java 09 Oct 2020 14:46:28:745 INFO PostgresClient [] trying to execute: UPDATE diku_mod_kb_ebsco_java.rmb_internal SET jsonb = jsonb || jsonb_build_object( 'rmbVersion', '31.1.0', 'moduleVersion', 'mod-kb-ebsco-java-3.5.4-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, "c 09 Oct 2020 14:46:28:750 INFO PostgresClient [] Successfully executed: UPDATE diku_mod_kb_ebsco_java.rmb_internal SET jsonb = jsonb || jsonb_build_object( 'rmbVersion', '31.1.0', 'moduleVersion', 'mod-kb-ebsco-java-3.5.4-SNAPSHOT', 'schemaJson', $mainftl${ "tables": [ { "tableName": "tags", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-tags- 09 Oct 2020 14:46:28:754 INFO PostgresClient [] Successfully committed: 2032374816 09 Oct 2020 14:46:28:822 INFO TenantApiImpl [] ************ Running schema updates ************ 09 Oct 2020 14:46:28:824 INFO LiquibaseUtil [] Initializing schema diku_mod_kb_ebsco_java for tenant diku 09 Oct 2020 14:46:28:828 INFO SingleConnectionProvider [] Attempting to get connection for diku 09 Oct 2020 14:46:28:828 INFO PostgresClient [] DB config read from environment variables 09 Oct 2020 14:46:28:829 INFO PostgresClient [] Using schema: diku 09 Oct 2020 14:46:28:830 INFO PostgresClient [] postgreSQLClientConfig = {"maxPoolSize":5,"port":5432,"username":"diku_mod_kb_ebsco_java","host":"10.0.2.15","database":"okapi_modules","password":"..."} 09 Oct 2020 14:46:31:086 INFO Slf4jLogger [] SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.databasechangeloglock 09 Oct 2020 14:46:31:090 INFO Slf4jLogger [] SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.databasechangeloglock 09 Oct 2020 14:46:31:094 INFO Slf4jLogger [] SELECT LOCKED FROM diku_mod_kb_ebsco_java.databasechangeloglock WHERE ID=1 09 Oct 2020 14:46:31:117 INFO Slf4jLogger [] Successfully acquired change log lock 09 Oct 2020 14:46:33:740 INFO Slf4jLogger [] SELECT MD5SUM FROM diku_mod_kb_ebsco_java.databasechangelog WHERE MD5SUM IS NOT NULL LIMIT 1 09 Oct 2020 14:46:33:758 INFO Slf4jLogger [] SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.databasechangelog 09 Oct 2020 14:46:33:759 INFO Slf4jLogger [] Reading from diku_mod_kb_ebsco_java.databasechangelog 09 Oct 2020 14:46:33:759 INFO Slf4jLogger [] SELECT * FROM diku_mod_kb_ebsco_java.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC 09 Oct 2020 14:46:33:893 INFO Slf4jLogger [] CREATE TABLE diku_mod_kb_ebsco_java.kb_users (id UUID NOT NULL, user_name VARCHAR(100), first_name VARCHAR(100), middle_name VARCHAR(100), last_name VARCHAR(100), patron_group VARCHAR(100), CONSTRAINT pk_kb_users PRIMARY KEY (id)) 09 Oct 2020 14:46:33:913 INFO Slf4jLogger [] Table kb_users created 09 Oct 2020 14:46:33:916 INFO Slf4jLogger [] ChangeSet liquibase/tenant/scripts/v3.5.3/create-kb-users-table.xml::MODKBEKBJ-435@@create-kb-users-table::psmagin ran successfully in 26ms 09 Oct 2020 14:46:33:917 INFO Slf4jLogger [] SELECT MAX(ORDEREXECUTED) FROM diku_mod_kb_ebsco_java.databasechangelog 09 Oct 2020 14:46:33:923 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@@create-kb-users-table', 'psmagin', 'liquibase/tenant/scripts/v3.5.3/create-kb-users-table.xml', NOW(), 94, '8:e839a8020ebaea5310b9ffc35c0e6865', 'createTable tableName=kb_users', '', 'EXECUTED', NULL, NULL, '3.8.9', '2254793774') 09 Oct 2020 14:46:33:928 INFO Slf4jLogger [] INSERT INTO kb_users (id, user_name, first_name, middle_name, last_name, patron_group) SELECT id, user_name, first_name, middle_name, last_name, patron_group FROM assigned_users ON CONFLICT(id) DO NOTHING 09 Oct 2020 14:46:33:930 INFO Slf4jLogger [] Custom SQL executed 09 Oct 2020 14:46:33:930 INFO Slf4jLogger [] ChangeSet liquibase/tenant/scripts/v3.5.3/create-kb-users-table.xml::MODKBEKBJ-435@@migrate-users-from-assigned-users-to-kb-users::psmagin ran successfully in 4ms 09 Oct 2020 14:46:33:932 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@@migrate-users-from-assigned-users-to-kb-users', 'psmagin', 'liquibase/tenant/scripts/v3.5.3/create-kb-users-table.xml', NOW(), 95, '8:7ccd0cd0e000bc022c2823ac12c38563', 'sql', '', 'EXECUTED', NULL, NULL, '3.8.9', '2254793774') 09 Oct 2020 14:46:33:936 INFO Slf4jLogger [] INSERT INTO kb_users (id, user_name, first_name, middle_name, last_name) SELECT DISTINCT created_by_user_id, created_by_username, created_by_first_name, created_by_middle_name, created_by_last_name FROM access_types ON CONFLICT(id) DO NOTHING 09 Oct 2020 14:46:33:938 INFO Slf4jLogger [] Custom SQL executed 09 Oct 2020 14:46:33:938 INFO Slf4jLogger [] ChangeSet liquibase/tenant/scripts/v3.5.3/create-kb-users-table.xml::MODKBEKBJ-435@@migrate-created-by-users-from-access-types-to-kb-users::psmagin ran successfully in 3ms 09 Oct 2020 14:46:33:939 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@@migrate-created-by-users-from-access-types-to-kb-users', 'psmagin', 'liquibase/tenant/scripts/v3.5.3/create-kb-users-table.xml', NOW(), 96, '8:f8dc95c37d3394d61a8aa329078524b8', 'sql', '', 'EXECUTED', NULL, NULL, '3.8.9', '2254793774') 09 Oct 2020 14:46:33:943 INFO Slf4jLogger [] INSERT INTO kb_users (id, user_name, first_name, middle_name, last_name) SELECT DISTINCT updated_by_user_id, updated_by_username, updated_by_first_name, updated_by_middle_name, updated_by_last_name FROM access_types WHERE updated_by_user_id IS NOT NULL ON CONFLICT(id) DO NOTHING 09 Oct 2020 14:46:33:944 INFO Slf4jLogger [] Custom SQL executed 09 Oct 2020 14:46:33:945 INFO Slf4jLogger [] ChangeSet liquibase/tenant/scripts/v3.5.3/create-kb-users-table.xml::MODKBEKBJ-435@@migrate-updated-by-users-from-access-types-to-kb-users::psmagin ran successfully in 4ms 09 Oct 2020 14:46:33:946 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@@migrate-updated-by-users-from-access-types-to-kb-users', 'psmagin', 'liquibase/tenant/scripts/v3.5.3/create-kb-users-table.xml', NOW(), 97, '8:faea81f8f0984c01bbbc2daad0ed095d', 'sql', '', 'EXECUTED', NULL, NULL, '3.8.9', '2254793774') 09 Oct 2020 14:46:33:949 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.assigned_users DROP COLUMN user_name 09 Oct 2020 14:46:33:954 INFO Slf4jLogger [] Column assigned_users.user_name dropped 09 Oct 2020 14:46:33:955 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.assigned_users DROP COLUMN first_name 09 Oct 2020 14:46:33:955 INFO Slf4jLogger [] Column assigned_users.first_name dropped 09 Oct 2020 14:46:33:956 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.assigned_users DROP COLUMN middle_name 09 Oct 2020 14:46:33:957 INFO Slf4jLogger [] Column assigned_users.middle_name dropped 09 Oct 2020 14:46:33:958 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.assigned_users DROP COLUMN last_name 09 Oct 2020 14:46:33:958 INFO Slf4jLogger [] Column assigned_users.last_name dropped 09 Oct 2020 14:46:33:959 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.assigned_users DROP COLUMN patron_group 09 Oct 2020 14:46:33:960 INFO Slf4jLogger [] Column assigned_users.patron_group dropped 09 Oct 2020 14:46:33:962 INFO Slf4jLogger [] ChangeSet liquibase/tenant/scripts/v3.5.3/alter-assigned-users-table.xml::MODKBEKBJ-435@@drop-deprecated-columns-from-assigned-users-table::psmagin ran successfully in 13ms 09 Oct 2020 14:46:33:964 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@@drop-deprecated-columns-from-assigned-users-table', 'psmagin', 'liquibase/tenant/scripts/v3.5.3/alter-assigned-users-table.xml', NOW(), 98, '8:2e1e7436e56aadb10252ff8961402312', 'dropColumn columnName=user_name, tableName=assigned_users; dropColumn columnName=first_name, tableName=assigned_users; dropColumn columnName=middle_name, tableName=assigned_users; dropColumn columnName=last_name, tableName=assigned_users; dropColu...', '', 'EXECUTED', NULL, NULL, '3.8.9', '2254793774') 09 Oct 2020 14:46:33:967 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.assigned_users RENAME COLUMN id TO user_id 09 Oct 2020 14:46:33:969 INFO Slf4jLogger [] Column assigned_users.id renamed to user_id 09 Oct 2020 14:46:33:970 INFO Slf4jLogger [] ChangeSet liquibase/tenant/scripts/v3.5.3/alter-assigned-users-table.xml::MODKBEKBJ-435@@rename-id-column-in-assigned-users-table::psmagin ran successfully in 3ms 09 Oct 2020 14:46:33:971 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@@rename-id-column-in-assigned-users-table', 'psmagin', 'liquibase/tenant/scripts/v3.5.3/alter-assigned-users-table.xml', NOW(), 99, '8:3fa4a31c65a989b3c217cbe107163921', 'renameColumn newColumnName=user_id, oldColumnName=id, tableName=assigned_users', '', 'EXECUTED', NULL, NULL, '3.8.9', '2254793774') 09 Oct 2020 14:46:33:974 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.assigned_users ADD CONSTRAINT fk_assigned_users_kb_users FOREIGN KEY (user_id) REFERENCES diku_mod_kb_ebsco_java.kb_users (id) ON UPDATE RESTRICT ON DELETE RESTRICT 09 Oct 2020 14:46:33:982 INFO Slf4jLogger [] Foreign key constraint added to assigned_users (user_id) 09 Oct 2020 14:46:33:984 INFO Slf4jLogger [] ChangeSet liquibase/tenant/scripts/v3.5.3/alter-assigned-users-table.xml::MODKBEKBJ-435@@add-foreign-key-from-assigned-users-to-kb-users::psmagin ran successfully in 9ms 09 Oct 2020 14:46:33:986 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@@add-foreign-key-from-assigned-users-to-kb-users', 'psmagin', 'liquibase/tenant/scripts/v3.5.3/alter-assigned-users-table.xml', NOW(), 100, '8:b02481a8fd22d9e0412a7c1487a80eb5', 'addForeignKeyConstraint baseTableName=assigned_users, constraintName=fk_assigned_users_kb_users, referencedTableName=kb_users', '', 'EXECUTED', NULL, NULL, '3.8.9', '2254793774') 09 Oct 2020 14:46:33:988 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.access_types DROP COLUMN created_by_username 09 Oct 2020 14:46:33:991 INFO Slf4jLogger [] Column access_types.created_by_username dropped 09 Oct 2020 14:46:33:992 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.access_types DROP COLUMN created_by_last_name 09 Oct 2020 14:46:33:993 INFO Slf4jLogger [] Column access_types.created_by_last_name dropped 09 Oct 2020 14:46:33:994 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.access_types DROP COLUMN created_by_first_name 09 Oct 2020 14:46:33:996 INFO Slf4jLogger [] Column access_types.created_by_first_name dropped 09 Oct 2020 14:46:33:996 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.access_types DROP COLUMN created_by_middle_name 09 Oct 2020 14:46:33:997 INFO Slf4jLogger [] Column access_types.created_by_middle_name dropped 09 Oct 2020 14:46:33:999 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.access_types DROP COLUMN updated_by_username 09 Oct 2020 14:46:34:000 INFO Slf4jLogger [] Column access_types.updated_by_username dropped 09 Oct 2020 14:46:34:001 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.access_types DROP COLUMN updated_by_last_name 09 Oct 2020 14:46:34:002 INFO Slf4jLogger [] Column access_types.updated_by_last_name dropped 09 Oct 2020 14:46:34:003 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.access_types DROP COLUMN updated_by_first_name 09 Oct 2020 14:46:34:004 INFO Slf4jLogger [] Column access_types.updated_by_first_name dropped 09 Oct 2020 14:46:34:004 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.access_types DROP COLUMN updated_by_middle_name 09 Oct 2020 14:46:34:005 INFO Slf4jLogger [] Column access_types.updated_by_middle_name dropped 09 Oct 2020 14:46:34:006 INFO Slf4jLogger [] ChangeSet liquibase/tenant/scripts/v3.5.3/alter-access-types-table.xml::MODKBEKBJ-435@@drop-deprecated-columns-from-access-types-table::psmagin ran successfully in 18ms 09 Oct 2020 14:46:34:008 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@@drop-deprecated-columns-from-access-types-table', 'psmagin', 'liquibase/tenant/scripts/v3.5.3/alter-access-types-table.xml', NOW(), 101, '8:7892c0272bc0388dd5140d45b48715d3', 'dropColumn columnName=created_by_username, tableName=access_types; dropColumn columnName=created_by_last_name, tableName=access_types; dropColumn columnName=created_by_first_name, tableName=access_types; dropColumn columnName=created_by_middle_nam...', '', 'EXECUTED', NULL, NULL, '3.8.9', '2254793774') 09 Oct 2020 14:46:34:012 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.access_types ADD CONSTRAINT fk_access_types_created_kb_users FOREIGN KEY (created_by_user_id) REFERENCES diku_mod_kb_ebsco_java.kb_users (id) ON UPDATE RESTRICT ON DELETE RESTRICT 09 Oct 2020 14:46:34:014 INFO Slf4jLogger [] Foreign key constraint added to access_types (created_by_user_id) 09 Oct 2020 14:46:34:017 INFO Slf4jLogger [] ChangeSet liquibase/tenant/scripts/v3.5.3/alter-access-types-table.xml::MODKBEKBJ-435@@add-foreign-keys-from-access-types-created-by-user-id-to-kb-users::psmagin ran successfully in 5ms 09 Oct 2020 14:46:34:019 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@@add-foreign-keys-from-access-types-created-by-user-id-to-kb-users', 'psmagin', 'liquibase/tenant/scripts/v3.5.3/alter-access-types-table.xml', NOW(), 102, '8:7e41232eac9f2b5d97949c0a078b4db5', 'addForeignKeyConstraint baseTableName=access_types, constraintName=fk_access_types_created_kb_users, referencedTableName=kb_users', '', 'EXECUTED', NULL, NULL, '3.8.9', '2254793774') 09 Oct 2020 14:46:34:022 INFO Slf4jLogger [] ALTER TABLE diku_mod_kb_ebsco_java.access_types ADD CONSTRAINT fk_access_types_updated_kb_users FOREIGN KEY (updated_by_user_id) REFERENCES diku_mod_kb_ebsco_java.kb_users (id) ON UPDATE RESTRICT ON DELETE RESTRICT 09 Oct 2020 14:46:34:026 INFO Slf4jLogger [] Foreign key constraint added to access_types (updated_by_user_id) 09 Oct 2020 14:46:34:028 INFO Slf4jLogger [] ChangeSet liquibase/tenant/scripts/v3.5.3/alter-access-types-table.xml::MODKBEKBJ-435@@add-foreign-keys-from-access-types-updated-by-user-id-to-kb-users::psmagin ran successfully in 6ms 09 Oct 2020 14:46:34:029 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@@add-foreign-keys-from-access-types-updated-by-user-id-to-kb-users', 'psmagin', 'liquibase/tenant/scripts/v3.5.3/alter-access-types-table.xml', NOW(), 103, '8:89f558ca604cc8bb7668765eb9a4de0e', 'addForeignKeyConstraint baseTableName=access_types, constraintName=fk_access_types_updated_kb_users, referencedTableName=kb_users', '', 'EXECUTED', NULL, NULL, '3.8.9', '2254793774') 09 Oct 2020 14:46:34:037 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_username, 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_username, 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 09 Oct 2020 14:46:34:050 INFO Slf4jLogger [] View access_types_view created 09 Oct 2020 14:46:34:052 INFO Slf4jLogger [] ChangeSet liquibase/tenant/scripts/v3.5.3/create-access-types-view.xml::MODKBEKBJ-435@@create-access-types-view::psmagin ran successfully in 19ms 09 Oct 2020 14:46:34:053 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@@create-access-types-view', 'psmagin', 'liquibase/tenant/scripts/v3.5.3/create-access-types-view.xml', NOW(), 104, '8:41b3d665c9d91cb9fd84702a37d2b116', 'createView viewName=access_types_view', '', 'EXECUTED', NULL, NULL, '3.8.9', '2254793774') 09 Oct 2020 14:46:34:056 INFO Slf4jLogger [] CREATE VIEW diku_mod_kb_ebsco_java.assigned_users_view AS SELECT a.user_id AS user_id, a.credentials_id AS credentials_id, u.user_name AS user_name, u.last_name AS last_name, u.first_name AS first_name, u.middle_name AS middle_name, u.patron_group AS patron_group FROM assigned_users a LEFT JOIN kb_users u ON a.user_id = u.id 09 Oct 2020 14:46:34:058 INFO Slf4jLogger [] View assigned_users_view created 09 Oct 2020 14:46:34:060 INFO Slf4jLogger [] ChangeSet liquibase/tenant/scripts/v3.5.3/create-assigned-users-view.xml::MODKBEKBJ-435@@create-assigned-users-view::psmagin ran successfully in 5ms 09 Oct 2020 14:46:34:062 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@@create-assigned-users-view', 'psmagin', 'liquibase/tenant/scripts/v3.5.3/create-assigned-users-view.xml', NOW(), 105, '8:a2bf16f21dc95d78ed81741133fc72d0', 'createView viewName=assigned_users_view', '', 'EXECUTED', NULL, NULL, '3.8.9', '2254793774') 09 Oct 2020 14:46:34:066 INFO Slf4jLogger [] Successfully released change log lock 09 Oct 2020 14:46:34:067 INFO LiquibaseUtil [] Schema is initialized for tenant diku 09 Oct 2020 14:46:34:068 INFO TenantApiImpl [] Schema updated for tenant: diku 09 Oct 2020 14:46:34:080 INFO PostgresClient [] Executing multiple statements with id 1986706864 09 Oct 2020 14:46:34:089 INFO TenantApiImpl [] Received flag to initialize test data. Check the server log for details. 09 Oct 2020 14:46:34:089 INFO TenantApiImpl [] ************ Creating test data ************ 09 Oct 2020 14:46:34:101 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 09 Oct 2020 14:46:34:103 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 C 09 Oct 2020 14:46:34:104 INFO PostgresClient [] Successfully committed: 1986706864 09 Oct 2020 14:46:34:107 INFO LogUtil [reqId=925749/proxy;360678/tenant] org.folio.rest.RestVerticle start invoking postTenant 09 Oct 2020 14:46:34:126 INFO LogUtil [reqId=925749/proxy;360678/tenant] 10.0.2.15:37814 POST /_/tenant null HTTP_1_1 200 3 6599 tid=diku OK