简介:问题整理:ZABBIX4.0登录界面出现错误 SQL statement execution has failed “INSERT INTO sessions (sessionid,userid,.. 登录zabbix4.0界面,出现报错:SQL statement execution has failed "INSERTINTO sessions (sessionid,userid,lastaccess,status) VALUES ('6d1a0523bd8cd53179fcdfc3c397d343','1','16088895...
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...
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...
zabbix6.0-web-pgsql.noarch6.0.25-1.el7 epel [root@mcw03~]# 执行,需要安装的包,不装这个,zabbix6.0-server.noarch,后面那个才是对的zabbix-release [root@mcw03 ~]# yum install zabbix6.0-server.noarch zabbix6.0-server-mysql zabbix6.0-web-mysql zabbix-agent zabbix-get-y ...
登录zabbix4.0界面,出现报错:SQL statement execution has failed "INSERT INTO sessions (sessionid,userid,lastaccess,status) VALUES ('6d1a0523bd8cd53179fcdfc3c397d343','1','1608889582','0')".我遇到的情况是服务器突然断电,再开机后登... 问答...
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 ...
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. ...
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}"...