# [BC]mysql_pconnect generate warning when link against mysqlnd

- Thread: https://externals.io/message/54840
- Original archive: https://news-web.php.net/php.internals/54840
- Started by Laruence on 2011-08-24T07:30:34+00:00
- Messages: 4
- Reply by email to internals@lists.php.net
- More for agents: search with https://externals.io/search.md?q={query} · JSON API at https://externals.io/api · documentation at https://externals.io/llms.txt

---

## #54840 — Laruence — 2011-08-24T07:30:34+00:00

URL: https://externals.io/message/54840#54840

Hi:
    when linke mysql against mysqlnd,

    call to mysql_pconnect after previous one timeout,  can trigger a warnning:
       PHP Warning:  mysql_pconnect(): MySQL server has gone away

    while linked against libmysql will not generate this warning.  so
maybe this should be a BC ?

    thanks

    test script :
      <?php
$plink = mysql_pconnect("127.0.0.1:3307", "root", "");

mysql_query("set wait_timeout=1", $plink);

sleep(3);

$plink = mysql_pconnect("127.0.0.1:3307", "root", "");




-- 
Laruence  Xinchen Hui
http://www.laruence.com/

---

## #54842 — Laruence — 2011-08-24T07:35:55+00:00

URL: https://externals.io/message/54840#54842 · In reply to: #54840

And the same warnings will be throw while call mysql_ping too.

$plink = 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:
>    when linke mysql against mysqlnd,
>
>    call to mysql_pconnect after previous one timeout,  can trigger a warnning:
>       PHP Warning:  mysql_pconnect(): MySQL server has gone away
>
>    while linked against libmysql will not generate this warning.  so
> maybe this should be a BC ?
>
>    thanks
>
>    test script :
>      <?php
> $plink = mysql_pconnect("127.0.0.1:3307", "root", "");
>
> mysql_query("set wait_timeout=1", $plink);
>
> sleep(3);
>
> $plink = mysql_pconnect("127.0.0.1:3307", "root", "");
>
>
>
>
> --
> Laruence  Xinchen Hui
> http://www.laruence.com/
>



-- 
Laruence  Xinchen Hui
http://www.laruence.com/

---

## #54847 — Andrey Hristov — 2011-08-24T08:26:28+00:00

URL: https://externals.io/message/54840#54847 · In reply to: #54842

Hi,
in my opinion a warning in this case is better than no warning. Because 
this shows a problem and even if display_warnings is off the warnings 
can be logged for further inspection.

Best,
Andrey


> And the same warnings will be throw while call mysql_ping too.
>
> $plink = 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>:
> > […]

---

## #54850 — Laruence — 2011-08-24T08:47:24+00:00

URL: https://externals.io/message/54840#54850 · In reply to: #54847

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>:
>  Hi,
> in my opinion a warning in this case is better than no warning. Because this
> shows a problem and even if display_warnings is off the warnings can be
> logged for further inspection.
>
> Best,
> Andrey
>
> 
> > […]
>
>



-- 
Laruence  Xinchen Hui
http://www.laruence.com/