Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/include/

View File Name : read_only_bug28438114.inc

#
# Test that $query correctly checks read_only flag even if this
# flag is set while the query is blocked waiting for protection
# global read lock. Used by test for bug#28438114 in read_only.test.
#

--enable_connect_log
connection default;
FLUSH TABLES WITH READ LOCK;

connection con1;
--echo # DDL statement will block waiting for GRL.
--send_eval $query

connection con2;
--echo # Wait until statement is blocked waiting for GRL.
let $wait_condition=
  SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST
  WHERE STATE = "Waiting for global read lock";
--source include/wait_condition.inc
SET GLOBAL READ_ONLY= 1;

connection default;
--echo # Unblock the DDL statement.
UNLOCK TABLES;

connection con1;
--echo # Without patch for BUG#28438114, the DDL statement will succeed even
--echo # though read only mode was set.
--error ER_OPTION_PREVENTS_STATEMENT
--reap

--echo # Clean up.
connection default;
SET GLOBAL READ_ONLY= 0;
--disable_connect_log