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

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 3 different diffs reported by users for this test.

Count Diff
7 (78%)
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!
1 (11%)
1 (11%)
002-
003- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
005+ lsof: WARNING: can't stat() ext4 file system /var/lib/docker/devicemapper
006+ Output information may be incomplete.
007+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named
008+ Output information may be incomplete.
009+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/var/named
010+ Output information may be incomplete.
011+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.conf
012+ Output information may be incomplete.
013+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.rfc1912.zones
014+ Output information may be incomplete.
015+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/rndc.key
016+ Output information may be incomplete.
017+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/usr/lib64/bind
018+ Output information may be incomplete.
019+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.iscdlv.key
020+ Output information may be incomplete.
021+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.root.key
022+ Output information may be incomplete.
023+ [005] Setting openened files...
024+ [003] reconnect 1
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
013- [007] Opened files as expected
014-
015- Warning: mysql_ping(): MySQL server has gone away in %s on line %d
016- [003] reconnect 2
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!
027+ lsof: WARNING: can't stat() ext4 file system /var/lib/docker/devicemapper
028+ Output information may be incomplete.
029+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named
030+ Output information may be incomplete.
031+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/var/named
032+ Output information may be incomplete.
033+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.conf
034+ Output information may be incomplete.
035+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.rfc1912.zones
036+ Output information may be incomplete.
037+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/rndc.key
038+ Output information may be incomplete.
039+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/usr/lib64/bind
040+ Output information may be incomplete.
041+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.iscdlv.key
042+ Output information may be incomplete.
043+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.root.key
044+ Output information may be incomplete.
045+ [007] Opened files as expected
046+ [003] reconnect 2
047+
048+ 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
049+ lsof: WARNING: can't stat() ext4 file system /var/lib/docker/devicemapper
050+ Output information may be incomplete.
051+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named
052+ Output information may be incomplete.
053+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/var/named
054+ Output information may be incomplete.
055+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.conf
056+ Output information may be incomplete.
057+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.rfc1912.zones
058+ Output information may be incomplete.
059+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/rndc.key
060+ Output information may be incomplete.
061+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/usr/lib64/bind
062+ Output information may be incomplete.
063+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.iscdlv.key
064+ Output information may be incomplete.
065+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.root.key
066+ Output information may be incomplete.
067+ [007] Opened files as expected
068+ [003] reconnect 3
069+
070+ 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
071+ lsof: WARNING: can't stat() ext4 file system /var/lib/docker/devicemapper
072+ Output information may be incomplete.
073+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named
074+ Output information may be incomplete.
075+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/var/named
076+ Output information may be incomplete.
077+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.conf
078+ Output information may be incomplete.
079+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.rfc1912.zones
080+ Output information may be incomplete.
081+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/rndc.key
082+ Output information may be incomplete.
083+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/usr/lib64/bind
084+ Output information may be incomplete.
085+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.iscdlv.key
086+ Output information may be incomplete.
087+ lsof: WARNING: can't stat() ext4 file system /var/named/chroot/etc/named.root.key
088+ Output information may be incomplete.
089+ [007] Opened files as expected
090+ done!