Attaching to postgres-db-migrator, postgres postgres | The files belonging to this database system will be owned by user "postgres". postgres | This user must also own the server process. postgres | postgres | The database cluster will be initialized with locale "en_US.utf8". postgres | The default database encoding has accordingly been set to "UTF8". postgres | The default text search configuration will be set to "english". postgres | postgres | Data page checksums are disabled. postgres | postgres | fixing permissions on existing directory /var/lib/postgresql/data ... ok postgres | creating subdirectories ... ok postgres | selecting default max_connections ... 100 postgres | selecting default shared_buffers ... 128MB postgres | selecting dynamic shared memory implementation ... posix postgres | creating configuration files ... ok postgres | running bootstrap script ... ok postgres | performing post-bootstrap initialization ... ok postgres | syncing data to disk ... ok postgres | postgres | Success. You can now start the database server using: postgres | postgres | pg_ctl -D /var/lib/postgresql/data -l logfile start postgres | postgres | postgres | WARNING: enabling "trust" authentication for local connections postgres | You can change this by editing pg_hba.conf or using the option -A, or postgres | --auth-local and --auth-host, the next time you run initdb. postgres | waiting for server to start....2022-03-28 10:25:00.446 UTC [44] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" postgres | 2022-03-28 10:25:00.479 UTC [45] LOG: database system was shut down at 2022-03-28 10:25:00 UTC postgres | 2022-03-28 10:25:00.485 UTC [44] LOG: database system is ready to accept connections postgres | done postgres | server started postgres | postgres | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/db.conf postgres | postgres | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/db.sh postgres | CREATE ROLE postgres | CREATE DATABASE postgres | GRANT postgres | CREATE DATABASE postgres | GRANT postgres | CREATE DATABASE postgres | GRANT postgres | CREATE DATABASE postgres | GRANT postgres | CREATE DATABASE postgres | GRANT postgres | CREATE DATABASE postgres | GRANT postgres | postgres | waiting for server to shut down....2022-03-28 10:25:02.894 UTC [44] LOG: received fast shutdown request postgres | 2022-03-28 10:25:02.897 UTC [44] LOG: aborting any active transactions postgres | 2022-03-28 10:25:02.902 UTC [44] LOG: background worker "logical replication launcher" (PID 51) exited with exit code 1 postgres | 2022-03-28 10:25:02.902 UTC [46] LOG: shutting down postgres | 2022-03-28 10:25:02.935 UTC [44] LOG: database system is shut down postgres | done postgres | server stopped postgres | postgres | PostgreSQL init process complete; ready for start up. postgres | postgres | 2022-03-28 10:25:03.027 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 postgres | 2022-03-28 10:25:03.027 UTC [1] LOG: listening on IPv6 address "::", port 5432 postgres | 2022-03-28 10:25:03.034 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" postgres | 2022-03-28 10:25:03.067 UTC [170] LOG: database system was shut down at 2022-03-28 10:25:02 UTC postgres | 2022-03-28 10:25:03.074 UTC [1] LOG: database system is ready to accept connections postgres | 2022-03-28 10:25:03.791 UTC [177] LOG: incomplete startup packet postgres | 2022-03-28 10:25:27.797 UTC [577] FATAL: password authentication failed for user "postgres" postgres | 2022-03-28 10:25:27.797 UTC [577] DETAIL: Password does not match for user "postgres". postgres | Connection matched pg_hba.conf line 95: "host all all all md5" postgres-db-migrator | Waiting for postgres port 5432... postgres-db-migrator | nc: connect to postgres port 5432 (tcp) failed: Connection refused postgres-db-migrator | nc: connect to postgres port 5432 (tcp) failed: Connection refused postgres-db-migrator | nc: connect to postgres port 5432 (tcp) failed: Connection refused postgres-db-migrator | nc: connect to postgres port 5432 (tcp) failed: Connection refused postgres-db-migrator | Connection to postgres 5432 port [tcp/postgresql] succeeded! postgres-db-migrator | ....Start of test 2022-03-28-10:25:03 postgres-db-migrator | postgres-db-migrator | ############################################################################################################ postgres-db-migrator | postgres-db-migrator | Starting test 1 postgres-db-migrator | 302 blocks postgres-db-migrator | Preparing upgrade release version: 0800 postgres-db-migrator | Preparing upgrade release version: 0900 postgres-db-migrator | Preparing upgrade release version: 1000 postgres-db-migrator | Done postgres-db-migrator | List of databases postgres-db-migrator | Name | Owner | Encoding | Collate | Ctype | Access privileges postgres-db-migrator | -------------------+----------+----------+------------+------------+-------------------------- postgres-db-migrator | clampacm | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | migration | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | operationshistory | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyadmin | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyclamp | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | pooling | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | postgres-db-migrator | template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | (9 rows) postgres-db-migrator | postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | CREATE TABLE postgres-db-migrator | CREATE TABLE postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | INSERT 0 1 postgres-db-migrator | upgrade: 0 -> 0900 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0100-jpapdpgroup_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0110-jpapdpstatistics_enginestats.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0120-jpapdpsubgroup_policies.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0130-jpapdpsubgroup_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0150-jpatoscacapabilityassignment_attributes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0160-jpatoscacapabilityassignment_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0170-jpatoscacapabilityassignment_occurrences.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0180-jpatoscacapabilityassignment_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0190-jpatoscacapabilitytype_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0200-jpatoscacapabilitytype_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0210-jpatoscadatatype_constraints.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0220-jpatoscadatatype_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0230-jpatoscadatatype_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0240-jpatoscanodetemplate_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0250-jpatoscanodetemplate_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0260-jpatoscanodetype_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0270-jpatoscanodetype_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0280-jpatoscapolicy_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0290-jpatoscapolicy_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0300-jpatoscapolicy_targets.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0310-jpatoscapolicytype_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0320-jpatoscapolicytype_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0330-jpatoscapolicytype_targets.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0340-jpatoscapolicytype_triggers.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0350-jpatoscaproperty_constraints.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0360-jpatoscaproperty_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0370-jpatoscarelationshiptype_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0380-jpatoscarelationshiptype_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0390-jpatoscarequirement_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0400-jpatoscarequirement_occurrences.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0410-jpatoscarequirement_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0420-jpatoscaservicetemplate_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0430-jpatoscatopologytemplate_inputs.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0440-pdpgroup_pdpsubgroup.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0450-pdpgroup.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0460-pdppolicystatus.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0470-pdp.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0480-pdpstatistics.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0490-pdpsubgroup_pdp.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0500-pdpsubgroup.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0510-toscacapabilityassignment.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0520-toscacapabilityassignments.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0530-toscacapabilityassignments_toscacapabilityassignment.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0540-toscacapabilitytype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0550-toscacapabilitytypes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0560-toscacapabilitytypes_toscacapabilitytype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0570-toscadatatype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0580-toscadatatypes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0590-toscadatatypes_toscadatatype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0600-toscanodetemplate.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0610-toscanodetemplates.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0620-toscanodetemplates_toscanodetemplate.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0630-toscanodetype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0640-toscanodetypes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0650-toscanodetypes_toscanodetype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0660-toscaparameter.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0670-toscapolicies.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0680-toscapolicies_toscapolicy.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0690-toscapolicy.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0700-toscapolicytype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0710-toscapolicytypes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0720-toscapolicytypes_toscapolicytype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0730-toscaproperty.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0740-toscarelationshiptype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0750-toscarelationshiptypes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0760-toscarelationshiptypes_toscarelationshiptype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0770-toscarequirement.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0780-toscarequirements.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0790-toscarequirements_toscarequirement.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0800-toscaservicetemplate.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0810-toscatopologytemplate.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0820-toscatrigger.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0830-FK_ToscaNodeTemplate_capabilitiesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0840-FK_ToscaNodeTemplate_requirementsName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0850-FK_ToscaNodeType_requirementsName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0870-FK_ToscaServiceTemplate_dataTypesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0880-FK_ToscaServiceTemplate_nodeTypesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0890-FK_ToscaServiceTemplate_policyTypesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0920-FK_ToscaTopologyTemplate_policyName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0940-PdpPolicyStatus_PdpGroup.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0960-FK_ToscaNodeTemplate_capabilitiesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0970-FK_ToscaNodeTemplate_requirementsName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0980-FK_ToscaNodeType_requirementsName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1000-FK_ToscaServiceTemplate_dataTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1010-FK_ToscaServiceTemplate_nodeTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1020-FK_ToscaServiceTemplate_policyTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1050-FK_ToscaTopologyTemplate_policyName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0100-pdp.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0110-idx_tsidx1.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0120-pk_pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0130-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0140-pk_pdpstatistics.sql postgres-db-migrator | UPDATE 0 postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0150-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0160-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0170-jpapdpstatistics_enginestats.sql postgres-db-migrator | UPDATE 0 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0180-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0190-jpapolicyaudit.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0200-JpaPolicyAuditIndex_timestamp.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0210-sequence.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0220-sequence.sql postgres-db-migrator | INSERT 0 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | policyadmin: OK: upgrade (0900) postgres-db-migrator | Ending test 1 postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | Status: (109 rows) postgres-db-migrator | postgres-db-migrator | policyadmin: upgrade available: 0900 -> 1000 postgres-db-migrator | postgres-db-migrator | Test summary: operation:upgrade, from:0, to:0900, new executions:109, sqlFiles:109 postgres-db-migrator | postgres-db-migrator | *** Test 1: PASS , Successful upgrade, current version: *** postgres-db-migrator | postgres-db-migrator | postgres-db-migrator | ############################################################################################################ postgres-db-migrator | postgres-db-migrator | Starting test 2 postgres-db-migrator | 265 blocks postgres-db-migrator | Preparing downgrade release version: 0800 postgres-db-migrator | Preparing downgrade release version: 0900 postgres-db-migrator | Preparing downgrade release version: 1000 postgres-db-migrator | Done postgres-db-migrator | List of databases postgres-db-migrator | Name | Owner | Encoding | Collate | Ctype | Access privileges postgres-db-migrator | -------------------+----------+----------+------------+------------+-------------------------- postgres-db-migrator | clampacm | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | migration | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | operationshistory | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyadmin | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyclamp | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | pooling | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | postgres-db-migrator | template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | (9 rows) postgres-db-migrator | postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | CREATE TABLE postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | CREATE TABLE postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | downgrade: 0900 -> 0800 postgres-db-migrator | postgres-db-migrator | > downgrade 0220-sequence.sql postgres-db-migrator | DELETE 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0210-sequence.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0200-JpaPolicyAuditIndex_timestamp.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0190-jpapolicyaudit.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0180-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0170-jpapdpstatistics_enginestats.sql postgres-db-migrator | UPDATE 0 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0160-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0150-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0140-pk_pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | UPDATE 0 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0130-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0120-pk_pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0110-idx_tsidx1.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0100-pdp.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | policyadmin: OK: downgrade (0800) postgres-db-migrator | Ending test 2 postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | Status: (122 rows) postgres-db-migrator | postgres-db-migrator | policyadmin: downgrade available: 0800 -> 0 postgres-db-migrator | postgres-db-migrator | Test summary: operation:downgrade, from:0900, to:0800, new executions:13, sqlFiles:13 postgres-db-migrator | postgres-db-migrator | *** Test 2: PASS , Successful downgrade, current version: *** postgres-db-migrator | postgres-db-migrator | postgres-db-migrator | ############################################################################################################ postgres-db-migrator | postgres-db-migrator | Starting test 3 postgres-db-migrator | 302 blocks postgres-db-migrator | Preparing upgrade release version: 0800 postgres-db-migrator | Preparing upgrade release version: 0900 postgres-db-migrator | Preparing upgrade release version: 1000 postgres-db-migrator | Done postgres-db-migrator | List of databases postgres-db-migrator | Name | Owner | Encoding | Collate | Ctype | Access privileges postgres-db-migrator | -------------------+----------+----------+------------+------------+-------------------------- postgres-db-migrator | clampacm | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | migration | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | operationshistory | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyadmin | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyclamp | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | pooling | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | postgres-db-migrator | template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | (9 rows) postgres-db-migrator | postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | CREATE TABLE postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | CREATE TABLE postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | upgrade: 0800 -> 1000 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0100-pdp.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0110-idx_tsidx1.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0120-pk_pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0130-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0140-pk_pdpstatistics.sql postgres-db-migrator | UPDATE 0 postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0150-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0160-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0170-jpapdpstatistics_enginestats.sql postgres-db-migrator | UPDATE 0 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0180-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0190-jpapolicyaudit.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0200-JpaPolicyAuditIndex_timestamp.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0210-sequence.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0220-sequence.sql postgres-db-migrator | INSERT 0 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0100-jpatoscapolicy_targets.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0110-jpatoscapolicytype_targets.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0120-toscatrigger.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0130-jpatoscapolicytype_triggers.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0140-toscaparameter.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0150-toscaproperty.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | DROP TABLE postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0160-jpapolicyaudit_pk.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0170-pdpstatistics_pk.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0180-jpatoscanodetemplate_metadata.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | policyadmin: OK: upgrade (1000) postgres-db-migrator | Ending test 3 postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | Status: (144 rows) postgres-db-migrator | postgres-db-migrator | policyadmin: OK @ 1000 postgres-db-migrator | postgres-db-migrator | Test summary: operation:upgrade, from:0800, to:1000, new executions:22, sqlFiles:22 postgres-db-migrator | postgres-db-migrator | *** Test 3: PASS , Successful upgrade, current version: *** postgres-db-migrator | postgres-db-migrator | postgres-db-migrator | ############################################################################################################ postgres-db-migrator | postgres-db-migrator | Starting test 4 postgres-db-migrator | 265 blocks postgres-db-migrator | Preparing downgrade release version: 0800 postgres-db-migrator | Preparing downgrade release version: 0900 postgres-db-migrator | Preparing downgrade release version: 1000 postgres-db-migrator | Done postgres-db-migrator | List of databases postgres-db-migrator | Name | Owner | Encoding | Collate | Ctype | Access privileges postgres-db-migrator | -------------------+----------+----------+------------+------------+-------------------------- postgres-db-migrator | clampacm | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | migration | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | operationshistory | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyadmin | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyclamp | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | pooling | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | postgres-db-migrator | template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | (9 rows) postgres-db-migrator | postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | CREATE TABLE postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | CREATE TABLE postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | downgrade: 1000 -> 0800 postgres-db-migrator | postgres-db-migrator | > downgrade 0180-jpatoscanodetemplate_metadata.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0170-pdpstatistics_pk.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0160-jpapolicyaudit_pk.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0150-toscaproperty.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | CREATE TABLE postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0140-toscaparameter.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0130-jpatoscapolicytype_triggers.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0120-toscatrigger.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0110-jpatoscapolicytype_targets.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0100-jpatoscapolicy_targets.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0220-sequence.sql postgres-db-migrator | DELETE 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0210-sequence.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0200-JpaPolicyAuditIndex_timestamp.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0190-jpapolicyaudit.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0180-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0170-jpapdpstatistics_enginestats.sql postgres-db-migrator | UPDATE 0 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0160-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0150-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0140-pk_pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | UPDATE 0 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0130-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0120-pk_pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0110-idx_tsidx1.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0100-pdp.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | policyadmin: OK: downgrade (0800) postgres-db-migrator | psql: error: FATAL: password authentication failed for user "postgres" postgres-db-migrator | 302 blocks postgres-db-migrator | Preparing upgrade release version: 0800 postgres-db-migrator | Preparing upgrade release version: 0900 postgres-db-migrator | Preparing upgrade release version: 1000 postgres-db-migrator | Done postgres-db-migrator | List of databases postgres-db-migrator | Name | Owner | Encoding | Collate | Ctype | Access privileges postgres-db-migrator | -------------------+----------+----------+------------+------------+-------------------------- postgres-db-migrator | clampacm | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | migration | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | operationshistory | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyadmin | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyclamp | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | pooling | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | postgres-db-migrator | template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | (9 rows) postgres-db-migrator | postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | CREATE TABLE postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | CREATE TABLE postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | upgrade: 0800 -> 0900 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0100-pdp.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0110-idx_tsidx1.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0120-pk_pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0130-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0140-pk_pdpstatistics.sql postgres-db-migrator | UPDATE 0 postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0150-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0160-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0170-jpapdpstatistics_enginestats.sql postgres-db-migrator | UPDATE 0 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0180-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0190-jpapolicyaudit.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0200-JpaPolicyAuditIndex_timestamp.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0210-sequence.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0220-sequence.sql postgres-db-migrator | INSERT 0 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | policyadmin: OK: upgrade (0900) postgres-db-migrator | Ending test 4 postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | Status: (179 rows) postgres-db-migrator | postgres-db-migrator | policyadmin: upgrade available: 0900 -> 1000 postgres-db-migrator | postgres-db-migrator | Test summary: operation:upgrade, from:0800, to:0900, new executions:179, sqlFiles:13 postgres-db-migrator | postgres-db-migrator | *** Test 4: FAIL , Errors occurred during upgrade, current version: *** postgres-db-migrator | postgres-db-migrator | postgres-db-migrator | ############################################################################################################ postgres-db-migrator | postgres-db-migrator | Starting test 5 postgres-db-migrator | 265 blocks postgres-db-migrator | Preparing downgrade release version: 0800 postgres-db-migrator | Preparing downgrade release version: 0900 postgres-db-migrator | Preparing downgrade release version: 1000 postgres-db-migrator | Done postgres-db-migrator | List of databases postgres-db-migrator | Name | Owner | Encoding | Collate | Ctype | Access privileges postgres-db-migrator | -------------------+----------+----------+------------+------------+-------------------------- postgres-db-migrator | clampacm | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | migration | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | operationshistory | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyadmin | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyclamp | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | pooling | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | postgres-db-migrator | template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | (9 rows) postgres-db-migrator | postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | CREATE TABLE postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | CREATE TABLE postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | downgrade: 0900 -> 0800 postgres-db-migrator | postgres-db-migrator | > downgrade 0220-sequence.sql postgres-db-migrator | DELETE 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0210-sequence.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0200-JpaPolicyAuditIndex_timestamp.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0190-jpapolicyaudit.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0180-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0170-jpapdpstatistics_enginestats.sql postgres-db-migrator | UPDATE 0 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0160-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0150-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0140-pk_pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | UPDATE 0 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0130-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0120-pk_pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0110-idx_tsidx1.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0100-pdp.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | policyadmin: OK: downgrade (0800) postgres-db-migrator | Ending test 5 postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | Status: (192 rows) postgres-db-migrator | postgres-db-migrator | policyadmin: downgrade available: 0800 -> 0 postgres-db-migrator | postgres-db-migrator | Test summary: operation:downgrade, from:0900, to:0800, new executions:13, sqlFiles:13 postgres-db-migrator | postgres-db-migrator | *** Test 5: PASS , Successful downgrade, current version: *** postgres-db-migrator | postgres-db-migrator | postgres-db-migrator | ############################################################################################################ postgres-db-migrator | postgres-db-migrator | Starting test 6 postgres-db-migrator | 265 blocks postgres-db-migrator | Preparing downgrade release version: 0800 postgres-db-migrator | Preparing downgrade release version: 0900 postgres-db-migrator | Preparing downgrade release version: 1000 postgres-db-migrator | Done postgres-db-migrator | List of databases postgres-db-migrator | Name | Owner | Encoding | Collate | Ctype | Access privileges postgres-db-migrator | -------------------+----------+----------+------------+------------+-------------------------- postgres-db-migrator | clampacm | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | migration | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | operationshistory | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyadmin | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyclamp | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | pooling | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | postgres-db-migrator | template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | (9 rows) postgres-db-migrator | postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | CREATE TABLE postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | CREATE TABLE postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | downgrade: 0800 -> 0 postgres-db-migrator | postgres-db-migrator | > downgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 1050-FK_ToscaTopologyTemplate_policyName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 1020-FK_ToscaServiceTemplate_policyTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 1010-FK_ToscaServiceTemplate_nodeTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 1000-FK_ToscaServiceTemplate_dataTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0980-FK_ToscaNodeType_requirementsName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0970-FK_ToscaNodeTemplate_requirementsName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0960-FK_ToscaNodeTemplate_capabilitiesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0940-PdpPolicyStatus_PdpGroup.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0920-FK_ToscaTopologyTemplate_policyName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0890-FK_ToscaServiceTemplate_policyTypesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0880-FK_ToscaServiceTemplate_nodeTypesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0870-FK_ToscaServiceTemplate_dataTypesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0850-FK_ToscaNodeType_requirementsName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0840-FK_ToscaNodeTemplate_requirementsName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0830-FK_ToscaNodeTemplate_capabilitiesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0820-toscatrigger.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0810-toscatopologytemplate.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0800-toscaservicetemplate.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0790-toscarequirements_toscarequirement.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0780-toscarequirements.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0770-toscarequirement.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0760-toscarelationshiptypes_toscarelationshiptype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0750-toscarelationshiptypes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0740-toscarelationshiptype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0730-toscaproperty.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0720-toscapolicytypes_toscapolicytype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0710-toscapolicytypes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0700-toscapolicytype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0690-toscapolicy.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0680-toscapolicies_toscapolicy.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0670-toscapolicies.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0660-toscaparameter.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0650-toscanodetypes_toscanodetype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0640-toscanodetypes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0630-toscanodetype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0620-toscanodetemplates_toscanodetemplate.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0610-toscanodetemplates.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0600-toscanodetemplate.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0590-toscadatatypes_toscadatatype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0580-toscadatatypes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0570-toscadatatype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0560-toscacapabilitytypes_toscacapabilitytype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0550-toscacapabilitytypes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0540-toscacapabilitytype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0530-toscacapabilityassignments_toscacapabilityassignment.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0520-toscacapabilityassignments.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0510-toscacapabilityassignment.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0500-pdpsubgroup.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0490-pdpsubgroup_pdp.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0480-pdpstatistics.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0470-pdp.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0460-pdppolicystatus.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0450-pdpgroup.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0440-pdpgroup_pdpsubgroup.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0430-jpatoscatopologytemplate_inputs.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0420-jpatoscaservicetemplate_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0410-jpatoscarequirement_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0400-jpatoscarequirement_occurrences.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0390-jpatoscarequirement_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0380-jpatoscarelationshiptype_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0370-jpatoscarelationshiptype_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0360-jpatoscaproperty_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0350-jpatoscaproperty_constraints.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0340-jpatoscapolicytype_triggers.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0330-jpatoscapolicytype_targets.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0320-jpatoscapolicytype_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0310-jpatoscapolicytype_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0300-jpatoscapolicy_targets.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0290-jpatoscapolicy_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0280-jpatoscapolicy_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0270-jpatoscanodetype_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0260-jpatoscanodetype_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0250-jpatoscanodetemplate_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0240-jpatoscanodetemplate_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0230-jpatoscadatatype_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0220-jpatoscadatatype_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0210-jpatoscadatatype_constraints.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0200-jpatoscacapabilitytype_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0190-jpatoscacapabilitytype_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0180-jpatoscacapabilityassignment_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0170-jpatoscacapabilityassignment_occurrences.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0160-jpatoscacapabilityassignment_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0150-jpatoscacapabilityassignment_attributes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0130-jpapdpsubgroup_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0120-jpapdpsubgroup_policies.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0110-jpapdpstatistics_enginestats.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0100-jpapdpgroup_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | policyadmin: OK: downgrade (0) postgres-db-migrator | Ending test 6 postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | Status: (288 rows) postgres-db-migrator | postgres-db-migrator | policyadmin: OK @ 0 postgres-db-migrator | postgres-db-migrator | Test summary: operation:downgrade, from:0800, to:0, new executions:96, sqlFiles:96 postgres-db-migrator | postgres-db-migrator | *** Test 6: PASS , Successful downgrade, current version: *** postgres-db-migrator | postgres-db-migrator | postgres-db-migrator | ############################################################################################################ postgres-db-migrator | postgres-db-migrator | Starting test 7 postgres-db-migrator | 302 blocks postgres-db-migrator | Preparing upgrade release version: 0800 postgres-db-migrator | Preparing upgrade release version: 0900 postgres-db-migrator | Preparing upgrade release version: 1000 postgres-db-migrator | Done postgres-db-migrator | List of databases postgres-db-migrator | Name | Owner | Encoding | Collate | Ctype | Access privileges postgres-db-migrator | -------------------+----------+----------+------------+------------+-------------------------- postgres-db-migrator | clampacm | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | migration | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | operationshistory | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyadmin | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyclamp | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | pooling | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | postgres-db-migrator | template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | (9 rows) postgres-db-migrator | postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | CREATE TABLE postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | CREATE TABLE postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | upgrade: 0 -> 1000 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0100-jpapdpgroup_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0110-jpapdpstatistics_enginestats.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0120-jpapdpsubgroup_policies.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0130-jpapdpsubgroup_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0150-jpatoscacapabilityassignment_attributes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0160-jpatoscacapabilityassignment_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0170-jpatoscacapabilityassignment_occurrences.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0180-jpatoscacapabilityassignment_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0190-jpatoscacapabilitytype_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0200-jpatoscacapabilitytype_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0210-jpatoscadatatype_constraints.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0220-jpatoscadatatype_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0230-jpatoscadatatype_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0240-jpatoscanodetemplate_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0250-jpatoscanodetemplate_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0260-jpatoscanodetype_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0270-jpatoscanodetype_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0280-jpatoscapolicy_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0290-jpatoscapolicy_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0300-jpatoscapolicy_targets.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0310-jpatoscapolicytype_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0320-jpatoscapolicytype_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0330-jpatoscapolicytype_targets.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0340-jpatoscapolicytype_triggers.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0350-jpatoscaproperty_constraints.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0360-jpatoscaproperty_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0370-jpatoscarelationshiptype_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0380-jpatoscarelationshiptype_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0390-jpatoscarequirement_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0400-jpatoscarequirement_occurrences.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0410-jpatoscarequirement_properties.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0420-jpatoscaservicetemplate_metadata.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0430-jpatoscatopologytemplate_inputs.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0440-pdpgroup_pdpsubgroup.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0450-pdpgroup.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0460-pdppolicystatus.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0470-pdp.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0480-pdpstatistics.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0490-pdpsubgroup_pdp.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0500-pdpsubgroup.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0510-toscacapabilityassignment.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0520-toscacapabilityassignments.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0530-toscacapabilityassignments_toscacapabilityassignment.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0540-toscacapabilitytype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0550-toscacapabilitytypes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0560-toscacapabilitytypes_toscacapabilitytype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0570-toscadatatype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0580-toscadatatypes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0590-toscadatatypes_toscadatatype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0600-toscanodetemplate.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0610-toscanodetemplates.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0620-toscanodetemplates_toscanodetemplate.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0630-toscanodetype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0640-toscanodetypes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0650-toscanodetypes_toscanodetype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0660-toscaparameter.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0670-toscapolicies.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0680-toscapolicies_toscapolicy.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0690-toscapolicy.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0700-toscapolicytype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0710-toscapolicytypes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0720-toscapolicytypes_toscapolicytype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0730-toscaproperty.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0740-toscarelationshiptype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0750-toscarelationshiptypes.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0760-toscarelationshiptypes_toscarelationshiptype.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0770-toscarequirement.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0780-toscarequirements.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0790-toscarequirements_toscarequirement.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0800-toscaservicetemplate.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0810-toscatopologytemplate.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0820-toscatrigger.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0830-FK_ToscaNodeTemplate_capabilitiesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0840-FK_ToscaNodeTemplate_requirementsName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0850-FK_ToscaNodeType_requirementsName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0870-FK_ToscaServiceTemplate_dataTypesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0880-FK_ToscaServiceTemplate_nodeTypesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0890-FK_ToscaServiceTemplate_policyTypesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0920-FK_ToscaTopologyTemplate_policyName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0940-PdpPolicyStatus_PdpGroup.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0960-FK_ToscaNodeTemplate_capabilitiesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0970-FK_ToscaNodeTemplate_requirementsName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0980-FK_ToscaNodeType_requirementsName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1000-FK_ToscaServiceTemplate_dataTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1010-FK_ToscaServiceTemplate_nodeTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1020-FK_ToscaServiceTemplate_policyTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1050-FK_ToscaTopologyTemplate_policyName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0100-pdp.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0110-idx_tsidx1.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0120-pk_pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0130-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0140-pk_pdpstatistics.sql postgres-db-migrator | UPDATE 0 postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0150-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0160-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0170-jpapdpstatistics_enginestats.sql postgres-db-migrator | UPDATE 0 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0180-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0190-jpapolicyaudit.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0200-JpaPolicyAuditIndex_timestamp.sql postgres-db-migrator | CREATE INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0210-sequence.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0220-sequence.sql postgres-db-migrator | INSERT 0 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0100-jpatoscapolicy_targets.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0110-jpatoscapolicytype_targets.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0120-toscatrigger.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0130-jpatoscapolicytype_triggers.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0140-toscaparameter.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0150-toscaproperty.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | DROP TABLE postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0160-jpapolicyaudit_pk.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0170-pdpstatistics_pk.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | rc=0 postgres-db-migrator | postgres-db-migrator | > upgrade 0180-jpatoscanodetemplate_metadata.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | policyadmin: OK: upgrade (1000) postgres-db-migrator | Ending test 7 postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | Status: (406 rows) postgres-db-migrator | postgres-db-migrator | policyadmin: OK @ 1000 postgres-db-migrator | postgres-db-migrator | Test summary: operation:upgrade, from:0, to:1000, new executions:118, sqlFiles:118 postgres-db-migrator | postgres-db-migrator | *** Test 7: PASS , Successful upgrade, current version: *** postgres-db-migrator | postgres-db-migrator | postgres-db-migrator | ############################################################################################################ postgres-db-migrator | postgres-db-migrator | Starting test 8 postgres-db-migrator | 265 blocks postgres-db-migrator | Preparing downgrade release version: 0800 postgres-db-migrator | Preparing downgrade release version: 0900 postgres-db-migrator | Preparing downgrade release version: 1000 postgres-db-migrator | Done postgres-db-migrator | List of databases postgres-db-migrator | Name | Owner | Encoding | Collate | Ctype | Access privileges postgres-db-migrator | -------------------+----------+----------+------------+------------+-------------------------- postgres-db-migrator | clampacm | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | migration | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | operationshistory | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyadmin | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | policyclamp | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | pooling | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =Tc/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres + postgres-db-migrator | | | | | | policy_user=CTc/postgres postgres-db-migrator | postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | postgres-db-migrator | template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + postgres-db-migrator | | | | | | postgres=CTc/postgres postgres-db-migrator | (9 rows) postgres-db-migrator | postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | CREATE TABLE postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | CREATE TABLE postgres-db-migrator | ?column? postgres-db-migrator | ---------- postgres-db-migrator | (0 rows) postgres-db-migrator | postgres-db-migrator | downgrade: 1000 -> 0 postgres-db-migrator | postgres-db-migrator | > downgrade 0180-jpatoscanodetemplate_metadata.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0170-pdpstatistics_pk.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0160-jpapolicyaudit_pk.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0150-toscaproperty.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | CREATE TABLE postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0140-toscaparameter.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0130-jpatoscapolicytype_triggers.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0120-toscatrigger.sql postgres-db-migrator | CREATE TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0110-jpatoscapolicytype_targets.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0100-jpatoscapolicy_targets.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0220-sequence.sql postgres-db-migrator | DELETE 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0210-sequence.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0200-JpaPolicyAuditIndex_timestamp.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0190-jpapolicyaudit.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0180-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0170-jpapdpstatistics_enginestats.sql postgres-db-migrator | UPDATE 0 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0160-jpapdpstatistics_enginestats.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0150-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0140-pk_pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | UPDATE 0 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0130-pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0120-pk_pdpstatistics.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0110-idx_tsidx1.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0100-pdp.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 1050-FK_ToscaTopologyTemplate_policyName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 1020-FK_ToscaServiceTemplate_policyTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 1010-FK_ToscaServiceTemplate_nodeTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 1000-FK_ToscaServiceTemplate_dataTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0980-FK_ToscaNodeType_requirementsName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0970-FK_ToscaNodeTemplate_requirementsName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0960-FK_ToscaNodeTemplate_capabilitiesName.sql postgres-db-migrator | ALTER TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0940-PdpPolicyStatus_PdpGroup.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0920-FK_ToscaTopologyTemplate_policyName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0890-FK_ToscaServiceTemplate_policyTypesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0880-FK_ToscaServiceTemplate_nodeTypesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0870-FK_ToscaServiceTemplate_dataTypesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0850-FK_ToscaNodeType_requirementsName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0840-FK_ToscaNodeTemplate_requirementsName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0830-FK_ToscaNodeTemplate_capabilitiesName.sql postgres-db-migrator | DROP INDEX postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0820-toscatrigger.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0810-toscatopologytemplate.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0800-toscaservicetemplate.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0790-toscarequirements_toscarequirement.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0780-toscarequirements.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0770-toscarequirement.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0760-toscarelationshiptypes_toscarelationshiptype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0750-toscarelationshiptypes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0740-toscarelationshiptype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0730-toscaproperty.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0720-toscapolicytypes_toscapolicytype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0710-toscapolicytypes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0700-toscapolicytype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0690-toscapolicy.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0680-toscapolicies_toscapolicy.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0670-toscapolicies.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0660-toscaparameter.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0650-toscanodetypes_toscanodetype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0640-toscanodetypes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0630-toscanodetype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0620-toscanodetemplates_toscanodetemplate.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0610-toscanodetemplates.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0600-toscanodetemplate.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0590-toscadatatypes_toscadatatype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0580-toscadatatypes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0570-toscadatatype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0560-toscacapabilitytypes_toscacapabilitytype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0550-toscacapabilitytypes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0540-toscacapabilitytype.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0530-toscacapabilityassignments_toscacapabilityassignment.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0520-toscacapabilityassignments.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0510-toscacapabilityassignment.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0500-pdpsubgroup.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0490-pdpsubgroup_pdp.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0480-pdpstatistics.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0470-pdp.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0460-pdppolicystatus.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0450-pdpgroup.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0440-pdpgroup_pdpsubgroup.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0430-jpatoscatopologytemplate_inputs.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0420-jpatoscaservicetemplate_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0410-jpatoscarequirement_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0400-jpatoscarequirement_occurrences.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0390-jpatoscarequirement_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0380-jpatoscarelationshiptype_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0370-jpatoscarelationshiptype_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0360-jpatoscaproperty_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0350-jpatoscaproperty_constraints.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0340-jpatoscapolicytype_triggers.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0330-jpatoscapolicytype_targets.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0320-jpatoscapolicytype_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0310-jpatoscapolicytype_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0300-jpatoscapolicy_targets.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0290-jpatoscapolicy_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0280-jpatoscapolicy_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0270-jpatoscanodetype_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0260-jpatoscanodetype_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0250-jpatoscanodetemplate_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0240-jpatoscanodetemplate_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0230-jpatoscadatatype_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0220-jpatoscadatatype_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0210-jpatoscadatatype_constraints.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0200-jpatoscacapabilitytype_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0190-jpatoscacapabilitytype_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0180-jpatoscacapabilityassignment_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0170-jpatoscacapabilityassignment_occurrences.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0160-jpatoscacapabilityassignment_metadata.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0150-jpatoscacapabilityassignment_attributes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0130-jpapdpsubgroup_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0120-jpapdpsubgroup_policies.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0110-jpapdpstatistics_enginestats.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | postgres-db-migrator | > downgrade 0100-jpapdpgroup_properties.sql postgres-db-migrator | DROP TABLE postgres-db-migrator | INSERT 0 1 postgres-db-migrator | INSERT 0 1 postgres-db-migrator | policyadmin: OK: downgrade (0) postgres-db-migrator | Ending test 8 postgres-db-migrator | NOTICE: relation "schema_versions" already exists, skipping postgres-db-migrator | NOTICE: relation "policyadmin_schema_changelog" already exists, skipping postgres-db-migrator | Status: (524 rows) postgres-db-migrator | postgres-db-migrator | policyadmin: OK @ 0 postgres-db-migrator | postgres-db-migrator | Test summary: operation:downgrade, from:1000, to:0, new executions:118, sqlFiles:118 postgres-db-migrator | postgres-db-migrator | *** Test 8: PASS , Successful downgrade, current version: *** postgres-db-migrator | postgres-db-migrator | postgres-db-migrator | ----------------------------------------------------------------------- postgres-db-migrator | Number of Tests: 8, Tests Passed: 7, Tests Failed: 1 postgres-db-migrator | ----------------------------------------------------------------------- postgres-db-migrator | End of test 2022-03-28-10:26:02