SQL Exception while Installing JIRA Due to Database Encoding

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

While installing JIRA for first time, the following error appears in the atlassian-jira.log:

SQL Exception while executing the following:INSERT INTO changeitem (ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data truncated for column 'NEWSTRING' at row 1))

Cause

The database wasn't set to UTF-8 character encoding during creation.

Resolution

Recreate the JIRA database as UTF-8, and re-install JIRA:

 
  1. Backup the existing data
  2. Create a new database with the following command:

    CREATE DATABASE jiradb CHARACTER SET utf8;
    
  3. Point JIRA to new database and restart JIRA
  4. Restore the existing backup XML

Last modified on Mar 30, 2016

Was this helpful?

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