JIRA Deployment Fails with MySQL 4.1.x on Ubuntu

Still need help?

The Atlassian Community is here for you.

Ask the community


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))


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


  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:

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

Last modified on Apr 7, 2016

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.