Stéphane Varoqui, Senior Consultant

Phone: +33 695-926-401, skype: svaroqui
http://www.mariadb.com

Le 29 Nov 2016 à 12:22, Florent B <florent@coppint.com> a écrit :

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…

Have you check your TCP settings or may be some firewall or proxy that would just sit in the middle ? 



_______________________________________________
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