mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
ff5d306e29
SHOW ENGINE INNODB MUTEX functionality is completely removed, as are the InnoDB latching order checks. We will enforce innodb_fatal_semaphore_wait_threshold only for dict_sys.mutex and lock_sys.mutex. dict_sys_t::mutex_lock(): A single entry point for dict_sys.mutex. lock_sys_t::mutex_lock(): A single entry point for lock_sys.mutex. FIXME: srv_sys should be removed altogether; it is duplicating tpool functionality. fil_crypt_threads_init(): To prevent SAFE_MUTEX warnings, we must not hold fil_system.mutex. fil_close_all_files(): To prevent SAFE_MUTEX warnings for fil_space_destroy_crypt_data(), we must not hold fil_system.mutex while invoking fil_space_free_low() on a detached tablespace.
44 lines
1.1 KiB
Text
44 lines
1.1 KiB
Text
--source include/have_innodb.inc
|
|
#
|
|
# http://bugs.mysql.com/53046
|
|
# dict_update_statistics_low can still be run concurrently on same table
|
|
#
|
|
# This is a symbolic test, it would not fail if the bug is present.
|
|
#
|
|
|
|
CREATE TABLE bug53046_1 (c1 INT PRIMARY KEY) ENGINE=INNODB;
|
|
CREATE TABLE bug53046_2 (c2 INT PRIMARY KEY,
|
|
FOREIGN KEY (c2) REFERENCES bug53046_1(c1)
|
|
ON UPDATE CASCADE ON DELETE CASCADE) ENGINE=INNODB;
|
|
|
|
INSERT INTO bug53046_1 VALUES (1);
|
|
let $i = 5;
|
|
while ($i) {
|
|
eval INSERT INTO bug53046_1 SELECT c1+(SELECT MAX(c1) FROM bug53046_1)
|
|
FROM bug53046_1;
|
|
dec $i;
|
|
}
|
|
|
|
INSERT INTO bug53046_2 VALUES (1), (2);
|
|
|
|
# CREATE TABLE innodb_table_monitor (a int) ENGINE=INNODB;
|
|
# wait more than 1 minute and observe the mysqld output
|
|
# DROP TABLE innodb_table_monitor;
|
|
|
|
ANALYZE TABLE bug53046_1;
|
|
|
|
# this prints create time and other nondeterministic data
|
|
-- disable_result_log
|
|
SHOW TABLE STATUS LIKE 'bug53046_1';
|
|
-- enable_result_log
|
|
|
|
UPDATE bug53046_1 SET c1 = c1 - 1;
|
|
|
|
DELETE FROM bug53046_1;
|
|
|
|
INSERT INTO bug53046_1 VALUES (1);
|
|
INSERT INTO bug53046_2 VALUES (1);
|
|
TRUNCATE TABLE bug53046_2;
|
|
|
|
DROP TABLE bug53046_2;
|
|
DROP TABLE bug53046_1;
|