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

13
Samebug Inc., 1 year ago
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>
0
chinthana, 4 months ago
via stackoverflow.com by Unknown author
Upgrade the database driver to the latest and check.
```
<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>9.3-1101-jdbc41</version>
</dependency>
```
Replace version with the latest driver version.

Solutions on the web

Problem while deleting plans

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".

Problem while deleting plans

Why are my queries deadlocking?

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

another method can't be called while other ones is calling

ERROR: duplicate key value violates unique constraint "pk_tb_faq" Detail: Key (id_faq)=(135) already exists.

how can i tune postgres to avoid this error?

ERROR: could not write block 3478284 of temporary file: No space left on device

GitHub comment 30#64321925

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 org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)	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 org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)	at com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao.removeResultsSummariesForPlan(BuildResultsSummaryHibernateDao.java:553)	at com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao.removeResultsSummariesForPlan(BuildResultsSummaryHibernateDao.java:402)