[chandler-users] Exception in MySQL 0.6.0 to 0.7.0 migration to

[Blair Zajac]

I tried the migration from 0.6.0 to 0.7.0 today on i386 Ubuntu Dapper Drake 
using JDK 1.6 and MySQL 5:

$ java -jar cosmo-migration-0.7.0-jar-with-dependencies.jar -v migration.properties

I got the below exception.  Is there anything I can do to fix this?  Is there 
any other information to help fix this?

I copied my modified migration.properties file I used from the 0.5.0 to 0.6.0 
migration to the 0.7.0 migration, since the original migration.properties file 
did not change.

BTW, the documentation in the README.txt file mentions the 0.5 server.

Regards,
Blair

-- 
Blair Zajac, Ph.D.
CTO, OrcaWare Technologies
<blair at orcaware.com>
Subversion training, consulting and support
http://www.orcaware.com/training/





INFO - CollectionFactory.<clinit>(76) | JDK 1.4+ collections available
INFO - XmlBeanDefinitionReader.loadBeanDefinitions(347) | Loading XML bean 
definitions from class path resource [applicationContext-migrate.xml]
INFO - AbstractRefreshableApplicationContext.refreshBeanFactory(100) | Bean 
factory for application context 
[org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=9502784]: 
org.springframework.beans.factory.support.DefaultListableBeanFactory defining 
beans 
[dataSource,zeroPointFiveToZeroPointSix,zeroPointSixToZeroPointSixZeroOne,zeroPointSixZeroOneToZeroPointSixOne,zeroPointSixOneToZeroPointSeven,propertyPlaceHolderConfigurer,migrationManager]; 
root of BeanFactory hierarchy
INFO - AbstractApplicationContext.refresh(322) | 7 beans defined in application 
context 
[org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=9502784]
INFO - AbstractApplicationContext.initMessageSource(473) | Unable to locate 
MessageSource with name 'messageSource': using default 
[org.springframework.context.support.DelegatingMessageSource at 1342ba4]
INFO - AbstractApplicationContext.initApplicationEventMulticaster(495) | Unable 
to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': 
using default 
[org.springframework.context.event.SimpleApplicationEventMulticaster at 29ab3e]
INFO - DefaultListableBeanFactory.preInstantiateSingletons(261) | 
Pre-instantiating singletons in factory 
[org.springframework.beans.factory.support.DefaultListableBeanFactory defining 
beans 
[dataSource,zeroPointFiveToZeroPointSix,zeroPointSixToZeroPointSixZeroOne,zeroPointSixZeroOneToZeroPointSixOne,zeroPointSixOneToZeroPointSeven,propertyPlaceHolderConfigurer,migrationManager]; 
root of BeanFactory hierarchy]
INFO - DriverManagerDataSource.setDriverClassName(155) | Loaded JDBC driver: 
com.mysql.jdbc.Driver
INFO - MigrationManager.migrate(85) | Found Cosmo schema version 0.6.0
INFO - MigrationManager.migrate(92) | Found 3 migrations using dialect: MySQL5
INFO - MigrationManager.migrate(95) | Migrating 0.6.0 to 0.6.0.1
DEBUG - AbstractMigration.migrateSchema(83) | begin migrateSchema()
INFO - AbstractMigration.migrateSchema(89) | unable to find script: 
/0.6.0-to-0.6.0.1-MySQL5-pre.sql
INFO - AbstractMigration.migrateSchemaCleanup(133) | found script: 
/0.6.0-to-0.6.0.1-MySQL5-post.sql
DEBUG - AbstractMigration.migrateSchemaCleanup(143) | executing update 
server_properties SET propertyvalue='0.6.0.1' WHERE 
propertyname='cosmo.schemaVersion';
INFO - MigrationManager.migrate(97) | Migrated to 0.6.0.1
INFO - MigrationManager.migrate(95) | Migrating 0.6.0.1 to 100
DEBUG - AbstractMigration.migrateSchema(83) | begin migrateSchema()
INFO - AbstractMigration.migrateSchema(89) | unable to find script: 
/0.6.0.1-to-100-MySQL5-pre.sql
DEBUG - ZeroPointSixZeroOneToZeroPointSixOneMigration.migrateData(89) | starting 
migrateData()
DEBUG - ZeroPointSixZeroOneToZeroPointSixOneMigration.migrateEvents(140) | begin 
migrateEvents()
DEBUG - ZeroPointSixZeroOneToZeroPointSixOneMigration.migrateEvents(402) | 
processed 52 events
DEBUG - ZeroPointSixZeroOneToZeroPointSixOneMigration.migrateEvents(403) | 0 
events had event exceptions
DEBUG - ZeroPointSixZeroOneToZeroPointSixOneMigration.migrateEvents(404) | 0 
exceptions ignored due to duplicates
DEBUG - ZeroPointSixZeroOneToZeroPointSixOneMigration.migrateEvents(405) | 0 
events contain duplicate exceptions
DEBUG - ZeroPointSixZeroOneToZeroPointSixOneMigration.migrateEvents(406) | 0 bad 
events encountered
DEBUG - ZeroPointSixZeroOneToZeroPointSixOneMigration.migrateEvents(407) | 21 
events failed validation
DEBUG - ZeroPointSixZeroOneToZeroPointSixOneMigration.migrateAttributes(99) | 
starting migrateAttributes()
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'createdate' 
in 'field list'
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
         at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
         at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
         at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
         at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
         at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
         at 
org.osaf.cosmo.migrate.ZeroPointSixZeroOneToZeroPointSixOneMigration.migrateAttributes(ZeroPointSixZeroOneToZeroPointSixOneMigration.java:106)
         at 
org.osaf.cosmo.migrate.ZeroPointSixZeroOneToZeroPointSixOneMigration.migrateData(ZeroPointSixZeroOneToZeroPointSixOneMigration.java:92)
         at 
org.osaf.cosmo.migrate.AbstractMigration.migrate(AbstractMigration.java:61)
         at 
org.osaf.cosmo.migrate.MigrationManager.migrate(MigrationManager.java:96)
         at org.osaf.cosmo.migrate.Main.main(Main.java:90)