MySQL Forums :: Connector/Arduino :: Reconnecting to mysql connector


Advanced Search

Re: Reconnecting to mysql connector
Posted by: Noam Parness ()
Date: December 29, 2013 09:48AM

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

Options: ReplyQuote


Subject Views Written By Posted
Reconnecting to mysql connector 7850 Chris Watters 11/01/2013 01:10AM
Re: Reconnecting to mysql connector 2349 Darlington Adibe 11/01/2013 10:22PM
Re: Reconnecting to mysql connector 2137 Charles Bell 11/06/2013 06:48AM
Re: Reconnecting to mysql connector 1875 Milan Rotovnik 11/06/2013 09:35AM
Re: Reconnecting to mysql connector 1999 Charles Bell 11/07/2013 08:47AM
Re: Reconnecting to mysql connector 1713 Milan Rotovnik 11/11/2013 02:03PM
Re: Reconnecting to mysql connector 2153 Noam Parness 12/18/2013 01:48PM
Re: Reconnecting to mysql connector 1768 Charles Bell 12/18/2013 03:48PM
Re: Reconnecting to mysql connector 1746 Noam Parness 12/29/2013 09:48AM
Re: Reconnecting to mysql connector 1448 Noam Parness 12/30/2013 03:15PM
Re: Reconnecting to mysql connector 1470 Noam Parness 12/31/2013 11:50AM
Re: Reconnecting to mysql connector 1676 Noam Parness 01/06/2014 01:59PM
Re: Reconnecting to mysql connector 1460 Charles Bell 02/04/2014 03:45PM
Re: Reconnecting to mysql connector 1397 Noam Parness 02/04/2014 04:20PM
Re: Reconnecting to mysql connector 1442 Charles Bell 02/05/2014 01:15PM
Re: Reconnecting to mysql connector 1586 Noam Parness 02/05/2014 02:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.