+ /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	1704220518530800u	1	2022-04-17 05:18:52
2	0110-jpapdpstatistics_enginestats.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:52
3	0120-jpapdpsubgroup_policies.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:52
4	0130-jpapdpsubgroup_properties.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:53
5	0140-jpapdpsubgroup_supportedpolicytypes.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:53
6	0150-jpatoscacapabilityassignment_attributes.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:53
7	0160-jpatoscacapabilityassignment_metadata.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:53
8	0170-jpatoscacapabilityassignment_occurrences.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:54
9	0180-jpatoscacapabilityassignment_properties.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:54
10	0190-jpatoscacapabilitytype_metadata.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:54
11	0200-jpatoscacapabilitytype_properties.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:54
12	0210-jpatoscadatatype_constraints.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:54
13	0220-jpatoscadatatype_metadata.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:55
14	0230-jpatoscadatatype_properties.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:56
15	0240-jpatoscanodetemplate_metadata.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:57
16	0250-jpatoscanodetemplate_properties.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:58
17	0260-jpatoscanodetype_metadata.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:58
18	0270-jpatoscanodetype_properties.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:59
19	0280-jpatoscapolicy_metadata.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:18:59
20	0290-jpatoscapolicy_properties.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:00
21	0300-jpatoscapolicy_targets.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:00
22	0310-jpatoscapolicytype_metadata.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:00
23	0320-jpatoscapolicytype_properties.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:01
24	0330-jpatoscapolicytype_targets.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:01
25	0340-jpatoscapolicytype_triggers.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:01
26	0350-jpatoscaproperty_constraints.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:02
27	0360-jpatoscaproperty_metadata.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:02
28	0370-jpatoscarelationshiptype_metadata.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:02
29	0380-jpatoscarelationshiptype_properties.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:03
30	0390-jpatoscarequirement_metadata.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:03
31	0400-jpatoscarequirement_occurrences.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:03
32	0410-jpatoscarequirement_properties.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:03
33	0420-jpatoscaservicetemplate_metadata.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:03
34	0430-jpatoscatopologytemplate_inputs.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:04
35	0440-pdpgroup_pdpsubgroup.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:04
36	0450-pdpgroup.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:04
37	0460-pdppolicystatus.sql	upgrade	0	0800	1704220518530800u	1	2022-04-17 05:19:04
38	0100-pdp.sql	upgrade	0800	0900	1704220522530900u	1	2022-04-17 05:22:55
39	0110-idx_tsidx1.sql	upgrade	0800	0900	1704220522530900u	0	2022-04-17 05:22:56
policyadmin: upgrade available: 0900 -> 1000
+ exit 1
