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)]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 843830, 1 year ago
Try to insert null into a non-nullable column in statement [INSERT INTO CONTRACT (ID, NAME, TYPE, CLIENT, STATUS, type) VALUES (10, NULL, 0, 0, 0, NULL)]
via hsqldb by wiggly
, 1 year ago
The database is shutdown in statement \[INSERT INTO session ( id, user\_id, machine\_id, start, charge, reward ) VALUES ( 4231, 1661, 1189, '20041227164527', 0, 0 )\]
via Atlassian JIRA by Dave Loeng [Atlassian], 1 year ago
Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3]
via Atlassian JIRA by Dave Loeng [Atlassian], 1 year ago
Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3]
via hsqldb by nobody
, 1 year ago
File input/output error: saveSorted java.lang.ClassCastException: java.lang.Float in statement \[ALTER TABLE \_DSMS\_2ENCOURS DROP COLUMN ColumnName ;\]
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.(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 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 com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32)
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.