/usr/lib/jvm/java-11-openjdk-amd64/bin/java -Dvisualvm.id=1900375788570704 -Duser.language=en -Duser.region=US -javaagent:/home/grabse/java/idea-IU-203.7148.57/lib/idea_rt.jar=37421:/home/grabse/java/idea-IU-203.7148.57/bin -Dfile.encoding=UTF-8 -classpath /home/grabse/IdeaProjects/mod-orders-storage/target/classes:/home/grabse/.m2/repository/one/util/streamex/0.7.3/streamex-0.7.3.jar:/home/grabse/.m2/repository/org/folio/domain-models-api-interfaces/33.0.0/domain-models-api-interfaces-33.0.0.jar:/home/grabse/.m2/repository/io/vertx/vertx-core/4.1.0.CR1/vertx-core-4.1.0.CR1.jar:/home/grabse/.m2/repository/io/netty/netty-common/4.1.65.Final/netty-common-4.1.65.Final.jar:/home/grabse/.m2/repository/io/netty/netty-buffer/4.1.65.Final/netty-buffer-4.1.65.Final.jar:/home/grabse/.m2/repository/io/netty/netty-transport/4.1.65.Final/netty-transport-4.1.65.Final.jar:/home/grabse/.m2/repository/io/netty/netty-handler/4.1.65.Final/netty-handler-4.1.65.Final.jar:/home/grabse/.m2/repository/io/netty/netty-codec/4.1.65.Final/netty-codec-4.1.65.Final.jar:/home/grabse/.m2/repository/io/netty/netty-handler-proxy/4.1.65.Final/netty-handler-proxy-4.1.65.Final.jar:/home/grabse/.m2/repository/io/netty/netty-codec-socks/4.1.65.Final/netty-codec-socks-4.1.65.Final.jar:/home/grabse/.m2/repository/io/netty/netty-codec-http/4.1.65.Final/netty-codec-http-4.1.65.Final.jar:/home/grabse/.m2/repository/io/netty/netty-codec-http2/4.1.65.Final/netty-codec-http2-4.1.65.Final.jar:/home/grabse/.m2/repository/io/netty/netty-resolver/4.1.65.Final/netty-resolver-4.1.65.Final.jar:/home/grabse/.m2/repository/io/netty/netty-resolver-dns/4.1.65.Final/netty-resolver-dns-4.1.65.Final.jar:/home/grabse/.m2/repository/io/netty/netty-codec-dns/4.1.65.Final/netty-codec-dns-4.1.65.Final.jar:/home/grabse/.m2/repository/io/vertx/vertx-web/4.1.0.CR1/vertx-web-4.1.0.CR1.jar:/home/grabse/.m2/repository/io/vertx/vertx-web-common/4.1.0.CR1/vertx-web-common-4.1.0.CR1.jar:/home/grabse/.m2/repository/io/vertx/vertx-auth-common/4.1.0.CR1/vertx-auth-common-4.1.0.CR1.jar:/home/grabse/.m2/repository/io/vertx/vertx-bridge-common/4.1.0.CR1/vertx-bridge-common-4.1.0.CR1.jar:/home/grabse/.m2/repository/org/glassfish/jersey/media/jersey-media-json-jackson/2.34/jersey-media-json-jackson-2.34.jar:/home/grabse/.m2/repository/org/glassfish/jersey/core/jersey-common/2.34/jersey-common-2.34.jar:/home/grabse/.m2/repository/jakarta/ws/rs/jakarta.ws.rs-api/2.1.6/jakarta.ws.rs-api-2.1.6.jar:/home/grabse/.m2/repository/jakarta/annotation/jakarta.annotation-api/1.3.5/jakarta.annotation-api-1.3.5.jar:/home/grabse/.m2/repository/org/glassfish/hk2/external/jakarta.inject/2.6.1/jakarta.inject-2.6.1.jar:/home/grabse/.m2/repository/org/glassfish/hk2/osgi-resource-locator/1.0.3/osgi-resource-locator-1.0.3.jar:/home/grabse/.m2/repository/org/glassfish/jersey/ext/jersey-entity-filtering/2.34/jersey-entity-filtering-2.34.jar:/home/grabse/.m2/repository/com/fasterxml/jackson/module/jackson-module-jaxb-annotations/2.11.3/jackson-module-jaxb-annotations-2.11.3.jar:/home/grabse/.m2/repository/jakarta/activation/jakarta.activation-api/1.2.1/jakarta.activation-api-1.2.1.jar:/home/grabse/.m2/repository/com/fasterxml/jackson/core/jackson-core/2.11.3/jackson-core-2.11.3.jar:/home/grabse/.m2/repository/com/fasterxml/jackson/core/jackson-databind/2.11.3/jackson-databind-2.11.3.jar:/home/grabse/.m2/repository/com/fasterxml/jackson/core/jackson-annotations/2.11.3/jackson-annotations-2.11.3.jar:/home/grabse/.m2/repository/com/google/guava/guava/30.1.1-jre/guava-30.1.1-jre.jar:/home/grabse/.m2/repository/com/google/guava/failureaccess/1.0.1/failureaccess-1.0.1.jar:/home/grabse/.m2/repository/com/google/guava/listenablefuture/9999.0-empty-to-avoid-conflict-with-guava/listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar:/home/grabse/.m2/repository/org/checkerframework/checker-qual/3.8.0/checker-qual-3.8.0.jar:/home/grabse/.m2/repository/com/google/errorprone/error_prone_annotations/2.5.1/error_prone_annotations-2.5.1.jar:/home/grabse/.m2/repository/com/google/j2objc/j2objc-annotations/1.3/j2objc-annotations-1.3.jar:/home/grabse/.m2/repository/javax/ws/rs/javax.ws.rs-api/2.0.1/javax.ws.rs-api-2.0.1.jar:/home/grabse/.m2/repository/javax/mail/mailapi/1.4.3/mailapi-1.4.3.jar:/home/grabse/.m2/repository/javax/activation/activation/1.1/activation-1.1.jar:/home/grabse/.m2/repository/org/folio/domain-models-api-aspects/33.0.0/domain-models-api-aspects-33.0.0.jar:/home/grabse/.m2/repository/org/hibernate/validator/hibernate-validator/6.1.5.Final/hibernate-validator-6.1.5.Final.jar:/home/grabse/.m2/repository/jakarta/validation/jakarta.validation-api/2.0.2/jakarta.validation-api-2.0.2.jar:/home/grabse/.m2/repository/org/jboss/logging/jboss-logging/3.3.2.Final/jboss-logging-3.3.2.Final.jar:/home/grabse/.m2/repository/com/fasterxml/classmate/1.3.4/classmate-1.3.4.jar:/home/grabse/.m2/repository/javax/el/javax.el-api/3.0.1-b06/javax.el-api-3.0.1-b06.jar:/home/grabse/.m2/repository/javax/validation/validation-api/2.0.1.Final/validation-api-2.0.1.Final.jar:/home/grabse/.m2/repository/org/glassfish/javax.el/3.0.1-b11/javax.el-3.0.1-b11.jar:/home/grabse/.m2/repository/org/apache/commons/commons-lang3/3.11/commons-lang3-3.11.jar:/home/grabse/.m2/repository/org/aspectj/aspectjrt/1.9.6/aspectjrt-1.9.6.jar:/home/grabse/.m2/repository/org/javassist/javassist/3.27.0-GA/javassist-3.27.0-GA.jar:/home/grabse/.m2/repository/xerces/xmlParserAPIs/2.6.2/xmlParserAPIs-2.6.2.jar:/home/grabse/.m2/repository/org/apache/commons/commons-collections4/4.1/commons-collections4-4.1.jar:/home/grabse/.m2/repository/org/folio/domain-models-runtime/33.0.0/domain-models-runtime-33.0.0.jar:/home/grabse/.m2/repository/io/vertx/vertx-web-client/4.1.0.CR1/vertx-web-client-4.1.0.CR1.jar:/home/grabse/.m2/repository/com/ongres/scram/client/2.1/client-2.1.jar:/home/grabse/.m2/repository/com/ongres/scram/common/2.1/common-2.1.jar:/home/grabse/.m2/repository/com/ongres/stringprep/saslprep/1.1/saslprep-1.1.jar:/home/grabse/.m2/repository/com/ongres/stringprep/stringprep/1.1/stringprep-1.1.jar:/home/grabse/.m2/repository/org/folio/cql2pgjson/33.0.0/cql2pgjson-33.0.0.jar:/home/grabse/.m2/repository/org/folio/dbschema/33.0.0/dbschema-33.0.0.jar:/home/grabse/.m2/repository/org/folio/okapi/okapi-common/4.8.0/okapi-common-4.8.0.jar:/home/grabse/.m2/repository/io/vertx/vertx-micrometer-metrics/4.1.0.CR1/vertx-micrometer-metrics-4.1.0.CR1.jar:/home/grabse/.m2/repository/io/micrometer/micrometer-core/1.6.2/micrometer-core-1.6.2.jar:/home/grabse/.m2/repository/org/latencyutils/LatencyUtils/2.0.3/LatencyUtils-2.0.3.jar:/home/grabse/.m2/repository/org/hdrhistogram/HdrHistogram/2.1.10/HdrHistogram-2.1.10.jar:/home/grabse/.m2/repository/io/micrometer/micrometer-registry-influx/1.6.3/micrometer-registry-influx-1.6.3.jar:/home/grabse/.m2/repository/io/micrometer/micrometer-registry-prometheus/1.6.3/micrometer-registry-prometheus-1.6.3.jar:/home/grabse/.m2/repository/io/prometheus/simpleclient_common/0.9.0/simpleclient_common-0.9.0.jar:/home/grabse/.m2/repository/io/prometheus/simpleclient/0.9.0/simpleclient-0.9.0.jar:/home/grabse/.m2/repository/io/micrometer/micrometer-registry-jmx/1.6.3/micrometer-registry-jmx-1.6.3.jar:/home/grabse/.m2/repository/io/dropwizard/metrics/metrics-jmx/4.0.7/metrics-jmx-4.0.7.jar:/home/grabse/.m2/repository/io/dropwizard/metrics/metrics-core/4.0.7/metrics-core-4.0.7.jar:/home/grabse/.m2/repository/org/z3950/zing/cql-java/1.13/cql-java-1.13.jar:/home/grabse/.m2/repository/io/vertx/vertx-pg-client/4.1.0.CR1-FOLIO/vertx-pg-client-4.1.0.CR1-FOLIO.jar:/home/grabse/.m2/repository/io/vertx/vertx-sql-client/4.1.0.CR1-FOLIO/vertx-sql-client-4.1.0.CR1-FOLIO.jar:/home/grabse/.m2/repository/commons-io/commons-io/2.8.0/commons-io-2.8.0.jar:/home/grabse/.m2/repository/org/freemarker/freemarker/2.3.31/freemarker-2.3.31.jar:/home/grabse/.m2/repository/org/apache/logging/log4j/log4j-core/2.13.3/log4j-core-2.13.3.jar:/home/grabse/.m2/repository/org/apache/logging/log4j/log4j-api/2.13.3/log4j-api-2.13.3.jar:/home/grabse/.m2/repository/jakarta/xml/bind/jakarta.xml.bind-api/2.3.2/jakarta.xml.bind-api-2.3.2.jar:/home/grabse/.m2/repository/com/google/code/findbugs/jsr305/3.0.2/jsr305-3.0.2.jar:/home/grabse/.m2/repository/org/folio/folio-di-support/1.3.0/folio-di-support-1.3.0.jar:/home/grabse/.m2/repository/io/vertx/vertx-service-proxy/4.1.0.CR1/vertx-service-proxy-4.1.0.CR1.jar:/home/grabse/.m2/repository/org/springframework/spring-core/5.2.8.RELEASE/spring-core-5.2.8.RELEASE.jar:/home/grabse/.m2/repository/org/springframework/spring-jcl/5.2.8.RELEASE/spring-jcl-5.2.8.RELEASE.jar:/home/grabse/.m2/repository/org/springframework/spring-context/5.2.8.RELEASE/spring-context-5.2.8.RELEASE.jar:/home/grabse/.m2/repository/org/springframework/spring-aop/5.2.8.RELEASE/spring-aop-5.2.8.RELEASE.jar:/home/grabse/.m2/repository/org/springframework/spring-beans/5.2.8.RELEASE/spring-beans-5.2.8.RELEASE.jar:/home/grabse/.m2/repository/org/springframework/spring-expression/5.2.8.RELEASE/spring-expression-5.2.8.RELEASE.jar:/home/grabse/.m2/repository/commons-lang/commons-lang/2.6/commons-lang-2.6.jar:/home/grabse/.m2/repository/org/slf4j/slf4j-api/1.7.30/slf4j-api-1.7.30.jar:/home/grabse/.m2/repository/org/folio/util/33.0.0/util-33.0.0.jar:/home/grabse/.m2/repository/org/folio/testing/33.0.0/testing-33.0.0.jar org.folio.rest.RestLauncher run org.folio.rest.RestVerticle -Dhttp.port=8082 -Duser.language=en -Duser.region=US
starting rest verticle service..........
2021-10-01T16:15:45,605 INFO  [vert.x-eventloop-thread-1] RestVerticle git: https://github.com/folio-org/raml-module-builder.git dd850aff5b138c57456fe721044118732c474a37
2021-10-01T16:15:45,612 WARN  [vert.x-eventloop-thread-1] RestVerticle The following cmd line parameter was skipped, run. Expected format key=value
If this is a JVM argument, pass it before the jar, not after
2021-10-01T16:15:45,612 WARN  [vert.x-eventloop-thread-1] RestVerticle The following cmd line parameter was skipped, org.folio.rest.RestVerticle. Expected format key=value
If this is a JVM argument, pass it before the jar, not after
2021-10-01T16:15:45,612 INFO  [vert.x-eventloop-thread-1] RestVerticle module specific argument added: -Dhttp.port with value 8082
2021-10-01T16:15:45,612 INFO  [vert.x-eventloop-thread-1] RestVerticle module specific argument added: -Duser.language with value en
2021-10-01T16:15:45,613 INFO  [vert.x-eventloop-thread-1] RestVerticle module specific argument added: -Duser.region with value US
2021-10-01T16:15:45,613 INFO  [vert.x-eventloop-thread-1] RestVerticle metrics enabled: false
2021-10-01T16:15:45,693 INFO  [vert.x-eventloop-thread-1] Messages Loading messages from /infra-messages/APIMessages_de.properties ................................
2021-10-01T16:15:45,694 INFO  [vert.x-eventloop-thread-1] Messages Loading messages from /infra-messages/APIMessages_en.properties ................................
2021-10-01T16:15:45,885 INFO  [vert.x-eventloop-thread-1] Version HV000001: Hibernate Validator 6.1.5.Final
2021-10-01T16:15:46,435 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /_/jsonSchemas -> getJsonSchemas
2021-10-01T16:15:46,504 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /orders-storage/configuration/prefixes/{id} -> deleteOrdersStorageConfigurationPrefixesById
2021-10-01T16:15:46,504 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/configuration/prefixes/{id} -> getOrdersStorageConfigurationPrefixesById
2021-10-01T16:15:46,504 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /orders-storage/configuration/prefixes/{id} -> putOrdersStorageConfigurationPrefixesById
2021-10-01T16:15:46,504 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /orders-storage/configuration/reasons-for-closure/{id} -> deleteOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:15:46,505 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/configuration/reasons-for-closure/{id} -> getOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:15:46,505 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /orders-storage/configuration/reasons-for-closure/{id} -> putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:15:46,505 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /orders-storage/configuration/suffixes/{id} -> deleteOrdersStorageConfigurationSuffixesById
2021-10-01T16:15:46,505 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/configuration/suffixes/{id} -> getOrdersStorageConfigurationSuffixesById
2021-10-01T16:15:46,505 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /orders-storage/configuration/suffixes/{id} -> putOrdersStorageConfigurationSuffixesById
2021-10-01T16:15:46,505 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/configuration/prefixes -> getOrdersStorageConfigurationPrefixes
2021-10-01T16:15:46,505 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /orders-storage/configuration/prefixes -> postOrdersStorageConfigurationPrefixes
2021-10-01T16:15:46,505 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/configuration/reasons-for-closure -> getOrdersStorageConfigurationReasonsForClosure
2021-10-01T16:15:46,505 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /orders-storage/configuration/reasons-for-closure -> postOrdersStorageConfigurationReasonsForClosure
2021-10-01T16:15:46,506 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/configuration/suffixes -> getOrdersStorageConfigurationSuffixes
2021-10-01T16:15:46,506 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /orders-storage/configuration/suffixes -> postOrdersStorageConfigurationSuffixes
2021-10-01T16:15:46,551 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /orders-storage/po-lines/{id} -> deleteOrdersStoragePoLinesById
2021-10-01T16:15:46,551 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/po-lines/{id} -> getOrdersStoragePoLinesById
2021-10-01T16:15:46,551 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /orders-storage/po-lines/{id} -> putOrdersStoragePoLinesById
2021-10-01T16:15:46,551 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/po-lines -> getOrdersStoragePoLines
2021-10-01T16:15:46,552 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /orders-storage/po-lines -> postOrdersStoragePoLines
2021-10-01T16:15:46,599 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/po-number -> getOrdersStoragePoNumber
2021-10-01T16:15:46,641 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /admin/kill_query -> deleteAdminKillQuery
2021-10-01T16:15:46,642 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/cache_hit_rates -> getAdminCacheHitRates
2021-10-01T16:15:46,642 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/db_cache_summary -> getAdminDbCacheSummary
2021-10-01T16:15:46,642 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/health -> getAdminHealth
2021-10-01T16:15:46,642 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/jstack -> getAdminJstack
2021-10-01T16:15:46,642 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /admin/jstack -> putAdminJstack
2021-10-01T16:15:46,642 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/list_locking_queries -> getAdminListLockingQueries
2021-10-01T16:15:46,642 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/loglevel -> getAdminLoglevel
2021-10-01T16:15:46,643 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /admin/loglevel -> putAdminLoglevel
2021-10-01T16:15:46,643 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/memory -> getAdminMemory
2021-10-01T16:15:46,643 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/postgres_active_sessions -> getAdminPostgresActiveSessions
2021-10-01T16:15:46,643 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/postgres_load -> getAdminPostgresLoad
2021-10-01T16:15:46,643 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/postgres_table_access_stats -> getAdminPostgresTableAccessStats
2021-10-01T16:15:46,643 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/postgres_table_size -> getAdminPostgresTableSize
2021-10-01T16:15:46,643 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/slow_queries -> getAdminSlowQueries
2021-10-01T16:15:46,643 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/table_index_usage -> getAdminTableIndexUsage
2021-10-01T16:15:46,644 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /admin/total_db_size -> getAdminTotalDbSize
2021-10-01T16:15:46,644 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /admin/get_password -> postAdminGetPassword
2021-10-01T16:15:46,644 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /admin/importSQL -> postAdminImportSQL
2021-10-01T16:15:46,644 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /admin/postgres_maintenance -> postAdminPostgresMaintenance
2021-10-01T16:15:46,644 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /admin/set_AES_key -> postAdminSetAESKey
2021-10-01T16:15:46,644 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /admin/postgres_create_indexes -> putAdminPostgresCreateIndexes
2021-10-01T16:15:46,644 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /admin/postgres_drop_indexes -> putAdminPostgresDropIndexes
2021-10-01T16:15:46,682 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /orders-storage/titles/{id} -> deleteOrdersStorageTitlesById
2021-10-01T16:15:46,682 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/titles/{id} -> getOrdersStorageTitlesById
2021-10-01T16:15:46,682 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /orders-storage/titles/{id} -> putOrdersStorageTitlesById
2021-10-01T16:15:46,682 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/titles -> getOrdersStorageTitles
2021-10-01T16:15:46,682 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /orders-storage/titles -> postOrdersStorageTitles
2021-10-01T16:15:46,719 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /_/tenant/{operation_id} -> deleteTenantByOperationId
2021-10-01T16:15:46,719 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /_/tenant/{operation_id} -> getTenantByOperationId
2021-10-01T16:15:46,719 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /_/tenant -> postTenant
2021-10-01T16:15:46,779 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/po-line-number -> getOrdersStoragePoLineNumber
2021-10-01T16:15:46,825 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /_/ramls -> getRamls
2021-10-01T16:15:46,871 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /orders-storage/purchase-orders/{id} -> deleteOrdersStoragePurchaseOrdersById
2021-10-01T16:15:46,871 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/purchase-orders/{id} -> getOrdersStoragePurchaseOrdersById
2021-10-01T16:15:46,871 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /orders-storage/purchase-orders/{id} -> putOrdersStoragePurchaseOrdersById
2021-10-01T16:15:46,872 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/purchase-orders -> getOrdersStoragePurchaseOrders
2021-10-01T16:15:46,872 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /orders-storage/purchase-orders -> postOrdersStoragePurchaseOrders
2021-10-01T16:15:46,918 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /orders-storage/order-templates/{id} -> deleteOrdersStorageOrderTemplatesById
2021-10-01T16:15:46,918 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/order-templates/{id} -> getOrdersStorageOrderTemplatesById
2021-10-01T16:15:46,918 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /orders-storage/order-templates/{id} -> putOrdersStorageOrderTemplatesById
2021-10-01T16:15:46,918 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/order-templates -> getOrdersStorageOrderTemplates
2021-10-01T16:15:46,918 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /orders-storage/order-templates -> postOrdersStorageOrderTemplates
2021-10-01T16:15:46,950 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /orders-storage/reporting-codes/{id} -> deleteOrdersStorageReportingCodesById
2021-10-01T16:15:46,950 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/reporting-codes/{id} -> getOrdersStorageReportingCodesById
2021-10-01T16:15:46,950 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /orders-storage/reporting-codes/{id} -> putOrdersStorageReportingCodesById
2021-10-01T16:15:46,950 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/reporting-codes -> getOrdersStorageReportingCodes
2021-10-01T16:15:46,950 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /orders-storage/reporting-codes -> postOrdersStorageReportingCodes
2021-10-01T16:15:46,983 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /acquisitions-units-storage/memberships/{id} -> deleteAcquisitionsUnitsStorageMembershipsById
2021-10-01T16:15:46,983 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /acquisitions-units-storage/memberships/{id} -> getAcquisitionsUnitsStorageMembershipsById
2021-10-01T16:15:46,983 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /acquisitions-units-storage/memberships/{id} -> putAcquisitionsUnitsStorageMembershipsById
2021-10-01T16:15:46,983 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /acquisitions-units-storage/units/{id} -> deleteAcquisitionsUnitsStorageUnitsById
2021-10-01T16:15:46,983 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /acquisitions-units-storage/units/{id} -> getAcquisitionsUnitsStorageUnitsById
2021-10-01T16:15:46,983 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /acquisitions-units-storage/units/{id} -> putAcquisitionsUnitsStorageUnitsById
2021-10-01T16:15:46,984 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /acquisitions-units-storage/memberships -> getAcquisitionsUnitsStorageMemberships
2021-10-01T16:15:46,984 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /acquisitions-units-storage/memberships -> postAcquisitionsUnitsStorageMemberships
2021-10-01T16:15:46,984 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /acquisitions-units-storage/units -> getAcquisitionsUnitsStorageUnits
2021-10-01T16:15:46,984 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /acquisitions-units-storage/units -> postAcquisitionsUnitsStorageUnits
2021-10-01T16:15:47,017 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /orders-storage/alerts/{id} -> deleteOrdersStorageAlertsById
2021-10-01T16:15:47,017 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/alerts/{id} -> getOrdersStorageAlertsById
2021-10-01T16:15:47,017 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /orders-storage/alerts/{id} -> putOrdersStorageAlertsById
2021-10-01T16:15:47,017 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/alerts -> getOrdersStorageAlerts
2021-10-01T16:15:47,017 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /orders-storage/alerts -> postOrdersStorageAlerts
2021-10-01T16:15:47,053 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /orders-storage/pieces/{id} -> deleteOrdersStoragePiecesById
2021-10-01T16:15:47,054 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/pieces/{id} -> getOrdersStoragePiecesById
2021-10-01T16:15:47,054 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /orders-storage/pieces/{id} -> putOrdersStoragePiecesById
2021-10-01T16:15:47,054 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/pieces -> getOrdersStoragePieces
2021-10-01T16:15:47,054 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /orders-storage/pieces -> postOrdersStoragePieces
2021-10-01T16:15:47,086 INFO  [vert.x-eventloop-thread-1] RestRouting Looks like org.folio.rest.jaxrs.resource.Rmbtests is not implemented
2021-10-01T16:15:47,135 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/receiving-history -> getOrdersStorageReceivingHistory
2021-10-01T16:15:47,178 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route DELETE /orders-storage/order-invoice-relns/{id} -> deleteOrdersStorageOrderInvoiceRelnsById
2021-10-01T16:15:47,178 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/order-invoice-relns/{id} -> getOrdersStorageOrderInvoiceRelnsById
2021-10-01T16:15:47,179 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route PUT /orders-storage/order-invoice-relns/{id} -> putOrdersStorageOrderInvoiceRelnsById
2021-10-01T16:15:47,179 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route GET /orders-storage/order-invoice-relns -> getOrdersStorageOrderInvoiceRelns
2021-10-01T16:15:47,179 INFO  [vert.x-eventloop-thread-1] RestRouting Adding route POST /orders-storage/order-invoice-relns -> postOrdersStorageOrderInvoiceRelns
2021-10-01T16:15:47,216 INFO  [vert.x-eventloop-thread-1] RestVerticle Init hook called with implemented class named org.folio.rest.impl.InitAPIs
2021-10-01T16:15:47,556 INFO  [vert.x-eventloop-thread-1] RestVerticle Listening port 8082
2021-10-01T16:15:47,669 INFO  [vert.x-eventloop-thread-1] RestVerticle No periodic implementation found, continuing with deployment
2021-10-01T16:15:47,716 INFO  [vert.x-eventloop-thread-1] RestVerticle No Post Deploy Hook implementation found, continuing with deployment
2021-10-01T16:15:47,719 INFO  [vert.x-eventloop-thread-0] VertxIsolatedDeployer Succeeded in deploying verticle
2021-10-01T16:36:25,853 INFO  [vert.x-eventloop-thread-1] RestRouting invoking postTenant
2021-10-01T16:36:25,872 INFO  [vert.x-eventloop-thread-1] LoadConfs File does not exist: /postgres-conf.json
2021-10-01T16:36:25,873 INFO  [vert.x-eventloop-thread-1] LoadConfs Resource has been loaded: /postgres-conf.json
2021-10-01T16:36:25,889 INFO  [vert.x-eventloop-thread-1] PostgresClient postgreSQLClientConfig = {"host":"localhost","port":5432,"database":"okapi_modules","username":"folio_admin","password":"...","postgres_tester":false}
2021-10-01T16:36:26,305 INFO  [vert.x-eventloop-thread-1] PostgresClient Executing multiple statements with id 454184603
2021-10-01T16:36:26,319 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} ALTER ROLE diku_mod_orders_storage SET search_path = "$user";
2021-10-01T16:36:26,321 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  ALTER ROLE diku_mod_orders_storage SET search_path = "$user";
2021-10-01T16:36:26,321 INFO  [vert.x-eventloop-thread-1] 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 $$;
2021-10-01T16:36:26,325 INFO  [vert.x-eventloop-thread-1] 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 $$;
2021-10-01T16:36:26,325 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public;
2021-10-01T16:36:26,328 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase 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='1761', routine='CreateExtension', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,328 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public;
2021-10-01T16:36:26,328 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public;
2021-10-01T16:36:26,329 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase 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='1761', routine='CreateExtension', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,329 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public;
2021-10-01T16:36:26,329 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE TABLE IF NOT EXISTS diku_mod_orders_storage.rmb_job (       id UUID PRIMARY KEY,       jsonb JSONB NOT NULL     );
2021-10-01T16:36:26,330 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42P07', message='relation "rmb_job" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='parse_utilcmd.c', line='209', routine='transformCreateStmt', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,330 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE TABLE IF NOT EXISTS diku_mod_orders_storage.rmb_job (       id UUID PRIMARY KEY,       jsonb JSONB NOT NULL     );
2021-10-01T16:36:26,404 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:38052 POST /_/tenant null HTTP_1_1 201 284 738 tid=diku Created 
2021-10-01T16:36:26,460 INFO  [vert.x-eventloop-thread-1] PostgresClient Executing multiple statements with id 80801446
2021-10-01T16:36:26,465 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getTenantByOperationId
2021-10-01T16:36:26,467 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} SET search_path TO diku_mod_orders_storage;
2021-10-01T16:36:26,468 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  SET search_path TO diku_mod_orders_storage;
2021-10-01T16:36:26,468 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE TABLE IF NOT EXISTS diku_mod_orders_storage.rmb_internal_index (   name text PRIMARY KEY,   def text NOT NULL,   remove boolean NOT NULL );
2021-10-01T16:36:26,469 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42P07', message='relation "rmb_internal_index" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='parse_utilcmd.c', line='209', routine='transformCreateStmt', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,469 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE TABLE IF NOT EXISTS diku_mod_orders_storage.rmb_internal_index (   name text PRIMARY KEY,   def text NOT NULL,   remove boolean NOT NULL );
2021-10-01T16:36:26,469 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} UPDATE diku_mod_orders_storage.rmb_internal_index SET remove = TRUE;
2021-10-01T16:36:26,473 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  UPDATE diku_mod_orders_storage.rmb_internal_index SET remove = TRUE;
2021-10-01T16:36:26,473 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE TABLE IF NOT EXISTS rmb_internal_analyze (   tablename text );
2021-10-01T16:36:26,477 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:38052 GET /_/tenant/96f0bfed-d0c4-49a6-8d7d-6eba57902dae null HTTP_1_1 200 284 13 tid=diku OK 
2021-10-01T16:36:26,478 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42P07', message='relation "rmb_internal_analyze" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='parse_utilcmd.c', line='209', routine='transformCreateStmt', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,478 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE TABLE IF NOT EXISTS rmb_internal_analyze (   tablename text );
2021-10-01T16:36:26,478 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_orders_storage.count_estimate_smart2(bigint,bigint,text);
2021-10-01T16:36:26,481 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  DROP FUNCTION IF EXISTS diku_mod_orders_storage.count_estimate_smart2(bigint,bigint,text);
2021-10-01T16:36:26,482 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE FUNCTION diku_mod_orders_storage.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;
2021-10-01T16:36:26,486 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE FUNCTION diku_mod_orders_storage.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;
2021-10-01T16:36:26,487 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.count_estimate_default(query text) RETURNS bigint AS $$
DECLARE
  rows bigint;
  q text;
BEGIN
  q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 20000) x';
  EXECUTE q INTO rows;
  IF rows < 20000 THEN
    return rows;
  END IF;
  rows = diku_mod_orders_storage.count_estimate_smart2(20000, 20000, query);
  IF rows < 20000 THEN
    return 20000;
  END IF;
  RETURN rows;
END;
$$ LANGUAGE plpgsql IMMUTABLE STRICT;
2021-10-01T16:36:26,488 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.count_estimate_default(query text) RETURNS bigint AS $$
DECLARE
  rows bigint;
  q text;
BEGIN
  q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 20000) x';
  EXECUTE q INTO rows;
  IF rows < 20000 THEN
    return rows;
  END IF;
  rows = diku_mod_orders_storage.count_estimate_smart2(20000, 20000, query);
  IF rows < 20000 THEN
    return 20000;
  END IF;
  RETURN rows;
END;
$$ LANGUAGE plpgsql IMMUTABLE STRICT;
2021-10-01T16:36:26,488 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.count_estimate(query text) RETURNS bigint AS $$
DECLARE
  count bigint;
  est_count bigint;
  q text;
BEGIN
  est_count = diku_mod_orders_storage.count_estimate_smart2(20000, 20000, query);
  IF est_count > 4*20000 THEN
    RETURN est_count;
  END IF;
  q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 20000) x';
  EXECUTE q INTO count;
  IF count < 20000 THEN
    RETURN count;
  END IF;
  IF est_count < 20000 THEN
    RETURN 20000;
  END IF;
  RETURN est_count;
