2、 当出现添加/克隆 [10.127.3.4XXXXX]主机失败。错误信息(SQL statement execution has failed “INSERT INTO XXXX”)等类似的问题,可以通过update语句把报错的表的有关联外键xxxid的字段更新。 举例: 如图一下所示,当出现 INSERT INTO items …… Duplicae entry ‘69263’ for key ‘PRIMARY’,意思是和某个...
登录zabbix4.0界面,出现报错:SQL statement execution has failed "INSERT INTO sessions (sessionid,userid,lastaccess,status) VALUES ('6d1a0523bd8cd53179fcdfc3c397d343','1','1608889582','0')". 我遇到的情况是服务器突然断电,再开机后登录zabbix web界面出现此情况 初步判断为mysql数据库文件损坏,而且数...
When i try login in zabbix, i receive the error: SQL statement execution has failed "INSERT INTO sessions (sessionid,userid,lastaccess,status) VALUES ('b26e0dc6e80a192bc43814b39906e5f2','3','1603540119','0')". I running zabbix front with...
Type'help;'or'\h'forhelp. Type'\c'to clear the current input statement. MariaDB [(none)]>show database; ERROR1064(42000): You have an errorinyour SQL syntax; check the manual that corresponds to your MariaDB server versionforthe right syntax to use near'database'at line1MariaDB [(...
Fatal error: Uncaught exception 'DBException' with message 'SQL statement execution has failed "UPDATE hosts SET status='0' WHERE (hostid IN ('10084')) ".' in /srv/web/zabbix/include/classes/db/DB.php:48 Stack trace: #0 /srv/web/zabbix/include/classes/db/DB.php(448): DB::exception...
php_value max_execution_time300php_value memory_limit 128M php_value post_max_size 16M php_value upload_max_filesize 2M php_value max_input_time300 8、修改系统时间 安装ntp服务 # yum install ntpdate -y 调整为亚洲上海时区 # ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime ...
登录zabbix4.0界面,出现报错:SQL statement execution has failed "INSERT INTO sessions (sessionid,userid,lastaccess,status) VALUES ('6d1a0523bd8cd53179fcdfc3c397d343','1','1608889582','0')".我遇到的情况是服务器突然断电,再开机后登... 问答...
The last run of the job has failed. last(/MSSQL by Zabbix agent 2/mssql.job.runstatus["{#JOBNAME}"])=0 Warning Manual close: Yes MSSQL: Job '{#JOBNAME}': Job duration is high The job is taking too long. last(/MSSQL by Zabbix agent 2/mssql.job.run_duration["{#JOBNAME}"...
Error is thrown since Zabbix_Test user does not have read-write access to the "Test/Read-Only_Rights" host group under permissions but the host is in "Test/Admin_Rights" which the user has read-write access to. If you view the user permissions it shows "Host Test" has read-write righ...
Memory: Allocated by SQL Current SQL statement memory usage for root. Dependent itemcockroachdb.memory.sql Preprocessing Prometheus pattern:VALUE(sql_mem_root_current) SQL: Schema changes, rate Total number of SQL DDL statements successfully executed per second. ...