I am experiencing an issue with ProxySQL version 2.0.9 where connections to MySQL through SQLAlchemy disconnect after about 5 minutes of inactivity. Both ProxySQL and MySQL have wait_timeout and interactive_timeout set to 4 hours, but connections are still being dropped much sooner than expected.
Steps to Reproduce:
Set up ProxySQL 2.0.9 and configure wait_timeout and interactive_timeout on both ProxySQL and MySQL to 4 hours.
Connect to MySQL through ProxySQL using Python with SQLAlchemy.
Allow the connection to remain idle for 5 minutes.
Observe that the connection disconnects and an error message is displayed.
Expected Behavior:
The connection should remain active for up to 4 hours of inactivity, consistent with the wait_timeout and interactive_timeout configurations.
Observed Behavior:
The connection disconnects after about 5 minutes of inactivity. The error message received is:
The client was disconnected by the server because of inactivity, see wait_timeout and interactive_timeout
Additional Information:
ProxySQL version: 2.0.9
SQLAlchemy version: [specify your SQLAlchemy version here]
Python version: [specify your Python version here]
Both wait_timeout and interactive_timeout are configured to 4 hours on both ProxySQL and MySQL.
Any insights or suggestions to resolve this issue would be greatly appreciated. Thank you!
Description:
I am experiencing an issue with ProxySQL version 2.0.9 where connections to MySQL through SQLAlchemy disconnect after about 5 minutes of inactivity. Both ProxySQL and MySQL have wait_timeout and interactive_timeout set to 4 hours, but connections are still being dropped much sooner than expected.
Steps to Reproduce:
Set up ProxySQL 2.0.9 and configure wait_timeout and interactive_timeout on both ProxySQL and MySQL to 4 hours. Connect to MySQL through ProxySQL using Python with SQLAlchemy. Allow the connection to remain idle for 5 minutes. Observe that the connection disconnects and an error message is displayed. Expected Behavior:
The connection should remain active for up to 4 hours of inactivity, consistent with the wait_timeout and interactive_timeout configurations.
Observed Behavior:
The connection disconnects after about 5 minutes of inactivity. The error message received is:
The client was disconnected by the server because of inactivity, see wait_timeout and interactive_timeout
Additional Information:
ProxySQL version: 2.0.9 SQLAlchemy version: [specify your SQLAlchemy version here] Python version: [specify your Python version here] Both wait_timeout and interactive_timeout are configured to 4 hours on both ProxySQL and MySQL. Any insights or suggestions to resolve this issue would be greatly appreciated. Thank you!
Let me know if you'd like any adjustments.