INFO 6/12/14 11:47 PM:liquibase: liquibase.xml is using schema version 1.9 rather than version 2.0
INFO 6/12/14 11:47 PM:liquibase: Reading from `liquibasechangelog`
INFO 6/12/14 11:47 PM:liquibase: Successfully acquired change log lock
INFO 6/12/14 11:47 PM:liquibase: liquibase.xml is using schema version 1.9 rather than version 2.0
INFO 6/12/14 11:47 PM:liquibase: Reading from `liquibasechangelog`
INFO 6/12/14 11:47 PM:liquibase: ChangeSet liquibase.xml::CSM-58-01062014::k-joseph ran successfully in 209ms
INFO 6/12/14 11:47 PM:liquibase: ChangeSet liquibase.xml::CSM-58-020620141120::k-joseph ran successfully in 51ms
SEVERE 6/12/14 11:47 PM:liquibase: Change Set liquibase.xml::CSM-58-120620141637::k-joseph failed.  Error: Error executing SQL ALTER TABLE `chartsearch_categories` ADD CONSTRAINT `category_sub_category_fk` FOREIGN KEY (`category_id`) REFERENCES `chartsearch_sub_categories` (`category_id`): Can't create table 'openmrs.#sql-d4f_63b' (errno: 150)
liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `chartsearch_categories` ADD CONSTRAINT `category_sub_category_fk` FOREIGN KEY (`category_id`) REFERENCES `chartsearch_sub_categories` (`category_id`): Can't create table 'openmrs.#sql-d4f_63b' (errno: 150)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
	at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
	at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
	at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:202)
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
	at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:231)
	at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:798)
	at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:581)
	at org.openmrs.api.context.Daemon$1.run(Daemon.java:58)
Caused by: java.sql.SQLException: Can't create table 'openmrs.#sql-d4f_63b' (errno: 150)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
	at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
	... 11 more
INFO 6/12/14 11:47 PM:liquibase: Successfully released change log lock
WARN - ModuleFactory.startModuleInternal(637) |2014-06-12 23:47:37,562| Error while trying to start module: chartsearch
org.openmrs.module.ModuleException: Unable to update data model using liquibase.xml. Module: Chart Search Module
	at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:808)
	at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:581)
	at org.openmrs.api.context.Daemon$1.run(Daemon.java:58)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::CSM-58-120620141637::k-joseph:
     Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `chartsearch_categories` ADD CONSTRAINT `category_sub_category_fk` FOREIGN KEY (`category_id`) REFERENCES `chartsearch_sub_categories` (`category_id`): Can't create table 'openmrs.#sql-d4f_63b' (errno: 150):
          Caused By: Error executing SQL ALTER TABLE `chartsearch_categories` ADD CONSTRAINT `category_sub_category_fk` FOREIGN KEY (`category_id`) REFERENCES `chartsearch_sub_categories` (`category_id`): Can't create table 'openmrs.#sql-d4f_63b' (errno: 150):
          Caused By: Can't create table 'openmrs.#sql-d4f_63b' (errno: 150)
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
	at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:202)
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
	at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:231)
	at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:798)
	... 2 more
Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `chartsearch_categories` ADD CONSTRAINT `category_sub_category_fk` FOREIGN KEY (`category_id`) REFERENCES `chartsearch_sub_categories` (`category_id`): Can't create table 'openmrs.#sql-d4f_63b' (errno: 150)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
	at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
	at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
	... 7 more
Caused by: java.sql.SQLException: Can't create table 'openmrs.#sql-d4f_63b' (errno: 150)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
	at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
	... 11 more
INFO - LoggingAdvice.invoke(117) |2014-06-12 23:47:37,707| In method AlertService.saveAlert. Arguments: Alert=Alert: #null,
INFO - LoggingAdvice.invoke(154) |2014-06-12 23:47:37,721| Exiting method saveAlert