org.postgresql.util.PSQLException: ERROR: update or delete on table "original_message" violat es foreign key constraint "fk9b54a99e97018bb7" on table "translated_message" @400000004d89dc5b2d59cf54 Detail: Key (id)=(31031) is still referenced from table "translated_message". @400000004d89dc5b2d59cf54 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) @400000004d89dc5b2d59d33c at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) @400000004d89dc5b2d59e2dc at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) @400000004d89dc5b2d59e6c4 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) @400000004d89dc5b2d59eaac at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) @400000004d89dc5b2d59ee94 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) @400000004d89dc5b2d5a486c at translate.imports.AdminService$_deleteInstalledVersion_closure7.doCall(AdminService.groovy:94) @400000004d89dc5b2d5a4c54 at translate.imports.AdminService$_deleteInstalledVersion_closure7.doCall(AdminService.groovy) @400000004d89dc5b2d5a503c at translate.TimeMixin$_closure1.doCall(TimeMixin.groovy:7) @400000004d89dc5b2d5a5424 at translate.imports.AdminService.deleteInstalledVersion(AdminService.groovy:93) @400000004d89dc5b2d5a63c4 at translate.imports.AdminService.this$2$deleteInstalledVersion(AdminService.groovy) @400000004d89dc5b2d5a67ac at translate.imports.AdminService$_deleteVersionWorker_closure1.doCall(AdminService.groovy:46) @400000004d89dc5b2d5a67ac at translate.imports.AdminService$_deleteVersionWorker_closure1.doCall(AdminService.groovy) @400000004d89dc5b2d5a6b94 at translate.TimeMixin$_closure1.doCall(TimeMixin.groovy:7) @400000004d89dc5b2d5a7b34 at translate.imports.AdminService.deleteVersionWorker(AdminService.groovy:45)

