Tests results - Container onap-policy-galera-db-migrator from pod onap-policy-galera-config--1-jjwcm logs

# Results

By type

- Logs

raw version

              + /opt/app/policy/bin/prepare_upgrade.sh policyadmin
    602 blocks
    find: /opt/app/policy/etc/db/migration/policyadmin//*/upgrade: No such file or directory
    Done
    + /opt/app/policy/bin/db-migrator -s policyadmin -o upgrade
    upgrade: 0800 -> 1000

    > upgrade 0100-pdp.sql
    --------------
    ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER HEALTHY
    --------------

    > upgrade 0110-idx_tsidx1.sql
    --------------
    ERROR 1146 (42S02) at line 20: Table 'policyadmin.pdpstatistics' doesn't exist
    CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version)
    --------------

    policyadmin: upgrade aborted at 0900 by script 0110-idx_tsidx1.sql
    policyadmin: failure: upgrade to release 1000 (0900)
    + rc=1
    + /opt/app/policy/bin/db-migrator -s policyadmin -o report
    Partial upgrade detected
    Upgrade will attempt to resume after 0110-idx_tsidx1.sql
    name	version
    policyadmin	0900
    ID	script	operation	from_version	to_version	tag	success	atTime
    1	0100-jpapdpgroup_properties.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:14
    2	0110-jpapdpstatistics_enginestats.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:15
    3	0120-jpapdpsubgroup_policies.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:15
    4	0130-jpapdpsubgroup_properties.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:15
    5	0140-jpapdpsubgroup_supportedpolicytypes.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:16
    6	0150-jpatoscacapabilityassignment_attributes.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:16
    7	0160-jpatoscacapabilityassignment_metadata.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:17
    8	0170-jpatoscacapabilityassignment_occurrences.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:18
    9	0180-jpatoscacapabilityassignment_properties.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:18
    10	0190-jpatoscacapabilitytype_metadata.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:18
    11	0200-jpatoscacapabilitytype_properties.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:19
    12	0210-jpatoscadatatype_constraints.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:19
    13	0220-jpatoscadatatype_metadata.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:19
    14	0230-jpatoscadatatype_properties.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:20
    15	0240-jpatoscanodetemplate_metadata.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:20
    16	0250-jpatoscanodetemplate_properties.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:20
    17	0260-jpatoscanodetype_metadata.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:20
    18	0270-jpatoscanodetype_properties.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:21
    19	0280-jpatoscapolicy_metadata.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:21
    20	0290-jpatoscapolicy_properties.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:21
    21	0300-jpatoscapolicy_targets.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:22
    22	0310-jpatoscapolicytype_metadata.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:22
    23	0320-jpatoscapolicytype_properties.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:22
    24	0330-jpatoscapolicytype_targets.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:23
    25	0340-jpatoscapolicytype_triggers.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:24
    26	0350-jpatoscaproperty_constraints.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:26
    27	0360-jpatoscaproperty_metadata.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:26
    28	0370-jpatoscarelationshiptype_metadata.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:27
    29	0380-jpatoscarelationshiptype_properties.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:27
    30	0390-jpatoscarequirement_metadata.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:27
    31	0400-jpatoscarequirement_occurrences.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:28
    32	0410-jpatoscarequirement_properties.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:28
    33	0420-jpatoscaservicetemplate_metadata.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:28
    34	0430-jpatoscatopologytemplate_inputs.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:29
    35	0440-pdpgroup_pdpsubgroup.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:29
    36	0450-pdpgroup.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:29
    37	0460-pdppolicystatus.sql	upgrade	0	0800	0804220510140800u	1	2022-04-08 05:10:29
    38	0100-pdp.sql	upgrade	0800	0900	0804220512250900u	1	2022-04-08 05:12:26
    39	0110-idx_tsidx1.sql	upgrade	0800	0900	0804220512250900u	0	2022-04-08 05:12:27
    policyadmin: upgrade available: 0900 -> 1000
    + exit 1