Since a few days we added MS SQL servers to monitor with zabbix (version 6). We use the template MSSQL by ODBC to monitor SQL. At first we added them to our zabbix server (and not a proxy) but this was probably to much to handle. So we added a proxy and connected all the SQlservers to the proxy. But the same problem now occurs on the proxy server. When i look at the processes under linux it seems that the preprocessing manager can't process its messages. But I don't know whats the problem. Does anybody has any clue what to do?
UID PID PPID C STIME TTY TIME CMD
zabbix 1109 1 0 Mar30 ? 00:00:00 /usr/sbin/zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf
zabbix 1114 1109 0 Mar30 ? 00:00:04 /usr/sbin/zabbix_agentd: collector [idle 1 sec]
zabbix 1115 1109 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_agentd: listener #1 [waiting for connection]
zabbix 1116 1109 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_agentd: listener #2 [waiting for connection]
zabbix 1117 1109 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_agentd: listener #3 [waiting for connection]
zabbix 1118 1109 0 Mar30 ? 00:00:15 /usr/sbin/zabbix_agentd: active checks #1 [idle 1 sec]
zabbix 3458 1 0 Mar30 ? 00:00:06 /usr/sbin/zabbix_proxy -c /etc/zabbix/zabbix_proxy.conf
zabbix 3459 3458 0 Mar30 ? 00:00:19 /usr/sbin/zabbix_proxy: configuration syncer [synced config 15579624 bytes in 65.298325 sec, idle 3600 sec]
zabbix 3460 3458 0 Mar30 ? 00:00:09 /usr/sbin/zabbix_proxy: trapper #1 [processed data in 1.968597 sec, waiting for connection]
zabbix 3461 3458 0 Mar30 ? 00:00:09 /usr/sbin/zabbix_proxy: trapper #2 [processed data in 5.907294 sec, waiting for connection]
zabbix 3462 3458 0 Mar30 ? 00:00:10 /usr/sbin/zabbix_proxy: trapper #3 [processed data in 7.749427 sec, waiting for connection]
zabbix 3463 3458 0 Mar30 ? 00:00:10 /usr/sbin/zabbix_proxy: trapper #4 [processed data in 2.310827 sec, waiting for connection]
zabbix 3464 3458 0 Mar30 ? 00:00:09 /usr/sbin/zabbix_proxy: trapper #5 [processed data in 45.174505 sec, waiting for connection]
zabbix 3465 3458 0 Mar30 ? 00:00:31 /usr/sbin/zabbix_proxy: preprocessing manager #1 [queued 32339, processed 2 values, idle 0.000000 sec during 6.936685 sec]
zabbix 3466 3458 0 Mar30 ? 00:00:06 /usr/sbin/zabbix_proxy: preprocessing worker #1 started
zabbix 3467 3458 0 Mar30 ? 00:00:08 /usr/sbin/zabbix_proxy: preprocessing worker #2 started
zabbix 3468 3458 0 Mar30 ? 00:00:01 /usr/sbin/zabbix_proxy: preprocessing worker #3 started
zabbix 3469 3458 0 Mar30 ? 00:00:03 /usr/sbin/zabbix_proxy: preprocessing worker #4 started
zabbix 3470 3458 0 Mar30 ? 00:00:01 /usr/sbin/zabbix_proxy: preprocessing worker #5 started
zabbix 3471 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: preprocessing worker #6 started
zabbix 3472 3458 0 Mar30 ? 00:00:06 /usr/sbin/zabbix_proxy: preprocessing worker #7 started
zabbix 3473 3458 0 Mar30 ? 00:00:00 /usr/sbin/zabbix_proxy: preprocessing worker #8 started
zabbix 3474 3458 0 Mar30 ? 00:00:01 /usr/sbin/zabbix_proxy: heartbeat sender [sending heartbeat message success in 2.762490 sec, idle 58 sec]
zabbix 3475 3458 0 Mar30 ? 00:00:20 /usr/sbin/zabbix_proxy: data sender [sent 0 values in 6.312413 sec, sending data]
zabbix 3476 3458 0 Mar30 ? 00:00:00 /usr/sbin/zabbix_proxy: housekeeper [deleted 923 records in 5.068677 sec, idle for 1 hour(s)]
zabbix 3477 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: http poller #1 [got 0 values in 0.858157 sec, getting values]
zabbix 3478 3458 0 Mar30 ? 00:00:00 /usr/sbin/zabbix_proxy: discoverer #1 [processed 0 rules in 0.620838 sec, idle 60 sec]
zabbix 3479 3458 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_proxy: history syncer #1 [processed 0 values in 0.640177 sec, idle 1 sec]
zabbix 3480 3458 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_proxy: history syncer #2 [processed 0 values in 0.857398 sec, idle 1 sec]
zabbix 3481 3458 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_proxy: history syncer #3 [processed 0 values in 0.810275 sec, syncing history]
zabbix 3482 3458 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_proxy: history syncer #4 [processed 0 values in 0.197473 sec, idle 1 sec]
zabbix 3483 3458 0 Mar30 ? 00:00:08 /usr/sbin/zabbix_proxy: self-monitoring [processing data]
zabbix 3484 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: task manager [processing tasks]
zabbix 3485 3458 0 Mar30 ? 00:00:29 /usr/sbin/zabbix_proxy: poller #1 [got 1 values in 8.135571 sec, getting values]
zabbix 3486 3458 0 Mar30 ? 00:00:29 /usr/sbin/zabbix_proxy: poller #2 [got 2 values in 8.756239 sec, getting values]
zabbix 3487 3458 0 Mar30 ? 00:00:29 /usr/sbin/zabbix_proxy: poller #3 [got 1 values in 5.682693 sec, getting values]
zabbix 3488 3458 0 Mar30 ? 00:00:29 /usr/sbin/zabbix_proxy: poller #4 [got 2 values in 9.012605 sec, getting values]
zabbix 3489 3458 0 Mar30 ? 00:00:29 /usr/sbin/zabbix_proxy: poller #5 [got 2 values in 5.924525 sec, getting values]
zabbix 3490 3458 0 Mar30 ? 00:00:10 /usr/sbin/zabbix_proxy: unreachable poller #1 [got 1 values in 6.905483 sec, getting values]
zabbix 3491 3458 0 Mar30 ? 00:00:06 /usr/sbin/zabbix_proxy: icmp pinger #1 [got 0 values in 0.242339 sec, idle 5 sec]
zabbix 3492 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: history poller #1 [got 0 values in 0.634661 sec, idle 5 sec]
zabbix 3493 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: history poller #2 [got 0 values in 0.011014 sec, idle 5 sec]
zabbix 3494 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: history poller #3 [got 0 values in 0.853323 sec, idle 5 sec]
zabbix 3495 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: history poller #4 [got 0 values in 0.850636 sec, idle 5 sec]
zabbix 3496 3458 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_proxy: availability manager #1 [queued 0, processed 1 values, idle 4.817233 sec during 6.867464 sec]
zabbix 3497 3458 0 Mar30 ? 00:00:25 /usr/sbin/zabbix_proxy: odbc poller #1 [got 1 values in 83.417947 sec, getting values]
zabbix 3498 3458 0 Mar30 ? 00:00:22 /usr/sbin/zabbix_proxy: odbc poller #2 [got 1 values in 456.050071 sec, getting values]
zabbix 3499 3458 0 Mar30 ? 00:00:21 /usr/sbin/zabbix_proxy: odbc poller #3 [got 1 values in 14.486302 sec, getting values]
zabbix 3500 3458 0 Mar30 ? 00:00:22 /usr/sbin/zabbix_proxy: odbc poller #4 [got 1 values in 179.593483 sec, getting values]
zabbix 3501 3458 0 Mar30 ? 00:00:21 /usr/sbin/zabbix_proxy: odbc poller #5 [got 1 values in 949.182788 sec, getting values]
zabbix 3502 3458 0 Mar30 ? 00:00:22 /usr/sbin/zabbix_proxy: odbc poller #6 [got 1 values in 1013.362971 sec, getting values]
zabbix 3503 3458 0 Mar30 ? 00:00:21 /usr/sbin/zabbix_proxy: odbc poller #7 [got 1 values in 65.349307 sec, getting values]
zabbix 3504 3458 0 Mar30 ? 00:00:22 /usr/sbin/zabbix_proxy: odbc poller #8 [got 1 values in 196.157393 sec, getting values]
zabbix 3505 3458 0 Mar30 ? 00:00:22 /usr/sbin/zabbix_proxy: odbc poller #9 [got 1 values in 883.149160 sec, getting values]
zabbix 3506 3458 0 Mar30 ? 00:00:22 /usr/sbin/zabbix_proxy: odbc poller #10 [got 1 values in 95.561105 sec, getting values]
zabbix 3507 3458 0 Mar30 ? 00:00:23 /usr/sbin/zabbix_proxy: odbc poller #11 [got 1 values in 9.443608 sec, getting values]
zabbix 3508 3458 0 Mar30 ? 00:00:21 /usr/sbin/zabbix_proxy: odbc poller #12 [got 1 values in 46.207435 sec, getting values]
UID PID PPID C STIME TTY TIME CMD
zabbix 1109 1 0 Mar30 ? 00:00:00 /usr/sbin/zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf
zabbix 1114 1109 0 Mar30 ? 00:00:04 /usr/sbin/zabbix_agentd: collector [idle 1 sec]
zabbix 1115 1109 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_agentd: listener #1 [waiting for connection]
zabbix 1116 1109 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_agentd: listener #2 [waiting for connection]
zabbix 1117 1109 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_agentd: listener #3 [waiting for connection]
zabbix 1118 1109 0 Mar30 ? 00:00:15 /usr/sbin/zabbix_agentd: active checks #1 [idle 1 sec]
zabbix 3458 1 0 Mar30 ? 00:00:06 /usr/sbin/zabbix_proxy -c /etc/zabbix/zabbix_proxy.conf
zabbix 3459 3458 0 Mar30 ? 00:00:19 /usr/sbin/zabbix_proxy: configuration syncer [synced config 15579624 bytes in 65.298325 sec, idle 3600 sec]
zabbix 3460 3458 0 Mar30 ? 00:00:09 /usr/sbin/zabbix_proxy: trapper #1 [processed data in 1.968597 sec, waiting for connection]
zabbix 3461 3458 0 Mar30 ? 00:00:09 /usr/sbin/zabbix_proxy: trapper #2 [processed data in 5.907294 sec, waiting for connection]
zabbix 3462 3458 0 Mar30 ? 00:00:10 /usr/sbin/zabbix_proxy: trapper #3 [processed data in 7.749427 sec, waiting for connection]
zabbix 3463 3458 0 Mar30 ? 00:00:10 /usr/sbin/zabbix_proxy: trapper #4 [processed data in 2.310827 sec, waiting for connection]
zabbix 3464 3458 0 Mar30 ? 00:00:09 /usr/sbin/zabbix_proxy: trapper #5 [processed data in 45.174505 sec, waiting for connection]
zabbix 3465 3458 0 Mar30 ? 00:00:31 /usr/sbin/zabbix_proxy: preprocessing manager #1 [queued 32339, processed 2 values, idle 0.000000 sec during 6.936685 sec]
zabbix 3466 3458 0 Mar30 ? 00:00:06 /usr/sbin/zabbix_proxy: preprocessing worker #1 started
zabbix 3467 3458 0 Mar30 ? 00:00:08 /usr/sbin/zabbix_proxy: preprocessing worker #2 started
zabbix 3468 3458 0 Mar30 ? 00:00:01 /usr/sbin/zabbix_proxy: preprocessing worker #3 started
zabbix 3469 3458 0 Mar30 ? 00:00:03 /usr/sbin/zabbix_proxy: preprocessing worker #4 started
zabbix 3470 3458 0 Mar30 ? 00:00:01 /usr/sbin/zabbix_proxy: preprocessing worker #5 started
zabbix 3471 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: preprocessing worker #6 started
zabbix 3472 3458 0 Mar30 ? 00:00:06 /usr/sbin/zabbix_proxy: preprocessing worker #7 started
zabbix 3473 3458 0 Mar30 ? 00:00:00 /usr/sbin/zabbix_proxy: preprocessing worker #8 started
zabbix 3474 3458 0 Mar30 ? 00:00:01 /usr/sbin/zabbix_proxy: heartbeat sender [sending heartbeat message success in 2.762490 sec, idle 58 sec]
zabbix 3475 3458 0 Mar30 ? 00:00:20 /usr/sbin/zabbix_proxy: data sender [sent 0 values in 6.312413 sec, sending data]
zabbix 3476 3458 0 Mar30 ? 00:00:00 /usr/sbin/zabbix_proxy: housekeeper [deleted 923 records in 5.068677 sec, idle for 1 hour(s)]
zabbix 3477 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: http poller #1 [got 0 values in 0.858157 sec, getting values]
zabbix 3478 3458 0 Mar30 ? 00:00:00 /usr/sbin/zabbix_proxy: discoverer #1 [processed 0 rules in 0.620838 sec, idle 60 sec]
zabbix 3479 3458 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_proxy: history syncer #1 [processed 0 values in 0.640177 sec, idle 1 sec]
zabbix 3480 3458 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_proxy: history syncer #2 [processed 0 values in 0.857398 sec, idle 1 sec]
zabbix 3481 3458 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_proxy: history syncer #3 [processed 0 values in 0.810275 sec, syncing history]
zabbix 3482 3458 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_proxy: history syncer #4 [processed 0 values in 0.197473 sec, idle 1 sec]
zabbix 3483 3458 0 Mar30 ? 00:00:08 /usr/sbin/zabbix_proxy: self-monitoring [processing data]
zabbix 3484 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: task manager [processing tasks]
zabbix 3485 3458 0 Mar30 ? 00:00:29 /usr/sbin/zabbix_proxy: poller #1 [got 1 values in 8.135571 sec, getting values]
zabbix 3486 3458 0 Mar30 ? 00:00:29 /usr/sbin/zabbix_proxy: poller #2 [got 2 values in 8.756239 sec, getting values]
zabbix 3487 3458 0 Mar30 ? 00:00:29 /usr/sbin/zabbix_proxy: poller #3 [got 1 values in 5.682693 sec, getting values]
zabbix 3488 3458 0 Mar30 ? 00:00:29 /usr/sbin/zabbix_proxy: poller #4 [got 2 values in 9.012605 sec, getting values]
zabbix 3489 3458 0 Mar30 ? 00:00:29 /usr/sbin/zabbix_proxy: poller #5 [got 2 values in 5.924525 sec, getting values]
zabbix 3490 3458 0 Mar30 ? 00:00:10 /usr/sbin/zabbix_proxy: unreachable poller #1 [got 1 values in 6.905483 sec, getting values]
zabbix 3491 3458 0 Mar30 ? 00:00:06 /usr/sbin/zabbix_proxy: icmp pinger #1 [got 0 values in 0.242339 sec, idle 5 sec]
zabbix 3492 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: history poller #1 [got 0 values in 0.634661 sec, idle 5 sec]
zabbix 3493 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: history poller #2 [got 0 values in 0.011014 sec, idle 5 sec]
zabbix 3494 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: history poller #3 [got 0 values in 0.853323 sec, idle 5 sec]
zabbix 3495 3458 0 Mar30 ? 00:00:05 /usr/sbin/zabbix_proxy: history poller #4 [got 0 values in 0.850636 sec, idle 5 sec]
zabbix 3496 3458 0 Mar30 ? 00:00:07 /usr/sbin/zabbix_proxy: availability manager #1 [queued 0, processed 1 values, idle 4.817233 sec during 6.867464 sec]
zabbix 3497 3458 0 Mar30 ? 00:00:25 /usr/sbin/zabbix_proxy: odbc poller #1 [got 1 values in 83.417947 sec, getting values]
zabbix 3498 3458 0 Mar30 ? 00:00:22 /usr/sbin/zabbix_proxy: odbc poller #2 [got 1 values in 456.050071 sec, getting values]
zabbix 3499 3458 0 Mar30 ? 00:00:21 /usr/sbin/zabbix_proxy: odbc poller #3 [got 1 values in 14.486302 sec, getting values]
zabbix 3500 3458 0 Mar30 ? 00:00:22 /usr/sbin/zabbix_proxy: odbc poller #4 [got 1 values in 179.593483 sec, getting values]
zabbix 3501 3458 0 Mar30 ? 00:00:21 /usr/sbin/zabbix_proxy: odbc poller #5 [got 1 values in 949.182788 sec, getting values]
zabbix 3502 3458 0 Mar30 ? 00:00:22 /usr/sbin/zabbix_proxy: odbc poller #6 [got 1 values in 1013.362971 sec, getting values]
zabbix 3503 3458 0 Mar30 ? 00:00:21 /usr/sbin/zabbix_proxy: odbc poller #7 [got 1 values in 65.349307 sec, getting values]
zabbix 3504 3458 0 Mar30 ? 00:00:22 /usr/sbin/zabbix_proxy: odbc poller #8 [got 1 values in 196.157393 sec, getting values]
zabbix 3505 3458 0 Mar30 ? 00:00:22 /usr/sbin/zabbix_proxy: odbc poller #9 [got 1 values in 883.149160 sec, getting values]
zabbix 3506 3458 0 Mar30 ? 00:00:22 /usr/sbin/zabbix_proxy: odbc poller #10 [got 1 values in 95.561105 sec, getting values]
zabbix 3507 3458 0 Mar30 ? 00:00:23 /usr/sbin/zabbix_proxy: odbc poller #11 [got 1 values in 9.443608 sec, getting values]
zabbix 3508 3458 0 Mar30 ? 00:00:21 /usr/sbin/zabbix_proxy: odbc poller #12 [got 1 values in 46.207435 sec, getting values]
Comment