Bug #33932 assertion at handle_slave_sql if init_slave_thread() fails
Submitted: 18 Jan 2008 19:22 Modified: 29 Mar 2008 17:56
Reporter: Andrei Elkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.0 OS:Any
Assigned to: Andrei Elkin CPU Architecture:Any

[18 Jan 2008 19:22] Andrei Elkin 
Description:
Similarly to Bug #33931, but not sql thread
hits 
  mysqld: slave.cc:4028: void* handle_slave_sql(void*): Assertion`rli->slave_running == 1' failed.

wheneven one of the functions
   init_thr_lock() || thd->store_globals()
returns non-zero.

It's not clear if this finding reveals the very reason of Bug #33421, Bug #33423.

How to repeat:
Apply the patch on Bug #33931 how-to-repeat section.
[4 Feb 2008 21:59] Andrei Elkin 
The patch for the bug is within cset for a related bug#33931
[14 Feb 2008 22:06] Andrei Elkin 
Pushed to 5.0-rpl along with fixes for bug#33931.
[25 Mar 2008 11:22] Bugs System 
Pushed into 5.0.60
[25 Mar 2008 11:23] Bugs System 
Pushed into 5.1.24-rc
[26 Mar 2008 19:01] Bugs System 
Pushed into 6.0.5-alpha
[27 Mar 2008 8:19] Andrei Elkin 
Similarly to bug#33931,
asserts fired in a case of having negative results from memory allocation
at thd->store_globals().
The assert condition did not expect that due to the failure in thd->store_globals() execution trace will skip some of necessary initializations.
And that has been corrected.
[29 Mar 2008 17:56] Jon Stephens 
No end-user changes to be documented; closed without further action.