Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:54850
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.220.170 as permitted sender)
MIME-Version: 1.0
Sender: laruence@gmail.com
In-Reply-To: <4E54B5B4.2040607@hristov.com>
References: <CABBJUpcv2SCYTcuB5kCb4Vf_ncH8r4jEY_FsWS6Fq3OS=1J9cQ@mail.gmail.com>
	<CABBJUpeuQ3CO7qf5bMmSmSwWbNG3pKX=oD-afNK2DATuEDSfUg@mail.gmail.com>
	<4E54B5B4.2040607@hristov.com>
Date: Wed, 24 Aug 2011 16:47:24 +0800
Message-ID: <CABBJUpfEu_ki3UcFQGQ1H+1cAy4upG+jKjWQBgNzC6Nye8cYVw@mail.gmail.com>
To: Andrey Hristov <php@hristov.com>
Cc: PHP Internals <internals@lists.php.net>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Subject: Re: [BC]mysql_pconnect generate warning when link against mysqlnd
From: laruence@php.net (Laruence)

Hi:
   hmm,

   but it really no sense for mysql_ping.

   the function used to identified a link whether valid,  and if not
valid, return a false is enough :)

thanks

2011/8/24 Andrey Hristov <php@hristov.com>:
> =C2=A0Hi,
> in my opinion a warning in this case is better than no warning. Because t=
his
> shows a problem and even if display_warnings is off the warnings can be
> logged for further inspection.
>
> Best,
> Andrey
>
> On 08/24/2011 09:35 AM, Laruence wrote:
>>
>> And the same warnings will be throw while call mysql_ping too.
>>
>> $plink =3D mysql_pconnect(****);
>> sleep(*); //a long time wait the mysql server timeout
>>
>> if (!mysql_ping($plink)) {} // warning genereated
>>
>> thanks
>>
>> 2011/8/24 Laruence<laruence@php.net>:
>>>
>>> Hi:
>>> =C2=A0 =C2=A0when linke mysql against mysqlnd,
>>>
>>> =C2=A0 =C2=A0call to mysql_pconnect after previous one timeout, =C2=A0c=
an trigger a
>>> warnning:
>>> =C2=A0 =C2=A0 =C2=A0 PHP Warning: =C2=A0mysql_pconnect(): MySQL server =
has gone away
>>>
>>> =C2=A0 =C2=A0while linked against libmysql will not generate this warni=
ng. =C2=A0so
>>> maybe this should be a BC ?
>>>
>>> =C2=A0 =C2=A0thanks
>>>
>>> =C2=A0 =C2=A0test script :
>>> =C2=A0 =C2=A0 =C2=A0<?php
>>> $plink =3D mysql_pconnect("127.0.0.1:3307", "root", "");
>>>
>>> mysql_query("set wait_timeout=3D1", $plink);
>>>
>>> sleep(3);
>>>
>>> $plink =3D mysql_pconnect("127.0.0.1:3307", "root", "");
>>>
>>>
>>>
>>>
>>> --
>>> Laruence =C2=A0Xinchen Hui
>>> http://www.laruence.com/
>>>
>>
>>
>>
>
>



--=20
Laruence =C2=A0Xinchen Hui
http://www.laruence.com/