Test: /ext/mysql/tests/bug55473.phpt - Version 5.5.19        

Bug #55473 mysql_pconnect leaks file descriptors on reconnect
Submitted: 2011-08-21 10:52:44 Modified: 2011-08-22 10:57:44
From: littlesavage Assigned: andrey
Status: Closed Package: MySQL related
PHP Version: 5.3.7 OS:

There are 6 different diffs reported by users for this test.

Count Diff
22 (76%)
002-
003- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
006+ [003] reconnect 1
008+ Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s/bug55473.php on line 13
009+ [007] Opened files as expected
010+ [003] reconnect 2
011+
012+ Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s/bug55473.php on line 13
013+ [007] Opened files as expected
014+ [003] reconnect 3
009- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
010- [003] reconnect 1
014-
018+ done!
015- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
016- [003] reconnect 2
017-
018- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
019- [007] Opened files as expected
020-
021- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
022- [003] reconnect 3
023-
024- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
025- [007] Opened files as expected
026- done!
3 (10%)
002-
003- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
005+ lsof: WARNING: can't stat() fuse file system /root/.cache/doc
006+ Output information may be incomplete.
008-
009- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
011+ lsof: WARNING: can't stat() fuse file system /root/.cache/doc
012+ Output information may be incomplete.
014-
015- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
017+ lsof: WARNING: can't stat() fuse file system /root/.cache/doc
018+ Output information may be incomplete.
020-
021- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
023+ lsof: WARNING: can't stat() fuse file system /root/.cache/doc
024+ Output information may be incomplete.
1 (3%)
002-
003- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
005+ lsof: WARNING: can't stat() fuse.gvfsd-fuse file system /run/user/1000/gvfs
006+ Output information may be incomplete.
008-
009- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
011+ lsof: WARNING: can't stat() fuse.gvfsd-fuse file system /run/user/1000/gvfs
012+ Output information may be incomplete.
014-
015- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
017+ lsof: WARNING: can't stat() fuse.gvfsd-fuse file system /run/user/1000/gvfs
018+ Output information may be incomplete.
020-
021- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
023+ lsof: WARNING: can't stat() fuse.gvfsd-fuse file system /run/user/1000/gvfs
024+ Output information may be incomplete.
1 (3%)
002-
003- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
004- [003] reconnect 0
005-
006- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
003+ [007] Opened files as expected
004+ [007] Opened files as expected
006+ done!
008-
009- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
010- [003] reconnect 1
011-
012- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
014-
015- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
016- [003] reconnect 2
017-
018- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
019- [007] Opened files as expected
020-
021- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
022- [003] reconnect 3
023-
024- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
025- [007] Opened files as expected
026- done!
1 (3%)
002+ lsof: WARNING: can't stat() fuse.gvfs-fuse-daemon file system /root/.gvfs
003+ Output information may be incomplete.
002-
003- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
004- [003] reconnect 0
005-
006- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
005+ lsof: WARNING: can't stat() fuse.gvfs-fuse-daemon file system /root/.gvfs
006+ Output information may be incomplete.
007+ [007] Opened files as expected
008+ lsof: WARNING: can't stat() fuse.gvfs-fuse-daemon file system /root/.gvfs
009+ Output information may be incomplete.
010+ [007] Opened files as expected
011+ lsof: WARNING: can't stat() fuse.gvfs-fuse-daemon file system /root/.gvfs
012+ Output information may be incomplete.
008-
009- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
010- [003] reconnect 1
011-
012- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
014+ done!
014-
015- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
016- [003] reconnect 2
017-
018- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
019- [007] Opened files as expected
020-
021- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
022- [003] reconnect 3
023-
024- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
025- [007] Opened files as expected
026- done!
1 (3%)
002+ [003] reconnect 0
003- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
004- [003] reconnect 0
004+ Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s/bug55473.php on line 13
005+ lsof: WARNING: compiled for FreeBSD release 10.0-RELEASE-p7; this is 10.0-RELEASE-p12.
006+ [005] Setting openened files...
007+ [003] reconnect 1
008+
009+ Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s/bug55473.php on line 13
010+ lsof: WARNING: compiled for FreeBSD release 10.0-RELEASE-p7; this is 10.0-RELEASE-p12.
011+ [007] Opened files as expected
012+ [003] reconnect 2
013+
014+ Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s/bug55473.php on line 13
015+ lsof: WARNING: compiled for FreeBSD release 10.0-RELEASE-p7; this is 10.0-RELEASE-p12.
016+ [007] Opened files as expected
017+ [003] reconnect 3
007- [005] Setting openened files...
008-
009- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
010- [003] reconnect 1
011-
012- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
014-
020+ lsof: WARNING: compiled for FreeBSD release 10.0-RELEASE-p7; this is 10.0-RELEASE-p12.
022+ done!
015- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
016- [003] reconnect 2
017-
018- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
019- [007] Opened files as expected
020-
021- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
022- [003] reconnect 3
023-
024- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
025- [007] Opened files as expected
026- done!