By type
+ /dbcmd-config/db_migrator_policy_init.sh
314 blocks
Preparing upgrade release version: 0800
Preparing upgrade release version: 0900
Preparing upgrade release version: 1000
Preparing upgrade release version: 1100
Preparing upgrade release version: 1200
Done
upgrade: 0 -> 1200
> upgrade 0100-jpapdpgroup_properties.sql
--------------
CREATE TABLE IF NOT EXISTS jpapdpgroup_properties (name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, PROPERTIES VARCHAR(255) DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) DEFAULT NULL)
--------------
> upgrade 0110-jpapdpstatistics_enginestats.sql
--------------
CREATE TABLE IF NOT EXISTS jpapdpstatistics_enginestats (AVERAGEEXECUTIONTIME DOUBLE DEFAULT NULL, ENGINEID VARCHAR(255) DEFAULT NULL, ENGINETIMESTAMP BIGINT DEFAULT NULL, ENGINEWORKERSTATE INT DEFAULT NULL, EVENTCOUNT BIGINT DEFAULT NULL, LASTENTERTIME BIGINT DEFAULT NULL, LASTEXECUTIONTIME BIGINT DEFAULT NULL, LASTSTART BIGINT DEFAULT NULL, UPTIME BIGINT DEFAULT NULL, timeStamp datetime DEFAULT NULL, name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL)
--------------
> upgrade 0120-jpapdpsubgroup_policies.sql
--------------
CREATE TABLE IF NOT EXISTS jpapdpsubgroup_policies (name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, parentLocalName VARCHAR(120) DEFAULT NULL, localName VARCHAR(120) DEFAULT NULL, parentKeyVersion VARCHAR(15) DEFAULT NULL, parentKeyName VARCHAR(120) DEFAULT NULL)
--------------
> upgrade 0130-jpapdpsubgroup_properties.sql
--------------
CREATE TABLE IF NOT EXISTS jpapdpsubgroup_properties (parentLocalName VARCHAR(120) DEFAULT NULL, localName VARCHAR(120) DEFAULT NULL, parentKeyVersion VARCHAR(15) DEFAULT NULL, parentKeyName VARCHAR(120) DEFAULT NULL, PROPERTIES VARCHAR(255) DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) DEFAULT NULL)
--------------
> upgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql
--------------
CREATE TABLE IF NOT EXISTS jpapdpsubgroup_supportedpolicytypes (name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, parentLocalName VARCHAR(120) DEFAULT NULL, localName VARCHAR(120) DEFAULT NULL, parentKeyVersion VARCHAR(15) DEFAULT NULL, parentKeyName VARCHAR(120) DEFAULT NULL)
--------------
> upgrade 0150-jpatoscacapabilityassignment_attributes.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_attributes (name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, ATTRIBUTES LONGTEXT DEFAULT NULL, ATTRIBUTES_KEY VARCHAR(255) DEFAULT NULL)
--------------
> upgrade 0160-jpatoscacapabilityassignment_metadata.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
--------------
> upgrade 0170-jpatoscacapabilityassignment_occurrences.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL)
--------------
> upgrade 0180-jpatoscacapabilityassignment_properties.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
--------------
> upgrade 0190-jpatoscacapabilitytype_metadata.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscacapabilitytype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
--------------
> upgrade 0200-jpatoscacapabilitytype_properties.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscacapabilitytype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
--------------
> upgrade 0210-jpatoscadatatype_constraints.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscadatatype_constraints (name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINTS VARCHAR(255) NULL)
--------------
> upgrade 0220-jpatoscadatatype_metadata.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscadatatype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
--------------
> upgrade 0230-jpatoscadatatype_properties.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscadatatype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
--------------
> upgrade 0240-jpatoscanodetemplate_metadata.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscanodetemplate_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
--------------
> upgrade 0250-jpatoscanodetemplate_properties.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscanodetemplate_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
--------------
> upgrade 0260-jpatoscanodetype_metadata.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscanodetype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
--------------
> upgrade 0270-jpatoscanodetype_properties.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscanodetype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
--------------
> upgrade 0280-jpatoscapolicy_metadata.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscapolicy_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
--------------
> upgrade 0290-jpatoscapolicy_properties.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscapolicy_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
--------------
> upgrade 0300-jpatoscapolicy_targets.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscapolicy_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL)
--------------
> upgrade 0310-jpatoscapolicytype_metadata.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscapolicytype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
--------------
> upgrade 0320-jpatoscapolicytype_properties.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscapolicytype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
--------------
> upgrade 0330-jpatoscapolicytype_targets.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscapolicytype_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL)
--------------
> upgrade 0340-jpatoscapolicytype_triggers.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscapolicytype_triggers (name VARCHAR(120) NULL, version VARCHAR(20) NULL, TRIGGERS VARCHAR(255) NULL)
--------------
> upgrade 0350-jpatoscaproperty_constraints.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscaproperty_constraints (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, CONSTRAINTS VARCHAR(255) NULL)
--------------
> upgrade 0360-jpatoscaproperty_metadata.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscaproperty_metadata (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
--------------
> upgrade 0370-jpatoscarelationshiptype_metadata.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
--------------
> upgrade 0380-jpatoscarelationshiptype_properties.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
--------------
> upgrade 0390-jpatoscarequirement_metadata.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscarequirement_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
--------------
> upgrade 0400-jpatoscarequirement_occurrences.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscarequirement_occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL)
--------------
> upgrade 0410-jpatoscarequirement_properties.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscarequirement_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
--------------
> upgrade 0420-jpatoscaservicetemplate_metadata.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscaservicetemplate_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
--------------
> upgrade 0430-jpatoscatopologytemplate_inputs.sql
--------------
CREATE TABLE IF NOT EXISTS jpatoscatopologytemplate_inputs (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, INPUTS LONGBLOB DEFAULT NULL, INPUTS_KEY VARCHAR(255) NULL)
--------------
> upgrade 0440-pdpgroup_pdpsubgroup.sql
--------------
CREATE TABLE IF NOT EXISTS pdpgroup_pdpsubgroup (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, PRIMARY KEY PK_PDPGROUP_PDPSUBGROUP (name, version, parentLocalName, localName, parentKeyVersion, parentKeyName))
--------------
> upgrade 0450-pdpgroup.sql
--------------
CREATE TABLE IF NOT EXISTS pdpgroup (`DESCRIPTION` VARCHAR(255) NULL, PDPGROUPSTATE INT DEFAULT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_PDPGROUP (name, version))
--------------
> upgrade 0460-pdppolicystatus.sql
--------------
CREATE TABLE IF NOT EXISTS pdppolicystatus (DEPLOY BOOLEAN DEFAULT 0, PDPGROUP VARCHAR(255) DEFAULT NULL, PDPTYPE VARCHAR(255) DEFAULT NULL, STATE INT DEFAULT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, PRIMARY KEY PK_PDPPOLICYSTATUS (parentLocalName, localName, parentKeyVersion, parentKeyName))
--------------
> upgrade 0470-pdp.sql
--------------
CREATE TABLE IF NOT EXISTS pdp (HEALTHY INT DEFAULT NULL, MESSAGE VARCHAR(255) DEFAULT NULL, PDPSTATE INT DEFAULT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, PRIMARY KEY PK_PDP (parentLocalName, localName, parentKeyVersion, parentKeyName))
--------------
ERROR 2002 (HY000): Can't connect to server on 'policy-mariadb' (115)
> upgrade 0480-pdpstatistics.sql
ERROR 2002 (HY000): Can't connect to server on 'policy-mariadb' (115)
ERROR 2002 (HY000): Can't connect to server on 'policy-mariadb' (115)
policyadmin: upgrade aborted at 0800 by script 0480-pdpstatistics.sql
policyadmin: failure: upgrade to release 1200 (0800)
name version
policyadmin 0800
ID script operation from_version to_version tag success atTime
1 0100-jpapdpgroup_properties.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:21
2 0110-jpapdpstatistics_enginestats.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:21
3 0120-jpapdpsubgroup_policies.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:21
4 0130-jpapdpsubgroup_properties.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:22
5 0140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:22
6 0150-jpatoscacapabilityassignment_attributes.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:22
7 0160-jpatoscacapabilityassignment_metadata.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:22
8 0170-jpatoscacapabilityassignment_occurrences.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:23
9 0180-jpatoscacapabilityassignment_properties.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:23
10 0190-jpatoscacapabilitytype_metadata.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:23
11 0200-jpatoscacapabilitytype_properties.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:23
12 0210-jpatoscadatatype_constraints.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:24
13 0220-jpatoscadatatype_metadata.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:24
14 0230-jpatoscadatatype_properties.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:24
15 0240-jpatoscanodetemplate_metadata.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:24
16 0250-jpatoscanodetemplate_properties.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:24
17 0260-jpatoscanodetype_metadata.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:25
18 0270-jpatoscanodetype_properties.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:25
19 0280-jpatoscapolicy_metadata.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:25
20 0290-jpatoscapolicy_properties.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:25
21 0300-jpatoscapolicy_targets.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:26
22 0310-jpatoscapolicytype_metadata.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:26
23 0320-jpatoscapolicytype_properties.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:26
24 0330-jpatoscapolicytype_targets.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:26
25 0340-jpatoscapolicytype_triggers.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:26
26 0350-jpatoscaproperty_constraints.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:27
27 0360-jpatoscaproperty_metadata.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:27
28 0370-jpatoscarelationshiptype_metadata.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:27
29 0380-jpatoscarelationshiptype_properties.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:28
30 0390-jpatoscarequirement_metadata.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:29
31 0400-jpatoscarequirement_occurrences.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:29
32 0410-jpatoscarequirement_properties.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:30
33 0420-jpatoscaservicetemplate_metadata.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:30
34 0430-jpatoscatopologytemplate_inputs.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:31
35 0440-pdpgroup_pdpsubgroup.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:31
36 0450-pdpgroup.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:31
37 0460-pdppolicystatus.sql upgrade 0 0800 2204230307200800u 1 2023-04-22 03:07:32
policyadmin: upgrade available: 0800 -> 1200