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 <florent@coppint.com> ha scritto: Oggetto: Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION) A: "Reindl Harald" <h.reindl@thelounge.net>, maria-discuss@lists.launchpad.net Data: Martedì 29 novembre 2016, 12:22 On 11/29/2016 12:03 PM, Reindl Harald wrote:
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