Bug #55373 Prevent io_thread from stopping in the middle of a transaction
Submitted: 19 Jul 2010 16:42 Modified: 19 Jul 2010 19:37
Reporter: Kavita T Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.1.41 OS:Linux
Assigned to: CPU Architecture:Any
Tags: IO_THREAD

[19 Jul 2010 16:42] Kavita T
Description:
Prevent io_thread from stopping in the middle of a transaction. This causes Sql_thread to loop indefinitely (Reference bug #55185) until manual intervention.
Please suggest alternative solutions for stopping io_thread followed by sql_thread.

How to repeat:
occurs randomly
[19 Jul 2010 19:37] Sveta Smirnova
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

According to bug #55185 this is your application which tries to be sure replication catch up comparing binary and relay log positions while IO thread stopped. Please fix logic in your application so it does not rely on such behavior.