[#JRA-8468] JIRA 3.4 does not work with MySQL and MS SQL Server

JIRA

JIRA 3.4 does not work with MySQL and MS SQL Server

Created: 10/Nov/05 03:23 AM Updated: 30/Jul/06 07:37 PM

Component/s:

Installation

Affects Version/s:

3.4

Fix Version/s:

3.4.1

Time Tracking:

Not Specified

Participants:	Anton Mazkovoi [Atlassian], David Fischer and Shannon Krebs
Since last comment:	2 years, 47 weeks, 2 days ago
Resolution Date:	10/Nov/05 04:01 PM
Labels:

Description

« Hide

When starting JIRA 3.4 with MySQL JIRA throws a lot of exceptions such as:

org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ListenerConfig]
[clazz,com.atlassian.jira.event.listeners.cache.IssueCacheListener][name,Issue Cache Listener][id,null]
(SQL Exception while executing the following:
INSERT INTO listenerconfig (ID, CLAZZ, listenername) VALUES (?, ?, ?) (Column 'ID' cannot be null))
        at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:123)
        at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)
        at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63)
        at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470)

To fix the problem in JIRA Standalone please download http://repository.atlassian.com/ofbcore/jars/ofbcore-entity-2.1.1-atlassian-08Nov05.jar and replace the atlassian-jira/WEB-INF/lib/ofbcore-entity-2.1.1-atlassian-04Nov05.jar under the JIRA web application with the downloaded ofbcore-entity-2.1.1-atlassian-08Nov05.jar.

If using the webapp distribution of JIRA (i.e. not standalone) replare webapp/WEB-INF/lib/ofbcore-entity-2.1.1-atlassian-04Nov05.jar with the downloaded file before running build.bat or build.sh.

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

David Fischer added a comment - 10/Nov/05 11:10 AM

FYI, the same bug (and fix) applies to MS SQL Server 2000

[ Permlink | « Hide ]

Anton Mazkovoi [Atlassian] added a comment - 10/Nov/05 04:01 PM

Thanks for the note. This will be fixed in JIRA 3.4.1.

[ Permlink | « Hide ]

Shannon Krebs added a comment - 10/Nov/05 04:40 PM

We also noticed a similar error when trying to run 3.4 on mysql. The cause seems to be related to this line:

[ofbiz.core.entity.SequenceUtil] Can't call commit when autocommit=true

After adding '&relaxAutoCommit=true' to the database url as mentioned in ~~CONF-1710~~ this problem went away as did the rest of the sql errors.