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: