Hi. So i have Zabbix for MySQL monitoring. Now it shows errors:
But it doesnt show data. I see in the logs:
892:20230930:184227.642 item "WebHostManager:mysql.threads_cached" became supported
892:20230930:184227.642 item "WebHostManager:mysql.threads_connected" became supported
892:20230930:184227.642 item "WebHostManager:mysql.threads_running" became supported
892:20230930:184227.642 item "WebHostManager:mysql.uptime" became supported
894:20230930:184229.644 item "WebHostManager:mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWO RD}"]" became supported
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
894:20230930:184324.691 item "WebHostManager:mysql.buffer_pool_efficiency" became supported
891:20230930:184325.692 item "WebHostManager:mysql.buffer_pool_utilization" became supported
890:20230930:184327.696 error reason for "WebHostManager:mysql.innodb_log_file_size" changed: Cannot evaluate function: not enough data at "last(//mysql.innodb_os_log_written,#1:now-1h)) / {$MYSQL.INNODB_LOG_FILES}".
890:20230930:184327.696 item "WebHostManager:mysql.aborted_clients.rate" became supported
891:20230930:183917.466 item "WebHostManager:zabbix[process,connector worker,avg,busy]" became not supported: No "connector worker" processes started.
890:20230930:183924.474 error reason for "WebHostManager:mysql.buffer_pool_efficiency" changed: Cannot evaluate function: item "/WebHostManager/mysql.innodb_buffer_pool_reads" is not supported at "last(//mysql.innodb_buffer_pool_reads) /
( last(//mysql.innodb_buffer_pool_read_requests) +
( last(//mysql.innodb_buffer_pool_read_requests) = 0 ) ) * 100 *
( last(//mysql.innodb_buffer_pool_read_requests) > 0 )".
894:20230930:183925.477 error reason for "WebHostManager:mysql.buffer_pool_utilization" changed: Cannot evaluate function: item "/WebHostManager/mysql.innodb_buffer_pool_pages_total" is not supported at "last(//mysql.innodb_buffer_pool_pages_total) -
last(//mysql.innodb_buffer_pool_pages_free) ) /
( last(//mysql.innodb_buffer_pool_pages_total) +
( last(//mysql.innodb_buffer_pool_pages_total) = 0 ) ) * 100 *
( last(//mysql.innodb_buffer_pool_pages_total) > 0 )".
891:20230930:183926.478 item "WebHostManager:zabbix[process,ipmi manager,avg,busy]" became not supported: No "ipmi manager" processes started.
891:20230930:183926.478 item "WebHostManager:zabbix[process,ipmi poller,avg,busy]" became not supported: No "ipmi poller" processes started.
892:20230930:183928.480 item "WebHostManager:zabbix[process,java poller,avg,busy]" became not supported: No "java poller" processes started.
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
892:20230930:183933.486 item "WebHostManager:vfs.file.contents["/sys/class/net/ens3/speed"]" became not supported: Value of type "double" is not suitable for value type "Numeric (unsigned)". Value "-1000000"
892:20230930:183933.486 item "WebHostManager:vfs.file.contents["/sys/class/net/wg0/speed"]" became not supported: Cannot read from file: read /sys/class/net/wg0/speed: invalid argument
891:20230930:183935.492 item "WebHostManager:zabbix[process,report manager,avg,busy]" became not supported: No "report manager" processes started.
894:20230930:183936.492 item "WebHostManager:vfs.dev.read.await[sda]" became not supported: Cannot evaluate function: not enough data at "last(//vfs.dev.read.time.rate[sda])/(last(//vfs.dev.read.rate[sda])+(last(//vfs.dev.read.rate[sda])=0)))*1000*(last(//vfs.dev.read.rate[sda]) >> 890:20230930:183937.493 item "WebHostManager:vfs.dev.write.await[sda]" became not supported: Cannot evaluate function: not enough data at "last(//vfs.dev.write.time.rate[sda])/(last(//vfs.dev.write.rate[sda])+(last(//vfs.dev.write.rate[sda])=0)))*1000*(last(//vfs.dev.write.rate[sd> 890:20230930:183937.493 item "WebHostManager:zabbix[process,report writer,avg,busy]" became not supported: No "report writer" processes started.
891:20230930:183939.498 item "WebHostManager:zabbix[process,snmp trapper,avg,busy]" became not supported: No "snmp trapper" processes started.
891:20230930:183945.503 item "WebHostManager:zabbix[process,vmware collector,avg,busy]" became not supported: No "vmware collector" processes started.
892:20230930:183957.513 item "WebHostManager:zabbix[vmware,buffer,pused]" became not supported: No "vmware collector" processes started.
891:20230930:184008.523 item "WebHostManager:zabbix[connector_queue]" became not supported: connector is not initialized: please check "StartConnectors" configuration parameter
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
890:20230930:184136.598 item "WebHostManager:vfs.dev.read.await[sda]" became supported
892:20230930:
How can i fix this?
But it doesnt show data. I see in the logs:
892:20230930:184227.642 item "WebHostManager:mysql.threads_cached" became supported
892:20230930:184227.642 item "WebHostManager:mysql.threads_connected" became supported
892:20230930:184227.642 item "WebHostManager:mysql.threads_running" became supported
892:20230930:184227.642 item "WebHostManager:mysql.uptime" became supported
894:20230930:184229.644 item "WebHostManager:mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWO RD}"]" became supported
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
894:20230930:184324.691 item "WebHostManager:mysql.buffer_pool_efficiency" became supported
891:20230930:184325.692 item "WebHostManager:mysql.buffer_pool_utilization" became supported
890:20230930:184327.696 error reason for "WebHostManager:mysql.innodb_log_file_size" changed: Cannot evaluate function: not enough data at "last(//mysql.innodb_os_log_written,#1:now-1h)) / {$MYSQL.INNODB_LOG_FILES}".
890:20230930:184327.696 item "WebHostManager:mysql.aborted_clients.rate" became supported
891:20230930:183917.466 item "WebHostManager:zabbix[process,connector worker,avg,busy]" became not supported: No "connector worker" processes started.
890:20230930:183924.474 error reason for "WebHostManager:mysql.buffer_pool_efficiency" changed: Cannot evaluate function: item "/WebHostManager/mysql.innodb_buffer_pool_reads" is not supported at "last(//mysql.innodb_buffer_pool_reads) /
( last(//mysql.innodb_buffer_pool_read_requests) +
( last(//mysql.innodb_buffer_pool_read_requests) = 0 ) ) * 100 *
( last(//mysql.innodb_buffer_pool_read_requests) > 0 )".
894:20230930:183925.477 error reason for "WebHostManager:mysql.buffer_pool_utilization" changed: Cannot evaluate function: item "/WebHostManager/mysql.innodb_buffer_pool_pages_total" is not supported at "last(//mysql.innodb_buffer_pool_pages_total) -
last(//mysql.innodb_buffer_pool_pages_free) ) /
( last(//mysql.innodb_buffer_pool_pages_total) +
( last(//mysql.innodb_buffer_pool_pages_total) = 0 ) ) * 100 *
( last(//mysql.innodb_buffer_pool_pages_total) > 0 )".
891:20230930:183926.478 item "WebHostManager:zabbix[process,ipmi manager,avg,busy]" became not supported: No "ipmi manager" processes started.
891:20230930:183926.478 item "WebHostManager:zabbix[process,ipmi poller,avg,busy]" became not supported: No "ipmi poller" processes started.
892:20230930:183928.480 item "WebHostManager:zabbix[process,java poller,avg,busy]" became not supported: No "java poller" processes started.
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
892:20230930:183933.486 item "WebHostManager:vfs.file.contents["/sys/class/net/ens3/speed"]" became not supported: Value of type "double" is not suitable for value type "Numeric (unsigned)". Value "-1000000"
892:20230930:183933.486 item "WebHostManager:vfs.file.contents["/sys/class/net/wg0/speed"]" became not supported: Cannot read from file: read /sys/class/net/wg0/speed: invalid argument
891:20230930:183935.492 item "WebHostManager:zabbix[process,report manager,avg,busy]" became not supported: No "report manager" processes started.
894:20230930:183936.492 item "WebHostManager:vfs.dev.read.await[sda]" became not supported: Cannot evaluate function: not enough data at "last(//vfs.dev.read.time.rate[sda])/(last(//vfs.dev.read.rate[sda])+(last(//vfs.dev.read.rate[sda])=0)))*1000*(last(//vfs.dev.read.rate[sda]) >> 890:20230930:183937.493 item "WebHostManager:vfs.dev.write.await[sda]" became not supported: Cannot evaluate function: not enough data at "last(//vfs.dev.write.time.rate[sda])/(last(//vfs.dev.write.rate[sda])+(last(//vfs.dev.write.rate[sda])=0)))*1000*(last(//vfs.dev.write.rate[sd> 890:20230930:183937.493 item "WebHostManager:zabbix[process,report writer,avg,busy]" became not supported: No "report writer" processes started.
891:20230930:183939.498 item "WebHostManager:zabbix[process,snmp trapper,avg,busy]" became not supported: No "snmp trapper" processes started.
891:20230930:183945.503 item "WebHostManager:zabbix[process,vmware collector,avg,busy]" became not supported: No "vmware collector" processes started.
892:20230930:183957.513 item "WebHostManager:zabbix[vmware,buffer,pused]" became not supported: No "vmware collector" processes started.
891:20230930:184008.523 item "WebHostManager:zabbix[connector_queue]" became not supported: connector is not initialized: please check "StartConnectors" configuration parameter
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
890:20230930:184136.598 item "WebHostManager:vfs.dev.read.await[sda]" became supported
892:20230930:
How can i fix this?