Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-2077

Exceptions on startup with MySQL on Linux

    XMLWordPrintable

Details

    Description

      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)

      Attachments

        Activity

          People

            Unassigned Unassigned
            a11de597e1c1 Mike Salisbury
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: