Re: [xwiki-users] Data too long for column 'XWV_UNIQUE_ID' error on save visit statictics

2014-02-28 Thread Maxime Sinclair 
Good to read it was fixed in 5.1.
Thanks for your quick answer.
Maxime


2014-02-28 10:18 GMT+01:00 vinc...@massol.net :

> Hi Maxime,
>
> AFAIR it's because the user-agent string is too large.
>
> This was fixed a while ago, see http://jira.xwiki.org/browse/XWIKI-8937
>
> Thanks
> -Vincent
>
>
> On 28 Feb 2014 at 10:13:32, Maxime Sinclair (maxime.sincl...@gmail.com
> (mailto:maxime.sincl...@gmail.com)) wrote:
>
> > Hello,
> >
> > A new error message just appeared in the logs of my xwiki instance (3.5).
> > This is the message :
> > 2014-02-27 18:06:49,307 [Statistics storing daemon] ERROR
> > .x.x.s.i.x.VisitStatsStoreItem - Failed to save visit statistics object
> > [class com.xpn.xwiki.stats.impl.xwiki.VisitStatsStoreItem
> XWiki.XWikiGuest
> > 10.210.105.105Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64;
> > Trident/7.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR
> > 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; InfoPath.1; Microsoft
> > Outlook 14.0.7109; ms-office; MSOffice 14)
> > PFEBDVUTJS84C531ZDS26WMNMKJWK1EQ]
> >
> > It seems this is an old issue, see:
> > http://xwiki.markmail.org/thread/sob63ol6csslbfqs
> >
> > But I find nothing in Jira about this subject. Do I have to create one ?
> Is
> > this issue still present in the last version of XWiki ?
> >
> > Thanks for your advice.
> >
> > Maxime
>
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Data too long for column 'XWV_UNIQUE_ID' error on save visit statictics

2014-02-28 Thread vinc...@massol.net 
Hi Maxime,

AFAIR it’s because the user-agent string is too large.

This was fixed a while ago, see http://jira.xwiki.org/browse/XWIKI-8937

Thanks
-Vincent


On 28 Feb 2014 at 10:13:32, Maxime Sinclair 
(maxime.sincl...@gmail.com(mailto:maxime.sincl...@gmail.com)) wrote:

> Hello,
>  
> A new error message just appeared in the logs of my xwiki instance (3.5).
> This is the message :
> 2014-02-27 18:06:49,307 [Statistics storing daemon] ERROR
> .x.x.s.i.x.VisitStatsStoreItem - Failed to save visit statistics object
> [class com.xpn.xwiki.stats.impl.xwiki.VisitStatsStoreItem XWiki.XWikiGuest
> 10.210.105.105Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64;
> Trident/7.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR
> 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; InfoPath.1; Microsoft
> Outlook 14.0.7109; ms-office; MSOffice 14)
> PFEBDVUTJS84C531ZDS26WMNMKJWK1EQ]
>  
> It seems this is an old issue, see:
> http://xwiki.markmail.org/thread/sob63ol6csslbfqs
>  
> But I find nothing in Jira about this subject. Do I have to create one ? Is
> this issue still present in the last version of XWiki ?
>  
> Thanks for your advice.
>  
> Maxime

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

[xwiki-users] Data too long for column 'XWV_UNIQUE_ID' error on save visit statictics

2014-02-28 Thread Maxime Sinclair 
Hello,

A new error message just appeared in the logs of my xwiki instance (3.5).
This is the message :
2014-02-27 18:06:49,307 [Statistics storing daemon] ERROR
.x.x.s.i.x.VisitStatsStoreItem - Failed to save visit statistics object
[class com.xpn.xwiki.stats.impl.xwiki.VisitStatsStoreItem XWiki.XWikiGuest
10.210.105.105Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64;
Trident/7.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR
3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; InfoPath.1; Microsoft
Outlook 14.0.7109; ms-office; MSOffice 14)
PFEBDVUTJS84C531ZDS26WMNMKJWK1EQ]

It seems this is an old issue, see:
http://xwiki.markmail.org/thread/sob63ol6csslbfqs

But I find nothing in Jira about this subject. Do I have to create one ? Is
this issue still present in the last version of XWiki ?

Thanks for your advice.

Maxime
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

[xwiki-users] Data too long for column 'XWV_UNIQUE_ID' error on save visit statictics

2010-04-29 Thread coldserenity 

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