SQL Exception while Installing JIRA Due to Database Encoding

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

Was this helpful?

Thanks for your feedback!

Why was this unhelpful?

Have a question about this article?

See questions about this article

Powered by Confluence and Scroll Viewport