#33849 [NEW]: LOCK TABLES with mysql_query() works wrong

From: test157 at starman dot ee Operating system: Linux Fedora Core 4 PHP version: 4.4.0 PHP Bug Type: MySQL related Bug description: LOCK TABLES with mysql_query() works wrong Description: ------------ When I'am locking MySQL ISAM table from PHP env, all other threads still can use this table for READ/WRITE actions. But I didn't get from mysql_error() any message, and even cannot access other tables, untill they not locked too. So it's seems like PHP really thinks that MySQL locked. I think that this is problem of PHP because from MySQL console I can lock tables succesfuly, and after this lock even PHP cannot access this table. Reproduce code: --------------- mysql_pconnect("localhost","root",""); mysql_select_db("test_db"); mysql_query("LOCK TABLES test_table_1 WRITE"); mysql_query("INSERT INTO test_table_1 (a) VALUES (1)"); // returns OK mysql_query("INSERT INTO test_table_2 (a) VALUES (1)"); // Table was not locked with LOCK TABLES sleep(100); mysql_query("UNLOCK TABLES"); Expected result: ---------------- with this code I want to show you that all works fine, from side of thread what lock MySQL table. But really nothing is locked, during this 100 seconds I can edit/read test_table_1, without any problems from other threads. If I will even remove UNLOCK TABLES command and will use presistent connection, I will not hang up system. Because nothing is locked. Actual result: -------------- I tried it on PHP v 4.4.0/5.0.3/snapshots, CLI mode/Apache 2.0.54 compiled as worker/prefork, mysql v 4.1.12,13,14. And everywhere the same picture. I tried to compile PHP in different ways, from --disable-all + some only important keys, to full configs. Also tried to use budle MySQL libraries and what install on system. But all the same. Hope on your fast bug_fix. P.S: Also on this system I cannot flock(file) it all the same like with MySQL, no any error returned, but file no locked for other threads. (FS:ext2) -- Edit bug report at http://bugs.php.net/?id=33849&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33849&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=33849&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=33849&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=33849&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=33849&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=33849&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=33849&r=needscript Try newer version: http://bugs.php.net/fix.php?id=33849&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=33849&r=support Expected behavior: http://bugs.php.net/fix.php?id=33849&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=33849&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=33849&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=33849&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33849&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=33849&r=dst IIS Stability: http://bugs.php.net/fix.php?id=33849&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=33849&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=33849&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=33849&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=33849&r=mysqlcfg