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

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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)
    via by Mike Salisbury,
  • Installation error
    via infoglue by nobody
    ,
  • jdbc Error, unable to connect to sql
    via Stack Overflow by SDWACW
    ,
  • i am getting Hibernate error
    via Stack Overflow by Raji
    ,
    • 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)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    5 more bugmates