You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi guys, I have been investigating how laravel octane maintaining the connection to mysql Database,, and I noticed that laravel octane never disconnect from mysql by sending a quit to mysql server, i mean even after the server is going down.
Let me explain it more, i know that laravel octane maintain's one connection for each worker, but what if this worker is taken down, currently the connection to mysql will still be open that because laravel octane dose not send disconnect (Quit) to mysql,,
To reproduce the problem:
first create a new installation of laravel with octane
run migrations ( while opening mysql logs ) you will see in mysql logs something like:
# mysql logs
15 Connect root@localhost on db_name using TCP/IP
15 Close stmt
15 Quit
run the server using laravel octane
do any query ( navigate to the main page and do some queries in that route )
quit from laravel octane
# mysql logs
17 Connect root@localhost on test_rabbitmq_keepalive using TCP/IP
17 Close stmt
it should be Quit the connection after laravel octane server is stopped.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
Hi guys, I have been investigating how laravel octane maintaining the connection to mysql Database,, and I noticed that laravel octane never disconnect from mysql by sending a quit to mysql server, i mean even after the server is going down.
Let me explain it more, i know that laravel octane maintain's one connection for each worker, but what if this worker is taken down, currently the connection to mysql will still be open that because laravel octane dose not send disconnect (Quit) to mysql,,
To reproduce the problem:
# mysql logs 15 Connect root@localhost on db_name using TCP/IP 15 Close stmt 15 Quit
# mysql logs 17 Connect root@localhost on test_rabbitmq_keepalive using TCP/IP 17 Close stmt
it should be Quit the connection after laravel octane server is stopped.
Any help on explaining this?
Beta Was this translation helpful? Give feedback.
All reactions