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
  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 | 12 months 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