Re: [xwiki-users] about "big" attachments

27 Apr 2008

      Hi,

Yep, this is known, see
http://jira.xwiki.org/jira/browse/XWIKI-2339

The solution is to replace mediumblob by longblob in your DB for the  
XWA_ARCHIVE column.

Thanks
-Vincent

On Apr 27, 2008, at 11:06 AM, [Ricardo Rodriguez] Your EPEC Network  
ICT Team wrote:
...
Hi all,
Working with not updated 1.3.8295 (I would like to avoid to update it
right now, if possible) I have received an error message while  
attaching
a "big" (around 13Mb) file. This error read:
*****
2008-04-27 10:24:58,604
[http://xpescaderias.environmentalchange.net/xwiki/bin/upload/Main/VideoPromo... 
]
[http-193.144.34.240-80-9] WARN  web.XWikiAction                 -
Uncaught exception: Error number 3232 in 3: Exception while saving
attachment pescaderiasLongo.wmv of document Main.VideoPromocional
Wrapped Exception: Could not execute JDBC batch update
com.xpn.xwiki.XWikiException: Error number 3232 in 3: Exception while
saving attachment pescaderiasLongo.wmv of document  
Main.VideoPromocional
Wrapped Exception: Could not execute JDBC batch update
   at
com 
.xpn 
.xwiki 
.store 
.XWikiHibernateAttachmentStore 
.saveAttachmentContent(XWikiHibernateAttachmentStore.java:99)
   at
com 
.xpn 
.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 
2517)
   at
com 
.xpn 
.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 
2499)
   at com.xpn.xwiki.web.UploadAction.action(UploadAction.java:129)
   at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:188)
   at
org 
.apache 
.struts 
.action.RequestProcessor.processActionPerform(RequestProcessor.java: 
431)
   at
org 
.apache.struts.action.RequestProcessor.process(RequestProcessor.java: 
236)
   at
org.apache.struts.action.ActionServlet.process(ActionServlet.java: 
1196)
   at  
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
   at
org 
.apache 
.catalina 
.core 
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
290)
   at
org 
.apache 
.catalina 
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at
com 
.xpn 
.xwiki 
.web 
.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java: 
117)
   at
org 
.apache 
.catalina 
.core 
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
235)
   at
org 
.apache 
.catalina 
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at
org 
.apache 
.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 
228)
   at
org 
.apache 
.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 
175)
   at
org 
.apache 
.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at
org 
.apache 
.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
   at
org 
.apache 
.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 
109)
   at
org 
.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 
216)
   at
org 
.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 
844)
   at
org.apache.coyote.http11.Http11Protocol 
$Http11ConnectionHandler.process(Http11Protocol.java:634)
   at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 
445)
   at java.lang.Thread.run(Unknown Source)
Wrapped Exception:
java.sql.BatchUpdateException: Data truncation: Data too long for  
column
'XWA_ARCHIVE' 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)
   at
org 
.hibernate 
.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
   at
org 
.hibernate 
.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
   at
org 
.hibernate 
.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
   at
org 
.hibernate 
.persister 
.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java: 
2224)
   at
org 
.hibernate 
.persister 
.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java: 
2660)
   at
org 
.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java: 
56)
   at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
   at  
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
   at  
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
   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: 
778)
   at
com 
.xpn 
.xwiki 
.store 
.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java: 
749)
   at
com 
.xpn 
.xwiki 
.store 
.XWikiHibernateAttachmentStore 
.saveAttachmentContent(XWikiHibernateAttachmentStore.java:94)
   at
com 
.xpn 
.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 
2517)
   at
com 
.xpn 
.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 
2499)
   at com.xpn.xwiki.web.UploadAction.action(UploadAction.java:129)
   at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:188)
   at
org 
.apache 
.struts 
.action.RequestProcessor.processActionPerform(RequestProcessor.java: 
431)
   at
org 
.apache.struts.action.RequestProcessor.process(RequestProcessor.java: 
236)
   at
org.apache.struts.action.ActionServlet.process(ActionServlet.java: 
1196)
   at  
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
   at
