проблемы с БД?

[tsolodov]

13864:20100608:040235.941 [Z3005] Query failed: [2006] MySQL server has gone away [begin;]
13864:20100608:040236.072 [Z3005] Query failed: [2006] MySQL server has gone away [update hosts set errors_from=0,disable_until=0,error='' where hostid=10017]
13853:20100608:041800.613 [Z3005] Query failed: [2006] MySQL server has gone away [begin;]
13853:20100608:041800.625 [Z3005] Query failed: [2006] MySQL server has gone away [update hosts set snmp_errors_from=0,snmp_disable_until=0,snmp_error ='' where hostid=11984]
13925:20100608:045801.289 [Z3005] Query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [delete from escalations where escalationid=514929]
13854:20100608:054959.810 [Z3005] Query failed: [2006] MySQL server has gone away [begin;]
13854:20100608:054959.857 [Z3005] Query failed: [2006] MySQL server has gone away [update hosts set snmp_disable_until=1275961814 where hostid=11985]
13863:20100608:055005.220 [Z3005] Query failed: [2006] MySQL server has gone away [begin;]
13863:20100608:055005.222 [Z3005] Query failed: [2006] MySQL server has gone away [update hosts set snmp_disable_until=1275961820 where hostid=11986]
13925:20100608:114838.784 [Z3005] Query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [delete from escalations where escalationid=520423]

Последнее время стали сыпаться ошибки в логе....
Мб пора переходить на innoDB?
Или в чем то другом дело?
Сервер mysql всегда запущен, в даун он не уходит.

[$0s]

+1
Только немного не так:

[Z3005] Query failed: [2006] MySQL server has gone away [begin;]
[Z3005] Query failed: [2006] MySQL server has gone away [update hosts set snmp_a
Database is down. Retrying in 10 seconds
[Z3005] Query failed: [2006] MySQL server has gone away [begin;]
[Z3005] Query failed: [2006] MySQL server has gone away [update hosts set snmp_a
Database is down. Retrying in 10 seconds
[Z3005] Query failed: [2006] MySQL server has gone away [begin;]
[Z3005] Query failed: [2006] MySQL server has gone away [update hosts set snmp_a
Database is down. Retrying in 10 seconds
[Z3005] Query failed: [2006] MySQL server has gone away [begin;]
[Z3005] Query failed: [2006] MySQL server has gone away [update hosts set snmp_a
Database is down. Retrying in 10 seconds

[zxxc]

А как сделать чтобы заббикс не умирал когда база упала? А сам пробовал переподключаться?

[sergeyfromkomi]

тоже самое подтверждаю .... вот только логи я не сохранил...отчистил... как только появится напишу...

 36211:20100613:213838.374 Deleted 4148 records from history and trends
 36201:20100613:215920.285 Item [BGP_RTKOM:bgp.check []] error: Script /usr/local/etc/zabbix/externalscripts/bgp.check  returned nothing.
 36201:20100613:215920.285 Parameter [BGP_RTKOM:bgp.check []] is not supported by agent Old status [0]
 36201:20100613:215920.285 [Z3005] Query failed: [2006] MySQL server has gone away [begin;]
 36201:20100613:215920.285 [Z3005] Query failed: [2006] MySQL server has gone away [select t.triggerid,i.itemid from triggers t,functions f,items i where t.t
 36201:20100613:215920.285 Database is down. Retrying in 10 seconds
 36217:20100613:220120.780 Parameter [24677][BGP_RTKOM:bgp.check []] became supported by agent
 36211:20100613:223938.397 Executing housekeeper
 36211:20100613:223942.704 Deleted 4154 records from history and trends
 36211:20100613:234042.726 Executing housekeeper

прошу внимания разработчиков к этой проблеме...!!!!

[sergeyfromkomi]

Последнее время стали сыпаться ошибки в логе....
Мб пора переходить на innoDB?
Или в чем то другом дело?
Сервер mysql всегда запущен, в даун он не уходит.

http://www.zabbix.com/forum/showthread.php?t=17489