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?
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...
Ah, good idea. I'll check that, thanks. _____ From: iglance@yahoogroups.com [mailto:iglance@yahoogroups.com] On Behalf Of Peter Pan Sent: Monday, October 23,...
This way maybe you will also find MySQL replication and failover a fun. ... From: David Barrett To: iglance@yahoogroups.com Sent: Monday, October 23, 2006 5:26...
Incidentally, I finally resolved the server problem - as Peter suggested, it was just a matter of reconnecting to the MySQL database on occasion. Not sure why...