END;
$$ LANGUAGE plpgsql STABLE STRICT;
2021-10-01T16:36:26,489 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.count_estimate(query text) RETURNS bigint AS $$
DECLARE
  count bigint;
  est_count bigint;
  q text;
BEGIN
  est_count = diku_mod_orders_storage.count_estimate_smart2(20000, 20000, query);
  IF est_count > 4*20000 THEN
    RETURN est_count;
  END IF;
  q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 20000) x';
  EXECUTE q INTO count;
  IF count < 20000 THEN
    RETURN count;
  END IF;
  IF est_count < 20000 THEN
    RETURN 20000;
  END IF;
  RETURN est_count;
END;
$$ LANGUAGE plpgsql STABLE STRICT;
2021-10-01T16:36:26,489 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.upsert(text, uuid, anyelement) RETURNS uuid AS $$
DECLARE
  ret uuid;
BEGIN
  EXECUTE format('UPDATE diku_mod_orders_storage.%I SET jsonb=$3 WHERE id=$2 RETURNING id', $1)
          USING $1, $2, $3 INTO ret;
  IF ret IS NOT NULL THEN
    RETURN ret;
  END IF;
  EXECUTE format('INSERT INTO diku_mod_orders_storage.%I (id, jsonb) VALUES ($2, $3) RETURNING id', $1)
          USING $1, $2, $3 INTO STRICT ret;
  RETURN ret;
END;
$$ LANGUAGE plpgsql;
2021-10-01T16:36:26,491 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.upsert(text, uuid, anyelement) RETURNS uuid AS $$
DECLARE
  ret uuid;
BEGIN
  EXECUTE format('UPDATE diku_mod_orders_storage.%I SET jsonb=$3 WHERE id=$2 RETURNING id', $1)
          USING $1, $2, $3 INTO ret;
  IF ret IS NOT NULL THEN
    RETURN ret;
  END IF;
  EXECUTE format('INSERT INTO diku_mod_orders_storage.%I (id, jsonb) VALUES ($2, $3) RETURNING id', $1)
          USING $1, $2, $3 INTO STRICT ret;
  RETURN ret;
END;
$$ LANGUAGE plpgsql;
2021-10-01T16:36:26,491 INFO  [vert.x-eventloop-thread-1] 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_orders_storage.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_orders_storage.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
$$;
2021-10-01T16:36:26,493 INFO  [vert.x-eventloop-thread-1] 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_orders_storage.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_orders_storage.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
$$;
2021-10-01T16:36:26,493 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.get_tsvector(text) RETURNS tsvector AS $$
  SELECT to_tsvector('simple', translate($1, '&', ','));
$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;
2021-10-01T16:36:26,494 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.get_tsvector(text) RETURNS tsvector AS $$
  SELECT to_tsvector('simple', translate($1, '&', ','));
$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;
2021-10-01T16:36:26,494 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.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;
2021-10-01T16:36:26,495 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.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;
2021-10-01T16:36:26,495 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.tsquery_or(text) RETURNS tsquery AS $$
  SELECT replace(diku_mod_orders_storage.tsquery_and($1)::text, '&', '|')::tsquery;
$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;
2021-10-01T16:36:26,496 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.tsquery_or(text) RETURNS tsquery AS $$
  SELECT replace(diku_mod_orders_storage.tsquery_and($1)::text, '&', '|')::tsquery;
$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;
2021-10-01T16:36:26,497 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.tsquery_phrase(text) RETURNS tsquery AS $$
  SELECT replace(diku_mod_orders_storage.tsquery_and($1)::text, '&', '<->')::tsquery;
$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;
2021-10-01T16:36:26,498 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.tsquery_phrase(text) RETURNS tsquery AS $$
  SELECT replace(diku_mod_orders_storage.tsquery_and($1)::text, '&', '<->')::tsquery;
$$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT;
2021-10-01T16:36:26,498 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.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;
2021-10-01T16:36:26,499 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.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;
2021-10-01T16:36:26,499 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_id_in_jsonb() RETURNS TRIGGER AS $$
BEGIN
  NEW.jsonb = jsonb_set(NEW.jsonb, '{id}', to_jsonb(NEW.id));
  RETURN NEW;
END;
$$ language 'plpgsql';
2021-10-01T16:36:26,500 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_id_in_jsonb() RETURNS TRIGGER AS $$
BEGIN
  NEW.jsonb = jsonb_set(NEW.jsonb, '{id}', to_jsonb(NEW.id));
  RETURN NEW;
END;
$$ language 'plpgsql';
2021-10-01T16:36:26,500 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} create or replace function diku_mod_orders_storage.concat_space_sql(VARIADIC text[]) RETURNS text AS $$ select concat_ws(' ', VARIADIC $1);
$$ LANGUAGE SQL IMMUTABLE PARALLEL SAFE STRICT;
2021-10-01T16:36:26,501 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  create or replace function diku_mod_orders_storage.concat_space_sql(VARIADIC text[]) RETURNS text AS $$ select concat_ws(' ', VARIADIC $1);
$$ LANGUAGE SQL IMMUTABLE PARALLEL SAFE STRICT;
2021-10-01T16:36:26,502 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} create or replace function diku_mod_orders_storage.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;
2021-10-01T16:36:26,503 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  create or replace function diku_mod_orders_storage.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;
2021-10-01T16:36:26,503 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} create or replace function diku_mod_orders_storage.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;
2021-10-01T16:36:26,505 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  create or replace function diku_mod_orders_storage.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;
2021-10-01T16:36:26,505 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} create or replace function diku_mod_orders_storage.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;
2021-10-01T16:36:26,506 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  create or replace function diku_mod_orders_storage.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;
2021-10-01T16:36:26,506 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} create or replace function diku_mod_orders_storage.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;
2021-10-01T16:36:26,507 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  create or replace function diku_mod_orders_storage.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;
2021-10-01T16:36:26,508 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text);
2021-10-01T16:36:26,510 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function rmb_internal_index(text,text,text) does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,510 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text);
2021-10-01T16:36:26,511 INFO  [vert.x-eventloop-thread-1] 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_orders_storage.rmb_internal_index WHERE name = $1' USING aname;
    RETURN;
  END IF;
  SELECT def INTO olddef      FROM diku_mod_orders_storage.rmb_internal_index WHERE name = aname;
  SELECT def INTO prepareddef FROM diku_mod_orders_storage.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_orders_storage.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;
2021-10-01T16:36:26,512 INFO  [vert.x-eventloop-thread-1] 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_orders_storage.rmb_internal_index WHERE name = $1' USING aname;
    RETURN;
  END IF;
  SELECT def INTO olddef      FROM diku_mod_orders_storage.rmb_internal_index WHERE name = aname;
  SELECT def INTO prepareddef FROM diku_mod_orders_storage.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_orders_storage.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;
2021-10-01T16:36:26,513 INFO  [vert.x-eventloop-thread-1] 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_orders_storage;
  REVOKE CREATE ON SCHEMA public FROM PUBLIC;
END $$;
2021-10-01T16:36:26,515 INFO  [vert.x-eventloop-thread-1] 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_orders_storage;
  REVOKE CREATE ON SCHEMA public FROM PUBLIC;
END $$;
2021-10-01T16:36:26,515 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_alert_references ON diku_mod_orders_storage.alert CASCADE;
2021-10-01T16:36:26,516 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "update_alert_references" for relation "diku_mod_orders_storage.alert" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,516 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_alert_references ON diku_mod_orders_storage.alert CASCADE;
2021-10-01T16:36:26,516 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_alert_references();
2021-10-01T16:36:26,517 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_alert_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,517 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_alert_references();
2021-10-01T16:36:26,517 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_alert_ol_version_trigger     ON diku_mod_orders_storage.alert CASCADE;
2021-10-01T16:36:26,518 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "set_alert_ol_version_trigger" for relation "diku_mod_orders_storage.alert" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,519 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_alert_ol_version_trigger     ON diku_mod_orders_storage.alert CASCADE;
2021-10-01T16:36:26,519 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.alert_set_ol_version() CASCADE;
2021-10-01T16:36:26,520 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.alert_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,520 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.alert_set_ol_version() CASCADE;
2021-10-01T16:36:26,521 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_reporting_code_references ON diku_mod_orders_storage.reporting_code CASCADE;
2021-10-01T16:36:26,522 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "update_reporting_code_references" for relation "diku_mod_orders_storage.reporting_code" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,522 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_reporting_code_references ON diku_mod_orders_storage.reporting_code CASCADE;
2021-10-01T16:36:26,522 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_reporting_code_references();
2021-10-01T16:36:26,522 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_reporting_code_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,522 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_reporting_code_references();
2021-10-01T16:36:26,523 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_reporting_code_ol_version_trigger     ON diku_mod_orders_storage.reporting_code CASCADE;
2021-10-01T16:36:26,523 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "set_reporting_code_ol_version_trigger" for relation "diku_mod_orders_storage.reporting_code" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,523 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_reporting_code_ol_version_trigger     ON diku_mod_orders_storage.reporting_code CASCADE;
2021-10-01T16:36:26,523 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.reporting_code_set_ol_version() CASCADE;
2021-10-01T16:36:26,524 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.reporting_code_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,524 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.reporting_code_set_ol_version() CASCADE;
2021-10-01T16:36:26,524 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_acqUnitIds_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_acqUnitIds_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'acqUnitIds')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,526 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_acqUnitIds_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_acqUnitIds_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'acqUnitIds')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,526 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_assignedTo_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_assignedTo_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'assignedTo')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,528 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_assignedTo_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_assignedTo_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'assignedTo')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,528 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_metadata_createdDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_metadata_createdDate_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'metadata'->>'createdDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,529 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_metadata_createdDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_metadata_createdDate_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'metadata'->>'createdDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,530 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_metadata_createdByUserId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_metadata_createdByUserId_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'metadata'->>'createdByUserId')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,531 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_metadata_createdByUserId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_metadata_createdByUserId_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'metadata'->>'createdByUserId')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,531 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_workflowStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_workflowStatus_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'workflowStatus')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,532 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_workflowStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_workflowStatus_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'workflowStatus')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,532 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_approved_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_approved_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'approved')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,533 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_approved_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_approved_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'approved')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,533 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_dateOrdered_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_dateOrdered_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'dateOrdered')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,534 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_dateOrdered_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_dateOrdered_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'dateOrdered')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,534 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_orderType_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_orderType_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'orderType')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,535 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_orderType_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_orderType_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'orderType')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,535 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_reEncumber_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_reEncumber_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'reEncumber')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,536 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_reEncumber_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_reEncumber_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->>'reEncumber')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,536 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_renewal_manualRenewal_idx', 'DELETE',
      'CREATE INDEX IF NOT EXISTS purchase_order_renewal_manualRenewal_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'renewal'->>'manualRenewal')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,539 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='index "purchase_order_renewal_manualrenewal_idx" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='SQL statement "DROP INDEX IF EXISTS purchase_order_renewal_manualRenewal_idx"
PL/pgSQL function rmb_internal_index(text,text,text,text) line 10 at EXECUTE
SQL statement "SELECT rmb_internal_index(
      'purchase_order', 'purchase_order_renewal_manualRenewal_idx', 'DELETE',
      'CREATE INDEX IF NOT EXISTS purchase_order_renewal_manualRenewal_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'renewal'->>'manualRenewal')),600))$rmb$
      )"
PL/pgSQL function inline_code_block line 3 at PERFORM', file='tablecmds.c', line='1194', routine='DropErrorMsgNonExistent', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,540 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_renewal_manualRenewal_idx', 'DELETE',
      'CREATE INDEX IF NOT EXISTS purchase_order_renewal_manualRenewal_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'renewal'->>'manualRenewal')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,540 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_renewal_renewalDate_idx', 'DELETE',
      'CREATE INDEX IF NOT EXISTS purchase_order_renewal_renewalDate_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'renewal'->>'renewalDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,541 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='index "purchase_order_renewal_renewaldate_idx" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='SQL statement "DROP INDEX IF EXISTS purchase_order_renewal_renewalDate_idx"
PL/pgSQL function rmb_internal_index(text,text,text,text) line 10 at EXECUTE
SQL statement "SELECT rmb_internal_index(
      'purchase_order', 'purchase_order_renewal_renewalDate_idx', 'DELETE',
      'CREATE INDEX IF NOT EXISTS purchase_order_renewal_renewalDate_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'renewal'->>'renewalDate')),600))$rmb$
      )"
PL/pgSQL function inline_code_block line 3 at PERFORM', file='tablecmds.c', line='1194', routine='DropErrorMsgNonExistent', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,542 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_renewal_renewalDate_idx', 'DELETE',
      'CREATE INDEX IF NOT EXISTS purchase_order_renewal_renewalDate_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'renewal'->>'renewalDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,542 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_renewal_reviewPeriod_idx', 'DELETE',
      'CREATE INDEX IF NOT EXISTS purchase_order_renewal_reviewPeriod_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'renewal'->>'reviewPeriod')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,543 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='index "purchase_order_renewal_reviewperiod_idx" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='SQL statement "DROP INDEX IF EXISTS purchase_order_renewal_reviewPeriod_idx"
PL/pgSQL function rmb_internal_index(text,text,text,text) line 10 at EXECUTE
SQL statement "SELECT rmb_internal_index(
      'purchase_order', 'purchase_order_renewal_reviewPeriod_idx', 'DELETE',
      'CREATE INDEX IF NOT EXISTS purchase_order_renewal_reviewPeriod_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'renewal'->>'reviewPeriod')),600))$rmb$
      )"
