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

Atlassian JIRA | Krystian Brazulewicz [Atlassian] | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Spotted this while upgrading JBAC 3.4.1 dump to 3.4.3. Upgrade went smooth, then this popped in the logs: {noformat} 2012-01-13 10:27:46,521 INFO [QuartzScheduler_Worker-3] [DeletionServiceImpl] Deleting TEST-RELEASEMASTER 2012-01-13 10:27:47,014 WARN [QuartzScheduler_Worker-3] [BuildResultsSummaryHibernateDao] Unexpected exception while executing profiler wrapper 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) {noformat}

    Atlassian JIRA | 5 years ago | Krystian Brazulewicz [Atlassian]
    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".
  2. 0

    Spotted this while upgrading JBAC 3.4.1 dump to 3.4.3. Upgrade went smooth, then this popped in the logs: {noformat} 2012-01-13 10:27:46,521 INFO [QuartzScheduler_Worker-3] [DeletionServiceImpl] Deleting TEST-RELEASEMASTER 2012-01-13 10:27:47,014 WARN [QuartzScheduler_Worker-3] [BuildResultsSummaryHibernateDao] Unexpected exception while executing profiler wrapper 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) {noformat}

    Atlassian JIRA | 5 years ago | Krystian Brazulewicz [Atlassian]
    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".
  3. 0

    RE: Upgrade 5.2.3 to 6.0.5 - Forums | Liferay

    liferay.com | 1 year ago
    esql.util.PSQLException: ERROR: duplicate key value violates unique constraint "assetentry_pkey"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    RE: Upgrade 5.2.3 to 6.0.5 - Forums | Liferay

    liferay.com | 1 year ago
    esql.util.PSQLException: ERROR: duplicate key value violates unique constraint "assetentry_pkey"
  6. 0

    Upgrade 5.2.3 to 6.0.5 - Forums | Liferay

    liferay.com | 1 year ago
    esql.util.PSQLException: ERROR: duplicate key value violates unique constraint "assetentry_pkey"
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeUpdate
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
    6 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeUpdate
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
    1 frame
  4. com.atlassian.bamboo
    BuildResultsSummaryHibernateDao$10.doInHibernate
    1. com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao$11.call(BuildResultsSummaryHibernateDao.java:601)
    2. com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao$11.call(BuildResultsSummaryHibernateDao.java:597)
    3. com.atlassian.bamboo.util.BambooProfilingUtils.withUtilTimerStack(BambooProfilingUtils.java:35)
    4. com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao.removeResultsSummariesForPlanExecuteQuery(BuildResultsSummaryHibernateDao.java:596)
    5. com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao.access$600(BuildResultsSummaryHibernateDao.java:70)
    6. com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao$10.doInHibernate(BuildResultsSummaryHibernateDao.java:567)
    7. com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao$10.doInHibernate(BuildResultsSummaryHibernateDao.java:554)
    7 frames
  5. Hibernate
    HibernateTemplate.execute
    1. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
    2. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
    2 frames
  6. com.atlassian.bamboo
    BuildResultsSummaryHibernateDao.removeResultsSummariesForPlan
    1. com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao.removeResultsSummariesForPlan(BuildResultsSummaryHibernateDao.java:553)
    2. com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao.removeResultsSummariesForPlan(BuildResultsSummaryHibernateDao.java:402)
    2 frames