Symptoms

JIRA fails to create MySQL tables on Ubuntu. The following appears in the atlassian-jira.log:

org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:OSPropertyEntry][propertyKey,jira.i18n.language.index][type,5][id,10000][entityName,jira.properties][entityId,1] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (Incorrect arguments to mysql_stmt_execute))

Cause

This is due to an Ubuntu/Debian packaging problem. It's also discussed on Atlassian's forums.

Resolution

1. Edit the following section in your server.xml:

   <Context docBase="${catalina.home}/atlassian-jira" path="" reloadable="false">
             <Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="20" name="jdbc/JiraDS" password="Eet4Vape" type="javax.sql.DataSource" url="jdbc:mysql://localhost/jiradb?useUnicode=true&amp;characterEncoding=UTF8" username="jirauser"/>
   

   Edit the section that starts with "url=" and append 'useServerPrepStmts=false' So that the JDBC URL looks like the following:

   url"jdbc:mysql://localhost/jiradb?useServerPrepStmts=false"
   

2. Restart of JIRA for the changes to take effect.