java.sql.SQLException

Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)]

Solutions on the web9144

  • via Atlassian JIRA by Armond Avanes, 1 year ago
    Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)]
  • via Atlassian JIRA by Armond Avanes, 1 year ago
    Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)]
  • via Atlassian JIRA by Stuart Donovan, 1 year ago
    Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENT_STATUS, CONTENTTYPE, CONTENTID) values (NULL, NULL, 'This space
  • Stack trace

    • java.sql.SQLException: Violation of unique index: SYS_PK_CONTENT in statement [insert into CONTENT (DESCSPACEID, TITLE, BODY, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, PREVVER, CONTENTTYPE, CONTENTID) values (NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'SPACEDESCRIPTION', 0)] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:469) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2326) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2279) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2180) at com.atlassian.confluence.setup.SpringSessionInViewFilter.closeSession(SpringSessionInViewFilter.java:42) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:88) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:39) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) 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.CacheInvocation.service(CacheInvocation.java:135) 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago