By type
+ /opt/app/policy/bin/prepare_upgrade.sh policyadmin
281 blocks
+ /opt/app/policy/bin/db-migrator -s policyadmin -o upgrade
Preparing upgrade release version: 0800
Preparing upgrade release version: 0900
Done
Partial upgrade detected
Upgrade will attempt to resume at 0100-pdp.sql
upgrade: 0800 -> 0900
> upgrade 0100-pdp.sql
--------------
ERROR 1146 (42S02) at line 20: Table 'policyadmin.pdp' doesn't exist
ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER HEALTHY
--------------
policyadmin: upgrade aborted at 0900 by script 0100-pdp.sql
+ rc=1
+ /opt/app/policy/bin/db-migrator -s policyadmin -o report
policyadmin: failure: upgrade to release 0900 (0900)
Partial upgrade detected
Upgrade will attempt to resume after 0100-pdp.sql
name version
policyadmin 0900
ID script operation from_version to_version tag success atTime
1 0100-jpapdpgroup_properties.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:38
2 0110-jpapdpstatistics_enginestats.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:39
3 0120-jpapdpsubgroup_policies.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:39
4 0130-jpapdpsubgroup_properties.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:40
5 0140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:41
6 0150-jpatoscacapabilityassignment_attributes.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:42
7 0160-jpatoscacapabilityassignment_metadata.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:43
8 0170-jpatoscacapabilityassignment_occurrences.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:43
9 0180-jpatoscacapabilityassignment_properties.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:44
10 0190-jpatoscacapabilitytype_metadata.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:45
11 0200-jpatoscacapabilitytype_properties.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:46
12 0210-jpatoscadatatype_constraints.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:47
13 0220-jpatoscadatatype_metadata.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:48
14 0230-jpatoscadatatype_properties.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:48
15 0240-jpatoscanodetemplate_metadata.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:49
16 0250-jpatoscanodetemplate_properties.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:50
17 0260-jpatoscanodetype_metadata.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:51
18 0270-jpatoscanodetype_properties.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:52
19 0280-jpatoscapolicy_metadata.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:52
20 0290-jpatoscapolicy_properties.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:53
21 0300-jpatoscapolicy_targets.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:53
22 0310-jpatoscapolicytype_metadata.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:54
23 0320-jpatoscapolicytype_properties.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:55
24 0330-jpatoscapolicytype_targets.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:56
25 0340-jpatoscapolicytype_triggers.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:57
26 0350-jpatoscaproperty_constraints.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:58
27 0360-jpatoscaproperty_metadata.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:58
28 0370-jpatoscarelationshiptype_metadata.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:00:59
29 0380-jpatoscarelationshiptype_properties.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:01:00
30 0390-jpatoscarequirement_metadata.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:01:01
31 0400-jpatoscarequirement_occurrences.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:01:03
32 0410-jpatoscarequirement_properties.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:01:05
33 0420-jpatoscaservicetemplate_metadata.sql upgrade 0 0800 2104220300380800u 1 2022-04-21 03:01:06
34 0100-pdp.sql upgrade 0800 0900 2104220303320900u 0 2022-04-21 03:03:34
35 0100-pdp.sql upgrade 0800 0900 2104220304540900u 0 2022-04-21 03:04:55
policyadmin: OK @ 0900
+ exit 1