net.sf.hibernate.JDBCException: Could not execute JDBC batch update

Atlassian JIRA | Mark Chaimungkalanont | 1 decade ago
  1. 0

    Tasklist crashes when task item has link. This occurs when you click on a task icon. The task still gets toggled sucessfully though CONFLUENCE System Error A system error has occurred - our apologies! Please create a support issue on our support system at http://support.atlassian.com with the following information: 1. a description of your problem and what you were doing at the time it occurred 2. cut & paste the error and system information found below 3. attach the application server log file (if possible). We will respond as promptly as possible. Thank you! Cause: org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. Stack Trace: [hide] org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) 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.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) 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:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:73) 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.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.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:133) 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:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:222) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:103) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:80) at com.atlassian.confluence.servlet.simpledisplay.SimpleDisplayServlet.doGet(SimpleDisplayServlet.java:44) at javax.servlet.http.HttpServlet.service(HttpServlet.java:126) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:158) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170) at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) Referer URL: http://extranet.atlassian.com/display/JIRADEV/JIRA+Release+Plan Build Information: Uptime: 2 days, 3 hours, 54 minutes, 34 seconds Version: 1.4-DR4 Build Number: 115 Server Information: Application Server: Resin/2.1.11 Servlet Version: 2.3 Database Dialect: N/A Memory Information: Total Memory: 254 MB Free Memory: 34 MB Used Memory: 220 MB System Information: System Date: Wednesday, 09 Feb 2005 System Time: 20:20:41 System Favourite Colour: Lime Java Version: 1.4.2_04 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_04-b05 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: j2ee User Timezone: America/Chicago Operating System: Linux 2.4.21-27.0.2.ELsmp OS Architecture: i386 Request Information: URL: http://atlassian01.contegix.com:10087/500page.jsp - Scheme: http - Server: atlassian01.contegix.com - Port: 10087 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: null Attributes: - javax.servlet.error.exception : org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. - sessioninview.FILTERED : true - javax.servlet.error.status_code : 500 - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - atlassian.core.seraph.original.url : [elided] - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@13d88c7 - javax.servlet.error.servlet_name : simple-display - loginfilter.already.filtered : true - os_securityfilter_already_filtered : true - __sitemesh__filterapplied : true - javax.servlet.error.message : (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. - javax.servlet.error.request_uri : /display/JIRADEV/JIRA+Release+Plan - javax.servlet.jsp.jspException : org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: - tasklist.complete = <p>Create new <span class="nobr"><a href="http://jira.atlassian.com/secure/project/ManageVersions.jspa?pid=10240" title="Visit page outside Confluence" rel="nofollow">version(s) <sup><img class="rendericon" src="/images/icons/linkext7.gif" height="7" width="7" align="absmiddle" alt="" border="0"/></sup></a></span> if needed <br/> Logging: 14 log statements generated by this request: [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] ERROR: value too long for type character varying(255) [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] ERROR: value too long for type character varying(255) [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Could not execute JDBC batch update Throwable: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) 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.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) 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) [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session Throwable: net.sf.hibernate.JDBCException: Could not execute JDBC batch update at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:133) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) 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.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) 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) [ERROR] Wed Feb 09 20:20:38 CST 2005 [com.atlassian.confluence.util.XWorkTransactionInterceptor] Invoking rollback for transaction on action '/pages/viewpage.action (ViewPageAction.execute())' due to throwable: org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. Throwable: org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) 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.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) 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) [ERROR] Wed Feb 09 20:20:38 CST 2005 [org.springframework.orm.hibernate.HibernateTransactionManager] Rollback exception overridden by synchronization exception Throwable: java.lang.IllegalStateException: Transaction synchronization is not active at org.springframework.transaction.support.TransactionSynchronizationManager.getSynchronizations(TransactionSynchronizationManager.java:220) at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCompletion(AbstractPlatformTransactionManager.java:512) at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:423) at com.atlassian.confluence.util.XWorkTransactionInterceptor.onThrowable(XWorkTransactionInterceptor.java:201) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:140) 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:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:222) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:103) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:80) at com.atlassian.confluence.servlet.simpledisplay.SimpleDisplayServlet.doGet(SimpleDisplayServlet.java:44) at javax.servlet.http.HttpServlet.service(HttpServlet.java:126) [ERROR] Wed Feb 09 20:20:38 CST 2005 [com.atlassian.confluence.util.XWorkTransactionInterceptor] Attempted rollback caused exception: java.lang.IllegalStateException: Cannot deactivate transaction synchronization - not active Throwable: java.lang.IllegalStateException: Cannot deactivate transaction synchronization - not active at org.springframework.transaction.support.TransactionSynchronizationManager.clearSynchronization(TransactionSynchronizationManager.java:232) at org.springframework.transaction.support.AbstractPlatformTransactionManager.cleanupAfterCompletion(AbstractPlatformTransactionManager.java:570) at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:455) at com.atlassian.confluence.util.XWorkTransactionInterceptor.onThrowable(XWorkTransactionInterceptor.java:201) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:140) 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:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:222) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:103) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:80) at com.atlassian.confluence.servlet.simpledisplay.SimpleDisplayServlet.doGet(SimpleDisplayServlet.java:44) at javax.servlet.http.HttpServlet.service(HttpServlet.java:126) [ERROR] Wed Feb 09 20:20:38 CST 2005 [com.opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action Throwable: org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) 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.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) 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)

    Atlassian JIRA | 1 decade ago | Mark Chaimungkalanont
    net.sf.hibernate.JDBCException: Could not execute JDBC batch update
  2. 0

    Tasklist crashes when task item has link. This occurs when you click on a task icon. The task still gets toggled sucessfully though CONFLUENCE System Error A system error has occurred - our apologies! Please create a support issue on our support system at http://support.atlassian.com with the following information: 1. a description of your problem and what you were doing at the time it occurred 2. cut & paste the error and system information found below 3. attach the application server log file (if possible). We will respond as promptly as possible. Thank you! Cause: org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. Stack Trace: [hide] org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) 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.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) 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:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:73) 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.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.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:133) 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:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:222) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:103) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:80) at com.atlassian.confluence.servlet.simpledisplay.SimpleDisplayServlet.doGet(SimpleDisplayServlet.java:44) at javax.servlet.http.HttpServlet.service(HttpServlet.java:126) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:158) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170) at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) Referer URL: http://extranet.atlassian.com/display/JIRADEV/JIRA+Release+Plan Build Information: Uptime: 2 days, 3 hours, 54 minutes, 34 seconds Version: 1.4-DR4 Build Number: 115 Server Information: Application Server: Resin/2.1.11 Servlet Version: 2.3 Database Dialect: N/A Memory Information: Total Memory: 254 MB Free Memory: 34 MB Used Memory: 220 MB System Information: System Date: Wednesday, 09 Feb 2005 System Time: 20:20:41 System Favourite Colour: Lime Java Version: 1.4.2_04 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_04-b05 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: j2ee User Timezone: America/Chicago Operating System: Linux 2.4.21-27.0.2.ELsmp OS Architecture: i386 Request Information: URL: http://atlassian01.contegix.com:10087/500page.jsp - Scheme: http - Server: atlassian01.contegix.com - Port: 10087 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: null Attributes: - javax.servlet.error.exception : org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. - sessioninview.FILTERED : true - javax.servlet.error.status_code : 500 - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - atlassian.core.seraph.original.url : [elided] - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@13d88c7 - javax.servlet.error.servlet_name : simple-display - loginfilter.already.filtered : true - os_securityfilter_already_filtered : true - __sitemesh__filterapplied : true - javax.servlet.error.message : (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. - javax.servlet.error.request_uri : /display/JIRADEV/JIRA+Release+Plan - javax.servlet.jsp.jspException : org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: - tasklist.complete = <p>Create new <span class="nobr"><a href="http://jira.atlassian.com/secure/project/ManageVersions.jspa?pid=10240" title="Visit page outside Confluence" rel="nofollow">version(s) <sup><img class="rendericon" src="/images/icons/linkext7.gif" height="7" width="7" align="absmiddle" alt="" border="0"/></sup></a></span> if needed <br/> Logging: 14 log statements generated by this request: [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] ERROR: value too long for type character varying(255) [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. [WARN] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] ERROR: value too long for type character varying(255) [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Could not execute JDBC batch update Throwable: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) 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.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) 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) [ERROR] Wed Feb 09 20:20:38 CST 2005 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session Throwable: net.sf.hibernate.JDBCException: Could not execute JDBC batch update at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:133) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) 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.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) 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) [ERROR] Wed Feb 09 20:20:38 CST 2005 [com.atlassian.confluence.util.XWorkTransactionInterceptor] Invoking rollback for transaction on action '/pages/viewpage.action (ViewPageAction.execute())' due to throwable: org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. Throwable: org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) 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.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) 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) [ERROR] Wed Feb 09 20:20:38 CST 2005 [org.springframework.orm.hibernate.HibernateTransactionManager] Rollback exception overridden by synchronization exception Throwable: java.lang.IllegalStateException: Transaction synchronization is not active at org.springframework.transaction.support.TransactionSynchronizationManager.getSynchronizations(TransactionSynchronizationManager.java:220) at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCompletion(AbstractPlatformTransactionManager.java:512) at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:423) at com.atlassian.confluence.util.XWorkTransactionInterceptor.onThrowable(XWorkTransactionInterceptor.java:201) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:140) 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:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:222) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:103) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:80) at com.atlassian.confluence.servlet.simpledisplay.SimpleDisplayServlet.doGet(SimpleDisplayServlet.java:44) at javax.servlet.http.HttpServlet.service(HttpServlet.java:126) [ERROR] Wed Feb 09 20:20:38 CST 2005 [com.atlassian.confluence.util.XWorkTransactionInterceptor] Attempted rollback caused exception: java.lang.IllegalStateException: Cannot deactivate transaction synchronization - not active Throwable: java.lang.IllegalStateException: Cannot deactivate transaction synchronization - not active at org.springframework.transaction.support.TransactionSynchronizationManager.clearSynchronization(TransactionSynchronizationManager.java:232) at org.springframework.transaction.support.AbstractPlatformTransactionManager.cleanupAfterCompletion(AbstractPlatformTransactionManager.java:570) at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:455) at com.atlassian.confluence.util.XWorkTransactionInterceptor.onThrowable(XWorkTransactionInterceptor.java:201) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:140) 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:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:222) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:103) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:80) at com.atlassian.confluence.servlet.simpledisplay.SimpleDisplayServlet.doGet(SimpleDisplayServlet.java:44) at javax.servlet.http.HttpServlet.service(HttpServlet.java:126) [ERROR] Wed Feb 09 20:20:38 CST 2005 [com.opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action Throwable: org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. Batch entry 0 insert into OS_PROPERTYENTRY (key_type, boolean_val, double_val, string_val, long_val, int_val, date_val, entity_name, entity_id, entity_key) values ( was aborted. Call getNextException() to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) 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.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) 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)

    Atlassian JIRA | 1 decade ago | Mark Chaimungkalanont
    net.sf.hibernate.JDBCException: Could not execute JDBC batch update
  3. 0

    oracle - hibernate

    wsabi4axis | 1 decade ago | nobody
    net.sf.hibernate.JDBCException: Could not execute JDBC batch update
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate Community • View topic - problem building caveatemptor with firebird 1.5 ss

    hibernate.org | 1 year ago
    net.sf.hibernate.JDBCException: could not insert: [org.hibernate.auction.model.Category#1]

    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.JDBCException

      Could not execute JDBC batch update

      at net.sf.hibernate.impl.BatcherImpl.executeBatch()
    2. net.sf.hibernate
      JDBCTransaction.commit
      1. net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:133)
      2. net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421)
      3. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
      4. net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
      5. net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
      5 frames
    3. Hibernate
      HibernateTransactionManager.doCommit
      1. org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463)
      1 frame
    4. Spring Tx
      AbstractPlatformTransactionManager.commit
      1. org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373)
      1 frame
    5. com.atlassian.confluence
      XWorkTransactionInterceptor$1.beforeResult
      1. com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124)
      1 frame
    6. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:181)
      1 frame
    7. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
      1 frame
    8. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      1 frame
    9. com.opensymphony.xwork
      DefaultWorkflowInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55)
      1 frame
    10. com.atlassian.confluence
      ConfluenceWorkflowInterceptor.intercept
      1. com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33)
      1 frame
    11. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      1 frame
    12. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
      1 frame
    13. com.atlassian.confluence
      ConfluenceValidationInterceptor.intercept
      1. com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16)
      1 frame
    14. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      1 frame
    15. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
      1 frame
    16. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      1 frame