Using an Unsupported Version of MySQL
症状
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)
診断
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.
原因
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.
ソリューション
Upgrade the version of MySQL to one of our Supported Platforms.
最終更新日 2020 年 11 月 17 日
Powered by Confluence and Scroll Viewport.