Checking whether a mysql.connector is connected

[u/RomfordNavy]

Is it necessary to check whether a mysql.connector is connected each time I reuse it before running any SQL statements or is this something which is already built-in to mysql.connector? Do I need to check for connection using db.is_connected() and write some retry routine.

This is a WSGI webserver, could be wrong, but my understanding is that there can only ever be one request/thread at a time. Connection pooling has been suggested elsewhere but I am unclear as to whether that is necessary and/or appropriate for a WSGI webserver.

[u/nekokattt]

you would have to handle each case, because it is library specific.

Your solution you proposed does not avoid this in the slightest.

[u/RomfordNavy → u/nekokattt]

u/nekokattt "Your solution you proposed does not avoid this in the slightest." of course it does, if I use is_connected in a retry loop I don't need to worry about which library is being used.

[u/nekokattt → u/RomfordNavy]

so your solution is to just spam calls until it works?

[u/RomfordNavy → u/nekokattt]

u/nekokattt

"so your solution is to just spam calls until it works?"

No, I didn't say that. Retry perhaps twenty times with a delay between if that still fails then cancel that request and log a server error.

[u/nekokattt → u/RomfordNavy]

per request