Zabbix server crash randomly

[Valerie]

Hello,
We recently upgraded from 1.1alpha10 to 1.1beta 5. Ever since, the server has been crashing randomly, we succesfully repaired some of the issues(other thread ) but the server still crash every once in a while.

Here is the latest crash's log.

015791:20060123:134312 In process_new_value()
015791:20060123:134312 In add_history(zabbix[log],,1,4)
015791:20060123:134312 In add_history(18500,STRING:Parameter [zabbix[log]] became supported by agent on host [aquila])
015791:20060123:134312 In add_history_str()
015791:20060123:134312 Executing query:insert into history_str (clock,itemid,value) values (1138041792,18500,'Parameter [zabbix[log]] became supported by agent on host [aquila]')
015791:20060123:134312 End of add_history
015791:20060123:134312 In update_item()
015791:20060123:134312 Executing query:update items set nextcheck=1138041840,lastclock=1138041792 where itemid=18500
015791:20060123:134312 Parameter [zabbix[log]] became supported by agent on host [aquila]
015791:20060123:134312 In zabbix_log()
015791:20060123:134312 Executing query:select i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,h.status,i.value_type,h.network_errors,i.snmp_port,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt from hosts h, items i where h.hostid=i.hostid and i.key_='zabbix[log]' and i.value_type=1
015791:20060123:134312 In DBnum_rows
015791:20060123:134312 Result of DBnum_rows [1]
015791:20060123:134312 In DBnum_rows
015791:20060123:134312 Result of DBnum_rows [1]
015791:20060123:134312 In process_new_value()
015791:20060123:134312 In add_history(zabbix[log],,1,4)
015791:20060123:134312 In add_history(18500,STRING:Parameter [zabbix[log]] became supported by agent on host [aquila])
015791:20060123:134312 In add_history_str()
015791:20060123:134312 Executing query:insert into history_str (clock,itemid,value) values (1138041792,18500,'Parameter [zabbix[log]] became supported by agent on host [aquila]')
015791:20060123:134312 End of add_history
015791:20060123:134312 In update_item()
015791:20060123:134312 Executing query:update items set nextcheck=1138041840,lastclock=1138041792 where itemid=18500
015791:20060123:134312 Parameter [zabbix[log]] became supported by agent on host [aquila]
015791:20060123:134312 In zabbix_log()
015791:20060123:134312 Executing query:select i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,h.status,i.value_type,h.network_errors,i.snmp_port,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt from hosts h, items i where h.hostid=i.hostid and i.key_='zabbix[log]' and i.value_type=1
015791:20060123:134312 In DBnum_rows
015791:20060123:134312 Result of DBnum_rows [1]
015791:20060123:134312 In DBnum_rows
015791:20060123:134312 Result of DBnum_rows [1]
015776:20060123:134312 One child process died. Exiting ...
015776:20060123:134312 Got QUIT or INT or TERM or PIPE signal. Exiting...

Any kind of help would be appreciated.

[Valerie]

Getting insane...

Well, ever since my last post the server has kept crashing over and over again.
These lines are reccurent everytime it crash.

031511:20060123:140311 In add_history(18500,STRING:Parameter [zabbix[log]] became supported by agent on host [aquila])
031497:20060123:140311 One child process died. Exiting ...

This morning, the server kept up for about 2-3hours, untill i tried to add an host. Then it crashed, so i started to server again, removed that host, but it stills crash every 20 secondes or so.

[Alexei]

Please may I ask you to send the whole log file to a l e x @zabbix.com. Thanks!

[Valerie]

Problem solved

Hey Alexei,

Thanks for your time, but the problem is solved.
I believe the server was flooded with request from the agent to support this parameter... The log was full of this line :

Parameter [zabbix[log]] became supported by agent on host [aquila])

What i did to get this solve, was to desactivate the item "zabbix[log"]" from the items configuration of the host (wich is the server by the way). Then the server came up and running, I guess it "realised" the agent version had changed. Then I reactivated the parameter without crashing the whole thing..

Sorry i cannot come up with a better explanation.