Issue Details (XML | Word | Printable)

Key: JRA-8231
Type: Third-party issue Third-party issue
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Jeff Turner [Atlassian]
Reporter: Jeff Turner [Atlassian]
Votes: 0
Watchers: 3
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
JIRA

MySQL 3.1.11 JDBC driver broken

Created: 13/Oct/05 11:18 PM   Updated: 07/Dec/05 08:27 PM
Component/s: None
Affects Version/s: None
Fix Version/s: None

Time Tracking:
Not Specified

Participants: Anton Mazkovoi [Atlassian], Chris Wood, Dirk Tiemeyer, Gili, Jeff Turner [Atlassian] and Nick Menere [Atlassian]
Since last comment: 3 years, 29 weeks, 6 days ago
Resolution Date: 07/Dec/05 08:27 PM
Labels:


 Description  « Hide
The latest MySQL Connector/J JDBC driver appears broken. It dies when JIRA tries to read some column metadata (tested against MySQL 4.1.11 and 4.1.14): 
2005-10-14 14:13:14,933 ERROR [com.atlassian.jira.ComponentManager] An exception occurred while ComponentManager was initialising. JIRA not started properly. 
java.lang.NullPointerException
	at java.util.TreeMap.compare(TreeMap.java:1093)
	at java.util.TreeMap.getEntry(TreeMap.java:347)
	at java.util.TreeMap.containsKey(TreeMap.java:204)
	at java.util.TreeSet.contains(TreeSet.java:196)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.getColumnInfo(DatabaseUtil.java:897)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:86)
	at org.ofbiz.core.entity.GenericDAO.checkDb(GenericDAO.java:1295)
	at org.ofbiz.core.entity.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:245)
	at org.ofbiz.core.entity.GenericDelegator.<init>(GenericDelegator.java:147)
	at org.ofbiz.core.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:89)
	at com.atlassian.core.ofbiz.CoreFactory.getGenericDelegator(CoreFactory.java:33)
	at com.atlassian.jira.ComponentManager.registerComponents(ComponentManager.java:377)
	at com.atlassian.jira.ComponentManager.initialise(ComponentManager.java:233)
	at com.atlassian.jira.ComponentManager.<init>(ComponentManager.java:221)
	at com.atlassian.jira.ComponentManager.<clinit>(ComponentManager.java:207)
	at com.atlassian.jira.upgrade.ConsistencyLauncher.contextInitialized(ConsistencyLauncher.java:25)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3669)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4104)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
	at org.apache.catalina.core.StandardService.start(StandardService.java:450)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
2005-10-14 14:13:14,969 ERROR [ContainerBase.[Standalone].[localhost].[/jira]] Exception sending context initialized event to listener instance of class com.atlassian.jira.upgrade.ConsistencyLauncher
java.lang.NullPointerException
	at com.atlassian.jira.ComponentManager.quickStart(ComponentManager.java:255)
	at com.atlassian.jira.ComponentManager.start(ComponentManager.java:242)
	at com.atlassian.jira.upgrade.ConsistencyLauncher.contextInitialized(ConsistencyLauncher.java:25)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3669)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4104)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
	at org.apache.catalina.core.StandardService.start(StandardService.java:450)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
2005-10-14 14:13:15,090 ERROR [ContainerBase.[Standalone].[localhost].[/jira]] Exception sending context initialized event to listener instance of class com.atlassian.jira.upgrade.UpgradeLauncher
java.lang.NullPointerException
	at com.atlassian.jira.ManagerFactory.getApplicationProperties(ManagerFactory.java:177)
	at com.atlassian.jira.util.JiraLicenseRegistry.getAppProperties(JiraLicenseRegistry.java:21)
	at com.atlassian.jira.util.JiraLicenseRegistry.getLicenseHash(JiraLicenseRegistry.java:41)
	at com.atlassian.jira.web.action.util.JiraLicenseUtils.isLicenseSetup(JiraLicenseUtils.java:167)
	at com.atlassian.jira.appconsistency.BuildAndLicenseEventCheck.doCheck(BuildAndLicenseEventCheck.java:48)
	at com.atlassian.jira.appconsistency.BuildAndLicenseEventCheck.check(BuildAndLicenseEventCheck.java:42)
	at com.atlassian.jira.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:45)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3669)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4104)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
	at org.apache.catalina.core.StandardService.start(StandardService.java:450)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)


 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
[ Permalink | « Hide ]
Jeff Turner [Atlassian] added a comment - 13/Oct/05 11:45 PM
The 3.2.0-alpha driver works.

[ Permalink | « Hide ]
Dirk Tiemeyer added a comment - 19/Oct/05 09:33 AM
We had the same issue at our installation.
This is a little bit tricky, because the link to the latest version is MySQL Connector/J JDBC is also part of the Installation document and there is no hint, to this issue.

When we go back to an older version of the MySQL Connector/J JDBC it works fine like discribed in this issue.


[ Permalink | « Hide ]
Gili added a comment - 19/Oct/05 12:02 PM
Just curious if anyone has reported this bug to the Connector/J author.

[ Permalink | « Hide ]
Jeff Turner [Atlassian] added a comment - 19/Oct/05 07:17 PM
The installation docs now point to the 3.2 driver, and note the problem. It hasn't been reported to MySQL since it is fixed in 3.2, and a bug report more useful than "metadata reading is broken" would take a lot of time.

[ Permalink | « Hide ]
Gili added a comment - 19/Oct/05 07:23 PM
Well, I filed an issue just in case they're not aware of it: http://bugs.mysql.com/bug.php?id=14162

[ Permalink | « Hide ]
Gili added a comment - 20/Oct/05 12:38 AM
BTW, I wouldn't recommend Connector/J 3.2 to end-users. It broke Roller Weblog for me and who knows what else it might break. This isn't surprising given its alpha status.

I would recommend you link users to the Connector/J 3.1.10 which works for me. I found a copy here: http://mysql.mirror.rafal.ca/Downloads/Connector-J/


[ Permalink | « Hide ]
Jeff Turner [Atlassian] added a comment - 20/Oct/05 01:07 AM
Okay, we'll deep-link to the zip and tar.gz for 3.1.10. Thanks for the note.

[ Permalink | « Hide ]
Gili added a comment - 27/Oct/05 10:59 AM
The MySQL guys cannot reproduce this issue and have requested a testcase, but this is beyond my abilities. Can someone from the JIRA team help them reproduce this? The link to the MySQL bug can be found above.

[ Permalink | « Hide ]
Jeff Turner [Atlassian] added a comment - 27/Oct/05 10:12 PM
I have added a comment on the MySQL bug report.

[ Permalink | « Hide ]
Anton Mazkovoi [Atlassian] added a comment - 07/Nov/05 11:43 PM
Provided a test case for MySQL developers on http://bugs.mysql.com/bug.php?id=14162

Hopefully that will help.


[ Permalink | « Hide ]
Chris Wood added a comment - 01/Dec/05 08:45 PM
This appears to have been fixed with http://bugs.mysql.com/bug.php?id=14815 ,
the problem is not evident in the latest connector J build, 3.1.12

[ Permalink | « Hide ]
Nick Menere [Atlassian] added a comment - 01/Dec/05 09:19 PM
Thanks for the info Chris.
We will let you know if any issues come up.

Cheers,
Nick


[ Permalink | « Hide ]
Jeff Turner [Atlassian] added a comment - 07/Dec/05 08:27 PM
Confirmed; 3.1.12 works.


Powered by Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13.4-#354) - Bug/feature request - Atlassian news - Contact Administrators