Comment 8 for bug 1129074

Hi,

I think this is still related to the issue I reported here. If not, feel free to open this as a new bug.

With the version you provided, a parallel BG query using ORDER BY and LIMIT will cause the server to crash
(I know the query is rather stupid with large tables since the head node needs to do the sorting right? But
still it should not take the server down):

select * from FOO order by BAR limit 10;

will crash. This will not crash however:

select * from FOO order by BAR;
select * from FOO limit 10;

Stacktrace from the log file is:

/usr/local/mysql/bin/mysqld(my_print_stacktrace+0x33)[0x7558e3]
/usr/local/mysql/bin/mysqld(handle_segfault+0x42b)[0x50153b]
/lib64/libpthread.so.0[0x309760f500]
/usr/local/mysql/lib/plugin/ha_spider.so(_ZN9ha_spider8positionEPKh+0x111)[0x2b2667584601]
/usr/local/mysql/bin/mysqld(_ZN12ha_partition8positionEPKh+0x27)[0x8b0d57]
/usr/local/mysql/bin/mysqld(_Z8filesortP3THDP5TABLEP13st_sort_fieldjP10SQL_SELECTybPy+0x12ae)[0x64b8de]
/usr/local/mysql/bin/mysqld[0x596af5]
/usr/local/mysql/bin/mysqld(_ZN4JOIN4execEv+0xb25)[0x5a07e5]
/usr/local/mysql/bin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x162)[0x59c862]
/usr/local/mysql/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x17c)[0x5a1efc]
/usr/local/mysql/bin/mysqld[0x5657b4]
/usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0x2c65)[0x56b5e5]
/usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x16d)[0x56cd7d]
/usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1257)[0x56e717]
/usr/local/mysql/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x176)[0x5f7686]
/usr/local/mysql/bin/mysqld(handle_one_connection+0x4a)[0x5f76ea]
/usr/local/mysql/bin/mysqld(pfs_spawn_thread+0x54)[0x7ae034]
/lib64/libpthread.so.0[0x3097607851]
/lib64/libc.so.6(clone+0x6d)[0x3096ae890d]

I'm happy to provide any other information that might help...

Thanks!