Liquibase 3.0.8 also has an issue trying to re-create the liquibase database tables all the time. I have to delete them from the database each time I attempt the update or it fails before doing anything. Here is the log from where I didn't delete the liquibase tables and hit the issue which is repeatable:
DEBUG 28/02/14 5:25 PM:liquibase: Connected to informix@jdbc:informix-sqli://localhost:1301:INFORMIXSERVER=ids_test;database=liquibase DEBUG 28/02/14 5:25 PM:liquibase: Setting auto commit to false from true DEBUG 28/02/14 5:25 PM:liquibase: Executing EXECUTE database command: EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('T'); DEBUG 28/02/14 5:25 PM:liquibase: Create Database Lock Table DEBUG 28/02/14 5:25 PM:liquibase: Executing EXECUTE database command: CREATE TABLE "test".DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED DATETIME YEAR TO FRACTION(5), LOCKEDBY VARCHAR(255), PRIMARY KEY (ID)) SEVERE 28/02/14 5:25 PM:liquibase: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE "test".DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED DATETIME YEAR TO FRACTION(5), LOCKEDBY VARCHAR(255), PRIMARY KEY (ID)): Table (test.databasechangeloglock) already exists in database.
Environment
Informix
Activity
Show:
Bohuslav Roztočil July 2, 2014 at 9:52 AM
Setting changelogSchemaName to the name of schema containing DATABASECHANGELOG... tables apparently solves the problem, eg.
<changelogSchemaName>amis</changelogSchemaName>
Bohuslav Roztočil July 2, 2014 at 9:32 AM
I use Maven liquibase plugin 3.2.0 and the problem keeps occuring:
[ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:3.2.0:update (default) on project amishd-ope-plan-svc: Error setting up or running Liquibase: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED DATETIME YEAR TO FRACTION(5), LOCKEDBY VARCHAR(255), PRIMARY KEY (ID)): Table (amis.databasechangeloglock) already exists in database. SQLException -> [Help 1]
I even added explicit dependency to liquibase-core 3.2.0 without any effect.
From http://forum.liquibase.org/topic/informix-issues#49382000001031006
Liquibase 3.0.8 also has an issue trying to re-create the liquibase database tables all the time. I have to delete them from the database each time I attempt the update or it fails before doing anything.
Here is the log from where I didn't delete the liquibase tables and hit the issue which is repeatable:
DEBUG 28/02/14 5:25 PM:liquibase: Connected to informix@jdbc:informix-sqli://localhost:1301:INFORMIXSERVER=ids_test;database=liquibase
DEBUG 28/02/14 5:25 PM:liquibase: Setting auto commit to false from true
DEBUG 28/02/14 5:25 PM:liquibase: Executing EXECUTE database command: EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('T');
DEBUG 28/02/14 5:25 PM:liquibase: Create Database Lock Table
DEBUG 28/02/14 5:25 PM:liquibase: Executing EXECUTE database command: CREATE TABLE "test".DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED DATETIME YEAR TO FRACTION(5), LOCKEDBY VARCHAR(255), PRIMARY KEY (ID))
SEVERE 28/02/14 5:25 PM:liquibase: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE "test".DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED DATETIME YEAR TO FRACTION(5), LOCKEDBY VARCHAR(255), PRIMARY KEY (ID)): Table (test.databasechangeloglock) already exists in database.