110121 14:29:53 InnoDB: Assertion failure in thread 140737018169104 in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0sel.c line 3696 InnoDB: Failing assertion: prebuilt->sql_stat_start || trx->conc_state == 1 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. Program received signal SIGABRT, Aborted. [Switching to Thread 0x7fffe3f98710 (LWP 10175)] 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 64 return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig); (gdb) bt #0 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #1 0x00000030e1434185 in abort () at abort.c:92 #2 0x000000000098f70c in row_search_for_mysql (buf=0x7fffb02739c0 "\375\327\377", mode=1, prebuilt=0x7fffb0070458, match_mode=0, direction=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0sel.c:3696 #3 0x0000000000965c24 in ha_innobase::general_fetch (this=0x7fffb02634d0, buf=0x7fffb02739c0 "\375\327\377", direction=1, match_mode=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:5878 #4 0x0000000000966095 in ha_innobase::rnd_next (this=0x7fffb02634d0, buf=0x7fffb02739c0 "\375\327\377") at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:6072 #5 0x0000000000848c3b in rr_sequential (info=0x7fffbc020100) at /home/sbester/build/bzr/mysql-5.5-security/sql/records.cc:455 #6 0x000000000063a7d4 in sub_select (join=0x7fffbc064b10, join_tab=0x7fffbc020080, end_of_records=false) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:11675 #7 0x000000000063a37f in do_select (join=0x7fffbc064b10, fields=0x7fffbc004c50, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:11436 #8 0x00000000006234e9 in JOIN::exec (this=0x7fffbc064b10) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:2362 #9 0x00000000007d4e07 in subselect_single_select_engine::exec (this=0x7fffbc018510) at /home/sbester/build/bzr/mysql-5.5-security/sql/item_subselect.cc:1983 #10 0x00000000007cf7a2 in Item_subselect::exec (this=0x7fffbc018420) at /home/sbester/build/bzr/mysql-5.5-security/sql/item_subselect.cc:275 #11 0x00000000007d059e in Item_singlerow_subselect::val_int (this=0x7fffbc018420) at /home/sbester/build/bzr/mysql-5.5-security/sql/item_subselect.cc:588 #12 0x00000000007af853 in Item_func_set_user_var::check (this=0x7fffbc023190, use_result_field=false) at /home/sbester/build/bzr/mysql-5.5-security/sql/item_func.cc:4521 #13 0x000000000056ff07 in set_var_user::check (this=0x7fffbc018570, thd=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/set_var.cc:688 #14 0x000000000056f9ea in sql_set_variables (thd=0x1db9cb0, var_list=0x1dbc560) at /home/sbester/build/bzr/mysql-5.5-security/sql/set_var.cc:570 #15 0x00000000005f4295 in mysql_execute_command (thd=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:3053 #16 0x00000000005fabd2 in mysql_parse (thd=0x1db9cb0, rawbuf=0x7fffbc0190f0 "set @`var0`:=(\nselect \t\n`t23`.`a23` as a23 \nfrom\n\t`test`.`t73` as `t73` \n\t left join `test`.`t23` as `t23` \non (@var3 rlike @var8 )\n where\nt73.a73 like( ( \nselect count(*) from\n\t`test`.`t52` as `t52` ignore index (idx451,idx450)\n\t inner join `test`.`t25` as `t25` ignore index for join (idx237,idx241) \non (@var1 ^ t25.col281 )\n \t\n\t straight_join `test`.`t53` as `t53` \non ( '1' )\n \n\n \n \n \n\n ) ) or \nt23.col255 collate utf8_esperanto_ci >= some( ( \nselect count(*) from\n\t`test`.`t79` as `t79` \n\t straight_join `test`.`t65` as `t65` \non ( '1' )\n \t\n\t cross join `test`.`t28` as `t28` \non ( ((t79.a79) not in ((t79.col840),(t79.a79),(t79.col840),(t79.col840))) like cast((t28.a28) as binary) )\n \n\n \n \n \n\n ) ) or \n row(t73.col788 ,t23.col250 collate utf8_latvian_ci ,t23.col251 )<= row( t73.col800 collate latin1_swedish_ci , t23.col259 collate latin1_spanish_ci , t73.col798 )\n\n \n \n \nlimit 1\n )", length=920, parser_state=0x7fffe3f97630) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:5509 #17 0x00000000005eef05 in dispatch_command (command=COM_QUERY, thd=0x1db9cb0, packet=0x1dbce21 "set @`var0`:=(\nselect \t\n`t23`.`a23` as a23 \nfrom\n\t`test`.`t73` as `t73` \n\t left join `test`.`t23` as `t23` \non (@var3 rlike @var8 )\n where\nt73.a73 like( ( \nselect count(*) from\n\t`test`.`t52` as `t52` ignore index (idx451,idx450)\n\t inner join `test`.`t25` as `t25` ignore index for join (idx237,idx241) \non (@var1 ^ t25.col281 )\n \t\n\t straight_join `test`.`t53` as `t53` \non ( '1' )\n \n\n \n \n \n\n ) ) or \nt23.col255 collate utf8_esperanto_ci >= some( ( \nselect count(*) from\n\t`test`.`t79` as `t79` \n\t straight_join `test`.`t65` as `t65` \non ( '1' )\n \t\n\t cross join `test`.`t28` as `t28` \non ( ((t79.a79) not in ((t79.col840),(t79.a79),(t79.col840),(t79.col840))) like cast((t28.a28) as binary) )\n \n\n \n \n \n\n ) ) or \n row(t73.col788 ,t23.col250 collate utf8_latvian_ci ,t23.col251 )<= row( t73.col800 collate latin1_swedish_ci , t23.col259 collate latin1_spanish_ci , t73.col798 )\n\n \n \n \nlimit 1\n )", packet_length=920) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:1035 #18 0x00000000005ee211 in do_command (thd=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:772 #19 0x00000000006cb886 in do_handle_one_connection (thd_arg=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:748 #20 0x00000000006cb417 in handle_one_connection (arg=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:684 #21 0x00000030e1807761 in start_thread (arg=0x7fffe3f98710) at pthread_create.c:301 #22 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 (gdb) set print elements 2000 (gdb) bt #0 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #1 0x00000030e1434185 in abort () at abort.c:92 #2 0x000000000098f70c in row_search_for_mysql (buf=0x7fffb02739c0 "\375\327\377", mode=1, prebuilt=0x7fffb0070458, match_mode=0, direction=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0sel.c:3696 #3 0x0000000000965c24 in ha_innobase::general_fetch (this=0x7fffb02634d0, buf=0x7fffb02739c0 "\375\327\377", direction=1, match_mode=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:5878 #4 0x0000000000966095 in ha_innobase::rnd_next (this=0x7fffb02634d0, buf=0x7fffb02739c0 "\375\327\377") at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:6072 #5 0x0000000000848c3b in rr_sequential (info=0x7fffbc020100) at /home/sbester/build/bzr/mysql-5.5-security/sql/records.cc:455 #6 0x000000000063a7d4 in sub_select (join=0x7fffbc064b10, join_tab=0x7fffbc020080, end_of_records=false) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:11675 #7 0x000000000063a37f in do_select (join=0x7fffbc064b10, fields=0x7fffbc004c50, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:11436 #8 0x00000000006234e9 in JOIN::exec (this=0x7fffbc064b10) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:2362 #9 0x00000000007d4e07 in subselect_single_select_engine::exec (this=0x7fffbc018510) at /home/sbester/build/bzr/mysql-5.5-security/sql/item_subselect.cc:1983 #10 0x00000000007cf7a2 in Item_subselect::exec (this=0x7fffbc018420) at /home/sbester/build/bzr/mysql-5.5-security/sql/item_subselect.cc:275 #11 0x00000000007d059e in Item_singlerow_subselect::val_int (this=0x7fffbc018420) at /home/sbester/build/bzr/mysql-5.5-security/sql/item_subselect.cc:588 #12 0x00000000007af853 in Item_func_set_user_var::check (this=0x7fffbc023190, use_result_field=false) at /home/sbester/build/bzr/mysql-5.5-security/sql/item_func.cc:4521 #13 0x000000000056ff07 in set_var_user::check (this=0x7fffbc018570, thd=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/set_var.cc:688 #14 0x000000000056f9ea in sql_set_variables (thd=0x1db9cb0, var_list=0x1dbc560) at /home/sbester/build/bzr/mysql-5.5-security/sql/set_var.cc:570 #15 0x00000000005f4295 in mysql_execute_command (thd=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:3053 #16 0x00000000005fabd2 in mysql_parse (thd=0x1db9cb0, rawbuf=0x7fffbc0190f0 "set @`var0`:=(\nselect \t\n`t23`.`a23` as a23 \nfrom\n\t`test`.`t73` as `t73` \n\t left join `test`.`t23` as `t23` \non (@var3 rlike @var8 )\n where\nt73.a73 like( ( \nselect count(*) from\n\t`test`.`t52` as `t52` ignore index (idx451,idx450)\n\t inner join `test`.`t25` as `t25` ignore index for join (idx237,idx241) \non (@var1 ^ t25.col281 )\n \t\n\t straight_join `test`.`t53` as `t53` \non ( '1' )\n \n\n \n \n \n\n ) ) or \nt23.col255 collate utf8_esperanto_ci >= some( ( \nselect count(*) from\n\t`test`.`t79` as `t79` \n\t straight_join `test`.`t65` as `t65` \non ( '1' )\n \t\n\t cross join `test`.`t28` as `t28` \non ( ((t79.a79) not in ((t79.col840),(t79.a79),(t79.col840),(t79.col840))) like cast((t28.a28) as binary) )\n \n\n \n \n \n\n ) ) or \n row(t73.col788 ,t23.col250 collate utf8_latvian_ci ,t23.col251 )<= row( t73.col800 collate latin1_swedish_ci , t23.col259 collate latin1_spanish_ci , t73.col798 )\n\n \n \n \nlimit 1\n )", length=920, parser_state=0x7fffe3f97630) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:5509 #17 0x00000000005eef05 in dispatch_command (command=COM_QUERY, thd=0x1db9cb0, packet=0x1dbce21 "set @`var0`:=(\nselect \t\n`t23`.`a23` as a23 \nfrom\n\t`test`.`t73` as `t73` \n\t left join `test`.`t23` as `t23` \non (@var3 rlike @var8 )\n where\nt73.a73 like( ( \nselect count(*) from\n\t`test`.`t52` as `t52` ignore index (idx451,idx450)\n\t inner join `test`.`t25` as `t25` ignore index for join (idx237,idx241) \non (@var1 ^ t25.col281 )\n \t\n\t straight_join `test`.`t53` as `t53` \non ( '1' )\n \n\n \n \n \n\n ) ) or \nt23.col255 collate utf8_esperanto_ci >= some( ( \nselect count(*) from\n\t`test`.`t79` as `t79` \n\t straight_join `test`.`t65` as `t65` \non ( '1' )\n \t\n\t cross join `test`.`t28` as `t28` \non ( ((t79.a79) not in ((t79.col840),(t79.a79),(t79.col840),(t79.col840))) like cast((t28.a28) as binary) )\n \n\n \n \n \n\n ) ) or \n row(t73.col788 ,t23.col250 collate utf8_latvian_ci ,t23.col251 )<= row( t73.col800 collate latin1_swedish_ci , t23.col259 collate latin1_spanish_ci , t73.col798 )\n\n \n \n \nlimit 1\n )", packet_length=920) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:1035 #18 0x00000000005ee211 in do_command (thd=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:772 #19 0x00000000006cb886 in do_handle_one_connection (thd_arg=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:748 #20 0x00000000006cb417 in handle_one_connection (arg=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:684 #21 0x00000030e1807761 in start_thread (arg=0x7fffe3f98710) at pthread_create.c:301 #22 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 (gdb) thread apply all bt Thread 2407 (Thread 0x7fffe3ed5710 (LWP 16016)): #0 0x0000000000a47551 in mach_write_to_1 (b=0x7fffb8081362 "", n=5) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/include/mach0data.ic:41 #1 0x00000000009801fb in row_mysql_store_true_var_len (dest=0x7fffb8081362 "", len=5, lenlen=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0mysql.c:177 #2 0x000000000098d71e in row_sel_field_store_in_mysql_format (dest=0x7fffb8081362 "", templ=0x7fffb4018448, data=0x7fffe84f0185 "\026\031\340\017\026", len=5) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0sel.c:2579 #3 0x000000000098de8b in row_sel_store_mysql_rec (mysql_rec=0x7fffb8081270 "", prebuilt=0x7fffb80825a8, rec=0x7fffe84f0083 "", rec_clust=0, offsets=0x7fffe3ed1e00) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0sel.c:2786 #4 0x0000000000990fe5 in row_search_for_mysql (buf=0x7fffb8081270 "", mode=1, prebuilt=0x7fffb80825a8, match_mode=0, direction=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0sel.c:4453 #5 0x0000000000965473 in ha_innobase::index_read (this=0x7fffb82abda0, buf=0x7fffb8081270 "", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:5665 #6 0x0000000000965e5e in ha_innobase::index_first (this=0x7fffb82abda0, buf=0x7fffb8081270 "") at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:5967 #7 0x0000000000966057 in ha_innobase::rnd_next (this=0x7fffb82abda0, buf=0x7fffb8081270 "") at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:6064 #8 0x0000000000848c3b in rr_sequential (info=0x7fffb4183970) at /home/sbester/build/bzr/mysql-5.5-security/sql/records.cc:455 #9 0x000000000063c366 in join_init_read_record (tab=0x7fffb41838f0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:12401 #10 0x000000000063a7a5 in sub_select (join=0x7fffb4023bc0, join_tab=0x7fffb41838f0, end_of_records=false) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:11670 #11 0x000000000063a37f in do_select (join=0x7fffb4023bc0, fields=0x0, table=0x7fffb4384e70, procedure=0x0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:11436 #12 0x0000000000621bf9 in JOIN::exec (this=0x7fffb4023bc0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:1971 #13 0x0000000000623c98 in mysql_select (thd=0x1d6a120, rref_pointer_array=0x1d6c618, tables=0x7fffb40b3cf0, wild_num=0, fields=..., conds=0x7fffb4016400, og_num=2, order=0x7fffb4046040, group=0x7fffb40f4830, having=0x7fffb411e680, proc_param=0x0, select_options=2157185280, result=0x7fffb40c1460, unit=0x1d6bdf0, select_lex=0x1d6c420) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:2571 #14 0x000000000061be40 in handle_select (thd=0x1d6a120, lex=0x1d6bd40, result=0x7fffb40c1460, setup_tables_done_option=0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:297 #15 0x00000000005f8a6e in execute_sqlcom_select (thd=0x1d6a120, all_tables=0x7fffb40b3cf0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:4472 #16 0x00000000005f1627 in mysql_execute_command (thd=0x1d6a120) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:2053 #17 0x00000000005fabd2 in mysql_parse (thd=0x1d6a120, rawbuf=0x7fffb40d8ce0 "select version() as col800_846688\nfrom\nt73 as t73_846673\nwhere\n@a:=t73_846673.col791 xor t73_846673.col791\ngroup by\n@a:=( select coalesce(t23_846606.col257,t23_846606.col257,t23_846606.col257,t23_846606.col257,t23_846606.col257) as col257_846617\nfrom\nt23 as t23_846606\nwhere\n@a:=t23_846606.a23 xor t23_846606.a23\ngroup by\n@a:=( select t23_846606.col251 not in (t23_846606.col251,t23_846606.col251,t23_846606.col251) as col251_846611\nfrom\nt23 as t23_846606\nwhere\n@a:=t23_846606.col248 <=> t23_846606.col248\ngroup by\n@a:=t23_846606.col256\nhaving\ncol251_846611 \norder by\n@a:=t23_846606.col248\nlimit 1 )\nhaving\ncol257_846617 \norder by\n@a:=t23_846606.col248\nlimit 1 )\nhaving\ncol800_846688 \norder by\n@a:=t73_846673.a73\nlimit 1 for update", length=731, parser_state=0x7fffe3ed4630) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:5509 #18 0x00000000005eef05 in dispatch_command (command=COM_QUERY, thd=0x1d6a120, packet=0x1da5e21 "select version() as col800_846688\nfrom\nt73 as t73_846673\nwhere\n@a:=t73_846673.col791 xor t73_846673.col791\ngroup by\n@a:=( select coalesce(t23_846606.col257,t23_846606.col257,t23_846606.col257,t23_846606.col257,t23_846606.col257) as col257_846617\nfrom\nt23 as t23_846606\nwhere\n@a:=t23_846606.a23 xor t23_846606.a23\ngroup by\n@a:=( select t23_846606.col251 not in (t23_846606.col251,t23_846606.col251,t23_846606.col251) as col251_846611\nfrom\nt23 as t23_846606\nwhere\n@a:=t23_846606.col248 <=> t23_846606.col248\ngroup by\n@a:=t23_846606.col256\nhaving\ncol251_846611 \norder by\n@a:=t23_846606.col248\nlimit 1 )\nhaving\ncol257_846617 \norder by\n@a:=t23_846606.col248\nlimit 1 )\nhaving\ncol800_846688 \norder by\n@a:=t73_846673.a73\nlimit 1 for update", packet_length=731) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:1035 #19 0x00000000005ee211 in do_command (thd=0x1d6a120) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:772 #20 0x00000000006cb886 in do_handle_one_connection (thd_arg=0x1d6a120) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:748 #21 0x00000000006cb417 in handle_one_connection (arg=0x1d6a120) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:684 #22 0x00000030e1807761 in start_thread (arg=0x7fffe3ed5710) at pthread_create.c:301 #23 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 1796 (Thread 0x7fffe3fd9710 (LWP 13822)): #0 0x00000030e180e42d in write () at ../sysdeps/unix/syscall-template.S:82 #1 0x0000000000ad03f6 in vio_write (vio=0x1d94ee0, buf=0x7fffc00dfcb0 "\v", size=18) at /home/sbester/build/bzr/mysql-5.5-security/vio/viosocket.c:115 #2 0x000000000055fde8 in net_real_write (net=0x1dc10a0, packet=0x7fffc00dfcb0 "\v", len=18) at /home/sbester/build/bzr/mysql-5.5-security/sql/net_serv.cc:632 #3 0x000000000055f4e7 in net_flush (net=0x1dc10a0) at /home/sbester/build/bzr/mysql-5.5-security/sql/net_serv.cc:338 #4 0x0000000000565ddc in net_send_ok (thd=0x1dc0e30, server_status=2, statement_warn_count=1, affected_rows=0, id=0, message=0x1dc3d4a "") at /home/sbester/build/bzr/mysql-5.5-security/sql/protocol.cc:251 #5 0x0000000000566581 in Protocol::send_ok (this=0x1dc1358, server_status=2, statement_warn_count=1, affected_rows=0, last_insert_id=0, message=0x1dc3d4a "") at /home/sbester/build/bzr/mysql-5.5-security/sql/protocol.cc:547 #6 0x00000000005664a4 in Protocol::end_statement (this=0x1dc1358) at /home/sbester/build/bzr/mysql-5.5-security/sql/protocol.cc:516 #7 0x00000000005f0143 in dispatch_command (command=COM_QUERY, thd=0x1dc0e30, packet=0x1dc3fa5 "", packet_length=92) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:1395 #8 0x00000000005ee211 in do_command (thd=0x1dc0e30) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:772 #9 0x00000000006cb886 in do_handle_one_connection (thd_arg=0x1dc0e30) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:748 #10 0x00000000006cb417 in handle_one_connection (arg=0x1dc0e30) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:684 #11 0x00000030e1807761 in start_thread (arg=0x7fffe3fd9710) at pthread_create.c:301 #12 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 1795 (Thread 0x7fffe3f57710 (LWP 13821)): #0 Lex_input_stream::yyGet (this=0x7fffe3f56630) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_lex.h:1730 #1 0x00000000005e5e31 in lex_one_token (arg=0x7fffe3f546b0, yythd=0x1da9e30) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_lex.cc:1041 #2 0x00000000005e5854 in MYSQLlex (arg=0x7fffe3f546b0, yythd=0x1da9e30) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_lex.cc:875 #3 0x00000000006f5e80 in MYSQLparse (yythd=0x1da9e30) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_yacc.cc:16774 #4 0x00000000005fe492 in parse_sql (thd=0x1da9e30, parser_state=0x7fffe3f56630, creation_ctx=0x0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:7234 #5 0x00000000005faa83 in mysql_parse (thd=0x1da9e30, rawbuf=0x7fffd421d2c0 "drop temporary table if exists test.t", length=37, parser_state=0x7fffe3f56630) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:5464 #6 0x00000000005eef05 in dispatch_command (command=COM_QUERY, thd=0x1da9e30, packet=0x1dacfa5 "drop temporary table if exists test.t", packet_length=37) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:1035 #7 0x00000000005ee211 in do_command (thd=0x1da9e30) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:772 #8 0x00000000006cb886 in do_handle_one_connection (thd_arg=0x1da9e30) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:748 #9 0x00000000006cb417 in handle_one_connection (arg=0x1da9e30) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:684 #10 0x00000030e1807761 in start_thread (arg=0x7fffe3f57710) at pthread_create.c:301 #11 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 740 (Thread 0x7fffcbfff710 (LWP 11578)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c9a25 in safe_cond_wait (cond=0x14870b8, mp=0x1487040, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x0000000000a54a0e in os_cond_wait (cond=0x14870b8, mutex=0x1487040) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:207 #3 0x0000000000a552af in os_event_wait_low (event=0x1487040, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:634 #4 0x0000000000999395 in srv_suspend_mysql_thread (thr=0x7fffb438e168) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c:1664 #5 0x0000000000980b97 in row_mysql_handle_errors (new_err=0x7fffcbffc6a0, trx=0x7fffb8014c88, thr=0x7fffb438e168, savept=0x0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0mysql.c:594 #6 0x0000000000991369 in row_search_for_mysql (buf=0x7fffb400a550 "", mode=1, prebuilt=0x7fffb40cbcb8, match_mode=0, direction=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0sel.c:4588 #7 0x0000000000965473 in ha_innobase::index_read (this=0x7fffb4153a70, buf=0x7fffb400a550 "", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:5665 #8 0x0000000000965e5e in ha_innobase::index_first (this=0x7fffb4153a70, buf=0x7fffb400a550 "") at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:5967 #9 0x000000000063c4b1 in join_read_first (tab=0x7fffb8065880) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:12420 #10 0x000000000063a7a5 in sub_select (join=0x7fffb808cb90, join_tab=0x7fffb8065880, end_of_records=false) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:11670 #11 0x000000000063a37f in do_select (join=0x7fffb808cb90, fields=0x1db33c0, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:11436 #12 0x00000000006234e9 in JOIN::exec (this=0x7fffb808cb90) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:2362 #13 0x0000000000623c98 in mysql_select (thd=0x1db0fb0, rref_pointer_array=0x1db34a8, tables=0x7fffb8146dc0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2148797184, result=0x7fffb801ce00, unit=0x1db2c80, select_lex=0x1db32b0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:2571 #14 0x000000000061be40 in handle_select (thd=0x1db0fb0, lex=0x1db2bd0, result=0x7fffb801ce00, setup_tables_done_option=0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:297 #15 0x00000000005f8a6e in execute_sqlcom_select (thd=0x1db0fb0, all_tables=0x7fffb8146dc0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:4472 #16 0x00000000005f1627 in mysql_execute_command (thd=0x1db0fb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:2053 #17 0x00000000005fabd2 in mysql_parse (thd=0x1db0fb0, rawbuf=0x7fffb80bfb70 "(select `t53_1`.`col600` from t53 as `t53_1` for update )", length=59, parser_state=0x7fffcbffe630) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:5509 #18 0x00000000005eef05 in dispatch_command (command=COM_QUERY, thd=0x1db0fb0, packet=0x1db4121 "", packet_length=68) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:1035 #19 0x00000000005ee211 in do_command (thd=0x1db0fb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:772 #20 0x00000000006cb886 in do_handle_one_connection (thd_arg=0x1db0fb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:748 #21 0x00000000006cb417 in handle_one_connection (arg=0x1db0fb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:684 #22 0x00000030e1807761 in start_thread (arg=0x7fffcbfff710) at pthread_create.c:301 #23 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 40 (Thread 0x7fffe3f98710 (LWP 10175)): #0 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #1 0x00000030e1434185 in abort () at abort.c:92 #2 0x000000000098f70c in row_search_for_mysql (buf=0x7fffb02739c0 "\375\327\377", mode=1, prebuilt=0x7fffb0070458, match_mode=0, direction=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0sel.c:3696 #3 0x0000000000965c24 in ha_innobase::general_fetch (this=0x7fffb02634d0, buf=0x7fffb02739c0 "\375\327\377", direction=1, match_mode=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:5878 #4 0x0000000000966095 in ha_innobase::rnd_next (this=0x7fffb02634d0, buf=0x7fffb02739c0 "\375\327\377") at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:6072 #5 0x0000000000848c3b in rr_sequential (info=0x7fffbc020100) at /home/sbester/build/bzr/mysql-5.5-security/sql/records.cc:455 #6 0x000000000063a7d4 in sub_select (join=0x7fffbc064b10, join_tab=0x7fffbc020080, end_of_records=false) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:11675 #7 0x000000000063a37f in do_select (join=0x7fffbc064b10, fields=0x7fffbc004c50, table=0x0, procedure=0x0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:11436 #8 0x00000000006234e9 in JOIN::exec (this=0x7fffbc064b10) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_select.cc:2362 #9 0x00000000007d4e07 in subselect_single_select_engine::exec (this=0x7fffbc018510) at /home/sbester/build/bzr/mysql-5.5-security/sql/item_subselect.cc:1983 #10 0x00000000007cf7a2 in Item_subselect::exec (this=0x7fffbc018420) at /home/sbester/build/bzr/mysql-5.5-security/sql/item_subselect.cc:275 #11 0x00000000007d059e in Item_singlerow_subselect::val_int (this=0x7fffbc018420) at /home/sbester/build/bzr/mysql-5.5-security/sql/item_subselect.cc:588 #12 0x00000000007af853 in Item_func_set_user_var::check (this=0x7fffbc023190, use_result_field=false) at /home/sbester/build/bzr/mysql-5.5-security/sql/item_func.cc:4521 #13 0x000000000056ff07 in set_var_user::check (this=0x7fffbc018570, thd=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/set_var.cc:688 #14 0x000000000056f9ea in sql_set_variables (thd=0x1db9cb0, var_list=0x1dbc560) at /home/sbester/build/bzr/mysql-5.5-security/sql/set_var.cc:570 #15 0x00000000005f4295 in mysql_execute_command (thd=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:3053 #16 0x00000000005fabd2 in mysql_parse (thd=0x1db9cb0, rawbuf=0x7fffbc0190f0 "set @`var0`:=(\nselect \t\n`t23`.`a23` as a23 \nfrom\n\t`test`.`t73` as `t73` \n\t left join `test`.`t23` as `t23` \non (@var3 rlike @var8 )\n where\nt73.a73 like( ( \nselect count(*) from\n\t`test`.`t52` as `t52` ignore index (idx451,idx450)\n\t inner join `test`.`t25` as `t25` ignore index for join (idx237,idx241) \non (@var1 ^ t25.col281 )\n \t\n\t straight_join `test`.`t53` as `t53` \non ( '1' )\n \n\n \n \n \n\n ) ) or \nt23.col255 collate utf8_esperanto_ci >= some( ( \nselect count(*) from\n\t`test`.`t79` as `t79` \n\t straight_join `test`.`t65` as `t65` \non ( '1' )\n \t\n\t cross join `test`.`t28` as `t28` \non ( ((t79.a79) not in ((t79.col840),(t79.a79),(t79.col840),(t79.col840))) like cast((t28.a28) as binary) )\n \n\n \n \n \n\n ) ) or \n row(t73.col788 ,t23.col250 collate utf8_latvian_ci ,t23.col251 )<= row( t73.col800 collate latin1_swedish_ci , t23.col259 collate latin1_spanish_ci , t73.col798 )\n\n \n \n \nlimit 1\n )", length=920, parser_state=0x7fffe3f97630) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:5509 #17 0x00000000005eef05 in dispatch_command (command=COM_QUERY, thd=0x1db9cb0, packet=0x1dbce21 "set @`var0`:=(\nselect \t\n`t23`.`a23` as a23 \nfrom\n\t`test`.`t73` as `t73` \n\t left join `test`.`t23` as `t23` \non (@var3 rlike @var8 )\n where\nt73.a73 like( ( \nselect count(*) from\n\t`test`.`t52` as `t52` ignore index (idx451,idx450)\n\t inner join `test`.`t25` as `t25` ignore index for join (idx237,idx241) \non (@var1 ^ t25.col281 )\n \t\n\t straight_join `test`.`t53` as `t53` \non ( '1' )\n \n\n \n \n \n\n ) ) or \nt23.col255 collate utf8_esperanto_ci >= some( ( \nselect count(*) from\n\t`test`.`t79` as `t79` \n\t straight_join `test`.`t65` as `t65` \non ( '1' )\n \t\n\t cross join `test`.`t28` as `t28` \non ( ((t79.a79) not in ((t79.col840),(t79.a79),(t79.col840),(t79.col840))) like cast((t28.a28) as binary) )\n \n\n \n \n \n\n ) ) or \n row(t73.col788 ,t23.col250 collate utf8_latvian_ci ,t23.col251 )<= row( t73.col800 collate latin1_swedish_ci , t23.col259 collate latin1_spanish_ci , t73.col798 )\n\n \n \n \nlimit 1\n )", packet_length=920) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:1035 #18 0x00000000005ee211 in do_command (thd=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:772 #19 0x00000000006cb886 in do_handle_one_connection (thd_arg=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:748 #20 0x00000000006cb417 in handle_one_connection (arg=0x1db9cb0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:684 #21 0x00000030e1807761 in start_thread (arg=0x7fffe3f98710) at pthread_create.c:301 #22 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 19 (Thread 0x7ffff40ae710 (LWP 10041)): #0 do_sigwait (set=, sig=0x7ffff40adea8) at ../sysdeps/unix/sysv/linux/sigwait.c:65 #1 __sigwait (set=, sig=0x7ffff40adea8) at ../sysdeps/unix/sysv/linux/sigwait.c:100 #2 0x0000000000555dae in signal_hand (arg=0x0) at /home/sbester/build/bzr/mysql-5.5-security/sql/mysqld.cc:2696 #3 0x00000030e1807761 in start_thread (arg=0x7ffff40ae710) at pthread_create.c:301 #4 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 18 (Thread 0x7fffe1b2a710 (LWP 10040)): #0 0x00000030e14da043 in select () at ../sysdeps/unix/syscall-template.S:82 #1 0x0000000000a55d2b in os_thread_sleep (tm=1000000) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0thread.c:274 #2 0x000000000099afe9 in srv_master_thread (arg=0x0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c:2734 #3 0x00000030e1807761 in start_thread (arg=0x7fffe1b2a710) at pthread_create.c:301 #4 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 17 (Thread 0x7fffe252b710 (LWP 10039)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:212 #1 0x00000000008c9bf7 in safe_cond_timedwait (cond=0x165bd78, mp=0x165bd00, abstime=0x7fffe252adf0, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=171) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:278 #2 0x0000000000a54904 in os_cond_wait_timed (cond=0x165bd78, mutex=0x165bd00, abstime=0x7fffe252adf0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:171 #3 0x0000000000a55452 in os_event_wait_time_low (event=0x165bd00, time_in_usec=5000000, reset_sig_count=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:743 #4 0x000000000099a25d in srv_monitor_thread (arg=0x0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c:2131 #5 0x00000030e1807761 in start_thread (arg=0x7fffe252b710) at pthread_create.c:301 #6 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 16 (Thread 0x7fffe392d710 (LWP 10038)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:212 #1 0x00000000008c9bf7 in safe_cond_timedwait (cond=0x165bbf8, mp=0x165bb80, abstime=0x7fffe392ce10, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=171) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:278 #2 0x0000000000a54904 in os_cond_wait_timed (cond=0x165bbf8, mutex=0x165bb80, abstime=0x7fffe392ce10) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:171 #3 0x0000000000a55452 in os_event_wait_time_low (event=0x165bb80, time_in_usec=1000000, reset_sig_count=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:743 #4 0x000000000099a9d2 in srv_error_monitor_thread (arg=0x0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c:2454 #5 0x00000030e1807761 in start_thread (arg=0x7fffe392d710) at pthread_create.c:301 #6 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 15 (Thread 0x7fffe2f2c710 (LWP 10037)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:212 #1 0x00000000008c9bf7 in safe_cond_timedwait (cond=0x165bcb8, mp=0x165bc40, abstime=0x7fffe2f2be00, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=171) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:278 #2 0x0000000000a54904 in os_cond_wait_timed (cond=0x165bcb8, mutex=0x165bc40, abstime=0x7fffe2f2be00) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:171 #3 0x0000000000a55452 in os_event_wait_time_low (event=0x165bc40, time_in_usec=1000000, reset_sig_count=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:743 #4 0x000000000099a65b in srv_lock_timeout_thread (arg=0x0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c:2281 #5 0x00000030e1807761 in start_thread (arg=0x7fffe2f2c710) at pthread_create.c:301 #6 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 13 (Thread 0x7fffe49da710 (LWP 10035)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c9a25 in safe_cond_wait (cond=0x1897688, mp=0x1897610, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x0000000000a54a0e in os_cond_wait (cond=0x1897688, mutex=0x1897610) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:207 #3 0x0000000000a552af in os_event_wait_low (event=0x1897610, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:634 #4 0x0000000000a537c4 in os_aio_simulated_handle (global_segment=9, message1=0x7fffe49d9e60, message2=0x7fffe49d9e58, type=0x7fffe49d9e50) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4926 #5 0x0000000000a14811 in fil_aio_wait (segment=9) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4538 #6 0x000000000099c717 in io_handler_thread (arg=0x125e3a8) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7fffe49da710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 12 (Thread 0x7fffe53db710 (LWP 10034)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c9a25 in safe_cond_wait (cond=0x18975c8, mp=0x1897550, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x0000000000a54a0e in os_cond_wait (cond=0x18975c8, mutex=0x1897550) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:207 #3 0x0000000000a552af in os_event_wait_low (event=0x1897550, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:634 #4 0x0000000000a537c4 in os_aio_simulated_handle (global_segment=8, message1=0x7fffe53dae60, message2=0x7fffe53dae58, type=0x7fffe53dae50) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4926 #5 0x0000000000a14811 in fil_aio_wait (segment=8) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4538 #6 0x000000000099c717 in io_handler_thread (arg=0x125e3a0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7fffe53db710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 11 (Thread 0x7fffe5ddc710 (LWP 10033)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c9a25 in safe_cond_wait (cond=0x1897508, mp=0x1897490, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x0000000000a54a0e in os_cond_wait (cond=0x1897508, mutex=0x1897490) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:207 #3 0x0000000000a552af in os_event_wait_low (event=0x1897490, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:634 #4 0x0000000000a537c4 in os_aio_simulated_handle (global_segment=7, message1=0x7fffe5ddbe60, message2=0x7fffe5ddbe58, type=0x7fffe5ddbe50) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4926 #5 0x0000000000a14811 in fil_aio_wait (segment=7) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4538 #6 0x000000000099c717 in io_handler_thread (arg=0x125e398) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7fffe5ddc710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 10 (Thread 0x7fffe67dd710 (LWP 10032)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c9a25 in safe_cond_wait (cond=0x1897448, mp=0x18973d0, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x0000000000a54a0e in os_cond_wait (cond=0x1897448, mutex=0x18973d0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:207 #3 0x0000000000a552af in os_event_wait_low (event=0x18973d0, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:634 #4 0x0000000000a537c4 in os_aio_simulated_handle (global_segment=6, message1=0x7fffe67dce60, message2=0x7fffe67dce58, type=0x7fffe67dce50) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4926 #5 0x0000000000a14811 in fil_aio_wait (segment=6) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4538 #6 0x000000000099c717 in io_handler_thread (arg=0x125e390) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7fffe67dd710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 9 (Thread 0x7fffe71de710 (LWP 10031)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c9a25 in safe_cond_wait (cond=0x1897388, mp=0x1897310, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x0000000000a54a0e in os_cond_wait (cond=0x1897388, mutex=0x1897310) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:207 #3 0x0000000000a552af in os_event_wait_low (event=0x1897310, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:634 #4 0x0000000000a537c4 in os_aio_simulated_handle (global_segment=5, message1=0x7fffe71dde60, message2=0x7fffe71dde58, type=0x7fffe71dde50) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4926 #5 0x0000000000a14811 in fil_aio_wait (segment=5) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4538 #6 0x000000000099c717 in io_handler_thread (arg=0x125e388) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7fffe71de710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 8 (Thread 0x7fffe7bdf710 (LWP 10030)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c9a25 in safe_cond_wait (cond=0x18972c8, mp=0x1897250, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x0000000000a54a0e in os_cond_wait (cond=0x18972c8, mutex=0x1897250) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:207 #3 0x0000000000a552af in os_event_wait_low (event=0x1897250, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:634 #4 0x0000000000a537c4 in os_aio_simulated_handle (global_segment=4, message1=0x7fffe7bdee60, message2=0x7fffe7bdee58, type=0x7fffe7bdee50) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4926 #5 0x0000000000a14811 in fil_aio_wait (segment=4) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4538 #6 0x000000000099c717 in io_handler_thread (arg=0x125e380) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7fffe7bdf710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 7 (Thread 0x7ffff4ce0710 (LWP 10029)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c9a25 in safe_cond_wait (cond=0x1897208, mp=0x1897190, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x0000000000a54a0e in os_cond_wait (cond=0x1897208, mutex=0x1897190) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:207 #3 0x0000000000a552af in os_event_wait_low (event=0x1897190, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:634 #4 0x0000000000a537c4 in os_aio_simulated_handle (global_segment=3, message1=0x7ffff4cdfe60, message2=0x7ffff4cdfe58, type=0x7ffff4cdfe50) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4926 #5 0x0000000000a14811 in fil_aio_wait (segment=3) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4538 #6 0x000000000099c717 in io_handler_thread (arg=0x125e378) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7ffff4ce0710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 6 (Thread 0x7ffff56e1710 (LWP 10028)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c9a25 in safe_cond_wait (cond=0x1897148, mp=0x18970d0, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x0000000000a54a0e in os_cond_wait (cond=0x1897148, mutex=0x18970d0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:207 #3 0x0000000000a552af in os_event_wait_low (event=0x18970d0, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:634 #4 0x0000000000a537c4 in os_aio_simulated_handle (global_segment=2, message1=0x7ffff56e0e60, message2=0x7ffff56e0e58, type=0x7ffff56e0e50) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4926 #5 0x0000000000a14811 in fil_aio_wait (segment=2) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4538 #6 0x000000000099c717 in io_handler_thread (arg=0x125e370) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7ffff56e1710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 5 (Thread 0x7ffff60e2710 (LWP 10027)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c9a25 in safe_cond_wait (cond=0x1897088, mp=0x1897010, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x0000000000a54a0e in os_cond_wait (cond=0x1897088, mutex=0x1897010) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:207 #3 0x0000000000a552af in os_event_wait_low (event=0x1897010, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:634 #4 0x0000000000a537c4 in os_aio_simulated_handle (global_segment=1, message1=0x7ffff60e1e60, message2=0x7ffff60e1e58, type=0x7ffff60e1e50) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4926 #5 0x0000000000a14811 in fil_aio_wait (segment=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4538 #6 0x000000000099c717 in io_handler_thread (arg=0x125e368) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7ffff60e2710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 4 (Thread 0x7ffff7fd2710 (LWP 10026)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c9a25 in safe_cond_wait (cond=0x1896fc8, mp=0x1896f50, file=0xc396b8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=207) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x0000000000a54a0e in os_cond_wait (cond=0x1896fc8, mutex=0x1896f50) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:207 #3 0x0000000000a552af in os_event_wait_low (event=0x1896f50, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:634 #4 0x0000000000a537c4 in os_aio_simulated_handle (global_segment=0, message1=0x7ffff7fd1e60, message2=0x7ffff7fd1e58, type=0x7ffff7fd1e50) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4926 #5 0x0000000000a14811 in fil_aio_wait (segment=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4538 #6 0x000000000099c717 in io_handler_thread (arg=0x125e360) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:483 #7 0x00000030e1807761 in start_thread (arg=0x7ffff7fd2710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 1 (Thread 0x7ffff7fd4700 (LWP 10021)): #0 0x00000030e14d7de3 in __poll (fds=, nfds=, timeout=) at ../sysdeps/unix/sysv/linux/poll.c:87 #1 0x00000000005598cb in handle_connections_sockets () at /home/sbester/build/bzr/mysql-5.5-security/sql/mysqld.cc:5091 #2 0x0000000000558d5c in mysqld_main (argc=13, argv=0x1269dc8) at /home/sbester/build/bzr/mysql-5.5-security/sql/mysqld.cc:4561 #3 0x0000000000551574 in main (argc=13, argv=0x7fffffffe2e8) at /home/sbester/build/bzr/mysql-5.5-security/sql/main.cc:24