+ /opt/app/policy/bin/prepare_upgrade.sh policyadmin 302 blocks Preparing upgrade release version: 0800 Preparing upgrade release version: 0900 Preparing upgrade release version: 1000 Done + /opt/app/policy/bin/db-migrator -s policyadmin -o upgrade Partial upgrade detected Upgrade will attempt to resume at 0110-idx_tsidx1.sql upgrade: 0800 -> 1000 > 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 2406220509260800u 1 2022-06-24 05:09:25 2 0110-jpapdpstatistics_enginestats.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:25 3 0120-jpapdpsubgroup_policies.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:26 4 0130-jpapdpsubgroup_properties.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:26 5 0140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:26 6 0150-jpatoscacapabilityassignment_attributes.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:27 7 0160-jpatoscacapabilityassignment_metadata.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:27 8 0170-jpatoscacapabilityassignment_occurrences.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:28 9 0180-jpatoscacapabilityassignment_properties.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:28 10 0190-jpatoscacapabilitytype_metadata.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:28 11 0200-jpatoscacapabilitytype_properties.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:28 12 0210-jpatoscadatatype_constraints.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:29 13 0220-jpatoscadatatype_metadata.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:29 14 0230-jpatoscadatatype_properties.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:29 15 0240-jpatoscanodetemplate_metadata.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:29 16 0250-jpatoscanodetemplate_properties.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:30 17 0260-jpatoscanodetype_metadata.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:30 18 0270-jpatoscanodetype_properties.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:30 19 0280-jpatoscapolicy_metadata.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:30 20 0290-jpatoscapolicy_properties.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:31 21 0300-jpatoscapolicy_targets.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:32 22 0310-jpatoscapolicytype_metadata.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:32 23 0320-jpatoscapolicytype_properties.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:33 24 0330-jpatoscapolicytype_targets.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:33 25 0340-jpatoscapolicytype_triggers.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:34 26 0350-jpatoscaproperty_constraints.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:34 27 0360-jpatoscaproperty_metadata.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:35 28 0370-jpatoscarelationshiptype_metadata.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:35 29 0380-jpatoscarelationshiptype_properties.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:36 30 0390-jpatoscarequirement_metadata.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:36 31 0400-jpatoscarequirement_occurrences.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:36 32 0410-jpatoscarequirement_properties.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:37 33 0420-jpatoscaservicetemplate_metadata.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:37 34 0430-jpatoscatopologytemplate_inputs.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:37 35 0440-pdpgroup_pdpsubgroup.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:37 36 0450-pdpgroup.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:38 37 0460-pdppolicystatus.sql upgrade 0 0800 2406220509260800u 1 2022-06-24 05:09:38 38 0100-pdp.sql upgrade 0800 0900 2406220510350900u 1 2022-06-24 05:10:35 39 0110-idx_tsidx1.sql upgrade 0800 0900 2406220510350900u 0 2022-06-24 05:10:35 40 0110-idx_tsidx1.sql upgrade 0800 0900 2406220512100900u 0 2022-06-24 05:12:10 41 0110-idx_tsidx1.sql upgrade 0800 0900 2406220512430900u 0 2022-06-24 05:12:43 42 0110-idx_tsidx1.sql upgrade 0800 0900 2406220513230900u 0 2022-06-24 05:13:23 43 0110-idx_tsidx1.sql upgrade 0800 0900 2406220514430900u 0 2022-06-24 05:14:43 44 0110-idx_tsidx1.sql upgrade 0800 0900 2406220517230900u 0 2022-06-24 05:17:23 policyadmin: upgrade available: 0900 -> 1000 + exit 1