java.sql.SQLException: General error, message from server: "Table 'jira.CHANGEGROUP' doesn't exist"

Atlassian JIRA | Mike Salisbury | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    When installing 2.3 upgrade, we noticed many exceptions like the following in our log. Upon poking into the issue, we discovered that the tables had been created with all lowercase names. With MySQL on a Unix server, the database and table names are case sensitive ('cuz the filesystem is). While I did a complete rebuild of the db with the upgrade (that is, i dropped all of the tables before upgrading so Jira would recreate) - it would be ideal if the startup didn't error out. Do you have any suggestions? I was surprised others hadn't run into this in the forums. Cheers, java.sql.SQLException: General error, message from server: "Table 'jira.CHANGEGROUP' doesn't exist" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1626) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:886) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:917) at com.mysql.jdbc.Connection.execSQL(Connection.java:1841) at com.mysql.jdbc.Connection.execSQL(Connection.java:1775) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1220) at com.mysql.jdbc.DatabaseMetaData.getIndexInfo(DatabaseMetaData.java:2127) at org.ofbiz.core.entity.jdbc.DatabaseUtil.getIndexInfo(DatabaseUtil.java:1122) at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:499) at org.ofbiz.core.entity.GenericDAO.checkDb(GenericDAO.java:1413) at org.ofbiz.core.entity.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:270) at org.ofbiz.core.entity.GenericDelegator.<init>(GenericDelegator.java:144) at org.ofbiz.core.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:86) at com.atlassian.core.CoreFactory.getGenericDelegator(CoreFactory.java:33) at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkConnection(ConsistencyCheckImpl.java:134) at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkConsistency(ConsistencyCheckImpl.java:93) at com.atlassian.jira.upgrade.ConsistencyCheckImpl.initialise(ConsistencyCheckImpl.java:78) at com.atlassian.jira.upgrade.ConsistencyLauncher.contextInitialized(ConsistencyLauncher.java:18) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3269) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3598)

    Atlassian JIRA | 1 decade ago | Mike Salisbury
    java.sql.SQLException: General error, message from server: "Table 'jira.CHANGEGROUP' doesn't exist"

    Root Cause Analysis

    1. java.sql.SQLException

      General error, message from server: "Table 'jira.CHANGEGROUP' doesn't exist"

      at com.mysql.jdbc.MysqlIO.checkErrorPacket()
    2. MySQL jdbc
      DatabaseMetaData.getIndexInfo
      1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1626)
      2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:886)
      3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945)
      4. com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:917)
      5. com.mysql.jdbc.Connection.execSQL(Connection.java:1841)
      6. com.mysql.jdbc.Connection.execSQL(Connection.java:1775)
      7. com.mysql.jdbc.Statement.executeQuery(Statement.java:1220)
      8. com.mysql.jdbc.DatabaseMetaData.getIndexInfo(DatabaseMetaData.java:2127)
      8 frames
    3. org.ofbiz.core
      GenericDelegator.getGenericDelegator
      1. org.ofbiz.core.entity.jdbc.DatabaseUtil.getIndexInfo(DatabaseUtil.java:1122)
      2. org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:499)
      3. org.ofbiz.core.entity.GenericDAO.checkDb(GenericDAO.java:1413)
      4. org.ofbiz.core.entity.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:270)
      5. org.ofbiz.core.entity.GenericDelegator.<init>(GenericDelegator.java:144)
      6. org.ofbiz.core.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:86)
      6 frames
    4. com.atlassian.core
      CoreFactory.getGenericDelegator
      1. com.atlassian.core.CoreFactory.getGenericDelegator(CoreFactory.java:33)
      1 frame
    5. com.atlassian.jira
      ConsistencyLauncher.contextInitialized
      1. com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkConnection(ConsistencyCheckImpl.java:134)
      2. com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkConsistency(ConsistencyCheckImpl.java:93)
      3. com.atlassian.jira.upgrade.ConsistencyCheckImpl.initialise(ConsistencyCheckImpl.java:78)
      4. com.atlassian.jira.upgrade.ConsistencyLauncher.contextInitialized(ConsistencyLauncher.java:18)
      4 frames
    6. Glassfish Core
      StandardContext.start
      1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3269)
      2. org.apache.catalina.core.StandardContext.start(StandardContext.java:3598)
      2 frames