org 
.apache 
.catalina 
.core 
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
290)
   at
org 
.apache 
.catalina 
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at
com 
.xpn 
.xwiki 
.web 
.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java: 
117)
   at
org 
.apache 
.catalina 
.core 
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
235)
   at
org 
.apache 
.catalina 
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at
org 
.apache 
.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 
228)
   at
org 
.apache 
.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 
175)
   at
org 
.apache 
.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at
org 
.apache 
.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
   at
org 
.apache 
.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 
109)
   at
org 
.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 
216)
   at
org 
.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 
844)
   at
org.apache.coyote.http11.Http11Protocol 
$Http11ConnectionHandler.process(Http11Protocol.java:634)
   at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 
445)
   at java.lang.Thread.run(Unknown Source)
*****
In spite of this message, the document seems has been correctly
attached. After this action, I've attached a new file and got:
*****
2008-04-27 10:28:59,810
[http://xpescaderias.environmentalchange.net/xwiki/bin/upload/Main/VideoPromo... 
]
[http-193.144.34.240-80-9] ERROR jdbc.AbstractBatcher            -
Exception executing batch:
org.hibernate.StaleStateException: Batch update returned unexpected  
row
count from update [1]; actual row count: 0; expected: 1
   at
org.hibernate.jdbc.Expectations 
$BasicExpectation.checkBatched(Expectations.java:61)
   at
org.hibernate.jdbc.Expectations 
$BasicExpectation.verifyOutcome(Expectations.java:46)
   at
org 
.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java: 
68)
   at
org 
.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java: 
48)
   at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java: 
246)
   at
org 
.hibernate 
.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
   at
org 
.hibernate 
.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
   at
org 
.hibernate 
.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
   at
org 
.hibernate 
.persister 
.entity.AbstractEntityPersister.update(AbstractEntityPersister.java: 
2354)
   at
org 
.hibernate 
.persister 
.entity 
.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java: 
2307)
   at
org 
.hibernate 
.persister 
.entity.AbstractEntityPersister.update(AbstractEntityPersister.java: 
2607)
   at
org 
.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java: 
92)
   at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
   at  
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
   at  
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
   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: 
778)
   at
com 
.xpn 
.xwiki 
.store 
.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java: 
749)
   at
com 
.xpn 
.xwiki 
.store 
.XWikiHibernateAttachmentStore 
.saveAttachmentContent(XWikiHibernateAttachmentStore.java:94)
   at
com 
.xpn 
.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 
2517)
   at
com 
.xpn 
.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 
2499)
   at com.xpn.xwiki.web.UploadAction.action(UploadAction.java:129)
   at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:188)
   at
org 
.apache 
.struts 
.action.RequestProcessor.processActionPerform(RequestProcessor.java: 
431)
   at
org 
.apache.struts.action.RequestProcessor.process(RequestProcessor.java: 
236)
   at
org.apache.struts.action.ActionServlet.process(ActionServlet.java: 
1196)
   at  
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
   at
org 
.apache 
.catalina 
.core 
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
290)
   at
org 
.apache 
.catalina 
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at
com 
.xpn 
.xwiki 
.web 
.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java: 
117)
   at
org 
.apache 
.catalina 
.core 
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
235)
   at
org 
.apache 
.catalina 
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at
org 
.apache 
.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 
228)
   at
org 
.apache 
.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 
175)
   at
org 
.apache 
.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at
org 
.apache 
.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
   at
org 
.apache 
.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 
109)
   at
org 
.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 
216)
   at
org 
.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 
844)
   at
org.apache.coyote.http11.Http11Protocol 
$Http11ConnectionHandler.process(Http11Protocol.java:634)
   at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 
445)
   at java.lang.Thread.run(Unknown Source)
2008-04-27 10:28:59,811
[http://xpescaderias.environmentalchange.net/xwiki/bin/upload/Main/VideoPromo... 
]
[http-193.144.34.240-80-9] ERROR .AbstractFlushingEventListener  -  
Could
not synchronize database state with session
org.hibernate.StaleStateException: Batch update returned unexpected  
row
count from update [1]; actual row count: 0; expected: 1
   at
