Problems with very long comments and MySQL migration

Issue Symptoms

There is a known issue with Fisheye 2.0.x and very long comments when migrating your database to MySQL.In some circumstances, this might result in truncation of very long comments, causing data loss.

Depending on your configuration, you may see an error message like this while migrating to MySQL, causing the migration to fail:

2009-07-16 16:56:12,390 ERROR [ThreadPool1] fisheye.app com.cenqua.crucible.actions.admin.database.DBEditHelper-doGet - 
Database migration failed: 
java.sql.BatchUpdateException: Data truncation: Data too long for column 'cru_message' at row 1 
java.sql.BatchUpdateException: Data truncation: Data too long for column 'cru_message' at row 1

(info) You may not see the message if you are running MySQL with default settings.

For more information, see the Jira issue.

Workaround

If your data contains very long comments or review descriptions (longer than 21,845 multibyte unicode characters), consider avoiding use of MySQL until this issue is resolved fully. Alternatively, use PostgreSQL or the default (built-in) HSQLDB database.

The Fisheye developers are actively working on a solution to this problem and it will be addressed in an upcoming Fisheye point release.

Requesting Support

If you require assistance in resolving the problem, please raise a support request under the Fisheye project.

Last modified on Oct 25, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.