Zabbix Server 1.8.5 died on Mysql 5.5

[dalle]

I migrated from mysql 5.1 to mysql 5.5 commercial enterprise edition.
I recompiled server/agent/proxy binaries and now when i start the daemon
after few seconds the server die.
I've put the loglevel to 4 (debug) but all that I can see is:

21227:20110624:161404.033 Query [txnlev:0] [select min(clock) from trends where itemid=18398]
21209:20110624:161404.033 In DCflush_nextchecks()
21209:20110624:161404.033 End of get_values()
21209:20110624:161404.033 poller #1 spent 1.332867 seconds while updating 0 values
21209:20110624:161404.033 In DCconfig_get_poller_nextcheck() poller_type:0
21205:20110624:161404.033 One child process died (PID:21208,exitcode/signal:255). Exiting ...
21227:20110624:161404.033 In delete_history(trends_uint,18398,365,1308924842)
21246:20110624:161404.033 End of DCconfig_get_proxypoller_hosts():0
21205:20110624:161404.033 zbx_on_exit() called
21227:20110624:161404.033 Query [txnlev:0] [select min(clock) from trends_uint where itemid=18398]
21210:20110624:161404.033 Got signal [signal:15(SIGTERM),sender_pid:21205,sender_uid:500 ,reason:0]. Exiting ...

any help is really appreciate.
I've decided to move from mysql standard to commercial for hotbackup features but now nothing is working, obviously mysql is running well, etc... and no error on it.

Thanks

[richlv]

this logfile fragment doesn't show what happened with the process that died - what do you have on pid 21208 ?

[dalle]

You are absolutely right on pid there was a fork of zabbix, on monday i'll send you back a complete logfile
Thanyou

[dalle]

Dear Richlv here there is a complete logfile generated today
thankyou in advance

[JBo]

Hi,

From your logs :

21475:20110627:095240.692 [file:dbconfig.c,line:1304] zbx_mem_realloc(): [B]out of memory[/B] (requested 384 bytes)
21475:20110627:095240.692 [file:dbconfig.c,line:1304] zbx_mem_realloc(): [B]please increase CacheSize configuration parameter[/B]

Hope this helps
JBo

[dalle]

Hi,

From your logs :

21475:20110627:095240.692 [file:dbconfig.c,line:1304] zbx_mem_realloc(): [B]out of memory[/B] (requested 384 bytes)
21475:20110627:095240.692 [file:dbconfig.c,line:1304] zbx_mem_realloc(): [B]please increase CacheSize configuration parameter[/B]

Hope this helps
JBo

Yes this solved, thank you i didn't see at all
thank you again!!!
now is working right!!!!

[u002483]

Zabbix Error zbx_mem_realloc(): out of memory -zbx_mem_realloc(): please increase Cac

I am currently also a problem identical to that above.
Enclose print the error, as well as the zabbix server log.

If I can help in resolving this issue.
thank you


zabbix server log error :
"
1661:20130909:180020.851 __mem_malloc: skipped 6 asked 209224 skip_min 864 skip_max 139384
1661:20130909:180020.853 __mem_malloc: skipped 5 asked 209224 skip_min 864 skip_max 83168
1661:20130909:180020.853 __mem_malloc: skipped 6 asked 209224 skip_min 864 skip_max 139448
1661:20130909:180020.853 [file:dbconfig.c,line:365] zbx_mem_realloc(): out of memory (requested 209224 bytes)
1661:20130909:180020.853 [file:dbconfig.c,line:365] zbx_mem_realloc(): please increase CacheSize configuration parameter
1653:20130909:180020.854 One child process died (PID:1661,exitcode/signal:255). Exiting ...
1653:20130909:180022.855 syncing history data...
1653:20130909:180022.881 syncing history data done
1653:20130909:180022.881 syncing trends data...
1653:20130909:180023.115 syncing trends data done
1653:20130909:180023.115 Zabbix Server stopped. Zabbix 2.0.8 (revision ).

"

[JBo]

Hi,

A solution is suggested in your logs:

1661:20130909:180020.853 [file:dbconfig.c,line:365] zbx_mem_realloc(): out of memory (requested 209224 bytes)
1661:20130909:180020.853 [file:dbconfig.c,line:365] zbx_mem_realloc(): please increase CacheSize configuration parameter

Have you tried increasing CacheSize parameter ?

Hope this helps
JBo