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

    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