Atlassian JIRA | Jacek Jaroczynski [Atlassian] Bugmaster | 6 years ago
  1. 0

    ERROR errors.GrailsExceptionResolver - ERROR: update or delete on table "original_message" violates foreign key constraint "fk9b54a99e97018bb7" on table "translated_message " @400000004d89dc5b2d59a844 Detail: Key (id)=(31031) is still referenced from table "translated_message". @400000004d89dc5b2d59ac2c org.postgresql.util.PSQLException: ERROR: update or delete on table "original_message" violat es foreign key constraint "fk9b54a99e97018bb7" on table "translated_message" @400000004d89dc5b2d59cf54 Detail: Key (id)=(31031) is still referenced from table "translated_message". @400000004d89dc5b2d59cf54 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) @400000004d89dc5b2d59d33c at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) @400000004d89dc5b2d59e2dc at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) @400000004d89dc5b2d59e6c4 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) @400000004d89dc5b2d59eaac at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) @400000004d89dc5b2d59ee94 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) @400000004d89dc5b2d5a486c at translate.imports.AdminService$_deleteInstalledVersion_closure7.doCall(AdminService.groovy:94) @400000004d89dc5b2d5a4c54 at translate.imports.AdminService$_deleteInstalledVersion_closure7.doCall(AdminService.groovy) @400000004d89dc5b2d5a503c at translate.TimeMixin$_closure1.doCall(TimeMixin.groovy:7) @400000004d89dc5b2d5a5424 at translate.imports.AdminService.deleteInstalledVersion(AdminService.groovy:93) @400000004d89dc5b2d5a63c4 at translate.imports.AdminService.this$2$deleteInstalledVersion(AdminService.groovy) @400000004d89dc5b2d5a67ac at translate.imports.AdminService$_deleteVersionWorker_closure1.doCall(AdminService.groovy:46) @400000004d89dc5b2d5a67ac at translate.imports.AdminService$_deleteVersionWorker_closure1.doCall(AdminService.groovy) @400000004d89dc5b2d5a6b94 at translate.TimeMixin$_closure1.doCall(TimeMixin.groovy:7) @400000004d89dc5b2d5a7b34 at translate.imports.AdminService.deleteVersionWorker(AdminService.groovy:45) @400000004d89dc5b2d5a7f1c at translate.imports.AdminService.this$2$deleteVersionWorker(AdminService.groovy) @400000004d89dc5b2d5a7f1c at translate.imports.AdminService$this$2$deleteVersionWorker.callCurrent(Unknown Source) @400000004d89dc5b2d5a8304 at translate.imports.AdminService.deleteVersion(AdminService.groovy:27) @400000004d89dc5b2d5aa244 at translate.imports.AdminService$deleteVersion.call(Unknown Source) @400000004d89dc5b2d5aa62c at translate.AdminController$_deleteVersion_closure15.doCall(AdminController.groovy:206) @400000004d89dc5b2d5aaa14 at translate.AdminController$_deleteVersion_closure15.doCall(AdminController.groovy) @400000004d89dc5b2d5aaa14 at translate.TimeMixin$_closure1.doCall(TimeMixin.groovy:7) @400000004d89dc5b2d5aadfc at translate.AdminController.deleteVersion(AdminController.groovy:205) @400000004d89dc5b2d5abd9c at translate.AdminController$_closure3_closure20.doCall(AdminController.groovy:50) @400000004d89dc5b2d5ac184 at translate.AdminController$_closure3_closure20.call(AdminController.groovy) @400000004d89dc5b2d5ac184 at translate.AjaxRequestProcessor$_closure1.doCall(AjaxRequestProcessor.groovy:26) @400000004d89dc5b2d5ac56c at translate.AdminController$_closure3.doCall(AdminController.groovy:33) @400000004d89dc5b2d5ad50c at translate.AdminController$_closure3.doCall(AdminController.groovy) @400000004d89dc5b2d5ad8f4 at com.studentsonly.grails.plugins.uiperformance.CacheFilter.doFilter(CacheFilter.java:67) @400000004d89dc5b2d5ad8f4 at java.lang.Thread.run(Thread.java:619)

    Atlassian JIRA | 6 years ago | Jacek Jaroczynski [Atlassian] Bugmaster
    org.postgresql.util.PSQLException: ERROR: update or delete on table "original_message" violat es foreign key constraint "fk9b54a99e97018bb7" on table "translated_message" @400000004d89dc5b2d59cf54 Detail: Key (id)=(31031) is still referenced from table "translated_message". @400000004d89dc5b2d59cf54 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) @400000004d89dc5b2d59d33c at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) @400000004d89dc5b2d59e2dc at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) @400000004d89dc5b2d59e6c4 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) @400000004d89dc5b2d59eaac at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) @400000004d89dc5b2d59ee94 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) @400000004d89dc5b2d5a486c at translate.imports.AdminService$_deleteInstalledVersion_closure7.doCall(AdminService.groovy:94) @400000004d89dc5b2d5a4c54 at translate.imports.AdminService$_deleteInstalledVersion_closure7.doCall(AdminService.groovy) @400000004d89dc5b2d5a503c at translate.TimeMixin$_closure1.doCall(TimeMixin.groovy:7) @400000004d89dc5b2d5a5424 at translate.imports.AdminService.deleteInstalledVersion(AdminService.groovy:93) @400000004d89dc5b2d5a63c4 at translate.imports.AdminService.this$2$deleteInstalledVersion(AdminService.groovy) @400000004d89dc5b2d5a67ac at translate.imports.AdminService$_deleteVersionWorker_closure1.doCall(AdminService.groovy:46) @400000004d89dc5b2d5a67ac at translate.imports.AdminService$_deleteVersionWorker_closure1.doCall(AdminService.groovy) @400000004d89dc5b2d5a6b94 at translate.TimeMixin$_closure1.doCall(TimeMixin.groovy:7) @400000004d89dc5b2d5a7b34 at translate.imports.AdminService.deleteVersionWorker(AdminService.groovy:45)
  2. 0

    OpenNMS / Mailing Lists

    sourceforge.net | 1 year ago
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1" Position: 13 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.execute(AbstractJdbc2Statement.java:360) at org.opennms.netmgt.dao.db.InstallerDb.databaseSetUser(InstallerDb.java:1940)
  3. 0

    OpenNMS / Mailing Lists

    sourceforge.net | 3 months ago
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1" Position: 13 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.execute(AbstractJdbc2Statement.java:360) at org.opennms.netmgt.dao.db.InstallerDb.databaseSetUser(InstallerDb.java:1940)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    POSIntegration

    Google Groups | 7 months ago | Jianfeng Wang
    org.postgresql.util.PSQLException: ERROR: update or delete on table "ad_package_imp_proc" violates foreign key constraint "adpackageimpproc_adpackageimp" on table "ad_package_imp" Detail: Key (ad_package_imp_proc_id)=(1000002) is still referenced from table "ad_package_imp".; State=23503; ErrorCode=0 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173) at org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:824) at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:848) at com.mchange.v2.c3p0.impl.NewProxyConnection.commit(NewProxyConnection.java:1007)
  6. 0

    POSIntegration

    Google Groups | 7 months ago | Jianfeng Wang
    org.postgresql.util.PSQLException: ERROR: update or delete on table "ad_package_imp_proc" violates foreign key constraint "adpackageimpproc_adpackageimp" on table "ad_package_imp" Detail: Key (ad_package_imp_proc_id)=(1000003) is still referenced from table "ad_package_imp".; State=23503; ErrorCode=0 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173) at org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:824) at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:848) at com.mchange.v2.c3p0.impl.NewProxyConnection.commit(NewProxyConnection.java:1007)

    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 "original_message" violat es foreign key constraint "fk9b54a99e97018bb7" on table "translated_message" @400000004d89dc5b2d59cf54 Detail: Key (id)=(31031) is still referenced from table "translated_message". @400000004d89dc5b2d59cf54 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) @400000004d89dc5b2d59d33c at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) @400000004d89dc5b2d59e2dc at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) @400000004d89dc5b2d59e6c4 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) @400000004d89dc5b2d59eaac at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) @400000004d89dc5b2d59ee94 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) @400000004d89dc5b2d5a486c at translate.imports.AdminService$_deleteInstalledVersion_closure7.doCall(AdminService.groovy:94) @400000004d89dc5b2d5a4c54 at translate.imports.AdminService$_deleteInstalledVersion_closure7.doCall(AdminService.groovy) @400000004d89dc5b2d5a503c at translate.TimeMixin$_closure1.doCall(TimeMixin.groovy:7) @400000004d89dc5b2d5a5424 at translate.imports.AdminService.deleteInstalledVersion(AdminService.groovy:93) @400000004d89dc5b2d5a63c4 at translate.imports.AdminService.this$2$deleteInstalledVersion(AdminService.groovy) @400000004d89dc5b2d5a67ac at translate.imports.AdminService$_deleteVersionWorker_closure1.doCall(AdminService.groovy:46) @400000004d89dc5b2d5a67ac at translate.imports.AdminService$_deleteVersionWorker_closure1.doCall(AdminService.groovy) @400000004d89dc5b2d5a6b94 at translate.TimeMixin$_closure1.doCall(TimeMixin.groovy:7) @400000004d89dc5b2d5a7b34 at translate.imports.AdminService.deleteVersionWorker(AdminService.groovy:45)

      at translate.imports.AdminService.this$2$deleteVersionWorker()
    2. translate.imports
      AdminService$this$2$deleteVersionWorker.callCurrent
      1. translate.imports.AdminService.this$2$deleteVersionWorker(AdminService.groovy)
      2. translate.imports.AdminService$this$2$deleteVersionWorker.callCurrent(Unknown Source)
      2 frames