Hi,
I've been using xwiki for a month now without problems. I use it as an
internal tool with less than 5 users.
Yesterday I have started to have some problems when saving pages. When
I write a add text to an existing page or I write a new page I often
(not always) have the following error:
Error number 3201 in 3: Exception while saving document Projects.xwikiPb
Wrapped Exception: Could not execute JDBC batch update
com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while
saving document Projects.xwikiPb
Wrapped Exception: Could not execute JDBC batch update
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java:540)
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java:557)
at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77
)
at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:560)
at com.xpn.xwiki.XWikiService.actionSave(XWikiService.java:445)
at
com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:155)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:421)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
226)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi
ngFilter.java:127)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
at java.lang.Thread.run(Unknown Source)
Wrapped Exception:
java.sql.BatchUpdateException: Data truncation: Data too long for column
'XWD_CONTENT' at row 1
at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.
java:1103)
at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:853
)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingState
ment.java:294)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingState
ment.java:294)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:5
7)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:172
)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
AbstractFlushingEventListener.java:274)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEv
entListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:726)
at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:320)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86
)
at
com.xpn.xwiki.store.XWikiHibernateStore.endTransaction(XWikiHibernateSto
re.java:350)
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java:535)
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java:557)
at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77
)
at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:560)
at com.xpn.xwiki.XWikiService.actionSave(XWikiService.java:445)
at
com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:155)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:421)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
226)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi
ngFilter.java:127)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
at java.lang.Thread.run(Unknown Source)
Nonetheless the exception I can edit and view the page. When I edit it,
I have a similar exception but for the XWD_ARCHIVE column
When I delete the page I have another exception saying that the page
does not exist even thought it is still displayed
When I restart Tomcat, the page is really deleted.
I am using:
- Tomcat 5.0 (same problems with Tomcat 5.5)
- MySql 5.0 (I check tables for corruption with mysql administrator and
everything seems fine)
I tried the following to solve my problem without success:
- I already configured xwiki to support large attachments.
- I modified the hibernate.cgf file with the useServerPrepStmts=false
option
- I tried with mysql 5.0 driver
- I checked for resource usage
Thanks for any help.
Frederic Aymard
Hi All,
I am currently looking to use an object of this type to designate users
in my class. Getting the users is not much of a problem; however what
is a bit of a problem is how I want to use the user list in my select
element: I'd like to show user's firstname and lastname BUT store only
the users login (iow use the .value and .text assignment seperately in
the generated select list). This new class would normally appear
multiple times in another class (similar to a Comment object but with
selectable users).
Has anyone done something similar, or got any idea's on an alternative?
[current query used in the object:
select firstname.value || ' ' || lastname.value from BaseObject obj,
StringProperty firstname, StringProperty lastname where
obj.className='XWiki.XWikiUsers' and firstname.id.id=obj.id and
lastname.id.id=obj.id and firstname.name='first_name' and
lastname.name='last_name' and firstname.value <> 'XWiki' order by
firstname.value
]
Brandon Esbach
Software Engineer
M/A-Com Eurotec Operations
LoughMahon Technology Park,
Skehard Road,
Blackrock,
Cork, Ireland
Tel +353 21 4808305
Hi
Is there a way to add all groovy function definition to a specific page,
as we do for velocity macros?
I can't find an example for that. Thank you.
Marc Lijour
