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 [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)

原因

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.


最終更新日: 2020 年 12 月 2 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.