Server dies on SQL Query

[KarmaPolice]

022620:20060113:120230 Query::select function,parameter,itemid,lastvalue from functions where itemid=18069 group by 1,2,3 order by 1,2,3
022629:20060113:120230 Query::insert into history_str (clock,itemid,value) values (1137175350,18118,'1.1beta4')
022620:20060113:120230 Query failed:Lost connection to MySQL server during query [2013]
022629:20060113:120230 Query failed:Lost connection to MySQL server during query [2013]
022624:20060113:120230 Query::select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,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_securit ylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassph rase,i.formula,h.available,i.status from items i,hosts h where i.nextcheck<=1137175350 and i.status in (0,3) and i.type not in (2,7) and ((h.status=0 and h.available!=2) or (h.status=0 and h.available=2 and h.disable_until<=1137175350)) and h.hostid=i.hostid and i.itemid%15=12 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') order by i.nextcheck
022624:20060113:120230 Query failed:Lost connection to MySQL server during query [2013]
022629:20060113:120230 Query::update items set nextcheck=1137175380,lastclock=1137175350 where itemid=18118
022629:20060113:120230 Query failed:Can't connect to MySQL server on 'STPUXA00' (111) [2003]
022629:20060113:120230 Query::select function,parameter,itemid,lastvalue from functions where itemid=18118 group by 1,2,3 order by 1,2,3
022629:20060113:120230 Query failed:Can't connect to MySQL server on 'STPUXA00' (111) [2003]
022593:20060113:120230 One child process died. Exiting ...
022598:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022593:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022595:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022601:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022609:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022596:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022618:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022648:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022600:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022648:20060113:120230 Cannot remove PID file [/var/tmp/zabbix_server.pid] [No such file or directory]
022605:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022606:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022649:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022652:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022656:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022652:20060113:120230 Cannot remove PID file [/var/tmp/zabbix_server.pid] [No such file or directory]
022608:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022604:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022610:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022616:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022621:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022623:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022649:20060113:120230 Cannot remove PID file [/var/tmp/zabbix_server.pid] [No such file or directory]
022656:20060113:120230 Cannot remove PID file [/var/tmp/zabbix_server.pid] [No such file or directory]
022630:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022653:20060113:120230 Got QUIT or INT or TERM or PIPE signal. Exiting...
022653:20060113:120230 Cannot kill process. PID=[22595] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22596] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22598] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22600] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22601] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22604] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22605] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22606] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22608] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22609] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22610] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22616] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22618] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22620] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22621] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22623] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22624] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22629] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22630] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22648] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22649] [No such process]
022653:20060113:120230 Cannot kill process. PID=[22652] [No such process]
022653:20060113:120230 Cannot remove PID file [/var/tmp/zabbix_server.pid] [No such file or directory]




Any thoughts?

[Alexei]

"Cannot connect to MySQL" clearly indicates that MySQL is not running!

[KarmaPolice]

"Cannot connect to MySQL" clearly indicates that MySQL is not running!

That's what i thought too... however it is running... i'm currently looking into why it might not be able to connect but i'm 100% sure it's up and running...

What kind of connection settings for MySQL do you use in your standard config? persistent connections? how many connections? and how long a timeout?