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)

Solutions on the web3355

  • via Atlassian JIRA by Jacek Jaroczynski [Atlassian] Bugmaster, 9 months ago
    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
  • via sourceforge.net by Unknown author, 1 year ago
    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
  • via sourceforge.net by Unknown author, 10 months ago
    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
  • Stack trace

    • 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(AdminService.groovy) at translate.imports.AdminService$this$2$deleteVersionWorker.callCurrent(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You are the first who have seen this exception. Write a tip to help other users and build your expert profile.