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-error-on-save-visit-statictics-tp4980842p4980842.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
