Re: Reconnecting to mysql connector

[Noam Parness]

After another week of playing with it, I have another update:
I think I've narroewed the problem down some more. If the Arduino sends a request to the server, and doesn't get a response in a timely manner, it hangs.
Increasing the MAX_TIMEOUT from 10 to 20 helped some, but it still tends to hang at some point.
I changed my code so that I make the connection to the MySQL server inside the loop, right before I send the query. I then close the connection afterward. Since I only send the query if the connection is successful, I had hoped that would fix the issue for me. It was more stable for a number of hours, but it still hangs if the connection is lost (or times out) after the connection is made - but before the response is recevied by the Arduino.
My programming skills are not all that great, so I can't figure out where it is hanging, other than it seems to be right after the "wait_for_client()" function exits after being called the second time by the "read_packet()" function. (If that doesn't make any sense, then I *really* don't understand the code ;-) ).
I'm guessing that the timeout is creating a state which is not covered by the conditions in the nested functions - so it sits there forever instead of exiting out.