Доброго дня
Появилась странная проблема с мускулем. В лог заббикса сыплются ошибки
dmesg, messages, syslog, лог mysql - все чисто
конфиг mysql:
zabbix и mysql на одной машине
Появилась странная проблема с мускулем. В лог заббикса сыплются ошибки
Code:
1667:20110628:114248.488 [Z3005] Query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='sargass' and status in (0,1) and proxy_hostid=0 and hostid between 000000000000000 and 099999999999999]
1665:20110628:114253.533 [Z3005] Query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='kauri' and status in (0,1) and proxy_hostid=0 and hostid between 000000000000000 and 099999999999999]
Timeout: No Response from 192.168.202.5
1666:20110628:114255.598 Sending list of active checks to [127.0.0.1] failed: host [localhost] not found
Timeout: No Response from 192.168.202.4
1672:20110628:114300.959 [Z3005] Query failed: [2006] MySQL server has gone away [select distinct t.triggerid,t.type,t.value,t.error,t.expression from triggers t,functions f,items i,hosts h where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=h.hostid and t.status=0 and f.function in ('nodata','date','dayofmonth','dayofweek','time','now') and i.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and h.hostid between 000000000000000 and 099999999999999]
Timeout: No Response from 192.168.202.4
1683:20110628:114309.847 [Z3005] Query failed: [2006] MySQL server has gone away [select druleid,iprange,name,unique_dcheckid from drules where proxy_hostid=0 and status=0 and (nextcheck<=1309246989 or nextcheck>1309246989+delay) and mod(druleid,1)=0 and druleid between 000000000000000 and 099999999999999]
1665:20110628:114323.780 [Z3005] Query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='puma' and status in (0,1) and proxy_hostid=0 and hostid between 000000000000000 and 099999999999999]
1657:20110628:114327.194 [Z3005] Query failed: [2006] MySQL server has gone away [select i.itemid,i.hostid,h.proxy_hostid,i.type,i.data_type,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.snmp_port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.delay,i.delay_flex,i.trapper_hosts,i.logtimefmt,i.params,i.status,i.authtype,i.username,i.password,i.publickey,i.privatekey from items i,hosts h where i.hostid=h.hostid and h.status in (0) and i.status in (0,3) and i.itemid between 000000000000000 and 099999999999999]
1664:20110628:114329.796 [Z3005] Query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='sturgeon' and status in (0,1) and proxy_hostid=0 and hostid between 000000000000000 and 099999999999999]
1672:20110628:114330.998 [Z3005] Query failed: [2006] MySQL server has gone away [select distinct t.triggerid,t.type,t.value,t.error,t.expression from triggers t,functions f,items i,hosts h where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=h.hostid and t.status=0 and f.function in ('nodata','date','dayofmonth','dayofweek','time','now') and i.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and h.hostid between 000000000000000 and 099999999999999]
1660:20110628:114336.935 [Z3005] Query failed: [2006] MySQL server has gone away [begin;]
1663:20110628:114344.345 [Z3005] Query failed: [2006] MySQL server has gone away [begin;]
1683:20110628:114409.854 [Z3005] Query failed: [2006] MySQL server has gone away [select druleid,iprange,name,unique_dcheckid from drules where proxy_hostid=0 and status=0 and (nextcheck<=1309247049 or nextcheck>1309247049+delay) and mod(druleid,1)=0 and druleid between 000000000000000 and 099999999999999]
1664:20110628:114416.509 [Z3005] Query failed: [2006] MySQL server has gone away [select hostid,status from hosts where host='serval' and status in (0,1) and proxy_hostid=0 and hostid between 000000000000000 and 099999999999999]
конфиг mysql:
Code:
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /data #/var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking bind-address = 0.0.0.0 #127.0.0.1 key_buffer = 128M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 32 thread_cache = 32 myisam-recover = BACKUP table_cache = 512M thread_concurrency = 8 max_heap_table_size=1024M tmp_table_size = 2048M query_cache_limit = 1M query_cache_size = 256M query_cache_min_res_unit = 512 long_query_time = 5 expire_logs_days = 10 max_binlog_size = 100M log_slow_queries = /var/log/mysql/mysql-slow.log # * InnoDB default-storage-engine=innodb innodb_open_files = 500 innodb_file_per_table innodb_buffer_pool_size = 1024M innodb_flush_log_at_trx_commit = 2 innodb_thread_concurrency = 8 innodb_lock_wait_timeout = 500 innodb_log_file_size = 64M interactive_timeout = 20 back_log = 75 wait_timeout = 30 connect_timeout = 10 [mysqldump] quick quote-names max_allowed_packet = 16M
Comment