PL/pgSQL function inline_code_block line 3 at PERFORM', file='tablecmds.c', line='1194', routine='DropErrorMsgNonExistent', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,543 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_renewal_reviewPeriod_idx', 'DELETE',
      'CREATE INDEX IF NOT EXISTS purchase_order_renewal_reviewPeriod_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'renewal'->>'reviewPeriod')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,543 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_ongoing_manualRenewal_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_ongoing_manualRenewal_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'ongoing'->>'manualRenewal')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,544 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_ongoing_manualRenewal_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_ongoing_manualRenewal_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'ongoing'->>'manualRenewal')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,544 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_ongoing_renewalDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_ongoing_renewalDate_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'ongoing'->>'renewalDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,545 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_ongoing_renewalDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_ongoing_renewalDate_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'ongoing'->>'renewalDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,545 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_ongoing_reviewPeriod_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_ongoing_reviewPeriod_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'ongoing'->>'reviewPeriod')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,546 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_ongoing_reviewPeriod_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_ongoing_reviewPeriod_idx ON diku_mod_orders_storage.purchase_order '
      || $rmb$(left(lower(f_unaccent(jsonb->'ongoing'->>'reviewPeriod')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,546 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_closeReason_reason_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_closeReason_reason_idx_ft ON diku_mod_orders_storage.purchase_order USING GIN '
      || $rmb$( get_tsvector(f_unaccent(jsonb->'closeReason'->>'reason')) )$rmb$);
    END $do$;
2021-10-01T16:36:26,547 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_closeReason_reason_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_closeReason_reason_idx_ft ON diku_mod_orders_storage.purchase_order USING GIN '
      || $rmb$( get_tsvector(f_unaccent(jsonb->'closeReason'->>'reason')) )$rmb$);
    END $do$;
2021-10-01T16:36:26,547 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_closeReason_note_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_closeReason_note_idx_ft ON diku_mod_orders_storage.purchase_order USING GIN '
      || $rmb$( get_tsvector(f_unaccent(jsonb->'closeReason'->>'note')) )$rmb$);
    END $do$;
2021-10-01T16:36:26,548 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'purchase_order', 'purchase_order_closeReason_note_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS purchase_order_closeReason_note_idx_ft ON diku_mod_orders_storage.purchase_order USING GIN '
      || $rmb$( get_tsvector(f_unaccent(jsonb->'closeReason'->>'note')) )$rmb$);
    END $do$;
2021-10-01T16:36:26,549 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_purchase_order_references ON diku_mod_orders_storage.purchase_order CASCADE;
2021-10-01T16:36:26,549 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "update_purchase_order_references" for relation "diku_mod_orders_storage.purchase_order" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,549 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_purchase_order_references ON diku_mod_orders_storage.purchase_order CASCADE;
2021-10-01T16:36:26,550 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_purchase_order_references();
2021-10-01T16:36:26,550 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_purchase_order_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,550 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_purchase_order_references();
2021-10-01T16:36:26,550 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_purchase_order_ol_version_trigger     ON diku_mod_orders_storage.purchase_order CASCADE;
2021-10-01T16:36:26,551 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "set_purchase_order_ol_version_trigger" for relation "diku_mod_orders_storage.purchase_order" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,552 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_purchase_order_ol_version_trigger     ON diku_mod_orders_storage.purchase_order CASCADE;
2021-10-01T16:36:26,552 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.purchase_order_set_ol_version() CASCADE;
2021-10-01T16:36:26,552 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.purchase_order_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,553 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.purchase_order_set_ol_version() CASCADE;
2021-10-01T16:36:26,553 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_eresource_accessProvider_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_eresource_accessProvider_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'eresource'->>'accessProvider')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,554 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_eresource_accessProvider_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_eresource_accessProvider_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'eresource'->>'accessProvider')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,554 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_eresource_activated_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_eresource_activated_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'eresource'->>'activated')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,555 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_eresource_activated_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_eresource_activated_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'eresource'->>'activated')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,555 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_eresource_expectedActivation_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_eresource_expectedActivation_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'eresource'->>'expectedActivation')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,556 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_eresource_expectedActivation_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_eresource_expectedActivation_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'eresource'->>'expectedActivation')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,556 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_eresource_trial_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_eresource_trial_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'eresource'->>'trial')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,557 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_eresource_trial_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_eresource_trial_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'eresource'->>'trial')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,557 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_eresource_materialType_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_eresource_materialType_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'eresource'->>'materialType')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,558 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_eresource_materialType_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_eresource_materialType_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'eresource'->>'materialType')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,558 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_details_subscriptionFrom_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_details_subscriptionFrom_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'details'->>'subscriptionFrom')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,558 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_details_subscriptionFrom_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_details_subscriptionFrom_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'details'->>'subscriptionFrom')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,558 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_details_subscriptionTo_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_details_subscriptionTo_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'details'->>'subscriptionTo')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,559 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_details_subscriptionTo_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_details_subscriptionTo_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'details'->>'subscriptionTo')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,559 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_location_locationId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_location_locationId_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'location'->>'locationId')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,560 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_location_locationId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_location_locationId_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'location'->>'locationId')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,560 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_physical_receiptDue_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_physical_receiptDue_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'physical'->>'receiptDue')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,561 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_physical_receiptDue_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_physical_receiptDue_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'physical'->>'receiptDue')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,561 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_physical_expectedReceiptDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_physical_expectedReceiptDate_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'physical'->>'expectedReceiptDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,562 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_physical_expectedReceiptDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_physical_expectedReceiptDate_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'physical'->>'expectedReceiptDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,562 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_physical_volumes_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_physical_volumes_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'physical'->>'volumes')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,562 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_physical_volumes_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_physical_volumes_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'physical'->>'volumes')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,562 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_physical_materialType_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_physical_materialType_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'physical'->>'materialType')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,563 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_physical_materialType_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_physical_materialType_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'physical'->>'materialType')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,563 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_claim_grace_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_claim_grace_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'claim'->>'grace')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,564 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_claim_grace_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_claim_grace_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'claim'->>'grace')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,564 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_claim_sent_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_claim_sent_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'claim'->>'sent')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,565 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_claim_sent_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_claim_sent_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'claim'->>'sent')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,565 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_collection_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_collection_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'collection')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,565 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_collection_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_collection_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'collection')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,565 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_receiptStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_receiptStatus_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receiptStatus')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,566 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_receiptStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_receiptStatus_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receiptStatus')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,566 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_paymentStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_paymentStatus_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'paymentStatus')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,567 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_paymentStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_paymentStatus_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'paymentStatus')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,567 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_orderFormat_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_orderFormat_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'orderFormat')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,568 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_orderFormat_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_orderFormat_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'orderFormat')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,568 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_receiptDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_receiptDate_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receiptDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,569 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_receiptDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_receiptDate_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receiptDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,569 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_metadata_createdDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_metadata_createdDate_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'metadata'->>'createdDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,570 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_metadata_createdDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_metadata_createdDate_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'metadata'->>'createdDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,570 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_rush_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_rush_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'rush')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,571 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_rush_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_rush_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'rush')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,571 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_source_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_source_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'source')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,571 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_source_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_source_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'source')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,572 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_fundDistribution_code_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_fundDistribution_code_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'fundDistribution'->>'code'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,572 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_fundDistribution_code_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_fundDistribution_code_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'fundDistribution'->>'code'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,572 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_details_productIds_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_details_productIds_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'details'->>'productIds'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,573 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_details_productIds_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_details_productIds_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'details'->>'productIds'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,573 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_title_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS po_line_title_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'title'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,574 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='index "po_line_title_idx_gin" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='SQL statement "DROP INDEX IF EXISTS po_line_title_idx_gin"
PL/pgSQL function rmb_internal_index(text,text,text,text) line 10 at EXECUTE
SQL statement "SELECT rmb_internal_index(
      'po_line', 'po_line_title_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS po_line_title_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'title'))) public.gin_trgm_ops)$rmb$
      )"
PL/pgSQL function inline_code_block line 3 at PERFORM', file='tablecmds.c', line='1194', routine='DropErrorMsgNonExistent', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,574 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_title_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS po_line_title_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'title'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,574 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_titleOrPackage_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_titleOrPackage_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'titleOrPackage'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,575 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_titleOrPackage_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_titleOrPackage_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'titleOrPackage'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,575 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_vendor_vendorAccount_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_vendor_vendorAccount_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'vendor'->>'vendorAccount'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,576 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_vendor_vendorAccount_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_vendor_vendorAccount_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'vendor'->>'vendorAccount'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,576 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_vendor_refNumber_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_vendor_refNumber_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'vendor'->>'refNumber'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,577 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_vendor_refNumber_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_vendor_refNumber_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'vendor'->>'refNumber'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,577 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_tags_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_tags_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'tags'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,578 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_tags_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_tags_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'tags'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,578 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_contributors_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_contributors_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'contributors'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,579 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_contributors_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_contributors_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'contributors'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,579 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_requester_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_requester_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'requester'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,580 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_requester_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_requester_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'requester'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,580 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_poLineNumber_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_poLineNumber_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'poLineNumber'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,581 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_poLineNumber_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_poLineNumber_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'poLineNumber'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,581 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_publisher_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_publisher_idx_ft ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$( get_tsvector(f_unaccent(jsonb->>'publisher')) )$rmb$);
    END $do$;
2021-10-01T16:36:26,581 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_publisher_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_publisher_idx_ft ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$( get_tsvector(f_unaccent(jsonb->>'publisher')) )$rmb$);
    END $do$;
2021-10-01T16:36:26,582 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_donor_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_donor_idx_ft ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$( get_tsvector(f_unaccent(jsonb->>'donor')) )$rmb$);
    END $do$;
2021-10-01T16:36:26,583 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_donor_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_donor_idx_ft ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$( get_tsvector(f_unaccent(jsonb->>'donor')) )$rmb$);
    END $do$;
2021-10-01T16:36:26,583 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_selector_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_selector_idx_ft ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$( get_tsvector(f_unaccent(jsonb->>'selector')) )$rmb$);
    END $do$;
2021-10-01T16:36:26,584 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_selector_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_selector_idx_ft ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$( get_tsvector(f_unaccent(jsonb->>'selector')) )$rmb$);
    END $do$;
2021-10-01T16:36:26,584 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         ALTER TABLE diku_mod_orders_storage.po_line           ADD COLUMN IF NOT EXISTS purchaseOrderId UUID;
2021-10-01T16:36:26,585 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42701', message='column "purchaseorderid" of relation "po_line" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='tablecmds.c', line='6179', routine='check_for_column_name_collision', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,585 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          ALTER TABLE diku_mod_orders_storage.po_line           ADD COLUMN IF NOT EXISTS purchaseOrderId UUID;
2021-10-01T16:36:26,585 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         DO $$
        BEGIN
          BEGIN
            ALTER TABLE po_line
              ADD CONSTRAINT purchaseOrderId_purchase_order_fkey
              FOREIGN KEY (purchaseOrderId) REFERENCES purchase_order;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
2021-10-01T16:36:26,587 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          DO $$
        BEGIN
          BEGIN
            ALTER TABLE po_line
              ADD CONSTRAINT purchaseOrderId_purchase_order_fkey
              FOREIGN KEY (purchaseOrderId) REFERENCES purchase_order;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
2021-10-01T16:36:26,587 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         CREATE INDEX IF NOT EXISTS po_line_purchaseOrderId_idx           ON diku_mod_orders_storage.po_line (purchaseOrderId);
2021-10-01T16:36:26,588 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42P07', message='relation "po_line_purchaseorderid_idx" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='index.c', line='852', routine='index_create', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,588 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          CREATE INDEX IF NOT EXISTS po_line_purchaseOrderId_idx           ON diku_mod_orders_storage.po_line (purchaseOrderId);
2021-10-01T16:36:26,588 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         INSERT INTO rmb_internal_analyze VALUES ('po_line');
2021-10-01T16:36:26,589 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          INSERT INTO rmb_internal_analyze VALUES ('po_line');
2021-10-01T16:36:26,589 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_po_line_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.purchaseOrderId = (NEW.jsonb->>'purchaseOrderId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
2021-10-01T16:36:26,590 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_po_line_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.purchaseOrderId = (NEW.jsonb->>'purchaseOrderId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
2021-10-01T16:36:26,590 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_po_line_references ON diku_mod_orders_storage.po_line CASCADE;
2021-10-01T16:36:26,592 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_po_line_references ON diku_mod_orders_storage.po_line CASCADE;
2021-10-01T16:36:26,592 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     CREATE TRIGGER update_po_line_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.po_line       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_po_line_references();
2021-10-01T16:36:26,596 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      CREATE TRIGGER update_po_line_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.po_line       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_po_line_references();
2021-10-01T16:36:26,596 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE po_line DROP CONSTRAINT IF EXISTS '
                || 'purchaseOrderId_purchase_order_fkey' || i;
      END LOOP;
    END $$;
2021-10-01T16:36:26,597 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE po_line DROP CONSTRAINT IF EXISTS '
                || 'purchaseOrderId_purchase_order_fkey' || i;
      END LOOP;
    END $$;
2021-10-01T16:36:26,597 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_po_line_ol_version_trigger     ON diku_mod_orders_storage.po_line CASCADE;
2021-10-01T16:36:26,598 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "set_po_line_ol_version_trigger" for relation "diku_mod_orders_storage.po_line" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,598 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_po_line_ol_version_trigger     ON diku_mod_orders_storage.po_line CASCADE;
2021-10-01T16:36:26,598 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.po_line_set_ol_version() CASCADE;
2021-10-01T16:36:26,599 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.po_line_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,599 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.po_line_set_ol_version() CASCADE;
2021-10-01T16:36:26,599 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         ALTER TABLE diku_mod_orders_storage.titles           ADD COLUMN IF NOT EXISTS poLineId UUID;
2021-10-01T16:36:26,600 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42701', message='column "polineid" of relation "titles" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='tablecmds.c', line='6179', routine='check_for_column_name_collision', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,600 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          ALTER TABLE diku_mod_orders_storage.titles           ADD COLUMN IF NOT EXISTS poLineId UUID;
2021-10-01T16:36:26,600 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         DO $$
        BEGIN
          BEGIN
            ALTER TABLE titles
              ADD CONSTRAINT poLineId_po_line_fkey
              FOREIGN KEY (poLineId) REFERENCES po_line;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
2021-10-01T16:36:26,601 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          DO $$
        BEGIN
          BEGIN
            ALTER TABLE titles
              ADD CONSTRAINT poLineId_po_line_fkey
              FOREIGN KEY (poLineId) REFERENCES po_line;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
2021-10-01T16:36:26,601 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         CREATE INDEX IF NOT EXISTS titles_poLineId_idx           ON diku_mod_orders_storage.titles (poLineId);
2021-10-01T16:36:26,601 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42P07', message='relation "titles_polineid_idx" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='index.c', line='852', routine='index_create', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,601 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          CREATE INDEX IF NOT EXISTS titles_poLineId_idx           ON diku_mod_orders_storage.titles (poLineId);
2021-10-01T16:36:26,601 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         INSERT INTO rmb_internal_analyze VALUES ('titles');
2021-10-01T16:36:26,602 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          INSERT INTO rmb_internal_analyze VALUES ('titles');
2021-10-01T16:36:26,602 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_titles_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.poLineId = (NEW.jsonb->>'poLineId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
2021-10-01T16:36:26,603 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_titles_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.poLineId = (NEW.jsonb->>'poLineId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
2021-10-01T16:36:26,603 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_titles_references ON diku_mod_orders_storage.titles CASCADE;
2021-10-01T16:36:26,604 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_titles_references ON diku_mod_orders_storage.titles CASCADE;
2021-10-01T16:36:26,604 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     CREATE TRIGGER update_titles_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.titles       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_titles_references();
2021-10-01T16:36:26,605 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      CREATE TRIGGER update_titles_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.titles       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_titles_references();
2021-10-01T16:36:26,605 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE titles DROP CONSTRAINT IF EXISTS '
                || 'poLineId_po_line_fkey' || i;
      END LOOP;
    END $$;
2021-10-01T16:36:26,606 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE titles DROP CONSTRAINT IF EXISTS '
                || 'poLineId_po_line_fkey' || i;
      END LOOP;
    END $$;
2021-10-01T16:36:26,606 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_titles_ol_version_trigger     ON diku_mod_orders_storage.titles CASCADE;
2021-10-01T16:36:26,607 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "set_titles_ol_version_trigger" for relation "diku_mod_orders_storage.titles" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,607 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_titles_ol_version_trigger     ON diku_mod_orders_storage.titles CASCADE;
2021-10-01T16:36:26,607 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.titles_set_ol_version() CASCADE;
2021-10-01T16:36:26,608 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.titles_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,608 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.titles_set_ol_version() CASCADE;
2021-10-01T16:36:26,608 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_format_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_format_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'format')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,609 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_format_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_format_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'format')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,609 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_itemId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_itemId_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'itemId')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,609 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_itemId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_itemId_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'itemId')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,610 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_locationId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_locationId_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'locationId')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,610 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_locationId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_locationId_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'locationId')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,611 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_receivingStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_receivingStatus_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receivingStatus')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,612 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_receivingStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_receivingStatus_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receivingStatus')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,612 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_receivedDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_receivedDate_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receivedDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,613 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_receivedDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_receivedDate_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receivedDate')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,614 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_supplement_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_supplement_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'supplement')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,615 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_supplement_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_supplement_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'supplement')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,615 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_caption_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_caption_idx_gin ON diku_mod_orders_storage.pieces USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'caption'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,616 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_caption_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_caption_idx_gin ON diku_mod_orders_storage.pieces USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'caption'))) public.gin_trgm_ops)$rmb$
      );
    END $do$;
