org.postgresql.util.PSQLException: ERROR: update or delete on table "repository_changeset" violates foreign key constraint "fk34a3e6e3cbadfcbd" on table "relevant_changesets" Detail: Key (repository_changeset_id)=(166767264) is still referenced from table "relevant_changesets".

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 Krystian Brazulewicz [Atlassian], 1 year ago
ERROR: update or delete on table "repository_changeset" violates foreign key constraint "fk34a3e6e3cbadfcbd" on table "relevant_changesets" Detail: Key (repository_changeset_id)=(166767264) is still referenced from table "relevant_changesets".
via Atlassian JIRA by Krystian Brazulewicz [Atlassian], 1 year ago
ERROR: update or delete on table "repository_changeset" violates foreign key constraint "fk34a3e6e3cbadfcbd" on table "relevant_changesets" Detail: Key (repository_changeset_id)=(166767264) is still referenced from table "relevant_changesets".
via Stack Overflow by Scott
, 2 years ago
ERROR: deadlock detected Detail: Process 8949 waits for ShareLock on transaction 256629; blocked by process 8924. Process 8924 waits for ExclusiveLock on tuple (4148,40) of relation 30265 of database 16384; blocked by process 8949. Hint: See
via Stack Overflow by Aulia Ardy
, 2 years ago
ERROR: duplicate key value violates unique constraint "pk_tb_faq" Detail: Key (id_faq)=(135) already exists.
via Server Fault by pstanton
, 1 year ago
ERROR: could not write block 3478284 of temporary file: No space left on device
via GitHub by jayp
, 2 years ago
ERROR: column "data" is of type json but expression is of type character varying Hint: You will need to rewrite or cast the expression. Position: 51
org.postgresql.util.PSQLException: ERROR: update or delete on table "repository_changeset" violates foreign key constraint "fk34a3e6e3cbadfcbd" on table "relevant_changesets" Detail: Key (repository_changeset_id)=(166767264) is still referenced from table "relevant_changesets".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao$11.call(BuildResultsSummaryHibernateDao.java:601)
at com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao$11.call(BuildResultsSummaryHibernateDao.java:597)
at com.atlassian.bamboo.util.BambooProfilingUtils.withUtilTimerStack(BambooProfilingUtils.java:35)
at com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao.removeResultsSummariesForPlanExecuteQuery(BuildResultsSummaryHibernateDao.java:596)
at com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao.access$600(BuildResultsSummaryHibernateDao.java:70)
at com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao$10.doInHibernate(BuildResultsSummaryHibernateDao.java:567)
at com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao$10.doInHibernate(BuildResultsSummaryHibernateDao.java:554)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
at com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao.removeResultsSummariesForPlan(BuildResultsSummaryHibernateDao.java:553)
at com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao.removeResultsSummariesForPlan(BuildResultsSummaryHibernateDao.java:402)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 3 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
102 more bugmates

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