From: brian dot sanders at cometsystems dot com
Operating system: Fedora Core 3
PHP version: 5.0.2
PHP Bug Type: MySQL related
Bug description: Database selection fails intermittently with pconnect
Description:
------------
I am having the following issue with pconnect on my development box:
environment:
I have an entry in my /etc/hosts file to point the hostname of a remote
MySQL server to localhost. This allows me to test the production setup,
while running both the application and database on my local machine.
testing:
I can connect as the application user via the mysql client to the local
database by either 'localhost' or by the remote name (which is looped back
to 'localhost.localdomain', as described above.) I can select the database
'use my_db' repeatedly without failure.
symtoms:
My PHP app uses mysql_pconnect() to connect to the remote database server
(again, which is looped back to 'localhost.localdomain'.) Intermittenly,
PHP connects to the server, but fails to select the database. Unlike bug
#24977, mysql_select_db() does return false (as it should.)
This issue seems to be tied to the persistant connections.
mysql_select_db() might fail 5-20 times, then work 5-20 times, then fail
again. Strangely enough, the app never fails to connect, but only to
select the database. If I change mysql_pconnect() to mysql_connect(), the
problem disappears. Also, if I change the app's configuration to connect
to localhost.localdomain (instead of the looped-back remote address) the
problem disappears.
So to sum up, using mysql_pconnect() to connect to a non-localhost
hostname on the local machine causes mysql_select_db to fail
intermittenly.
Here's the info on my box:
OS: Fedora Core 3
kernel: 2.6.10-1.741_FC3smp
MySQL server: 3.23.58
MySQL client: Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
Apache: 1.3.33 built from source
PHP: 5.0.2 built from source
Reproduce code:
---------------
/etc/hosts:
127.0.0.1 localhost.localdomain localhost
127.0.0.1 some.faroffserver.com
PHP app:
$db = mysql_pconnect('some.faroffserver.com', 'user', '');
if(!$db) {
die('Could not connect to database');
} else {
if(!mysql_select_db('my_db', $db)) {
die('Could not select database.');
}
}
Expected result:
----------------
Nothing (mysql_select_db() returns true)
Actual result:
--------------
Sometimes mysql_select_db() returns false.
--
Edit bug report at http://bugs.php.net/?id=31782&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31782&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=31782&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=31782&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=31782&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=31782&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=31782&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=31782&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=31782&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=31782&r=support
Expected behavior: http://bugs.php.net/fix.php?id=31782&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=31782&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=31782&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=31782&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31782&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=31782&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=31782&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=31782&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=31782&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=31782&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=31782&r=mysqlcfg
