ChuckBell
commented
4 years ago Sounds like you’re running out of memory or the connection is dropping or hanging. Please ensure you’re doing the following:
- connect/disconnect in the loop() (not in setup())
- use free_row_boffer after each row is read
- use free_column_buffer after all columns are read
- delete the cursor
You can also print the available memory on each pass through loop(), which should give you an idea if you are leaking memory.
If you’re still stumped, you can send me your sketch and I’ll try to look at it.
On Apr 9, 2020, at 1:37 PM, TomInIowa notifications@github.com wrote:
Running on Arduino Uno with Ethernet Shield. Running the sketch "querry_results" Sometimes it works 5 or 10 times in a row. Then it quits doing MySQL_Cursor *cur_mem = new MySQL_Cursor(&conn); I put Serial.println ... above and below the line
The serial monitor shows a backward question mark when it doesn't work. from your function: Ram:991
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/130, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB6SHYFUDUVJK6DIKIGE4ULRLYBVJANCNFSM4ME42KQQ.
Thank you for sharing the sketch/library!!!!
Running on Arduino Uno with Ethernet Shield. Running the sketch "querry_results" Sometimes it works 5 or 10 times in a row. Then it quits doing MySQL_Cursor *cur_mem = new MySQL_Cursor(&conn); I put Serial.println ... above and below the line
The serial monitor shows a backward question mark when it doesn't work. from your function: Ram:991 It starts working again (I haven't figured out why)