Hi,
I installed Zappix yesterday on my server with Server, Agent 2 and frontend. Then I added some hosts with the Linux template which works. Then I added the template "MySQL by Zabbix agent 2" to monitor my database. Server/Agent on same maschine. But I can't see any data in "Latest data". So I thought it's a configuration error and changed the {$MYSQL.DSN} macro value very often. No difference.
First of all my config:
I didn't change any MySQL related stuff in config files, only in the frontend.
I tried different values for {$MYSQL.DSN} such as localhost, localhost:3306, tcp://127.0.0.1:3306 and so on. But can't see data.
zabbix_agentd.log:
zabbix_server.log:
Do I have to open more ports? In the first log you see "connection refused" on port 10051?! But I'm on localhost. So that's shouldn't be relevant?!
I installed Zappix yesterday on my server with Server, Agent 2 and frontend. Then I added some hosts with the Linux template which works. Then I added the template "MySQL by Zabbix agent 2" to monitor my database. Server/Agent on same maschine. But I can't see any data in "Latest data". So I thought it's a configuration error and changed the {$MYSQL.DSN} macro value very often. No difference.
First of all my config:
I didn't change any MySQL related stuff in config files, only in the frontend.
I tried different values for {$MYSQL.DSN} such as localhost, localhost:3306, tcp://127.0.0.1:3306 and so on. But can't see data.
zabbix_agentd.log:
Code:
21515:20230127:232439.027 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 21515:20230127:232439.027 **** Enabled features **** 21515:20230127:232439.027 IPv6 support: YES 21515:20230127:232439.027 TLS support: YES 21515:20230127:232439.027 ************************** 21515:20230127:232439.027 using configuration file: /etc/zabbix/zabbix_agentd.conf 21515:20230127:232439.027 agent #0 started [main process] <! --- shortend --> 21520:20230127:232439.029 agent #5 started [active checks #1] 21520:20230127:232439.031 Unable to connect to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Connection refused] 21520:20230127:232439.031 Unable to send heartbeat message to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Connection refused] 21520:20230127:232439.031 Unable to connect to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Connection refused] 21520:20230127:232439.031 Active check configuration update started to fail 21515:20230127:232735.573 Got signal [signal:15(SIGTERM),sender_pid:22069,sender_uid:120,reason:0]. Exiting ... 21515:20230127:232735.575 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 22077:20230127:232735.585 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 22077:20230127:232735.585 **** Enabled features **** 22077:20230127:232735.585 IPv6 support: YES 22077:20230127:232735.585 TLS support: YES 22077:20230127:232735.585 ************************** 22077:20230127:232735.585 using configuration file: /etc/zabbix/zabbix_agentd.conf 22077:20230127:232735.585 agent #0 started [main process] 22078:20230127:232735.586 agent #1 started [collector] 22079:20230127:232735.586 agent #2 started[listener #1] <! --- shortend --> 22082:20230127:232735.587 agent #5 started [active checks #1] 22082:20230127:232735.590 Unable to connect to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Connection refused] 22082:20230127:232735.590 Unable to send heartbeat message to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Connection refused] 22082:20230127:232735.590 Unable to connect to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Connection refused] 22082:20230127:232735.590 Active check configuration update started to fail 22082:20230127:232835.598 Successfully sent heartbeat message to [127.0.0.1]:10051 22082:20230127:232835.600 Active check configuration update from [127.0.0.1:10051] is working again 22077:20230128:004530.741 Got signal [signal:15(SIGTERM),sender_pid:24956,sender_uid:120,reason:0]. Exiting ... 22077:20230128:004530.743 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 24959:20230128:004530.752 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 24959:20230128:004530.752 **** Enabled features **** 24959:20230128:004530.752 IPv6 support: YES 24959:20230128:004530.752 TLS support: YES 24959:20230128:004530.752 ************************** 24959:20230128:004530.752 using configuration file: /etc/zabbix/zabbix_agentd.conf 24959:20230128:004530.753 agent #0 started [main process] 24960:20230128:004530.753 agent #1 started [collector] 24961:20230128:004530.753 agent #2 started[listener #1] 24962:20230128:004530.754 agent #3 started[listener #2] 24963:20230128:004530.754 agent #4 started[listener #3] 24964:20230128:004530.754 agent #5 started [active checks #1] 24959:20230128:005552.413 Got signal [signal:15(SIGTERM),sender_pid:25172,sender_uid:120,reason:0]. Exiting ... 24959:20230128:005552.414 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 25175:20230128:005552.424 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 25175:20230128:005552.424 **** Enabled features **** 25175:20230128:005552.424 IPv6 support: YES 25175:20230128:005552.424 TLS support: YES 25175:20230128:005552.424 ************************** 25175:20230128:005552.424 using configuration file: /etc/zabbix/zabbix_agentd.conf 25175:20230128:005552.424 agent #0 started [main process] 25176:20230128:005552.425 agent #1 started [collector] 25177:20230128:005552.425 agent #2 started[listener #1] <! --- shortend --> 25180:20230128:005552.426 agent #5 started [active checks #1] 25180:20230128:005555.428 Unable to receive from [127.0.0.1]:10051 [ZBX_TCP_READ() timed out] 25180:20230128:005555.428 Active check configuration update started to fail 25180:20230128:005655.440 Active check configuration update from [127.0.0.1:10051] is working again 25175:20230128:010257.553 Got signal [signal:15(SIGTERM),sender_pid:25339,sender_uid:120,reason:0]. Exiting ... 25175:20230128:010257.554 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 25342:20230128:010257.564 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 25342:20230128:010257.564 **** Enabled features **** 25342:20230128:010257.564 IPv6 support: YES 25342:20230128:010257.564 TLS support: YES 25342:20230128:010257.564 ************************** 25342:20230128:010257.564 using configuration file: /etc/zabbix/zabbix_agentd.conf 25342:20230128:010257.564 agent #0 started [main process] 25343:20230128:010257.565 agent #1 started [collector] <! --- shortend --> 25347:20230128:010257.567 agent #5 started [active checks #1] 25347:20230128:011100.653 Unable to receive from [127.0.0.1]:10051 [ZBX_TCP_READ() timed out] 25347:20230128:011100.653 Active check configuration update started to fail 25347:20230128:011200.664 Active check configuration update from [127.0.0.1:10051] is working again 25342:20230128:011318.634 Got signal [signal:15(SIGTERM),sender_pid:25625,sender_uid:120,reason:0]. Exiting ... 25342:20230128:011318.635 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 25628:20230128:011318.645 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 25628:20230128:011318.645 **** Enabled features **** 25628:20230128:011318.645 IPv6 support: YES 25628:20230128:011318.645 TLS support: YES 25628:20230128:011318.645 ************************** 25628:20230128:011318.645 using configuration file: /etc/zabbix/zabbix_agentd.conf 25628:20230128:011318.645 agent #0 started [main process] 25629:20230128:011318.646 agent #1 started [collector] 25630:20230128:011318.646 agent #2 started[listener #1] 25631:20230128:011318.647 agent #3 started[listener #2] 25632:20230128:011318.647 agent #4 started[listener #3] 25633:20230128:011318.648 agent #5 started [active checks #1] 25628:20230128:011633.125 Got signal [signal:15(SIGTERM),sender_pid:25701,sender_uid:120,reason:0]. Exiting ... 25628:20230128:011633.126 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 25707:20230128:011643.242 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 25707:20230128:011643.242 **** Enabled features **** 25707:20230128:011643.242 IPv6 support: YES 25707:20230128:011643.242 TLS support: YES 25707:20230128:011643.242 ************************** 25707:20230128:011643.242 using configuration file: /etc/zabbix/zabbix_agentd.conf 25707:20230128:011643.242 agent #0 started [main process] 25708:20230128:011643.243 agent #1 started [collector] 25709:20230128:011643.243 agent #2 started[listener #1] 25710:20230128:011643.244 agent #3 started[listener #2] 25711:20230128:011643.244 agent #4 started[listener #3] 25712:20230128:011643.244 agent #5 started [active checks #1] 25707:20230128:011801.186 Got signal [signal:15(SIGTERM),sender_pid:25733,sender_uid:120,reason:0]. Exiting ... 25707:20230128:011801.187 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 25743:20230128:011811.222 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 25743:20230128:011811.222 **** Enabled features **** 25743:20230128:011811.222 IPv6 support: YES 25743:20230128:011811.222 TLS support: YES 25743:20230128:011811.222 ************************** 25743:20230128:011811.222 using configuration file: /etc/zabbix/zabbix_agentd.conf 25743:20230128:011811.222 agent #0 started [main process] 25744:20230128:011811.223 agent #1 started [collector] 25745:20230128:011811.223 agent #2 started[listener #1] 25746:20230128:011811.223 agent #3 started[listener #2] 25747:20230128:011811.224 agent #4 started[listener #3] 25748:20230128:011811.224 agent #5 started [active checks #1] 25743:20230128:012056.581 Got signal [signal:15(SIGTERM),sender_pid:25818,sender_uid:120,reason:0]. Exiting ... 25743:20230128:012056.584 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 25821:20230128:012056.595 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 25821:20230128:012056.595 **** Enabled features **** 25821:20230128:012056.595 IPv6 support: YES 25821:20230128:012056.595 TLS support: YES 25821:20230128:012056.595 ************************** 25821:20230128:012056.595 using configuration file: /etc/zabbix/zabbix_agentd.conf 25821:20230128:012056.595 agent #0 started [main process] 25822:20230128:012056.596 agent #1 started [collector] 25823:20230128:012056.596 agent #2 started[listener #1] 25824:20230128:012056.596 agent #3 started[listener #2] 25825:20230128:012056.596 agent #4 started[listener #3] 25826:20230128:012056.597 agent #5 started [active checks #1] 25821:20230128:013113.318 Got signal [signal:15(SIGTERM),sender_pid:26013,sender_uid:120,reason:0]. Exiting ... 25821:20230128:013113.320 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 26016:20230128:013113.336 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 26016:20230128:013113.336 **** Enabled features **** 26016:20230128:013113.336 IPv6 support: YES 26016:20230128:013113.336 TLS support: YES 26016:20230128:013113.336 ************************** 26016:20230128:013113.336 using configuration file: /etc/zabbix/zabbix_agentd.conf 26016:20230128:013113.337 agent #0 started [main process] 26017:20230128:013113.337 agent #1 started [collector] 26018:20230128:013113.338 agent #2 started[listener #1] 26019:20230128:013113.339 agent #3 started[listener #2] 26020:20230128:013113.340 agent #4 started[listener #3] 26021:20230128:013113.340 agent #5 started [active checks #1] 26016:20230128:013210.700 Got signal [signal:15(SIGTERM),sender_pid:26071,sender_uid:120,reason:0]. Exiting ... 26016:20230128:013210.702 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 833:20230128:013227.134 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 833:20230128:013227.135 **** Enabled features **** 833:20230128:013227.135 IPv6 support: YES 833:20230128:013227.135 TLS support: YES 833:20230128:013227.135 ************************** 833:20230128:013227.135 using configuration file: /etc/zabbix/zabbix_agentd.conf 833:20230128:013227.136 agent #0 started [main process] 843:20230128:013227.138 agent #2 started[listener #1] 846:20230128:013227.139 agent #5 started [active checks #1] <! --- shortend --> 842:20230128:013227.152 agent #1 started [collector] 846:20230128:013227.157 Unable to connect to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Connection refused] 846:20230128:013227.158 Unable to send heartbeat message to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Connection refused] 846:20230128:013227.158 Unable to connect to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Connection refused] 846:20230128:013227.158 Active check configuration update started to fail 846:20230128:013327.173 Successfully sent heartbeat message to [127.0.0.1]:10051 846:20230128:013327.175 Active check configuration update from [127.0.0.1:10051] is working again 833:20230128:013733.359 Got signal [signal:15(SIGTERM),sender_pid:2308,sender_uid:120,reason:0]. Exiting ... 833:20230128:013733.360 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 2311:20230128:013733.369 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 2311:20230128:013733.369 **** Enabled features **** 2311:20230128:013733.369 IPv6 support: YES 2311:20230128:013733.369 TLS support: YES 2311:20230128:013733.369 ************************** 2311:20230128:013733.369 using configuration file: /etc/zabbix/zabbix_agentd.conf 2311:20230128:013733.369 agent #0 started [main process] 2312:20230128:013733.370 agent #1 started [collector] <! --- shortend --> 2316:20230128:013733.371 agent #5 started [active checks #1] 2311:20230128:014145.209 Got signal [signal:15(SIGTERM),sender_pid:2489,sender_uid:120,reason:0]. Exiting ... 2311:20230128:014145.210 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 2492:20230128:014145.219 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 2492:20230128:014145.219 **** Enabled features **** 2492:20230128:014145.219 IPv6 support: YES 2492:20230128:014145.219 TLS support: YES 2492:20230128:014145.219 ************************** 2492:20230128:014145.219 using configuration file: /etc/zabbix/zabbix_agentd.conf 2492:20230128:014145.220 agent #0 started [main process] 2493:20230128:014145.220 agent #1 started [collector] 2494:20230128:014145.220 agent #2 started[listener #1] 2495:20230128:014145.221 agent #3 started[listener #2] 2496:20230128:014145.221 agent #4 started[listener #3] 2497:20230128:014145.221 agent #5 started [active checks #1] 2492:20230128:015323.690 Got signal [signal:15(SIGTERM),sender_pid:2739,sender_uid:120,reason:0]. Exiting ... 2492:20230128:015323.691 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 2742:20230128:015323.701 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 2742:20230128:015323.701 **** Enabled features **** 2742:20230128:015323.701 IPv6 support: YES 2742:20230128:015323.701 TLS support: YES 2742:20230128:015323.701 ************************** 2742:20230128:015323.701 using configuration file: /etc/zabbix/zabbix_agentd.conf 2742:20230128:015323.702 agent #0 started [main process] 2743:20230128:015323.702 agent #1 started [collector] 2744:20230128:015323.702 agent #2 started[listener #1] 2745:20230128:015323.703 agent #3 started[listener #2] 2746:20230128:015323.703 agent #4 started[listener #3] 2747:20230128:015323.703 agent #5 started [active checks #1] 2742:20230128:022134.225 Got signal [signal:15(SIGTERM),sender_pid:4081,sender_uid:120,reason:0]. Exiting ... 2742:20230128:022134.235 Zabbix Agent stopped. Zabbix 6.2.6 (revision 6981d8b729a). 868:20230128:022148.470 Starting Zabbix Agent [Zabbix server]. Zabbix 6.2.6 (revision 6981d8b729a). 868:20230128:022148.470 **** Enabled features **** 868:20230128:022148.470 IPv6 support: YES 868:20230128:022148.470 TLS support: YES 868:20230128:022148.470 ************************** 868:20230128:022148.470 using configuration file: /etc/zabbix/zabbix_agentd.conf 868:20230128:022148.471 agent #0 started [main process] 869:20230128:022148.472 agent #1 started [collector] 870:20230128:022148.472 agent #2 started[listener #1] 872:20230128:022148.473 agent #4 started[listener #3] 873:20230128:022148.473 agent #5 started [active checks #1] 871:20230128:022148.477 agent #3 started[listener #2] 873:20230128:022148.477 Unable to connect to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Connection refused] 873:20230128:022148.477 Unable to send heartbeat message to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Connection refused] 873:20230128:022148.477 Unable to connect to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Connection refused] 873:20230128:022148.477 Active check configuration update started to fail 873:20230128:022248.136 Successfully sent heartbeat message to [127.0.0.1]:10051 873:20230128:022248.139 Active check configuration update from [127.0.0.1:10051] is working again 873:20230128:032851.785 Unable to receive from [127.0.0.1]:10051 [ZBX_TCP_READ() timed out] 873:20230128:032851.785 Active check configuration update started to fail 873:20230128:032951.796 Active check configuration update from [127.0.0.1:10051] is working again
zabbix_server.log:
Code:
22075:20230127:232735.582 Starting Zabbix Server. Zabbix 6.2.6 (revision 6981d8b729a).
22075:20230127:232735.582 ****** Enabled features ******
22075:20230127:232735.582 SNMP monitoring: YES
22075:20230127:232735.582 IPMI monitoring: YES
22075:20230127:232735.582 Web monitoring: YES
22075:20230127:232735.582 VMware monitoring: YES
22075:20230127:232735.582 SMTP authentication: YES
22075:20230127:232735.582 ODBC: YES
22075:20230127:232735.582 SSH support: YES
22075:20230127:232735.582 IPv6 support: YES
22075:20230127:232735.582 TLS support: YES
22075:20230127:232735.582 ******************************
22075:20230127:232735.582 using configuration file: /etc/zabbix/zabbix_server.conf
22075:20230127:232735.603 current database version (mandatory/optional): 06020000/06020013
22075:20230127:232735.603 required mandatory version: 06020000
<! --- shortend -->
22224:20230127:232742.789 item "Zabbix server:zabbix[process,ipmi poller,avg,busy]" became not supported: No "ipmi poller" processes started.
22219:20230127:232743.800 item "Zabbix server:zabbix[process,java poller,avg,busy]" became not supported: No "java poller" processes started.
22219:20230127:232747.818 item "Zabbix server:zabbix[process,snmp trapper,avg,busy]" became not supported: No "snmp trapper" processes started.
22219:20230127:232747.818 item "Zabbix server:zabbix[process,ipmi manager,avg,busy]" became not supported: No "ipmi manager" processes started.
22231:20230127:232748.804 enabling Zabbix agent checks on host "Zabbix server": interface became available
22219:20230127:232748.824 item "Zabbix server:zabbix[process,vmware collector,avg,busy]" became not supported: No "vmware collector" processes started.
22219:20230127:232755.857 item "Zabbix server:zabbix[vmware,buffer,pused]" became not supported: No "vmware collector" processes started.
22219:20230127:232758.872 item "Zabbix server:zabbix[process,report writer,avg,busy]" became not supported: No "report writer" processes started.
22219:20230127:232759.877 item "Zabbix server:zabbix[process,report manager,avg,busy]" became not supported: No "report manager" processes started.
<! --- shortend -->
22219:20230127:234443.692 item "Zabbix server:vfs.file.contents["/sys/class/net/eth0/speed"]" became not supported: Value "-1000000" of type "double" is not suitable for value type "Numeric (unsigned)"
22223:20230127:234456.719 item "Zabbix server:vfs.dev.read.await[vda]" became not supported: Cannot evaluate function: not enough data at "last(//vfs.dev.read.time.rate[vda])/(last(//vfs.dev.read.rate[vda])+(last(//vfs.dev.read.rate[vda])=0)))*1000*(last(//vfs.dev.read.rate[vda]) > 0)".
22219:20230127:234457.720 item "Zabbix server:vfs.dev.write.await[vda]" became not supported: Cannot evaluate function: not enough data at "last(//vfs.dev.write.time.rate[vda])/(last(//vfs.dev.write.rate[vda])+(last(//vfs.dev.write.rate[vda])=0)))*1000*(last(//vfs.dev.write.rate[vda]) > 0)".
<! --- shortend -->
22223:20230127:234656.866 item "Zabbix server:vfs.dev.read.await[vda]" became supported
22224:20230127:234657.867 item "Zabbix server:vfs.dev.write.await[vda]" became supported
<! --- shortend -->
22236:20230127:235543.813 Zabbix agent item "proc.num[,,run]" on host "raspberrypi4kar" failed: first network error, wait for 15 seconds
22239:20230127:235602.365 Zabbix agent item "system.uname" on host "raspberrypi4kar" failed: another network error, wait for 15 seconds
22239:20230127:235621.375 Zabbix agent item "vfs.dev.discovery" on host "raspberrypi4kar" failed: another network error, wait for 15 seconds
22239:20230127:235640.391 temporarily disabling Zabbix agent checks on host "raspberrypi4kar": interface unavailable
22213:20230127:235735.882 executing housekeeper
22213:20230127:235735.889 housekeeper [deleted 0 hist/trends, 0 items/triggers, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit, 0 records in 0.006447 sec, idle for 1 hour(s)]
22236:20230128:000439.554 Zabbix agent item "system.cpu.load[all,avg1]" on host "customer0001" failed: first network error, wait for 15 seconds
22239:20230128:000454.839 Zabbix agent item "system.cpu.load[all,avg5]" on host "customer0001" failed: another network error, wait for 15 seconds
22239:20230128:000509.852 Zabbix agent item "system.hostname" on host "customer0001" failed: another network error, wait for 15 seconds
22239:20230128:000524.866 temporarily disabling Zabbix agent checks on host "customer0001": interface unavailable
22239:20230128:000624.922 enabling Zabbix agent checks on host "customer0001": interface became available
22211:20230128:001415.057 discovery rule "Zabbix server:mysql.db.discovery["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became not supported: Unsupported item key.
22212:20230128:001417.007 discovery rule "Zabbix server:mysql.replication.discovery["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became not supported: Unsupported item key.
22224:20230128:001427.460 item "Zabbix server:mysql.buffer_pool_efficiency" became not supported: Cannot evaluate function: not enough data 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 )".
22223:20230128:001428.460 item "Zabbix server:mysql.buffer_pool_utilization" became not supported: Cannot evaluate function: not enough data 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 )".
22220:20230128:001429.462 item "Zabbix server:mysql.innodb_log_file_size" became not supported: Cannot evaluate function: not enough data at "last(//mysql.innodb_os_log_written) - last(//mysql.innodb_os_log_written,#1:now-1h)) / {$MYSQL.INNODB_LOG_FILES}".
22219:20230128:001430.461 item "Zabbix server:mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became not supported: Unsupported item key.
22224:20230128:001431.465 item "Zabbix server:mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became not supported: Unsupported item key.
22223:20230128:001432.465 item "Zabbix server:mysql.version["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became not supported: Unsupported item key.
<! --- shortend -->
22219:20230128:004531.937 error reason for "Zabbix server:mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" changed: Value "Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysqladmin: Error while setting value 'zbx_monitor' to 'port'" of type "string" is not suitable for value type "Numeric (unsigned)"
22219:20230128:004631.011 item "Zabbix server:mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became supported
22219:20230128:004631.011 item "Zabbix server:mysql.aborted_clients.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Aborted_clients": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.011 item "Zabbix server:mysql.aborted_connects.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Aborted_connects": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.011 item "Zabbix server:mysql.binlog_cache_disk_use" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Binlog_cache_disk_use": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.011 item "Zabbix server:mysql.bytes_received.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Bytes_received": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.011 item "Zabbix server:mysql.bytes_sent.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Bytes_sent": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.011 item "Zabbix server:mysql.com_delete.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Com_delete": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.011 item "Zabbix server:mysql.com_insert.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Com_insert": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.011 item "Zabbix server:mysql.com_select.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Com_select": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.011 item "Zabbix server:mysql.com_update.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Com_update": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.connection_errors_accept.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Connection_errors_accept": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.connection_errors_internal.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Connection_errors_internal": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.connection_errors_max_connections.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Connection_errors_max_connections": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.connection_errors_peer_address.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Connection_errors_peer_address": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.connection_errors_select.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Connection_errors_select": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.connection_errors_tcpwrap.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Connection_errors_tcpwrap": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.connections.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Connections": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.created_tmp_files.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Created_tmp_files": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.created_tmp_disk_tables.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Created_tmp_disk_tables": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.created_tmp_tables.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Created_tmp_tables": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.innodb_buffer_pool_pages_free" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Innodb_buffer_pool_pages_free": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.innodb_buffer_pool_pages_total" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Innodb_buffer_pool_pages_total": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.innodb_buffer_pool_read_requests" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Innodb_buffer_pool_read_requests": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.innodb_buffer_pool_read_requests.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Innodb_buffer_pool_read_requests": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.innodb_buffer_pool_reads" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Innodb_buffer_pool_reads": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.innodb_buffer_pool_reads.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Innodb_buffer_pool_reads": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.innodb_buffer_pool_wait_free" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Innodb_buffer_pool_wait_free": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.innodb_os_log_written" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Innodb_os_log_written": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.innodb_num_open_files" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Innodb_num_open_files": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.innodb_row_lock_time" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Innodb_row_lock_time": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.innodb_row_lock_time_max" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Innodb_row_lock_time_max": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.innodb_row_lock_waits" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Innodb_row_lock_waits": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.max_used_connections" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Max_used_connections": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.open_table_definitions" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Open_table_definitions": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.open_tables" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Open_tables": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.queries.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Queries": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.questions.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Questions": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.slow_queries.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Slow_queries": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.threads_cached" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Threads_cached": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.threads_connected" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Threads_connected": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.threads_created.rate" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Threads_created": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.threads_running" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Threads_running": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22219:20230128:004631.012 item "Zabbix server:mysql.uptime" became not supported: Preprocessing failed for: Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor').mysql: Error while setting valu...
1. Failed: cannot extract value from json by path "$.Uptime": invalid object format, expected opening character '{' or '[' at: 'Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysql: Error while setting value 'zbx_monitor' to 'port''
22220:20230128:004728.090 error reason for "Zabbix server:mysql.buffer_pool_efficiency" changed: Cannot evaluate function: item "/Zabbix server/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 )".
22219:20230128:004730.093 error reason for "Zabbix server:mysql.innodb_log_file_size" changed: Cannot evaluate function: item "/Zabbix server/mysql.innodb_os_log_written" is not supported at "last(//mysql.innodb_os_log_written) - last(//mysql.innodb_os_log_written,#1:now-1h)) / {$MYSQL.INNODB_LOG_FILES}".
22220:20230128:004831.177 item "Zabbix server:mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became not supported: Special characters "\, ', ", `, *, ?, [, ], {, }, ~, $, !, &, ;, (, ), <, >, |, #, @, 0x0a" are not allowed in the parameters.
22223:20230128:004832.178 error reason for "Zabbix server:mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" changed: Special characters "\, ', ", `, *, ?, [, ], {, }, ~, $, !, &, ;, (, ), <, >, |, #, @, 0x0a" are not allowed in the parameters.
22220:20230128:005108.475 slow query: 6.098766 sec, "commit;"
<! --- shortend -->
22220:20230128:005330.658 item "Zabbix server:mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became supported
22223:20230128:005331.661 error reason for "Zabbix server:mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" changed: Value "Unknown suffix 'z' used for variable 'port' (value 'zbx_monitor')
mysqladmin: Error while setting value 'zbx_monitor' to 'port'" of type "string" is not suitable for value type "Numeric (unsigned)"
22212:20230128:005432.558 invalid discovery rule ID [44716]
22219:20230128:005432.744 item "Zabbix server:mysql.version["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became supported
22083:20230128:005501.525 slow query: 3.912470 sec, "begin;"
<! --- shortend -->
22219:20230128:005557.440 item "Zabbix server DB:mysql.buffer_pool_efficiency" became not supported: Cannot evaluate function: not enough data 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 )".
22219:20230128:005557.440 item "Zabbix server DB:mysql.innodb_log_file_size" became not supported: Cannot evaluate function: not enough data at "last(//mysql.innodb_os_log_written) - last(//mysql.innodb_os_log_written,#1:now-1h)) / {$MYSQL.INNODB_LOG_FILES}".
22220:20230128:005557.442 item "Zabbix server DB:mysql.buffer_pool_utilization" became not supported: Cannot evaluate function: not enough data 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 )".
22234:20230128:005558.311 enabling Zabbix agent checks on host "Zabbix server DB": interface became available
22224:20230128:005558.449 item "Zabbix server DB:mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became not supported: Unsupported item key.
22220:20230128:005559.451 item "Zabbix server DB:mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became not supported: Unsupported item key.
22223:20230128:005600.451 item "Zabbix server DB:mysql.version["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became not supported: Unsupported item key.
<! --- shortend -->
22212:20230128:005646.336 discovery rule "Zabbix server DB:mysql.db.discovery["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became not supported: Unsupported item key.
22212:20230128:005646.362 discovery rule "Zabbix server DB:mysql.replication.discovery["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became not supported: Unsupported item key.
22223:20230128:005650.535 slow query: 3.197428 sec, "commit;"
22220:20230128:005726.656 item "Zabbix server:zabbix[cluster,discovery,nodes]" became supported
22213:20230128:005735.989 executing housekeeper
22213:20230128:005736.035 housekeeper [deleted 0 hist/trends, 1 items/triggers, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit, 0 records in 0.045036 sec, idle for 1 hour(s)]
<! --- shortend -->
Code:
root@v22:/var/log/zabbix# sudo ufw status verbose Status: active Logging: on (low) Default: deny (incoming), allow (outgoing), deny (routed) New profiles: skip To Action From -- ------ ---- 1312 ALLOW IN Anywhere 80/tcp ALLOW IN Anywhere 443 ALLOW IN Anywhere 943 ALLOW IN Anywhere 40000:50000/tcp ALLOW IN Anywhere 3000 ALLOW IN Anywhere 20/tcp ALLOW IN Anywhere 21/tcp ALLOW IN Anywhere 1312 (v6) ALLOW IN Anywhere (v6) 80/tcp (v6) ALLOW IN Anywhere (v6) 443 (v6) ALLOW IN Anywhere (v6) 943 (v6) ALLOW IN Anywhere (v6) 40000:50000/tcp (v6) ALLOW IN Anywhere (v6) 3000 (v6) ALLOW IN Anywhere (v6) 20/tcp (v6) ALLOW IN Anywhere (v6) 21/tcp (v6) ALLOW IN Anywhere (v6)
Comment