Bug #64913 | crash after get_schema_tables_result when reading information_schema tables | ||
---|---|---|---|
Submitted: | 9 Apr 2012 8:11 | Modified: | 3 Jul 2012 11:45 |
Reporter: | Simon Mudd (OCA) | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Information schema | Severity: | S3 (Non-critical) |
Version: | 5.6.4-m7-log MySQL Community Server (GPL | OS: | Linux (centos-release-5-6.el5.centos.1) |
Assigned to: | CPU Architecture: | Any | |
Tags: | windmill |
[9 Apr 2012 8:11]
Simon Mudd
[9 Apr 2012 8:54]
Simon Mudd
mysqld_using_numactl is a shell wrapper to use numactl when starting mysqld. See: http://blog.wl0.org/2011/03/how-to-start-mysqld-using-numactl/
[16 Apr 2012 20:46]
MySQL Verification Team
I got a repeatable crash when accessing information_schema tables in a join. Without knowing the query involved in this crash, it's not possible to be 100% sure I got the same bug. my 5.6.6 backtrace: mysqld.exe!get_schema_tables_result()[sql_show.cc:7184] mysqld.exe!JOIN::prepare_result()[sql_select.cc:795] mysqld.exe!JOIN::exec()[sql_executor.cc:139] mysqld.exe!mysql_select()[sql_select.cc:1069] mysqld.exe!handle_select()[sql_select.cc:107] mysqld.exe!execute_sqlcom_select()[sql_parse.cc:4929] mysqld.exe!mysql_execute_command()[sql_parse.cc:2488] mysqld.exe!mysql_parse()[sql_parse.cc:6016] mysqld.exe!dispatch_command()[sql_parse.cc:1260] mysqld.exe!do_command()[sql_parse.cc:980] mysqld.exe!do_handle_one_connection()[sql_connect.cc:942] mysqld.exe!handle_one_connection()[sql_connect.cc:858] mysqld.exe!pthread_start()[my_winthread.c:61] mysqld.exe!_callthreadstartex()[threadex.c:314] mysqld.exe!_threadstartex()[threadex.c:292] Oracle bug number: 13966514
[15 May 2012 17:23]
Franjo Markovic
I had same crashes twice today, immediately after a deadlock detection. My err file output is very similar, except it ends at this line: stack_bottom = 0x7b8434eb8 thread_stack 0x40000 (and restart messages follow after)
[16 May 2012 4:57]
MySQL Verification Team
Franjo, I've made you last comment private. It has nothing to do with this crash and didnt' want to it confusing the bug report. Yours is InnoDB/Query Cache related, not information_schema related.
[3 Jul 2012 11:45]
MySQL Verification Team
After the similar bug was fixed in 5.6.6: Bug 13966514 - CRASH IN GET_SCHEMA_TABLES_RESULT WITH MIN/MAX, LEFT/RIGHT JOIN ON I_S TABLE I have never seen this particular crash again. Tentatively marking this as "cant repeat".