Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-1448

UncategorizedSQLException when updating a page with jiraissues macro

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Medium
    • None
    • 1.1
    • None
    • build #53

    Description

      Attempted to update a page to have the following contents (page will update when both jiraissues macro tags are removed, manual retrieval of the rss feed seems fine (no issues in jira however))
      (servernames, users, project keys and passwords changed to protect the innocent):

      This is the home page for the blah blah - blah space.

      Latest Project News

      {rss:url=https://SERVERNAME/confluence/spaces/blogrss.action?key=XYZ12&os_username=MY_USER&os_password=MY_PASS|max=5}

      Open Support Requests

      {jiraissues:url=https://SERVERNAME/jira/secure/IssueNavigator.jspa?view=rss&pid=10230&types=5&statusIds=1&statusIds=3&statusIds=4&sorter/field=priority&sorter/order=DESC&tempMax=25&reset=true&decorator=none&os_username=THE_USER&os_password=THE_PASS|columns=key;summary;updated;assignee;reporter;priority}

      Open Project Issues

      {jiraissues:url=https://SERVERNAME/jira/secure/IssueNavigator.jspa?view=rss&pid=10230&types=1&types=2&types=3&types=4&statusIds=1&statusIds=3&statusIds=4&sorter/field=priority&sorter/order=DESC&tempMax=25&reset=true&decorator=none&os_username=THE_USER&os_password=THE_PASS|columns=key;summary;type;updated;assignee;reporter;priority}

      Project Links

      SupportNet

      Repository Documents

      {children:depth=2}

      Got the following stack trace:

      Cause:
      org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 3 insert into LINKS (DESTPAGETITLE, DESTSPACEKEY, CONTENTID, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, LINKID) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 3 insert into LINKS (DESTPAGETITLE, DESTSPACEKEY, CONTENTID, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, LINKID) values ( was aborted. Call getNextException() to see the cause.

      Stack Trace: [hide]

      org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Batch entry 3 insert into LINKS (DESTPAGETITLE, DESTSPACEKEY, CONTENTID, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, LINKID) values ( was aborted. Call getNextException() to see the cause.]; nested exception is org.postgresql.jdbc2.PBatchUpdateException: Batch entry 3 insert into LINKS (DESTPAGETITLE, DESTSPACEKEY, CONTENTID, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, LINKID) values ( was aborted. Call getNextException() to see the cause.
      Batch entry 3 insert into LINKS (DESTPAGETITLE, DESTSPACEKEY, CONTENTID, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, LINKID) values ( was aborted. Call getNextException() to see the cause.
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:105)
      at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
      at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:122)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2385)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2335)
      at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2204)
      at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
      at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:386)
      at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:316)
      at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:158)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115)
      at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:278)
      at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:248)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:145)
      at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:146)
      at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:165)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:117)
      at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
      at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
      at java.lang.Thread.run(Thread.java:536)

      Referer URL: https://support.customware.net/confluence/pages/editpage.action?pageId=12726

      Build Information:
      Uptime: 7 days, 2 hours, 8 minutes, 59 seconds
      Version: 1.1
      Build Number: 53

      Server Information:
      Application Server: Apache Tomcat/4.1.30
      Servlet Version: 2.3
      Database Dialect: net.sf.hibernate.dialect.PostgreSQLDialect

      Memory Information:
      Total Memory: 762 MB
      Free Memory: 76 MB
      Used Memory: 686 MB

      System Information:
      System Date: Tuesday, 22 Jun 2004
      System Time: 12:30:55
      System Favourite Colour: Almond
      Java Version: 1.4.1_03
      Java Vendor: Sun Microsystems Inc.
      JVM Version: 1.0
      JVM Vendor: Sun Microsystems Inc.
      JVM Implementation Version: 1.4.1_03-b02
      Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition
      Java VM: Java HotSpot(TM) Client VM
      User Name: jira
      User Timezone: Australia/Sydney
      Operating System: Linux 2.4.18-14
      OS Architecture: i386

      Request Logging:
      0 log statements generated by this request:

      Attachments

        Activity

          People

            Unassigned Unassigned
            2b292a1585d0 Nathan Lee
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: