ESP8266 Community Forum

- Fri Feb 19, 2016 2:06 pm #41477 Hi,

I am using the nodelua with the arduino library to send data to an SQL database, but after some time running the esp stops sending the data to the SQL database. I would like to know if anyone has encountered this problem before and if so how it was resolved

Any help will be appreciated

thanks

- Sun Feb 21, 2016 3:50 pm #41612 I'm facing the exactly same problem. Right now I'm doing some tests without sending data to SQL to be sure if the problem isn't related to WiFi.

Did you noticed if the serial monitor stopped too? In my case, yes. It seems that the ESP completely freezes.

Mine freezes in 15 minutes, at maximum.

- Sat Feb 27, 2016 12:41 pm #42008 Just to keep you updated, I discovered that I had 2 stability sources: the SQL and the WiFi. After reading a lot of posts in this forum about stability and suggestions to address the problem correctly, I made some changes in my circuit and voilà! The WiFi stability seems to be solved right now. It's been more than 12 hours without any hang. I'll wait unitl 48 hours and then I'll try to understand why it freezes after sending a bunch of queries to the SQL server.

Maybe it's better to have the server to get the data from ESP instead of the ESP sending to server.

P.S.: english is not my native language...

- Thu Mar 03, 2016 7:48 am #42302 Now I'm sure that I don't have any problem with the ESP itself. I've changed the SQL library to a newer release and it works for more than an hour. But still keeps hanging... Checked the memory usage and it seems to be OK, lots of memory available... It hangs ONLY if it's running the query. In normal usage, no hangs.

Any ideas?