-
Type:
Incident report
-
Resolution: Won't Do
-
Priority:
Critical
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
when i click lastest data in zbx page, get error
no matter in zbx3.2 or 3.4 or 4.0
ZABBIX-WEB info
[root@zabbix_web]#
zabbix_get (Zabbix) 4.0.0
nginx version: nginx/1.10.2
CentOS release 6.8 (Final)
PHP 5.5.38 (cli) (built: Jul 21 2016 12:51:12)
[root@zabbix_web]# egrep -v "$|#" /etc/zabbix/zabbix_server.conf
StartPollers=300
StartPollersUnreachable=80
StartDiscoverers=120
StartVMwareCollectors=160
VMwareCacheSize=1G
CacheSize=4G
StartDBSyncers=16
HistoryCacheSize=1G
HistoryIndexCacheSize=256M
TrendCacheSize=1G
ValueCacheSize=1G
StartPingers=100
DBHost=XXX
DBPassword=XXX
StartSNMPTrapper=1
HousekeepingFrequency=0
LogFile=/var/log/zabbix/zabbix_server.log
LogFileSize=0
PidFile=/var/run/zabbix/zabbix_server.pid
DBName=zabbix
DBUser=XXX
SNMPTrapperFile=/var/log/snmptrap/snmptrap.log
Timeout=30
AlertScriptsPath=/usr/lib/zabbix/alertscripts
ExternalScripts=/usr/lib/zabbix/externalscripts
LogSlowQueries=10000
ZABBIX DB info
[root@zabbix-db]# mysql -V
mysql Ver 14.14 Distrib 5.7.16-10(Percona5.7)
[root@zabbix-db]# cat /etc/my.cnf
[mysqld]
wait_timeout=15
interactive_timeout=15
datadir=/home/percona/data
socket=/home/percona/data/mysql.sock
user=mysql
max_allowed_packet=32M
expire_logs_days=7
#max-heap-table-size=128M
#key_buffer_size=128M
#sort-buffer-size=16M
#join-buffer-size=16M
#net_buffer_size=8K
#read_buffer_size=256K
#read_rnd_buffer_size=512K
#thread-cache-size=16
#thread-concurrency=24
#query-cache-size=4096M
#query-cache-limit=4M
#tmp-table-size=128M
#log_warnings
#innodb_file_io_threads=4
#innodb_open_files=2048
#innodb_buffer_pool_size=10G
#innodb_additional_mem_pool=16M
#innodb_thread_concurrency=16
#innodb_max_dirty_pages_pct=90
event_scheduler=ON
- Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
max_connections=5000
slow_query_log
slow_query_log_file=/home/percona/log/slowquery.log
long_query_time=2
log-error=/home/percona/log/log-error.log
#skip-name-resolve
#back_log=300
#table-cache=4096
character-set-server=utf8
innodb_file_per_table=1
server-id=1
log-bin=mysql-bin
log-bin=/home/percona/log/update
[mysqld_safe]
log-error=/home/percona/log/mysqld.log
pid-file=/home/percona/data/zabbix-db.pid
#[mysql]
#no-auto-rehash
#[mysqldump]
#quick
#max_allowed_packet=16M