Bug #116317 Clone_persist_gtid thread runs even when GTID mode disabled

• Submitted: 9 Oct 2024 3:16
• Modified: 9 Oct 2024 6:22
• Reporter: Jervin Real
• Status: Verified
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• Version: 8.0.39
• OS: Any
• CPU Architecture: Any

[9 Oct 2024 3:16] Jervin Real

Description:
On an instance with GTID mode disabled, Clone_persist_gtid internal thread still runs. This exposes instances to issues like https://bugs.mysql.com/bug.php?id=107991

How to repeat:
perf record -aRg sleep 10
perf script | grep Clone_persist_gtid

Should show the thread running.

    100 my_internal_malloc<&(redirecting_allocator(unsigned,std::__detail::_Hashtable_alloc<Malloc_allocator<std::__detail::_Hash_node<std::pair<std::__cxx11::basic_string<char,,Sid_map::Sid_map,Clone_persist_gtid::flush_gtids,Clone_persist_gtid::periodic_write,std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread,,execute_native_thread_routine
    100 malloc,std::__detail::_Hashtable_alloc<Malloc_allocator<std::__detail::_Hash_node<std::pair<std::__cxx11::basic_string<char,,Sid_map::Sid_map,Clone_persist_gtid::flush_gtids,Clone_persist_gtid::periodic_write,std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread,,execute_native_thread_routine

Suggested fix:
Disable this thread when gtid mode is disabled.

[9 Oct 2024 6:22] MySQL Verification Team

Hello Jervin Real,

Thank you for the report and feedback.

regards,
Umesh