java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1

Atlassian JIRA | Thomas Link | 10 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    {checklist:name=Design Status: | parent=3000 Design | checklabels=mypplus_abnahme, mypplus_changerequests, mypplus_release1 | comment-heading=Comments} Cause: org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:99) caused by: java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648) Stack Trace: [hide] org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2393) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:472) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:397) at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:89) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:181) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.util.LoggingContextInterceptor.intercept(LoggingContextInterceptor.java:48) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:47) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:114) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:67) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:39) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:98) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:229) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:117) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:137) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:21) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:159) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:172) at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:122) at com.atlassian.core.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.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:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) Referer URL: http://wiki.namics.com/display/MYPPLUS/3000+Design Build Information: confluence.home: /home/confluence/data system.uptime: 5 days, 7 hours, 47 minutes, 21 seconds system.version: 2.5.4 build.number: 809 Server Information: Application Server: Apache Tomcat/5.5.15 Servlet Version: 2.4 Database Dialect: com.atlassian.hibernate.dialect.MySQLDialect Database Driver Name: com.mysql.jdbc.Driver Database Driver Version: 3.1 Memory Information: total.memory: 254 MB free.memory: 105 MB used.memory: 149 MB System Information: system.date: Wednesday, 26 Sep 2007 system.time: 15:53:06 system.favourite.colour: Myrtle java.version: 1.4.2_10 java.vendor: Sun Microsystems Inc. jvm.version: 1.0 jvm.vendor: Sun Microsystems Inc. jvm.implementation.version: 1.4.2_10-b03 java.runtime: Java(TM) 2 Runtime Environment, Standard Edition java.vm: Java HotSpot(TM) Client VM user.name.word: root user.timezone: Europe/Zurich operating.system: Linux 2.6.9-5.0.5.ELsmp os.architecture: i386 fs.encoding: UTF-8 Cluster Information: Not clustered. Enabled Plugins: Checklists Macros (com.comalatech.checklists, Version: 1.2) Basic Macros (confluence.macros.basic, Version: 1.3) Confluence Usage Stats (com.atlassian.confluence.ext.usage, Version: 0.7.2) Chart Plugin (confluence.extra.chart, Version: 1.8) User Listener (confluence.extra.userlister, Version: 1.2) Global Labels Sections (confluence.sections.labels, Version: 1.0) Information Macros (confluence.extra.information, Version: 0.2) Page Operations (confluence.sections.page.operations, Version: 1.0) Task List Macros V2 (confluence.extra.tasklistv2, Version: 2.0.1) WebDAV Plugin (confluence.extra.webdav, Version: 1.1) Profile Tabs (confluence.sections.profile, Version: 1.0) Confluence Remote API (confluence.extra.confluencerpc, Version: 1.4) Core Startup and Shutdown (confluence.lifecycle.core, Version: 1) Admin Sections (confluence.sections.admin, Version: 1.0) Table of Contents Plugin (org.randombits.confluence.toc, Version: 2.3.2) TinyMCE Editor Plugin (com.atlassian.confluence.extra.tinymceplugin, Version: 1.12) Space Pages Sections (confluence.sections.space.pages, Version: 1.0) News Tabs (confluence.sections.news, Version: 1.0) Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0) Confluence Contributors Plugin (com.atlassian.confluence.contributors, Version: 1.1) Attachments Macros (confluence.extra.attachments, Version: 1.4) IM Presence Macros (confluence.extra.impresence, Version: 0.1) Space Actions Sections (confluence.sections.space.actions, Version: 1.0) Task List Macros (confluence.extra.tasklist, Version: 1.3) Redirection Macros (org.randombits.confluence.redirection, Version: 2.2) Space Labels Sections (confluence.sections.space.labels, Version: 1.0) Dynamic Task List Macros (confluence.extra.dynamictasklist, Version: 1.5) Core Extractors (confluence.extractors.core, Version: 1.4) Compatibility Macros (confluence.macros.compatibility, Version: 1.3) Page Tabs (confluence.sections.page, Version: 1.0) Core Listeners (confluence.listeners.core, Version: 1.3) Dashboard Macros (confluence.macros.dashboard, Version: 1.3) Live Search Macros (confluence.extra.livesearch, Version: 1.6) Page View Links (confluence.sections.page.actions, Version: 1.0) JIRA Macros (confluence.extra.jira, Version: 1.6) Clickr Theme (com.atlassian.confluence.themes.clickr, Version: 0.9.1) Layout Macros (confluence.extra.layout, Version: 0.2) Excel Plugin (org.swift.confluence.excel, Version: 3.1) Tabular Metadata (confluence.extra.masterdetail, Version: 1.0) Space Admin Sections (confluence.sections.space.admin, Version: 1.0) Mail Page Plugin (com.atlassian.confluence.ext.mailpage, Version: 1.2) Calendar Plugin (confluence.extra.calendar, Version: 2.3) Testplan Plugins (com.pantero.confluence.plugins.testplans, Version: 1.1) Advanced Macros (confluence.macros.advanced, Version: 1.3) IM Presence NG Plugin (confluence.extra.impresence2, Version: 2.0-rc2) Atlassian Plugin Repository (confluence.repository.client, Version: 2.0.4) Edit Profile Sections (confluence.sections.profile.edit, Version: 1.0) Attachment Extractors (confluence.extractors.attachments, Version: 1.4) Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 1.0) BloggingRPC (com.atlassian.confluence.plugins.xmlrpc.bloggingrpc, Version: 1.2.1) Space Item Tabs (confluence.sections.space, Version: 1.0) Code Macro (confluence.macros.code, Version: 1.4) Request Information: URL: http://wiki.namics.com/500page.jsp - Scheme: http - Server: wiki.namics.com - Port: 80 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: entityId=4497&columnKey=Comments&cellId=DesignStatus_8332_537771500&pageId=8332&checklistId=DesignStatus&rows=5&cols=50&storeInRows=true&value=Besprochene%20%C3%84nderungen%20m%EF%BF%BDssen%20noch%20gemacht%20werden. Attributes: - javax.servlet.forward.request_uri : /plugins/checklists/setWikiInput.action - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /plugins/checklists/setWikiInput.action - javax.servlet.forward.path_info : /500page.jsp - javax.servlet.forward.query_string : entityId=4497&columnKey=Comments&cellId=DesignStatus_8332_537771500&pageId=8332&checklistId=DesignStatus&rows=5&cols=50&storeInRows=true&value=Besprochene%20%C3%84nderungen%20m%EF%BF%BDssen%20noch%20gemacht%20werden. - javax.servlet.error.exception : org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 - javax.servlet.error.message : - os_securityfilter_already_filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - __sitemesh__using_stream : false - javax.servlet.error.request_uri : /plugins/checklists/setWikiInput.action - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - javax.servlet.error.servlet_name : action - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@164109d - loginfilter.already.filtered : true - atlassian.core.seraph.original.url : /plugins/checklists/setWikiInput.action?entityId=4497&columnKey=Comments&cellId=DesignStatus_8332_537771500&pageId=8332&checklistId=DesignStatus&rows=5&cols=50&storeInRows=true&value=Besprochene%20%C3%84nderungen%20m%EF%BF%BDssen%20noch%20gemacht%20werden. - javax.servlet.jsp.jspException : org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 - sessioninview.FILTERED : true - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: - cols = 50 - value = Besprochene Änderungen müssen noch gemacht werden. - rows = 5 - checklistId = DesignStatus - storeInRows = true - columnKey = Comments - cellId = DesignStatus_8332_537771500 - entityId = 4497 - pageId = 8332 Confluence User: - anonymous Logging: 0 log statements generated by this request.

    Atlassian JIRA | 10 years ago | Thomas Link
    java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1
  2. 0

    {checklist:name=Design Status: | parent=3000 Design | checklabels=mypplus_abnahme, mypplus_changerequests, mypplus_release1 | comment-heading=Comments} Cause: org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:99) caused by: java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648) Stack Trace: [hide] org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2393) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:472) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:397) at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:89) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:181) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.util.LoggingContextInterceptor.intercept(LoggingContextInterceptor.java:48) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:47) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:114) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:67) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:39) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:98) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:229) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:117) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:137) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:21) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:159) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:172) at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:122) at com.atlassian.core.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.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:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) Referer URL: http://wiki.namics.com/display/MYPPLUS/3000+Design Build Information: confluence.home: /home/confluence/data system.uptime: 5 days, 7 hours, 47 minutes, 21 seconds system.version: 2.5.4 build.number: 809 Server Information: Application Server: Apache Tomcat/5.5.15 Servlet Version: 2.4 Database Dialect: com.atlassian.hibernate.dialect.MySQLDialect Database Driver Name: com.mysql.jdbc.Driver Database Driver Version: 3.1 Memory Information: total.memory: 254 MB free.memory: 105 MB used.memory: 149 MB System Information: system.date: Wednesday, 26 Sep 2007 system.time: 15:53:06 system.favourite.colour: Myrtle java.version: 1.4.2_10 java.vendor: Sun Microsystems Inc. jvm.version: 1.0 jvm.vendor: Sun Microsystems Inc. jvm.implementation.version: 1.4.2_10-b03 java.runtime: Java(TM) 2 Runtime Environment, Standard Edition java.vm: Java HotSpot(TM) Client VM user.name.word: root user.timezone: Europe/Zurich operating.system: Linux 2.6.9-5.0.5.ELsmp os.architecture: i386 fs.encoding: UTF-8 Cluster Information: Not clustered. Enabled Plugins: Checklists Macros (com.comalatech.checklists, Version: 1.2) Basic Macros (confluence.macros.basic, Version: 1.3) Confluence Usage Stats (com.atlassian.confluence.ext.usage, Version: 0.7.2) Chart Plugin (confluence.extra.chart, Version: 1.8) User Listener (confluence.extra.userlister, Version: 1.2) Global Labels Sections (confluence.sections.labels, Version: 1.0) Information Macros (confluence.extra.information, Version: 0.2) Page Operations (confluence.sections.page.operations, Version: 1.0) Task List Macros V2 (confluence.extra.tasklistv2, Version: 2.0.1) WebDAV Plugin (confluence.extra.webdav, Version: 1.1) Profile Tabs (confluence.sections.profile, Version: 1.0) Confluence Remote API (confluence.extra.confluencerpc, Version: 1.4) Core Startup and Shutdown (confluence.lifecycle.core, Version: 1) Admin Sections (confluence.sections.admin, Version: 1.0) Table of Contents Plugin (org.randombits.confluence.toc, Version: 2.3.2) TinyMCE Editor Plugin (com.atlassian.confluence.extra.tinymceplugin, Version: 1.12) Space Pages Sections (confluence.sections.space.pages, Version: 1.0) News Tabs (confluence.sections.news, Version: 1.0) Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0) Confluence Contributors Plugin (com.atlassian.confluence.contributors, Version: 1.1) Attachments Macros (confluence.extra.attachments, Version: 1.4) IM Presence Macros (confluence.extra.impresence, Version: 0.1) Space Actions Sections (confluence.sections.space.actions, Version: 1.0) Task List Macros (confluence.extra.tasklist, Version: 1.3) Redirection Macros (org.randombits.confluence.redirection, Version: 2.2) Space Labels Sections (confluence.sections.space.labels, Version: 1.0) Dynamic Task List Macros (confluence.extra.dynamictasklist, Version: 1.5) Core Extractors (confluence.extractors.core, Version: 1.4) Compatibility Macros (confluence.macros.compatibility, Version: 1.3) Page Tabs (confluence.sections.page, Version: 1.0) Core Listeners (confluence.listeners.core, Version: 1.3) Dashboard Macros (confluence.macros.dashboard, Version: 1.3) Live Search Macros (confluence.extra.livesearch, Version: 1.6) Page View Links (confluence.sections.page.actions, Version: 1.0) JIRA Macros (confluence.extra.jira, Version: 1.6) Clickr Theme (com.atlassian.confluence.themes.clickr, Version: 0.9.1) Layout Macros (confluence.extra.layout, Version: 0.2) Excel Plugin (org.swift.confluence.excel, Version: 3.1) Tabular Metadata (confluence.extra.masterdetail, Version: 1.0) Space Admin Sections (confluence.sections.space.admin, Version: 1.0) Mail Page Plugin (com.atlassian.confluence.ext.mailpage, Version: 1.2) Calendar Plugin (confluence.extra.calendar, Version: 2.3) Testplan Plugins (com.pantero.confluence.plugins.testplans, Version: 1.1) Advanced Macros (confluence.macros.advanced, Version: 1.3) IM Presence NG Plugin (confluence.extra.impresence2, Version: 2.0-rc2) Atlassian Plugin Repository (confluence.repository.client, Version: 2.0.4) Edit Profile Sections (confluence.sections.profile.edit, Version: 1.0) Attachment Extractors (confluence.extractors.attachments, Version: 1.4) Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 1.0) BloggingRPC (com.atlassian.confluence.plugins.xmlrpc.bloggingrpc, Version: 1.2.1) Space Item Tabs (confluence.sections.space, Version: 1.0) Code Macro (confluence.macros.code, Version: 1.4) Request Information: URL: http://wiki.namics.com/500page.jsp - Scheme: http - Server: wiki.namics.com - Port: 80 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: entityId=4497&columnKey=Comments&cellId=DesignStatus_8332_537771500&pageId=8332&checklistId=DesignStatus&rows=5&cols=50&storeInRows=true&value=Besprochene%20%C3%84nderungen%20m%EF%BF%BDssen%20noch%20gemacht%20werden. Attributes: - javax.servlet.forward.request_uri : /plugins/checklists/setWikiInput.action - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /plugins/checklists/setWikiInput.action - javax.servlet.forward.path_info : /500page.jsp - javax.servlet.forward.query_string : entityId=4497&columnKey=Comments&cellId=DesignStatus_8332_537771500&pageId=8332&checklistId=DesignStatus&rows=5&cols=50&storeInRows=true&value=Besprochene%20%C3%84nderungen%20m%EF%BF%BDssen%20noch%20gemacht%20werden. - javax.servlet.error.exception : org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 - javax.servlet.error.message : - os_securityfilter_already_filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - __sitemesh__using_stream : false - javax.servlet.error.request_uri : /plugins/checklists/setWikiInput.action - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - javax.servlet.error.servlet_name : action - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@164109d - loginfilter.already.filtered : true - atlassian.core.seraph.original.url : /plugins/checklists/setWikiInput.action?entityId=4497&columnKey=Comments&cellId=DesignStatus_8332_537771500&pageId=8332&checklistId=DesignStatus&rows=5&cols=50&storeInRows=true&value=Besprochene%20%C3%84nderungen%20m%EF%BF%BDssen%20noch%20gemacht%20werden. - javax.servlet.jsp.jspException : org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 - sessioninview.FILTERED : true - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: - cols = 50 - value = Besprochene Änderungen müssen noch gemacht werden. - rows = 5 - checklistId = DesignStatus - storeInRows = true - columnKey = Comments - cellId = DesignStatus_8332_537771500 - entityId = 4497 - pageId = 8332 Confluence User: - anonymous Logging: 0 log statements generated by this request.

    Atlassian JIRA | 10 years ago | Thomas Link
    java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    The problem of space removal when attachments are stored within the database occurred and generated the following error exception: {noformat} 2008-03-25 13:11:45,359 ERROR [http-8484-Processor3] [atlassian.xwork.interceptors.XWorkTransactionInterceptor] onThrowable Invoking rollback for transaction on action '/spaces/doremovespace.action (RemoveSpaceAction.doRemove())' due to throwable: org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`)) -- url: /spaces/doremovespace.action | userName: admin org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`)) java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`)) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648) {noformat} The same happened while using the embedded DB. Steps to replicate: # Migrate attachment storage to database # Delete the space (Please try the space export from CSP-16708)

    Atlassian JIRA | 9 years ago | Mei Yan Chan [Atlassian]
    java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`))

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.BatchUpdateException

      Data truncation: Data truncated for column 'text_val' at row 1

      at com.mysql.jdbc.ServerPreparedStatement.executeBatch()
    2. MySQL jdbc
      ServerPreparedStatement.executeBatch
      1. com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648)
      1 frame