org.postgresql.util.PSQLException: ERROR: update or delete on "content" violates foreign key constraint "fk9eb4c0e0c45e94dc" on "ancestors" Detail: Key (contentid)=(69518087748070383) is still referenced from table "ancestors".

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

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via Atlassian JIRA by Nick Menere [Atlassian], 1 year ago
ERROR: update or delete on "content" violates foreign key constraint "fk9eb4c0e0c45e94dc" on "ancestors" Detail: Key (contentid)=(69518087748070383) is still referenced from table "ancestors".
via Atlassian JIRA by Nick Menere [Atlassian], 1 year ago
ERROR: update or delete on "content" violates foreign key constraint "fk9eb4c0e0c45e94dc" on "ancestors" Detail: Key (contentid)=(69518087748070383) is still referenced from table "ancestors".
via Stack Overflow by displayname
, 2 months ago
ERROR: null value in column "created" violates not-null constraint Detail: Failing row contains (1, null, null, null, $2a$10$0GEFgVryvwG3Dv5LN1tg6evPpl4wQ9uJOWiMKMyZq8HVQXCMRt.kS, null, test).
via GitHub by begriffs
, 1 year ago
ERROR: could not modify any active placements
via Stack Overflow by Vineet
, 1 year ago
ERROR: malformed record literal: "qwe" Detail: Missing left parenthesis.
via Stack Overflow by membersound
, 2 years ago
org.postgresql.util.PSQLException: ERROR: update or delete on "content" violates foreign key constraint "fk9eb4c0e0c45e94dc" on "ancestors" Detail: Key (contentid)=(69518087748070383) is still referenced from table "ancestors".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:347)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2559)
at com.caucho.sql.UserStatement.executeBatch(UserStatement.java:213)
at com.caucho.sql.UserStatement.executeBatch(UserStatement.java:213)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2397)
at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821)
at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3863)
at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52)
at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao$4.doInHibernate(HibernatePageDao.java:449)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getDescendents(HibernatePageDao.java:439)
at com.atlassian.confluence.pages.DefaultPageManager.getDescendents(DefaultPageManager.java:153)
at com.atlassian.confluence.pages.DefaultPageManager.removePageFromAncestorCollections(DefaultPageManager.java:180)
at com.atlassian.confluence.pages.Page.remove(Page.java:189)

Users with the same issue

37 times, 1 week ago
3 times, 1 month ago
Once, 2 months ago
Once, 2 months ago
32 times, 2 months ago

Write tip

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