mirror of
https://github.com/MariaDB/server.git
synced 2025-08-16 07:21:32 +02:00
![]() 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. |
||
---|---|---|
.. | ||
psi | ||
auth_dialog_client.h | ||
client_plugin.h | ||
client_plugin.h.pp | ||
plugin.h | ||
plugin_audit.h | ||
plugin_audit.h.pp | ||
plugin_auth.h | ||
plugin_auth.h.pp | ||
plugin_auth_common.h | ||
plugin_data_type.h | ||
plugin_data_type.h.pp | ||
plugin_encryption.h | ||
plugin_encryption.h.pp | ||
plugin_ftparser.h | ||
plugin_ftparser.h.pp | ||
plugin_function.h | ||
plugin_function.h.pp | ||
plugin_password_validation.h | ||
plugin_password_validation.h.pp | ||
service_base64.h | ||
service_debug_sync.h | ||
service_encryption.h | ||
service_encryption_scheme.h | ||
service_json.h | ||
service_kill_statement.h | ||
service_log_warnings.h | ||
service_logger.h | ||
service_md5.h | ||
service_my_crypt.h | ||
service_my_print_error.h | ||
service_my_snprintf.h | ||
service_print_check_msg.h | ||
service_progress_report.h | ||
service_sha1.h | ||
service_sha2.h | ||
service_sql.h | ||
service_thd_alloc.h | ||
service_thd_autoinc.h | ||
service_thd_error_context.h | ||
service_thd_mdl.h | ||
service_thd_rnd.h | ||
service_thd_specifics.h | ||
service_thd_timezone.h | ||
service_thd_wait.h | ||
service_wsrep.h | ||
services.h |