org.hibernate.jdbc.Expectations 
$BasicExpectation.checkBatched(Expectations.java:61)
   at
org.hibernate.jdbc.Expectations 
$BasicExpectation.verifyOutcome(Expectations.java:46)
   at
org 
.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java: 
68)
   at
org 
.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java: 
48)
   at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java: 
246)
   at
org 
.hibernate 
.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
   at
org 
.hibernate 
.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
   at
org 
.hibernate 
.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
   at
org 
.hibernate 
.persister 
.entity.AbstractEntityPersister.update(AbstractEntityPersister.java: 
2354)
   at
org 
.hibernate 
.persister 
.entity 
.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java: 
2307)
   at
org 
.hibernate 
.persister 
.entity.AbstractEntityPersister.update(AbstractEntityPersister.java: 
2607)
   at
org 
.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java: 
92)
   at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
   at  
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
   at  
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
   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: 
778)
   at
com 
.xpn 
.xwiki 
.store 
.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java: 
749)
   at
com 
.xpn 
.xwiki 
.store 
.XWikiHibernateAttachmentStore 
.saveAttachmentContent(XWikiHibernateAttachmentStore.java:94)
   at
com 
.xpn 
.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 
2517)
   at
com 
.xpn 
.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 
2499)
   at com.xpn.xwiki.web.UploadAction.action(UploadAction.java:129)
   at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:188)
   at
org 
.apache 
.struts 
.action.RequestProcessor.processActionPerform(RequestProcessor.java: 
431)
   at
org 
.apache.struts.action.RequestProcessor.process(RequestProcessor.java: 
236)
   at
org.apache.struts.action.ActionServlet.process(ActionServlet.java: 
1196)
   at  
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
   at
org 
.apache 
.catalina 
.core 
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
290)
   at
org 
.apache 
.catalina 
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at
com 
.xpn 
.xwiki 
.web 
.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java: 
117)
   at
org 
.apache 
.catalina 
.core 
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
235)
   at
org 
.apache 
.catalina 
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at
org 
.apache 
.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 
228)
   at
org 
.apache 
.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 
175)
   at
org 
.apache 
.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at
org 
.apache 
.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
   at
org 
.apache 
.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 
109)
   at
org 
.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 
216)
   at
org 
.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 
844)
   at
org.apache.coyote.http11.Http11Protocol 
$Http11ConnectionHandler.process(Http11Protocol.java:634)
   at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 
445)
   at java.lang.Thread.run(Unknown Source)
2008-04-27 10:28:59,812
[http://xpescaderias.environmentalchange.net/xwiki/bin/upload/Main/VideoPromo... 
]
[http-193.144.34.240-80-9] WARN  web.XWikiAction                 -
Uncaught exception: Error number 3232 in 3: Exception while saving
attachment pdR.ppt of document Main.VideoPromocional
Wrapped Exception: Batch update returned unexpected row count from
update [1]; actual row count: 0; expected: 1
com.xpn.xwiki.XWikiException: Error number 3232 in 3: Exception while
saving attachment pdR.ppt of document Main.VideoPromocional
Wrapped Exception: Batch update returned unexpected row count from
update [1]; actual row count: 0; expected: 1
   at
com 
.xpn 
.xwiki 
.store 
.XWikiHibernateAttachmentStore 
.saveAttachmentContent(XWikiHibernateAttachmentStore.java:99)
   at
com 
.xpn 
.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 
2517)
   at
com 
.xpn 
.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 
2499)
   at com.xpn.xwiki.web.UploadAction.action(UploadAction.java:129)
   at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:188)
   at
org 
.apache 
.struts 
.action.RequestProcessor.processActionPerform(RequestProcessor.java: 
431)
   at
org 
.apache.struts.action.RequestProcessor.process(RequestProcessor.java: 
236)
   at
org.apache.struts.action.ActionServlet.process(ActionServlet.java: 
1196)
   at  
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
   at
