net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update

Atlassian JIRA | Immanuel Siagian [Atlassian] | 1 year ago
  1. 0

    The following exception is raised when installing the Gliffy Plugin for Confluence using Confluence 2.3.1 and MySQL. The error seems to only show up when using the mysql-connector-java-3.1.10 database driver. When I upgraded to mysql-connector-java-5.0.4, the install was successful. Cause: java.lang.RuntimeException: There was a problem evicting or flushing a PluginData object at com.atlassian.confluence.plugin.persistence.hibernate.HibernatePluginDataDao.saveOrUpdate(HibernatePluginDataDao.java:65) caused by: net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1048592 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2632) Stack Trace: [hide] java.lang.RuntimeException: There was a problem evicting or flushing a PluginData object at com.atlassian.confluence.plugin.persistence.hibernate.HibernatePluginDataDao.saveOrUpdate(HibernatePluginDataDao.java:65) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy0.saveOrUpdate(Unknown Source) at com.atlassian.confluence.plugin.DefaultPluginInstaller.installPlugin(DefaultPluginInstaller.java:31) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy2.installPlugin(Unknown Source) at com.atlassian.plugin.DefaultPluginManager.installPlugin(DefaultPluginManager.java:100) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy3.installPlugin(Unknown Source) at com.atlassian.confluence.plugin.EventDispatchingPluginController.installPlugin(EventDispatchingPluginController.java:60) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy54.installPlugin(Unknown Source) at com.atlassian.confluence.admin.actions.plugins.ManagePluginsAction.installPlugin(ManagePluginsAction.java:225) at com.atlassian.confluence.admin.actions.plugins.UploadPluginAction.handleUploadedFile(UploadPluginAction.java:61) at com.atlassian.confluence.admin.actions.plugins.UploadPluginAction.execute(UploadPluginAction.java:30) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:39) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) 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.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.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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) Caused by: net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:328) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:135) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261) at com.atlassian.confluence.plugin.persistence.hibernate.HibernatePluginDataDao.saveOrUpdate(HibernatePluginDataDao.java:60) ... 141 more Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1048592 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2632) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2618) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1551) at com.mysql.jdbc.ServerPreparedStatement.realClose(ServerPreparedStatement.java:877) at com.mysql.jdbc.ServerPreparedStatement.close(ServerPreparedStatement.java:453) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.close(NewProxyPreparedStatement.java:1811) at net.sf.hibernate.impl.BatcherImpl.closePreparedStatement(BatcherImpl.java:276) at net.sf.hibernate.impl.BatcherImpl.closeStatement(BatcherImpl.java:142) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:131) ... 145 more Referer URL: http://wiki.gliffy.com/confluence/admin/plugins.action Build Information: confluence.home: /gliffy/confluence-2.3.1-std/data system.uptime: 16 hours, 10 minutes, 4 seconds system.version: 2.3.1 build.number: 643 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: 127 MB free.memory: 37 MB used.memory: 90 MB System Information: system.date: Tuesday, 30 Jan 2007 system.time: 11:53:54 system.favourite.colour: Claret java.version: 1.4.2_13 java.vendor: Sun Microsystems Inc. jvm.version: 1.0 jvm.vendor: Sun Microsystems Inc. jvm.implementation.version: 1.4.2_13-b06 java.runtime: Java(TM) 2 Runtime Environment, Standard Edition java.vm: Java HotSpot(TM) Client VM user.name.word: gliffy user.timezone: US/Central operating.system: Linux 2.6.9-34.EL os.architecture: i386 fs.encoding: ISO-8859-1 Cluster Information: Not clustered. Enabled Plugins: Page Tabs (confluence.sections.page, Version: 1.0) Basic Macros (confluence.macros.basic, Version: 1.3) Core Listeners (confluence.listeners.core, Version: 1.3) Dashboard Macros (confluence.macros.dashboard, Version: 1.3) User Listener (confluence.extra.userlister, Version: 1.2) Confluence Usage Stats (com.atlassian.confluence.ext.usage, Version: 0.3) Chart Plugin (confluence.extra.chart, Version: 1.7) Live Search Macros (confluence.extra.livesearch, Version: 1.4) Information Macros (confluence.extra.information, Version: 0.1) Global Labels Sections (confluence.sections.labels, Version: 1.0) Page View Links (confluence.sections.page.actions, Version: 1.0) JIRA Macros (confluence.extra.jira, Version: 1.5) Clickr Theme (com.atlassian.confluence.themes.clickr, Version: 0.5) Layout Macros (confluence.extra.layout, Version: 0.1) Confluence Remote API (confluence.extra.confluencerpc, Version: 1.4) Profile Tabs (confluence.sections.profile, Version: 1.0) Admin Sections (confluence.sections.admin, Version: 1.0) Core Startup and Shutdown (confluence.lifecycle.core, Version: 1) Plain Theme (com.atlassian.confluence.themes.tabless, Version: 1.0) Tabular Metadata (confluence.extra.masterdetail, Version: 1.0) Table of Contents Macros (org.randombits.confluence.toc, Version: 2.3) Space Admin Sections (confluence.sections.space.admin, Version: 1.0) Space Pages Sections (confluence.sections.space.pages, Version: 1.0) IM Presence NG Plugin (confluence.extra.impresence2, Version: 2.0-rc2) Confluence Repository Client (confluence.repository.client, Version: 1.3) Advanced Macros (confluence.macros.advanced, Version: 1.3) Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0) News Tabs (confluence.sections.news, Version: 1.0) IM Presence Macros (confluence.extra.impresence, Version: 0.1) Attachments Macros (confluence.extra.attachments, Version: 1.3) Edit Profile Sections (confluence.sections.profile.edit, Version: 1.0) Space Actions Sections (confluence.sections.space.actions, Version: 1.0) UAT Test Theme (com.atlassian.confluence.uattheme, Version: N/A) Confluence Functional Test Remote API (confluence.extra.functestrpc, Version: 1.4) Plain Website Theme (com.atlassian.confluence.themes.plain-website, Version: 1.0) Task List Macros (confluence.extra.tasklist, Version: 1.3) Space Labels Sections (confluence.sections.space.labels, Version: 1.0) Attachment Extractors (confluence.extractors.attachments, Version: 1.4) Contributors Plugin (confluence.authors, Version: 0.8) Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 1.0) Dynamic Task List Macros (confluence.extra.dynamictasklist, Version: 1.3) Core Extractors (confluence.extractors.core, Version: 1.4) BloggingRPC (com.atlassian.confluence.plugins.xmlrpc.bloggingrpc, Version: 1.1) Compatibility Macros (confluence.macros.compatibility, Version: 1.3) Code Macro (confluence.macros.code, Version: 1.4) Space Item Tabs (confluence.sections.space, Version: 1.0) Request Information: URL: http://wiki.gliffy.com/confluence/500page.jsp - Scheme: http - Server: wiki.gliffy.com - Port: 80 - URI: /confluence/500page.jsp - - Context Path: /confluence - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: null Attributes: - javax.servlet.forward.request_uri : /confluence/admin/uploadplugin.action - javax.servlet.forward.context_path : /confluence - javax.servlet.forward.servlet_path : /admin/uploadplugin.action - javax.servlet.forward.path_info : /500page.jsp - javax.servlet.error.exception : java.lang.RuntimeException: There was a problem evicting or flushing a PluginData object - 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 : /confluence/admin/uploadplugin.action - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - javax.servlet.error.servlet_name : action - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@1ac2227 - loginfilter.already.filtered : true - atlassian.core.seraph.original.url : /admin/uploadplugin.action - javax.servlet.jsp.jspException : java.lang.RuntimeException: There was a problem evicting or flushing a PluginData object - sessioninview.FILTERED : true - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: Confluence User: - anonymous Logging: 0 log statements generated by this request.

    Atlassian JIRA | 10 years ago | Gliffy ChrisK
    net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
  2. 0

    Exceeds max allowed packet for MySQL - Atlassian Documentation

    atlassian.com | 7 months ago
    net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
  3. 0

    h3. Summary Importing a word file with more than 255 characters in its heading will cause HibernateSystemException ERROR h3. Steps to reproduce # Create a word file with multiple headings. One of the headings contains a sentence that is more than 255 characters # Select the "Import Word Document" and select the word document that was just created # Select {{Level 3 Headings}} for {{Split by heading:}} # It will throw an ERROR h3. Expected Results Confluence should throw an INFO/WARNING saying that one of the headings contains more than 255 characters. As such, it cannot complete the import h3. Actual Results It will throw the following ERROR {noformat} Cause org.springframework.orm.hibernate.HibernateSystemException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280]; nested exception is net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:597) caused by: net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:475) caused by: net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2055) caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4235) Stack Trace:[hide] org.springframework.orm.hibernate.HibernateSystemException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280]; nested exception is net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:597) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:477) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:378) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:146) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:173) at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao$1.getBySpaceAndTitle(CachingPageDao.ja ... {noformat} h3.Workaround Modify the sentence to be less than 255 characters

    Atlassian JIRA | 1 year ago | Immanuel Siagian [Atlassian]
    net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    The following exception is raised when installing the Gliffy Plugin for Confluence using Confluence 2.3.1 and MySQL. The error seems to only show up when using the mysql-connector-java-3.1.10 database driver. When I upgraded to mysql-connector-java-5.0.4, the install was successful. Cause: java.lang.RuntimeException: There was a problem evicting or flushing a PluginData object at com.atlassian.confluence.plugin.persistence.hibernate.HibernatePluginDataDao.saveOrUpdate(HibernatePluginDataDao.java:65) caused by: net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1048592 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2632) Stack Trace: [hide] java.lang.RuntimeException: There was a problem evicting or flushing a PluginData object at com.atlassian.confluence.plugin.persistence.hibernate.HibernatePluginDataDao.saveOrUpdate(HibernatePluginDataDao.java:65) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy0.saveOrUpdate(Unknown Source) at com.atlassian.confluence.plugin.DefaultPluginInstaller.installPlugin(DefaultPluginInstaller.java:31) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy2.installPlugin(Unknown Source) at com.atlassian.plugin.DefaultPluginManager.installPlugin(DefaultPluginManager.java:100) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy3.installPlugin(Unknown Source) at com.atlassian.confluence.plugin.EventDispatchingPluginController.installPlugin(EventDispatchingPluginController.java:60) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy54.installPlugin(Unknown Source) at com.atlassian.confluence.admin.actions.plugins.ManagePluginsAction.installPlugin(ManagePluginsAction.java:225) at com.atlassian.confluence.admin.actions.plugins.UploadPluginAction.handleUploadedFile(UploadPluginAction.java:61) at com.atlassian.confluence.admin.actions.plugins.UploadPluginAction.execute(UploadPluginAction.java:30) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:39) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) 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.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.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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) Caused by: net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:328) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:135) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261) at com.atlassian.confluence.plugin.persistence.hibernate.HibernatePluginDataDao.saveOrUpdate(HibernatePluginDataDao.java:60) ... 141 more Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1048592 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2632) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2618) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1551) at com.mysql.jdbc.ServerPreparedStatement.realClose(ServerPreparedStatement.java:877) at com.mysql.jdbc.ServerPreparedStatement.close(ServerPreparedStatement.java:453) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.close(NewProxyPreparedStatement.java:1811) at net.sf.hibernate.impl.BatcherImpl.closePreparedStatement(BatcherImpl.java:276) at net.sf.hibernate.impl.BatcherImpl.closeStatement(BatcherImpl.java:142) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:131) ... 145 more Referer URL: http://wiki.gliffy.com/confluence/admin/plugins.action Build Information: confluence.home: /gliffy/confluence-2.3.1-std/data system.uptime: 16 hours, 10 minutes, 4 seconds system.version: 2.3.1 build.number: 643 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: 127 MB free.memory: 37 MB used.memory: 90 MB System Information: system.date: Tuesday, 30 Jan 2007 system.time: 11:53:54 system.favourite.colour: Claret java.version: 1.4.2_13 java.vendor: Sun Microsystems Inc. jvm.version: 1.0 jvm.vendor: Sun Microsystems Inc. jvm.implementation.version: 1.4.2_13-b06 java.runtime: Java(TM) 2 Runtime Environment, Standard Edition java.vm: Java HotSpot(TM) Client VM user.name.word: gliffy user.timezone: US/Central operating.system: Linux 2.6.9-34.EL os.architecture: i386 fs.encoding: ISO-8859-1 Cluster Information: Not clustered. Enabled Plugins: Page Tabs (confluence.sections.page, Version: 1.0) Basic Macros (confluence.macros.basic, Version: 1.3) Core Listeners (confluence.listeners.core, Version: 1.3) Dashboard Macros (confluence.macros.dashboard, Version: 1.3) User Listener (confluence.extra.userlister, Version: 1.2) Confluence Usage Stats (com.atlassian.confluence.ext.usage, Version: 0.3) Chart Plugin (confluence.extra.chart, Version: 1.7) Live Search Macros (confluence.extra.livesearch, Version: 1.4) Information Macros (confluence.extra.information, Version: 0.1) Global Labels Sections (confluence.sections.labels, Version: 1.0) Page View Links (confluence.sections.page.actions, Version: 1.0) JIRA Macros (confluence.extra.jira, Version: 1.5) Clickr Theme (com.atlassian.confluence.themes.clickr, Version: 0.5) Layout Macros (confluence.extra.layout, Version: 0.1) Confluence Remote API (confluence.extra.confluencerpc, Version: 1.4) Profile Tabs (confluence.sections.profile, Version: 1.0) Admin Sections (confluence.sections.admin, Version: 1.0) Core Startup and Shutdown (confluence.lifecycle.core, Version: 1) Plain Theme (com.atlassian.confluence.themes.tabless, Version: 1.0) Tabular Metadata (confluence.extra.masterdetail, Version: 1.0) Table of Contents Macros (org.randombits.confluence.toc, Version: 2.3) Space Admin Sections (confluence.sections.space.admin, Version: 1.0) Space Pages Sections (confluence.sections.space.pages, Version: 1.0) IM Presence NG Plugin (confluence.extra.impresence2, Version: 2.0-rc2) Confluence Repository Client (confluence.repository.client, Version: 1.3) Advanced Macros (confluence.macros.advanced, Version: 1.3) Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0) News Tabs (confluence.sections.news, Version: 1.0) IM Presence Macros (confluence.extra.impresence, Version: 0.1) Attachments Macros (confluence.extra.attachments, Version: 1.3) Edit Profile Sections (confluence.sections.profile.edit, Version: 1.0) Space Actions Sections (confluence.sections.space.actions, Version: 1.0) UAT Test Theme (com.atlassian.confluence.uattheme, Version: N/A) Confluence Functional Test Remote API (confluence.extra.functestrpc, Version: 1.4) Plain Website Theme (com.atlassian.confluence.themes.plain-website, Version: 1.0) Task List Macros (confluence.extra.tasklist, Version: 1.3) Space Labels Sections (confluence.sections.space.labels, Version: 1.0) Attachment Extractors (confluence.extractors.attachments, Version: 1.4) Contributors Plugin (confluence.authors, Version: 0.8) Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 1.0) Dynamic Task List Macros (confluence.extra.dynamictasklist, Version: 1.3) Core Extractors (confluence.extractors.core, Version: 1.4) BloggingRPC (com.atlassian.confluence.plugins.xmlrpc.bloggingrpc, Version: 1.1) Compatibility Macros (confluence.macros.compatibility, Version: 1.3) Code Macro (confluence.macros.code, Version: 1.4) Space Item Tabs (confluence.sections.space, Version: 1.0) Request Information: URL: http://wiki.gliffy.com/confluence/500page.jsp - Scheme: http - Server: wiki.gliffy.com - Port: 80 - URI: /confluence/500page.jsp - - Context Path: /confluence - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: null Attributes: - javax.servlet.forward.request_uri : /confluence/admin/uploadplugin.action - javax.servlet.forward.context_path : /confluence - javax.servlet.forward.servlet_path : /admin/uploadplugin.action - javax.servlet.forward.path_info : /500page.jsp - javax.servlet.error.exception : java.lang.RuntimeException: There was a problem evicting or flushing a PluginData object - 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 : /confluence/admin/uploadplugin.action - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - javax.servlet.error.servlet_name : action - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@1ac2227 - loginfilter.already.filtered : true - atlassian.core.seraph.original.url : /admin/uploadplugin.action - javax.servlet.jsp.jspException : java.lang.RuntimeException: There was a problem evicting or flushing a PluginData object - sessioninview.FILTERED : true - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: Confluence User: - anonymous Logging: 0 log statements generated by this request.

    Atlassian JIRA | 10 years ago | Gliffy ChrisK
    net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
  6. 0

    h3. Summary Importing a word file with more than 255 characters in its heading will cause HibernateSystemException ERROR h3. Steps to reproduce # Create a word file with multiple headings. One of the headings contains a sentence that is more than 255 characters # Select the "Import Word Document" and select the word document that was just created # Select {{Level 3 Headings}} for {{Split by heading:}} # It will throw an ERROR h3. Expected Results Confluence should throw an INFO/WARNING saying that one of the headings contains more than 255 characters. As such, it cannot complete the import h3. Actual Results It will throw the following ERROR {noformat} Cause org.springframework.orm.hibernate.HibernateSystemException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280]; nested exception is net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:597) caused by: net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:475) caused by: net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2055) caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4235) Stack Trace:[hide] org.springframework.orm.hibernate.HibernateSystemException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280]; nested exception is net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:597) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:477) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:378) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:146) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:173) at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao$1.getBySpaceAndTitle(CachingPageDao.ja ... {noformat} h3.Workaround Modify the sentence to be less than 255 characters

    Atlassian JIRA | 1 year ago | Immanuel Siagian [Atlassian]
    net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update

    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. net.sf.hibernate.exception.GenericJDBCException

      Could not execute JDBC batch update

      at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException()
    2. net.sf.hibernate
      ErrorCodeConverter.handledNonSpecificException
      1. net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90)
      1 frame