[xwiki-users] Data too long for column 'XWV_UNIQUE_ID' error on save visit statictics
Hello, Recently I have enabled statistics module which works pretty nice. One thing though I have noticed in xwiki log file is the following exception occurring periodically
2010-04-28 23:35:34,679 [http://myhost/xwiki/bin/view/MySpace/] [Statistics storing daemon] ERROR xwiki.DocumentStatsStoreItem - Failed to save visit statictics object [class com.xpn.xwiki.stats.impl.xwiki.VisitStatsStoreItem XWiki.XWikiGuest 209.47.111.5Mozilla/4.0 (compatible; MSIE 8.0; Wind ows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; InfoPath.2; .NET CLR 3.0.4506.2152; .NET CLR 3. 5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0) 7WR28YZF6YHUMMIUZKZJ96HUOWDAFLSK] 2010-04-28 23:35:51,141 [http://myhost/xwiki/bin/view/MySpace/] [Statistics storing daemon] WARN util.JDBCExceptionReporter - SQL Err or: 0, SQLState: 22001 2010-04-28 23:35:51,141 [http://myhost/xwiki/bin/view/MySpace/] [Statistics storing daemon] ERROR util.JDBCExceptionReporter - Data tr uncation: Data too long for column 'XWV_UNIQUE_ID' at row 1 2010-04-28 23:35:51,141 [http://myhost/xwiki/bin/view/MySpace/] [Statistics storing daemon] ERROR .AbstractFlushingEventListener - Could n ot synchronize database state with session org.hibernate.exception.DataException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:855) at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:826) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiCollection(XWikiHibernateStore.java:999) at com.xpn.xwiki.stats.impl.xwiki.VisitStatsStoreItem.storeInternal(VisitStatsStoreItem.java:110) at com.xpn.xwiki.stats.impl.xwiki.AbstractStatsStoreItem.store(AbstractStatsStoreItem.java:99) at com.xpn.xwiki.stats.impl.xwiki.XWikiStatsStoreService.register(XWikiStatsStoreService.java:167) at com.xpn.xwiki.stats.impl.xwiki.XWikiStatsStoreService.runInternal(XWikiStatsStoreService.java:119) at com.xpn.xwiki.util.AbstractXWikiRunnable.run(AbstractXWikiRunnable.java:99) at java.lang.Thread.run(Thread.java:636) Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'XWV_UNIQUE_ID' at row 1 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1669) at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1085) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) ... 16 more
Could someone tell if it's a serious issue and which type of error it identifies: configuration error or bug in statistics module? We are running XWiki Enterprise 2.2.4.28034 Regards, Roman -- View this message in context: http://xwiki.475771.n2.nabble.com/Data-too-long-for-column-XWV-UNIQUE-ID-err... Sent from the XWiki- Users mailing list archive at Nabble.com.
participants (1)
-
coldserenity