The root cause is "Data truncation: Data too long for column 'XWS_VALUE' at row 1" which mean that some object in document "SDomain.HW_DEV.0_LIB.Components-CommercialPC.Library Description.WebHome" contain a short String field with a value longer than 255 characters. The error does give enough information to know which object or which field.
On Mon, Feb 22, 2016 at 7:38 AM, gervwyk <[email protected]> wrote: > After importing a large number of spaces in my wiki, my server through the > following error when browsing which causes browsing delays. > > 22016-02-19 17:11:04,982 > [http://192.168.0.35:8080/xwiki/bin/view/SDomain/HW_DEV/0_LIB/Components-CommercialPC/Library+Description/] > WARN o.h.u.JDBCExceptionReporter - SQL Error: 1406, SQLState: 22001 > 2016-02-19 17:11:04,983 > [http://192.168.0.35:8080/xwiki/bin/view/SDomain/HW_DEV/0_LIB/Components-CommercialPC/Library+Description/] > ERROR o.h.u.JDBCExceptionReporter - Data truncation: Data too long for > column 'XWS_VALUE' at row 1 > com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving > document xwiki:XWiki.Admin > at > com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:658) > at > com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:167) > at > com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:160) > at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1564) > at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1508) > at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1503) > at > org.xwiki.commons._CMP_WikiV3.script.PageBuilder.recentVisitedMiciUpdate(PageBuilder.java:2419) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280) > at > org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:369) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluateInternal(DefaultVelocityEngine.java:256) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:222) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:198) > at > org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:124) > at > org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:50) > at > org.xwiki.rendering.macro.script.AbstractScriptMacro.evaluateBlock(AbstractScriptMacro.java:286) > at > org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:182) > at > org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:58) > at > org.xwiki.rendering.internal.transformation.macro.MacroTransformation.transform(MacroTransformation.java:269) > at > org.xwiki.rendering.internal.transformation.DefaultRenderingContext.transformInContext(DefaultRenderingContext.java:183) > at > org.xwiki.rendering.internal.transformation.DefaultTransformationManager.performTransformations(DefaultTransformationManager.java:95) > at > org.xwiki.display.internal.DocumentContentDisplayer.display(DocumentContentDisplayer.java:253) > at > org.xwiki.display.internal.DocumentContentDisplayer.display(DocumentContentDisplayer.java:126) > at > org.xwiki.display.internal.DocumentContentDisplayer.display(DocumentContentDisplayer.java:56) > at > org.xwiki.display.internal.DefaultDocumentDisplayer.display(DefaultDocumentDisplayer.java:96) > at > org.xwiki.display.internal.DefaultDocumentDisplayer.display(DefaultDocumentDisplayer.java:39) > at > org.xwiki.sheet.internal.SheetDocumentDisplayer.display(SheetDocumentDisplayer.java:113) > at > org.xwiki.sheet.internal.SheetDocumentDisplayer.display(SheetDocumentDisplayer.java:50) > at > org.xwiki.display.internal.ConfiguredDocumentDisplayer.display(ConfiguredDocumentDisplayer.java:68) > at > org.xwiki.display.internal.ConfiguredDocumentDisplayer.display(ConfiguredDocumentDisplayer.java:42) > at > com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:1164) > at > com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:1127) > at > com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:1179) > at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:692) > at sun.reflect.GeneratedMethodAccessor362.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280) > at > org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:567) > at > org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:71) > at > org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:142) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.xwiki.velocity.introspection.TryCatchDirective.render(TryCatchDirective.java:72) > at > org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluateInternal(DefaultVelocityEngine.java:256) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:222) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:198) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.evaluateContent(InternalTemplateManager.java:725) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:626) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:604) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:570) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:556) > at > com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:65) > at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:1876) > at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1854) > at com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:821) > at sun.reflect.GeneratedMethodAccessor205.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280) > at > org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:369) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:216) > at > org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:311) > at > org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:230) > at > org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluateInternal(DefaultVelocityEngine.java:256) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:222) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:198) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.evaluateContent(InternalTemplateManager.java:725) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:626) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:604) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:570) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:556) > at > com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:65) > at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:1876) > at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1854) > at com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:821) > at sun.reflect.GeneratedMethodAccessor205.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280) > at > org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:369) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:216) > at > org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:311) > at > org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:230) > at > org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluateInternal(DefaultVelocityEngine.java:256) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:222) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:198) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.evaluateContent(InternalTemplateManager.java:725) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:626) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:604) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:570) > at > com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:556) > at > com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:65) > at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:1876) > at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:180) > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:431) > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:184) > at > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) > at > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:115) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:137) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) > at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041) > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) > at > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.hibernate.HibernateException: Failed to commit or rollback > transaction. Root cause [] > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:1022) > at > com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:649) > ... 170 more > Caused by: org.hibernate.exception.DataException: could not update: > [com.xpn.xwiki.objects.StringProperty#component[id,name]{id=-3231836267878261431, > name=recent}] > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102) > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) > at > org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2612) > at > org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2494) > at > org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2821) > at > org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:113) > at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273) > at > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265) > at > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185) > at > org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) > at > org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) > at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) > at > org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133) > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:1015) > ... 171 more > Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too > long for column 'XWS_VALUE' at row 1 > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4235) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2441) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2366) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2350) > at > org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) > at > org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) > at > org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) > at > org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2594) > ... 183 more > 2016-02-19 17:11:05,081 > [http://192.168.0.35:8080/xwiki/bin/view/SDomain/HW_DEV/0_LIB/Components-CommercialPC/Library+Description/] > WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method > [com.xpn.xwiki.api.XWiki.searchDocuments] in > 52:xwiki:SDomain.HW_DEV.0_LIB.Components-CommercialPC.Library > Description.WebHome@17,27 > > > any ideas what causes this? I'm running ubuntu server, tomcat 7 and mysql > setup. > > Thanks > Gerrie > > > > -- > View this message in context: > http://xwiki.475771.n2.nabble.com/Server-SQL-error-tp7598052.html > Sent from the XWiki- Users mailing list archive at Nabble.com. > _______________________________________________ > users mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/users -- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
