From: abrahamkou at sbcglobal dot net Operating system: Windows 2003 PHP version: 4.3.3 PHP Bug Type: MySQL related Bug description: Mysql_pconnect() issues
Description: ------------ mysql_pconnect sometimes ignores the open connection and starts a new connection -- but if you refresh the page again, it will re-use the old connection again. I am using temporary tables with a form with an action to $PHP_SELF with mutiple steps (meaning the form refreshes itself over and over and displays different fields) that stores interim data into a temporary table. I noticed about once out of every 5 page loads i'll get a message staying Table (tmeporary_table_name) does not exist. However, if I refresh it, it will come back. I looiked at the mysql_thread_id(); and it changes when it says the table does not exist, but changes back to the previous threadid when i refresh the page and repost form data. Reproduce code: --------------- The form is at: http://cia.dyns.cx/add_user.php Expected result: ---------------- No error messages, and the same connection and same temporary table is used over and over again. Actual result: -------------- as you fill out the form, after you click 'next' a few times it will say "table t_23453294598329 does not exist" (the tablename will be different of corse). but if you refresh the page and repost form data, it will work again. It means that pconnect is creating a new connection despite an old one being opened already; so the temporary table is not accessible to the new connection. -- Edit bug report at http://bugs.php.net/?id=25368&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=25368&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=25368&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=25368&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=25368&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=25368&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=25368&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=25368&r=support Expected behavior: http://bugs.php.net/fix.php?id=25368&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=25368&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=25368&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=25368&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=25368&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=25368&r=dst IIS Stability: http://bugs.php.net/fix.php?id=25368&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=25368&r=gnused
