Добрый день. Внезапно перестал отображать данные виджет "Состояние системы". Если выключить галку "Предупреждения" то начинает отображать. Предупреждений более 1000. Куда копать?
# zabbix_server -V
zabbix_server (Zabbix) 3.4.2
Revision 72885 25 September 2017, compilation time: Sep 25 2017 15:54:03
MariaDB [(none)]> SHOW PROCESSLIST;
+-----+--------+-----------+--------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+-----+--------+-----------+--------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
| 23 | zabbix | localhost | zabbix | Sleep | 19 | | NULL | 0.000 |
| 24 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | 0.000 |
| 25 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | 0.000 |
| 26 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | 0.000 |
| 27 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | 0.000 |
| 28 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | 0.000 |
| 29 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | 0.000 |
| 30 | zabbix | localhost | zabbix | Sleep | 1116 | | NULL | 0.000 |
| 31 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | 0.000 |
| 32 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | 0.000 |
| 33 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | 0.000 |
| 34 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | 0.000 |
| 35 | zabbix | localhost | zabbix | Sleep | 15 | | NULL | 0.000 |
| 36 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | 0.000 |
| 37 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | 0.000 |
| 38 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 39 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 40 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 41 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 42 | zabbix | localhost | zabbix | Sleep | 301 | | NULL | 0.000 |
| 43 | zabbix | localhost | zabbix | Sleep | 721 | | NULL | 0.000 |
| 44 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | 0.000 |
| 45 | zabbix | localhost | zabbix | Sleep | 1115 | | NULL | 0.000 |
| 46 | zabbix | localhost | zabbix | Sleep | 32 | | NULL | 0.000 |
| 47 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 48 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 49 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 50 | zabbix | localhost | zabbix | Sleep | 57 | | NULL | 0.000 |
| 51 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 52 | zabbix | localhost | zabbix | Sleep | 392 | | NULL | 0.000 |
| 53 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 54 | zabbix | localhost | zabbix | Sleep | 1115 | | NULL | 0.000 |
| 55 | zabbix | localhost | zabbix | Sleep | 151 | | NULL | 0.000 |
| 56 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 57 | zabbix | localhost | zabbix | Sleep | 56 | | NULL | 0.000 |
| 58 | zabbix | localhost | zabbix | Sleep | 354 | | NULL | 0.000 |
| 59 | zabbix | localhost | zabbix | Sleep | 1115 | | NULL | 0.000 |
| 60 | zabbix | localhost | zabbix | Sleep | 61 | | NULL | 0.000 |
| 61 | zabbix | localhost | zabbix | Sleep | 1115 | | NULL | 0.000 |
| 62 | zabbix | localhost | zabbix | Sleep | 1115 | | NULL | 0.000 |
| 89 | zabbix | localhost | zabbix | Sleep | 24 | | NULL | 0.000 |
| 112 | root | localhost | NULL | Sleep | 439 | | NULL | 0.000 |
| 572 | root | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
| 573 | zabbix | localhost | zabbix | Query | 10 | Sending data | SELECT p.eventid FROM problem p WHERE p.source='0' AND p.object='0' AND (p.eventid BETWEEN '1284890' | 0.000 |
+-----+--------+-----------+--------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
44 rows in set (0.00 sec)
# free
total used free shared buff/cache available
Mem: 2068112 589396 481532 27440 997184 1230812
Swap: 496636 0 496636
#top
613 mysql 20 0 758200 244240 15684 S 130,9 11,8 14:00.57 mysqld
# lscpu
Architecture: i686
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 4
On-line CPU(s) list: 0-3
Thread(s) per core: 1
Core(s) per socket: 2
Socket(s): 2
Vendor ID: GenuineIntel
CPU family: 15
Model: 6
Model name: Common KVM processor
Stepping: 1
CPU MHz: 2593.748
BogoMIPS: 5187.49
Hypervisor vendor: KVM
Virtualization type: full
L1d cache: 32K
L1i cache: 32K
L2 cache: 4096K
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx lm constant_tsc xtopology eagerfpu pni cx16 x2apic hypervisor lahf_lm
# zabbix_server -V
zabbix_server (Zabbix) 3.4.2
Revision 72885 25 September 2017, compilation time: Sep 25 2017 15:54:03
MariaDB [(none)]> SHOW PROCESSLIST;
+-----+--------+-----------+--------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+-----+--------+-----------+--------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
| 23 | zabbix | localhost | zabbix | Sleep | 19 | | NULL | 0.000 |
| 24 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | 0.000 |
| 25 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | 0.000 |
| 26 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | 0.000 |
| 27 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | 0.000 |
| 28 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | 0.000 |
| 29 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | 0.000 |
| 30 | zabbix | localhost | zabbix | Sleep | 1116 | | NULL | 0.000 |
| 31 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | 0.000 |
| 32 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | 0.000 |
| 33 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | 0.000 |
| 34 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | 0.000 |
| 35 | zabbix | localhost | zabbix | Sleep | 15 | | NULL | 0.000 |
| 36 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | 0.000 |
| 37 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | 0.000 |
| 38 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 39 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 40 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 41 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 42 | zabbix | localhost | zabbix | Sleep | 301 | | NULL | 0.000 |
| 43 | zabbix | localhost | zabbix | Sleep | 721 | | NULL | 0.000 |
| 44 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | 0.000 |
| 45 | zabbix | localhost | zabbix | Sleep | 1115 | | NULL | 0.000 |
| 46 | zabbix | localhost | zabbix | Sleep | 32 | | NULL | 0.000 |
| 47 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 48 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 49 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 50 | zabbix | localhost | zabbix | Sleep | 57 | | NULL | 0.000 |
| 51 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 52 | zabbix | localhost | zabbix | Sleep | 392 | | NULL | 0.000 |
| 53 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 54 | zabbix | localhost | zabbix | Sleep | 1115 | | NULL | 0.000 |
| 55 | zabbix | localhost | zabbix | Sleep | 151 | | NULL | 0.000 |
| 56 | zabbix | localhost | zabbix | Sleep | 35 | | NULL | 0.000 |
| 57 | zabbix | localhost | zabbix | Sleep | 56 | | NULL | 0.000 |
| 58 | zabbix | localhost | zabbix | Sleep | 354 | | NULL | 0.000 |
| 59 | zabbix | localhost | zabbix | Sleep | 1115 | | NULL | 0.000 |
| 60 | zabbix | localhost | zabbix | Sleep | 61 | | NULL | 0.000 |
| 61 | zabbix | localhost | zabbix | Sleep | 1115 | | NULL | 0.000 |
| 62 | zabbix | localhost | zabbix | Sleep | 1115 | | NULL | 0.000 |
| 89 | zabbix | localhost | zabbix | Sleep | 24 | | NULL | 0.000 |
| 112 | root | localhost | NULL | Sleep | 439 | | NULL | 0.000 |
| 572 | root | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
| 573 | zabbix | localhost | zabbix | Query | 10 | Sending data | SELECT p.eventid FROM problem p WHERE p.source='0' AND p.object='0' AND (p.eventid BETWEEN '1284890' | 0.000 |
+-----+--------+-----------+--------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
44 rows in set (0.00 sec)
# free
total used free shared buff/cache available
Mem: 2068112 589396 481532 27440 997184 1230812
Swap: 496636 0 496636
#top
613 mysql 20 0 758200 244240 15684 S 130,9 11,8 14:00.57 mysqld
# lscpu
Architecture: i686
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 4
On-line CPU(s) list: 0-3
Thread(s) per core: 1
Core(s) per socket: 2
Socket(s): 2
Vendor ID: GenuineIntel
CPU family: 15
Model: 6
Model name: Common KVM processor
Stepping: 1
CPU MHz: 2593.748
BogoMIPS: 5187.49
Hypervisor vendor: KVM
Virtualization type: full
L1d cache: 32K
L1i cache: 32K
L2 cache: 4096K
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx lm constant_tsc xtopology eagerfpu pni cx16 x2apic hypervisor lahf_lm
Comment