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

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 Thuan Nguyen Ngoc Hieu [Atlassian], 1 year ago
ERROR: update or delete on table "content" violates foreign key constraint "fk4514b9c8dd41734" on table "likes" Detail: Key (contentid)=(211649701) is still referenced from table "likes".
via Stack Overflow by My God
, 1 year ago
ERROR: column json_data" is of type json but expression is of type bytea Hint: You will need to rewrite or cast the expression. Position: 247
via Google Groups by Ramon Davila, 7 months ago
via Atlassian JIRA by Michael Heemskerk, 1 year ago
ERROR: duplicate key value violates unique constraint "uk_trusted_app_restrict" Detail: Key (trusted_app_id, restriction_type, restriction_value)=(3, 0, 127.0.0.1) already exists.
via Atlassian JIRA by Michael Heemskerk, 1 year ago
ERROR: duplicate key value violates unique constraint "uk_trusted_app_restrict" Detail: Key (trusted_app_id, restriction_type, restriction_value)=(3, 0, 127.0.0.1) already exists.
org.postgresql.util.PSQLException: ERROR: update or delete on table "content" violates foreign key constraint "fk4514b9c8dd41734" on table "likes" Detail: Key (contentid)=(211649701) is still referenced from table "likes".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893)
at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:344)
at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:344)
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.BatcherImpl.prepareStatement(BatcherImpl.java:61)
at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:58)
at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:111)
at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:570)
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.findBySQL(SessionImpl.java:3897)
at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52)
at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.lambda$getDescendants$96(HibernatePageDao.java:798)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Once, 3 days ago
Once, 6 days ago
Samebug visitor profile picture
Unknown user
Once, 6 days ago
100 more bugmates

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