← Back to team overview

maria-discuss team mailing list archive

Re: Aborted connection (CLOSE_CONNECTION)

 

Stéphane Varoqui, Senior Consultant
Phone: +33 695-926-401, skype: svaroqui
http://www.mariadb.com <http://www.mariadb.com/>
> Le 29 Nov 2016 à 12:22, Florent B <florent@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp


References