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

Atlassian JIRA | Mike Salisbury | 1 decade ago
  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"
  2. 0

    Hibernate Community • View topic - junit fails with mysql

    hibernate.org | 8 months ago
    net.sf.hibernate.JDBCException: SQLException occurred
  3. 0

    QUERY OF DB TABLES

    Oracle Community | 1 decade ago | 843835
    java.sql.SQLException: General error: Table 'games.tablename' doesn't exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    RDBMS compatibility

    runawfe | 1 decade ago | yilativs
    ru.runa.af.InternalApplicationException: net.sf.hibernate.exception.SQLGrammarException: Unable to perform find

    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

      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