2021-10-01T16:36:26,616 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_comment_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_comment_idx_ft ON diku_mod_orders_storage.pieces USING GIN '
      || $rmb$( get_tsvector(f_unaccent(jsonb->>'comment')) )$rmb$);
    END $do$;
2021-10-01T16:36:26,616 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_comment_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_comment_idx_ft ON diku_mod_orders_storage.pieces USING GIN '
      || $rmb$( get_tsvector(f_unaccent(jsonb->>'comment')) )$rmb$);
    END $do$;
2021-10-01T16:36:26,616 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         ALTER TABLE diku_mod_orders_storage.pieces           ADD COLUMN IF NOT EXISTS poLineId UUID;
2021-10-01T16:36:26,617 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42701', message='column "polineid" of relation "pieces" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='tablecmds.c', line='6179', routine='check_for_column_name_collision', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,617 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          ALTER TABLE diku_mod_orders_storage.pieces           ADD COLUMN IF NOT EXISTS poLineId UUID;
2021-10-01T16:36:26,617 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         DO $$
        BEGIN
          BEGIN
            ALTER TABLE pieces
              ADD CONSTRAINT poLineId_po_line_fkey
              FOREIGN KEY (poLineId) REFERENCES po_line;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
2021-10-01T16:36:26,618 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          DO $$
        BEGIN
          BEGIN
            ALTER TABLE pieces
              ADD CONSTRAINT poLineId_po_line_fkey
              FOREIGN KEY (poLineId) REFERENCES po_line;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
2021-10-01T16:36:26,618 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         CREATE INDEX IF NOT EXISTS pieces_poLineId_idx           ON diku_mod_orders_storage.pieces (poLineId);
2021-10-01T16:36:26,619 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42P07', message='relation "pieces_polineid_idx" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='index.c', line='852', routine='index_create', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,620 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          CREATE INDEX IF NOT EXISTS pieces_poLineId_idx           ON diku_mod_orders_storage.pieces (poLineId);
2021-10-01T16:36:26,620 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         INSERT INTO rmb_internal_analyze VALUES ('pieces');
2021-10-01T16:36:26,621 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          INSERT INTO rmb_internal_analyze VALUES ('pieces');
2021-10-01T16:36:26,621 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         ALTER TABLE diku_mod_orders_storage.pieces           ADD COLUMN IF NOT EXISTS titleId UUID;
2021-10-01T16:36:26,622 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42701', message='column "titleid" of relation "pieces" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='tablecmds.c', line='6179', routine='check_for_column_name_collision', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,622 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          ALTER TABLE diku_mod_orders_storage.pieces           ADD COLUMN IF NOT EXISTS titleId UUID;
2021-10-01T16:36:26,622 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         DO $$
        BEGIN
          BEGIN
            ALTER TABLE pieces
              ADD CONSTRAINT titleId_titles_fkey
              FOREIGN KEY (titleId) REFERENCES titles;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
2021-10-01T16:36:26,622 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          DO $$
        BEGIN
          BEGIN
            ALTER TABLE pieces
              ADD CONSTRAINT titleId_titles_fkey
              FOREIGN KEY (titleId) REFERENCES titles;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
