Server IP : 172.67.216.182 / Your IP : 162.158.108.91 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/innodb/t/ |
Upload File : |
-- source include/have_innodb.inc # # Check and select innodb lock type # set global innodb_table_locks=1; select @@innodb_table_locks; # # Testing of explicit table locks with enforced table locks # connect (con1,localhost,root,,); connect (con2,localhost,root,,); --disable_warnings drop table if exists t1; --enable_warnings # # Testing of explicit table locks with enforced table locks # set @@innodb_table_locks=1; connection con1; create table t1 (id integer, x integer) engine=INNODB; insert into t1 values(0, 0); set autocommit=0; SELECT * from t1 where id = 0 FOR UPDATE; connection con2; set autocommit=0; # The following statement should hang because con1 is locking the page --send lock table t1 write; --sleep 2 connection con1; update t1 set x=1 where id = 0; select * from t1; commit; connection con2; reap; update t1 set x=2 where id = 0; commit; unlock tables; connection con1; select * from t1; commit; drop table t1; --echo # --echo # Old lock method (where LOCK TABLE was ignored by InnoDB) no longer --echo # works when LOCK TABLE ... WRITE is used due to fix for bugs #46272 --echo # "MySQL 5.4.4, new MDL: unnecessary and bug #37346 "innodb does not --echo # detect deadlock between update and alter table". --echo # After WL#6671 "Improve scalability by not using thr_lock.c locks --echo # for InnoDB tables" was implemented it no longer works for LOCK TABLES --echo # ,,, READ as well. --echo # LOCK TABLES locks are now completely handled by MDL subsystem. --echo # set @@innodb_table_locks=0; create table t1 (id integer primary key, x integer) engine=INNODB; insert into t1 values(0, 0),(1,1),(2,2); commit; SELECT * from t1 where id = 0 FOR UPDATE; --echo # Connection 'con2'. connection con2; set autocommit=0; set @@innodb_table_locks=0; --echo # The following statement should block because SQL-level lock --echo # is taken on t1 which will wait until concurrent transaction --echo # is commited. --echo # Sending: --send lock table t1 write; --echo # Connection 'con1'. connection con1; --echo # Wait until LOCK TABLE is blocked on SQL-level lock. let $wait_condition= select count(*) = 1 from information_schema.processlist where state = "Waiting for table metadata lock" and info = "lock table t1 write"; --source include/wait_condition.inc --echo # We should be able to do UPDATEs and SELECTs within transaction. update t1 set x=1 where id = 0; select * from t1; --echo # Unblock LOCK TABLE. commit; --echo # Connection 'con2'. connection con2; --echo # Reap LOCK TABLE. --reap unlock tables; --echo # Connection 'con1'. connection con1; select * from t1 where id = 0 for update; --echo # Connection 'con2'. connection con2; --echo # The following statement should block because SQL-level lock --echo # is taken on t1 which will wait until concurrent transaction --echo # is commited. --echo # Sending: --send lock table t1 read; --echo # Connection 'con1'. connection con1; --echo # Wait until LOCK TABLE is blocked on SQL-level lock. let $wait_condition= select count(*) = 1 from information_schema.processlist where state = "Waiting for table metadata lock" and info = "lock table t1 read"; --source include/wait_condition.inc --echo # We should be able to do UPDATEs and SELECTs within transaction. update t1 set x=2 where id = 0; select * from t1; --echo # Unblock LOCK TABLE. commit; --echo # Connection 'con2'. connection con2; --echo # Reap LOCK TABLE. --reap unlock tables; --echo # Connection 'default'. connection default; drop table t1; # End of 4.1 tests --echo # --echo #Bug#12842206 INNODB LOCKING REGRESSION FOR INSERT IGNORE --echo #fixed by re-fixing Bug#7975 --echo #aka Bug#11759688 52020: InnoDB can still deadlock on just INSERT... --echo # connection default; CREATE TABLE t1 (a INT PRIMARY KEY, b INT NOT NULL) ENGINE=InnoDB; INSERT INTO t1 VALUES(3,1); BEGIN; # this used to wrongly acquire an X lock; now it takes an S lock INSERT IGNORE INTO t1 VALUES(3,14); connection con1; BEGIN; # this used to wrongly acquire an X lock; now it takes an S lock INSERT IGNORE INTO t1 VALUES(3,23); --send SELECT * FROM t1 FOR UPDATE; connection con2; # Check that the above SELECT is blocked let $wait_condition= select count(*) = 1 from information_schema.processlist where state = 'Sending data' and info = 'SELECT * FROM t1 FOR UPDATE'; --source include/wait_condition.inc connection default; COMMIT; connection con1; reap; COMMIT; disconnect con1; disconnect con2; connection default; DROP TABLE t1; --echo Bug#19803418 ASSERTION: TABLE->QUIESCE == QUIESCE_NONE --echo IN ROW0QUIESCE.CC LINE 683 CREATE TABLE t1(C TEXT CHARACTER SET UJIS) ENGINE=INNODB; LOCK TABLES t1 WRITE,t1 AS t0 READ,t1 AS t2 READ; FLUSH TABLE t1; LOCK TABLES t1 READ,t1 AS t0 WRITE,t1 AS t2 READ; FLUSH TABLE t1; LOCK TABLES t1 READ,t1 AS t0 READ,t1 AS t2 READ; --error ER_TABLE_NOT_LOCKED_FOR_WRITE FLUSH TABLE t1; UNLOCK TABLES; FLUSH TABLE t1; DROP TABLE t1;