【 使用环境 】生产环境
【 OB or 其他组件 】 V4.3.5_CE_BP2_HF1
【 使用版本 】
【问题描述】zabbix中部分操作无法执行
【复现路径】
禁用主机时报错
无法禁用主机
Error in query [UPDATE hosts SET status='1' WHERE hostid='10998'] [Cannot delete or update a parent row: a foreign key constraint fails] [zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostDisable->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描述式执行已失败: "UPDATE hosts SET status='1' WHERE hostid='10998'".
添加模板时报错
Error in query [UPDATE hosts SET status='0' WHERE hostid='10998'] [Cannot delete or update a parent row: a foreign key constraint fails] [zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostUpdate->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描述式执行已失败: "UPDATE hosts SET status='0' WHERE hostid='10998'".
【附件及日志】
