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