maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

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@xxxxxxxxxxx> ha scritto:

 Oggetto: Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION)
 A: "Reindl Harald" <h.reindl@xxxxxxxxxxxxx>, maria-discuss@xxxxxxxxxxxxxxxxxxx
 Data: Martedì 29 novembre 2016, 12:22
 
 On 11/29/2016 12:03 PM,
 Reindl Harald wrote:
 >
 >
 > Am 29.11.2016 um
 11:49 schrieb Florent B:
 >> For
 example, if I try this in PHP:
 >>
 >> 1/ Connect to mariadb
 >>
 >> 2/ sleep 610
 seconds
 >>
 >> 3/
 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@xxxxxxxxxxxxxxxxxxx
 Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp