· 10 years ago · Nov 29, 2015, 03:42 PM
1--- maven-failsafe-plugin:2.19:integration-test (default) @ dsas-uncy-reader ---
2
3-------------------------------------------------------
4 T E S T S
5-------------------------------------------------------
611-29 09:38:16 jdbc[3]:
7/*SQL */SET TRACE_LEVEL_FILE 2;
82015-11-29 09:38:16 jdbc:
9/**/Connection conn0 = DriverManager.getConnection("jdbc:h2:tcp://localhost:53344/mem:xploder;create=false;TRACE_LEVEL_FILE=2;TRACE_LEVEL_SYSTEM_OUT=2", "TEST", "");
1011-29 09:38:17 jdbc[3]:
11/*SQL #:1 t:2*/CALL DATABASE();
1211-29 09:38:17 jdbc[3]:
13/*SQL */ROLLBACK;
142015-11-29 09:38:21 jdbc: exception
1511-29 09:38:21 jdbc[3]:
16/*SQL t:1*/CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
1711-29 09:38:21 jdbc[3]:
18/*SQL */COMMIT;
1911-29 09:38:21 jdbc[3]:
20/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
2111-29 09:38:21 jdbc[3]:
22/*SQL */DELETE FROM PUBLIC.DATABASECHANGELOGLOCK;
2311-29 09:38:21 jdbc[3]:
24/*SQL #:1*/INSERT INTO PUBLIC.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);
2511-29 09:38:21 jdbc[3]:
26/*SQL */COMMIT;
2711-29 09:38:21 jdbc[3]:
28/*SQL #:1 t:1*/SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1;
2911-29 09:38:21 jdbc[3]:
30/*SQL #:1 t:1*/UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = '192.168.99.1 (192.168.99.1)', LOCKGRANTED = '2015-11-29 09:38:21.600' WHERE ID = 1 AND LOCKED = FALSE;
3111-29 09:38:21 jdbc[3]:
32/*SQL */COMMIT;
33INFO 11/29/15 9:38 AM: liquibase: Successfully acquired change log lock
3411-29 09:38:21 jdbc[3]:
35/*SQL */ROLLBACK;
36INFO 11/29/15 9:38 AM: liquibase: Dropping Database Objects in schema: XPLODER.PUBLIC
3711-29 09:38:21 jdbc[3]:
38/*SQL l:410*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOG', 6: '\\', 7: 'TABLE'};
39INFO 11/29/15 9:38 AM: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
4011-29 09:38:21 jdbc[3]:
41/*SQL */CREATE TABLE PUBLIC.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255));
4211-29 09:38:21 jdbc[3]:
43/*SQL */COMMIT;
4411-29 09:38:21 jdbc[3]:
45/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
4611-29 09:38:21 jdbc[3]:
47/*SQL #:1*/SELECT CATALOG_NAME TABLE_CAT FROM INFORMATION_SCHEMA.CATALOGS;
4811-29 09:38:21 jdbc[3]:
49/*SQL #:2 t:1*/SELECT SCHEMA_NAME TABLE_SCHEM, CATALOG_NAME TABLE_CATALOG, IS_DEFAULT FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
5011-29 09:38:21 jdbc[3]:
51/*SQL l:410 t:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: '%', 6: '\\', 7: 'VIEW'};
5211-29 09:38:21 jdbc[3]:
53/*SQL l:410 #:2 t:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: '%', 6: '\\', 7: 'TABLE'};
5411-29 09:38:21 jdbc[3]:
55/*SQL */SELECT SEQUENCE_NAME FROM INFORMATION_SCHEMA.SEQUENCES WHERE SEQUENCE_SCHEMA = 'PUBLIC' AND IS_GENERATED=FALSE;
5611-29 09:38:21 jdbc[3]:
57/*SQL l:410 #:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOG', 6: '\\', 7: 'TABLE'};
5811-29 09:38:21 jdbc[3]:
59/*SQL l:482*/SELECT PKTABLE_CATALOG PKTABLE_CAT, PKTABLE_SCHEMA PKTABLE_SCHEM, PKTABLE_NAME PKTABLE_NAME, PKCOLUMN_NAME, FKTABLE_CATALOG FKTABLE_CAT, FKTABLE_SCHEMA FKTABLE_SCHEM, FKTABLE_NAME, FKCOLUMN_NAME, ORDINAL_POSITION KEY_SEQ, UPDATE_RULE, DELETE_RULE, FK_NAME, PK_NAME, DEFERRABILITY FROM INFORMATION_SCHEMA.CROSS_REFERENCES WHERE FKTABLE_CATALOG LIKE ? ESCAPE ? AND FKTABLE_SCHEMA LIKE ? ESCAPE ? AND FKTABLE_NAME = ? ORDER BY PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, FK_NAME, KEY_SEQ {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOG'};
6011-29 09:38:21 jdbc[3]:
61/*SQL l:959 #:13 t:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATALOG, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_SCHEMA, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_TABLE, SOURCE_DATA_TYPE, CASE WHEN SEQUENCE_NAME IS NULL THEN CAST(? AS VARCHAR) ELSE CAST(? AS VARCHAR) END IS_AUTOINCREMENT, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATLOG FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND COLUMN_NAME LIKE ? ESCAPE ? ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION {1: 'NO', 2: 'YES', 3: 'XPLODER', 4: '\\', 5: 'PUBLIC', 6: '\\', 7: 'DATABASECHANGELOG', 8: '\\', 9: '%', 10: '\\'};
6211-29 09:38:21 jdbc[3]:
63/*SQL l:410 #:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOGLOCK', 6: '\\', 7: 'TABLE'};
6411-29 09:38:21 jdbc[3]:
65/*SQL l:482*/SELECT PKTABLE_CATALOG PKTABLE_CAT, PKTABLE_SCHEMA PKTABLE_SCHEM, PKTABLE_NAME PKTABLE_NAME, PKCOLUMN_NAME, FKTABLE_CATALOG FKTABLE_CAT, FKTABLE_SCHEMA FKTABLE_SCHEM, FKTABLE_NAME, FKCOLUMN_NAME, ORDINAL_POSITION KEY_SEQ, UPDATE_RULE, DELETE_RULE, FK_NAME, PK_NAME, DEFERRABILITY FROM INFORMATION_SCHEMA.CROSS_REFERENCES WHERE FKTABLE_CATALOG LIKE ? ESCAPE ? AND FKTABLE_SCHEMA LIKE ? ESCAPE ? AND FKTABLE_NAME = ? ORDER BY PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, FK_NAME, KEY_SEQ {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOGLOCK'};
6611-29 09:38:21 jdbc[3]:
67/*SQL l:959 #:4*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATALOG, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_SCHEMA, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_TABLE, SOURCE_DATA_TYPE, CASE WHEN SEQUENCE_NAME IS NULL THEN CAST(? AS VARCHAR) ELSE CAST(? AS VARCHAR) END IS_AUTOINCREMENT, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATLOG FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND COLUMN_NAME LIKE ? ESCAPE ? ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION {1: 'NO', 2: 'YES', 3: 'XPLODER', 4: '\\', 5: 'PUBLIC', 6: '\\', 7: 'DATABASECHANGELOGLOCK', 8: '\\', 9: '%', 10: '\\'};
6811-29 09:38:21 jdbc[3]:
69/*SQL */COMMIT;
7011-29 09:38:21 jdbc[3]:
71/*SQL #:1*/select count(*) from \"PUBLIC\".\"DATABASECHANGELOG\";
7211-29 09:38:21 jdbc[3]:
73/*SQL t:1*/DROP TABLE \"PUBLIC\".\"DATABASECHANGELOG\";
7411-29 09:38:21 jdbc[3]:
75/*SQL #:1*/select count(*) from \"PUBLIC\".\"DATABASECHANGELOGLOCK\";
7611-29 09:38:21 jdbc[3]:
77/*SQL */DROP TABLE \"PUBLIC\".\"DATABASECHANGELOGLOCK\";
7811-29 09:38:21 jdbc[3]:
79/*SQL */COMMIT;
802015-11-29 09:38:21 jdbc: exception
8111-29 09:38:21 jdbc[3]:
82/*SQL */ROLLBACK;
832015-11-29 09:38:21 jdbc: exception
8411-29 09:38:21 jdbc[3]:
85/*SQL */COMMIT;
862015-11-29 09:38:21 jdbc: exception
8711-29 09:38:21 jdbc[3]:
88/*SQL */COMMIT;
8911-29 09:38:21 jdbc[3]:
90/*SQL t:1*/COMMIT;
91INFO 11/29/15 9:38 AM: liquibase: Successfully acquired change log lock
9211-29 09:38:21 jdbc[3]:
93/*SQL */ROLLBACK;
9411-29 09:38:22 jdbc[3]:
95/*SQL l:410*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOG', 6: '\\', 7: 'TABLE'};
96INFO 11/29/15 9:38 AM: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
9711-29 09:38:22 jdbc[3]:
98/*SQL */COMMIT;
992015-11-29 09:38:22 jdbc: exception
10011-29 09:38:22 jdbc[3]:
101/*SQL */COMMIT;
1022015-11-29 09:38:22 jdbc: exception
10311-29 09:38:22 jdbc[3]:
104/*SQL */ROLLBACK;
10511-29 09:38:22 jdbc[3]:
106/*SQL */ROLLBACK;
107INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin: Tag 'pre-points-table-created' applied to database
10811-29 09:38:22 jdbc[3]:
109/*SQL t:1*/COMMIT;
110INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin: ChangeSet src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin ran successfully in 1ms
1112015-11-29 09:38:22 jdbc: exception
11211-29 09:38:22 jdbc[3]:
113/*SQL */COMMIT;
11411-29 09:38:22 jdbc[3]:
115/*SQL */COMMIT;
11611-29 09:38:22 jdbc[3]:
117/*SQL */ROLLBACK;
118INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): Table POINTS created
119INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): Index idx_ID created
12011-29 09:38:22 jdbc[3]:
121/*SQL */COMMIT;
122INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): ChangeSet src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov) ran successfully in 2ms
12311-29 09:38:22 jdbc[3]:
124/*SQL */COMMIT;
12511-29 09:38:22 jdbc[3]:
126/*SQL */COMMIT;
12711-29 09:38:22 jdbc[3]:
128/*SQL */ROLLBACK;
129INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin: Tag 'post-points-table-created' applied to database
13011-29 09:38:22 jdbc[3]:
131/*SQL */COMMIT;
132INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin: ChangeSet src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin ran successfully in 0ms
13311-29 09:38:22 jdbc[3]:
134/*SQL */COMMIT;
13511-29 09:38:22 jdbc[3]:
136/*SQL */COMMIT;
13711-29 09:38:22 jdbc[3]:
138/*SQL */ROLLBACK;
13911-29 09:38:22 jdbc[3]:
140/*SQL */COMMIT;
141INFO 11/29/15 9:38 AM: liquibase: Successfully released change log lock
14211-29 09:38:22 jdbc[3]:
143/*SQL */ROLLBACK;
144-- *********************************************************************
145-- Update Database Script
146-- *********************************************************************
147-- Change Log: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml
148-- Ran at: 11/29/15 9:38 AM
149-- Against: TEST@jdbc:h2:tcp://localhost:53344/mem:xploder
150-- Liquibase version: 3.4.2
151-- *********************************************************************
152
153-- Create Database Lock Table
154CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
155
156-- Initialize Database Lock Table
157DELETE FROM PUBLIC.DATABASECHANGELOGLOCK;
158
159INSERT INTO PUBLIC.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);
160
161-- Lock Database
162UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = '192.168.99.1 (192.168.99.1)', LOCKGRANTED = '2015-11-29 09:38:21.674' WHERE ID = 1 AND LOCKED = FALSE;
163
164-- Create Database Change Log Table
165CREATE TABLE PUBLIC.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255));
166
167-- Changeset src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin
168INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, TAG) VALUES ('tag-integration-test-database-before-creation', 'Ivan Suftin', 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml', NOW(), 1, '7:895e9d9e7c30a2094c0e607ef02b8de1', 'tagDatabase', '', 'EXECUTED', 'integration-test', NULL, '3.4.2', 'pre-points-table-created');
169
170-- Changeset src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov)
171CREATE TABLE PUBLIC.POINTS (ID BIGINT AUTO_INCREMENT NOT NULL, SHORELINE_ID BIGINT NOT NULL, SEGMENT_ID BIGINT NOT NULL, GEOM GEOMETRY NOT NULL, UNCY DOUBLE NOT NULL, CONSTRAINT pk_ID PRIMARY KEY (ID));
172
173CREATE UNIQUE INDEX PUBLIC.idx_ID ON PUBLIC.POINTS(id);
174
175INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('create-shoreline-points-table', 'Ivan Suftin (isuftin@usgs.gov)', 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml', NOW(), 2, '7:b0f510d94f8729fc5891a3604357fb3d', 'createTable, createIndex', '', 'EXECUTED', 'update,integration-test', NULL, '3.4.2');
176
177-- Changeset src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin
178INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, TAG) VALUES ('tag-integration-test-database-after-creation', 'Ivan Suftin', 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml', NOW(), 3, '7:3eed4ea632e44959f747908dce40aed8', 'tagDatabase', '', 'EXECUTED', 'integration-test', NULL, '3.4.2', 'post-points-table-created');
179
180-- Release Database Lock
181UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
182
18311-29 09:38:22 jdbc[3]:
184/*SQL */ROLLBACK;
185Running gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest
1862015-11-29 09:38:22 jdbc: exception
18711-29 09:38:22 jdbc[3]:
188/*SQL t:1*/CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
18911-29 09:38:22 jdbc[3]:
190/*SQL */COMMIT;
19111-29 09:38:22 jdbc[3]:
192/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
19311-29 09:38:22 jdbc[3]:
194/*SQL */DELETE FROM PUBLIC.DATABASECHANGELOGLOCK;
19511-29 09:38:22 jdbc[3]:
196/*SQL #:1*/INSERT INTO PUBLIC.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);
19711-29 09:38:22 jdbc[3]:
198/*SQL */COMMIT;
19911-29 09:38:22 jdbc[3]:
200/*SQL #:1*/SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1;
20111-29 09:38:22 jdbc[3]:
202/*SQL #:1*/UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = '192.168.99.1 (192.168.99.1)', LOCKGRANTED = '2015-11-29 09:38:22.270' WHERE ID = 1 AND LOCKED = FALSE;
20311-29 09:38:22 jdbc[3]:
204/*SQL */COMMIT;
205INFO 11/29/15 9:38 AM: liquibase: Successfully acquired change log lock
20611-29 09:38:22 jdbc[3]:
207/*SQL */ROLLBACK;
20811-29 09:38:22 jdbc[3]:
209/*SQL l:410*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOG', 6: '\\', 7: 'TABLE'};
210INFO 11/29/15 9:38 AM: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
21111-29 09:38:22 jdbc[3]:
212/*SQL */CREATE TABLE PUBLIC.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255));
21311-29 09:38:22 jdbc[3]:
214/*SQL */COMMIT;
21511-29 09:38:22 jdbc[3]:
216/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOG;
217INFO 11/29/15 9:38 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
21811-29 09:38:22 jdbc[3]:
219/*SQL */SELECT * FROM PUBLIC.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
22011-29 09:38:22 jdbc[3]:
221/*SQL */COMMIT;
22211-29 09:38:22 jdbc[3]:
223/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
22411-29 09:38:22 jdbc[3]:
225/*SQL */ROLLBACK;
22611-29 09:38:22 jdbc[3]:
227/*SQL */ROLLBACK;
228INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin: Tag 'pre-points-table-created' applied to database
22911-29 09:38:22 jdbc[3]:
230/*SQL */COMMIT;
231INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin: ChangeSet src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin ran successfully in 0ms
23211-29 09:38:22 jdbc[3]:
233/*SQL #:1 t:1*/SELECT MAX(ORDEREXECUTED) FROM PUBLIC.DATABASECHANGELOG;
23411-29 09:38:22 jdbc[3]:
235/*SQL #:1*/INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, TAG) VALUES ('tag-integration-test-database-before-creation', 'Ivan Suftin', 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml', NOW(), 1, '7:895e9d9e7c30a2094c0e607ef02b8de1', 'tagDatabase', '', 'EXECUTED', 'integration-test', NULL, '3.4.2', 'pre-points-table-created');
23611-29 09:38:22 jdbc[3]:
237/*SQL */COMMIT;
23811-29 09:38:22 jdbc[3]:
239/*SQL */COMMIT;
24011-29 09:38:22 jdbc[3]:
241/*SQL */ROLLBACK;
24211-29 09:38:22 jdbc[3]:
243/*SQL t:3*/CREATE TABLE PUBLIC.POINTS (ID BIGINT AUTO_INCREMENT NOT NULL, SHORELINE_ID BIGINT NOT NULL, SEGMENT_ID BIGINT NOT NULL, GEOM GEOMETRY NOT NULL, UNCY DOUBLE NOT NULL, CONSTRAINT pk_ID PRIMARY KEY (ID));
244INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): Table POINTS created
24511-29 09:38:22 jdbc[3]:
246/*SQL t:2*/CREATE UNIQUE INDEX PUBLIC.idx_ID ON PUBLIC.POINTS(id);
24711-29 09:38:22 jdbc[3]:
248/*SQL */COMMIT;INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): Index idx_ID created
249
250INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): ChangeSet src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov) ran successfully in 8ms
25111-29 09:38:22 jdbc[3]:
252/*SQL #:1 t:1*/INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('create-shoreline-points-table', 'Ivan Suftin (isuftin@usgs.gov)', 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml', NOW(), 2, '7:b0f510d94f8729fc5891a3604357fb3d', 'createTable, createIndex', '', 'EXECUTED', 'update,integration-test', NULL, '3.4.2');
25311-29 09:38:22 jdbc[3]:
254/*SQL */COMMIT;
25511-29 09:38:22 jdbc[3]:
256/*SQL */COMMIT;
25711-29 09:38:22 jdbc[3]:
258/*SQL */ROLLBACK;
259INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin: Tag 'post-points-table-created' applied to database
26011-29 09:38:22 jdbc[3]:
261/*SQL */COMMIT;
262INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin: ChangeSet src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin ran successfully in 0ms
26311-29 09:38:22 jdbc[3]:
264/*SQL #:1 t:1*/INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, TAG) VALUES ('tag-integration-test-database-after-creation', 'Ivan Suftin', 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml', NOW(), 3, '7:3eed4ea632e44959f747908dce40aed8', 'tagDatabase', '', 'EXECUTED', 'integration-test', NULL, '3.4.2', 'post-points-table-created');
26511-29 09:38:22 jdbc[3]:
266/*SQL */COMMIT;
26711-29 09:38:22 jdbc[3]:
268/*SQL */COMMIT;
26911-29 09:38:22 jdbc[3]:
270/*SQL */ROLLBACK;
27111-29 09:38:22 jdbc[3]:
272/*SQL #:1*/UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
27311-29 09:38:22 jdbc[3]:
274/*SQL */COMMIT;
275INFO 11/29/15 9:38 AM: liquibase: Successfully released change log lock
27611-29 09:38:22 jdbc[3]:
277/*SQL */ROLLBACK;
27809:38:22.362 [main] INFO g.u.c.d.u.H2DBOutputExploderIntegrationTest - testCreateXploder()
27909:38:23.114 [main] DEBUG gov.usgs.cida.dsas.uncy.Xploder - Reading source schema from /var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448811502260/test_shorelines.shp
28009:38:23.290 [main] DEBUG gov.usgs.cida.dsas.uncy.Xploder - Source schema is SimpleFeatureTypeImpl test_shorelines identified extends lineFeature(the_geom:MultiLineString,descriptio:descriptio,name:name,DATE_:DATE_,ACCURACY:ACCURACY)
28111-29 09:38:23 database: connecting session #4 to mem:xploder
28211-29 09:38:23 jdbc[4]:
283/*SQL t:1*/ROLLBACK;
28411-29 09:38:23 database: disconnecting session #4
28511-29 09:38:23 database: disconnected session #4
28611-29 09:38:23 database: connecting session #5 to mem:xploder
28711-29 09:38:23 jdbc[5]:
288/*SQL t:1*/CREATE DOMAIN POINT AS BLOB;
28911-29 09:38:23 jdbc[5]:
290/*SQL t:1*/CREATE DOMAIN LINESTRING AS BLOB;
29111-29 09:38:23 jdbc[5]:
292/*SQL */CREATE DOMAIN POLYGON AS BLOB;
29311-29 09:38:23 jdbc[5]:
294/*SQL */CREATE DOMAIN MULTIPOINT AS BLOB;
29511-29 09:38:23 jdbc[5]:
296/*SQL */CREATE DOMAIN MULTILINESTRING AS BLOB;
29711-29 09:38:23 jdbc[5]:
298/*SQL */CREATE DOMAIN MULTIPOLYGON AS BLOB;
29911-29 09:38:23 jdbc[5]:
300/*SQL */CREATE DOMAIN GEOMETRYCOLLECTION AS BLOB;
30111-29 09:38:23 jdbc[5]:
302/*SQL */CREATE TABLE IF NOT EXISTS _GEODB (checksum VARCHAR);
30311-29 09:38:23 jdbc[5]:
304/*SQL */DELETE FROM _GEODB;
30511-29 09:38:23 jdbc[5]:
306/*SQL #:1*/INSERT INTO _GEODB VALUES (9);
30711-29 09:38:23 jdbc[5]:
308/*SQL */CREATE TABLE IF NOT EXISTS geometry_columns (f_table_schema VARCHAR, f_table_name VARCHAR, f_geometry_column VARCHAR, coord_dimension INT, srid INT, type VARCHAR(30));
30911-29 09:38:23 jdbc[5]:
310/*SQL #:4*/SELECT TYPE TABLE_TYPE FROM INFORMATION_SCHEMA.TABLE_TYPES ORDER BY TABLE_TYPE;
31111-29 09:38:23 jdbc[5]:
312/*SQL l:413 #:5 t:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?, ?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: '%', 2: '\\', 3: '%', 4: '\\', 5: '%', 6: '\\', 7: 'TABLE', 8: 'VIEW'};
31311-29 09:38:23 jdbc[5]:
314/*SQL #:1 t:1*/SELECT checksum FROM _GEODB;
31511-29 09:38:23 jdbc[5]:
316/*SQL l:316 #:1 t:2*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION KEY_SEQ, IFNULL(CONSTRAINT_NAME, INDEX_NAME) PK_NAME FROM INFORMATION_SCHEMA.INDEXES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME = ? AND PRIMARY_KEY = TRUE ORDER BY COLUMN_NAME {1: '%', 2: '\\', 3: '%', 4: '\\', 5: 'POINTS'};
31711-29 09:38:23 jdbc[5]:
318/*SQL l:959 #:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATALOG, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_SCHEMA, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_TABLE, SOURCE_DATA_TYPE, CASE WHEN SEQUENCE_NAME IS NULL THEN CAST(? AS VARCHAR) ELSE CAST(? AS VARCHAR) END IS_AUTOINCREMENT, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATLOG FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND COLUMN_NAME LIKE ? ESCAPE ? ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION {1: 'NO', 2: 'YES', 3: '%', 4: '\\', 5: '%', 6: '\\', 7: 'POINTS', 8: '\\', 9: 'ID', 10: '\\'};
31911-29 09:38:23 jdbc[5]:
320/*SQL */SELECT \"ID\" FROM \"POINTS\" WHERE 0=1;
32111-29 09:38:23 jdbc[5]:
322/*SQL #:1*/CALL DATABASE();
32311-29 09:38:23 jdbc[5]:
324/*SQL #:1*/SELECT checksum FROM _GEODB;
32511-29 09:38:23 jdbc[5]:
326/*SQL l:959 #:5*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATALOG, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_SCHEMA, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_TABLE, SOURCE_DATA_TYPE, CASE WHEN SEQUENCE_NAME IS NULL THEN CAST(? AS VARCHAR) ELSE CAST(? AS VARCHAR) END IS_AUTOINCREMENT, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATLOG FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND COLUMN_NAME LIKE ? ESCAPE ? ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION {1: 'NO', 2: 'YES', 3: 'XPLODER', 4: '\\', 5: '%', 6: '\\', 7: 'POINTS', 8: '\\', 9: '%', 10: '\\'};
3272015-11-29T09:38:23.401-0600 WARNING Could not find mapping for 'GEOM', ignoring the column and setting the feature type read only
32811-29 09:38:23 jdbc[3]:
329/*SQL */ROLLBACK;
33011-29 09:38:23 jdbc[3]:
331/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
33211-29 09:38:23 jdbc[3]:
333/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
33411-29 09:38:23 jdbc[3]:
335/*SQL */COMMIT;
336INFO 11/29/15 9:38 AM: liquibase: Successfully acquired change log lock
33711-29 09:38:23 jdbc[3]:
338/*SQL */ROLLBACK;
33911-29 09:38:23 jdbc[3]:
340/*SQL l:410 #:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOG', 6: '\\', 7: 'TABLE'};
34111-29 09:38:23 jdbc[3]:
342/*SQL l:959 #:13*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATALOG, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_SCHEMA, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_TABLE, SOURCE_DATA_TYPE, CASE WHEN SEQUENCE_NAME IS NULL THEN CAST(? AS VARCHAR) ELSE CAST(? AS VARCHAR) END IS_AUTOINCREMENT, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATLOG FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND COLUMN_NAME LIKE ? ESCAPE ? ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION {1: 'NO', 2: 'YES', 3: 'XPLODER', 4: '\\', 5: 'PUBLIC', 6: '\\', 7: 'DATABASECHANGELOG', 8: '\\', 9: '%', 10: '\\'};
34311-29 09:38:23 jdbc[3]:
344/*SQL #:3*/SELECT MD5SUM FROM PUBLIC.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL;
34511-29 09:38:23 jdbc[3]:
346/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOG;
347INFO 11/29/15 9:38 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
34811-29 09:38:23 jdbc[3]:
349/*SQL #:3*/SELECT * FROM PUBLIC.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
35011-29 09:38:23 jdbc[3]:
351/*SQL */ROLLBACK;
352INFO 11/29/15 9:38 AM: liquibase: null: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin: Rolling Back Changeset:src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin
35311-29 09:38:23 jdbc[3]:
354/*SQL */COMMIT;
35511-29 09:38:23 jdbc[3]:
356/*SQL */COMMIT;
35711-29 09:38:23 jdbc[3]:
358/*SQL */COMMIT;
359INFO 11/29/15 9:38 AM: liquibase: null: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): Rolling Back Changeset:src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov)
36011-29 09:38:23 jdbc[3]:
361/*SQL */COMMIT;
36211-29 09:38:23 jdbc[3]:
363/*SQL */COMMIT;
36411-29 09:38:23 jdbc[3]:
365/*SQL */COMMIT;
36611-29 09:38:23 jdbc[3]:
367/*SQL */ROLLBACK;
36811-29 09:38:23 jdbc[3]:
369/*SQL */COMMIT;
370INFO 11/29/15 9:38 AM: liquibase: Successfully released change log lock
37111-29 09:38:23 jdbc[3]:
372/*SQL */ROLLBACK;
373-- *********************************************************************
374-- Rollback to 'pre-points-table-created' Script
375-- *********************************************************************
376-- Change Log: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml
377-- Ran at: 11/29/15 9:38 AM
378-- Against: TEST@jdbc:h2:tcp://localhost:53344/mem:xploder
379-- Liquibase version: 3.4.2
380-- *********************************************************************
381
382-- Lock Database
383UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = '192.168.99.1 (192.168.99.1)', LOCKGRANTED = '2015-11-29 09:38:23.404' WHERE ID = 1 AND LOCKED = FALSE;
384
385-- Rolling Back ChangeSet: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin
386DELETE FROM PUBLIC.DATABASECHANGELOG WHERE ID = 'tag-integration-test-database-after-creation' AND AUTHOR = 'Ivan Suftin' AND FILENAME = 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml';
387
388-- Rolling Back ChangeSet: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov)
389DELETE FROM PUBLIC.POINTS;
390
391DELETE FROM PUBLIC.DATABASECHANGELOG WHERE ID = 'create-shoreline-points-table' AND AUTHOR = 'Ivan Suftin (isuftin@usgs.gov)' AND FILENAME = 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml';
392
393-- Release Database Lock
394UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
395
39611-29 09:38:23 jdbc[3]:
397/*SQL */ROLLBACK;
39811-29 09:38:23 database: disconnecting session #3
39911-29 09:38:23 database: disconnected session #3
400Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 1.229 sec <<< FAILURE! - in gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest
401testCreateXploder(gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest) Time elapsed: 1.227 sec <<< ERROR!
402java.io.IOException: POINTS is read only
403 at gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest.testCreateXploder(H2DBOutputExploderIntegrationTest.java:127)
404
40511-29 09:38:23 jdbc[5]:
406/*SQL */ROLLBACK;
40711-29 09:38:23 database: disconnecting session #5
40811-29 09:38:23 database: closing mem:xploder
40911-29 09:38:23 database: closed
41011-29 09:38:23 database: disconnected session #5
411
412Results :
413
414Tests in error:
415 H2DBOutputExploderIntegrationTest.testCreateXploder:127 » IO POINTS is read on...
416
417Tests run: 1, Failures: 0, Errors: 1, Skipped: 0