我们搞了一次数据库迁移,环境2切到环境3,切到环境3后做一些禁用、删除的业务测试报这个外键错误。
Error in query [UPDATE hosts SET status='1',monitored_by='2',tls_connect='1',tls_accept='1',tls_issuer='',tls_subject='',tls_psk_identity='',tls_psk='',proxyid=NULL WHERE hostid='17682'] [Cannot delete or update a parent row: a foreign key constraint fails] [zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerPopupMassupdateHost->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->update() → CHost->updateForce() → CHost->massUpdate() → DB::update() → DBexecute() → trigger_error() in include/db.inc.php:362]
SQL statement execution has failed "UPDATE hosts SET status='1',monitored_by='2',tls_connect='1',tls_accept='1',tls_issuer='',tls_subject='',tls_psk_identity='',tls_psk='',proxyid=NULL WHERE hostid='17682'".
我们后来查了数据库环境2的外键是关闭的,环境3的是打开的
请问,zabbix 是不是要求外键约束必须打开?环境2的外键一直是关闭的,会有什么问题吗?
错误信息