"Can't find shared memory for database cache" and "MySQL server has gone away"

[fatiha]

Hi,

zabbix_server is installed on a Red Hat Enterprise Linux AS release 4 (Nahant Update 3) a,d mysql database on a Red Hat Enterprise Linux Server release 5.2 (Tikanga).

Zabbix_server stops every day and I wrote a script to restart it when it stops. The problem is that I don't understand the reason why it stops.

Below the lines extracted from zabbix_server.log :

731:20110214:091005 ZABBIX Server stopped. ZABBIX 1.6.4.
6860:20110214:091501 Starting zabbix_server. ZABBIX 1.6.4.
.....................
6860:20110214:094040 One child process died. Exiting ...
6860:20110214:094042 Can't find shared memory for database cache. [No such file or directory]
7307:20110214:094047 Starting zabbix_server. ZABBIX 1.6.4.
.....................
7312:20110215:024501 [Z3005] Query failed: [1053] Server shutdown in progress [select distinct h.hostid from hosts h, items i, functions f, triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=59749]
7314:20110215:024501 [Z3005] Query failed: [2006] MySQL server has gone away [select value from history where itemid=72897 order by clock desc limit 3]
7307:20110215:024501 One child process died. Exiting ...
7307:20110215:024503 ZABBIX Server stopped. ZABBIX 1.6.4.
.....................

Can you help me ?

Thanks,
Fatiha

[fatiha]

You can find below some informations about my file my.cnf :

wait_timeout=31536000
max_allowed_packet=32M
innodb_flush_log_at_trx_commit=0
max_connections=200
query_cache_size=32M
query_cache_type=1
tmp_table_size=46M
thread_cache_size=8
innodb_additional_mem_pool_size=6M
innodb_log_buffer_size=3M
innodb_buffer_pool_size=3G
innodb_log_file_size=700M
sort_buffer_size=4194288

Below you can read my database server's information, cat /proc/meminfo :

MemTotal:      4048196 kB
MemFree:         34208 kB
Buffers:          7212 kB
Cached:         951152 kB
SwapCached:     708172 kB
Active:        2987900 kB
Inactive:       955852 kB
HighTotal:           0 kB
HighFree:            0 kB
LowTotal:      4048196 kB
LowFree:         34208 kB
SwapTotal:     2064376 kB
SwapFree:       696620 kB
Dirty:             140 kB
Writeback:           0 kB
AnonPages:     2948764 kB
Mapped:          10984 kB
Slab:            46056 kB
PageTables:       9736 kB
NFS_Unstable:        0 kB
Bounce:              0 kB
CommitLimit:   4088472 kB
Committed_AS:  4135788 kB
VmallocTotal: 34359738367 kB
VmallocUsed:      1568 kB
VmallocChunk: 34359736647 kB
HugePages_Total:     0
HugePages_Free:      0
HugePages_Rsvd:      0
Hugepagesize:     2048 kB