----- Original Message -----

From: David Barrett

To: iglance@yahoogroups.com

Sent: Monday, October 23, 2006 1:41 PM

Subject: [iglance] MySQL 5 oddities?

So the iGlance server suffered a motherboard failure, thus triggering a big upgrade of hardware and software alike.  One change to the system is now we’re using MySQL 5, and something strange is afoot. 

Basically, the connection between the iGlance server and MySQL just stops working on occasion.  No other changes to the code, and it works great for hours or even days, and then spontaneously stops working.  The server in this state is still “working” fine in that it is processing and responding messages, but anything involving the database fails to work.  Restart the server without touching MySQL at all, and it works fine for another day or so.

Any ideas?  Is there some kind of age or query limit on a connection, thus requiring an occasional reconnect?

-david