Details
-
Bug
-
Resolution: Cannot Reproduce
-
Medium
-
None
-
2.3 Enterprise
-
2.03
-
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)