Bug #20914 SHOW VARIABLES crashes server
Submitted: 8 Jul 2006 5:40 Modified: 7 Aug 2006 9:01
Reporter: Valeriy Kravchuk Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.1.2-a_drop5p14 OS:Linux (RHEL 3 Linux)
Assigned to: Alexander Barkov CPU Architecture:Any
Tags: crash, show variables

[8 Jul 2006 5:40] Valeriy Kravchuk 
Description:
SHOW VARIABLES statetement crashes server (5.1.2-a_drop5p14) each and every time. No my.cnf is used. Other SHOW commands works.

Resolved stack trace is:

$ ./bin/resolve_stack_dump -s ~/mysqld-csc10434.sym -n ~/csc10434.trace
0x818e13e handle_segfault + 570
0xb75b6d28 _end + -1358614928
0x7a690074 _end + 1913831868
0x827d26a _Z14fill_variablesP3THDP13st_table_listP4Item + 78
0x827e2f5 _Z24get_schema_tables_resultP4JOIN + 289
0x81eeec8 _ZN4JOIN4execEv + 3212
0x81f0be9 _Z12mysql_selectP3THDPPP4ItemP13st_table_listjR4ListIS1_ES2_jP8st_orderSB_S2_SB_mP13select_resultP18st_select_lex_unitP13st_sel + 185

Server was built from sorces with:

configure --with-ndbcluster
make
make install
0x81f1206 _Z13handle_selectP3THDP6st_lexP13select_resultm + 186
0x81a55d2 _Z21mysql_execute_commandP3THD + 6618
0x81acec9 _Z11mysql_parseP3THDPcj + 481
0x81ad8cc _Z16dispatch_command19enum_server_commandP3THDPcj + 2220
0x81aecbd handle_one_connection + 1517
0xb75b0dec _end + -1358639308
0xb7416e8a _end + -1360318510

How to repeat:
Connect to MySQL 5.1.2-a_drop5p14 and execute SHOW VARIABLES. Not repeatable on 5.1-BK.

Suggested fix:
There is only one "similar" bug found, bug #3897, fixed in 4.0.21. Maybe, similar fix is needed for this 5.1.2-a_drop5p14?
[8 Jul 2006 5:44] Valeriy Kravchuk 
Sorry, text was pasted into the wrong place. Corrected description is:

Resolved stack trace is:

$ ./bin/resolve_stack_dump -s ~/mysqld-csc10434.sym -n ~/csc10434.trace
0x818e13e handle_segfault + 570
0xb75b6d28 _end + -1358614928
0x7a690074 _end + 1913831868
0x827d26a _Z14fill_variablesP3THDP13st_table_listP4Item + 78
0x827e2f5 _Z24get_schema_tables_resultP4JOIN + 289
0x81eeec8 _ZN4JOIN4execEv + 3212
0x81f0be9
_Z12mysql_selectP3THDPPP4ItemP13st_table_listjR4ListIS1_ES2_jP8st_orderSB_S2_SB_
mP13select_resultP18st_select_lex_unitP13st_sel + 185
0x81f1206 _Z13handle_selectP3THDP6st_lexP13select_resultm + 186
0x81a55d2 _Z21mysql_execute_commandP3THD + 6618
0x81acec9 _Z11mysql_parseP3THDPcj + 481
0x81ad8cc _Z16dispatch_command19enum_server_commandP3THDPcj + 2220
0x81aecbd handle_one_connection + 1517
0xb75b0dec _end + -1358639308
0xb7416e8a _end + -1360318510

Server was built from sorces with:

configure --with-ndbcluster
make
make install
[27 Jul 2006 7:44] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/9651
[7 Aug 2006 9:01] Alexander Barkov 
Pushed into mysql-5.1-wl2325-5.0

No documenting necessary, closing.