[PHP-DEV] Bug #11993: mysql_close closes incorrect db handler
From: [EMAIL PROTECTED]
Operating system: Debian 2.19
PHP version: 4.0.4pl1
PHP Bug Type: MySQL related
Bug description: mysql_close closes incorrect db handler
debian 2.19 / mysql 3.23.37 / php 4.0.4pl1
configure section of phpinfo():
'./configure' '--with-gd' '--with-jpeg-dir' '--with-png-dir'
'--with-tiff-dir' '--disable-posix' '--enable-ftp' '--enable-calendar'
'--with-imap' '--with-mcrypt' '--with-swf=/usr/local/swf'
'--with-apache=/home/atiware/apache_1.3.14' '--enable-track-vars'
'--with-mysql=/usr/local'
the sript that reproduces the problem:
--cut here--
?php
define(DEEPLIMIT,10); //maximal deep of recursive calls
/*
!! please edit this settings !!
*/
define(MYHOST,localhost);
define(MYPORT,3306);
define(MYUSER,YOUR_USERNAME);
define(MYPWD,YOUR_PASSWORD);
/* this function reproduces the error */
function recursive($deep,$persistent=false) {
if ($deep=DEEPLIMIT) {
//down side
if ($persistent)
$db=mysql_pconnect(MYHOST.:.MYPORT,MYUSER,MYPWD);
//creating
persistent mysql connection and storing in a local variable
else
$db=mysql_connect(MYHOST.:.MYPORT,MYUSER,MYPWD);
//creating mysql
connection and storing in a local variable
$res=@mysql_query(select 1 as ONE,$db); //some dummy query
$mr=null;
if (@mysql_num_rows($res)) {
$mr=@mysql_fetch_array($res);
}
//and now write the result
printf(%sRecursive: Deep: %s, DownSideQuery:
%sbr\n,str_repeat(,$deep),$deep,(int)$mr[ONE]);
recursive($deep+1,$persistent);
//up side
$res=@mysql_query(select 1 as ONE,$db); //using previously
created
connection ($db), if exists ;)
$mr=null;
if (@mysql_num_rows($res)) {
$mr=@mysql_fetch_array($res);
}
//write result again
printf(%sRecursive: Deep: %s, UpSideQuery:
%s,str_repeat(,$deep),$deep,(int)$mr[ONE]);
//error check
if (!(int)$mr[ONE])
printf(nbsp;nbsp;b!?ERROR!? why 0?/b);
printf(br\n);
@mysql_close($db); //closing mysql connection
}
else {
printf(Limit occured (%s). Turning back...br\n,DEEPLIMIT);
}
}
echo Trying with bmysql_connect()/bbr\n;
recursive(1);
echo brbr\n\n;
echo Trying with bmysql_pconnect()/bbr\n;
recursive(1,true);
?
--cut here--
the output of the script:
Trying with mysql_connect()
Recursive: Deep: 1, DownSideQuery: 1
Recursive: Deep: 2, DownSideQuery: 1
Recursive: Deep: 3, DownSideQuery: 1
Recursive: Deep: 4, DownSideQuery: 1
Recursive: Deep: 5, DownSideQuery: 1
Recursive: Deep: 6, DownSideQuery: 1
Recursive: Deep: 7, DownSideQuery: 1
Recursive: Deep: 8, DownSideQuery: 1
Recursive: Deep: 9, DownSideQuery: 1
Recursive: Deep: 10, DownSideQuery: 1
Limit occured (10). Turning back...
Recursive: Deep: 10, UpSideQuery: 1
Recursive: Deep: 9, UpSideQuery: 1
Recursive: Deep: 8, UpSideQuery: 1
Recursive: Deep: 7, UpSideQuery: 1
Recursive: Deep: 6, UpSideQuery: 1
Recursive: Deep: 5, UpSideQuery: 0 !?ERROR!? why 0?
Recursive: Deep: 4, UpSideQuery: 0 !?ERROR!? why 0?
Recursive: Deep: 3, UpSideQuery: 0 !?ERROR!? why 0?
Recursive: Deep: 2, UpSideQuery: 0 !?ERROR!? why 0?
Recursive: Deep: 1, UpSideQuery: 0 !?ERROR!? why 0?
Trying with mysql_pconnect()
Recursive: Deep: 1, DownSideQuery: 1
Recursive: Deep: 2, DownSideQuery: 1
Recursive: Deep: 3, DownSideQuery: 1
Recursive: Deep: 4, DownSideQuery: 1
Recursive: Deep: 5, DownSideQuery: 1
Recursive: Deep: 6, DownSideQuery: 1
Recursive: Deep: 7, DownSideQuery: 1
Recursive: Deep: 8, DownSideQuery: 1
Recursive: Deep: 9, DownSideQuery: 1
Recursive: Deep: 10, DownSideQuery: 1
Limit occured (10). Turning back...
Recursive: Deep: 10, UpSideQuery: 1
Recursive: Deep: 9, UpSideQuery: 1
Recursive: Deep: 8, UpSideQuery: 1
Recursive: Deep: 7, UpSideQuery: 1
Recursive: Deep: 6, UpSideQuery: 1
Recursive: Deep: 5, UpSideQuery: 1
Recursive: Deep: 4, UpSideQuery: 1
Recursive: Deep: 3, UpSideQuery: 1
Recursive: Deep: 2, UpSideQuery: 1
Recursive: Deep: 1, UpSideQuery: 1
--
Edit bug report at: http://bugs.php.net/?id=11993edit=1
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact
[PHP-DEV] Bug #11993 Updated: mysql_close closes incorrect db handler
ID: 11993
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MySQL related
Operating System: Debian 2.19
Old PHP Version: 4.0.4pl1
PHP Version: 4.0.6
New Comment:
i have tried out with the following configurations:
server1: php-4.0.6/mysql.3.23.32/apache-1.3.20/debian 2.19
server2: php-4.0.6/mysql.3.23.37/apache-1.3.20/debian 2.19
the result is the same as with php-4.0.4pl1
please check this...
thanks
ati
Previous Comments:
[2001-07-09 19:22:19] [EMAIL PROTECTED]
debian 2.19 / mysql 3.23.37 / php 4.0.4pl1
configure section of phpinfo():
'./configure' '--with-gd' '--with-jpeg-dir' '--with-png-dir' '--with-tiff-dir'
'--disable-posix' '--enable-ftp' '--enable-calendar' '--with-imap' '--with-mcrypt'
'--with-swf=/usr/local/swf' '--with-apache=/home/atiware/apache_1.3.14'
'--enable-track-vars' '--with-mysql=/usr/local'
the sript that reproduces the problem:
--cut here--
?php
define(DEEPLIMIT,10); //maximal deep of recursive calls
/*
!! please edit this settings !!
*/
define(MYHOST,localhost);
define(MYPORT,3306);
define(MYUSER,YOUR_USERNAME);
define(MYPWD,YOUR_PASSWORD);
/* this function reproduces the error */
function recursive($deep,$persistent=false) {
if ($deep=DEEPLIMIT) {
//down side
if ($persistent)
$db=mysql_pconnect(MYHOST.:.MYPORT,MYUSER,MYPWD);
//creating persistent mysql connection and storing in a local variable
else
$db=mysql_connect(MYHOST.:.MYPORT,MYUSER,MYPWD);
//creating mysql connection and storing in a local variable
$res=@mysql_query(select 1 as ONE,$db); //some dummy query
$mr=null;
if (@mysql_num_rows($res)) {
$mr=@mysql_fetch_array($res);
}
//and now write the result
printf(%sRecursive: Deep: %s, DownSideQuery:
%sbr\n,str_repeat(,$deep),$deep,(int)$mr[ONE]);
recursive($deep+1,$persistent);
//up side
$res=@mysql_query(select 1 as ONE,$db); //using previously
created connection ($db), if exists ;)
$mr=null;
if (@mysql_num_rows($res)) {
$mr=@mysql_fetch_array($res);
}
//write result again
printf(%sRecursive: Deep: %s, UpSideQuery:
%s,str_repeat(,$deep),$deep,(int)$mr[ONE]);
//error check
if (!(int)$mr[ONE])
printf(nbsp;nbsp;b!?ERROR!? why 0?/b);
printf(br\n);
@mysql_close($db); //closing mysql connection
}
else {
printf(Limit occured (%s). Turning back...br\n,DEEPLIMIT);
}
}
echo Trying with bmysql_connect()/bbr\n;
recursive(1);
echo brbr\n\n;
echo Trying with bmysql_pconnect()/bbr\n;
recursive(1,true);
?
--cut here--
the output of the script:
Trying with mysql_connect()
Recursive: Deep: 1, DownSideQuery: 1
Recursive: Deep: 2, DownSideQuery: 1
Recursive: Deep: 3, DownSideQuery: 1
Recursive: Deep: 4, DownSideQuery: 1
Recursive: Deep: 5, DownSideQuery: 1
Recursive: Deep: 6, DownSideQuery: 1
Recursive: Deep: 7, DownSideQuery: 1
Recursive: Deep: 8, DownSideQuery: 1
Recursive: Deep: 9, DownSideQuery: 1
Recursive: Deep: 10, DownSideQuery: 1
Limit occured (10). Turning back...
Recursive: Deep: 10, UpSideQuery: 1
Recursive: Deep: 9, UpSideQuery: 1
Recursive: Deep: 8, UpSideQuery: 1
Recursive: Deep: 7, UpSideQuery: 1
Recursive: Deep: 6, UpSideQuery: 1
Recursive: Deep: 5, UpSideQuery: 0 !?ERROR!? why 0?
Recursive: Deep: 4, UpSideQuery: 0 !?ERROR!? why 0?
Recursive: Deep: 3, UpSideQuery: 0 !?ERROR!? why 0?
Recursive: Deep: 2, UpSideQuery: 0 !?ERROR!? why 0?
Recursive: Deep: 1, UpSideQuery: 0 !?ERROR!? why 0?
Trying with mysql_pconnect()
Recursive: Deep: 1, DownSideQuery: 1
Recursive: Deep: 2, DownSideQuery: 1
Recursive: Deep: 3, DownSideQuery: 1
Recursive: Deep: 4, DownSideQuery: 1
Recursive: Deep: 5, DownSideQuery: 1
Recursive: Deep: 6, DownSideQuery: 1
Recursive: Deep: 7, DownSideQuery: 1
Recursive: Deep: 8, DownSideQuery: 1
Recursive: Deep: 9, DownSideQuery: 1
Recursive: Deep: 10, DownSideQuery: 1
Limit occured (10). Turning back...
Recursive: Deep: 10, UpSideQuery: 1
Recursive: Deep: 9, UpSideQuery: 1
Recursive: Deep: 8, UpSideQuery: 1
Recursive: Deep: 7, UpSideQuery: 1
Recursive: Deep: 6
[PHP-DEV] Bug #11993 Updated: mysql_close closes incorrect db handler
ID: 11993
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Old Status: Closed
Status: Open
Bug Type: MySQL related
Operating System: Debian 2.19
Old PHP Version: 4.0.6
PHP Version: 4.1.0
New Comment:
sorry, i can not try with php4.1.0RC3. I tried out with the latest php4.1.0, and no
changes, the problem still exists.
ati
Previous Comments:
[2001-12-13 06:26:24] [EMAIL PROTECTED]
No feedback. Closing.
[2001-11-20 19:55:37] [EMAIL PROTECTED]
Can you try if the problem still persists with latest RC
http://www.php.net/~zeev/php-4.1.0RC3.tar.gz
Feedback.
[2001-10-24 00:59:24] [EMAIL PROTECTED]
missing status
[2001-07-11 13:58:35] [EMAIL PROTECTED]
hi zak,
thanks for your answer.
in my opinion, php must have some matrix, where you stores the number of connect and
close calls with the connection id. this will probably solve the problem.
ps: i use these multiple connections in oop environment, where a global connection id,
is not the best idea. or?
ati
[2001-07-11 06:58:00] [EMAIL PROTECTED]
Here is a refinement on this bug:
Multiple duplicate calls to mysql_connect are supposed to return the same link ID.
Each call after the first call will only return the link ID of the first (if
everything goes as planned, the connection is still good, etc...).
i.e.
var_dump (mysql_connect() === mysql_connect());
Given this behavior, how should mysql_close() behave?
I would expect that calling mysql_close ($id) would close the connection that both $id
and $id2 refer to.
Behavior is not this - instead it is quite odd...
Multiple calls to mysql_close are required to close multiple duplicate calls to
mysql_connect.
i.e.
var_dump ($db = mysql_connect ());
var_dump ($db = mysql_connect ());
var_dump (mysql_close ($db));
// Maybe this closes the default connection?
var_dump (mysql_close ($db));
However, if more than two calls to mysql_connect are made, followed by a corresponding
number of calls to mysql_close, the mysql_close calls start to fail.
i.e.
$max = 10;
for ($x=0; $x$max; ++$x) {
var_dump ($db = mysql_connect());
}
for ($x=0; $x$max; ++$x) {
var_dump (mysql_close ($db));
}
Now, throw change the call to mysql_close($db) to mysql_close() - everything seems to
work as expected.
However as soon as you add a call to mysql_query after the call to mysql_close, the
link will *never* die - no matter how many times you close it.
Finally, put a call to mysql_close ($db) between the two loops. The next call to
mysql_close() will fail with an error, while subsequent calls will succeed - once
again, the link will never die.
Things get even stranger when this behavior is encountered within recursive function
calls - however, I guess that this is a side effect of the behavior described above.
It looks like there is some complex/odd interactions happening with the code that
closes mysql links and the code that sets and uses the default link -- however, this
is quite far over my head!
Anyone else have any ideas? :)
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/?id=11993
Edit this bug report at http://bugs.php.net/?id=11993edit=1
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
