Ad Widget

Collapse

Zabbix MySQL DB Slave error: a foreign key constraint fails

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • waydeechen
    Junior Member
    • Jun 2014
    • 16

    #1

    Zabbix MySQL DB Slave error: a foreign key constraint fails

    HI :

    When i set up zabbix server database master-slave to backup database , i got a error: "Last_SQL_Error: Error 'Cannot add or update a child row: a foreign key constraint fails"
    I set global foreign_key_checks=0 and set session foreign_key_checks=0 , but error continue

    How can i solve this problem?
Working...