Ad Widget

Collapse

Foreign key constraint violation after restart

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • DmitryMigunov
    Junior Member
    • May 2024
    • 2

    #1

    Foreign key constraint violation after restart

    After Zabbix restart, zabbix-server cannot operate normally, I have tons of errors like this:

    Code:
    305:20240502:102400.651 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: insert or update on table "alerts" violates foreign key constraint "c_alerts_2"
    DETAIL: Key (eventid)=(1064311) is not present in table "events".
    419:20240502:102402.682 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: insert or update on table "event_tag" violates foreign key constraint "c_event_tag_1"
    DETAIL: Key (eventid)=(1061993) is not present in table "events".
    Zabbix infinitely tries to create alerts and event_tag, but it fails and does it again.
    Last edited by DmitryMigunov; 02-05-2024, 12:54.
Working...