SQL Exception while Installing JIRA Due to Database Encoding
症状
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))
原因
The database wasn't set to UTF-8 character encoding during creation.
ソリューション
Recreate the JIRA database as UTF-8, and re-install JIRA:
- Backup the existing data
Create a new database with the following command:
CREATE DATABASE jiradb CHARACTER SET utf8;- Point JIRA to new database and restart JIRA
- Restore the existing backup XML
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.