[sbester@levovo mysql-5.6.2-m5-linux-x86_64]$ gdb ./bin/mysqld ./data/core.1413 GNU gdb (GDB) Fedora (7.1-18.fc13) Copyright (C) 2010 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-redhat-linux-gnu". For bug reporting instructions, please see: ... Reading symbols from /home/sbester/mysql/5.6/mysql-5.6.2-m5-linux-x86_64/bin/mysqld...done. [New Thread 2420] [New Thread 2425] [New Thread 2421] [New Thread 2422] [New Thread 2431] [New Thread 2434] [New Thread 2438] [New Thread 1413] [New Thread 1417] [New Thread 1416] [New Thread 1419] [New Thread 1418] [New Thread 1420] [New Thread 1421] [New Thread 1422] [New Thread 1423] [New Thread 1424] [New Thread 1426] [New Thread 1441] [New Thread 1443] [New Thread 1444] [New Thread 1446] [New Thread 1445] [New Thread 2155] [New Thread 1456] [New Thread 2418] [New Thread 2435] [New Thread 2419] [New Thread 2486] [New Thread 2433] [New Thread 2167] Reading symbols from /lib64/libpthread-2.12.so...Reading symbols from /usr/lib/debug/lib64/libpthread-2.12.so.debug...done. done. Loaded symbols for /lib64/libpthread-2.12.so Reading symbols from /lib64/libz.so.1.2.3...Reading symbols from /usr/lib/debug/lib64/libz.so.1.2.3.debug...done. done. Loaded symbols for /lib64/libz.so.1.2.3 Reading symbols from /lib64/libm-2.12.so...Reading symbols from /usr/lib/debug/lib64/libm-2.12.so.debug...done. done. Loaded symbols for /lib64/libm-2.12.so Reading symbols from /lib64/librt-2.12.so...Reading symbols from /usr/lib/debug/lib64/librt-2.12.so.debug...done. done. Loaded symbols for /lib64/librt-2.12.so Reading symbols from /lib64/libcrypt-2.12.so...Reading symbols from /usr/lib/debug/lib64/libcrypt-2.12.so.debug...done. done. Loaded symbols for /lib64/libcrypt-2.12.so Reading symbols from /lib64/libdl-2.12.so...Reading symbols from /usr/lib/debug/lib64/libdl-2.12.so.debug...done. done. Loaded symbols for /lib64/libdl-2.12.so Reading symbols from /lib64/libc-2.12.so...Reading symbols from /usr/lib/debug/lib64/libc-2.12.so.debug...done. done. Loaded symbols for /lib64/libc-2.12.so Reading symbols from /lib64/ld-2.12.so...Reading symbols from /usr/lib/debug/lib64/ld-2.12.so.debug...done. done. Loaded symbols for /lib64/ld-2.12.so Reading symbols from /lib64/libfreebl3.so...Reading symbols from /usr/lib/debug/lib64/libfreebl3.so.debug...done. done. Loaded symbols for /lib64/libfreebl3.so Reading symbols from /lib64/libgcc_s-4.4.4-20100630.so.1...Reading symbols from /usr/lib/debug/lib64/libgcc_s-4.4.4-20100630.so.1.debug...done. done. Loaded symbols for /lib64/libgcc_s-4.4.4-20100630.so.1 Reading symbols from /lib64/libnss_files-2.12.so...Reading symbols from /usr/lib/debug/lib64/libnss_files-2.12.so.debug...done. done. Loaded symbols for /lib64/libnss_files-2.12.so Reading symbols from /lib/modules/2.6.33.3-85.fc13.x86_64/vdso/vdso.so...Reading symbols from /usr/lib/debug/lib/modules/2.6.33.3-85.fc13.x86_64/vdso/vdso.so.debug...done. done. Loaded symbols for /lib/modules/2.6.33.3-85.fc13.x86_64/vdso/vdso.so Core was generated by `/home/sbester/mysql/5.6/mysql-5.6.2-m5-linux-x86_64/bin/mysqld --basedir=/home/'. Program terminated with signal 6, Aborted. #0 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 64 return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig); (gdb) set print elements 3000 (gdb) thread apply all bt Thread 31 (Thread 2167): #0 0x00000000009d5d3e in rec_offs_validate (rec=0x0, index=0x0, offsets=0x7f1cdc51c950) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/rem0rec.ic:1002 #1 0x00000000009d6036 in rec_offs_nth_extern (offsets=0x7f1cdc51c950, n=4) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/rem0rec.ic:1100 #2 0x0000000000addc89 in cmp_rec_rec_with_match (rec1=0x7f1cdc61da91 "", rec2=0x7f1d156a810e "", offsets1=0x7f1cdc51c8d8, offsets2=0x7f1cdc51c950, index=0x7f1cd001a818, matched_fields=0x7f1ccfd30288, matched_bytes=0x7f1ccfd30280) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/rem/rem0cmp.c:953 #3 0x0000000000adc60f in cmp_rec_rec (rec1=0x7f1cdc61da91 "", rec2=0x7f1d156a810e "", offsets1=0x7f1cdc51c8d8, offsets2=0x7f1cdc51c950, index=0x7f1cd001a818) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/rem0cmp.ic:89 #4 0x0000000000a34731 in btr_pcur_restore_position_func (latch_mode=1, cursor=0x7f1cdc02f138, file=0xc8cb20 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c", line=3181, mtr=0x7f1ccfd30760) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/btr/btr0pcur.c:290 #5 0x00000000009ef253 in sel_restore_position_for_mysql (same_user_rec=0x7f1ccfd30c30, latch_mode=1, pcur=0x7f1cdc02f138, moves_up=1, mtr=0x7f1ccfd30760) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:3181 #6 0x00000000009f099a in row_search_for_mysql (buf=0x7f1cdc980910 , mode=1, prebuilt=0x7f1cdc695028, match_mode=0, direction=1) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:3949 #7 0x00000000009bd92c in ha_innobase::general_fetch (this=0x7f1cdc21ba40, buf=0x7f1cdc980910 , direction=1, match_mode=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6325 #8 0x00000000009bda53 in ha_innobase::index_next (this=0x7f1cdc21ba40, buf=0x7f1cdc980910 ) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6365 #9 0x000000000075e166 in handler::ha_index_next (this=0x7f1cdc21ba40, buf=0x7f1cdc980910 ) at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2277 #10 0x0000000000645af1 in join_read_next (info=0x7f1cdc5abb68) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:18317 #11 0x0000000000643991 in sub_select (join=0x7f1cdc55a020, join_tab=0x7f1cdc5abad8, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17384 #12 0x00000000006443db in evaluate_join_record (join=0x7f1cdc55a020, join_tab=0x7f1cdc5ab820, error=0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17680 #13 0x00000000006439f0 in sub_select (join=0x7f1cdc55a020, join_tab=0x7f1cdc5ab820, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17389 #14 0x00000000006443db in evaluate_join_record (join=0x7f1cdc55a020, join_tab=0x7f1cdc5ab568, error=0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17680 #15 0x00000000006439f0 in sub_select (join=0x7f1cdc55a020, join_tab=0x7f1cdc5ab568, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17389 #16 0x00000000006443db in evaluate_join_record (join=0x7f1cdc55a020, join_tab=0x7f1cdc5ab2b0, error=0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17680 #17 0x00000000006439f0 in sub_select (join=0x7f1cdc55a020, join_tab=0x7f1cdc5ab2b0, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17389 #18 0x00000000006443db in evaluate_join_record (join=0x7f1cdc55a020, join_tab=0x7f1cdc5aaff8, error=0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17680 #19 0x00000000006439f0 in sub_select (join=0x7f1cdc55a020, join_tab=0x7f1cdc5aaff8, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17389 #20 0x00000000006443db in evaluate_join_record (join=0x7f1cdc55a020, join_tab=0x7f1cdc5aad40, error=0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17680 #21 0x00000000006439f0 in sub_select (join=0x7f1cdc55a020, join_tab=0x7f1cdc5aad40, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17389 #22 0x00000000006443db in evaluate_join_record (join=0x7f1cdc55a020, join_tab=0x7f1cdc5aaa88, error=0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17680 #23 0x00000000006439f0 in sub_select (join=0x7f1cdc55a020, join_tab=0x7f1cdc5aaa88, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17389 #24 0x00000000006443db in evaluate_join_record (join=0x7f1cdc55a020, join_tab=0x7f1cdc5aa7d0, error=0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17680 #25 0x00000000006439f0 in sub_select (join=0x7f1cdc55a020, join_tab=0x7f1cdc5aa7d0, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17389 #26 0x00000000006443db in evaluate_join_record (join=0x7f1cdc55a020, join_tab=0x7f1cdc5aa518, error=0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17680 #27 0x000000000064397b in sub_select (join=0x7f1cdc55a020, join_tab=0x7f1cdc5aa518, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17376 #28 0x0000000000642e6c in do_select (join=0x7f1cdc55a020, fields=0x2b63578, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16920 #29 0x0000000000622d2e in JOIN::exec (this=0x7f1cdc55a020) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #30 0x00000000006235c0 in mysql_select (thd=0x2b61110, rref_pointer_array=0x2b63680, tables=0x7f1cdc17a7e0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2148797184, result=0x7f1cdc5eb6e0, unit=0x2b62e20, select_lex=0x2b63468) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3554 #31 0x0000000000619c09 in handle_select (thd=0x2b61110, lex=0x2b62d70, result=0x7f1cdc5eb6e0, setup_tables_done_option=0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:323 #32 0x00000000005fc34b in execute_sqlcom_select (thd=0x2b61110, all_tables=0x7f1cdc17a7e0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:4513 #33 0x00000000005f4fae in mysql_execute_command (thd=0x2b61110) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:2096 #34 0x00000000005fe4a7 in mysql_parse (thd=0x2b61110, rawbuf=0x7f1cdc6391f0 "select 1 from `t1` as `t1_0` \nleft outer join `t76` as `t76_1` on `t76_1`.`col687` != \n (select min(`t4_2`.`col39`) as `col39` from t4 as `t4_2` ) \nnatural left outer join `t26` as `t26_3` \nnatural right outer join `t97` as `t97_4` \nnatural right outer join `t32` as `t32_5` \nnatural left outer join `t5` as `t5_6` \nright outer join `t23` as `t23_7` on `t5_6`.`col48` like `t32_5`.`col308` \nnatural left join `t61` as `t61_8` \nnatural join `t62_tmp` as `t62_tmp_9` \nnatural left join `t94` as `t94_10` \nnatural right outer join `t98` as `t98_11` \nright outer join `t92` as `t92_12` on `t97_4`.`col863` is null \nleft join `t7` as `t7_13` on `t61_8`.`col575` <=> `t62_tmp_9`.`a62` and\n\t`t5_6`.`col46` = null", length=726, parser_state=0x7f1ccfd33610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #35 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2b61110, packet=0x2b92f61 "", packet_length=728) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #36 0x00000000005f1b76 in do_command (thd=0x2b61110) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #37 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2b61110) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #38 0x00000000006d140e in handle_one_connection (arg=0x2b61110) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #39 0x00000030e1807761 in start_thread (arg=0x7f1ccfd34710) at pthread_create.c:301 #40 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 30 (Thread 2433): #0 __lll_lock_wait_private () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:97 #1 0x00000030e1449566 in _L_lock_12950 () from /lib64/libc-2.12.so #2 0x00000030e144940a in buffered_vfprintf (s=0x30e1779860, format=, args=) at vfprintf.c:2238 #3 0x00000030e144450e in _IO_vfprintf_internal (s=0x30e1779860, format=0xc98542 "%02d%02d%02d %2d:%02d:%02d", ap=0x7f1d0f4d0c50) at vfprintf.c:1287 #4 0x00000030e144eee8 in __fprintf (stream=, format=) at fprintf.c:33 #5 0x0000000000a1f066 in ut_print_timestamp (file=0x30e1779860) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/ut/ut0ut.c:267 #6 0x0000000000a1cd5b in ut_dbg_assertion_failed (expr=0xc8db68 "prebuilt->sql_stat_start || trx->state == TRX_STATE_ACTIVE", file=0xc8cb20 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c", line=3869) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/ut/ut0dbg.c:55 #7 0x00000000009f061c in row_search_for_mysql (buf=0x7f1cdc24d480 "\376", mode=1, prebuilt=0x7f1cdc443aa8, match_mode=0, direction=1) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:3869 #8 0x00000000009bd92c in ha_innobase::general_fetch (this=0x7f1cdc5e4d30, buf=0x7f1cdc24d480 "\376", direction=1, match_mode=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6325 #9 0x00000000009bdd9d in ha_innobase::rnd_next (this=0x7f1cdc5e4d30, buf=0x7f1cdc24d480 "\376") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6519 #10 0x000000000075de5e in handler::ha_rnd_next (this=0x7f1cdc5e4d30, buf=0x7f1cdc24d480 "\376") at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2225 #11 0x00000000008334c0 in rr_sequential (info=0x7f1cdc182b48) at /home/sbester/build/bzr/mysql-trunk/sql/records.cc:458 #12 0x0000000000874cf0 in JOIN_CACHE_BNL::join_matching_records (this=0x7f1cdc630630, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1805 #13 0x0000000000874677 in JOIN_CACHE::join_records (this=0x7f1cdc630630, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1654 #14 0x00000000008747f5 in JOIN_CACHE::join_records (this=0x7f1cdc804870, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1700 #15 0x00000000006436a2 in sub_select_cache (join=0x7f1cdc986a90, join_tab=0x7f1cdc182800, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17174 #16 0x0000000000643865 in sub_select (join=0x7f1cdc986a90, join_tab=0x7f1cdc182548, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17344 #17 0x0000000000642e9e in do_select (join=0x7f1cdc986a90, fields=0x7f1cdc986e00, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16922 #18 0x0000000000622d2e in JOIN::exec (this=0x7f1cdc986a90) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #19 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cdc1efd20) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #20 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cdc804b90) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #21 0x00000000007e2f4e in Item_singlerow_subselect::val_int (this=0x7f1cdc804b90) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:723 #22 0x00000000007bc4b1 in Item_func_set_user_var::check (this=0x7f1cdc682a80, use_result_field=false) at /home/sbester/build/bzr/mysql-trunk/sql/item_func.cc:4542 #23 0x0000000000581ccf in set_var_user::check (this=0x7f1cdc549570, thd=0x2b5df10) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:686 #24 0x00000000005817b2 in sql_set_variables (thd=0x2b5df10, var_list=0x2b60838) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:568 #25 0x00000000005f7c55 in mysql_execute_command (thd=0x2b5df10) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:3097 #26 0x00000000005fe4a7 in mysql_parse (thd=0x2b5df10, rawbuf=0x7f1cdcca1ae0 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 )", length=1487, parser_state=0x7f1d0f4d3610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #27 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2b5df10, packet=0x2e18d21 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 ); ", packet_length=1498) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #28 0x00000000005f1b76 in do_command (thd=0x2b5df10) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #29 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2b5df10) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #30 0x00000000006d140e in handle_one_connection (arg=0x2b5df10) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #31 0x00000030e1807761 in start_thread (arg=0x7f1d0f4d4710) at pthread_create.c:301 #32 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 29 (Thread 2486): #0 0x0000000000adb52f in que_thr_stop_for_mysql (thr=0x7f1cec00e400) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/que/que0que.c:849 #1 0x00000000009f236b in row_search_for_mysql (buf=0x7f1cec226020 "\377\377", mode=1, prebuilt=0x7f1cec1154c8, match_mode=0, direction=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:4818 #2 0x00000000009bd18e in ha_innobase::index_read (this=0x7f1cec249870, buf=0x7f1cec226020 "\377\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6112 #3 0x00000000009bdb66 in ha_innobase::index_first (this=0x7f1cec249870, buf=0x7f1cec226020 "\377\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6414 #4 0x00000000009bdd5f in ha_innobase::rnd_next (this=0x7f1cec249870, buf=0x7f1cec226020 "\377\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6511 #5 0x000000000075de5e in handler::ha_rnd_next (this=0x7f1cec249870, buf=0x7f1cec226020 "\377\377") at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2225 #6 0x00000000008334c0 in rr_sequential (info=0x7f1cec1280c8) at /home/sbester/build/bzr/mysql-trunk/sql/records.cc:458 #7 0x000000000064592a in join_init_read_record (tab=0x7f1cec128038) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:18278 #8 0x000000000064391c in sub_select (join=0x7f1cec264830, join_tab=0x7f1cec128038, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17371 #9 0x0000000000642e6c in do_select (join=0x7f1cec264830, fields=0x0, table=0x7f1cec2227d0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16920 #10 0x000000000062113b in JOIN::exec (this=0x7f1cec264830) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:2913 #11 0x00000000006235c0 in mysql_select (thd=0x2b0a620, rref_pointer_array=0x2b0cb90, tables=0x7f1cec145150, wild_num=0, fields=..., conds=0x7f1cec239550, og_num=2, order=0x7f1cec2a69f0, group=0x7f1cec051590, having=0x7f1cec21bca0, proc_param=0x0, select_options=2157185280, result=0x7f1cec268b20, unit=0x2b0c330, select_lex=0x2b0c978) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3554 #12 0x0000000000619c09 in handle_select (thd=0x2b0a620, lex=0x2b0c280, result=0x7f1cec268b20, setup_tables_done_option=0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:323 #13 0x00000000005fc34b in execute_sqlcom_select (thd=0x2b0a620, all_tables=0x7f1cec145150) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:4513 #14 0x00000000005f4fae in mysql_execute_command (thd=0x2b0a620) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:2096 #15 0x00000000005fe4a7 in mysql_parse (thd=0x2b0a620, rawbuf=0x7f1cec1cbd80 "select charset(t4_33844.col30) as col30_33849\nfrom\nt4 as t4_33844\nwhere\n@a:=( select version() as col786_33196\nfrom\nt88 as t88_33190\nwhere\n@a:=t88_33190.col782 = t88_33190.col782\ngroup by\n@a:=t88_33190.col784\nhaving\ncol786_33196 \norder by\n@a:=t88_33190.col790\nlimit 1 ) <= ( select version() as col786_33196\nfrom\nt88 as t88_33190\nwhere\n@a:=t88_33190.col782 = t88_33190.col782\ngroup by\n@a:=t88_33190.col784\nhaving\ncol786_33196 \norder by\n@a:=t88_33190.col790\nlimit 1 )\ngroup by\n@a:=t4_33844.col34\nhaving\ncol30_33849 \norder by\n@a:=t4_33844.col27\nlimit 1 for update", length=561, parser_state=0x7f1ccffbd610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #16 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2b0a620, packet=0x2b8a651 "select charset(t4_33844.col30) as col30_33849\nfrom\nt4 as t4_33844\nwhere\n@a:=( select version() as col786_33196\nfrom\nt88 as t88_33190\nwhere\n@a:=t88_33190.col782 = t88_33190.col782\ngroup by\n@a:=t88_33190.col784\nhaving\ncol786_33196 \norder by\n@a:=t88_33190.col790\nlimit 1 ) <= ( select version() as col786_33196\nfrom\nt88 as t88_33190\nwhere\n@a:=t88_33190.col782 = t88_33190.col782\ngroup by\n@a:=t88_33190.col784\nhaving\ncol786_33196 \norder by\n@a:=t88_33190.col790\nlimit 1 )\ngroup by\n@a:=t4_33844.col34\nhaving\ncol30_33849 \norder by\n@a:=t4_33844.col27\nlimit 1 for update", packet_length=561) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #17 0x00000000005f1b76 in do_command (thd=0x2b0a620) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #18 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2b0a620) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #19 0x00000000006d140e in handle_one_connection (arg=0x2b0a620) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #20 0x00000030e1807761 in start_thread (arg=0x7f1ccffbe710) at pthread_create.c:301 #21 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 28 (Thread 2419): #0 0x00000030ec01187c in _Unwind_IteratePhdrCallback (info=, size=, ptr=0x7f1ccfd70f80) at ../../../gcc/unwind-dw2-fde-glibc.c:354 #1 0x00000030e151e886 in __dl_iterate_phdr (callback=0x30ec011470 <_Unwind_IteratePhdrCallback>, data=0x7f1ccfd70f80) at dl-iteratephdr.c:75 #2 0x00000030ec0121d7 in _Unwind_Find_FDE (pc=0x30e14329a5, bases=0x7f1ccfd712a8) at ../../../gcc/unwind-dw2-fde-glibc.c:417 #3 0x00000030ec00f5a3 in uw_frame_state_for (context=0x7f1ccfd71200, fs=0x7f1ccfd71080) at ../../../gcc/unwind-dw2.c:1137 #4 0x00000030ec0100b9 in _Unwind_Backtrace (trace=0x30e14f7560 , trace_argument=0x7f1ccfd71340) from /lib64/libgcc_s-4.4.4-20100630.so.1 #5 0x00000030e14f769e in __backtrace (array=, size=128) at ../sysdeps/ia64/backtrace.c:91 #6 0x000000000091113e in my_print_stacktrace (stack_bottom=0x7f1ccfd74e30 "\220u\267\002", thread_stack=262144) at /home/sbester/build/bzr/mysql-trunk/mysys/stacktrace.c:222 #7 0x000000000056af96 in handle_segfault (sig=6) at /home/sbester/build/bzr/mysql-trunk/sql/mysqld.cc:2439 #8 #9 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #10 0x00000030e1434185 in abort () at abort.c:92 #11 0x00000000009f0621 in row_search_for_mysql (buf=0x7f1cd0255f50 "\376", mode=1, prebuilt=0x7f1cd0256d18, match_mode=0, direction=1) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:3869 #12 0x00000000009bd92c in ha_innobase::general_fetch (this=0x7f1cd0255c70, buf=0x7f1cd0255f50 "\376", direction=1, match_mode=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6325 #13 0x00000000009bdd9d in ha_innobase::rnd_next (this=0x7f1cd0255c70, buf=0x7f1cd0255f50 "\376") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6519 #14 0x000000000075de5e in handler::ha_rnd_next (this=0x7f1cd0255c70, buf=0x7f1cd0255f50 "\376") at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2225 #15 0x00000000008334c0 in rr_sequential (info=0x7f1cec261d48) at /home/sbester/build/bzr/mysql-trunk/sql/records.cc:458 #16 0x0000000000874cf0 in JOIN_CACHE_BNL::join_matching_records (this=0x7f1cec04c490, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1805 #17 0x0000000000874677 in JOIN_CACHE::join_records (this=0x7f1cec04c490, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1654 #18 0x00000000008747f5 in JOIN_CACHE::join_records (this=0x7f1cec2a6dc0, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1700 #19 0x00000000006436a2 in sub_select_cache (join=0x7f1cec04bde0, join_tab=0x7f1cec261a00, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17174 #20 0x0000000000643865 in sub_select (join=0x7f1cec04bde0, join_tab=0x7f1cec261748, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17344 #21 0x0000000000642e9e in do_select (join=0x7f1cec04bde0, fields=0x7f1cec04c150, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16922 #22 0x0000000000622d2e in JOIN::exec (this=0x7f1cec04bde0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #23 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cec1a3330) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #24 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cec1aae00) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #25 0x00000000007e2f4e in Item_singlerow_subselect::val_int (this=0x7f1cec1aae00) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:723 #26 0x00000000007bc4b1 in Item_func_set_user_var::check (this=0x7f1cec2f5510, use_result_field=false) at /home/sbester/build/bzr/mysql-trunk/sql/item_func.cc:4542 #27 0x0000000000581ccf in set_var_user::check (this=0x7f1cec1a3390, thd=0x2b77590) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:686 #28 0x00000000005817b2 in sql_set_variables (thd=0x2b77590, var_list=0x2b79eb8) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:568 #29 0x00000000005f7c55 in mysql_execute_command (thd=0x2b77590) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:3097 #30 0x00000000005fe4a7 in mysql_parse (thd=0x2b77590, rawbuf=0x7f1cec0e7ae0 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 )", length=1487, parser_state=0x7f1ccfd74610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #31 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2b77590, packet=0x2b10071 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 ); ", packet_length=1498) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #32 0x00000000005f1b76 in do_command (thd=0x2b77590) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #33 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2b77590) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #34 0x00000000006d140e in handle_one_connection (arg=0x2b77590) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #35 0x00000030e1807761 in start_thread (arg=0x7f1ccfd75710) at pthread_create.c:301 #36 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 27 (Thread 2435): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x2a1e408, mp=0x2a1e390, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x2a1e408, mutex=0x2a1e390) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2a1e390, reset_sig_count=246) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000a01e22 in sync_array_wait_event (arr=0x214ea30, index=9) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0arr.c:457 #5 0x0000000000a05367 in mutex_spin_wait (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0sync.c:622 #6 0x0000000000a0467f in mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:222 #7 0x0000000000a04758 in pfs_mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:251 #8 0x0000000000aa9769 in lock_wait_table_release_slot (slot=0x7f1d217a8218) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:85 #9 0x0000000000aaa160 in lock_wait_suspend_thread (thr=0x7f1cdc651e88) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:336 #10 0x00000000009e1042 in row_mysql_handle_errors (new_err=0x7f1ccfdb2e48, trx=0x7f1cdcc90808, thr=0x7f1cdc651e88, savept=0x0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0mysql.c:604 #11 0x00000000009f2399 in row_search_for_mysql (buf=0x7f1cdc597aa0 "\377", mode=1, prebuilt=0x7f1cdc00fe58, match_mode=0, direction=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:4822 #12 0x00000000009bd18e in ha_innobase::index_read (this=0x7f1cdc97a880, buf=0x7f1cdc597aa0 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6112 #13 0x00000000009bdb66 in ha_innobase::index_first (this=0x7f1cdc97a880, buf=0x7f1cdc597aa0 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6414 #14 0x00000000009bdd5f in ha_innobase::rnd_next (this=0x7f1cdc97a880, buf=0x7f1cdc597aa0 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6511 #15 0x000000000075de5e in handler::ha_rnd_next (this=0x7f1cdc97a880, buf=0x7f1cdc597aa0 "\377") at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2225 #16 0x00000000008334c0 in rr_sequential (info=0x7f1cdc982568) at /home/sbester/build/bzr/mysql-trunk/sql/records.cc:458 #17 0x000000000064592a in join_init_read_record (tab=0x7f1cdc9824d8) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:18278 #18 0x000000000064391c in sub_select (join=0x7f1cdc52ad80, join_tab=0x7f1cdc9824d8, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17371 #19 0x0000000000642e6c in do_select (join=0x7f1cdc52ad80, fields=0x7f1cdc52b0f0, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16920 #20 0x0000000000622d2e in JOIN::exec (this=0x7f1cdc52ad80) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #21 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cdccaa030) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #22 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cdc5c0d70) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #23 0x00000000007e2ddb in Item_singlerow_subselect::bring_value (this=0x7f1cdc5c0d70) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:699 #24 0x00000000007d060a in Item_row::bring_value (this=0x7f1cdc1ffdb0) at /home/sbester/build/bzr/mysql-trunk/sql/item_row.cc:210 #25 0x0000000000789249 in Arg_comparator::compare_row (this=0x7f1cdc1f28d0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:1597 #26 0x0000000000796f7f in Arg_comparator::compare (this=0x7f1cdc1f28d0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.h:88 #27 0x000000000078a75d in Item_func_lt::val_int (this=0x7f1cdc1f2820) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:2097 #28 0x00000000007954b9 in Item_cond_xor::val_int (this=0x7f1cdcc9c200) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:5342 #29 0x0000000000768150 in Item::val_bool (this=0x7f1cdcc9c200) at /home/sbester/build/bzr/mysql-trunk/sql/item.cc:200 #30 0x0000000000792fac in Item_cond_and::val_int (this=0x7f1cdc45b5a0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:4640 #31 0x000000000069c2be in SQL_SELECT::skip_record (this=0x7f1cdc64d700, thd=0x2b9b490, skip_record=0x7f1ccfdb389f) at /home/sbester/build/bzr/mysql-trunk/sql/opt_range.h:928 #32 0x0000000000874fdd in JOIN_CACHE::check_match (this=0x7f1cdc17faf0, rec_ptr=0x7f1cdc6a2b64 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:2000 #33 0x0000000000874e76 in JOIN_CACHE::generate_full_extensions (this=0x7f1cdc17faf0, rec_ptr=0x7f1cdc6a2b64 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1949 #34 0x0000000000874cbb in JOIN_CACHE_BNL::join_matching_records (this=0x7f1cdc17faf0, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1848 #35 0x0000000000874677 in JOIN_CACHE::join_records (this=0x7f1cdc17faf0, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1654 #36 0x00000000008747f5 in JOIN_CACHE::join_records (this=0x7f1cdc7f42c0, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1700 #37 0x00000000006436a2 in sub_select_cache (join=0x7f1cdc5750e0, join_tab=0x7f1cdc8039c0, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17174 #38 0x0000000000643865 in sub_select (join=0x7f1cdc5750e0, join_tab=0x7f1cdc803708, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17344 #39 0x0000000000642e9e in do_select (join=0x7f1cdc5750e0, fields=0x7f1cdc575450, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16922 #40 0x0000000000622d2e in JOIN::exec (this=0x7f1cdc5750e0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #41 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cdc48e400) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #42 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cdc18bb80) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #43 0x00000000007e2f4e in Item_singlerow_subselect::val_int (this=0x7f1cdc18bb80) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:723 #44 0x00000000007bc4b1 in Item_func_set_user_var::check (this=0x7f1cdc4871d0, use_result_field=false) at /home/sbester/build/bzr/mysql-trunk/sql/item_func.cc:4542 #45 0x0000000000581ccf in set_var_user::check (this=0x7f1cdc48e460, thd=0x2b9b490) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:686 #46 0x00000000005817b2 in sql_set_variables (thd=0x2b9b490, var_list=0x2b9ddb8) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:568 #47 0x00000000005f7c55 in mysql_execute_command (thd=0x2b9b490) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:3097 #48 0x00000000005fe4a7 in mysql_parse (thd=0x2b9b490, rawbuf=0x7f1cdc596550 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 )", length=1487, parser_state=0x7f1ccfdb5610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #49 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2b9b490, packet=0x2b9e691 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 ); ", packet_length=1498) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #50 0x00000000005f1b76 in do_command (thd=0x2b9b490) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #51 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2b9b490) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #52 0x00000000006d140e in handle_one_connection (arg=0x2b9b490) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #53 0x00000030e1807761 in start_thread (arg=0x7f1ccfdb6710) at pthread_create.c:301 #54 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 26 (Thread 2418): #0 0x00000030e180e48d in read () at ../sysdeps/unix/syscall-template.S:82 #1 0x0000000000b3f6f1 in vio_read (vio=0x2ac6530, buf=0x2b6ae40 "\001", size=4) at /home/sbester/build/bzr/mysql-trunk/vio/viosocket.c:44 #2 0x000000000057681c in my_real_read (net=0x2b72be0, complen=0x7f1ccfe78c78) at /home/sbester/build/bzr/mysql-trunk/sql/net_serv.cc:831 #3 0x0000000000576e87 in my_net_read (net=0x2b72be0) at /home/sbester/build/bzr/mysql-trunk/sql/net_serv.cc:1028 #4 0x00000000005f19b1 in do_command (thd=0x2b72970) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:761 #5 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2b72970) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #6 0x00000000006d140e in handle_one_connection (arg=0x2b72970) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #7 0x00000030e1807761 in start_thread (arg=0x7f1ccfe79710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 25 (Thread 1456): #0 do_sigwait (set=, sig=0x7f1d20121ea8) at ../sysdeps/unix/sysv/linux/sigwait.c:65 #1 __sigwait (set=, sig=0x7f1d20121ea8) at ../sysdeps/unix/sysv/linux/sigwait.c:100 #2 0x000000000056b9ff in signal_hand (arg=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/mysqld.cc:2705 #3 0x00000030e1807761 in start_thread (arg=0x7f1d20122710) at pthread_create.c:301 #4 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 24 (Thread 2155): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x7f1cd81dc0f8, mp=0x7f1cd81dc080, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x7f1cd81dc0f8, mutex=0x7f1cd81dc080) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x7f1cd81dc080, reset_sig_count=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000aaa105 in lock_wait_suspend_thread (thr=0x7f1cd8abb700) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:315 #5 0x00000000009e1042 in row_mysql_handle_errors (new_err=0x7f1ccfeb6478, trx=0x7f1cdc4326d8, thr=0x7f1cd8abb700, savept=0x0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0mysql.c:604 #6 0x00000000009f2399 in row_search_for_mysql (buf=0x7f1cd813e7d0 "\377", mode=1, prebuilt=0x7f1cd83bfe98, match_mode=0, direction=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:4822 #7 0x00000000009bd18e in ha_innobase::index_read (this=0x7f1cd813e4f0, buf=0x7f1cd813e7d0 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6112 #8 0x00000000009bdb66 in ha_innobase::index_first (this=0x7f1cd813e4f0, buf=0x7f1cd813e7d0 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6414 #9 0x00000000009bdd5f in ha_innobase::rnd_next (this=0x7f1cd813e4f0, buf=0x7f1cd813e7d0 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6511 #10 0x000000000075de5e in handler::ha_rnd_next (this=0x7f1cd813e4f0, buf=0x7f1cd813e7d0 "\377") at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2225 #11 0x00000000008334c0 in rr_sequential (info=0x7f1cdcd518d0) at /home/sbester/build/bzr/mysql-trunk/sql/records.cc:458 #12 0x000000000064592a in join_init_read_record (tab=0x7f1cdcd51840) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:18278 #13 0x0000000000874a78 in JOIN_CACHE_BNL::join_matching_records (this=0x7f1cdc1ff1e0, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1798 #14 0x0000000000874677 in JOIN_CACHE::join_records (this=0x7f1cdc1ff1e0, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1654 #15 0x00000000006436a2 in sub_select_cache (join=0x7f1cdcbde7d0, join_tab=0x7f1cdcd51840, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17174 #16 0x0000000000643865 in sub_select (join=0x7f1cdcbde7d0, join_tab=0x7f1cdcd51588, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17344 #17 0x0000000000642e9e in do_select (join=0x7f1cdcbde7d0, fields=0x0, table=0x7f1cdc63a670, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16922 #18 0x000000000062113b in JOIN::exec (this=0x7f1cdcbde7d0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:2913 #19 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cdc0692e0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #20 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cdc5ec430) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #21 0x00000000007e2f4e in Item_singlerow_subselect::val_int (this=0x7f1cdc5ec430) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:723 #22 0x00000000007bc4b1 in Item_func_set_user_var::check (this=0x7f1cdc574960, use_result_field=false) at /home/sbester/build/bzr/mysql-trunk/sql/item_func.cc:4542 #23 0x0000000000581ccf in set_var_user::check (this=0x7f1cdc1a2d20, thd=0x2c4a950) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:686 #24 0x00000000005817b2 in sql_set_variables (thd=0x2c4a950, var_list=0x7f1cdc6125b8) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:568 #25 0x00000000005f7c55 in mysql_execute_command (thd=0x2c4a950) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:3097 #26 0x0000000000613e9f in Prepared_statement::execute (this=0x7f1cdc5f2b40, expanded_query=0x7f1ccfeb7fc0, open_cursor=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_prepare.cc:3766 #27 0x0000000000612fa7 in Prepared_statement::execute_loop (this=0x7f1cdc5f2b40, expanded_query=0x7f1ccfeb7fc0, open_cursor=false, packet=0x0, packet_end=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_prepare.cc:3419 #28 0x00000000006112e2 in mysql_sql_stmt_execute (thd=0x2c4a950) at /home/sbester/build/bzr/mysql-trunk/sql/sql_prepare.cc:2613 #29 0x00000000005f4fdf in mysql_execute_command (thd=0x2c4a950) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:2106 #30 0x00000000005fe4a7 in mysql_parse (thd=0x2c4a950, rawbuf=0x7f1cdc569de0 "execute `stmt`", length=14, parser_state=0x7f1ccfeb9610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #31 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2c4a950, packet=0x2aa1ba1 "execute `stmt`", packet_length=14) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #32 0x00000000005f1b76 in do_command (thd=0x2c4a950) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #33 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2c4a950) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #34 0x00000000006d140e in handle_one_connection (arg=0x2c4a950) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #35 0x00000030e1807761 in start_thread (arg=0x7f1ccfeba710) at pthread_create.c:301 #36 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 23 (Thread 1445): #0 0x00000030e14da043 in select () at ../sysdeps/unix/syscall-template.S:82 #1 0x0000000000ac351f in os_thread_sleep (tm=1000000) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0thread.c:274 #2 0x00000000009fd1b4 in srv_master_sleep () at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0srv.c:2511 #3 0x00000000009fd301 in srv_master_thread (arg=0x0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0srv.c:2560 #4 0x00000030e1807761 in start_thread (arg=0x7f1cfffff710) at pthread_create.c:301 #5 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 22 (Thread 1446): #0 0x00000030e14da043 in select () at ../sysdeps/unix/syscall-template.S:82 #1 0x0000000000ac351f in os_thread_sleep (tm=1000000) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0thread.c:274 #2 0x0000000000a4cff5 in page_cleaner_sleep_if_needed (next_loop_time=1295031734122) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/buf/buf0flu.c:2337 #3 0x0000000000a4d0b0 in buf_flush_page_cleaner_thread (arg=0x0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/buf/buf0flu.c:2377 #4 0x00000030e1807761 in start_thread (arg=0x7f1cff5fe710) at pthread_create.c:301 #5 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 21 (Thread 1444): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:212 #1 0x0000000000918dc7 in safe_cond_timedwait (cond=0x2338b28, mp=0x2338ab0, abstime=0x7f1d0d0e7df0, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=171) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:278 #2 0x0000000000ac20f8 in os_cond_wait_timed (cond=0x2338b28, mutex=0x2338ab0, abstime=0x7f1d0d0e7df0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:171 #3 0x0000000000ac2c46 in os_event_wait_time_low (event=0x2338ab0, time_in_usec=5000000, reset_sig_count=1) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:743 #4 0x00000000009fbf83 in srv_monitor_thread (arg=0x0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0srv.c:1707 #5 0x00000030e1807761 in start_thread (arg=0x7f1d0d0e8710) at pthread_create.c:301 #6 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 20 (Thread 1443): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:212 #1 0x0000000000918dc7 in safe_cond_timedwait (cond=0x2338a68, mp=0x23389f0, abstime=0x7f1d0dae8e10, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=171) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:278 #2 0x0000000000ac20f8 in os_cond_wait_timed (cond=0x2338a68, mutex=0x23389f0, abstime=0x7f1d0dae8e10) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:171 #3 0x0000000000ac2c46 in os_event_wait_time_low (event=0x23389f0, time_in_usec=1000000, reset_sig_count=1) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:743 #4 0x00000000009fc4eb in srv_error_monitor_thread (arg=0x0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0srv.c:1931 #5 0x00000030e1807761 in start_thread (arg=0x7f1d0dae9710) at pthread_create.c:301 #6 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 19 (Thread 1441): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:212 #1 0x0000000000918dc7 in safe_cond_timedwait (cond=0x2a1e7d8, mp=0x2a1e760, abstime=0x7f1d0e4e9e30, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=171) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:278 #2 0x0000000000ac20f8 in os_cond_wait_timed (cond=0x2a1e7d8, mutex=0x2a1e760, abstime=0x7f1d0e4e9e30) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:171 #3 0x0000000000ac2c46 in os_event_wait_time_low (event=0x2a1e760, time_in_usec=1000000, reset_sig_count=458) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:743 #4 0x0000000000aaa741 in lock_wait_timeout_thread (arg=0x0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:494 #5 0x00000030e1807761 in start_thread (arg=0x7f1d0e4ea710) at pthread_create.c:301 #6 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 18 (Thread 1426): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x25743b8, mp=0x2574340, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x25743b8, mutex=0x2574340) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2574340, reset_sig_count=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000ac0fb8 in os_aio_simulated_handle (global_segment=9, message1=0x7f1d0ffd8e60, message2=0x7f1d0ffd8e58, type=0x7f1d0ffd8e50) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0file.c:4944 #5 0x0000000000a7eb7f in fil_aio_wait (segment=9) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/fil/fil0fil.c:4543 #6 0x00000000009fe5df in io_handler_thread (arg=0x13424e8) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7f1d0ffd9710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 17 (Thread 1424): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x25742f8, mp=0x2574280, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x25742f8, mutex=0x2574280) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2574280, reset_sig_count=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000ac0fb8 in os_aio_simulated_handle (global_segment=8, message1=0x7f1d109d9e60, message2=0x7f1d109d9e58, type=0x7f1d109d9e50) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0file.c:4944 #5 0x0000000000a7eb7f in fil_aio_wait (segment=8) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/fil/fil0fil.c:4543 #6 0x00000000009fe5df in io_handler_thread (arg=0x13424e0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7f1d109da710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 16 (Thread 1423): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x2574238, mp=0x25741c0, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x2574238, mutex=0x25741c0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x25741c0, reset_sig_count=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000ac0fb8 in os_aio_simulated_handle (global_segment=7, message1=0x7f1d113dae60, message2=0x7f1d113dae58, type=0x7f1d113dae50) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0file.c:4944 #5 0x0000000000a7eb7f in fil_aio_wait (segment=7) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/fil/fil0fil.c:4543 #6 0x00000000009fe5df in io_handler_thread (arg=0x13424d8) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7f1d113db710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 15 (Thread 1422): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x2574178, mp=0x2574100, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x2574178, mutex=0x2574100) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2574100, reset_sig_count=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000ac0fb8 in os_aio_simulated_handle (global_segment=6, message1=0x7f1d11ddbe60, message2=0x7f1d11ddbe58, type=0x7f1d11ddbe50) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0file.c:4944 #5 0x0000000000a7eb7f in fil_aio_wait (segment=6) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/fil/fil0fil.c:4543 #6 0x00000000009fe5df in io_handler_thread (arg=0x13424d0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7f1d11ddc710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 14 (Thread 1421): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x25740b8, mp=0x2574040, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x25740b8, mutex=0x2574040) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2574040, reset_sig_count=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000ac0fb8 in os_aio_simulated_handle (global_segment=5, message1=0x7f1d127dce60, message2=0x7f1d127dce58, type=0x7f1d127dce50) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0file.c:4944 #5 0x0000000000a7eb7f in fil_aio_wait (segment=5) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/fil/fil0fil.c:4543 #6 0x00000000009fe5df in io_handler_thread (arg=0x13424c8) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7f1d127dd710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 13 (Thread 1420): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x2573ff8, mp=0x2573f80, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x2573ff8, mutex=0x2573f80) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2573f80, reset_sig_count=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000ac0fb8 in os_aio_simulated_handle (global_segment=4, message1=0x7f1d131dde60, message2=0x7f1d131dde58, type=0x7f1d131dde50) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0file.c:4944 #5 0x0000000000a7eb7f in fil_aio_wait (segment=4) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/fil/fil0fil.c:4543 #6 0x00000000009fe5df in io_handler_thread (arg=0x13424c0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7f1d131de710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 12 (Thread 1418): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x2573e78, mp=0x2573e00, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x2573e78, mutex=0x2573e00) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2573e00, reset_sig_count=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000ac0fb8 in os_aio_simulated_handle (global_segment=2, message1=0x7f1d20d53e60, message2=0x7f1d20d53e58, type=0x7f1d20d53e50) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0file.c:4944 #5 0x0000000000a7eb7f in fil_aio_wait (segment=2) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/fil/fil0fil.c:4543 #6 0x00000000009fe5df in io_handler_thread (arg=0x13424b0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7f1d20d54710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 11 (Thread 1419): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x2573f38, mp=0x2573ec0, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x2573f38, mutex=0x2573ec0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2573ec0, reset_sig_count=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000ac0fb8 in os_aio_simulated_handle (global_segment=3, message1=0x7f1d13bdee60, message2=0x7f1d13bdee58, type=0x7f1d13bdee50) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0file.c:4944 #5 0x0000000000a7eb7f in fil_aio_wait (segment=3) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/fil/fil0fil.c:4543 #6 0x00000000009fe5df in io_handler_thread (arg=0x13424b8) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7f1d13bdf710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 10 (Thread 1416): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x2573cf8, mp=0x2573c80, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x2573cf8, mutex=0x2573c80) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2573c80, reset_sig_count=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000ac0fb8 in os_aio_simulated_handle (global_segment=0, message1=0x7f1d23673e60, message2=0x7f1d23673e58, type=0x7f1d23673e50) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0file.c:4944 #5 0x0000000000a7eb7f in fil_aio_wait (segment=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/fil/fil0fil.c:4543 #6 0x00000000009fe5df in io_handler_thread (arg=0x13424a0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7f1d23674710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 9 (Thread 1417): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x2573db8, mp=0x2573d40, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x2573db8, mutex=0x2573d40) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2573d40, reset_sig_count=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000ac0fb8 in os_aio_simulated_handle (global_segment=1, message1=0x7f1d21754e60, message2=0x7f1d21754e58, type=0x7f1d21754e50) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0file.c:4944 #5 0x0000000000a7eb7f in fil_aio_wait (segment=1) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/fil/fil0fil.c:4543 #6 0x00000000009fe5df in io_handler_thread (arg=0x13424a8) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7f1d21755710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 8 (Thread 1413): #0 0x00000030e14d7de3 in __poll (fds=, nfds=, timeout=) at ../sysdeps/unix/sysv/linux/poll.c:87 #1 0x000000000056fdf1 in handle_connections_sockets () at /home/sbester/build/bzr/mysql-trunk/sql/mysqld.cc:5347 #2 0x000000000056f282 in mysqld_main (argc=10, argv=0x2116238) at /home/sbester/build/bzr/mysql-trunk/sql/mysqld.cc:4817 #3 0x00000000005670e4 in main (argc=9, argv=0x7ffffa3a5c98) at /home/sbester/build/bzr/mysql-trunk/sql/main.cc:24 Thread 7 (Thread 2438): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x2a1e408, mp=0x2a1e390, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x2a1e408, mutex=0x2a1e390) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2a1e390, reset_sig_count=246) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000a01e22 in sync_array_wait_event (arr=0x214ea30, index=7) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0arr.c:457 #5 0x0000000000a05367 in mutex_spin_wait (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0sync.c:622 #6 0x0000000000a0467f in mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:222 #7 0x0000000000a04758 in pfs_mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:251 #8 0x0000000000aa9769 in lock_wait_table_release_slot (slot=0x7f1d217a8418) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:85 #9 0x0000000000aaa160 in lock_wait_suspend_thread (thr=0x7f1cd0320108) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:336 #10 0x00000000009e1042 in row_mysql_handle_errors (new_err=0x7f1d0f552e48, trx=0x7f1cdc203548, thr=0x7f1cd0320108, savept=0x0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0mysql.c:604 #11 0x00000000009f2399 in row_search_for_mysql (buf=0x7f1cd00bc590 "\377", mode=1, prebuilt=0x7f1cd0382818, match_mode=0, direction=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:4822 #12 0x00000000009bd18e in ha_innobase::index_read (this=0x7f1cd00bc2b0, buf=0x7f1cd00bc590 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6112 #13 0x00000000009bdb66 in ha_innobase::index_first (this=0x7f1cd00bc2b0, buf=0x7f1cd00bc590 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6414 #14 0x00000000009bdd5f in ha_innobase::rnd_next (this=0x7f1cd00bc2b0, buf=0x7f1cd00bc590 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6511 #15 0x000000000075de5e in handler::ha_rnd_next (this=0x7f1cd00bc2b0, buf=0x7f1cd00bc590 "\377") at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2225 #16 0x00000000008334c0 in rr_sequential (info=0x7f1cdc244a38) at /home/sbester/build/bzr/mysql-trunk/sql/records.cc:458 #17 0x000000000064592a in join_init_read_record (tab=0x7f1cdc2449a8) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:18278 #18 0x000000000064391c in sub_select (join=0x7f1cdcc1aea0, join_tab=0x7f1cdc2449a8, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17371 #19 0x0000000000642e6c in do_select (join=0x7f1cdcc1aea0, fields=0x7f1cdcc1b210, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16920 #20 0x0000000000622d2e in JOIN::exec (this=0x7f1cdcc1aea0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #21 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cdcc9d330) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #22 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cdc5f7e10) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #23 0x00000000007e2ddb in Item_singlerow_subselect::bring_value (this=0x7f1cdc5f7e10) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:699 #24 0x00000000007d060a in Item_row::bring_value (this=0x7f1cdc43b5f0) at /home/sbester/build/bzr/mysql-trunk/sql/item_row.cc:210 #25 0x0000000000789249 in Arg_comparator::compare_row (this=0x7f1cdc21b220) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:1597 #26 0x0000000000796f7f in Arg_comparator::compare (this=0x7f1cdc21b220) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.h:88 #27 0x000000000078a75d in Item_func_lt::val_int (this=0x7f1cdc21b170) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:2097 #28 0x00000000007954b9 in Item_cond_xor::val_int (this=0x7f1cdc1f5cf0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:5342 #29 0x0000000000768150 in Item::val_bool (this=0x7f1cdc1f5cf0) at /home/sbester/build/bzr/mysql-trunk/sql/item.cc:200 #30 0x0000000000792fac in Item_cond_and::val_int (this=0x7f1cdcc29830) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:4640 #31 0x000000000069c2be in SQL_SELECT::skip_record (this=0x7f1cdc3f5ff0, thd=0x2b03410, skip_record=0x7f1d0f55389f) at /home/sbester/build/bzr/mysql-trunk/sql/opt_range.h:928 #32 0x0000000000874fdd in JOIN_CACHE::check_match (this=0x7f1cdc578410, rec_ptr=0x7f1cdcb7b0e4 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:2000 #33 0x0000000000874e76 in JOIN_CACHE::generate_full_extensions (this=0x7f1cdc578410, rec_ptr=0x7f1cdcb7b0e4 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1949 #34 0x0000000000874cbb in JOIN_CACHE_BNL::join_matching_records (this=0x7f1cdc578410, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1848 #35 0x0000000000874677 in JOIN_CACHE::join_records (this=0x7f1cdc578410, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1654 #36 0x00000000008747f5 in JOIN_CACHE::join_records (this=0x7f1cdc00cc90, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1700 #37 0x00000000006436a2 in sub_select_cache (join=0x7f1cdc976cb0, join_tab=0x7f1cdc566470, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17174 #38 0x0000000000643865 in sub_select (join=0x7f1cdc976cb0, join_tab=0x7f1cdc5661b8, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17344 #39 0x0000000000642e9e in do_select (join=0x7f1cdc976cb0, fields=0x7f1cdc977020, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16922 #40 0x0000000000622d2e in JOIN::exec (this=0x7f1cdc976cb0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #41 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cdc02f970) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #42 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cdc5f1a10) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #43 0x00000000007e2f4e in Item_singlerow_subselect::val_int (this=0x7f1cdc5f1a10) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:723 #44 0x00000000007bc4b1 in Item_func_set_user_var::check (this=0x7f1cdcc60410, use_result_field=false) at /home/sbester/build/bzr/mysql-trunk/sql/item_func.cc:4542 #45 0x0000000000581ccf in set_var_user::check (this=0x7f1cdcc93fe0, thd=0x2b03410) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:686 #46 0x00000000005817b2 in sql_set_variables (thd=0x2b03410, var_list=0x2b05d38) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:568 #47 0x00000000005f7c55 in mysql_execute_command (thd=0x2b03410) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:3097 #48 0x00000000005fe4a7 in mysql_parse (thd=0x2b03410, rawbuf=0x7f1cdcc33420 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 )", length=1487, parser_state=0x7f1d0f555610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #49 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2b03410, packet=0x2b06611 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 ); ", packet_length=1498) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #50 0x00000000005f1b76 in do_command (thd=0x2b03410) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #51 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2b03410) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #52 0x00000000006d140e in handle_one_connection (arg=0x2b03410) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #53 0x00000030e1807761 in start_thread (arg=0x7f1d0f556710) at pthread_create.c:301 #54 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 6 (Thread 2434): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x2a1e408, mp=0x2a1e390, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x2a1e408, mutex=0x2a1e390) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2a1e390, reset_sig_count=246) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000a01e22 in sync_array_wait_event (arr=0x214ea30, index=5) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0arr.c:457 #5 0x0000000000a05367 in mutex_spin_wait (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0sync.c:622 #6 0x0000000000a0467f in mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:222 #7 0x0000000000a04758 in pfs_mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:251 #8 0x0000000000aa9769 in lock_wait_table_release_slot (slot=0x7f1d217a8398) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:85 #9 0x0000000000aaa160 in lock_wait_suspend_thread (thr=0x7f1cdc51bd88) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:336 #10 0x00000000009e1042 in row_mysql_handle_errors (new_err=0x7f1ccfcefe48, trx=0x7f1cdcbdaab8, thr=0x7f1cdc51bd88, savept=0x0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0mysql.c:604 #11 0x00000000009f2399 in row_search_for_mysql (buf=0x7f1cdc1994a0 "\377", mode=1, prebuilt=0x7f1cdc207008, match_mode=0, direction=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:4822 #12 0x00000000009bd18e in ha_innobase::index_read (this=0x7f1cdc19c5a0, buf=0x7f1cdc1994a0 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6112 #13 0x00000000009bdb66 in ha_innobase::index_first (this=0x7f1cdc19c5a0, buf=0x7f1cdc1994a0 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6414 #14 0x00000000009bdd5f in ha_innobase::rnd_next (this=0x7f1cdc19c5a0, buf=0x7f1cdc1994a0 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6511 #15 0x000000000075de5e in handler::ha_rnd_next (this=0x7f1cdc19c5a0, buf=0x7f1cdc1994a0 "\377") at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2225 #16 0x00000000008334c0 in rr_sequential (info=0x7f1cdc229f88) at /home/sbester/build/bzr/mysql-trunk/sql/records.cc:458 #17 0x000000000064592a in join_init_read_record (tab=0x7f1cdc229ef8) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:18278 #18 0x000000000064391c in sub_select (join=0x7f1cdc96b990, join_tab=0x7f1cdc229ef8, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17371 #19 0x0000000000642e6c in do_select (join=0x7f1cdc96b990, fields=0x7f1cdc96bd00, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16920 #20 0x0000000000622d2e in JOIN::exec (this=0x7f1cdc96b990) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #21 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cdcc2e580) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #22 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cdc997ec0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #23 0x00000000007e2ddb in Item_singlerow_subselect::bring_value (this=0x7f1cdc997ec0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:699 #24 0x00000000007d060a in Item_row::bring_value (this=0x7f1cdc42f7b0) at /home/sbester/build/bzr/mysql-trunk/sql/item_row.cc:210 #25 0x0000000000789249 in Arg_comparator::compare_row (this=0x7f1cdc52d490) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:1597 #26 0x0000000000796f7f in Arg_comparator::compare (this=0x7f1cdc52d490) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.h:88 #27 0x000000000078a75d in Item_func_lt::val_int (this=0x7f1cdc52d3e0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:2097 #28 0x00000000007954b9 in Item_cond_xor::val_int (this=0x7f1cdc556790) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:5342 #29 0x0000000000768150 in Item::val_bool (this=0x7f1cdc556790) at /home/sbester/build/bzr/mysql-trunk/sql/item.cc:200 #30 0x0000000000792fac in Item_cond_and::val_int (this=0x7f1cdc7f43b0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:4640 #31 0x000000000069c2be in SQL_SELECT::skip_record (this=0x7f1cdc242e30, thd=0x2b3e870, skip_record=0x7f1ccfcf089f) at /home/sbester/build/bzr/mysql-trunk/sql/opt_range.h:928 #32 0x0000000000874fdd in JOIN_CACHE::check_match (this=0x7f1cdc53d180, rec_ptr=0x7f1cdc071694 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:2000 #33 0x0000000000874e76 in JOIN_CACHE::generate_full_extensions (this=0x7f1cdc53d180, rec_ptr=0x7f1cdc071694 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1949 #34 0x0000000000874cbb in JOIN_CACHE_BNL::join_matching_records (this=0x7f1cdc53d180, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1848 #35 0x0000000000874677 in JOIN_CACHE::join_records (this=0x7f1cdc53d180, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1654 #36 0x00000000008747f5 in JOIN_CACHE::join_records (this=0x7f1cdc625080, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1700 #37 0x00000000006436a2 in sub_select_cache (join=0x7f1cdc1cf9c0, join_tab=0x7f1cdc9b71b0, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17174 #38 0x0000000000643865 in sub_select (join=0x7f1cdc1cf9c0, join_tab=0x7f1cdc9b6ef8, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17344 #39 0x0000000000642e9e in do_select (join=0x7f1cdc1cf9c0, fields=0x7f1cdc1cfd30, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16922 #40 0x0000000000622d2e in JOIN::exec (this=0x7f1cdc1cf9c0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #41 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cdc1b5510) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #42 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cdc1b53e0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #43 0x00000000007e2f4e in Item_singlerow_subselect::val_int (this=0x7f1cdc1b53e0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:723 #44 0x00000000007bc4b1 in Item_func_set_user_var::check (this=0x7f1cdc622770, use_result_field=false) at /home/sbester/build/bzr/mysql-trunk/sql/item_func.cc:4542 #45 0x0000000000581ccf in set_var_user::check (this=0x7f1cdc406000, thd=0x2b3e870) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:686 #46 0x00000000005817b2 in sql_set_variables (thd=0x2b3e870, var_list=0x2b41198) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:568 #47 0x00000000005f7c55 in mysql_execute_command (thd=0x2b3e870) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:3097 #48 0x00000000005fe4a7 in mysql_parse (thd=0x2b3e870, rawbuf=0x7f1cdc171720 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 )", length=1487, parser_state=0x7f1ccfcf2610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #49 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2b3e870, packet=0x2b41a71 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 ); ", packet_length=1498) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #50 0x00000000005f1b76 in do_command (thd=0x2b3e870) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #51 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2b3e870) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #52 0x00000000006d140e in handle_one_connection (arg=0x2b3e870) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #53 0x00000030e1807761 in start_thread (arg=0x7f1ccfcf3710) at pthread_create.c:301 #54 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 5 (Thread 2431): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x2a1e408, mp=0x2a1e390, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x2a1e408, mutex=0x2a1e390) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2a1e390, reset_sig_count=246) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000a01e22 in sync_array_wait_event (arr=0x214ea30, index=4) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0arr.c:457 #5 0x0000000000a05367 in mutex_spin_wait (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0sync.c:622 #6 0x0000000000a0467f in mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:222 #7 0x0000000000a04758 in pfs_mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:251 #8 0x0000000000aa9769 in lock_wait_table_release_slot (slot=0x7f1d217a8358) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:85 #9 0x0000000000aaa160 in lock_wait_suspend_thread (thr=0x7f1cdc5bff38) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:336 #10 0x00000000009e1042 in row_mysql_handle_errors (new_err=0x7f1ccfffbe48, trx=0x7f1cd02522d8, thr=0x7f1cdc5bff38, savept=0x0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0mysql.c:604 #11 0x00000000009f2399 in row_search_for_mysql (buf=0x7f1cdc5b25d0 "\377", mode=1, prebuilt=0x7f1cdc9bf328, match_mode=0, direction=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:4822 #12 0x00000000009bd18e in ha_innobase::index_read (this=0x7f1cdc98b190, buf=0x7f1cdc5b25d0 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6112 #13 0x00000000009bdb66 in ha_innobase::index_first (this=0x7f1cdc98b190, buf=0x7f1cdc5b25d0 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6414 #14 0x00000000009bdd5f in ha_innobase::rnd_next (this=0x7f1cdc98b190, buf=0x7f1cdc5b25d0 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6511 #15 0x000000000075de5e in handler::ha_rnd_next (this=0x7f1cdc98b190, buf=0x7f1cdc5b25d0 "\377") at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2225 #16 0x00000000008334c0 in rr_sequential (info=0x7f1cd0088378) at /home/sbester/build/bzr/mysql-trunk/sql/records.cc:458 #17 0x000000000064592a in join_init_read_record (tab=0x7f1cd00882e8) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:18278 #18 0x000000000064391c in sub_select (join=0x7f1cd02d6190, join_tab=0x7f1cd00882e8, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17371 #19 0x0000000000642e6c in do_select (join=0x7f1cd02d6190, fields=0x7f1cd02d6500, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16920 #20 0x0000000000622d2e in JOIN::exec (this=0x7f1cd02d6190) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #21 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cd031dd60) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #22 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cd031dc30) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #23 0x00000000007e2ddb in Item_singlerow_subselect::bring_value (this=0x7f1cd031dc30) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:699 #24 0x00000000007d060a in Item_row::bring_value (this=0x7f1cd00ddf20) at /home/sbester/build/bzr/mysql-trunk/sql/item_row.cc:210 #25 0x0000000000789249 in Arg_comparator::compare_row (this=0x7f1cd00de0b0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:1597 #26 0x0000000000796f7f in Arg_comparator::compare (this=0x7f1cd00de0b0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.h:88 #27 0x000000000078a75d in Item_func_lt::val_int (this=0x7f1cd00de000) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:2097 #28 0x00000000007954b9 in Item_cond_xor::val_int (this=0x7f1cd00de1a0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:5342 #29 0x0000000000768150 in Item::val_bool (this=0x7f1cd00de1a0) at /home/sbester/build/bzr/mysql-trunk/sql/item.cc:200 #30 0x0000000000792fac in Item_cond_and::val_int (this=0x7f1cd0212760) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:4640 #31 0x000000000069c2be in SQL_SELECT::skip_record (this=0x7f1cd02128f0, thd=0x2c16c00, skip_record=0x7f1ccfffc89f) at /home/sbester/build/bzr/mysql-trunk/sql/opt_range.h:928 #32 0x0000000000874fdd in JOIN_CACHE::check_match (this=0x7f1cd0017050, rec_ptr=0x7f1cd02b3344 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:2000 #33 0x0000000000874e76 in JOIN_CACHE::generate_full_extensions (this=0x7f1cd0017050, rec_ptr=0x7f1cd02b3344 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1949 #34 0x0000000000874cbb in JOIN_CACHE_BNL::join_matching_records (this=0x7f1cd0017050, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1848 #35 0x0000000000874677 in JOIN_CACHE::join_records (this=0x7f1cd0017050, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1654 #36 0x00000000008747f5 in JOIN_CACHE::join_records (this=0x7f1cd0016eb0, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1700 #37 0x00000000006436a2 in sub_select_cache (join=0x7f1cd02d5940, join_tab=0x7f1cd0211cd0, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17174 #38 0x0000000000643865 in sub_select (join=0x7f1cd02d5940, join_tab=0x7f1cd0211a18, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17344 #39 0x0000000000642e9e in do_select (join=0x7f1cd02d5940, fields=0x7f1cd02d5cb0, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16922 #40 0x0000000000622d2e in JOIN::exec (this=0x7f1cd02d5940) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #41 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cd00de4f0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #42 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cd00de3c0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #43 0x00000000007e2f4e in Item_singlerow_subselect::val_int (this=0x7f1cd00de3c0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:723 #44 0x00000000007bc4b1 in Item_func_set_user_var::check (this=0x7f1cd03802e0, use_result_field=false) at /home/sbester/build/bzr/mysql-trunk/sql/item_func.cc:4542 #45 0x0000000000581ccf in set_var_user::check (this=0x7f1cd00de550, thd=0x2c16c00) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:686 #46 0x00000000005817b2 in sql_set_variables (thd=0x2c16c00, var_list=0x2c19528) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:568 #47 0x00000000005f7c55 in mysql_execute_command (thd=0x2c16c00) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:3097 #48 0x00000000005fe4a7 in mysql_parse (thd=0x2c16c00, rawbuf=0x7f1cd028b3c0 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 )", length=1487, parser_state=0x7f1ccfffe610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #49 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2c16c00, packet=0x2b80321 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 ); ", packet_length=1498) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #50 0x00000000005f1b76 in do_command (thd=0x2c16c00) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #51 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2c16c00) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #52 0x00000000006d140e in handle_one_connection (arg=0x2c16c00) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #53 0x00000030e1807761 in start_thread (arg=0x7f1ccffff710) at pthread_create.c:301 #54 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 4 (Thread 2422): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x2a1e408, mp=0x2a1e390, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x2a1e408, mutex=0x2a1e390) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2a1e390, reset_sig_count=246) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000a01e22 in sync_array_wait_event (arr=0x214ea30, index=6) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0arr.c:457 #5 0x0000000000a05367 in mutex_spin_wait (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0sync.c:622 #6 0x0000000000a0467f in mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:222 #7 0x0000000000a04758 in pfs_mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:251 #8 0x0000000000aa9769 in lock_wait_table_release_slot (slot=0x7f1d217a83d8) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:85 #9 0x0000000000aaa160 in lock_wait_suspend_thread (thr=0x7f1cd0333bb8) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:336 #10 0x00000000009e1042 in row_mysql_handle_errors (new_err=0x7f1ccfe34e48, trx=0x7f1cec03a2a8, thr=0x7f1cd0333bb8, savept=0x0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0mysql.c:604 #11 0x00000000009f2399 in row_search_for_mysql (buf=0x7f1cd025ca10 "\377", mode=1, prebuilt=0x7f1cd0005e58, match_mode=0, direction=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:4822 #12 0x00000000009bd18e in ha_innobase::index_read (this=0x7f1cd0005340, buf=0x7f1cd025ca10 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6112 #13 0x00000000009bdb66 in ha_innobase::index_first (this=0x7f1cd0005340, buf=0x7f1cd025ca10 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6414 #14 0x00000000009bdd5f in ha_innobase::rnd_next (this=0x7f1cd0005340, buf=0x7f1cd025ca10 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6511 #15 0x000000000075de5e in handler::ha_rnd_next (this=0x7f1cd0005340, buf=0x7f1cd025ca10 "\377") at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2225 #16 0x00000000008334c0 in rr_sequential (info=0x7f1cec25ade8) at /home/sbester/build/bzr/mysql-trunk/sql/records.cc:458 #17 0x000000000064592a in join_init_read_record (tab=0x7f1cec25ad58) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:18278 #18 0x000000000064391c in sub_select (join=0x7f1cec14b840, join_tab=0x7f1cec25ad58, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17371 #19 0x0000000000642e6c in do_select (join=0x7f1cec14b840, fields=0x7f1cec14bbb0, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16920 #20 0x0000000000622d2e in JOIN::exec (this=0x7f1cec14b840) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #21 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cec12cba0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #22 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cec138740) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #23 0x00000000007e2ddb in Item_singlerow_subselect::bring_value (this=0x7f1cec138740) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:699 #24 0x00000000007d060a in Item_row::bring_value (this=0x7f1cec11b430) at /home/sbester/build/bzr/mysql-trunk/sql/item_row.cc:210 #25 0x0000000000789249 in Arg_comparator::compare_row (this=0x7f1cec2a5840) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:1597 #26 0x0000000000796f7f in Arg_comparator::compare (this=0x7f1cec2a5840) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.h:88 #27 0x000000000078a75d in Item_func_lt::val_int (this=0x7f1cec2a5790) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:2097 #28 0x00000000007954b9 in Item_cond_xor::val_int (this=0x7f1cec2a6bb0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:5342 #29 0x0000000000768150 in Item::val_bool (this=0x7f1cec2a6bb0) at /home/sbester/build/bzr/mysql-trunk/sql/item.cc:200 #30 0x0000000000792fac in Item_cond_and::val_int (this=0x7f1cec1205c0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:4640 #31 0x000000000069c2be in SQL_SELECT::skip_record (this=0x7f1cec1e0280, thd=0x2b844f0, skip_record=0x7f1ccfe3589f) at /home/sbester/build/bzr/mysql-trunk/sql/opt_range.h:928 #32 0x0000000000874fdd in JOIN_CACHE::check_match (this=0x7f1cec0e1000, rec_ptr=0x7f1cec089f34 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:2000 #33 0x0000000000874e76 in JOIN_CACHE::generate_full_extensions (this=0x7f1cec0e1000, rec_ptr=0x7f1cec089f34 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1949 #34 0x0000000000874cbb in JOIN_CACHE_BNL::join_matching_records (this=0x7f1cec0e1000, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1848 #35 0x0000000000874677 in JOIN_CACHE::join_records (this=0x7f1cec0e1000, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1654 #36 0x00000000008747f5 in JOIN_CACHE::join_records (this=0x7f1cec100b90, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1700 #37 0x00000000006436a2 in sub_select_cache (join=0x7f1cec1a28c0, join_tab=0x7f1cec1c0030, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17174 #38 0x0000000000643865 in sub_select (join=0x7f1cec1a28c0, join_tab=0x7f1cec1bfd78, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17344 #39 0x0000000000642e9e in do_select (join=0x7f1cec1a28c0, fields=0x7f1cec1a2c30, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16922 #40 0x0000000000622d2e in JOIN::exec (this=0x7f1cec1a28c0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #41 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cec2a6d10) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #42 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cec295430) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #43 0x00000000007e2f4e in Item_singlerow_subselect::val_int (this=0x7f1cec295430) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:723 #44 0x00000000007bc4b1 in Item_func_set_user_var::check (this=0x7f1cec1d9ab0, use_result_field=false) at /home/sbester/build/bzr/mysql-trunk/sql/item_func.cc:4542 #45 0x0000000000581ccf in set_var_user::check (this=0x7f1cec295520, thd=0x2b844f0) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:686 #46 0x00000000005817b2 in sql_set_variables (thd=0x2b844f0, var_list=0x2b86e18) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:568 #47 0x00000000005f7c55 in mysql_execute_command (thd=0x2b844f0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:3097 #48 0x00000000005fe4a7 in mysql_parse (thd=0x2b844f0, rawbuf=0x7f1cec1ee190 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 )", length=1487, parser_state=0x7f1ccfe37610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #49 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2b844f0, packet=0x2b64451 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 ); ", packet_length=1498) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #50 0x00000000005f1b76 in do_command (thd=0x2b844f0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #51 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2b844f0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #52 0x00000000006d140e in handle_one_connection (arg=0x2b844f0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #53 0x00000030e1807761 in start_thread (arg=0x7f1ccfe38710) at pthread_create.c:301 #54 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 3 (Thread 2421): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000918bf5 in safe_cond_wait (cond=0x2a1e408, mp=0x2a1e390, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:240 #2 0x0000000000ac2202 in os_cond_wait (cond=0x2a1e408, mutex=0x2a1e390) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:207 #3 0x0000000000ac2aa3 in os_event_wait_low (event=0x2a1e390, reset_sig_count=246) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:634 #4 0x0000000000a01e22 in sync_array_wait_event (arr=0x214ea30, index=8) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0arr.c:457 #5 0x0000000000a05367 in mutex_spin_wait (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0sync.c:622 #6 0x0000000000a0467f in mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:222 #7 0x0000000000a04758 in pfs_mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:251 #8 0x0000000000aa9769 in lock_wait_table_release_slot (slot=0x7f1d217a8458) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:85 #9 0x0000000000aaa160 in lock_wait_suspend_thread (thr=0x7f1cdc173608) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:336 #10 0x00000000009e1042 in row_mysql_handle_errors (new_err=0x7f1ccfef7e48, trx=0x7f1cd01322d8, thr=0x7f1cdc173608, savept=0x0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0mysql.c:604 #11 0x00000000009f2399 in row_search_for_mysql (buf=0x7f1cdc43e690 "\377", mode=1, prebuilt=0x7f1cdc18e818, match_mode=0, direction=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:4822 #12 0x00000000009bd18e in ha_innobase::index_read (this=0x7f1cdc665740, buf=0x7f1cdc43e690 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6112 #13 0x00000000009bdb66 in ha_innobase::index_first (this=0x7f1cdc665740, buf=0x7f1cdc43e690 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6414 #14 0x00000000009bdd5f in ha_innobase::rnd_next (this=0x7f1cdc665740, buf=0x7f1cdc43e690 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6511 #15 0x000000000075de5e in handler::ha_rnd_next (this=0x7f1cdc665740, buf=0x7f1cdc43e690 "\377") at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2225 #16 0x00000000008334c0 in rr_sequential (info=0x7f1cd0018c48) at /home/sbester/build/bzr/mysql-trunk/sql/records.cc:458 #17 0x000000000064592a in join_init_read_record (tab=0x7f1cd0018bb8) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:18278 #18 0x000000000064391c in sub_select (join=0x7f1cd0047a80, join_tab=0x7f1cd0018bb8, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17371 #19 0x0000000000642e6c in do_select (join=0x7f1cd0047a80, fields=0x7f1cd0047df0, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16920 #20 0x0000000000622d2e in JOIN::exec (this=0x7f1cd0047a80) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #21 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cd0328ed0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #22 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cd0328da0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #23 0x00000000007e2ddb in Item_singlerow_subselect::bring_value (this=0x7f1cd0328da0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:699 #24 0x00000000007d060a in Item_row::bring_value (this=0x7f1cd0111c40) at /home/sbester/build/bzr/mysql-trunk/sql/item_row.cc:210 #25 0x0000000000789249 in Arg_comparator::compare_row (this=0x7f1cd012c8e0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:1597 #26 0x0000000000796f7f in Arg_comparator::compare (this=0x7f1cd012c8e0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.h:88 #27 0x000000000078a75d in Item_func_lt::val_int (this=0x7f1cd012c830) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:2097 #28 0x00000000007954b9 in Item_cond_xor::val_int (this=0x7f1cd0111d20) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:5342 #29 0x0000000000768150 in Item::val_bool (this=0x7f1cd0111d20) at /home/sbester/build/bzr/mysql-trunk/sql/item.cc:200 #30 0x0000000000792fac in Item_cond_and::val_int (this=0x7f1cd014c670) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:4640 #31 0x000000000069c2be in SQL_SELECT::skip_record (this=0x7f1cd0059cf0, thd=0x2b18d10, skip_record=0x7f1ccfef889f) at /home/sbester/build/bzr/mysql-trunk/sql/opt_range.h:928 #32 0x0000000000874fdd in JOIN_CACHE::check_match (this=0x7f1cd00df990, rec_ptr=0x7f1cd022b354 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:2000 #33 0x0000000000874e76 in JOIN_CACHE::generate_full_extensions (this=0x7f1cd00df990, rec_ptr=0x7f1cd022b354 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1949 #34 0x0000000000874cbb in JOIN_CACHE_BNL::join_matching_records (this=0x7f1cd00df990, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1848 #35 0x0000000000874677 in JOIN_CACHE::join_records (this=0x7f1cd00df990, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1654 #36 0x00000000008747f5 in JOIN_CACHE::join_records (this=0x7f1cd00993b0, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1700 #37 0x00000000006436a2 in sub_select_cache (join=0x7f1cd0047590, join_tab=0x7f1cd0335dd0, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17174 #38 0x0000000000643865 in sub_select (join=0x7f1cd0047590, join_tab=0x7f1cd0335b18, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17344 #39 0x0000000000642e9e in do_select (join=0x7f1cd0047590, fields=0x7f1cd0047900, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16922 #40 0x0000000000622d2e in JOIN::exec (this=0x7f1cd0047590) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #41 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cd007cf20) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #42 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cd007cdf0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #43 0x00000000007e2f4e in Item_singlerow_subselect::val_int (this=0x7f1cd007cdf0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:723 #44 0x00000000007bc4b1 in Item_func_set_user_var::check (this=0x7f1cd00e6ba0, use_result_field=false) at /home/sbester/build/bzr/mysql-trunk/sql/item_func.cc:4542 #45 0x0000000000581ccf in set_var_user::check (this=0x7f1cd007cf80, thd=0x2b18d10) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:686 #46 0x00000000005817b2 in sql_set_variables (thd=0x2b18d10, var_list=0x2b1b638) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:568 #47 0x00000000005f7c55 in mysql_execute_command (thd=0x2b18d10) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:3097 #48 0x00000000005fe4a7 in mysql_parse (thd=0x2b18d10, rawbuf=0x7f1cd028ea40 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 )", length=1487, parser_state=0x7f1ccfefa610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #49 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2b18d10, packet=0x2b571e1 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 ); ", packet_length=1498) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #50 0x00000000005f1b76 in do_command (thd=0x2b18d10) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #51 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2b18d10) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #52 0x00000000006d140e in handle_one_connection (arg=0x2b18d10) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #53 0x00000030e1807761 in start_thread (arg=0x7f1ccfefb710) at pthread_create.c:301 #54 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 2 (Thread 2425): #0 __lll_unlock_wake () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:366 #1 0x00000030e180a687 in _L_unlock_657 () from /lib64/libpthread-2.12.so #2 0x00000030e180a5ef in __pthread_mutex_unlock_usercnt (mutex=0x2a1e3b8) at pthread_mutex_unlock.c:52 #3 __pthread_mutex_unlock (mutex=0x2a1e3b8) at pthread_mutex_unlock.c:290 #4 0x0000000000918a26 in safe_mutex_unlock (mp=0x2a1e390, file=0xcb8e30 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c", line=918) at /home/sbester/build/bzr/mysql-trunk/mysys/thr_mutex.c:200 #5 0x0000000000ac31a0 in os_fast_mutex_unlock (fast_mutex=0x2a1e390) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:918 #6 0x0000000000ac2a72 in os_event_wait_low (event=0x2a1e390, reset_sig_count=246) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/os/os0sync.c:623 #7 0x0000000000a01e22 in sync_array_wait_event (arr=0x214ea30, index=3) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0arr.c:457 #8 0x0000000000a05367 in mutex_spin_wait (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/sync/sync0sync.c:622 #9 0x0000000000a0467f in mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:222 #10 0x0000000000a04758 in pfs_mutex_enter_func (mutex=0x7f1d217a8128, file_name=0xcb3ea0 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c", line=85) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/include/sync0sync.ic:251 #11 0x0000000000aa9769 in lock_wait_table_release_slot (slot=0x7f1d217a8318) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:85 #12 0x0000000000aaa160 in lock_wait_suspend_thread (thr=0x7f1cec24ba48) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/lock/lock0wait.c:336 #13 0x00000000009e1042 in row_mysql_handle_errors (new_err=0x7f1ccfdf3e48, trx=0x7f1cdc57c188, thr=0x7f1cec24ba48, savept=0x0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0mysql.c:604 #14 0x00000000009f2399 in row_search_for_mysql (buf=0x7f1cec040f20 "\377", mode=1, prebuilt=0x7f1cec0417d8, match_mode=0, direction=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:4822 #15 0x00000000009bd18e in ha_innobase::index_read (this=0x7f1cec040c40, buf=0x7f1cec040f20 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6112 #16 0x00000000009bdb66 in ha_innobase::index_first (this=0x7f1cec040c40, buf=0x7f1cec040f20 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6414 #17 0x00000000009bdd5f in ha_innobase::rnd_next (this=0x7f1cec040c40, buf=0x7f1cec040f20 "\377") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6511 #18 0x000000000075de5e in handler::ha_rnd_next (this=0x7f1cec040c40, buf=0x7f1cec040f20 "\377") at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2225 #19 0x00000000008334c0 in rr_sequential (info=0x7f1cdc40df58) at /home/sbester/build/bzr/mysql-trunk/sql/records.cc:458 #20 0x000000000064592a in join_init_read_record (tab=0x7f1cdc40dec8) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:18278 #21 0x000000000064391c in sub_select (join=0x7f1cdc04fe50, join_tab=0x7f1cdc40dec8, end_of_records=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17371 #22 0x0000000000642e6c in do_select (join=0x7f1cdc04fe50, fields=0x7f1cdc0501c0, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16920 #23 0x0000000000622d2e in JOIN::exec (this=0x7f1cdc04fe50) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #24 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cdc664070) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #25 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cdc613fe0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #26 0x00000000007e2ddb in Item_singlerow_subselect::bring_value (this=0x7f1cdc613fe0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:699 #27 0x00000000007d060a in Item_row::bring_value (this=0x7f1cdc1f2640) at /home/sbester/build/bzr/mysql-trunk/sql/item_row.cc:210 #28 0x0000000000789249 in Arg_comparator::compare_row (this=0x7f1cdc59e880) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:1597 #29 0x0000000000796f7f in Arg_comparator::compare (this=0x7f1cdc59e880) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.h:88 #30 0x000000000078a75d in Item_func_lt::val_int (this=0x7f1cdc59e7d0) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:2097 #31 0x00000000007954b9 in Item_cond_xor::val_int (this=0x7f1cdc008a30) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:5342 #32 0x0000000000768150 in Item::val_bool (this=0x7f1cdc008a30) at /home/sbester/build/bzr/mysql-trunk/sql/item.cc:200 #33 0x0000000000792fac in Item_cond_and::val_int (this=0x7f1cdc1c5590) at /home/sbester/build/bzr/mysql-trunk/sql/item_cmpfunc.cc:4640 #34 0x000000000069c2be in SQL_SELECT::skip_record (this=0x7f1cdc682600, thd=0x2c13a00, skip_record=0x7f1ccfdf489f) at /home/sbester/build/bzr/mysql-trunk/sql/opt_range.h:928 #35 0x0000000000874fdd in JOIN_CACHE::check_match (this=0x7f1cdc630950, rec_ptr=0x7f1cdcb3b0c4 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:2000 #36 0x0000000000874e76 in JOIN_CACHE::generate_full_extensions (this=0x7f1cdc630950, rec_ptr=0x7f1cdcb3b0c4 ) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1949 #37 0x0000000000874cbb in JOIN_CACHE_BNL::join_matching_records (this=0x7f1cdc630950, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1848 #38 0x0000000000874677 in JOIN_CACHE::join_records (this=0x7f1cdc630950, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1654 #39 0x00000000008747f5 in JOIN_CACHE::join_records (this=0x7f1cdc5a1330, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1700 #40 0x00000000006436a2 in sub_select_cache (join=0x7f1cdcbf2d80, join_tab=0x7f1cdc03f240, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17174 #41 0x0000000000643865 in sub_select (join=0x7f1cdcbf2d80, join_tab=0x7f1cdc03ef88, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17344 #42 0x0000000000642e9e in do_select (join=0x7f1cdcbf2d80, fields=0x7f1cdcbf30f0, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16922 #43 0x0000000000622d2e in JOIN::exec (this=0x7f1cdcbf2d80) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #44 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cdc5860d0) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #45 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cdc999130) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #46 0x00000000007e2f4e in Item_singlerow_subselect::val_int (this=0x7f1cdc999130) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:723 #47 0x00000000007bc4b1 in Item_func_set_user_var::check (this=0x7f1cdcc9f5f0, use_result_field=false) at /home/sbester/build/bzr/mysql-trunk/sql/item_func.cc:4542 #48 0x0000000000581ccf in set_var_user::check (this=0x7f1cdcbf6820, thd=0x2c13a00) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:686 #49 0x00000000005817b2 in sql_set_variables (thd=0x2c13a00, var_list=0x2c16328) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:568 #50 0x00000000005f7c55 in mysql_execute_command (thd=0x2c13a00) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:3097 #51 0x00000000005fe4a7 in mysql_parse (thd=0x2c13a00, rawbuf=0x7f1cdcc72160 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 )", length=1487, parser_state=0x7f1ccfdf6610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #52 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2c13a00, packet=0x2b7c311 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 ); ", packet_length=1498) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #53 0x00000000005f1b76 in do_command (thd=0x2c13a00) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #54 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2c13a00) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #55 0x00000000006d140e in handle_one_connection (arg=0x2c13a00) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #56 0x00000030e1807761 in start_thread (arg=0x7f1ccfdf7710) at pthread_create.c:301 #57 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 1 (Thread 2420): #0 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #1 0x00000030e1434185 in abort () at abort.c:92 #2 0x00000000009f0621 in row_search_for_mysql (buf=0x7f1cf801cb40 "\376", mode=1, prebuilt=0x7f1cf801d908, match_mode=0, direction=1) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:3869 #3 0x00000000009bd92c in ha_innobase::general_fetch (this=0x7f1cf801c860, buf=0x7f1cf801cb40 "\376", direction=1, match_mode=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6325 #4 0x00000000009bdd9d in ha_innobase::rnd_next (this=0x7f1cf801c860, buf=0x7f1cf801cb40 "\376") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6519 #5 0x000000000075de5e in handler::ha_rnd_next (this=0x7f1cf801c860, buf=0x7f1cf801cb40 "\376") at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2225 #6 0x00000000008334c0 in rr_sequential (info=0x7f1cdc0627d8) at /home/sbester/build/bzr/mysql-trunk/sql/records.cc:458 #7 0x0000000000874cf0 in JOIN_CACHE_BNL::join_matching_records (this=0x7f1cdc62d8f0, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1805 #8 0x0000000000874677 in JOIN_CACHE::join_records (this=0x7f1cdc62d8f0, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1654 #9 0x00000000008747f5 in JOIN_CACHE::join_records (this=0x7f1cdc1d0540, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1700 #10 0x00000000006436a2 in sub_select_cache (join=0x7f1cdc18d420, join_tab=0x7f1cdc062490, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17174 #11 0x0000000000643865 in sub_select (join=0x7f1cdc18d420, join_tab=0x7f1cdc0621d8, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17344 #12 0x0000000000642e9e in do_select (join=0x7f1cdc18d420, fields=0x7f1cdc18d790, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16922 #13 0x0000000000622d2e in JOIN::exec (this=0x7f1cdc18d420) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 #14 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cdc95a100) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 #15 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cdc606000) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 #16 0x00000000007e2f4e in Item_singlerow_subselect::val_int (this=0x7f1cdc606000) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:723 #17 0x00000000007bc4b1 in Item_func_set_user_var::check (this=0x7f1cdcc94290, use_result_field=false) at /home/sbester/build/bzr/mysql-trunk/sql/item_func.cc:4542 #18 0x0000000000581ccf in set_var_user::check (this=0x7f1cdcc97920, thd=0x2b96f70) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:686 #19 0x00000000005817b2 in sql_set_variables (thd=0x2b96f70, var_list=0x2b99898) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:568 #20 0x00000000005f7c55 in mysql_execute_command (thd=0x2b96f70) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:3097 #21 0x00000000005fe4a7 in mysql_parse (thd=0x2b96f70, rawbuf=0x7f1cdc452870 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 )", length=1487, parser_state=0x7f1ccff7c610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #22 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2b96f70, packet=0x2e1d271 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 ); ", packet_length=1498) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #23 0x00000000005f1b76 in do_command (thd=0x2b96f70) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #24 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2b96f70) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #25 0x00000000006d140e in handle_one_connection (arg=0x2b96f70) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #26 0x00000030e1807761 in start_thread (arg=0x7f1ccff7d710) at pthread_create.c:301 #27 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 (gdb) (gdb) thread 1 [Switching to thread 1 (Thread 2420)]#0 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 64 return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig); (gdb) frame 2 #2 0x00000000009f0621 in row_search_for_mysql (buf=0x7f1cf801cb40 "\376", mode=1, prebuilt=0x7f1cf801d908, match_mode=0, direction=1) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:3869 3869 ut_ad(prebuilt->sql_stat_start || trx->state == TRX_STATE_ACTIVE); (gdb) print *prebuilt $1 = { magic_n = 78540783, table = 0x7f1cd811e818, index = 0x7f1cd8138ec8, trx = 0x7f1cdc181fd8, sql_stat_start = 0, mysql_has_locked = 1, clust_index_was_generated = 0, index_usable = 1, read_just_key = 0, used_in_HANDLER = 0, template_type = 1, n_template = 2, null_bitmap_len = 1, need_to_access_clustered = 1, templ_contains_blob = 0, mysql_template = 0x7f1cf807b2e8, heap = 0x7f1cf801d890, ins_node = 0x0, ins_upd_rec_buff = 0x0, default_rec = 0x7f1cd8007b70 "\377", hint_need_to_fetch_extra_cols = 0, upd_node = 0x0, ins_graph = 0x0, upd_graph = 0x0, pcur = 0x7f1cf801db88, clust_pcur = 0x7f1cf801dcf8, sel_graph = 0x7f1cf801e180, search_tuple = 0x7f1cf801de68, row_id = "\000\000\000\000\000", clust_ref = 0x7f1cf801e020, select_lock_type = 2, stored_select_lock_type = 2, row_read_type = 0, new_rec_locks = 0, mysql_prefix_len = 21, mysql_row_len = 206, n_rows_fetched = 1, fetch_direction = 1, fetch_cache = {[0] = 0x7f1cd83db77c "\377", [1] = 0x7f1cd83db8dc "", [2] = 0x7f1cd83dba3c "", [3] = 0x7f1cd83dbb9c "", [4] = 0x7f1cd83dbcfc "", [5] = 0x7f1cd83dbe5c "", [6] = 0x7f1cd83dbfbc "", [7] = 0x7f1cd83dc11c ""}, keep_other_fields_on_keyread = 0, fetch_cache_first = 0, n_fetch_cached = 0, blob_heap = 0x0, old_vers_heap = 0x0, autoinc_last_value = 0, autoinc_increment = 1, autoinc_offset = 0, autoinc_error = 0, idx_cond = 0x0, idx_cond_n_cols = 0, magic_n2 = 78540783 } (gdb) print *trx $2 = { magic_n = 91118598, mutex = { event = 0x7f1cdc7ea780, lock_word = 0 '\000', waiters = 0, list = { prev = 0x7f1cdc1822c8, next = 0x7f1cec00ad38 }, cfile_name = 0xc968e8 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/trx/trx0trx.c", cline = 103, thread_id = 18446744073709551615, magic_n = 979585, count_os_wait = 1, count_using = 770931, count_spin_loop = 2, count_spin_rounds = 30, count_os_yield = 1, lspent_time = 0, lmax_spent_time = 0, cmutex_name = 0xc9692b "&trx->mutex", mutex_type = 0, pfs_psi = 0x0 }, state = TRX_STATE_NOT_STARTED, lock = { n_active_thrs = 0, que_state = TRX_QUE_RUNNING, wait_lock = 0x0, deadlock_mark = 0, was_chosen_as_deadlock_victim = 0, wait_started = 1295031732, wait_thr = 0x0, lock_heap = 0x7f1cdc1e5720, trx_locks = { count = 0, start = 0x0, end = 0x0 } }, op_info = 0xc8db2b "fetching rows", isolation_level = 2, check_foreigns = 1, is_registered = 1, owns_prepare_mutex = 0, check_unique_secondary = 1, support_xa = 1, flush_log_later = 0, must_flush_log_later = 0, duplicates = 0, has_search_latch = 0, search_latch_timeout = 10000, dict_operation = TRX_DICT_OP_NONE, declared_to_be_inside_innodb = 0, n_tickets_to_enter_innodb = 0, dict_operation_lock_mode = 0, is_recovered = 0, no = 18446744073709551615, start_time = 1295031732, id = 859932, xid = { formatID = -1, gtrid_length = 0, bqual_length = 0, data = '\000' }, commit_lsn = 0, table_id = 0, mysql_thd = 0x2b96f70, mysql_log_file_name = 0x1338fe0 "", mysql_log_offset = 0, mysql_thread_id = 139761724938000, mysql_process_no = 1413, n_mysql_tables_in_use = 12, mysql_n_tables_locked = 12, trx_list = { prev = 0x7f1cdc57c188, next = 0x7f1cdc4326d8 }, mysql_trx_list = { prev = 0x7f1cd01322d8, next = 0x7f1cec00aa48 }, error_state = DB_SUCCESS, error_info = 0x0, error_key_num = 0, sess = 0x2a88ad8, graph = 0x7f1cdc804258, global_read_view_heap = 0x7f1cdcc64ac0, global_read_view = 0x0, read_view = 0x0, trx_savepoints = { count = 0, start = 0x0, end = 0x0 }, undo_mutex = { event = 0x7f1cdc1982b0, lock_word = 0 '\000', waiters = 0, list = { prev = 0x7f1cd01322e0, next = 0x7f1cdc181fe0 }, cfile_name = 0xc968e8 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/trx/trx0trx.c", cline = 120, thread_id = 18446744073709551615, magic_n = 979585, count_os_wait = 0, count_using = 1, count_spin_loop = 0, count_spin_rounds = 0, count_os_yield = 0, lspent_time = 0, lmax_spent_time = 0, cmutex_name = 0xc96937 "&trx->undo_mutex", mutex_type = 0, pfs_psi = 0x0 }, undo_no = 0, last_sql_stat_start = { least_undo_no = 0 }, rseg = 0x0, insert_undo = 0x0, update_undo = 0x0, roll_limit = 0, pages_undone = 0, undo_no_arr = 0x7f1cdcc6b788, n_autoinc_rows = 0, autoinc_locks = 0x7f1cdc7f1048, detailed_error = '\000' } (gdb) (gdb) bt full #0 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 resultvar = 0 pid = selftid = 2420 #1 0x00000030e1434185 in abort () at abort.c:92 save_stage = 2 act = { __sigaction_handler = { sa_handler = 0x7f1ccff79df0, sa_sigaction = 0x7f1ccff79df0 }, sa_mask = warning: can't find linker symbol for virtual table for `(null)' value { __val = {[0] = 209937821416, [1] = 206158430232, [2] = 139761724923328, [3] = 139761724923136, [4] = 209938119367, [5] = 0, [6] = 209938366985, [7] = 0, [8] = 209937961731, [9] = 139761724938000, [10] = 404, [11] = 209941141600, [12] = 404, [13] = 404, [14] = 209937961418, [15] = 139761724923248} }, sa_flags = -512255904, sa_restorer = 0x194 } sigs = { __val = {[0] = 32, [1] = 0 } } #2 0x00000000009f0621 in row_search_for_mysql (buf=0x7f1cf801cb40 "\376", mode=1, prebuilt=0x7f1cf801d908, match_mode=0, direction=1) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/row/row0sel.c:3869 index = 0x7f1cd8138ec8 comp = 1 search_tuple = 0x7f1cf801de68 pcur = 0x7f1cf801db88 trx = 0x7f1cdc181fd8 clust_index = 0x0 thr = 0x7f1ccff7a6e0 rec = 0x40f9035000000000
result_rec = 0x10000dc1e9540
clust_rec = 0x0 err = 10 unique_search = 0 mtr_has_extra_clust_latch = 0 moves_up = 0 set_also_gap_locks = 1 did_semi_consistent_read = 0 next_offs = 11607533 same_user_rec = 139761724925664 mtr = { state = 12231, memo = { heap = 0x0, used = 0, data = "\267 \261\000\000\000\000\000X\361\"\334\034\177\000\000\003^\273\000\000\000\000\000\b\000\000\000\060\000\000\000\300\242\367\317\034\177\000\000\000\242\367\317\034\177\000\000@\226\036\334\034\177\000\000P\276\301\334\034\177\000\000\030\237\271\002\000\000\000\000 \242\367\317\034\177\000\000\000\000\000\000\000\000\000\000\374]\273\000\000\000\000\000\240r\241\341\060\000\000\000\225\000\000\000\000\000\000\000\020", '\000' "\340, \321#\334\034\177\000\000\220\366\220\000\000\000\000\000A\\\273\000\000\000\000\000@\225\036\334\034\177\000\000\200\242\367\317\034\177\000\000\355\367\260\000\000\000\000\000P\276\301\334\034\177\000\000@\226\036\334\034\177\000\000\260\242\367\317\034\177\000\000\251\037\261\000\000\000\000\000\374]\273\000\000\000\000\000L\\\273\000\021\r\000\000\000\000\000\000\017\000\000\000P\276\301\334\034\177\000\000\260\243\367\317\034\177\000\000\036/b\000\000\000\000\000 \321#\334\034\177\000\000 \222\303\000\000\000\000\000\017\000\000\200\000\000\024@\300\245\367\317\034\177\000\000\377\377\377\377\377\377\357\177p\316#\334\034\177\000\000X\231\303\000\000\000\000\000 \222\303\000\000\000\000\000\017\000\000\200\003\000\000\000\300\245\367\317\034\177", '\000' "\354, b\334\034\177\000\000\000\000\000\000\000\000\000\000p\316#\334\034\177\000\000\200\321#\334\034\177\000\000\340\321#\334\034\177\000\000\000\000\000\000\000\000\000\000\v,\261\000\000\000\000\000P\276\301\334\034\177", '\000' "\355, \035\261\000\000\000\000\000\300\245\367\317\034\177\000\000\210o\271\002\000\000\000\000\260\243\367\317\034\177\000\000&\320^\000\000\000\000\000\220$\006\334\034\177\000\000\317\005\000\000\000\000\000\000\000\000\000\000\016\000\000\000P\276\301\334\034\177\000\000\060\246\367\317\034\177\000", base = warning: can't find linker symbol for virtual table for `(null)' value warning: found `subselect_single_select_engine::exec()' instead { count = 8289847, start = 0x7f1ccff7a3e0, end = 0x7f1cdc6907d0 }, list = { prev = 0xbb63b8, next = 0x0 }, buf_end = 0, magic_n = 375767 }, log = { heap = 0x0, used = 0, data = "P\276\301\334\034\177\000\000@\225\036\334\000\000\001\000\060\244\367\317\034\177\000\000\v,\261\000\000\000\000\000P\276\301\334\034\177\000\000P\276\301\334\034\177\000\000`\246\367\317\034\177\000\000\213\037\261\000\000\000\000\000\240\246\367\317\034\177\000\000\000\000\000\000\375\027\000\000\200\246\367\317\034\177\000\000@\225\036\334\000\000\001\000\200\244\367\317\034\177\000\000\v,\261\000\000\000\000\000P\276\301\334\034\177\000\000P\276\301\334\034\177\000\000\017\026\310", '\000' "\254, \027\310", '\000' "\300, \244\367\317\034\177\000\000@\225\036\334\000\000\001\000Ф\367\317\034\177\000\000\v,\261\000\000\000\000\000P\276\301\334\034\177\000\000P\276\301\334\034\177\000\000\000\247\367\317\034\177\000\000\213\037\261\000\000\000\000\000 \247\367\317\034\177\000\000\000\000\000\000\026\031\000\000\303\027\310", '\000' , " \245\367\317\034\177\000\000@\225\036\334\000\000\001\000\060\245\367\317\034\177\000\000\v,\261\000\000\000\000\000P\276\301\334\034\177\000\000P\276\301\334\034\177\000\000`\247\367\317\034\177\000\000\213\037\261\000\000\000\000\000\200\247\367\317\034\177\000\000\000\000\000\000z\031", '\000' , "\025\000\000\000\000\000\000\000`\277\001\370\034\177\000\000È\023\330\034\177\000\000\027\325", '\000' , "\n\000\000\000\000\000\000\000Ч\367\317\034\177\000\000\340\000\343\024\035\177\000\000È\023\330\034\177\000\000\001\000\000\000\000\000\000\000\227\211\304\000\000\000\000\000\340\210\304\000\000\000\000\000\016\000\000\200\034\177\000\000p\251\367\317\034\177\000\000Q\235\272\000\000\000\000\000\030\237\271\002\000\000\000\000\020\246\367\317\034\177\000\000\233\002X\000\000\000\000", base = { count = 34405445488, start = 0x2b96f70, end = 0x7f1ccff7a640 }, list = warning: can't find linker symbol for virtual table for `(null)' value warning: found `Item_subselect::exec()' instead { prev = 0x7e1c77, next = 0x7f1ccff7a3d0 }, buf_end = 0, magic_n = 375767 }, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = 139761724925552, end_lsn = 139761936534400, magic_n = 54551 } heap = 0x0 offsets_ = {[0] = 100, [1] = 25400101245336, [2] = 12283342, [3] = 0, [4] = 12192582, [5] = 0, [6] = 139761724923584, [7] = 281478669702464, [8] = 139761724923600, [9] = 11611147, [10] = 139761939496528, [11] = 139761939496528, [12] = 139761724924160, [13] = 11607947, [14] = 139761724924192, [15] = 6738212404816, [16] = 12281562, [17] = 0, [18] = 139761724924224, [19] = 281478669702464, [20] = 139761724923696, [21] = 11611147, [22] = 139761939496528, [23] = 139761939496528, [24] = 139761724924256, [25] = 11607947, [26] = 12281546, [27] = 0, [28] = 139761724923760, [29] = 281478669702464, [30] = 139761724923776, [31] = 11611147, [32] = 139761939496528, [33] = 139761939496528, [34] = 139761724924336, [35] = 11607947, [36] = 139761724924368, [37] = 49009871814672, [38] = 81604378624, [39] = 139761939496528, [40] = 12283035, [41] = 0, [42] = 12762754, [43] = 281478669702464, [44] = 139761724923888, [45] = 11611147, [46] = 139761939496528, [47] = 139761939496528, [48] = 139761724924448, [49] = 11607947, [50] = 139761724924496, [51] = 72911376424429, [52] = 139761724924016, [53] = 20756974966080, [54] = 12758528, [55] = 12762754, [56] = 3703684688, [57] = 139761939496528, [58] = 12278849, [59] = 0, [60] = 139761724924048, [61] = 281478669702464, [62] = 139761724924032, [63] = 11611147, [64] = 139761939496528, [65] = 139761939496528, [66] = 139761724924592, [67] = 11607947, [68] = 139761724924656, [69] = 14422510390912, [70] = 139761939496528, [71] = 139762195432320, [72] = 12281562, [73] = 12277328, [74] = 139760383295507, [75] = 139761724924288, [76] = 12192424, [77] = 12192582, [78] = 6567925, [79] = 9500304, [80] = 81604378624, [81] = 139761928803648, [82] = 139761724924192, [83] = 281483578243053, [84] = 12278243, [85] = 139761939496528, [86] = 139761724924448, [87] = 11608247, [88] = 2147483667, [89] = 12283168, [90] = 12818776, [91] = 0, [92] = 139761724924272, [93] = 281478669702464, [94] = 139761724924288, [95] = 11611147, [96] = 139761939496528, [97] = 139761939496528, [98] = 139761724924848, [99] = 11607947} offsets = 0x7f1ccff79e70 table_lock_waited = 0 #3 0x00000000009bd92c in ha_innobase::general_fetch (this=0x7f1cf801c860, buf=0x7f1cf801cb40 "\376", direction=1, match_mode=0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6325 ret = 2147483662 error = 0 _db_stack_frame_ = { func = 0xc817c3 "rnd_next", file = 0xc7fed8 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc", level = 2147483663, prev = 0x7f1ccff7a7d0 } #4 0x00000000009bdd9d in ha_innobase::rnd_next (this=0x7f1cf801c860, buf=0x7f1cf801cb40 "\376") at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:6519 error = 0 _db_stack_frame_ = { func = 0xc48997 "JOIN_CACHE::join_records", file = 0xc488e0 "/home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc", level = 2147483662, prev = 0x7f1ccff7a970 } #5 0x000000000075de5e in handler::ha_rnd_next (this=0x7f1cf801c860, buf=0x7f1cf801cb40 "\376") at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:2225 result = 32540 locker = 0x0 state = { m_flags = 3489114224, m_table = 0x69c2e1, m_table_share = 0x3dc5a82a0, m_class = 0x7f1ccff7a89f, m_thread = 0x2b96f70, m_timer_start = 139761932731040, m_timer = 0x7f1ccff7a8b0, m_operation = 8867805, m_index = 0, m_lock_index = 3701603104, m_src_file = 0x7f1cdc62d8f0 "\020\357\002\001", m_src_line = -590654379, m_wait = 0x1007f1cdc1d0540 } #6 0x00000000008334c0 in rr_sequential (info=0x7f1cdc0627d8) at /home/sbester/build/bzr/mysql-trunk/sql/records.cc:458 tmp = 32540 #7 0x0000000000874cf0 in JOIN_CACHE_BNL::join_matching_records (this=0x7f1cdc62d8f0, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1805 cnt = 0 tab = 0x7f1cdc062748 info = 0x7f1cdc0627d8 select = 0x0 error = 0 rc = NESTED_LOOP_OK #8 0x0000000000874677 in JOIN_CACHE::join_records (this=0x7f1cdc62d8f0, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1654 tab = 0x7f1cdcbef990 outer_join_first_inner = false __PRETTY_FUNCTION__ = "enum_nested_loop_state JOIN_CACHE::join_records(bool)" rc = NESTED_LOOP_OK _db_stack_frame_ = { func = 0xc48997 "JOIN_CACHE::join_records", file = 0xc488e0 "/home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc", level = 2147483661, prev = 0x7f1ccff7a9c0 } #9 0x00000000008747f5 in JOIN_CACHE::join_records (this=0x7f1cdc1d0540, skip_last=false) at /home/sbester/build/bzr/mysql-trunk/sql/sql_join_cache.cc:1700 tab = 0x7f1cdc18d420 outer_join_first_inner = false __PRETTY_FUNCTION__ = "enum_nested_loop_state JOIN_CACHE::join_records(bool)" rc = NESTED_LOOP_OK _db_stack_frame_ = { func = 0xbb6d93 "sub_select_cache", file = 0xbb5650 "/home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc", level = 2147483660, prev = 0x7f1ccff7aa20 } #10 0x00000000006436a2 in sub_select_cache (join=0x7f1cdc18d420, join_tab=0x7f1cdc062490, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17174 rc = 10 cache = 0x7f1cdc1d0540 __PRETTY_FUNCTION__ = "enum_nested_loop_state sub_select_cache(JOIN*, JOIN_TAB*, bool)" _db_stack_frame_ = { func = 0xbb6da4 "sub_select", file = 0xbb5650 "/home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc", level = 2147483659, prev = 0x7f1ccff7aa80 } #11 0x0000000000643865 in sub_select (join=0x7f1cdc18d420, join_tab=0x7f1cdc0621d8, end_of_records=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:17344 nls = NESTED_LOOP_OK _db_stack_frame_ = { func = 0xbb6c9b "do_select", file = 0xbb5650 "/home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc", level = 2147483658, prev = 0x7f1ccff7ab00 } error = -1 rc = NESTED_LOOP_OK info = 0x7f1cdc062268 #12 0x0000000000642e9e in do_select (join=0x7f1cdc18d420, fields=0x7f1cdc18d790, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:16922 join_tab = 0x7f1cdc0621d8 end_select = 0x6463e0 __PRETTY_FUNCTION__ = "int do_select(JOIN*, List*, TABLE*, Procedure*)" rc = 0 error = NESTED_LOOP_OK _db_stack_frame_ = { func = 0xbb5c41 "JOIN::exec", file = 0xbb5650 "/home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc", level = 2147483657, prev = 0x7f1ccff7aba0 } #13 0x0000000000622d2e in JOIN::exec (this=0x7f1cdc18d420) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3331 _db_stack_frame_ = { func = 0xc39958 "subselect_single_select_engine::exec", file = 0xc39220 "/home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc", level = 2147483656, prev = 0x7f1ccff7ae70 } __FUNCTION__ = "exec" tmp_error = -598142656 curr_join = 0x7f1cdc18d420 curr_fields_list = 0x7f1cdc18d790 __PRETTY_FUNCTION__ = "void JOIN::exec()" columns_list = 0x7f1cdc637470 has_group_by = false curr_all_fields = 0x7f1cdc18d730 curr_tmp_table = 0x0 #14 0x00000000007e7d76 in subselect_single_select_engine::exec (this=0x7f1cdc95a100) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:2382 changed_tabs = {[0] = 0x7f1ccff7aca0, [1] = 0x1000200b0f7ed, [2] = 0xc63aec, [3] = 0x7f1cdcc1be50, [4] = 0x7f1ccff7ada0, [5] = 0xb120b7, [6] = 0x7f1ccff7ad10, [7] = 0xc63af1, [8] = 0x3000000008, [9] = 0x7f1ccff7adb0, [10] = 0x7f1ccff7acf0, [11] = 0xb2b30f, [12] = 0x7f1cdcc1be50, [13] = 0x4, [14] = 0x7f1cdc63dc04, [15] = 0x0, [16] = 0xc63aec, [17] = 0x30e1a172a0, [18] = 0x4, [19] = 0x0, [20] = 0x100000001, [21] = 0x7f1cdc626c64, [22] = 0x2b3b5f0, [23] = 0x90f690, [24] = 0x7f1cdcc1be50, [25] = 0x7f1cdc1e9540, [26] = 0x7f1ccff7ad70, [27] = 0xb0f7ed, [28] = 0x7f1cdcc1be50, [29] = 0x7f1cdc1e9640, [30] = 0x7f1ccff7ada0, [31] = 0xb11fa9, [32] = 0xc63aec, [33] = 0x114dc626c60, [34] = 0x600000000, [35] = 0x7f1cdcc1be50, [36] = 0x7f1ccff7ae20, [37] = 0x8eee94, [38] = 0x1cff7ade0, [39] = 0x7f1ccff7aeac, [40] = 0x4, [41] = 0x7f1cdc63dc00, [42] = 0xb4558d5acff7ae20, [43] = 0x2b97508, [44] = 0xba06b4, [45] = 0xba0420, [46] = 0x7f1c80000006, [47] = 0x7f1ccff7afc0, [48] = 0x2b3b5f0, [49] = 0x1, [50] = 0x780000006, [51] = 0xb4558d5a, [52] = 0x7f1ccff7ae70, [53] = 0x8eed92, [54] = 0x7f1ccff7aeac, [55] = 0x4, [56] = 0x7f1cdc63dc00, [57] = 0x2b97508, [58] = 0xba4f42, [59] = 0x7f1cdc626c10, [60] = 0x7f1c80000007} last_changed_tab = 0x7f1ccff7ac80 _db_stack_frame_ = { func = 0xc33b30 "Item_func_set_user_var::check", file = 0xc33600 "/home/sbester/build/bzr/mysql-trunk/sql/item_func.cc", level = 2147483655, prev = 0x7f1ccff7af50 } save_where = 0xba9d51 "field list" save_select = 0x2b992c8 #15 0x00000000007e1d2e in Item_subselect::exec (this=0x7f1cdc606000) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:298 res = 0 __PRETTY_FUNCTION__ = "virtual bool Item_subselect::exec()" #16 0x00000000007e2f4e in Item_singlerow_subselect::val_int (this=0x7f1cdc606000) at /home/sbester/build/bzr/mysql-trunk/sql/item_subselect.cc:723 __PRETTY_FUNCTION__ = "virtual longlong Item_singlerow_subselect::val_int()" #17 0x00000000007bc4b1 in Item_func_set_user_var::check (this=0x7f1cdcc94290, use_result_field=false) at /home/sbester/build/bzr/mysql-trunk/sql/item_func.cc:4542 _db_stack_frame_ = { func = 0xba06b4 "sql_set_variables", file = 0xba0420 "/home/sbester/build/bzr/mysql-trunk/sql/set_var.cc", level = 2147483654, prev = 0x7f1ccff7afc0 } __PRETTY_FUNCTION__ = "bool Item_func_set_user_var::check(bool)" #18 0x0000000000581ccf in set_var_user::check (this=0x7f1cdcc97920, thd=0x2b96f70) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:686 No locals. #19 0x00000000005817b2 in sql_set_variables (thd=0x2b96f70, var_list=0x2b99898) at /home/sbester/build/bzr/mysql-trunk/sql/set_var.cc:568 error = 0 it = { = { list = 0x2b99898, el = 0x7f1cdc0324e8, prev = 0x0, current = 0x0 }, } _db_stack_frame_ = { func = 0xbb0945 "mysql_execute_command", file = 0xbb0428 "/home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc", level = 2147483653, prev = 0x7f1ccff7bc00 } var = 0x7f1cdcc97920 #20 0x00000000005f7c55 in mysql_execute_command (thd=0x2b96f70) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:3097 lex_var_list = 0x2b99898 res = 0 lex = 0x2b98bd0 _db_stack_frame_ = { func = 0xbb13ff "mysql_parse", file = 0xbb0428 "/home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc", level = 2147483652, prev = 0x7f1ccff7bee0 } __FUNCTION__ = "mysql_execute_command" up_result = 0 __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" select_lex = 0x2b992c8 first_table = 0x0 all_tables = 0x7f1cdc993d70 unit = 0x2b98c80 have_table_map_for_update = false #21 0x00000000005fe4a7 in mysql_parse (thd=0x2b96f70, rawbuf=0x7f1cdc452870 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 )", length=1487, parser_state=0x7f1ccff7c610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 found_semicolon = 0x0 lex = 0x2b98bd0 err = false error = 32540 _db_stack_frame_ = { func = 0xbb05f9 "dispatch_command", file = 0xbb0428 "/home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc", level = 2147483651, prev = 0x7f1ccff7cb60 } __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)" __FUNCTION__ = "mysql_parse" #22 0x00000000005f286e in dispatch_command (command=COM_QUERY, thd=0x2b96f70, packet=0x2e1d271 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 ); ", packet_length=1498) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 packet_end = 0x7f1cdc452e3f "" parser_state = { m_lip = { m_thd = 0x2b96f70, yylineno = 1, yytoklen = 1, yylval = 0x7f1ccff7a680, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7f1cdc452e40 "", m_tok_start = 0x7f1cdc452e40 "", m_tok_end = 0x7f1cdc452e40 "", m_end_of_query = 0x7f1cdc452e3f "", m_tok_start_prev = 0x7f1cdc452e3f "", m_buf = 0x7f1cdc452870 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 )", m_buf_length = 1487, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x7f1cdc5cf890 "set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 )", m_cpp_ptr = 0x7f1cdc5cfe5f "", m_cpp_tok_start = 0x7f1cdc5cfe5f "", m_cpp_tok_start_prev = 0x7f1cdc5cfe5f "", m_cpp_tok_end = 0x7f1cdc5cfe5f "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0xb9ec29 "net_flush", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 63 '?', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = 11611147, m_cpp_text_start = 0x7f1cdc5cfe58 "1 )", m_cpp_text_end = 0x7f1cdc5cfe59 " )", m_underscore_cs = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = { m_item = {[0] = 0x0 } }, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ } } net = 0x2b971e0 __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" __FUNCTION__ = "dispatch_command" error = false _db_stack_frame_ = { func = 0xbb053f "do_command", file = 0xbb0428 "/home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc", level = 2147483650, prev = 0x7f1ccff7ccf0 } #23 0x00000000005f1b76 in do_command (thd=0x2b96f70) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 return_value = false packet = 0x2e1d270 "\003set @`var2`:=( select count(*) from \t`test`.`t45` as `t45` ignore index (PRIMARY,idx450,idx445) \t right join `test`.`t4` as `t4` on (t45.col434 is not false ) \t \t right outer join `test`.`t80` as `t80` use index for group by (idx794) on (t45.col432 regexp t80.col728 ) where t80.a80 && '2010-12-29' xor row(t45.col438 ,t45.col436 collate latin1_spanish_ci ,t4.col27 )< row(( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col627 sounds like t41.col403 ) \t \t right outer join `test`.`t54` as `t54` on ( time_format((t70.col628),(t70.col619)) sounds like @var9 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t70` as `t70` force index (idx684) \t right join `test`.`t41` as `t41` use index for group by (PRIMARY,idx409,idx411,idx401) on (t70.col617 is not null ) \t \t right outer join `test`.`t54` as `t54` on (@var7 sounds like @var6 )", ' ' , ") ) ,( ( select count(*) from \t`test`.`t30` as `t30` ignore index (PRIMARY,idx306,idx306,idx298) \t straight_join `test`.`t9` as `t9` ignore index for order by (idx59,PRIMARY,PRIMARY) on (@var1:=t30.col280 between t30.col285 and t9.col87 ) \t \t right join `test`.`t52` as `t52` use index for join (idx518) on ( @@global.character_set_system <> @@global.max_prepared_stmt_count )", ' ' , ") ) )", ' ' , "limit 1 ); " packet_length = 1499 net = 0x2b971e0 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = warning: can't find linker symbol for virtual table for `_db_stack_frame_' value { func = 0xcc4e4d "?func", file = 0xcc4e53 "?file", level = 2147483649, prev = 0x0 } #24 0x00000000006d187d in do_handle_one_connection (thd_arg=0x2b96f70) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 net = 0x2b971e0 rc = false thd = 0x2b96f70 #25 0x00000000006d140e in handle_one_connection (arg=0x2b96f70) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 thd = 0x2b96f70 #26 0x00000030e1807761 in start_thread (arg=0x7f1ccff7d710) at pthread_create.c:301 __res = pd = 0x7f1ccff7d710 now = unwind_buf = { cancel_jmp_buf = {[0] = { jmp_buf = {[0] = 139761724938000, [1] = 3356111218082567214, [2] = 20047872, [3] = 139761724938704, [4] = 0, [5] = 3, [6] = -3410682112124922834, [7] = 3382922812989887534}, mask_was_saved = 0 }}, priv = { pad = {[0] = 0x0, [1] = 0x0, [2] = 0x0, [3] = 0x0}, data = { prev = 0x0, cleanup = 0x0, canceltype = 0 } } } not_first_call = sp = freesize = #27 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 No locals. (gdb)