Data too long for column error during Crowd Upgrade
症状
Crowd upgrade from 1.X to 2.X is failing with errors:
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'display_name' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
原因
The database schema changed in Crowd 2.0. There may be some columns with excessively long values that will not fit into the new schema.
ソリューション
This is usually not a problem as most names are not long enough to cause this problem. Check for any extremely long data values, particularly in the column referenced in the error.
最終更新日 2012 年 11 月 21 日
Powered by Confluence and Scroll Viewport.