GreenSQL started dying again this morning after running for several months without a problem.

Here are the last lines from the log, I've masked part of the log that contains IP addresses.


[11/Dec/2008 20:19:32] NET_DEBUG [2]frontend socket fired 10
[11/Dec/2008 20:19:32] SQL_DEBUG QUERY command[SysLogs]: INSERT INTO logs (host, facility, priority, level, tag, date, time, program, msg) VALUES ( '0.0.0.193', 'local4', 'err', 'err','a3','2008-12-11', '20:19:32', '%PIX-3-305005', '%PIX-3-305005: No translation group found for udp src outside:123.16.12.211/1118 dst custdmz:zenoss/53' )
[11/Dec/2008 20:19:32] SQL_DEBUG AFTER NORM : insert into logs (host, facility, priority, level, tag, date, time, program, msg) values ( ?, ?, ?, ?,?,?, ?, ?, ? )
[11/Dec/2008 20:19:32] SQL_DEBUG RISK : 0
[11/Dec/2008 20:19:32] NET_DEBUG Socket_write
[11/Dec/2008 20:19:32] NET_DEBUG [2]backend socket fired 11
[11/Dec/2008 20:19:32] NET_DEBUG packet size expected 19 bytes (received 19)
[11/Dec/2008 20:19:32] NET_DEBUG Long response. Number of fields 0
[11/Dec/2008 20:19:32] NET_DEBUG Socket_write
[11/Dec/2008 20:19:32] NET_DEBUG [2]frontend socket fired 10
[11/Dec/2008 20:19:32] SQL_DEBUG QUERY command[SysLogs]: INSERT INTO logs (host, facility, priority, level, tag, date, time, program, msg) VALUES ( 'rdu-co-web03', 'local0', 'warning', 'warning','84','2008-12-11', '20:19:32', 'snmptt-sys', 'snmptt-sys[0]: MySQL error: Unable to connect to database: Access denied for user \'root\'@\'localhost\' (using password: NO)' )
[11/Dec/2008 20:19:32] SQL_DEBUG AFTER NORM : insert into logs (host, facility, priority, level, tag, date, time, program, msg) values ( ?, ?, ?, ?,?,?, ?, ?, ? )
[11/Dec/2008 20:19:32] SQL_DEBUG RISK : 0
[11/Dec/2008 20:19:32] NET_DEBUG Socket_write
[11/Dec/2008 20:19:32] NET_DEBUG [2]backend socket fired 11
[11/Dec/2008 20:19:32] NET_DEBUG packet size expected 19 bytes (received 19)
[11/Dec/2008 20:19:32] NET_DEBUG Long response. Number of fields 0
[11/Dec/2008 20:19:32] NET_DEBUG Socket_write
[11/Dec/2008 20:19:32] NET_DEBUG [2]frontend socket fired 10
[11/Dec/2008 20:19:32] SQL_DEBUG QUERY command[SysLogs]: INSERT INTO logs (host, facility, priority, level, tag, date, time, program, msg) VALUES ( 'rdu-co-web03', 'daemon', 'info', 'info','1e','2008-12-11', '20:19:32', 'snmptrapd', 'snmptrapd[2160]: 0.0.0.193' )
[11/Dec/2008 20:19:32] SQL_DEBUG AFTER NORM : insert into logs (host, facility, priority, level, tag, date, time, program, msg) values ( ?, ?, ?, ?,?,?, ?, ?, ? )
[11/Dec/2008 20:19:32] SQL_DEBUG RISK : 0
[11/Dec/2008 20:19:32] NET_DEBUG Socket_write
[11/Dec/2008 20:19:32] NET_DEBUG [2]backend socket fired 11
[11/Dec/2008 20:19:32] NET_DEBUG packet size expected 19 bytes (received 19)
[11/Dec/2008 20:19:32] NET_DEBUG Long response. Number of fields 0
[11/Dec/2008 20:19:32] NET_DEBUG Socket_write
[11/Dec/2008 20:19:33] CRIT Killer
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] NET_DEBUG connection close()
[11/Dec/2008 20:19:33] DEBUG config destructor


I've restarted it several times, each time it dies....it prints the same NET_DEBUG connection close messages over and over.

http://www.dougware.net