Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION)
Interesting. A couple ideas:
1
Try this query:
SHOW SESSION VARIABLES LIKE '%timeout%';
But this time, this should be executed by PHP, using the same library used by the application. Why? To check if a library changes a timeout at session level.
2
Have you checked if your application reconnects N times? For example, 600 could be a 60 seconds timeout * 10 attempts.
Federico
--------------------------------------------
Mar 29/11/16, Florent B
Am 29.11.2016 um
For example, if I try this in PHP:
1/ Connect to mariadb
2/ sleep 610 seconds
3/
11:49 schrieb Florent B: ping mariadb
=> I got Server has gone away
error.
With a 590 sleep time, no error.
I use MariaDB 10.1, didn't change
any "timeout" value in MariaDB :
interactive_timeout & wait_timeout are 28800
http://php.net/manual/en/mysqlnd.config.php#ini.mysqlnd.net-read-timeout
Hi, and thank you. But I cannot find any timeout of 600 seconds... default_socket_timeout = 60 mysqlnd.net_read_timeout = 31536000 And I have the exactly same problem using this algorithm in Python, it's not related to PHP... _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (1)
-
Federico Razzoli