org 
.apache 
.catalina 
.core 
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
290)
   at
org 
.apache 
.catalina 
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at
com 
.xpn 
.xwiki 
.web 
.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java: 
117)
   at
org 
.apache 
.catalina 
.core 
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
235)
   at
org 
.apache 
.catalina 
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at
org 
.apache 
.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 
228)
   at
org 
.apache 
.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 
175)
   at
org 
.apache 
.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at
org 
.apache 
.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
   at
org 
.apache 
.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 
109)
   at
org 
.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 
216)
   at
org 
.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 
844)
   at
org.apache.coyote.http11.Http11Protocol 
$Http11ConnectionHandler.process(Http11Protocol.java:634)
   at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 
445)
   at java.lang.Thread.run(Unknown Source)
Wrapped Exception:
org.hibernate.StaleStateException: Batch update returned unexpected  
row
count from update [1]; actual row count: 0; expected: 1
   at
org.hibernate.jdbc.Expectations 
$BasicExpectation.checkBatched(Expectations.java:61)
   at
org.hibernate.jdbc.Expectations 
$BasicExpectation.verifyOutcome(Expectations.java:46)
   at
org 
.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java: 
68)
   at
org 
.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java: 
48)
   at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java: 
246)
   at
org 
.hibernate 
.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
   at
org 
.hibernate 
.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
   at
org 
.hibernate 
.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
   at
org 
.hibernate 
.persister 
.entity.AbstractEntityPersister.update(AbstractEntityPersister.java: 
2354)
   at
org 
.hibernate 
.persister 
.entity 
.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java: 
2307)
   at
org 
.hibernate 
.persister 
.entity.AbstractEntityPersister.update(AbstractEntityPersister.java: 
2607)
   at
org 
.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java: 
92)
   at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
   at  
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
   at  
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
   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: 
778)
   at
com 
.xpn 
.xwiki 
.store 
.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java: 
749)
   at
com 
.xpn 
.xwiki 
.store 
.XWikiHibernateAttachmentStore 
.saveAttachmentContent(XWikiHibernateAttachmentStore.java:94)
   at
com 
.xpn 
.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 
2517)
   at
com 
.xpn 
.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 
2499)
   at com.xpn.xwiki.web.UploadAction.action(UploadAction.java:129)
   at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:188)
   at
org 
.apache 
.struts 
.action.RequestProcessor.processActionPerform(RequestProcessor.java: 
431)
   at
org 
.apache.struts.action.RequestProcessor.process(RequestProcessor.java: 
236)
   at
org.apache.struts.action.ActionServlet.process(ActionServlet.java: 
1196)
   at  
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
   at
org 
.apache 
.catalina 
.core 
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
290)
   at
org 
.apache 
.catalina 
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at
com 
.xpn 
.xwiki 
.web 
.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java: 
117)
   at
org 
.apache 
.catalina 
.core 
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
235)
   at
org 
.apache 
.catalina 
.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at
org 
.apache 
.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 
228)
   at
org 
.apache 
.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 
175)
   at
org 
.apache 
.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at
org 
.apache 
.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
   at
org 
.apache 
.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 
109)
   at
org 
.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 
216)
   at
org 
.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 
844)
   at
org.apache.coyote.http11.Http11Protocol 
$Http11ConnectionHandler.process(Http11Protocol.java:634)
   at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 
445)
   at java.lang.Thread.run(Unknown Source)
*****
Again, in spite of this message, the new file seems correctly attached
to the document.
I've found this http://jira.xwiki.org/jira/browse/XWIKI-1811. It seems
that upload_maxsize was already set to 32Mb last year. Or at least the
upload_maxsize was included by default in XWiki.XWikiPreferences  
class.
I can see the property, but I am not able to find the field in
Administration.
Please, does this any sense for you? What kind of issue I am facing
here? I don't know if this error could be "dangerous" for our database
integrity or we can survive with it.
Thank you so much for your help,
Ricardo
-- 
Ricardo Rodríguez
Your EPEC Network ICT Team
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] about "big" attachments

Vincent Massol