Skip to content

Instantly share code, notes, and snippets.

@ssmusoke
Created November 30, 2020 11:58
Show Gist options
  • Save ssmusoke/20d8e6cb410b281ac9f5af945db140f7 to your computer and use it in GitHub Desktop.
Save ssmusoke/20d8e6cb410b281ac9f5af945db140f7 to your computer and use it in GitHub Desktop.
an despite precondition failure due to onFail='MARK_RAN':
liquibase.xml : Not precondition failed
SEVERE 11/30/20 2:43 PM:liquibase: Change Set liquibase.xml::muzima-20201123083000::bmokaya failed. Error: Error executing SQL INSERT INTO scheduler_task_config (name, description, schedulable_class,
start_time, start_time_pattern, repeat_interval, start_on_startup, started,
created_by, date_created, changed_by, date_changed, last_execution_time, uuid )
VALUES ('Process Muzima's Queue Data', 'Task to process queue data submitted to the muzima processor.', 'org.openmrs.module.muzima.task.ProcessQueueDataTask',
'2020-11-23 00:00:00','MM/dd/yyyy HH:mm:ss',3600, 1, 1,
1, now(), NULL, NULL, NULL, uuid()): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Queue Data', 'Task to process queue data submitted to the muzima processor.', ' at line 4
liquibase.exception.DatabaseException: Error executing SQL INSERT INTO scheduler_task_config (name, description, schedulable_class,
start_time, start_time_pattern, repeat_interval, start_on_startup, started,
created_by, date_created, changed_by, date_changed, last_execution_time, uuid )
VALUES ('Process Muzima's Queue Data', 'Task to process queue data submitted to the muzima processor.', 'org.openmrs.module.muzima.task.ProcessQueueDataTask',
'2020-11-23 00:00:00','MM/dd/yyyy HH:mm:ss',3600, 1, 1,
1, now(), NULL, NULL, NULL, uuid()): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Queue Data', 'Task to process queue data submitted to the muzima processor.', ' at line 4
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:191)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:220)
at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:986)
at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:726)
at org.openmrs.api.context.Daemon$1.run(Daemon.java:80)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Queue Data', 'Task to process queue data submitted to the muzima processor.', ' at line 4
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2480)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2438)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
... 11 more
INFO 11/30/20 2:43 PM:liquibase: Successfully released change log lock
WARN - ModuleFactory.startModuleInternal(786) |2020-11-30 14:43:15,077| Error while trying to start module: muzimacore
org.openmrs.module.ModuleException: Unable to update data model using liquibase.xml. Module: Muzima Core Module
at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:993)
at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:726)
at org.openmrs.api.context.Daemon$1.run(Daemon.java:80)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::muzima-20201123083000::bmokaya:
Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO scheduler_task_config (name, description, schedulable_class,
start_time, start_time_pattern, repeat_interval, start_on_startup, started,
created_by, date_created, changed_by, date_changed, last_execution_time, uuid )
VALUES ('Process Muzima's Queue Data', 'Task to process queue data submitted to the muzima processor.', 'org.openmrs.module.muzima.task.ProcessQueueDataTask',
'2020-11-23 00:00:00','MM/dd/yyyy HH:mm:ss',3600, 1, 1,
1, now(), NULL, NULL, NULL, uuid()): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Queue Data', 'Task to process queue data submitted to the muzima processor.', ' at line 4:
Caused By: Error executing SQL INSERT INTO scheduler_task_config (name, description, schedulable_class,
start_time, start_time_pattern, repeat_interval, start_on_startup, started,
created_by, date_created, changed_by, date_changed, last_execution_time, uuid )
VALUES ('Process Muzima's Queue Data', 'Task to process queue data submitted to the muzima processor.', 'org.openmrs.module.muzima.task.ProcessQueueDataTask',
'2020-11-23 00:00:00','MM/dd/yyyy HH:mm:ss',3600, 1, 1,
1, now(), NULL, NULL, NULL, uuid()): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Queue Data', 'Task to process queue data submitted to the muzima processor.', ' at line 4:
Caused By: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Queue Data', 'Task to process queue data submitted to the muzima processor.', ' at line 4
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:191)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:220)
at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:986)
... 2 more
Caused by: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO scheduler_task_config (name, description, schedulable_class,
start_time, start_time_pattern, repeat_interval, start_on_startup, started,
created_by, date_created, changed_by, date_changed, last_execution_time, uuid )
VALUES ('Process Muzima's Queue Data', 'Task to process queue data submitted to the muzima processor.', 'org.openmrs.module.muzima.task.ProcessQueueDataTask',
'2020-11-23 00:00:00','MM/dd/yyyy HH:mm:ss',3600, 1, 1,
1, now(), NULL, NULL, NULL, uuid()): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Queue Data', 'Task to process queue data submitted to the muzima processor.', ' at line 4
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: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Queue Data', 'Task to process queue data submitted to the muzima processor.', ' at line 4
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2480)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2438)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment