INFO 2016.09.29. 16:01: liquibase: Could not set check compatibility mode on OracleDatabase, assuming not running in any sort of compatibility mode: Cannot read from v$parameter: ORA-00942: table or view does not exist DEBUG 2016.09.29. 16:01: liquibase: Connected to LB_SOLO@jdbc:oracle:thin:@192.168.64.5:49161:XE DEBUG 2016.09.29. 16:01: liquibase: Setting auto commit to false from true DEBUG 2016.09.29. 16:01: liquibase: Executing QUERY database command: select count(*) from LB_SOLO.DATABASECHANGELOGLOCK DEBUG 2016.09.29. 16:01: liquibase: Create Database Lock Table DEBUG 2016.09.29. 16:01: liquibase: Executing EXECUTE database command: CREATE TABLE LB_SOLO.DATABASECHANGELOGLOCK (ID INTEGER NOT NULL, LOCKED NUMBER(1) NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR2(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)) DEBUG 2016.09.29. 16:01: liquibase: Created database lock table with name: LB_SOLO.DATABASECHANGELOGLOCK DEBUG 2016.09.29. 16:01: liquibase: Executing QUERY database command: select count(*) from LB_SOLO.DATABASECHANGELOGLOCK DEBUG 2016.09.29. 16:01: liquibase: Initialize Database Lock Table DEBUG 2016.09.29. 16:01: liquibase: Executing EXECUTE database command: DELETE FROM LB_SOLO.DATABASECHANGELOGLOCK DEBUG 2016.09.29. 16:01: liquibase: Executing EXECUTE database command: INSERT INTO LB_SOLO.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, 0) DEBUG 2016.09.29. 16:01: liquibase: Executing QUERY database command: SELECT LOCKED FROM LB_SOLO.DATABASECHANGELOGLOCK WHERE ID=1 FOR UPDATE DEBUG 2016.09.29. 16:01: liquibase: Lock Database DEBUG 2016.09.29. 16:01: liquibase: Executing UPDATE database command: UPDATE LB_SOLO.DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '10.2.2.179 (10.2.2.179)', LOCKGRANTED = to_timestamp('2016-09-29 16:01:48.093', 'YYYY-MM-DD HH24:MI:SS.FF') WHERE ID = 1 AND LOCKED = 0 INFO 2016.09.29. 16:01: liquibase: Successfully acquired change log lock DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: includeAll for install/tab/ DEBUG 2016.09.29. 16:01: liquibase: Using file opener for includeAll: liquibase.resource.CompositeResourceAccessor(liquibase.resource.FileSystemResourceAccessor(/Users/test/liquibase/project/TEST/.),liquibase.integration.commandline.CommandLineResourceAccessor(file:/Oracle/Middleware/Oracle_Home/oracle_common/rda/da/lib/ojdbc14.jar)) DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: includeAll for install/seq/ DEBUG 2016.09.29. 16:01: liquibase: Using file opener for includeAll: liquibase.resource.CompositeResourceAccessor(liquibase.resource.FileSystemResourceAccessor(/Users/test/liquibase/project/TEST/.),liquibase.integration.commandline.CommandLineResourceAccessor(file:/Oracle/Middleware/Oracle_Home/oracle_common/rda/da/lib/ojdbc14.jar)) DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: includeAll for install/cst/ DEBUG 2016.09.29. 16:01: liquibase: Using file opener for includeAll: liquibase.resource.CompositeResourceAccessor(liquibase.resource.FileSystemResourceAccessor(/Users/test/liquibase/project/TEST/.),liquibase.integration.commandline.CommandLineResourceAccessor(file:/Oracle/Middleware/Oracle_Home/oracle_common/rda/da/lib/ojdbc14.jar)) DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: includeAll for latest/pks/ DEBUG 2016.09.29. 16:01: liquibase: Using file opener for includeAll: liquibase.resource.CompositeResourceAccessor(liquibase.resource.FileSystemResourceAccessor(/Users/test/liquibase/project/TEST/.),liquibase.integration.commandline.CommandLineResourceAccessor(file:/Oracle/Middleware/Oracle_Home/oracle_common/rda/da/lib/ojdbc14.jar)) DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: includeAll for latest/vw/ DEBUG 2016.09.29. 16:01: liquibase: Using file opener for includeAll: liquibase.resource.CompositeResourceAccessor(liquibase.resource.FileSystemResourceAccessor(/Users/test/liquibase/project/TEST/.),liquibase.integration.commandline.CommandLineResourceAccessor(file:/Oracle/Middleware/Oracle_Home/oracle_common/rda/da/lib/ojdbc14.jar)) DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: includeAll for latest/pkb/ DEBUG 2016.09.29. 16:01: liquibase: Using file opener for includeAll: liquibase.resource.CompositeResourceAccessor(liquibase.resource.FileSystemResourceAccessor(/Users/test/liquibase/project/TEST/.),liquibase.integration.commandline.CommandLineResourceAccessor(file:/Oracle/Middleware/Oracle_Home/oracle_common/rda/da/lib/ojdbc14.jar)) DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: includeAll for latest/trg/ DEBUG 2016.09.29. 16:01: liquibase: Using file opener for includeAll: liquibase.resource.CompositeResourceAccessor(liquibase.resource.FileSystemResourceAccessor(/Users/test/liquibase/project/TEST/.),liquibase.integration.commandline.CommandLineResourceAccessor(file:/Oracle/Middleware/Oracle_Home/oracle_common/rda/da/lib/ojdbc14.jar)) DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd' DEBUG 2016.09.29. 16:01: liquibase: Opening jar:file:/Users/test/liquibase/Users/test/liquibase-3.5.2/Users/test/liquibase.jar!/Users/test/liquibase/parser/core/xml/dbchangelog-1.9.xsd as liquibase/parser/core/xml/dbchangelog-1.9.xsd DEBUG 2016.09.29. 16:01: liquibase: Computed checksum for 1475157708746 as 2e5103ea70b79b024122d39cd9348b6a DEBUG 2016.09.29. 16:01: liquibase: Create Database Change Log Table INFO 2016.09.29. 16:01: liquibase: Creating database history table with name: LB_SOLO.DATABASECHANGELOG DEBUG 2016.09.29. 16:01: liquibase: Executing EXECUTE database command: CREATE TABLE LB_SOLO.DATABASECHANGELOG (ID VARCHAR2(255) NOT NULL, AUTHOR VARCHAR2(255) NOT NULL, FILENAME VARCHAR2(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INTEGER NOT NULL, EXECTYPE VARCHAR2(10) NOT NULL, MD5SUM VARCHAR2(35), DESCRIPTION VARCHAR2(255), COMMENTS VARCHAR2(255), TAG VARCHAR2(255), LIQUIBASE VARCHAR2(20), CONTEXTS VARCHAR2(255), LABELS VARCHAR2(255), DEPLOYMENT_ID VARCHAR2(10)) DEBUG 2016.09.29. 16:01: liquibase: Executing QUERY database command: select count(*) from LB_SOLO.DATABASECHANGELOG INFO 2016.09.29. 16:01: liquibase: Reading from LB_SOLO.DATABASECHANGELOG DEBUG 2016.09.29. 16:01: liquibase: Executing QUERY database command: SELECT * FROM LB_SOLO.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC DEBUG 2016.09.29. 16:01: liquibase: Executing QUERY database command: select count(*) from LB_SOLO.DATABASECHANGELOGLOCK DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Computed checksum for createTable:[ columns=[ [ [ nullable="false" primaryKey="true" primaryKeyName="DPT_PK" ] name="id" type="number(4,0)" ], [ name="dname" remarks="The official department name as registered on the internal website." type="varchar2(14)" ] ] remarks="The departments of this company. Does not include geographical divisions." ... [truncated in log] as e99886c40016439bb417f7a86af6f2f2 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Computed checksum for addUniqueConstraint:[ columnNames="dname" constraintName="departments_uk1" tableName="departments" ] as a35c955e24bb49bfb9326b0f95b5a3d5 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Computed checksum for 7:e99886c40016439bb417f7a86af6f2f2:7:a35c955e24bb49bfb9326b0f95b5a3d5: as c7013e83649083b4eb1f00ee595e7e2f DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: Computed checksum for createTable:[ columns=[ [ [ nullable="false" primaryKey="true" primaryKeyName="EMP_PK" ] name="id" type="number(4,0)" ], [ name="ename" remarks="The first and last name" type="varchar2(14)" ], [ name="salary" remarks="The full remuneration" type="number(6,2)" ], [ ... [truncated in log] as 2fac36d4e89b10a94858f3822a332147 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: Computed checksum for 7:2fac36d4e89b10a94858f3822a332147: as bd0abc438cb9f094fbdeefded68f2326 DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/tab/departments.xml::1::jsmith: Computed checksum for createTable:[ columns=[ [ [ nullable="false" primaryKey="true" primaryKeyName="DPT_PK" ] name="id" type="number(4,0)" ], [ name="dname" remarks="The official department name as registered on the internal website." type="varchar2(14)" ] ] remarks="The departments of this company. Does not include geographical divisions." ... [truncated in log] as e99886c40016439bb417f7a86af6f2f2 DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/tab/departments.xml::1::jsmith: Computed checksum for addUniqueConstraint:[ columnNames="dname" constraintName="departments_uk1" tableName="departments" ] as a35c955e24bb49bfb9326b0f95b5a3d5 DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/tab/departments.xml::1::jsmith: Computed checksum for 7:e99886c40016439bb417f7a86af6f2f2:7:a35c955e24bb49bfb9326b0f95b5a3d5: as c7013e83649083b4eb1f00ee595e7e2f DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/tab/employees.xml::1::jsmith: Computed checksum for createTable:[ columns=[ [ [ nullable="false" primaryKey="true" primaryKeyName="EMP_PK" ] name="id" type="number(4,0)" ], [ name="ename" remarks="The first and last name" type="varchar2(14)" ], [ name="salary" remarks="The full remuneration" type="number(6,2)" ], [ ... [truncated in log] as 2fac36d4e89b10a94858f3822a332147 DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/tab/employees.xml::1::jsmith: Computed checksum for 7:2fac36d4e89b10a94858f3822a332147: as bd0abc438cb9f094fbdeefded68f2326 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/seq/departments_seq.xml::1::jsmith: Computed checksum for createSequence:[ sequenceName="departments_seq" ] as 5953b530b261568f7dd0110b34f96f40 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/seq/departments_seq.xml::1::jsmith: Computed checksum for 7:5953b530b261568f7dd0110b34f96f40: as e0768474d1967405b776d003241a72ad DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/seq/departments_seq.xml::1::jsmith: Computed checksum for createSequence:[ sequenceName="departments_seq" ] as 5953b530b261568f7dd0110b34f96f40 DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/seq/departments_seq.xml::1::jsmith: Computed checksum for 7:5953b530b261568f7dd0110b34f96f40: as e0768474d1967405b776d003241a72ad DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/cst/employees.xml::1::jsmith: Computed checksum for addForeignKeyConstraint:[ baseColumnNames="dpt_id" baseTableName="employees" constraintName="emp_dpt_fk" referencedColumnNames="id" referencedTableName="departments" ] as af7ac1985de8fe272383ec63d2ad7c62 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/cst/employees.xml::1::jsmith: Computed checksum for 7:af7ac1985de8fe272383ec63d2ad7c62: as fcefbc54c4170cbccc077b7bccd6f7f6 DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/cst/employees.xml::1::jsmith: Computed checksum for addForeignKeyConstraint:[ baseColumnNames="dpt_id" baseTableName="employees" constraintName="emp_dpt_fk" referencedColumnNames="id" referencedTableName="departments" ] as af7ac1985de8fe272383ec63d2ad7c62 DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/cst/employees.xml::1::jsmith: Computed checksum for 7:af7ac1985de8fe272383ec63d2ad7c62: as fcefbc54c4170cbccc077b7bccd6f7f6 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/latest/pks/departments_pck.xml::1::jsmith: Computed checksum for createProcedure:[ procedureBody="create or replace package departments_pck as function upname(name in varchar2) return varchar2; end departments_pck;" ] as a2a7d8f81242b1ac45f52bcf3c065a31 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/latest/pks/departments_pck.xml::1::jsmith: Computed checksum for 7:a2a7d8f81242b1ac45f52bcf3c065a31: as 77f4f2389a35c8adb6f9e2c467876e0e DEBUG 2016.09.29. 16:01: liquibase: install.xml: latest/pks/departments_pck.xml::1::jsmith: Computed checksum for createProcedure:[ procedureBody="create or replace package departments_pck as function upname(name in varchar2) return varchar2; end departments_pck;" ] as a2a7d8f81242b1ac45f52bcf3c065a31 DEBUG 2016.09.29. 16:01: liquibase: install.xml: latest/pks/departments_pck.xml::1::jsmith: Computed checksum for 7:a2a7d8f81242b1ac45f52bcf3c065a31: as 77f4f2389a35c8adb6f9e2c467876e0e DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/latest/vw/departments_vw.xml::1::jsmith: Computed checksum for createView:[ selectQuery="select id, dname from departments" viewName="departments_vw" ] as 72eb0f81dfee0b125fbc71c7d98ff6ea DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/latest/vw/departments_vw.xml::1::jsmith: Computed checksum for 7:72eb0f81dfee0b125fbc71c7d98ff6ea: as 4a35f8deda595ba13493827c150abbe3 DEBUG 2016.09.29. 16:01: liquibase: install.xml: latest/vw/departments_vw.xml::1::jsmith: Computed checksum for createView:[ selectQuery="select id, dname from departments" viewName="departments_vw" ] as 72eb0f81dfee0b125fbc71c7d98ff6ea DEBUG 2016.09.29. 16:01: liquibase: install.xml: latest/vw/departments_vw.xml::1::jsmith: Computed checksum for 7:72eb0f81dfee0b125fbc71c7d98ff6ea: as 4a35f8deda595ba13493827c150abbe3 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/latest/pkb/departments_pck.xml::1::jsmith: Computed checksum for createProcedure:[ procedureBody="create or replace package body departments_pck as function upname(name in varchar2) return varchar2 is begin return upper(name); end; end departments_pck;" ] as 82c8107e5e18cfc6fe87014cc1c4d3f2 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/latest/pkb/departments_pck.xml::1::jsmith: Computed checksum for 7:82c8107e5e18cfc6fe87014cc1c4d3f2: as 531bd42e9181ca3fb35ae03ad39f1984 DEBUG 2016.09.29. 16:01: liquibase: install.xml: latest/pkb/departments_pck.xml::1::jsmith: Computed checksum for createProcedure:[ procedureBody="create or replace package body departments_pck as function upname(name in varchar2) return varchar2 is begin return upper(name); end; end departments_pck;" ] as 82c8107e5e18cfc6fe87014cc1c4d3f2 DEBUG 2016.09.29. 16:01: liquibase: install.xml: latest/pkb/departments_pck.xml::1::jsmith: Computed checksum for 7:82c8107e5e18cfc6fe87014cc1c4d3f2: as 531bd42e9181ca3fb35ae03ad39f1984 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/latest/trg/departments_bi.xml::1::jsmith: Computed checksum for createProcedure:[ procedureBody="create trigger departments_bi before insert on departments for each row when (new.id is null) begin select departments_seq.nextval into :new.id from dual; end;" ] as 5c8a4d53fa303a04f1d711b4e5f1e544 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/latest/trg/departments_bi.xml::1::jsmith: Computed checksum for 7:5c8a4d53fa303a04f1d711b4e5f1e544: as a87024edd93054316415693821f885a7 DEBUG 2016.09.29. 16:01: liquibase: install.xml: latest/trg/departments_bi.xml::1::jsmith: Computed checksum for createProcedure:[ procedureBody="create trigger departments_bi before insert on departments for each row when (new.id is null) begin select departments_seq.nextval into :new.id from dual; end;" ] as 5c8a4d53fa303a04f1d711b4e5f1e544 DEBUG 2016.09.29. 16:01: liquibase: install.xml: latest/trg/departments_bi.xml::1::jsmith: Computed checksum for 7:5c8a4d53fa303a04f1d711b4e5f1e544: as a87024edd93054316415693821f885a7 DEBUG 2016.09.29. 16:01: liquibase: install.xml: install.xml::1::MajorVersion: Computed checksum for as d41d8cd98f00b204e9800998ecf8427e DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Running Changeset:/Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Changeset /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Reading ChangeSet: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Executing Statement: liquibase.statement.core.CreateTableStatement@64b0598 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Executing EXECUTE database command: CREATE TABLE LB_SOLO.departments (id NUMBER(4, 0) NOT NULL, dname VARCHAR2(14), CONSTRAINT DPT_PK PRIMARY KEY (id)) DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Executing Statement: liquibase.statement.core.SetTableRemarksStatement@18f8cd79 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Executing EXECUTE database command: COMMENT ON TABLE LB_SOLO.departments IS 'The departments of this company. Does not include geographical divisions.' DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Executing Statement: liquibase.statement.core.SetColumnRemarksStatement@3e2055d6 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Executing EXECUTE database command: COMMENT ON COLUMN LB_SOLO.departments.dname IS 'The official department name as registered on the internal website.' INFO 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Table departments created DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Executing Statement: liquibase.statement.core.AddUniqueConstraintStatement@50029372 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Executing EXECUTE database command: ALTER TABLE LB_SOLO.departments ADD CONSTRAINT departments_uk1 UNIQUE (dname) INFO 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Unique constraint added to departments(dname) INFO 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: ChangeSet /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith ran successfully in 122ms DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Executing QUERY database command: SELECT MAX(ORDEREXECUTED) FROM LB_SOLO.DATABASECHANGELOG DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/departments.xml::1::jsmith: Executing EXECUTE database command: INSERT INTO LB_SOLO.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1', 'jsmith', '/Users/test/liquibase/project/TEST/install/tab/departments.xml', SYSTIMESTAMP, 1, '7:c7013e83649083b4eb1f00ee595e7e2f', 'createTable tableName=departments; addUniqueConstraint constraintName=departments_uk1, tableName=departments', '', 'EXECUTED', NULL, NULL, '3.5.2', '5157708844') DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: Running Changeset:/Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: Changeset /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: Reading ChangeSet: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: Executing Statement: liquibase.statement.core.CreateTableStatement@6bb4dd34 DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: Executing EXECUTE database command: CREATE TABLE LB_SOLO.employees (id NUMBER(4, 0) NOT NULL, ename VARCHAR2(14), salary NUMBER(6, 2), dpt_id NUMBER(4, 0), CONSTRAINT EMP_PK PRIMARY KEY (id)) DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: Executing Statement: liquibase.statement.core.SetColumnRemarksStatement@7d9f158f DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: Executing EXECUTE database command: COMMENT ON COLUMN LB_SOLO.employees.ename IS 'The first and last name' DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: Executing Statement: liquibase.statement.core.SetColumnRemarksStatement@45efd90f DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: Executing EXECUTE database command: COMMENT ON COLUMN LB_SOLO.employees.salary IS 'The full remuneration' INFO 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: Table employees created INFO 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: ChangeSet /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith ran successfully in 96ms DEBUG 2016.09.29. 16:01: liquibase: install.xml: /Users/test/liquibase/project/TEST/install/tab/employees.xml::1::jsmith: Executing EXECUTE database command: INSERT INTO LB_SOLO.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1', 'jsmith', '/Users/test/liquibase/project/TEST/install/tab/employees.xml', SYSTIMESTAMP, 2, '7:bd0abc438cb9f094fbdeefded68f2326', 'createTable tableName=employees', '', 'EXECUTED', NULL, NULL, '3.5.2', '5157708844') DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/tab/departments.xml::1::jsmith: Running Changeset:install/tab/departments.xml::1::jsmith DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/tab/departments.xml::1::jsmith: Changeset install/tab/departments.xml::1::jsmith DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/tab/departments.xml::1::jsmith: Reading ChangeSet: install/tab/departments.xml::1::jsmith DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/tab/departments.xml::1::jsmith: Executing Statement: liquibase.statement.core.CreateTableStatement@2bdd8394 DEBUG 2016.09.29. 16:01: liquibase: install.xml: install/tab/departments.xml::1::jsmith: Executing EXECUTE database command: CREATE TABLE LB_SOLO.departments (id NUMBER(4, 0) NOT NULL, dname VARCHAR2(14), CONSTRAINT DPT_PK PRIMARY KEY (id)) SEVERE 2016.09.29. 16:01: liquibase: install.xml: install/tab/departments.xml::1::jsmith: Change Set install/tab/departments.xml::1::jsmith failed. Error: ORA-00955: name is already used by an existing object [Failed SQL: CREATE TABLE LB_SOLO.departments (id NUMBER(4, 0) NOT NULL, dname VARCHAR2(14), CONSTRAINT DPT_PK PRIMARY KEY (id))] DEBUG 2016.09.29. 16:01: liquibase: install/tab/departments.xml::1::jsmith: Release Database Lock DEBUG 2016.09.29. 16:01: liquibase: install/tab/departments.xml::1::jsmith: Executing UPDATE database command: UPDATE LB_SOLO.DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1 INFO 2016.09.29. 16:01: liquibase: install/tab/departments.xml::1::jsmith: Successfully released change log lock SEVERE 2016.09.29. 16:01: liquibase: install/tab/departments.xml::1::jsmith: ORA-00955: name is already used by an existing object [Failed SQL: CREATE TABLE LB_SOLO.departments (id NUMBER(4, 0) NOT NULL, dname VARCHAR2(14), CONSTRAINT DPT_PK PRIMARY KEY (id))] liquibase.exception.MigrationFailedException: Migration failed for change set install/tab/departments.xml::1::jsmith: Reason: liquibase.exception.DatabaseException: ORA-00955: name is already used by an existing object [Failed SQL: CREATE TABLE LB_SOLO.departments (id NUMBER(4, 0) NOT NULL, dname VARCHAR2(14), CONSTRAINT DPT_PK PRIMARY KEY (id))] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79) at liquibase.Liquibase.update(Liquibase.java:214) at liquibase.Liquibase.update(Liquibase.java:192) at liquibase.integration.commandline.Main.doMigration(Main.java:1130) at liquibase.integration.commandline.Main.run(Main.java:188) at liquibase.integration.commandline.Main.main(Main.java:103) Caused by: liquibase.exception.DatabaseException: ORA-00955: name is already used by an existing object [Failed SQL: CREATE TABLE LB_SOLO.departments (id NUMBER(4, 0) NOT NULL, dname VARCHAR2(14), CONSTRAINT DPT_PK PRIMARY KEY (id))] at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582) ... 7 more Caused by: java.sql.SQLException: ORA-00955: name is already used by an existing object at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1726) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1696) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307) ... 12 more