[GH-ISSUE #3173] Deleting identities and domains results in a 500 internal server error #1787

New issue

Closed

opened 2026-02-27 11:19:07 +03:00 by kerem · 0 comments

kerem commented

2026-02-27 11:19:07 +03:00

Owner

Originally created by @y0va on GitHub (Jan 26, 2024).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/3173

Impacted versions

OS Type: Ubuntu
OS Version: Ubuntu 20.04.6
Database Type: PostgreSQL
Database version: 12.17
Modoboa: 2.2.4
installer used: Yes
Webserver: Nginx

Steps to reproduce

Delete Identity or domain in conventional or new admin interface.

Current behavior

I get 500 internal server error as result. in the psql logs I find:

2024-01-26 13:13:06.853 UTC [1318900] modoboa@modoboa ERROR:  update or delete on table "core_user" violates foreign key constraint "modoboa_contacts_addressbook_user_id_e49a5a75_fk_core_user_id" on table "modoboa_contacts_addressbook"
2024-01-26 13:13:06.853 UTC [1318900] modoboa@modoboa DETAIL:  Key (id)=(11) is still referenced from table "modoboa_contacts_addressbook".
2024-01-26 13:13:06.853 UTC [1318900] modoboa@modoboa STATEMENT:  COMMIT

Expected behavior

No error on delete.

Originally created by @y0va on GitHub (Jan 26, 2024). Original GitHub issue: https://github.com/modoboa/modoboa/issues/3173 # Impacted versions * OS Type: Ubuntu * OS Version: Ubuntu 20.04.6 * Database Type: PostgreSQL * Database version: 12.17 * Modoboa: 2.2.4 * installer used: Yes * Webserver: Nginx # Steps to reproduce Delete Identity or domain in conventional or new admin interface. # Current behavior I get 500 internal server error as result. in the psql logs I find: ``` 2024-01-26 13:13:06.853 UTC [1318900] modoboa@modoboa ERROR: update or delete on table "core_user" violates foreign key constraint "modoboa_contacts_addressbook_user_id_e49a5a75_fk_core_user_id" on table "modoboa_contacts_addressbook" 2024-01-26 13:13:06.853 UTC [1318900] modoboa@modoboa DETAIL: Key (id)=(11) is still referenced from table "modoboa_contacts_addressbook". 2024-01-26 13:13:06.853 UTC [1318900] modoboa@modoboa STATEMENT: COMMIT ``` # Expected behavior No error on delete.