Hi all,
After migrating my XE from 2.x to 3.1, I get a bunch of these errors in my
logs : "[Statistics storing daemon] ERROR o.h.u.JDBCExceptionReporter -
Data truncation: Data too long for column 'XWV_IP' at row 1"
I suppose it's a change in the statistics related tables ...
What should I do to remove these errors ?
Full stack trace :
2011-09-14 16:11:50,551 [Statistics storing daemon] ERROR
o.h.u.JDBCExceptionReporter - Data truncation: Data too long for column
'XWV_IP' at row 1
2011-09-14 16:11:50,551 [Statistics storing daemon] ERROR
.AbstractFlushingEventListener - Could not synchronize database state with
session
org.hibernate.exception.DataException: Could not execute JDBC batch update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
[hibernate-3.2.6.ga.jar:3.2.6.ga]
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
[hibernate-3.2.6.ga.jar:3.2.6.ga]
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
[hibernate-3.2.6.ga.jar:3.2.6.ga]
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
[hibernate-3.2.6.ga.jar:3.2.6.ga]
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:871)
[xwiki-platform-oldcore-3.1.jar:na]
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:842)
[xwiki-platform-oldcore-3.1.jar:na]
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiCollection(XWikiHibernateStore.java:1054)
[xwiki-platform-oldcore-3.1.jar:na]
at
com.xpn.xwiki.stats.impl.xwiki.VisitStatsStoreItem.storeInternal(VisitStatsStoreItem.java:112)
[xwiki-platform-oldcore-3.1.jar:na]
at
com.xpn.xwiki.stats.impl.xwiki.AbstractStatsStoreItem.store(AbstractStatsStoreItem.java:99)
[xwiki-platform-oldcore-3.1.jar:na]
at
com.xpn.xwiki.stats.impl.xwiki.XWikiStatsStoreService.register(XWikiStatsStoreService.java:167)
[xwiki-platform-oldcore-3.1.jar:na]
at
com.xpn.xwiki.stats.impl.xwiki.XWikiStatsStoreService.runInternal(XWikiStatsStoreService.java:119)
[xwiki-platform-oldcore-3.1.jar:na]
at
com.xpn.xwiki.util.AbstractXWikiRunnable.run(AbstractXWikiRunnable.java:99)
[xwiki-platform-oldcore-3.1.jar:na]
at java.lang.Thread.run(Thread.java:619) [na:1.6.0_11]
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for
column 'XWV_IP' at row 1
at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
~[mysql-connector-java-5.1.10-bin.jar:na]
at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)
~[mysql-connector-java-5.1.10-bin.jar:na]
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
~[commons-dbcp-1.3.jar:1.3]
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
~[commons-dbcp-1.3.jar:1.3]
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
~[commons-dbcp-1.3.jar:1.3]
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
... 16 common frames omitted
Thanks !
Jeremie.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Data-too-long-for-column-XWV-IP-tp6792700…
Sent from the XWiki- Users mailing list archive at
Nabble.com.