2021-10-01T16:36:26,622 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         CREATE INDEX IF NOT EXISTS pieces_titleId_idx           ON diku_mod_orders_storage.pieces (titleId);
2021-10-01T16:36:26,623 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42P07', message='relation "pieces_titleid_idx" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='index.c', line='852', routine='index_create', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,623 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          CREATE INDEX IF NOT EXISTS pieces_titleId_idx           ON diku_mod_orders_storage.pieces (titleId);
2021-10-01T16:36:26,623 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         INSERT INTO rmb_internal_analyze VALUES ('pieces');
2021-10-01T16:36:26,624 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          INSERT INTO rmb_internal_analyze VALUES ('pieces');
2021-10-01T16:36:26,624 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_pieces_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.poLineId = (NEW.jsonb->>'poLineId');
      NEW.titleId = (NEW.jsonb->>'titleId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
2021-10-01T16:36:26,624 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_pieces_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.poLineId = (NEW.jsonb->>'poLineId');
      NEW.titleId = (NEW.jsonb->>'titleId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
2021-10-01T16:36:26,625 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_pieces_references ON diku_mod_orders_storage.pieces CASCADE;
2021-10-01T16:36:26,625 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_pieces_references ON diku_mod_orders_storage.pieces CASCADE;
2021-10-01T16:36:26,625 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     CREATE TRIGGER update_pieces_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.pieces       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_pieces_references();
2021-10-01T16:36:26,626 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      CREATE TRIGGER update_pieces_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.pieces       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_pieces_references();
2021-10-01T16:36:26,626 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE pieces DROP CONSTRAINT IF EXISTS '
                || 'poLineId_po_line_fkey' || i;
      END LOOP;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE pieces DROP CONSTRAINT IF EXISTS '
                || 'titleId_titles_fkey' || i;
      END LOOP;
    END $$;
2021-10-01T16:36:26,626 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE pieces DROP CONSTRAINT IF EXISTS '
                || 'poLineId_po_line_fkey' || i;
      END LOOP;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE pieces DROP CONSTRAINT IF EXISTS '
                || 'titleId_titles_fkey' || i;
      END LOOP;
    END $$;
2021-10-01T16:36:26,626 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_pieces_ol_version_trigger     ON diku_mod_orders_storage.pieces CASCADE;
2021-10-01T16:36:26,627 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "set_pieces_ol_version_trigger" for relation "diku_mod_orders_storage.pieces" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,627 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_pieces_ol_version_trigger     ON diku_mod_orders_storage.pieces CASCADE;
2021-10-01T16:36:26,627 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.pieces_set_ol_version() CASCADE;
2021-10-01T16:36:26,627 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.pieces_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,628 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.pieces_set_ol_version() CASCADE;
2021-10-01T16:36:26,628 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'order_invoice_relationship', 'order_invoice_relationship_purchaseOrderId_invoiceId_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS order_invoice_relationship_purchaseOrderId_invoiceId_idx_unique ON diku_mod_orders_storage.order_invoice_relationship '
      || $rmb$(lower(f_unaccent(concat_space_sql(order_invoice_relationship.jsonb->>'purchaseOrderId' , order_invoice_relationship.jsonb->>'invoiceId'))))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,629 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'order_invoice_relationship', 'order_invoice_relationship_purchaseOrderId_invoiceId_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS order_invoice_relationship_purchaseOrderId_invoiceId_idx_unique ON diku_mod_orders_storage.order_invoice_relationship '
      || $rmb$(lower(f_unaccent(concat_space_sql(order_invoice_relationship.jsonb->>'purchaseOrderId' , order_invoice_relationship.jsonb->>'invoiceId'))))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,629 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         ALTER TABLE diku_mod_orders_storage.order_invoice_relationship           ADD COLUMN IF NOT EXISTS purchaseOrderId UUID;
2021-10-01T16:36:26,630 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42701', message='column "purchaseorderid" of relation "order_invoice_relationship" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='tablecmds.c', line='6179', routine='check_for_column_name_collision', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,630 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          ALTER TABLE diku_mod_orders_storage.order_invoice_relationship           ADD COLUMN IF NOT EXISTS purchaseOrderId UUID;
2021-10-01T16:36:26,630 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         DO $$
        BEGIN
          BEGIN
            ALTER TABLE order_invoice_relationship
              ADD CONSTRAINT purchaseOrderId_purchase_order_fkey
              FOREIGN KEY (purchaseOrderId) REFERENCES purchase_order;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
2021-10-01T16:36:26,630 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          DO $$
        BEGIN
          BEGIN
            ALTER TABLE order_invoice_relationship
              ADD CONSTRAINT purchaseOrderId_purchase_order_fkey
              FOREIGN KEY (purchaseOrderId) REFERENCES purchase_order;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
2021-10-01T16:36:26,630 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         CREATE INDEX IF NOT EXISTS order_invoice_relationship_purchaseOrderId_idx           ON diku_mod_orders_storage.order_invoice_relationship (purchaseOrderId);
2021-10-01T16:36:26,631 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42P07', message='relation "order_invoice_relationship_purchaseorderid_idx" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='index.c', line='852', routine='index_create', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,631 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          CREATE INDEX IF NOT EXISTS order_invoice_relationship_purchaseOrderId_idx           ON diku_mod_orders_storage.order_invoice_relationship (purchaseOrderId);
2021-10-01T16:36:26,631 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         INSERT INTO rmb_internal_analyze VALUES ('order_invoice_relationship');
2021-10-01T16:36:26,631 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          INSERT INTO rmb_internal_analyze VALUES ('order_invoice_relationship');
2021-10-01T16:36:26,631 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_order_invoice_relationship_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.purchaseOrderId = (NEW.jsonb->>'purchaseOrderId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
2021-10-01T16:36:26,632 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_order_invoice_relationship_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.purchaseOrderId = (NEW.jsonb->>'purchaseOrderId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
2021-10-01T16:36:26,632 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_order_invoice_relationship_references ON diku_mod_orders_storage.order_invoice_relationship CASCADE;
2021-10-01T16:36:26,633 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_order_invoice_relationship_references ON diku_mod_orders_storage.order_invoice_relationship CASCADE;
2021-10-01T16:36:26,633 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     CREATE TRIGGER update_order_invoice_relationship_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.order_invoice_relationship       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_order_invoice_relationship_references();
2021-10-01T16:36:26,633 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      CREATE TRIGGER update_order_invoice_relationship_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.order_invoice_relationship       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_order_invoice_relationship_references();
2021-10-01T16:36:26,633 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE order_invoice_relationship DROP CONSTRAINT IF EXISTS '
                || 'purchaseOrderId_purchase_order_fkey' || i;
      END LOOP;
    END $$;
2021-10-01T16:36:26,634 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE order_invoice_relationship DROP CONSTRAINT IF EXISTS '
                || 'purchaseOrderId_purchase_order_fkey' || i;
      END LOOP;
    END $$;
2021-10-01T16:36:26,634 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_order_invoice_relationship_ol_version_trigger     ON diku_mod_orders_storage.order_invoice_relationship CASCADE;
2021-10-01T16:36:26,635 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "set_order_invoice_relationship_ol_version_trigger" for relation "diku_mod_orders_storage.order_invoice_relationship" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,635 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_order_invoice_relationship_ol_version_trigger     ON diku_mod_orders_storage.order_invoice_relationship CASCADE;
2021-10-01T16:36:26,635 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.order_invoice_relationship_set_ol_version() CASCADE;
2021-10-01T16:36:26,636 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.order_invoice_relationship_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,636 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.order_invoice_relationship_set_ol_version() CASCADE;
2021-10-01T16:36:26,636 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit', 'acquisitions_unit_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS acquisitions_unit_name_idx_unique ON diku_mod_orders_storage.acquisitions_unit '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,637 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit', 'acquisitions_unit_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS acquisitions_unit_name_idx_unique ON diku_mod_orders_storage.acquisitions_unit '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,637 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_acquisitions_unit_references ON diku_mod_orders_storage.acquisitions_unit CASCADE;
2021-10-01T16:36:26,638 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "update_acquisitions_unit_references" for relation "diku_mod_orders_storage.acquisitions_unit" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,638 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_acquisitions_unit_references ON diku_mod_orders_storage.acquisitions_unit CASCADE;
2021-10-01T16:36:26,638 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_acquisitions_unit_references();
2021-10-01T16:36:26,638 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_acquisitions_unit_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,639 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_acquisitions_unit_references();
2021-10-01T16:36:26,639 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_acquisitions_unit_ol_version_trigger     ON diku_mod_orders_storage.acquisitions_unit CASCADE;
2021-10-01T16:36:26,639 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "set_acquisitions_unit_ol_version_trigger" for relation "diku_mod_orders_storage.acquisitions_unit" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,639 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_acquisitions_unit_ol_version_trigger     ON diku_mod_orders_storage.acquisitions_unit CASCADE;
2021-10-01T16:36:26,639 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisitions_unit_set_ol_version() CASCADE;
2021-10-01T16:36:26,640 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.acquisitions_unit_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,640 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisitions_unit_set_ol_version() CASCADE;
2021-10-01T16:36:26,640 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_acquisitions_unit_assignments_references ON diku_mod_orders_storage.acquisitions_unit_assignments CASCADE;
2021-10-01T16:36:26,640 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='relation "diku_mod_orders_storage.acquisitions_unit_assignments" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='489', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,640 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_acquisitions_unit_assignments_references ON diku_mod_orders_storage.acquisitions_unit_assignments CASCADE;
2021-10-01T16:36:26,640 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_acquisitions_unit_assignments_references();
2021-10-01T16:36:26,641 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_acquisitions_unit_assignments_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,641 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_acquisitions_unit_assignments_references();
2021-10-01T16:36:26,641 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_acquisitions_unit_assignments_ol_version_trigger     ON diku_mod_orders_storage.acquisitions_unit_assignments CASCADE;
2021-10-01T16:36:26,642 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='relation "diku_mod_orders_storage.acquisitions_unit_assignments" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='489', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,642 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_acquisitions_unit_assignments_ol_version_trigger     ON diku_mod_orders_storage.acquisitions_unit_assignments CASCADE;
2021-10-01T16:36:26,642 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisitions_unit_assignments_set_ol_version() CASCADE;
2021-10-01T16:36:26,642 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.acquisitions_unit_assignments_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,642 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisitions_unit_assignments_set_ol_version() CASCADE;
2021-10-01T16:36:26,642 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit_membership', 'acquisitions_unit_membership_userId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS acquisitions_unit_membership_userId_idx ON diku_mod_orders_storage.acquisitions_unit_membership '
      || $rmb$(left(lower(f_unaccent(jsonb->>'userId')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,643 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit_membership', 'acquisitions_unit_membership_userId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS acquisitions_unit_membership_userId_idx ON diku_mod_orders_storage.acquisitions_unit_membership '
      || $rmb$(left(lower(f_unaccent(jsonb->>'userId')),600))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,643 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         ALTER TABLE diku_mod_orders_storage.acquisitions_unit_membership           ADD COLUMN IF NOT EXISTS acquisitionsUnitId UUID;
2021-10-01T16:36:26,644 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42701', message='column "acquisitionsunitid" of relation "acquisitions_unit_membership" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='tablecmds.c', line='6179', routine='check_for_column_name_collision', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,644 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          ALTER TABLE diku_mod_orders_storage.acquisitions_unit_membership           ADD COLUMN IF NOT EXISTS acquisitionsUnitId UUID;
2021-10-01T16:36:26,644 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         DO $$
        BEGIN
          BEGIN
            ALTER TABLE acquisitions_unit_membership
              ADD CONSTRAINT acquisitionsUnitId_acquisitions_unit_fkey
              FOREIGN KEY (acquisitionsUnitId) REFERENCES acquisitions_unit;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
2021-10-01T16:36:26,645 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          DO $$
        BEGIN
          BEGIN
            ALTER TABLE acquisitions_unit_membership
              ADD CONSTRAINT acquisitionsUnitId_acquisitions_unit_fkey
              FOREIGN KEY (acquisitionsUnitId) REFERENCES acquisitions_unit;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
2021-10-01T16:36:26,645 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         CREATE INDEX IF NOT EXISTS acquisitions_unit_membership_acquisitionsUnitId_idx           ON diku_mod_orders_storage.acquisitions_unit_membership (acquisitionsUnitId);
2021-10-01T16:36:26,645 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='42P07', message='relation "acquisitions_unit_membership_acquisitionsunitid_idx" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='index.c', line='852', routine='index_create', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,645 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          CREATE INDEX IF NOT EXISTS acquisitions_unit_membership_acquisitionsUnitId_idx           ON diku_mod_orders_storage.acquisitions_unit_membership (acquisitionsUnitId);
2021-10-01T16:36:26,645 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}         INSERT INTO rmb_internal_analyze VALUES ('acquisitions_unit_membership');
2021-10-01T16:36:26,646 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed          INSERT INTO rmb_internal_analyze VALUES ('acquisitions_unit_membership');
2021-10-01T16:36:26,646 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_acquisitions_unit_membership_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.acquisitionsUnitId = (NEW.jsonb->>'acquisitionsUnitId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
2021-10-01T16:36:26,647 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_acquisitions_unit_membership_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.acquisitionsUnitId = (NEW.jsonb->>'acquisitionsUnitId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
2021-10-01T16:36:26,647 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_acquisitions_unit_membership_references ON diku_mod_orders_storage.acquisitions_unit_membership CASCADE;
2021-10-01T16:36:26,647 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_acquisitions_unit_membership_references ON diku_mod_orders_storage.acquisitions_unit_membership CASCADE;
2021-10-01T16:36:26,647 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     CREATE TRIGGER update_acquisitions_unit_membership_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.acquisitions_unit_membership       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_acquisitions_unit_membership_references();
2021-10-01T16:36:26,648 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      CREATE TRIGGER update_acquisitions_unit_membership_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.acquisitions_unit_membership       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_acquisitions_unit_membership_references();
2021-10-01T16:36:26,648 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE acquisitions_unit_membership DROP CONSTRAINT IF EXISTS '
                || 'acquisitionsUnitId_acquisitions_unit_fkey' || i;
      END LOOP;
    END $$;
2021-10-01T16:36:26,649 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE acquisitions_unit_membership DROP CONSTRAINT IF EXISTS '
                || 'acquisitionsUnitId_acquisitions_unit_fkey' || i;
      END LOOP;
    END $$;
2021-10-01T16:36:26,649 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_acquisitions_unit_membership_ol_version_trigger     ON diku_mod_orders_storage.acquisitions_unit_membership CASCADE;
2021-10-01T16:36:26,649 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "set_acquisitions_unit_membership_ol_version_trigger" for relation "diku_mod_orders_storage.acquisitions_unit_membership" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,649 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_acquisitions_unit_membership_ol_version_trigger     ON diku_mod_orders_storage.acquisitions_unit_membership CASCADE;
2021-10-01T16:36:26,649 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisitions_unit_membership_set_ol_version() CASCADE;
2021-10-01T16:36:26,650 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.acquisitions_unit_membership_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,650 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisitions_unit_membership_set_ol_version() CASCADE;
2021-10-01T16:36:26,650 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'order_templates', 'order_templates_templateName_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS order_templates_templateName_idx_unique ON diku_mod_orders_storage.order_templates '
      || $rmb$(lower(f_unaccent(jsonb->>'templateName')))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,651 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'order_templates', 'order_templates_templateName_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS order_templates_templateName_idx_unique ON diku_mod_orders_storage.order_templates '
      || $rmb$(lower(f_unaccent(jsonb->>'templateName')))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,651 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_order_templates_references ON diku_mod_orders_storage.order_templates CASCADE;
2021-10-01T16:36:26,651 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "update_order_templates_references" for relation "diku_mod_orders_storage.order_templates" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,651 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_order_templates_references ON diku_mod_orders_storage.order_templates CASCADE;
2021-10-01T16:36:26,651 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_order_templates_references();
2021-10-01T16:36:26,652 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_order_templates_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,652 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_order_templates_references();
2021-10-01T16:36:26,652 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_order_templates_ol_version_trigger     ON diku_mod_orders_storage.order_templates CASCADE;
2021-10-01T16:36:26,653 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "set_order_templates_ol_version_trigger" for relation "diku_mod_orders_storage.order_templates" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,653 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_order_templates_ol_version_trigger     ON diku_mod_orders_storage.order_templates CASCADE;
2021-10-01T16:36:26,653 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.order_templates_set_ol_version() CASCADE;
2021-10-01T16:36:26,653 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.order_templates_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,654 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.order_templates_set_ol_version() CASCADE;
2021-10-01T16:36:26,654 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'reasons_for_closure', 'reasons_for_closure_reason_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS reasons_for_closure_reason_idx_unique ON diku_mod_orders_storage.reasons_for_closure '
      || $rmb$(lower(f_unaccent(jsonb->>'reason')))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,654 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'reasons_for_closure', 'reasons_for_closure_reason_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS reasons_for_closure_reason_idx_unique ON diku_mod_orders_storage.reasons_for_closure '
      || $rmb$(lower(f_unaccent(jsonb->>'reason')))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,655 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_reasons_for_closure_references ON diku_mod_orders_storage.reasons_for_closure CASCADE;
2021-10-01T16:36:26,655 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "update_reasons_for_closure_references" for relation "diku_mod_orders_storage.reasons_for_closure" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,655 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_reasons_for_closure_references ON diku_mod_orders_storage.reasons_for_closure CASCADE;
2021-10-01T16:36:26,655 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_reasons_for_closure_references();
2021-10-01T16:36:26,656 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_reasons_for_closure_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,656 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_reasons_for_closure_references();
2021-10-01T16:36:26,656 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_reasons_for_closure_ol_version_trigger     ON diku_mod_orders_storage.reasons_for_closure CASCADE;
2021-10-01T16:36:26,656 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "set_reasons_for_closure_ol_version_trigger" for relation "diku_mod_orders_storage.reasons_for_closure" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,656 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_reasons_for_closure_ol_version_trigger     ON diku_mod_orders_storage.reasons_for_closure CASCADE;
2021-10-01T16:36:26,656 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.reasons_for_closure_set_ol_version() CASCADE;
2021-10-01T16:36:26,657 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.reasons_for_closure_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,657 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.reasons_for_closure_set_ol_version() CASCADE;
2021-10-01T16:36:26,657 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'prefixes', 'prefixes_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS prefixes_name_idx_unique ON diku_mod_orders_storage.prefixes '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,657 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'prefixes', 'prefixes_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS prefixes_name_idx_unique ON diku_mod_orders_storage.prefixes '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,658 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_prefixes_references ON diku_mod_orders_storage.prefixes CASCADE;
2021-10-01T16:36:26,658 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "update_prefixes_references" for relation "diku_mod_orders_storage.prefixes" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,658 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_prefixes_references ON diku_mod_orders_storage.prefixes CASCADE;
2021-10-01T16:36:26,658 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_prefixes_references();
2021-10-01T16:36:26,658 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_prefixes_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,659 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_prefixes_references();
2021-10-01T16:36:26,659 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_prefixes_ol_version_trigger     ON diku_mod_orders_storage.prefixes CASCADE;
2021-10-01T16:36:26,659 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "set_prefixes_ol_version_trigger" for relation "diku_mod_orders_storage.prefixes" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,659 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_prefixes_ol_version_trigger     ON diku_mod_orders_storage.prefixes CASCADE;
2021-10-01T16:36:26,659 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.prefixes_set_ol_version() CASCADE;
2021-10-01T16:36:26,660 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.prefixes_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,660 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.prefixes_set_ol_version() CASCADE;
2021-10-01T16:36:26,660 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'suffixes', 'suffixes_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS suffixes_name_idx_unique ON diku_mod_orders_storage.suffixes '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,660 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'suffixes', 'suffixes_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS suffixes_name_idx_unique ON diku_mod_orders_storage.suffixes '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$;
2021-10-01T16:36:26,661 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP TRIGGER IF EXISTS update_suffixes_references ON diku_mod_orders_storage.suffixes CASCADE;
2021-10-01T16:36:26,661 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "update_suffixes_references" for relation "diku_mod_orders_storage.suffixes" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,661 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP TRIGGER IF EXISTS update_suffixes_references ON diku_mod_orders_storage.suffixes CASCADE;
2021-10-01T16:36:26,661 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_suffixes_references();
2021-10-01T16:36:26,662 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_suffixes_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,662 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_suffixes_references();
2021-10-01T16:36:26,662 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP TRIGGER IF EXISTS set_suffixes_ol_version_trigger     ON diku_mod_orders_storage.suffixes CASCADE;
2021-10-01T16:36:26,662 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='trigger "set_suffixes_ol_version_trigger" for relation "diku_mod_orders_storage.suffixes" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,662 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP TRIGGER IF EXISTS set_suffixes_ol_version_trigger     ON diku_mod_orders_storage.suffixes CASCADE;
2021-10-01T16:36:26,662 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.suffixes_set_ol_version() CASCADE;
2021-10-01T16:36:26,663 WARN  [vert.x-eventloop-thread-1] SocketConnectionBase Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.suffixes_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
2021-10-01T16:36:26,663 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.suffixes_set_ol_version() CASCADE;
2021-10-01T16:36:26,663 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} CREATE OR REPLACE VIEW receiving_history_view AS SELECT pieces.id AS id,        json_build_object(            'id', pieces.jsonb ->>'id',            'caption', pieces.jsonb ->>'caption',            'checkin', po_line.jsonb ->>'checkinItems',            'chronology', pieces.jsonb ->>'chronology',            'comment', pieces.jsonb ->>'comment',            'copyNumber', pieces.jsonb ->>'copyNumber',            'dateOrdered', purchase_order.jsonb ->>'dateOrdered',            'discoverySuppress', pieces.jsonb ->>'discoverySuppress',            'displayOnHolding', pieces.jsonb ->>'displayOnHolding',            'enumeration', pieces.jsonb ->>'enumeration',            'itemId', pieces.jsonb ->>'itemId',            'locationId', pieces.jsonb ->>'locationId',            'pieceFormat', pieces.jsonb ->>'format',            'poLineId', pieces.jsonb ->>'poLineId',            'poLineNumber', po_line.jsonb ->>'poLineNumber',            'purchaseOrderId', po_line.jsonb ->>'purchaseOrderId',            'poLineReceiptStatus', po_line.jsonb ->>'receiptStatus',            'receiptDate', pieces.jsonb ->>'receiptDate',            'receivedDate', pieces.jsonb ->>'receivedDate',            'receivingNote', po_line.jsonb -> 'details' ->>'receivingNote',            'receivingStatus', pieces.jsonb ->>'receivingStatus',            'supplement', pieces.jsonb ->>'supplement',            'title', po_line.jsonb ->>'titleOrPackage') AS jsonb,        json_build_object(            'id', pieces.jsonb ->>'id',            'acqUnitIds', purchase_order.jsonb ->>'acqUnitIds',            'caption', pieces.jsonb ->>'caption',            'checkin', po_line.jsonb ->>'checkinItems',            'chronology', pieces.jsonb ->>'chronology',            'comment', pieces.jsonb ->>'comment',            'copyNumber', pieces.jsonb ->>'copyNumber',            'dateOrdered', purchase_order.jsonb ->>'dateOrdered',            'discoverySuppress', pieces.jsonb ->>'discoverySuppress',            'displayOnHolding', pieces.jsonb ->>'displayOnHolding',            'enumeration', pieces.jsonb ->>'enumeration',            'itemId', pieces.jsonb ->>'itemId',            'locationId', pieces.jsonb ->>'locationId',            'pieceFormat', pieces.jsonb ->>'format',            'poLineId', pieces.jsonb ->>'poLineId',            'poLineNumber', po_line.jsonb ->>'poLineNumber',            'purchaseOrderId', po_line.jsonb ->>'purchaseOrderId',            'poLineReceiptStatus', po_line.jsonb ->>'receiptStatus',            'receiptDate', pieces.jsonb ->>'receiptDate',            'receivedDate', pieces.jsonb ->>'receivedDate',            'receivingNote', po_line.jsonb -> 'details' ->> 'receivingNote',            'receivingStatus', pieces.jsonb ->>'receivingStatus',            'supplement', pieces.jsonb ->>'supplement',            'title', po_line.jsonb ->>'titleOrPackage')::jsonb AS metadata FROM pieces LEFT OUTER JOIN po_line ON pieces.jsonb ->>'poLineId' = po_line.jsonb->>'id' LEFT OUTER JOIN purchase_order     ON po_line.jsonb->>'purchaseOrderId' = purchase_order.jsonb->>'id';
2021-10-01T16:36:26,669 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  CREATE OR REPLACE VIEW receiving_history_view AS SELECT pieces.id AS id,        json_build_object(            'id', pieces.jsonb ->>'id',            'caption', pieces.jsonb ->>'caption',            'checkin', po_line.jsonb ->>'checkinItems',            'chronology', pieces.jsonb ->>'chronology',            'comment', pieces.jsonb ->>'comment',            'copyNumber', pieces.jsonb ->>'copyNumber',            'dateOrdered', purchase_order.jsonb ->>'dateOrdered',            'discoverySuppress', pieces.jsonb ->>'discoverySuppress',            'displayOnHolding', pieces.jsonb ->>'displayOnHolding',            'enumeration', pieces.jsonb ->>'enumeration',            'itemId', pieces.jsonb ->>'itemId',            'locationId', pieces.jsonb ->>'locationId',            'pieceFormat', pieces.jsonb ->>'format',            'poLineId', pieces.jsonb ->>'poLineId',            'poLineNumber', po_line.jsonb ->>'poLineNumber',            'purchaseOrderId', po_line.jsonb ->>'purchaseOrderId',            'poLineReceiptStatus', po_line.jsonb ->>'receiptStatus',            'receiptDate', pieces.jsonb ->>'receiptDate',            'receivedDate', pieces.jsonb ->>'receivedDate',            'receivingNote', po_line.jsonb -> 'details' ->>'receivingNote',            'receivingStatus', pieces.jsonb ->>'receivingStatus',            'supplement', pieces.jsonb ->>'supplement',            'title', po_line.jsonb ->>'titleOrPackage') AS jsonb,        json_build_object(            'id', pieces.jsonb ->>'id',            'acqUnitIds', purchase_order.jsonb ->>'acqUnitIds',            'caption', pieces.jsonb ->>'caption',            'checkin', po_line.jsonb ->>'checkinItems',            'chronology', pieces.jsonb ->>'chronology',            'comment', pieces.jsonb ->>'comment',            'copyNumber', pieces.jsonb ->>'copyNumber',            'dateOrdered', purchase_order.jsonb ->>'dateOrdered',            'discoverySuppress', pieces.jsonb ->>'discoverySuppress',            'displayOnHolding', pieces.jsonb ->>'displayOnHolding',            'enumeration', pieces.jsonb ->>'enumeration',            'itemId', pieces.jsonb ->>'itemId',            'locationId', pieces.jsonb ->>'locationId',            'pieceFormat', pieces.jsonb ->>'format',            'poLineId', pieces.jsonb ->>'poLineId',            'poLineNumber', po_line.jsonb ->>'poLineNumber',            'purchaseOrderId', po_line.jsonb ->>'purchaseOrderId',            'poLineReceiptStatus', po_line.jsonb ->>'receiptStatus',            'receiptDate', pieces.jsonb ->>'receiptDate',            'receivedDate', pieces.jsonb ->>'receivedDate',            'receivingNote', po_line.jsonb -> 'details' ->> 'receivingNote',            'receivingStatus', pieces.jsonb ->>'receivingStatus',            'supplement', pieces.jsonb ->>'supplement',            'title', po_line.jsonb ->>'titleOrPackage')::jsonb AS metadata FROM pieces LEFT OUTER JOIN po_line ON pieces.jsonb ->>'poLineId' = po_line.jsonb->>'id' LEFT OUTER JOIN purchase_order     ON po_line.jsonb->>'purchaseOrderId' = purchase_order.jsonb->>'id';
2021-10-01T16:36:26,669 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} UPDATE diku_mod_orders_storage.po_line SET jsonb =   (     SELECT jsonb_set(jsonb, '{fundDistribution}', jsonb_agg(         distrib || jsonb_build_object('code', replace(distrib ->> 'code', ':', '-'))     ))     FROM jsonb_array_elements(jsonb -> 'fundDistribution') distrib   ) WHERE jsonb_array_length(jsonb -> 'fundDistribution') > 0   AND (SELECT count(*)     FROM jsonb_array_elements(jsonb -> 'fundDistribution') elem     WHERE elem ->> 'code' LIKE '%:%') > 0;
2021-10-01T16:36:26,697 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  UPDATE diku_mod_orders_storage.po_line SET jsonb =   (     SELECT jsonb_set(jsonb, '{fundDistribution}', jsonb_agg(         distrib || jsonb_build_object('code', replace(distrib ->> 'code', ':', '-'))     ))     FROM jsonb_array_elements(jsonb -> 'fundDistribution') distrib   ) WHERE jsonb_array_length(jsonb -> 'fundDistribution') > 0   AND (SELECT count(*)     FROM jsonb_array_elements(jsonb -> 'fundDistribution') elem     WHERE elem ->> 'code' LIKE '%:%') > 0;
2021-10-01T16:36:26,697 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} DO $$
DECLARE
  aname TEXT;
BEGIN
  FOR aname IN SELECT name FROM diku_mod_orders_storage.rmb_internal_index WHERE remove = TRUE
  LOOP
    EXECUTE 'DROP INDEX IF EXISTS ' || aname;
  END LOOP;
END $$;
2021-10-01T16:36:26,698 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  DO $$
DECLARE
  aname TEXT;
BEGIN
  FOR aname IN SELECT name FROM diku_mod_orders_storage.rmb_internal_index WHERE remove = TRUE
  LOOP
    EXECUTE 'DROP INDEX IF EXISTS ' || aname;
  END LOOP;
END $$;
2021-10-01T16:36:26,698 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} DO $$
DECLARE
  version TEXT;
  i RECORD;
  newindexdef TEXT;
BEGIN
  SELECT jsonb->>'rmbVersion' INTO version FROM diku_mod_orders_storage.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_orders_storage'
  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_orders_storage.\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 $$;
2021-10-01T16:36:26,699 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  DO $$
DECLARE
  version TEXT;
  i RECORD;
  newindexdef TEXT;
BEGIN
  SELECT jsonb->>'rmbVersion' INTO version FROM diku_mod_orders_storage.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_orders_storage'
  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_orders_storage.\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 $$;
2021-10-01T16:36:26,699 INFO  [vert.x-eventloop-thread-1] 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 $$;
2021-10-01T16:36:26,717 INFO  [vert.x-eventloop-thread-1] 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 $$;
2021-10-01T16:36:26,717 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} TRUNCATE rmb_internal_analyze;
2021-10-01T16:36:26,720 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  TRUNCATE rmb_internal_analyze;
2021-10-01T16:36:26,720 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_orders_storage TO diku_mod_orders_storage;
2021-10-01T16:36:26,724 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_orders_storage TO diku_mod_orders_storage;
2021-10-01T16:36:26,724 INFO  [vert.x-eventloop-thread-1] PostgresClient trying to execute: {} UPDATE diku_mod_orders_storage.rmb_internal   SET jsonb = jsonb || jsonb_build_object(     'rmbVersion', '33.0.0',     'moduleVersion', 'mod-orders-storage-13.1.0',     'schemaJson', $mainftl${
  "exactCount" : 20000,
  "scripts": [
    {
      "run": "after",
      "snippetPath": "views/receiving_history_view.sql",
      "fromModuleVersion": "mod-orders-storage-13.1.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS orders_view;",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS order_lines_view;",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS purchase_orders_view;",
      "fromModuleVersion": "mod-orders-storage-7.0.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS po_lines_view;",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/9.0.0/po_line_table.sql",
      "fromModuleVersion": "mod-orders-storage-9.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/10.0.0/po_line_table.sql",
      "fromModuleVersion": "mod-orders-storage-10.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/10.0.0/purchase_order_table.sql",
      "fromModuleVersion": "mod-orders-storage-10.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/11.0.0/purchase_order_table.sql",
      "fromModuleVersion": "mod-orders-storage-11.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/11.0.0/update_title.sql",
      "fromModuleVersion": "mod-orders-storage-11.0.1"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/11.0.0/pieces_table.sql",
      "fromModuleVersion": "mod-orders-storage-11.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/po_line_sync_fund_code.sql",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/purchase_order_encumber_flag.sql",
      "fromModuleVersion": "mod-orders-storage-12.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/pol_status_for_ongoing_orders.sql",
      "fromModuleVersion": "mod-orders-storage-12.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/reference_number_migration.sql",
      "fromModuleVersion": "mod-orders-storage-12.0.0"
    },
    {
      "run": "before",
      "snippetPath": "data-migration/12.0.0/delete_order_invoices_relation_duplicates.ftl",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/13.1.0/restriction_for_fund_codes.sql",
      "fromModuleVersion": "mod-orders-storage-13.1.0"
    }
  ],
  "tables": [
    {
      "tableName": "alert",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true
    },
    {
      "tableName": "reporting_code",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true
    },
    {
      "tableName": "purchase_order",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "withMetadata": true,
      "customSnippetPath": "purchase_order_table.sql",
      "index": [
        {
          "fieldName": "acqUnitIds",
          "caseSensitive": false
        },
        {
          "fieldName": "assignedTo",
          "caseSensitive": false
        },
        {
          "fieldName": "metadata.createdDate",
          "caseSensitive": false
        },
        {
          "fieldName": "metadata.createdByUserId",
          "caseSensitive": false
        },
        {
          "fieldName": "workflowStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "approved",
          "caseSensitive": false
        },
        {
          "fieldName": "dateOrdered",
          "caseSensitive": false
        },
        {
          "fieldName": "orderType",
          "caseSensitive": false
        },
        {
          "fieldName": "reEncumber",
          "caseSensitive": false
        },
        {
          "fieldName": "renewal.manualRenewal",
          "tOps": "DELETE"
        },
        {
          "fieldName": "renewal.renewalDate",
          "tOps": "DELETE"
        },
        {
          "fieldName": "renewal.reviewPeriod",
          "tOps": "DELETE"
        },
        {
          "fieldName": "ongoing.manualRenewal",
          "caseSensitive": false
        },
        {
          "fieldName": "ongoing.renewalDate",
          "caseSensitive": false
        },
        {
          "fieldName": "ongoing.reviewPeriod",
          "caseSensitive": false
        }
      ],
      "fullTextIndex": [
        {
          "fieldName": "closeReason.reason"
        },
        {
          "fieldName": "closeReason.note"
        }
      ]
    },
    {
      "tableName": "po_line",
      "fromModuleVersion": "mod-orders-storage-12.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "purchaseOrderId",
          "targetTable": "purchase_order",
          "tableAlias": "poLine",
          "targetTableAlias": "purchaseOrder"
        }
      ],
      "index": [
        {
          "fieldName": "eresource.accessProvider",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.activated",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.expectedActivation",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.trial",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.materialType",
          "caseSensitive": false
        },
        {
          "fieldName": "details.subscriptionFrom",
          "caseSensitive": false
        },
        {
          "fieldName": "details.subscriptionTo",
          "caseSensitive": false
        },
        {
          "fieldName": "location.locationId",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.receiptDue",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.expectedReceiptDate",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.volumes",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.materialType",
          "caseSensitive": false
        },
        {
          "fieldName": "claim.grace",
          "caseSensitive": false
        },
        {
          "fieldName": "claim.sent",
          "caseSensitive": false
        },
        {
          "fieldName": "collection",
          "caseSensitive": false
        },
        {
          "fieldName": "receiptStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "paymentStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "orderFormat",
          "caseSensitive": false
        },
        {
          "fieldName": "receiptDate",
          "caseSensitive": false
        },
        {
          "fieldName": "metadata.createdDate",
          "caseSensitive": false
        },
        {
          "fieldName": "rush",
          "caseSensitive": false
        },
        {
          "fieldName": "source",
          "caseSensitive": false
        }
      ],
      "fullTextIndex": [
        {
          "fieldName": "publisher"
        },
        {
          "fieldName": "donor"
        },
        {
          "fieldName": "selector"
        }
      ],
      "ginIndex": [
        {
          "fieldName": "fundDistribution.code",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "details.productIds",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "title",
          "tOps": "DELETE"
        },
        {
          "fieldName": "titleOrPackage",
          "caseSensitive": false,
          "removeAccents": true,
          "tOps": "ADD"
        },
        {
          "fieldName": "vendor.vendorAccount",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "vendor.refNumber",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "tags",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "contributors",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "requester",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "poLineNumber",
          "caseSensitive": false,
          "removeAccents": true
        }
      ]
    },
    {
      "tableName": "titles",
      "fromModuleVersion": "mod-orders-storage-11.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "poLineId",
          "targetTable":      "po_line",
          "targetTableAlias": "poLine",
          "tableAlias": "titles",
          "tOps": "ADD"
        },
        {
          "targetPath": ["poLineId", "purchaseOrderId"],
          "targetTable":      "purchase_order",
          "targetTableAlias": "purchaseOrder",
          "tableAlias": "titles"
        }
      ]
    },
    {
      "tableName": "pieces",
      "fromModuleVersion": "mod-orders-storage-11.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "poLineId",
          "targetTable": "po_line"
        },
        {
          "fieldName": "titleId",
          "targetTable": "titles",
          "targetTableAlias": "titles",
          "tableAlias": "pieces",
          "tOps": "ADD"
        }
      ],
      "index": [
        {
          "fieldName": "format",
          "caseSensitive": false
        },
        {
          "fieldName": "itemId",
          "caseSensitive": false
        },
        {
          "fieldName": "locationId",
          "caseSensitive": false
        },
        {
          "fieldName": "receivingStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "receivedDate",
          "caseSensitive": false
        },
        {
          "fieldName": "supplement",
          "caseSensitive": false
        }
      ],
      "fullTextIndex": [
        {
          "fieldName": "comment"
        }
      ],
      "ginIndex": [
        {
          "fieldName": "caption",
          "caseSensitive": false,
          "removeAccents": true
        }
      ]
    },
    {
      "tableName": "order_invoice_relationship",
      "fromModuleVersion": "mod-orders-storage-12.1.0",
      "withMetadata": false,
      "uniqueIndex": [
        {
          "fieldName": "purchaseOrderId_invoiceId",
          "multiFieldNames": "purchaseOrderId,invoiceId",
          "tOps": "ADD"
        }
      ],
      "foreignKeys": [
        {
          "fieldName": "purchaseOrderId",
          "targetTable": "purchase_order",
          "tableAlias": "orderInvoiceRel",
          "targetTableAlias": "purchase_order",
          "tOps": "ADD"
        }
      ]
    },
    {
      "tableName": "acquisitions_unit",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true,
      "uniqueIndex": [
        {
            "fieldName" : "name"
        }
      ]
    },
    {
      "tableName": "acquisitions_unit_assignments",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "mode": "delete",
      "auditingTableName": "NOT_EXISTING_AUDITING_TABLE"
    },
    {
    "tableName": "acquisitions_unit_membership",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "acquisitionsUnitId",
          "targetTable": "acquisitions_unit"
        }
      ],
      "index": [
         {
            "fieldName" : "userId"
         }
       ]
     },
     {
      "tableName": "order_templates",
      "fromModuleVersion": "mod-orders-storage-8.0.0",
      "withMetadata": false,
      "uniqueIndex": [
         {
           "fieldName" : "templateName"
         }
       ]
     },
    {
      "tableName": "reasons_for_closure",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "uniqueIndex": [
        {
          "fieldName" : "reason"
        }
      ]
    },
    {
      "tableName": "prefixes",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "uniqueIndex": [
        {
          "fieldName" : "name"
        }
      ]
    },
    {
      "tableName": "suffixes",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "uniqueIndex": [
        {
          "fieldName" : "name"
        }
      ]
    }
  ]
}
$mainftl$);
2021-10-01T16:36:26,730 INFO  [vert.x-eventloop-thread-1] PostgresClient Successfully executed  UPDATE diku_mod_orders_storage.rmb_internal   SET jsonb = jsonb || jsonb_build_object(     'rmbVersion', '33.0.0',     'moduleVersion', 'mod-orders-storage-13.1.0',     'schemaJson', $mainftl${
  "exactCount" : 20000,
  "scripts": [
    {
      "run": "after",
      "snippetPath": "views/receiving_history_view.sql",
      "fromModuleVersion": "mod-orders-storage-13.1.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS orders_view;",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS order_lines_view;",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS purchase_orders_view;",
      "fromModuleVersion": "mod-orders-storage-7.0.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS po_lines_view;",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/9.0.0/po_line_table.sql",
      "fromModuleVersion": "mod-orders-storage-9.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/10.0.0/po_line_table.sql",
      "fromModuleVersion": "mod-orders-storage-10.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/10.0.0/purchase_order_table.sql",
      "fromModuleVersion": "mod-orders-storage-10.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/11.0.0/purchase_order_table.sql",
      "fromModuleVersion": "mod-orders-storage-11.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/11.0.0/update_title.sql",
      "fromModuleVersion": "mod-orders-storage-11.0.1"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/11.0.0/pieces_table.sql",
      "fromModuleVersion": "mod-orders-storage-11.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/po_line_sync_fund_code.sql",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/purchase_order_encumber_flag.sql",
      "fromModuleVersion": "mod-orders-storage-12.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/pol_status_for_ongoing_orders.sql",
      "fromModuleVersion": "mod-orders-storage-12.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/reference_number_migration.sql",
      "fromModuleVersion": "mod-orders-storage-12.0.0"
    },
    {
      "run": "before",
      "snippetPath": "data-migration/12.0.0/delete_order_invoices_relation_duplicates.ftl",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/13.1.0/restriction_for_fund_codes.sql",
      "fromModuleVersion": "mod-orders-storage-13.1.0"
    }
  ],
  "tables": [
    {
      "tableName": "alert",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true
    },
    {
      "tableName": "reporting_code",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true
    },
    {
      "tableName": "purchase_order",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "withMetadata": true,
      "customSnippetPath": "purchase_order_table.sql",
      "index": [
        {
          "fieldName": "acqUnitIds",
          "caseSensitive": false
        },
        {
          "fieldName": "assignedTo",
          "caseSensitive": false
        },
        {
          "fieldName": "metadata.createdDate",
          "caseSensitive": false
        },
        {
          "fieldName": "metadata.createdByUserId",
          "caseSensitive": false
        },
        {
          "fieldName": "workflowStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "approved",
          "caseSensitive": false
        },
        {
          "fieldName": "dateOrdered",
          "caseSensitive": false
        },
        {
          "fieldName": "orderType",
          "caseSensitive": false
        },
        {
          "fieldName": "reEncumber",
          "caseSensitive": false
        },
        {
          "fieldName": "renewal.manualRenewal",
          "tOps": "DELETE"
        },
        {
          "fieldName": "renewal.renewalDate",
          "tOps": "DELETE"
        },
        {
          "fieldName": "renewal.reviewPeriod",
          "tOps": "DELETE"
        },
        {
          "fieldName": "ongoing.manualRenewal",
          "caseSensitive": false
        },
        {
          "fieldName": "ongoing.renewalDate",
          "caseSensitive": false
        },
        {
          "fieldName": "ongoing.reviewPeriod",
          "caseSensitive": false
        }
      ],
      "fullTextIndex": [
        {
          "fieldName": "closeReason.reason"
        },
        {
          "fieldName": "closeReason.note"
        }
      ]
    },
    {
      "tableName": "po_line",
      "fromModuleVersion": "mod-orders-storage-12.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "purchaseOrderId",
          "targetTable": "purchase_order",
          "tableAlias": "poLine",
          "targetTableAlias": "purchaseOrder"
        }
      ],
      "index": [
        {
          "fieldName": "eresource.accessProvider",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.activated",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.expectedActivation",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.trial",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.materialType",
          "caseSensitive": false
        },
        {
          "fieldName": "details.subscriptionFrom",
          "caseSensitive": false
        },
        {
          "fieldName": "details.subscriptionTo",
          "caseSensitive": false
        },
        {
          "fieldName": "location.locationId",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.receiptDue",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.expectedReceiptDate",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.volumes",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.materialType",
          "caseSensitive": false
        },
        {
          "fieldName": "claim.grace",
          "caseSensitive": false
        },
        {
          "fieldName": "claim.sent",
          "caseSensitive": false
        },
        {
          "fieldName": "collection",
          "caseSensitive": false
        },
        {
          "fieldName": "receiptStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "paymentStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "orderFormat",
          "caseSensitive": false
        },
        {
          "fieldName": "receiptDate",
          "caseSensitive": false
        },
        {
          "fieldName": "metadata.createdDate",
          "caseSensitive": false
        },
        {
          "fieldName": "rush",
          "caseSensitive": false
        },
        {
          "fieldName": "source",
          "caseSensitive": false
        }
      ],
      "fullTextIndex": [
        {
          "fieldName": "publisher"
        },
        {
          "fieldName": "donor"
        },
        {
          "fieldName": "selector"
        }
      ],
      "ginIndex": [
        {
          "fieldName": "fundDistribution.code",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "details.productIds",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "title",
          "tOps": "DELETE"
        },
        {
          "fieldName": "titleOrPackage",
          "caseSensitive": false,
          "removeAccents": true,
          "tOps": "ADD"
        },
        {
          "fieldName": "vendor.vendorAccount",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "vendor.refNumber",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "tags",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "contributors",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "requester",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "poLineNumber",
          "caseSensitive": false,
          "removeAccents": true
        }
      ]
    },
    {
      "tableName": "titles",
      "fromModuleVersion": "mod-orders-storage-11.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "poLineId",
          "targetTable":      "po_line",
          "targetTableAlias": "poLine",
          "tableAlias": "titles",
          "tOps": "ADD"
        },
        {
          "targetPath": ["poLineId", "purchaseOrderId"],
          "targetTable":      "purchase_order",
          "targetTableAlias": "purchaseOrder",
          "tableAlias": "titles"
        }
      ]
    },
    {
      "tableName": "pieces",
      "fromModuleVersion": "mod-orders-storage-11.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "poLineId",
          "targetTable": "po_line"
        },
        {
          "fieldName": "titleId",
          "targetTable": "titles",
          "targetTableAlias": "titles",
          "tableAlias": "pieces",
          "tOps": "ADD"
        }
      ],
      "index": [
        {
          "fieldName": "format",
          "caseSensitive": false
        },
        {
          "fieldName": "itemId",
          "caseSensitive": false
        },
        {
          "fieldName": "locationId",
          "caseSensitive": false
        },
        {
          "fieldName": "receivingStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "receivedDate",
          "caseSensitive": false
        },
        {
          "fieldName": "supplement",
          "caseSensitive": false
        }
      ],
      "fullTextIndex": [
        {
          "fieldName": "comment"
        }
      ],
      "ginIndex": [
        {
          "fieldName": "caption",
          "caseSensitive": false,
          "removeAccents": true
        }
      ]
    },
    {
      "tableName": "order_invoice_relationship",
      "fromModuleVersion": "mod-orders-storage-12.1.0",
      "withMetadata": false,
      "uniqueIndex": [
        {
          "fieldName": "purchaseOrderId_invoiceId",
          "multiFieldNames": "purchaseOrderId,invoiceId",
          "tOps": "ADD"
        }
      ],
      "foreignKeys": [
        {
          "fieldName": "purchaseOrderId",
          "targetTable": "purchase_order",
          "tableAlias": "orderInvoiceRel",
          "targetTableAlias": "purchase_order",
          "tOps": "ADD"
        }
      ]
    },
    {
      "tableName": "acquisitions_unit",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true,
      "uniqueIndex": [
        {
            "fieldName" : "name"
        }
      ]
    },
    {
      "tableName": "acquisitions_unit_assignments",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "mode": "delete",
      "auditingTableName": "NOT_EXISTING_AUDITING_TABLE"
    },
    {
    "tableName": "acquisitions_unit_membership",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "acquisitionsUnitId",
          "targetTable": "acquisitions_unit"
        }
      ],
      "index": [
         {
            "fieldName" : "userId"
         }
       ]
     },
     {
      "tableName": "order_templates",
      "fromModuleVersion": "mod-orders-storage-8.0.0",
      "withMetadata": false,
      "uniqueIndex": [
         {
           "fieldName" : "templateName"
         }
       ]
     },
    {
      "tableName": "reasons_for_closure",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "uniqueIndex": [
        {
          "fieldName" : "reason"
        }
      ]
    },
    {
      "tableName": "prefixes",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "uniqueIndex": [
        {
          "fieldName" : "name"
        }
      ]
    },
    {
      "tableName": "suffixes",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "uniqueIndex": [
        {
          "fieldName" : "name"
        }
      ]
    }
  ]
}
$mainftl$);
2021-10-01T16:36:26,734 INFO  [vert.x-eventloop-thread-1] TenantReferenceAPI postTenant
2021-10-01T16:36:26,795 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getTenantByOperationId
2021-10-01T16:36:26,822 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,860 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,860 INFO  [vert.x-eventloop-thread-1] LoadConfs File does not exist: /postgres-conf.json
2021-10-01T16:36:26,861 INFO  [vert.x-eventloop-thread-1] LoadConfs Resource has been loaded: /postgres-conf.json
2021-10-01T16:36:26,861 INFO  [vert.x-eventloop-thread-1] PostgresClient Using schema: diku
2021-10-01T16:36:26,861 INFO  [vert.x-eventloop-thread-1] PostgresClient postgreSQLClientConfig = {"host":"localhost","port":5432,"database":"okapi_modules","username":"diku_mod_orders_storage","password":"...","postgres_tester":false}
2021-10-01T16:36:26,867 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:38052 GET /_/tenant/96f0bfed-d0c4-49a6-8d7d-6eba57902dae null HTTP_1_1 200 284 72 tid=diku OK 
2021-10-01T16:36:26,877 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/af55e63f-10f9-4919-add9-6feaf7097a6c null HTTP_1_1 204 0 80 tid=diku No Content 
2021-10-01T16:36:26,889 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,889 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,901 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/89389f7b-54e9-4b95-b5d0-f89c29b71147 null HTTP_1_1 204 0 12 tid=diku No Content 
2021-10-01T16:36:26,904 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,905 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,916 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/65a75ad7-fbbe-4139-9c69-79fbba805ce9 null HTTP_1_1 204 0 12 tid=diku No Content 
2021-10-01T16:36:26,920 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,920 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,931 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/cae85c3d-a839-420a-868d-283cedb1fd2f null HTTP_1_1 204 0 11 tid=diku No Content 
2021-10-01T16:36:26,934 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,935 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,938 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/71a83ae9-6af0-479e-b579-4904b24a3300 null HTTP_1_1 204 0 4 tid=diku No Content 
2021-10-01T16:36:26,941 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,942 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,945 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/fa4ab110-bf7c-4c1c-9014-fa3f95e1d07c null HTTP_1_1 204 0 4 tid=diku No Content 
2021-10-01T16:36:26,949 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,950 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,953 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/b72e8ea6-67b3-4238-9257-5d8e29b95694 null HTTP_1_1 204 0 5 tid=diku No Content 
2021-10-01T16:36:26,956 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,957 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,960 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/dcbb7f40-f2ae-4ad3-a367-27bff67ff6e6 null HTTP_1_1 204 0 4 tid=diku No Content 
2021-10-01T16:36:26,964 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,964 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,967 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/29936d21-93e4-4ab3-9ac4-2d11fa40e942 null HTTP_1_1 204 0 4 tid=diku No Content 
2021-10-01T16:36:26,971 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,971 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,974 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/27d10e3b-66cc-490b-bee6-7c1b2b07394c null HTTP_1_1 204 0 3 tid=diku No Content 
2021-10-01T16:36:26,976 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,977 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,980 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/a47051ec-7a4f-499f-9541-a5fc5deb2f41 null HTTP_1_1 204 0 4 tid=diku No Content 
2021-10-01T16:36:26,983 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,984 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,986 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/7c11e86e-4776-4f4f-9aa4-13e83b4ef44d null HTTP_1_1 204 0 3 tid=diku No Content 
2021-10-01T16:36:26,989 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,990 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,993 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/d17f9d15-4520-49ad-9ffa-123e7739ae53 null HTTP_1_1 204 0 4 tid=diku No Content 
2021-10-01T16:36:26,995 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:26,996 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:26,999 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/22bddeeb-6cbe-45bd-b73d-7343e28c0626 null HTTP_1_1 204 0 4 tid=diku No Content 
2021-10-01T16:36:27,002 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:27,003 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:27,006 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/71a233f8-edac-4e8e-9600-d55222d64273 null HTTP_1_1 204 0 4 tid=diku No Content 
2021-10-01T16:36:27,010 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:27,011 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:27,014 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/8ab21f8d-1343-4228-ac5c-2979ba99412b null HTTP_1_1 204 0 5 tid=diku No Content 
2021-10-01T16:36:27,016 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:27,017 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:27,020 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/8f11f23a-e101-4861-8df2-152da9ce4889 null HTTP_1_1 204 0 4 tid=diku No Content 
2021-10-01T16:36:27,022 INFO  [vert.x-eventloop-thread-1] RestRouting invoking putOrdersStorageConfigurationReasonsForClosureById
2021-10-01T16:36:27,023 WARN  [vert.x-eventloop-thread-1] PgUtil Response 409 is not defined for class class org.folio.rest.jaxrs.resource.OrdersStorageConfiguration$PutOrdersStorageConfigurationReasonsForClosureByIdResponse
2021-10-01T16:36:27,025 INFO  [vert.x-eventloop-thread-1] LogUtil 10.0.2.2:34388 PUT /orders-storage/configuration/reasons-for-closure/ebe73dd1-fa30-4c36-aad9-6c95ea5207ae null HTTP_1_1 204 0 3 tid=diku No Content 
2021-10-01T16:36:27,030 INFO  [vert.x-eventloop-thread-1] TenantAPI job 96f0bfed-d0c4-49a6-8d7d-6eba57902dae completed
2021-10-01T16:36:27,249 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getTenantByOperationId
2021-10-01T16:36:27,254 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:38052 GET /_/tenant/96f0bfed-d0c4-49a6-8d7d-6eba57902dae null HTTP_1_1 200 342 5 tid=diku OK 
2021-10-01T16:36:27,260 INFO  [vert.x-eventloop-thread-1] RestRouting invoking deleteTenantByOperationId
2021-10-01T16:36:27,260 INFO  [vert.x-eventloop-thread-1] TenantReferenceAPI deleteTenant
2021-10-01T16:36:27,269 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:38052 DELETE /_/tenant/96f0bfed-d0c4-49a6-8d7d-6eba57902dae null HTTP_1_1 204 0 10 tid=diku No Content