Using an Unsupported Version of MySQL

Still need help?

The Atlassian Community is here for you.

Ask the community

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.X

And 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

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.