Could not save the build results. Data too long for column
When Bamboo is starting, it fails to write to the Database and throws the error message below in atlassian-bamboo.log:
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 ; error code ; 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)
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:
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".
Recreate Database with UTF8 encoding as explained in the MySQL installation documentation.