Could not save the build results. Data too long for column
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
When Bamboo is starting, it fails to write to the Database and throws the error message below in atlassian-bamboo.log:
1
2
3
Could not save the build results. Data could be in an inconsistent state.
(org.springframework.jdbc.UncategorizedSQLException : Hibernate operation: could not insert: com.atlassian.bamboo.commit.CommitImpl#18513988; uncategorized SQLException for SQL []; SQL state [01004]; error code [0]; Data truncation: Data too long for column 'COMMIT_COMMENT_CLOB' at row 1;
nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'COMMIT_COMMENT_CLOB' at row 1)
Cause
The database is likely using Non-UTF-8 character encoding. To check the Character set and collation for the database, run the following query on the database:
1
2
SELECT default_character_set_name, default_collation_name FROM information_schema.SCHEMATA
WHERE schema_name = "<database-name>";For character set, we expect "utf8" and for collation "utf8_bin".
Resolution
Recreate Database with UTF8 encoding as explained in the MySQL installation documentation.
Was this helpful?