Bug #11993 Updated: mysql_close closes incorrect db handler

ID: 11993 User updated by: atiware@metasuccess.net Reported By: atiware@metasuccess.net 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] atiware@metasuccess.net 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: %s<br>\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 <b>mysql_connect()</b><br>\n"; recursive(1); echo "<br><br>\n\n"; echo "Trying with <b>mysql_pconnect()</b><br>\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 ------------------------------------------------------------------------ ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=11993&edit=1