Bug #59566 Server asserts in Diagnostics_area::set_ok_status
Submitted: 17 Jan 2011 19:17 Modified: 25 Feb 2011 8:41
Reporter: Luis Soares Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.5.8+ OS:Any
Assigned to: Jon Olav Hauglid CPU Architecture:Any

[17 Jan 2011 19:17] Luis Soares
Description:
During re-verification of BUG#51282, it was discovered that sometimes
the server would assert (5.5.8-debug, 5.5.9-debug) when running 
BUG#51282 test case with a number of threads equal to 8, 12, 16 on 
5.5.8 and equal to 8 threads in 5.5.9. It would exhibit this call 
stack:

    Assertion failed: ! is_set(), file ..\..\mysql-5.5.8\sql\sql_error.cc, line 359

	0058A423    mysqld-debug.exe!my_sigabrt_handler()[my_thr_init.c:521]
	00654E2B    mysqld-debug.exe!raise()[winsig.c:590]
	0065DCD5    mysqld-debug.exe!abort()[abort.c:71]
	006570D7    mysqld-debug.exe!_wassert()[assert.c:346]
	0025A661    mysqld-debug.exe!Diagnostics_area::set_ok_status()[sql_error.cc:359]
	0011EB49    mysqld-debug.exe!my_ok()[sql_class.h:2857]
	0024405B    mysqld-debug.exe!mysql_execute_command()[sql_parse.cc:3547]
	00248E64    mysqld-debug.exe!mysql_parse()[sql_parse.cc:5496]
	0023EBCF    mysqld-debug.exe!dispatch_command()[sql_parse.cc:1032]
	0023E619    mysqld-debug.exe!do_command()[sql_parse.cc:772]
	00153C0F    mysqld-debug.exe!do_handle_one_connection()[sql_connect.cc:745]
	001539BC    mysqld-debug.exe!handle_one_connection()[sql_connect.cc:684]
	00589388    mysqld-debug.exe!pthread_start()[my_winthread.c:61]
	00664B03    mysqld-debug.exe!_callthreadstartex()[threadex.c:348]
	00664AA4    mysqld-debug.exe!_threadstartex()[threadex.c:331]
	769AD0E9    kernel32.dll!BaseThreadInitThunk()
	773819BB    ntdll.dll!RtlInitializeExceptionChain()
	7738198E    ntdll.dll!RtlInitializeExceptionChain()

Environment:

  - Dell Vostro 200
  - Windows Vista 32-bit
  - Intel Pentium Dual E2180 2.00 GHz
  - 4GB RAM

How to repeat:
See Santo Leto's comment on BUG#51282: [17 Jan 1:18] Santo Leto

Suggested fix:
.
[25 Feb 2011 8:41] Jon Olav Hauglid
Closing the bug as Can't repeat
Neither Santo Leto or myself are able to trigger the bugs with the current
version of 5.5, several different machines and architectures tried.