Crucible 2.3 : Problems with very long comments and MySQL migration
This page last changed on Feb 09, 2010 by edawson.
Affects VersionThis issue was introduced in Crucible 2.0 and fixed in Crucible 2.1. Issue SymptomsThere is a known issue with Crucible 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 MySQL 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
For more information, see the JIRA issue. WorkaroundIf your data contains very long comments or review descriptions (longer than 21,845 multibyte unicode characters), consider avoiding use of MySQL until you can upgrade the product. Alternatively, use PostgreSQL or the default (built-in) HSQLDB database. This issue is now resolved. This issue was introduced in Crucible 2.0 and fixed in Crucible 2.1. Requesting SupportIf you require assistance in resolving the problem, please raise a support request under the Crucible project. |
![]() |
Document generated by Confluence on Jul 29, 2010 20:01 |