search

ChuckBell / MySQL_Connector_Arduino

Database connector library for using MySQL with your Arduino projects.
333 stars 133 forks source link

conn.close() doesn't close properly #162

Closed hervema closed 3 years ago

hervema commented 3 years ago

Hello,

When I would like to close an opened connection I use .close() function.

This works, apparently, as the connection is not really closed on the server and seems to stay in a "sleep" mode, and the number of connections on the server is growing over and over again...

Is there a better way to, really, close a connection on the server ?

Thanks,

Regards,

Hervema

hervema commented 3 years ago

Hello,

I've found my problem.

In my code, the call to .close() function was immediately follow by a wifi.disconnect ...

I added a delay between, delay(300), and all is working well now ! :-)

Thanks,

Regards,

Hervema

ChuckBell commented 3 years ago

Excellent!

On Nov 26, 2020, at 4:02 PM, hervema notifications@github.com wrote:

Closed #162 https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/162.

— 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/162#event-4043861353, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB6SHYEJT7P5T3CIREDK7CLSR265LANCNFSM4UEBRRYQ.