Using an Unsupported Version of MySQL
Symptoms
A number of symptoms can be caused by using an unsupported version of MySQL within JIRA.
The following appears in the atlassian-jira.log for JIRA 5.x onwards:
Database Version : MySQL - 5.0.XAnd this also appears:
2012-09-04 10:06:01,711 http-8080-65 WARN captain.planet 603x194319x14 fyvc6e 192.168.12.46 /rest/gadget/1.0/issueTable/jql [NoModule] Could not find JDBC driver class named com.mysql.jdbc.Driver.
2012-09-04 10:06:01,711 http-8080-65 WARN captain.planet 603x194319x14 fyvc6e 192.168.12.46 /rest/gadget/1.0/issueTable/jql [NoModule]
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at com.atlassian.plugins.rest.module.ChainingClassLoader.loadClass(ChainingClassLoader.java:65)
at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:81)
at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146)
at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:101)
at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:367)
at org.ofbiz.core.entity.GenericDAO.select(GenericDAO.java:466)
at org.ofbiz.core.entity.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:78)
at org.ofbiz.core.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:541)
at org.ofbiz.core.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:576)
at sun.reflect.GeneratedMethodAccessor31.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$AbstractMultiTenantAwareInvocationHandler.invokeInternal(MultiTenantComponentFactoryImpl.java:181)
at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$MultiTenantAwareMethodInterceptor.intercept(MultiTenantComponentFactoryImpl.java:230)
at org.ofbiz.core.entity.GenericDelegator$$EnhancerByCGLIB$$e813e576.findByPrimaryKey(<generated>)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByPrimaryKey(DefaultOfBizDelegator.java:414)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByPrimaryKey(DefaultOfBizDelegator.java:406)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findById(DefaultOfBizDelegator.java:397)
Diagnosis
Verify this by checking the logs to see if the above line is a part of the startup information or checking the database version of MySQL as in the MySQL Reference Manual.
Cause
An unsupported version of MySQL is being used by JIRA. MySQL 5.0 is no longer supported as it is considered EOL by Oracle as of 9/Jan/12 as per the EOL Notice:
MySQL 5.0 covered under Oracle Lifetime Sustaining Support
Per Oracle's Lifetime Support policy, MySQL 5.0 is now covered under Oracle Sustaining Support.
Users are encouraged to upgrade to MySQL 5.5.
Resolution
Upgrade the version of MySQL to one of our Supported Platforms.
Last modified on Nov 17, 2020
Powered by Confluence and Scroll Viewport.