Updating a Database

General Discussion
1

Hi,

I have applied changesets to a Oracle DB.  Now I am reruning update to get apply another set of change sets. On the second update, I get the following error:
  liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE DATABASECHANGELOG MODIFY ( MD5SUM VARCHAR2(35)

I sent the output to a sql file and this is what I saw:

– Lock Database
– Modifying size of databasechangelog.md5sum column
– Modifying size of databasechangelog.liquibase column
ALTER TABLE DATABASECHANGELOG MODIFY ( MD5SUM VARCHAR2(35);

ALTER TABLE DATABASECHANGELOG MODIFY ( LIQUIBASE VARCHAR2(20);

That doesn’t look like proper sql.  A bug?  Also why is the databasechangelog table being modified to begin with?

Thanks,
Alana

2

Just tried updating in Firebird, that works fine. :)  Haven’t had a chance to test with MySQL yet.

3

Is it 2.0 RC1 you are testing it with?  It was an oracle specific error that has been fixed.  You can get the most recent build from http://liquibase.org/ci/latest

Nathan

4

Thanks. :slight_smile: I will download the latest and test it.