ID: 7634 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Closed Bug Type: Documentation problem Operating System: Mandrake 7.0 PHP Version: 4.0 Latest CVS (03/11/2000) New Comment:
My dear, it's already documented in the "Persistent Database" section ... sorry :-p Previous Comments: ------------------------------------------------------------------------ [2002-06-10 04:08:04] [EMAIL PROTECTED] What is 'closing as doc problem' ? :) Reopening until it's really fixed. ------------------------------------------------------------------------ [2001-11-20 22:05:29] [EMAIL PROTECTED] Closed as a Doc problem; added a warning in CVS about the issue. Also included some info regarding transactions behaving similarly from the user notes. ------------------------------------------------------------------------ [2001-11-20 20:10:51] [EMAIL PROTECTED] Nope, still happens. This is on Debian woody, PHP 4.1.0RC3 (haven't tried on the win32 version you posted a link to, but whatever). Same script. ------------------------------------------------------------------------ [2001-11-20 19:46:00] [EMAIL PROTECTED] Can you try latest RC and see if the problem persists http://phpuk.org/~james/php-4.1.0RC3-win32.zip Feedback. ------------------------------------------------------------------------ [2000-11-03 21:08:24] [EMAIL PROTECTED] I've heard about this from a couple of sources and been looking for answers, but haven't found anything definitive. I don't even know if it's solvable. However, when using persistent connections and LOCK TABLES, if for any reason the UNLOCK TABLES never gets executed, the server ends up hanging while it waits for the lock to get released. This is reproduceable for me on every version of PHP I've tried. Example script: <?php /* -*- mode: c++; minor-mode: font -*- */ error_reporting(E_ALL); $dbh = mysql_pconnect($host, $user, $pass); /* Just to test the connection. */ if ($res = mysql_db_query($db, 'show tables', $dbh)) { while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) { echo $row["Tables_in_$db"] . "<br>\n"; } } echo "<hr>\n"; $table = 'category'; echo "Locking table '$table' (if the script blocks here, then the lock never got released)...<br>\n"; flush(); if ($res = mysql_db_query('chaps', "lock tables $table write", $dbh)) { echo "OK; locked.<br>\n"; } else { echo "failed; could not lock.<br>\n"; } flush(); //$res = mysql_db_query('chaps', "unlock tables", $dbh) ?> Is this just me? ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=7634&edit=1
