Re: Reconnecting to mysql connector

[Noam Parness]

Well, I wanted to post an update here, for anyone else following this thread.
After a few e-mails back and forth with Dr. Bell, I added a lot of Serial.print() statements into the code (bothmine and the mysql.cpp), to narrow down where the freeze is taking place.
I've also switched from the enc28j60 to the W5100-based Ethernet controller, and removed the EasyTransfer and SoftwareSerial libraries entireley from my code.
I'm still getting freezes, seemingly at the same place (at the end of the "wait_for_client()" function.
It seems to happen randomly, but I haven't been able to pass 6 hours without it crashing so far.
I don't suspect the MySQL database/server as the culprit, since I don't get any error messages, and a parallel system has been pumping data into that same database (via a PERL script on the PC) for two years now without a problem.

My top theory is still with a timeout of the MySQL connection, and I don't know how to get my code to recover from that.

--Noam