«

Feb 04

Problems moving a JIRA installation from Windows to Linux

If your JIRA install is broken and you are getting many messages in your atlassian-jira.log after doing a restore of your mysql db from a Windows server to a Linux server it’s possible you may have the problem I encountered today.

In the logs I saw many messages indicating that mysql had failed to to make inserts. Googling around many people were suggesting that this was due to mysql running out of connections, but I was seeing these from startup, so that was probably not the cause here.

Example:

2013-01-30 13:00:29,574 main ERROR [module.propertyset.ofbiz.OFBizPropertySet] Error setting value in PropertySet
org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:OSPropertyEntry][id,null][entityId,1][propertyKey,com.atlassian.activeobjects.admin.ActiveObjectsPluginToTablesMapping]
[type,6][entityName,jira.properties] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (Column '
ID' cannot be null))

On Windows mysql identifiers (tables, alias, etc.) are, by default, not case sensitive and in linux the opposite is true. My problems mainly came when JIRA was trying to generate new IDs for objects being inserted into the database. The sequence_value_item table was being called by SEQUENCE_VALUE_ITEM, which mysql on the ubuntu server I was using, could not find.

For a quick fix stick the following in your mysql my.cnf

# Somewhere in the [mysqld] section
lower_case_table_names=1

This will make all identifiers in queries non case sensitive for all databases on the mysql server. You can also do this per db, but I’ll leave that to you if you want to that.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>