java.sql.BatchUpdateException: Batch entry 0 insert into CONTENT_PERM (CP_TYPE, USERNAME, GROUPNAME, CPS_ID, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, ID) values ('Edit', NULL, 'administrators', 34701313, 'ff808081545c405b01545c9341d5002d', '2015-09-07 10:44:33.000000 +07:00:00', NULL, '2015-09-07 10:44:33.000000 +07:00:00', 34832386) was aborted. Call getNextException to see the cause. 2016-04-29 16:23:34.952900500 at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2707) 2016-04-29 16:23:34.952904500 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1912) 2016-04-29 16:23:34.952904500 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338) 2016-04-29 16:23:34.952905500 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2888) 2016-04-29 16:23:34.952905500 at sun.reflect.GeneratedMethodAccessor309.invoke(Unknown Source) 2016-04-29 16:23:34.952910500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

Atlassian JIRA | Shannon Mackie [Atlassian] | 10 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    h3. Summary When importing a space into Confluence that has page restrictions that include both {{confluence-administrators}} and {{administrators}} it will fail with an error: {noformat}2016-04-29 16:23:34.952894500 Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into CONTENT_PERM (CP_TYPE, USERNAME, GROUPNAME, CPS_ID, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, ID) values ('Edit', NULL, 'administrators', 34701313, 'ff808081545c405b01545c9341d5002d', '2015-09-07 10:44:33.000000 +07:00:00', NULL, '2015-09-07 10:44:33.000000 +07:00:00', 34832386) was aborted. Call getNextException to see the cause. 2016-04-29 16:23:34.952900500 at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2707) 2016-04-29 16:23:34.952904500 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1912) 2016-04-29 16:23:34.952904500 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338) 2016-04-29 16:23:34.952905500 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2888) 2016-04-29 16:23:34.952905500 at sun.reflect.GeneratedMethodAccessor309.invoke(Unknown Source) 2016-04-29 16:23:34.952910500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2016-04-29 16:23:34.952911500 at java.lang.reflect.Method.invoke(Method.java:498) 2016-04-29 16:23:34.952911500 at com.github.gquintana.metrics.proxy.MethodInvocation.proceed(MethodInvocation.java:75) 2016-04-29 16:23:34.952911500 at com.github.gquintana.metrics.sql.AbstractStatementProxyHandler.invoke(AbstractStatementProxyHandler.java:64) 2016-04-29 16:23:34.952916500 at com.github.gquintana.metrics.proxy.ProxyHandler.invoke(ProxyHandler.java:73) 2016-04-29 16:23:34.952916500 at com.sun.proxy.$Proxy513.executeBatch(Unknown Source) 2016-04-29 16:23:34.952916500 at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) 2016-04-29 16:23:34.952917500 at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) 2016-04-29 16:23:34.952921500 at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) 2016-04-29 16:23:34.952921500 at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) 2016-04-29 16:23:34.952922500 at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128) 2016-04-29 16:23:34.952922500 ... 67 more 2016-04-29 16:23:34.952922500 caused by: 2016-04-29 16:23:34.952926500 org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "cp_unique_group"{noformat} h3. Environment * Confluence Cloud 1000.71.0 h3. Steps to Reproduce # Apply page restrictions to a page and include both groups, {{confluence-administrators}} and {{administrators}} # Export to XML with intent to reimport. # On another Confluence instance, import the space. h3. Expected Results Should ignore the permissions that were set and not cause an issue. h3. Actual Results Fails on this error mentioned above. h3.Workaround Remove the page restrictions for both groups first, then create the XML to import.

    Atlassian JIRA | 10 months ago | Shannon Mackie [Atlassian]
    java.sql.BatchUpdateException: Batch entry 0 insert into CONTENT_PERM (CP_TYPE, USERNAME, GROUPNAME, CPS_ID, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, ID) values ('Edit', NULL, 'administrators', 34701313, 'ff808081545c405b01545c9341d5002d', '2015-09-07 10:44:33.000000 +07:00:00', NULL, '2015-09-07 10:44:33.000000 +07:00:00', 34832386) was aborted. Call getNextException to see the cause. 2016-04-29 16:23:34.952900500 at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2707) 2016-04-29 16:23:34.952904500 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1912) 2016-04-29 16:23:34.952904500 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338) 2016-04-29 16:23:34.952905500 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2888) 2016-04-29 16:23:34.952905500 at sun.reflect.GeneratedMethodAccessor309.invoke(Unknown Source) 2016-04-29 16:23:34.952910500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  2. 0

    h3. Summary When importing a space into Confluence that has page restrictions that include both {{confluence-administrators}} and {{administrators}} it will fail with an error: {noformat}2016-04-29 16:23:34.952894500 Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into CONTENT_PERM (CP_TYPE, USERNAME, GROUPNAME, CPS_ID, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, ID) values ('Edit', NULL, 'administrators', 34701313, 'ff808081545c405b01545c9341d5002d', '2015-09-07 10:44:33.000000 +07:00:00', NULL, '2015-09-07 10:44:33.000000 +07:00:00', 34832386) was aborted. Call getNextException to see the cause. 2016-04-29 16:23:34.952900500 at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2707) 2016-04-29 16:23:34.952904500 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1912) 2016-04-29 16:23:34.952904500 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338) 2016-04-29 16:23:34.952905500 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2888) 2016-04-29 16:23:34.952905500 at sun.reflect.GeneratedMethodAccessor309.invoke(Unknown Source) 2016-04-29 16:23:34.952910500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2016-04-29 16:23:34.952911500 at java.lang.reflect.Method.invoke(Method.java:498) 2016-04-29 16:23:34.952911500 at com.github.gquintana.metrics.proxy.MethodInvocation.proceed(MethodInvocation.java:75) 2016-04-29 16:23:34.952911500 at com.github.gquintana.metrics.sql.AbstractStatementProxyHandler.invoke(AbstractStatementProxyHandler.java:64) 2016-04-29 16:23:34.952916500 at com.github.gquintana.metrics.proxy.ProxyHandler.invoke(ProxyHandler.java:73) 2016-04-29 16:23:34.952916500 at com.sun.proxy.$Proxy513.executeBatch(Unknown Source) 2016-04-29 16:23:34.952916500 at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) 2016-04-29 16:23:34.952917500 at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) 2016-04-29 16:23:34.952921500 at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) 2016-04-29 16:23:34.952921500 at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) 2016-04-29 16:23:34.952922500 at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128) 2016-04-29 16:23:34.952922500 ... 67 more 2016-04-29 16:23:34.952922500 caused by: 2016-04-29 16:23:34.952926500 org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "cp_unique_group"{noformat} h3. Environment * Confluence Cloud 1000.71.0 h3. Steps to Reproduce # Apply page restrictions to a page and include both groups, {{confluence-administrators}} and {{administrators}} # Export to XML with intent to reimport. # On another Confluence instance, import the space. h3. Expected Results Should ignore the permissions that were set and not cause an issue. h3. Actual Results Fails on this error mentioned above. h3.Workaround Remove the page restrictions for both groups first, then create the XML to import.

    Atlassian JIRA | 10 months ago | Shannon Mackie [Atlassian]
    java.sql.BatchUpdateException: Batch entry 0 insert into CONTENT_PERM (CP_TYPE, USERNAME, GROUPNAME, CPS_ID, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, ID) values ('Edit', NULL, 'administrators', 34701313, 'ff808081545c405b01545c9341d5002d', '2015-09-07 10:44:33.000000 +07:00:00', NULL, '2015-09-07 10:44:33.000000 +07:00:00', 34832386) was aborted. Call getNextException to see the cause. 2016-04-29 16:23:34.952900500 at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2707) 2016-04-29 16:23:34.952904500 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1912) 2016-04-29 16:23:34.952904500 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338) 2016-04-29 16:23:34.952905500 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2888) 2016-04-29 16:23:34.952905500 at sun.reflect.GeneratedMethodAccessor309.invoke(Unknown Source) 2016-04-29 16:23:34.952910500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    Root Cause Analysis

    1. java.sql.BatchUpdateException

      Batch entry 0 insert into CONTENT_PERM (CP_TYPE, USERNAME, GROUPNAME, CPS_ID, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, ID) values ('Edit', NULL, 'administrators', 34701313, 'ff808081545c405b01545c9341d5002d', '2015-09-07 10:44:33.000000 +07:00:00', NULL, '2015-09-07 10:44:33.000000 +07:00:00', 34832386) was aborted. Call getNextException to see the cause. 2016-04-29 16:23:34.952900500 at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2707) 2016-04-29 16:23:34.952904500 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1912) 2016-04-29 16:23:34.952904500 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338) 2016-04-29 16:23:34.952905500 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2888) 2016-04-29 16:23:34.952905500 at sun.reflect.GeneratedMethodAccessor309.invoke(Unknown Source) 2016-04-29 16:23:34.952910500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke()
    2. Java RT
      Method.invoke
      1. java.lang.reflect.Method.invoke(Method.java:498)
      1 frame
    3. com.github.gquintana
      AbstractStatementProxyHandler.invoke
      1. com.github.gquintana.metrics.proxy.MethodInvocation.proceed(MethodInvocation.java:75)
      2. com.github.gquintana.metrics.sql.AbstractStatementProxyHandler.invoke(AbstractStatementProxyHandler.java:64)
      2 frames