com.mirth.connect.model.util.MigrationException: Failed to execute script: mysql-9-3.0.0-1.sql

Mirth Project | Brent Moen | 3 years ago
  1. 0

    See related forum post: http://www.mirthcorp.com/community/forums/showthread.php?t=9243&page=2 To reproduce: Set up a Mirth Connect 2.x instance running on a MySQL 5.1.52 database. Then attempt to migrate it to Mirth Connect 3.0.0. The following error will appear in the console and the server will halt with the schema left partially migrated: ERROR 2013-11-14 09:26:56,071 [main] com.mirth.connect.server.Mirth: Failed to migrate database schema com.mirth.connect.model.util.MigrationException: Failed to execute script: mysql-9-3.0.0-1.sql at com.mirth.connect.server.migration.Migrator.executeScript(Migrator.java:87) at com.mirth.connect.server.migration.Migrate3_0_0.migrate(Migrate3_0_0.java:46) at com.mirth.connect.server.migration.ServerMigrator.migrate(ServerMigrator.java:63) at com.mirth.connect.server.controllers.DefaultMigrationController.migrate(DefaultMigrationController.java:85) at com.mirth.connect.server.Mirth.startup(Mirth.java:235) at com.mirth.connect.server.Mirth.run(Mirth.java:154) at com.mirth.connect.server.Mirth.main(Mirth.java:107) Caused by: java.sql.SQLException: Can't execute the given command because you have active locked tables or an active transaction at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732) at com.mirth.connect.server.migration.Migrator.executeScript(Migrator.java:84) ... 6 more INFO 2013-11-14 09:26:56,073 [Thread-4] com.mirth.connect.server.Mirth: shutting down mirth due to normal request

    Mirth Project | 3 years ago | Brent Moen
    com.mirth.connect.model.util.MigrationException: Failed to execute script: mysql-9-3.0.0-1.sql
  2. 0

    See related forum post: http://www.mirthcorp.com/community/forums/showthread.php?t=9243&page=2 To reproduce: Set up a Mirth Connect 2.x instance running on a MySQL 5.1.52 database. Then attempt to migrate it to Mirth Connect 3.0.0. The following error will appear in the console and the server will halt with the schema left partially migrated: ERROR 2013-11-14 09:26:56,071 [main] com.mirth.connect.server.Mirth: Failed to migrate database schema com.mirth.connect.model.util.MigrationException: Failed to execute script: mysql-9-3.0.0-1.sql at com.mirth.connect.server.migration.Migrator.executeScript(Migrator.java:87) at com.mirth.connect.server.migration.Migrate3_0_0.migrate(Migrate3_0_0.java:46) at com.mirth.connect.server.migration.ServerMigrator.migrate(ServerMigrator.java:63) at com.mirth.connect.server.controllers.DefaultMigrationController.migrate(DefaultMigrationController.java:85) at com.mirth.connect.server.Mirth.startup(Mirth.java:235) at com.mirth.connect.server.Mirth.run(Mirth.java:154) at com.mirth.connect.server.Mirth.main(Mirth.java:107) Caused by: java.sql.SQLException: Can't execute the given command because you have active locked tables or an active transaction at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732) at com.mirth.connect.server.migration.Migrator.executeScript(Migrator.java:84) ... 6 more INFO 2013-11-14 09:26:56,073 [Thread-4] com.mirth.connect.server.Mirth: shutting down mirth due to normal request

    Mirth Project | 3 years ago | Brent Moen
    com.mirth.connect.model.util.MigrationException: Failed to execute script: mysql-9-3.0.0-1.sql
  3. 0

    Error when dumping logs

    GitHub | 5 years ago | havejack
    java.sql.SQLException: Access denied for user 'kunden_81053'@'%' (using password: YES)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Errors Spamming Server Logs

    GitHub | 3 years ago | brodiej
    java.sql.SQLException: Failed to read auto-increment value from storage engine
  6. 0

    new install problem

    GitHub | 2 years ago | gzanthony
    org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Error executing statement at line 39: ALTER TABLE `s_account_settings` ADD CONSTRAINT `FK_s_account_settings_2` FOREIGN KEY (`defaultThemeId`) REFERENCES `s_account_theme` (`id`) ON DELETE SET NULL ON UPDATE CASCADE

  1. tvrmsmith 12 times, last 3 weeks ago
  2. MethodCall 1 times, last 4 months ago
  3. mortalman7 2 times, last 5 months ago
1 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Can't execute the given command because you have active locked tables or an active transaction

    at com.mysql.jdbc.SQLError.createSQLException()
  2. MySQL jdbc
    StatementImpl.execute
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
    2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
    3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
    4. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
    5. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
    6. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
    7. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
    8. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
    9. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
    9 frames
  3. com.mirth.connect
    Mirth.main
    1. com.mirth.connect.server.migration.Migrator.executeScript(Migrator.java:84)
    2. com.mirth.connect.server.migration.Migrate3_0_0.migrate(Migrate3_0_0.java:46)
    3. com.mirth.connect.server.migration.ServerMigrator.migrate(ServerMigrator.java:63)
    4. com.mirth.connect.server.controllers.DefaultMigrationController.migrate(DefaultMigrationController.java:85)
    5. com.mirth.connect.server.Mirth.startup(Mirth.java:235)
    6. com.mirth.connect.server.Mirth.run(Mirth.java:154)
    7. com.mirth.connect.server.Mirth.main(Mirth.java:107)
    7 frames