A new topic, 'Upgrading from 1.8.1 to 1.9.5', has been made on a board you are
watching.
You can see it at
http://liquibase.org/forum/index.php?topic=524.new#new
The text of the topic is shown below:
Hi all. I'm trying to find documentation on migrating from 1.8.1 to 1.9.5.
It's definitely not a drop-in replacement. I've had the following problems:
Duplicate keys in the DATABASECHANGELOG table for 'alwaysRun' change sets. For
example:
Code:
liquibase.exception.JDBCException: Error executing SQL INSERT INTO
`DATABASECHANGELOG` (`DATEEXECUTED`, `AUTHOR`, `LIQUIBASE`, `DESCRIPTION`,
`COMMENTS`, `MD5SUM`, `ID`, `FILENAME`) VALUES (NOW(), 'josh', '1.9.5', 'Custom
SQL', 'Set the default storage engine.', '92131119c65016ef3f9f1226385bcfa1',
'prepare', 'lqScript.xml')
at
liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55)
at
liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86)
at
liquibase.database.AbstractDatabase.markChangeSetAsRan(AbstractDatabase.java:1309)
at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:28)
at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
at liquibase.Liquibase.update(Liquibase.java:112)
...
Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry 'prepare-josh-lqScript.xml' for key 'PRIMARY'
...
at
liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78)
at
liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
... 33 more
The change set is: Code:
<changeSet author="josh" id="prepare" runAlways="true">
<comment>Set the default storage engine.</comment>
<sql>SET storage_engine=MYISAM;</sql>
</changeSet>
Duplicate column name errors for change sets that work in 1.8.1. This might
be because of the checksum issues, not sure.
Lots of checksum errors when migrating a snapshot of a production database.
Fixed that by clearing the checksums though.
Maybe I should stick with 1.8.1 and wait for 2.0?
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The LiquiBase Community Forum Team.------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
