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
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  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)

    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