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

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 Adalberto Schneider, 1 year ago
ERROR: update or delete on table "content" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (contentid)=(5799948) is still referenced from table "imagedetails".
via Atlassian JIRA by Adalberto Schneider [Atlassian], 1 year ago
ERROR: update or delete on table "content" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (contentid)=(5799948) is still referenced from table "imagedetails".
via Atlassian JIRA by Alex Conde [Atlassian], 1 year ago
ERROR: insert or update on table "content_label" violates foreign key constraint "fkf0e7436e27072aef" Detail: Key (labelid)=(10682403) is not present in table "label".
via Atlassian JIRA by Alejandro Conde Carrillo, 1 year ago
ERROR: insert or update on table "content_label" violates foreign key constraint "fkf0e7436e27072aef" Detail: Key (labelid)=(10682403) is not present in table "label".
via GitHub by aviriel
, 1 year ago
ERROR: value too long for type character varying(1024)
via alfresco.com by Unknown author, 2 years ago
ERROR: value too long for type character varying(1024)
org.postgresql.util.PSQLException: ERROR: update or delete on table "content" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (contentid)=(5799948) is still referenced from table "imagedetails".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:615)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:465)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:584)
at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2476)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2462)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2424)
at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1837)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1594)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1559)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
at com.atlassian.confluence.content.persistence.hibernate.PluginContentHibernateDao.lambda$findChildrenOfType$577(PluginContentHibernateDao.java:256)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

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