maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #04180
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