mariadb/include/mysql
Aleksey Midenkov 96d75d0392 MDEV-29474 main.lock_sync fails with timeout
There was race condition in MDEV-28567 test case where
"DROP TRIGGER tr1" was too slow to acquire test/t1 (MDL_SHARED_NO_WRITE).
"INSERT INTO t2 SELECT * FROM t2" acquired it and since there is
autocommit=off it was held forever:

T@46   : dispatch_command: query: INSERT INTO t2 SELECT * FROM t2
T@46   : MDL_context::acquire_lock: mdl: Seized:   test/t2 (MDL_SHARED_WRITE)
T@46   : MDL_context::acquire_lock: mdl: Seized:   test/t2 (MDL_SHARED_WRITE)
T@46   : MDL_context::acquire_lock: mdl: Seized:   test/t1 (MDL_SHARED_WRITE)
T@48   : dispatch_command: query: DROP TRIGGER tr1
T@48   : MDL_context::acquire_lock: mdl: Seized:   test/tr1 (MDL_EXCLUSIVE)
T@48   : MDL_context::acquire_lock: mdl: Waiting:  test/t1 (MDL_SHARED_NO_WRITE)

To avoid this case the patch adds MDL type + table name sync point, so
INSERT starts only after DROP TRIGGER seized MDL_SHARED_NO_WRITE for t1.
2025-06-03 11:25:19 +03:00
..
psi Merge branch '10.5' into 10.6 2025-01-29 11:17:38 +01:00
auth_dialog_client.h Update FSF address 2019-05-10 20:52:00 +03:00
client_plugin.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
client_plugin.h.pp MDEV-8052 abi detection incorrect with clang 2015-06-03 09:54:56 +02:00
plugin.h Merge branch '10.6' into 10.11 2025-01-30 11:55:13 +01:00
plugin_audit.h MDEV-7389 Request: log warnings into SQL_ERROR_LOG 2023-05-24 13:21:55 +03:00
plugin_audit.h.pp Merge branch '10.5' into 10.6 2025-01-29 11:17:38 +01:00
plugin_auth.h MDEV-27341 Use SET PASSWORD to change PAM service 2022-01-17 18:19:29 +01:00
plugin_auth.h.pp Merge branch '10.5' into 10.6 2025-01-29 11:17:38 +01:00
plugin_auth_common.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
plugin_data_type.h cleanup: data type plugins 2019-10-31 11:19:39 +01:00
plugin_data_type.h.pp Merge branch '10.5' into 10.6 2025-01-29 11:17:38 +01:00
plugin_encryption.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
plugin_encryption.h.pp Merge branch '10.5' into 10.6 2025-01-29 11:17:38 +01:00
plugin_ftparser.h header typos 2022-12-20 08:55:48 +11:00
plugin_ftparser.h.pp Merge branch '10.5' into 10.6 2025-01-29 11:17:38 +01:00
plugin_function.h Part1: MDEV-20837 Add MariaDB_FUNCTION_PLUGIN 2019-10-16 21:40:30 +04:00
plugin_function.h.pp Merge branch '10.5' into 10.6 2025-01-29 11:17:38 +01:00
plugin_password_validation.h Pre requiste MDEV-9245: add host to validate password interface 2021-10-19 17:35:06 +02:00
plugin_password_validation.h.pp Merge branch '10.6' into 10.11 2025-01-30 11:55:13 +01:00
service_base64.h header typos 2022-12-20 08:55:48 +11:00
service_debug_sync.h MDEV-29474 main.lock_sync fails with timeout 2025-06-03 11:25:19 +03:00
service_encryption.h post fix for "move alloca() definition from all *.h files to one new header file" 2023-03-08 17:36:36 +01:00
service_encryption_scheme.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
service_json.h Improve documentation of json parser functions 2021-07-22 21:51:49 +03:00
service_kill_statement.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
service_log_warnings.h Only print "InnoDB: Transaction was aborted..." if log_warnings >= 4 2025-01-05 16:40:12 +02:00
service_logger.h Merge branch '5.5' into 10.1 2019-05-11 19:15:57 +03:00
service_md5.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
service_my_crypt.h post-merge fix 2023-09-13 12:10:43 +02:00
service_my_print_error.h remove incorrect #ifdef 2019-08-26 23:33:42 +02:00
service_my_snprintf.h header typos 2022-12-20 08:55:48 +11:00
service_print_check_msg.h MDEV-33277 In-place upgrade causes invalid AUTO_INCREMENT values 2024-02-08 10:35:45 +02:00
service_progress_report.h Merge branch '5.5' into 10.1 2019-05-11 19:15:57 +03:00
service_sha1.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
service_sha2.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
service_sql.h more C API methods in the service_sql 2025-01-28 19:31:29 +01:00
service_thd_alloc.h Merge 10.2 into 10.3 2019-05-14 17:18:46 +03:00
service_thd_autoinc.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
service_thd_error_context.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
service_thd_mdl.h MDEV-16678 Prefer MDL to dict_sys.latch for innodb background tasks 2019-12-10 15:42:50 +02:00
service_thd_rnd.h Merge 10.2 into 10.3 2019-05-14 17:18:46 +03:00
service_thd_specifics.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
service_thd_timezone.h header typos 2022-12-20 08:55:48 +11:00
service_thd_wait.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
service_wsrep.h MDEV-34836: TOI on parent table must BF abort SR in progress on a child 2024-09-24 11:14:01 +02:00
services.h MDEV-27595 Backport SQL service, introduced by MDEV-19275. 2023-11-05 23:35:31 +04:00