Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL)
-
None
Description
Note: I've decided to group all these crashes because filing them separately just doesn't make sense: they are intermittent, and since all of them happen on the same test case, most likely they all have the same one or two root causes. So, the major complaint here is this:
The provided concurrent test makes the server crash in one or another way.
I've run the same exact test 10 times on 5.5 tree and 10 times on 10.0 tree, below is the collection of failures that I got. It is not complete; I've seen different ones in previous tests as well.
I am also attaching as subtasks reports that I filed previously, originated from the same set of tests. They have MTR test cases which were rather fragile anyway.
The expected result after all fixe(s) is that it can run 10-20 minutes without crashing, preferably several times, and MTR test cases from the subtasks don't crash either. When it is achieved, please reassign it back to me for re-testing.
Command line (I am using lp:~elenst/randgen/mariadb-patches revno 1001)
perl ./runall-new --no-mask --threads=12 --duration=600 --queries=100M --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock --mysqld=--sql-mode=STRICT_TRANS_TABLES,ONLY_FULL_GROUP_BY --grammar=conf/runtime/performance_schema.yy --engine=MyISAM --views --basedir=<your basedir> --vardir=<your vardir>
|
To run the test several times, you can use runall-trials.pl:
perl ./runall-trials.pl --trials=10 --no-mask --threads=12 --duration=600 --queries=100M --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock --mysqld=--sql-mode=STRICT_TRANS_TABLES,ONLY_FULL_GROUP_BY --grammar=conf/runtime/performance_schema.yy --engine=MyISAM --views --basedir=<your basedir> --vardir=<your vardir>
|
Crashes on 5.5 revno 4435 (10 crashes out of 10 trials)
Happened twice |
# 2015-02-17T23:14:14 [57824] #3 <signal handler called>
|
# 2015-02-17T23:14:14 [57824] #4 0x00000000007e8a29 in Item_field::used_tables (this=0x7fb07a619708) at /home/elenst/bzr/5.5/sql/item.cc:2720
|
# 2015-02-17T23:14:14 [57824] #5 0x000000000057943d in Item::const_item (this=0x7fb07a619708) at /home/elenst/bzr/5.5/sql/item.h:1066
|
# 2015-02-17T23:14:14 [57824] #6 0x000000000066acf3 in create_tmp_table (thd=0x7fb0803ed060, param=0x7fb07282a738, fields=..., group=0x0, distinct=false, save_sum_fields=false, selec
|
t_options=2684619520, rows_limit=18446744073709551615, table_alias=0xd68876 "", do_not_open=false, keep_row_order=false) at /home/elenst/bzr/5.5/sql/sql_select.cc:15088
|
# 2015-02-17T23:14:14 [57824] #7 0x0000000000648992 in JOIN::init_execution (this=0x7fb07282a548) at /home/elenst/bzr/5.5/sql/sql_select.cc:1862
|
# 2015-02-17T23:14:14 [57824] #8 0x000000000064a98c in JOIN::exec (this=0x7fb07282a548) at /home/elenst/bzr/5.5/sql/sql_select.cc:2402
|
# 2015-02-17T23:14:14 [57824] #9 0x000000000064d099 in mysql_select (thd=0x7fb0803ed060, rref_pointer_array=0x7fb0803f0cd0, tables=0x7fb07a425a70, wild_num=1, fields=..., conds=0x0,
|
og_num=1, order=0x7fb07a426ca0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7fb07282a528, unit=0x7fb0803f0380, select_lex=0x7fb0803f0a60) at /home/elens
|
t/bzr/5.5/sql/sql_select.cc:3094
|
# 2015-02-17T23:14:14 [57824] #10 0x0000000000643747 in handle_select (thd=0x7fb0803ed060, lex=0x7fb0803f02d0, result=0x7fb07282a528, setup_tables_done_option=0) at /home/elenst/bzr/5
|
.5/sql/sql_select.cc:319
|
# 2015-02-17T23:14:14 [57824] #11 0x000000000061b5fd in execute_sqlcom_select (thd=0x7fb0803ed060, all_tables=0x7fb07a425a70) at /home/elenst/bzr/5.5/sql/sql_parse.cc:4689
|
# 2015-02-17T23:14:14 [57824] #12 0x00000000006141ba in mysql_execute_command (thd=0x7fb0803ed060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:2234
|
# 2015-02-17T23:14:14 [57824] #13 0x000000000061e24f in mysql_parse (thd=0x7fb0803ed060, rawbuf=0x7fb07a425078 "SELECT * FROM (INFORMATION_SCHEMA.`PARAMETERS` AS table1 LEFT JOIN INFO
|
RMATION_SCHEMA.`PARTITIONS` AS table2 ON ( table2.`PARTITION_DESCRIPTION` = table1.`ROUTINE_TYPE` ) ) ORDER BY table2.`CHECKSUM` LIMIT 74", length=208, parser_state=0x7fb0a527d650) at
|
/home/elenst/bzr/5.5/sql/sql_parse.cc:5909
|
# 2015-02-17T23:14:14 [57824] #14 0x0000000000611643 in dispatch_command (command=COM_QUERY, thd=0x7fb0803ed060, packet=0x7fb0803f2061 " SELECT * FROM (INFORMATION_SCHEMA.`PARAMETERS`
|
AS table1 LEFT JOIN INFORMATION_SCHEMA.`PARTITIONS` AS table2 ON ( table2.`PARTITION_DESCRIPTION` = table1.`ROUTINE_TYPE` ) ) ORDER BY table2.`CHECKSUM` LIMIT 74", packet_length=209)
|
at /home/elenst/bzr/5.5/sql/sql_parse.cc:1079
|
# 2015-02-17T23:14:14 [57824] #15 0x0000000000610794 in do_command (thd=0x7fb0803ed060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
|
# 2015-02-17T23:14:14 [57824] #16 0x000000000071d476 in do_handle_one_connection (thd_arg=0x7fb0803ed060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
|
# 2015-02-17T23:14:14 [57824] #17 0x000000000071cf48 in handle_one_connection (arg=0x7fb0803ed060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
|
# 2015-02-17T23:14:14 [57824] #18 0x00007fb0a434de9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
# 2015-02-17T23:14:14 [57824] #19 0x00007fb0a3a7acbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
# 2015-02-17T23:14:14 [57824] #20 0x0000000000000000 in ?? ()
|
Happened twice |
# 2015-02-17T23:15:31 [58121] #3 <signal handler called>
|
# 2015-02-17T23:15:31 [58121] #4 0x00000000006cc8dd in st_select_lex_unit::cleanup (this=0x7fc2ad674128) at /home/elenst/bzr/5.5/sql/sql_union.cc:887
|
# 2015-02-17T23:15:31 [58121] #5 0x000000000067b84f in free_underlaid_joins (thd=0x7fc2b37f7060, select=0x7fc2b37faa60) at /home/elenst/bzr/5.5/sql/sql_select.cc:21825
|
# 2015-02-17T23:15:31 [58121] #6 0x00000000005f74c1 in mysql_insert (thd=0x7fc2b37f7060, table_list=0x7fc2ad425198, fields=..., values_list=..., update_fields=..., update_values=...,
|
duplic=DUP_ERROR, ignore=false) at /home/elenst/bzr/5.5/sql/sql_insert.cc:992
|
# 2015-02-17T23:15:31 [58121] #7 0x0000000000615f1c in mysql_execute_command (thd=0x7fc2b37f7060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:2974
|
# 2015-02-17T23:15:31 [58121] #8 0x000000000061e24f in mysql_parse (thd=0x7fc2b37f7060, rawbuf=0x7fc2ad425078 "INSERT INTO `view_DD` ( `pk` ) VALUES (NULL)", length=44, parser_state=
|
0x7fc2d6aba650) at /home/elenst/bzr/5.5/sql/sql_parse.cc:5909
|
# 2015-02-17T23:15:31 [58121] #9 0x0000000000611643 in dispatch_command (command=COM_QUERY, thd=0x7fc2b37f7060, packet=0x7fc2d620a061 "INSERT INTO `view_DD` ( `pk` ) VALUES (NULL)",
|
packet_length=44) at /home/elenst/bzr/5.5/sql/sql_parse.cc:1079
|
# 2015-02-17T23:15:31 [58121] #10 0x0000000000610794 in do_command (thd=0x7fc2b37f7060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
|
# 2015-02-17T23:15:31 [58121] #11 0x000000000071d476 in do_handle_one_connection (thd_arg=0x7fc2b37f7060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
|
# 2015-02-17T23:15:31 [58121] #12 0x000000000071cf48 in handle_one_connection (arg=0x7fc2b37f7060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
|
# 2015-02-17T23:15:31 [58121] #13 0x00007fc2d7698e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
# 2015-02-17T23:15:31 [58121] #14 0x00007fc2d6dc5cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
# 2015-02-17T23:15:31 [58121] #15 0x0000000000000000 in ?? ()
|
Happened twice |
# 2015-02-17T23:18:27 [58620] #3 <signal handler called>
|
# 2015-02-17T23:18:27 [58620] #4 0x00000000006d7065 in mysql_make_view (thd=0x7f8543ff7060, parser=0x7f853a83f078, table=0x7f853eab5678, flags=0) at /home/elenst/bzr/5.5/sql/sql_view.cc:1125
|
# 2015-02-17T23:18:27 [58620] #5 0x00000000005c2f94 in open_new_frm (thd=0x7f8543ff7060, share=0x7f853ec5dc78, alias=0x7f853eab5670 "view_CC", db_stat=39, prgflag=44, ha_open_flags=16, outparam=0x7f85672b49a0, table_desc=0x7f853eab5678, mem_root=0x7f85672b5920) at /home/elenst/bzr/5.5/sql/sql_base.cc:9593
|
# 2015-02-17T23:18:27 [58620] #6 0x00000000005b6637 in tdc_open_view (thd=0x7f8543ff7060, table_list=0x7f853eab5678, alias=0x7f853eab5670 "view_CC", cache_key=0x7f85672b53c0 "test", cache_key_length=13, mem_root=0x7f85672b5920, flags=0) at /home/elenst/bzr/5.5/sql/sql_base.cc:3891
|
# 2015-02-17T23:18:27 [58620] #7 0x00000000005b48aa in open_table (thd=0x7f8543ff7060, table_list=0x7f853eab5678, mem_root=0x7f85672b5920, ot_ctx=0x7f85672b58e0) at /home/elenst/bzr/5.5/sql/sql_base.cc:2908
|
# 2015-02-17T23:18:27 [58620] #8 0x00000000005b78ba in open_and_process_table (thd=0x7f8543ff7060, lex=0x7f853d0ecb70, tables=0x7f853eab5678, counter=0x7f85672b59a4, flags=0, prelocking_strategy=0x7f85672b5a10, has_prelocking_list=false, ot_ctx=0x7f85672b58e0, new_frm_mem=0x7f85672b5920) at /home/elenst/bzr/5.5/sql/sql_base.cc:4540
|
# 2015-02-17T23:18:27 [58620] #9 0x00000000005b8918 in open_tables (thd=0x7f8543ff7060, start=0x7f85672b5990, counter=0x7f85672b59a4, flags=0, prelocking_strategy=0x7f85672b5a10) at /home/elenst/bzr/5.5/sql/sql_base.cc:5056
|
# 2015-02-17T23:18:27 [58620] #10 0x00000000005b97fe in open_and_lock_tables (thd=0x7f8543ff7060, tables=0x7f853eab5078, derived=true, flags=0, prelocking_strategy=0x7f85672b5a10) at /home/elenst/bzr/5.5/sql/sql_base.cc:5661
|
# 2015-02-17T23:18:27 [58620] #11 0x00000000005ac7f7 in open_and_lock_tables (thd=0x7f8543ff7060, tables=0x7f853eab5078, derived=true, flags=0) at /home/elenst/bzr/5.5/sql/sql_base.h:524
|
# 2015-02-17T23:18:27 [58620] #12 0x0000000000616289 in mysql_execute_command (thd=0x7f8543ff7060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:3039
|
# 2015-02-17T23:18:27 [58620] #13 0x000000000090b2a2 in sp_instr_stmt::exec_core (this=0x7f853eab5cf0, thd=0x7f8543ff7060, nextp=0x7f85672b637c) at /home/elenst/bzr/5.5/sql/sp_head.cc:3222
|
# 2015-02-17T23:18:27 [58620] #14 0x000000000090aa85 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7f853eab5d30, thd=0x7f8543ff7060, nextp=0x7f85672b637c, open_tables=false, instr=0x7f853eab5cf0) at /home/elenst/bzr/5.5/sql/sp_head.cc:3000
|
# 2015-02-17T23:18:27 [58620] #15 0x000000000090b004 in sp_instr_stmt::execute (this=0x7f853eab5cf0, thd=0x7f8543ff7060, nextp=0x7f85672b637c) at /home/elenst/bzr/5.5/sql/sp_head.cc:3146
|
# 2015-02-17T23:18:27 [58620] #16 0x0000000000906b3e in sp_head::execute (this=0x7f853d0ec078, thd=0x7f8543ff7060, merge_da_on_success=false) at /home/elenst/bzr/5.5/sql/sp_head.cc:1433
|
# 2015-02-17T23:18:27 [58620] #17 0x00000000009076a3 in sp_head::execute_trigger (this=0x7f853d0ec078, thd=0x7f8543ff7060, db_name=0x7f853941b1a8, table_name=0x7f853941b1b8, grant_info=0x7f853d0a88e8) at /home/elenst/bzr/5.5/sql/sp_head.cc:1738
|
# 2015-02-17T23:18:27 [58620] #18 0x00000000006c60f6 in Table_triggers_list::process_triggers (this=0x7f853d0a8838, thd=0x7f8543ff7060, event=TRG_EVENT_INSERT, time_type=TRG_ACTION_BEFORE, old_row_is_record1=true) at /home/elenst/bzr/5.5/sql/sql_trigger.cc:2156
|
# 2015-02-17T23:18:27 [58620] #19 0x00000000005c1bd7 in fill_record_n_invoke_before_triggers (thd=0x7f8543ff7060, fields=..., values=..., ignore_errors=false, triggers=0x7f853d0a8838, event=TRG_EVENT_INSERT) at /home/elenst/bzr/5.5/sql/sql_base.cc:9068
|
# 2015-02-17T23:18:27 [58620] #20 0x00000000005f7150 in mysql_insert (thd=0x7f8543ff7060, table_list=0x7f853dc25198, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /home/elenst/bzr/5.5/sql/sql_insert.cc:907
|
# 2015-02-17T23:18:27 [58620] #21 0x0000000000615f1c in mysql_execute_command (thd=0x7f8543ff7060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:2974
|
# 2015-02-17T23:18:27 [58620] #22 0x000000000061e24f in mysql_parse (thd=0x7f8543ff7060, rawbuf=0x7f853dc25078 "INSERT INTO `view_A` ( `pk` ) VALUES (NULL)", length=43, parser_state=0x7f85672b7650) at /home/elenst/bzr/5.5/sql/sql_parse.cc:5909
|
# 2015-02-17T23:18:27 [58620] #23 0x0000000000611643 in dispatch_command (command=COM_QUERY, thd=0x7f8543ff7060, packet=0x7f8566a0a061 "INSERT INTO `view_A` ( `pk` ) VALUES (NULL)", packet_length=43) at /home/elenst/bzr/5.5/sql/sql_parse.cc:1079
|
# 2015-02-17T23:18:27 [58620] #24 0x0000000000610794 in do_command (thd=0x7f8543ff7060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
|
# 2015-02-17T23:18:27 [58620] #25 0x000000000071d476 in do_handle_one_connection (thd_arg=0x7f8543ff7060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
|
# 2015-02-17T23:18:27 [58620] #26 0x000000000071cf48 in handle_one_connection (arg=0x7f8543ff7060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
|
# 2015-02-17T23:18:27 [58620] #27 0x00007f8567e95e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
# 2015-02-17T23:18:27 [58620] #28 0x00007f85675c2cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
# 2015-02-17T23:18:27 [58620] #29 0x0000000000000000 in ?? ()
|
Happened once |
# 2015-02-17T23:20:47 [59023] #3 <signal handler called>
|
# 2015-02-17T23:20:47 [59023] #4 0x00000000005e4cf9 in Item::delete_self (this=0x7fe1af94f7e0) at /home/elenst/bzr/5.5/sql/item.h:1434
|
# 2015-02-17T23:20:47 [59023] #5 0x00000000005dee7b in Query_arena::free_items (this=0x7fe1d9e8a078) at /home/elenst/bzr/5.5/sql/sql_class.cc:3160
|
# 2015-02-17T23:20:47 [59023] #6 0x00000000005da64e in THD::cleanup_after_query (this=0x7fe1d9e8a060) at /home/elenst/bzr/5.5/sql/sql_class.cc:1883
|
# 2015-02-17T23:20:47 [59023] #7 0x000000000061e358 in mysql_parse (thd=0x7fe1d9e8a060, rawbuf=0x7fe1c785b078 "SELECT * FROM (INFORMATION_SCHEMA.`COLUMNS` AS table1 STRAIGHT_JOIN mys
|
ql.`plugin` AS table2 ON ( table2.`dl` = table1.`CHARACTER_OCTET_LENGTH` ) ) ORDER BY table2.`dl` LIMIT 129", length=178, parser_state=0x7fe1da48e650) at /home/elenst/bzr/5.5/sql/sql_
|
parse.cc:5926
|
# 2015-02-17T23:20:47 [59023] #8 0x0000000000611643 in dispatch_command (command=COM_QUERY, thd=0x7fe1d9e8a060, packet=0x7fe1d9e8f061 "", packet_length=179) at /home/elenst/bzr/5.5/s
|
ql/sql_parse.cc:1079
|
# 2015-02-17T23:20:47 [59023] #9 0x0000000000610794 in do_command (thd=0x7fe1d9e8a060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
|
# 2015-02-17T23:20:47 [59023] #10 0x000000000071d476 in do_handle_one_connection (thd_arg=0x7fe1d9e8a060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
|
# 2015-02-17T23:20:47 [59023] #11 0x000000000071cf48 in handle_one_connection (arg=0x7fe1d9e8a060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
|
# 2015-02-17T23:20:47 [59023] #12 0x00007fe1db147e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
# 2015-02-17T23:20:47 [59023] #13 0x00007fe1da874cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
# 2015-02-17T23:20:47 [59023] #14 0x0000000000000000 in ?? ()
|
Happened once |
# 2015-02-17T23:23:43 [59578] #3 <signal handler called>
|
# 2015-02-17T23:23:43 [59578] #4 0x00000000007fc260 in Item_ident::get_depended_from (this=0x7f67935c1718) at /home/elenst/bzr/5.5/sql/item.cc:9776
|
# 2015-02-17T23:23:43 [59578] #5 0x00000000007e8a47 in Item_field::used_tables (this=0x7f67935c1718) at /home/elenst/bzr/5.5/sql/item.cc:2722
|
# 2015-02-17T23:23:43 [59578] #6 0x000000000057943d in Item::const_item (this=0x7f67935c1718) at /home/elenst/bzr/5.5/sql/item.h:1066
|
# 2015-02-17T23:23:43 [59578] #7 0x000000000066acf3 in create_tmp_table (thd=0x7f679e3f7060, param=0x7f67935bf7a0, fields=..., group=0x0, distinct=false, save_sum_fields=false, selec
|
t_options=2684619520, rows_limit=18446744073709551615, table_alias=0xd68876 "", do_not_open=false, keep_row_order=false) at /home/elenst/bzr/5.5/sql/sql_select.cc:15088
|
# 2015-02-17T23:23:43 [59578] #8 0x0000000000648992 in JOIN::init_execution (this=0x7f67935bf5b0) at /home/elenst/bzr/5.5/sql/sql_select.cc:1862
|
# 2015-02-17T23:23:43 [59578] #9 0x000000000064a98c in JOIN::exec (this=0x7f67935bf5b0) at /home/elenst/bzr/5.5/sql/sql_select.cc:2402
|
# 2015-02-17T23:23:43 [59578] #10 0x000000000064d099 in mysql_select (thd=0x7f679e3f7060, rref_pointer_array=0x7f679e3facd0, tables=0x7f6798025a88, wild_num=1, fields=..., conds=0x0,
|
og_num=1, order=0x7f6798026ca0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f67935bf590, unit=0x7f679e3fa380, select_lex=0x7f679e3faa60) at /home/elens
|
t/bzr/5.5/sql/sql_select.cc:3094
|
# 2015-02-17T23:23:43 [59578] #11 0x0000000000643747 in handle_select (thd=0x7f679e3f7060, lex=0x7f679e3fa2d0, result=0x7f67935bf590, setup_tables_done_option=0) at /home/elenst/bzr/5
|
.5/sql/sql_select.cc:319
|
# 2015-02-17T23:23:43 [59578] #12 0x000000000061b5fd in execute_sqlcom_select (thd=0x7f679e3f7060, all_tables=0x7f6798025a88) at /home/elenst/bzr/5.5/sql/sql_parse.cc:4689
|
# 2015-02-17T23:23:43 [59578] #13 0x00000000006141ba in mysql_execute_command (thd=0x7f679e3f7060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:2234
|
# 2015-02-17T23:23:43 [59578] #14 0x000000000061e24f in mysql_parse (thd=0x7f679e3f7060, rawbuf=0x7f6798025078 "SELECT * FROM (INFORMATION_SCHEMA.`INDEX_STATISTICS` AS table1 RIGHT JO
|
IN INFORMATION_SCHEMA.`VIEWS` AS table2 ON ( table2.`CHECK_OPTION` = table1.`TABLE_NAME` ) ) ORDER BY table2.`TABLE_SCHEMA` LIMIT 96", length=203, parser_state=0x7f67c1464650) at /hom
|
e/elenst/bzr/5.5/sql/sql_parse.cc:5909
|
# 2015-02-17T23:23:43 [59578] #15 0x0000000000611643 in dispatch_command (command=COM_QUERY, thd=0x7f679e3f7060, packet=0x7f67c0e0a061 " SELECT * FROM (INFORMATION_SCHEMA.`INDEX_STATI
|
STICS` AS table1 RIGHT JOIN INFORMATION_SCHEMA.`VIEWS` AS table2 ON ( table2.`CHECK_OPTION` = table1.`TABLE_NAME` ) ) ORDER BY table2.`TABLE_SCHEMA` LIMIT 96", packet_length=204) at /
|
home/elenst/bzr/5.5/sql/sql_parse.cc:1079
|
# 2015-02-17T23:23:43 [59578] #16 0x0000000000610794 in do_command (thd=0x7f679e3f7060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
|
# 2015-02-17T23:23:43 [59578] #17 0x000000000071d476 in do_handle_one_connection (thd_arg=0x7f679e3f7060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
|
# 2015-02-17T23:23:43 [59578] #18 0x000000000071cf48 in handle_one_connection (arg=0x7f679e3f7060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
|
# 2015-02-17T23:23:43 [59578] #19 0x00007f67c2042e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
# 2015-02-17T23:23:43 [59578] #20 0x00007f67c176fcbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
# 2015-02-17T23:23:43 [59578] #21 0x0000000000000000 in ?? ()
|
Happened once |
# 2015-02-17T23:26:23 [60120] #3 <signal handler called>
|
# 2015-02-17T23:26:23 [60120] #4 0x0000000000000000 in ?? ()
|
# 2015-02-17T23:26:23 [60120] #5 0x0000000000652b96 in update_ref_and_keys (thd=0x7fd8d77f7060, keyuse=0x7fd8d1426c58, join_tab=0x7fd8d1655798, tables=1, cond=0x7fd8d1426788, normal_
|
tables=18446744073709551615, select_lex=0x7fd8d77faa60, sargables=0x7fd8fa8b8330) at /home/elenst/bzr/5.5/sql/sql_select.cc:4919
|
# 2015-02-17T23:26:23 [60120] #6 0x000000000064dfae in make_join_statistics (join=0x7fd8d1426950, tables_list=..., conds=0x7fd8d1426788, keyuse_array=0x7fd8d1426c58) at /home/elenst/
|
bzr/5.5/sql/sql_select.cc:3374
|
# 2015-02-17T23:26:23 [60120] #7 0x000000000064642d in JOIN::optimize (this=0x7fd8d1426950) at /home/elenst/bzr/5.5/sql/sql_select.cc:1229
|
# 2015-02-17T23:26:23 [60120] #8 0x000000000064d004 in mysql_select (thd=0x7fd8d77f7060, rref_pointer_array=0x7fd8d77facd0, tables=0x7fd8d1425408, wild_num=1, fields=..., conds=0x7fd
|
8d1426788, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fd8d1426930, unit=0x7fd8d77fa380, select_lex=0x7fd8d77faa60) at /home/elens
|
t/bzr/5.5/sql/sql_select.cc:3080
|
# 2015-02-17T23:26:23 [60120] #9 0x0000000000643747 in handle_select (thd=0x7fd8d77f7060, lex=0x7fd8d77fa2d0, result=0x7fd8d1426930, setup_tables_done_option=0) at /home/elenst/bzr/5
|
.5/sql/sql_select.cc:319
|
# 2015-02-17T23:26:23 [60120] #10 0x000000000061b5fd in execute_sqlcom_select (thd=0x7fd8d77f7060, all_tables=0x7fd8d1425408) at /home/elenst/bzr/5.5/sql/sql_parse.cc:4689
|
# 2015-02-17T23:26:23 [60120] #11 0x00000000006141ba in mysql_execute_command (thd=0x7fd8d77f7060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:2234
|
# 2015-02-17T23:26:23 [60120] #12 0x000000000061e24f in mysql_parse (thd=0x7fd8d77f7060, rawbuf=0x7fd8d1425078 "SELECT * FROM performance_schema.`setup_instruments` AS table1 WHERE (
|
( table1.`TIMED` LIKE 'wait%' AND table1.`TIMED` IN ( 6, 5, 4 )) OR table1.`NAME` LIKE 'wait%') LIMIT 216", length=176, parser_state=0x7fd8fa8b9650) at /home/elenst/bzr/5.5/sql/sql_pa
|
rse.cc:5909
|
# 2015-02-17T23:26:23 [60120] #13 0x0000000000611643 in dispatch_command (command=COM_QUERY, thd=0x7fd8d77f7060, packet=0x7fd8fa20a061 " SELECT * FROM performance_schema.`setup_instru
|
ments` AS table1 WHERE ( ( table1.`TIMED` LIKE 'wait%' AND table1.`TIMED` IN ( 6, 5, 4 )) OR table1.`NAME` LIKE 'wait%') LIMIT 216", packet_length=177) at /home/elenst/bzr/5.5/sql/sql
|
_parse.cc:1079
|
# 2015-02-17T23:26:23 [60120] #14 0x0000000000610794 in do_command (thd=0x7fd8d77f7060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
|
# 2015-02-17T23:26:23 [60120] #15 0x000000000071d476 in do_handle_one_connection (thd_arg=0x7fd8d77f7060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
|
# 2015-02-17T23:26:23 [60120] #16 0x000000000071cf48 in handle_one_connection (arg=0x7fd8d77f7060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
|
# 2015-02-17T23:26:23 [60120] #17 0x00007fd8fb497e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
# 2015-02-17T23:26:23 [60120] #18 0x00007fd8fabc4cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
# 2015-02-17T23:26:23 [60120] #19 0x0000000000000000 in ?? ()
|
Happened once |
# 2015-02-17T23:28:03 [60368] #3 <signal handler called>
|
# 2015-02-17T23:28:03 [60368] #4 0x0000000000ccd994 in end_io_cache (info=0x7f9432c7e7c0) at /home/elenst/bzr/5.5/mysys/mf_iocache.c:1836
|
# 2015-02-17T23:28:03 [60368] #5 0x0000000000cc9537 in close_cached_file (cache=0x7f9432c7e7c0) at /home/elenst/bzr/5.5/mysys/mf_cache.c:105
|
# 2015-02-17T23:28:03 [60368] #6 0x00000000008d8498 in SQL_SELECT::cleanup (this=0x7f9432c7e7a0) at /home/elenst/bzr/5.5/sql/opt_range.cc:1798
|
# 2015-02-17T23:28:03 [60368] #7 0x00000000008d84b2 in SQL_SELECT::~SQL_SELECT (this=0x7f9432c7e7a0, __in_chrg=<optimised out>) at /home/elenst/bzr/5.5/sql/opt_range.cc:1804
|
# 2015-02-17T23:28:03 [60368] #8 0x000000000064cbe3 in JOIN::destroy (this=0x7f942bbbc078) at /home/elenst/bzr/5.5/sql/sql_select.cc:2941
|
# 2015-02-17T23:28:03 [60368] #9 0x00000000006cccb5 in st_select_lex::cleanup (this=0x7f9438bf0a60) at /home/elenst/bzr/5.5/sql/sql_union.cc:1015
|
# 2015-02-17T23:28:03 [60368] #10 0x000000000064d117 in mysql_select (thd=0x7f9438bed060, rref_pointer_array=0x7f9438bf0cd0, tables=0x7f9432c25308, wild_num=1, fields=..., conds=0x0,
|
og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f9432c26cb0, unit=0x7f9438bf0380, select_lex=0x7f9438bf0a60) at /home/elenst/bzr/5.5/s
|
ql/sql_select.cc:3106
|
# 2015-02-17T23:28:03 [60368] #11 0x0000000000643747 in handle_select (thd=0x7f9438bed060, lex=0x7f9438bf02d0, result=0x7f9432c26cb0, setup_tables_done_option=0) at /home/elenst/bzr/5
|
.5/sql/sql_select.cc:319
|
# 2015-02-17T23:28:03 [60368] #12 0x000000000061b5fd in execute_sqlcom_select (thd=0x7f9438bed060, all_tables=0x7f9432c25308) at /home/elenst/bzr/5.5/sql/sql_parse.cc:4689
|
# 2015-02-17T23:28:03 [60368] #13 0x00000000006141ba in mysql_execute_command (thd=0x7f9438bed060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:2234
|
# 2015-02-17T23:28:03 [60368] #14 0x000000000061e24f in mysql_parse (thd=0x7f9438bed060, rawbuf=0x7f9432c25078 "SELECT * FROM INFORMATION_SCHEMA.`PARAMETERS` AS table1 LIMIT 188", len
|
gth=65, parser_state=0x7f945d9d4650) at /home/elenst/bzr/5.5/sql/sql_parse.cc:5909
|
# 2015-02-17T23:28:03 [60368] #15 0x0000000000611643 in dispatch_command (command=COM_QUERY, thd=0x7f9438bed060, packet=0x7f9438bf2061 "", packet_length=66) at /home/elenst/bzr/5.5/sq
|
l/sql_parse.cc:1079
|
# 2015-02-17T23:28:03 [60368] #16 0x0000000000610794 in do_command (thd=0x7f9438bed060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
|
# 2015-02-17T23:28:03 [60368] #17 0x000000000071d476 in do_handle_one_connection (thd_arg=0x7f9438bed060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
|
# 2015-02-17T23:28:03 [60368] #18 0x000000000071cf48 in handle_one_connection (arg=0x7f9438bed060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
|
# 2015-02-17T23:28:03 [60368] #19 0x00007f945caa4e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
# 2015-02-17T23:28:03 [60368] #20 0x00007f945c1d1cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
# 2015-02-17T23:28:03 [60368] #21 0x0000000000000000 in ?? ()
|
Crashes on 10.0 revno 45600 (9 crashes out of 10 trials)
Happened once |
# 2015-02-18T00:23:17 [64109] #3 <signal handler called>
|
# 2015-02-18T00:23:17 [64109] #4 0x00000000006b97d8 in create_tmp_table (thd=0x7f175706a070, param=0x7f174483dff0, fields=..., group=0x0, distinct=false, save_sum_fields=false, selec
|
t_options=2684619520, rows_limit=18446744073709551615, table_alias=0xf1fabf "", do_not_open=false, keep_row_order=false) at /home/elenst/bzr/10.0/sql/sql_select.cc:15951
|
# 2015-02-18T00:23:17 [64109] #5 0x0000000000695809 in JOIN::init_execution (this=0x7f174483de00) at /home/elenst/bzr/10.0/sql/sql_select.cc:1981
|
# 2015-02-18T00:23:17 [64109] #6 0x0000000000697a41 in JOIN::exec_inner (this=0x7f174483de00) at /home/elenst/bzr/10.0/sql/sql_select.cc:2577
|
# 2015-02-18T00:23:17 [64109] #7 0x0000000000696d26 in JOIN::exec (this=0x7f174483de00) at /home/elenst/bzr/10.0/sql/sql_select.cc:2370
|
# 2015-02-18T00:23:17 [64109] #8 0x000000000069a343 in mysql_select (thd=0x7f175706a070, rref_pointer_array=0x7f175706e6e8, tables=0x7f1752c53d20, wild_num=1, fields=..., conds=0x7f1
|
7477ec3c8, og_num=5, order=0x7f17477ec5b0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f17477edfa0, unit=0x7f175706dd80, select_lex=0x7f175706e470) at /home/elenst/bzr/10.0/sql/sql_select.cc:3310
|
# 2015-02-18T00:23:17 [64109] #9 0x000000000069046f in handle_select (thd=0x7f175706a070, lex=0x7f175706dcb8, result=0x7f17477edfa0, setup_tables_done_option=0) at /home/elenst/bzr/1
|
0.0/sql/sql_select.cc:373
|
# 2015-02-18T00:23:17 [64109] #10 0x000000000066340e in execute_sqlcom_select (thd=0x7f175706a070, all_tables=0x7f1752c53d20) at /home/elenst/bzr/10.0/sql/sql_parse.cc:5258
|
# 2015-02-18T00:23:17 [64109] #11 0x000000000065b592 in mysql_execute_command (thd=0x7f175706a070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:2546
|
# 2015-02-18T00:23:17 [64109] #12 0x00000000006660d4 in mysql_parse (thd=0x7f175706a070, rawbuf=0x7f1752c53088 "SELECT * FROM (INFORMATION_SCHEMA.`INNODB_METRICS` AS table1 INNER JOIN INFORMATION_SCHEMA.`VIEWS` AS table2 ON ( table2.`TABLE_NAME` = table1.`MAX_COUNT` ) ) WHERE NOT ( ( ( ( table1.`MIN_COUNT` <> table1.`TIME_DISABLED` AND table2.`TABLE_NAME` <= '2006
|
-12-01 17:14:22.039695') OR table2.`DEFINER` IN ( 4, 1, 6 )) AND table2.`SECURITY_TYPE` LIKE 'wait/io%') AND table1.`COUNT_RESET` <= table2.`SECURITY_TYPE`) ORDER BY table2.`SECURITY_TYPE`, table2.`DEFINER`, table1.`COMMENT`, table1.`NAME`, table2.`VIEW_DEFINITION` LIMIT 190", length=529, parser_state=0x7f1778e88640) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6513
|
# 2015-02-18T00:23:17 [64109] #13 0x000000000065878b in dispatch_command (command=COM_QUERY, thd=0x7f175706a070, packet=0x7f1757070071 " SELECT * FROM (INFORMATION_SCHEMA.`INNODB_METRICS` AS table1 INNER JOIN INFORMATION_SCHEMA.`VIEWS` AS table2 ON ( table2.`TABLE_NAME` = table1.`MAX_COUNT` ) ) WHERE NOT ( ( ( ( table1.`MIN_COUNT` <> table1.`TIME_DISABLED` AND table2.`TABLE_NAME` <= '2006-12-01 17:14:22.039695') OR table2.`DEFINER` IN ( 4, 1, 6 )) AND table2.`SECURITY_TYPE` LIKE 'wait/io%') AND table1.`COUNT_RESET` <= table2.`SECURITY_TYPE`) ORDER BY table2.`SECURITY_TYPE`, table2.`DEFINER`, table1.`COMMENT`, table1.`NAME`, table2.`VIEW_DEFINITION` LIMIT 190", packet_length=530) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1300
|
# 2015-02-18T00:23:17 [64109] #14 0x0000000000657ada in do_command (thd=0x7f175706a070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:996
|
# 2015-02-18T00:23:17 [64109] #15 0x0000000000780141 in do_handle_one_connection (thd_arg=0x7f175706a070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1375
|
# 2015-02-18T00:23:17 [64109] #16 0x000000000077fea7 in handle_one_connection (arg=0x7f175706a070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1289
|
# 2015-02-18T00:23:17 [64109] #17 0x00007f177a410e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
# 2015-02-18T00:23:17 [64109] #18 0x00007f1779300cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
# 2015-02-18T00:23:17 [64109] #19 0x0000000000000000 in ?? ()
|
Happened 4 times |
# 2015-02-18T00:26:17 [64514] #3 <signal handler called>
|
# 2015-02-18T00:26:17 [64514] #4 0x000000000062b5c3 in Item::delete_self (this=0x7fd18f53f7f8) at /home/elenst/bzr/10.0/sql/item.h:1524
|
# 2015-02-18T00:26:17 [64514] #5 0x00000000006241cc in Query_arena::free_items (this=0x7fd19e6c3088) at /home/elenst/bzr/10.0/sql/sql_class.cc:3319
|
# 2015-02-18T00:26:17 [64514] #6 0x000000000061fac6 in THD::cleanup_after_query (this=0x7fd19e6c3070) at /home/elenst/bzr/10.0/sql/sql_class.cc:2070
|
# 2015-02-18T00:26:17 [64514] #7 0x000000000066620a in mysql_parse (thd=0x7fd19e6c3070, rawbuf=0x7fd18f48c088 "SELECT * FROM INFORMATION_SCHEMA.`REFERENTIAL_CONSTRAINTS` AS table1 WHERE (NOT ( table1.`MATCH_OPTION` LIKE 'wait/synch%' AND table1.`CONSTRAINT_SCHEMA` LIKE '%myisam%') AND table1.`CONSTRAINT_CATALOG` < 5) ORDER BY table1.`UNIQUE_CONSTRAINT_SCHEMA`, table1.`UNIQUE_CONSTRAINT_NAME`, table1.`MATCH_OPTION`, table1.`DELETE_RULE` LIMIT 191", length=338, parser_state=0x7fd1bc03e640) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6534
|
# 2015-02-18T00:26:17 [64514] #8 0x000000000065878b in dispatch_command (command=COM_QUERY, thd=0x7fd19e6c3070, packet=0x7fd19e6cf071 "", packet_length=339) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1300
|
# 2015-02-18T00:26:17 [64514] #9 0x0000000000657ada in do_command (thd=0x7fd19e6c3070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:996
|
# 2015-02-18T00:26:17 [64514] #10 0x0000000000780141 in do_handle_one_connection (thd_arg=0x7fd19e6c3070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1375
|
# 2015-02-18T00:26:17 [64514] #11 0x000000000077fea7 in handle_one_connection (arg=0x7fd19e6c3070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1289
|
# 2015-02-18T00:26:17 [64514] #12 0x00007fd1bb313e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
# 2015-02-18T00:26:17 [64514] #13 0x00007fd1ba203cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
# 2015-02-18T00:26:17 [64514] #14 0x0000000000000000 in ?? ()
|
Happened once |
# 2015-02-18T00:31:51 [65310] #3 <signal handler called>
|
# 2015-02-18T00:31:51 [65310] #4 0x00000000005a4ede in String::free (this=0x3636b5693f459d10) at /home/elenst/bzr/10.0/sql/sql_string.h:263
|
# 2015-02-18T00:31:51 [65310] #5 0x00000000005a4e6c in String::~String (this=0x3636b5693f459d10, __in_chrg=<optimised out>) at /home/elenst/bzr/10.0/sql/sql_string.h:119
|
# 2015-02-18T00:31:51 [65310] #6 0x000000000089f6fa in Arg_comparator::~Arg_comparator (this=0x3636b5693f459c88, __in_chrg=<optimised out>) at /home/elenst/bzr/10.0/sql/item_cmpfunc.h:39
|
# 2015-02-18T00:31:51 [65310] #7 0x000000000089f782 in Arg_comparator::cleanup (this=0x7f330b0467c8) at /home/elenst/bzr/10.0/sql/item_cmpfunc.h:115
|
# 2015-02-18T00:31:51 [65310] #8 0x000000000089fb7a in Item_bool_func2::cleanup (this=0x7f330b046708) at /home/elenst/bzr/10.0/sql/item_cmpfunc.h:402
|
# 2015-02-18T00:31:51 [65310] #9 0x000000000062b5c5 in Item::delete_self (this=0x7f330b046708) at /home/elenst/bzr/10.0/sql/item.h:1524
|
# 2015-02-18T00:31:51 [65310] #10 0x00000000006241cc in Query_arena::free_items (this=0x7f331804f088) at /home/elenst/bzr/10.0/sql/sql_class.cc:3319
|
# 2015-02-18T00:31:51 [65310] #11 0x000000000061fac6 in THD::cleanup_after_query (this=0x7f331804f070) at /home/elenst/bzr/10.0/sql/sql_class.cc:2070
|
# 2015-02-18T00:31:51 [65310] #12 0x000000000066620a in mysql_parse (thd=0x7f331804f070, rawbuf=0x7f3313c53088 "SELECT * FROM (INFORMATION_SCHEMA.`TABLE_PRIVILEGES` AS table1 INNER JOIN test.`view_BB` AS table2 ON ( table2.`col_int_key` = table1.`GRANTEE` ) ) WHERE ( ( (NOT ( (NOT ( ( ( (NOT ( table2.`col_date_key` = table1.`TABLE_NAME` AND table2.`col_datetime_key` < 6) OR table1.`TABLE_CATALOG` > table2.`col_date_nokey`) OR table1.`IS_GRANTABLE` LIKE 'wait/synch/rwlock%') OR table1.`TABLE_SCHEMA` <> table2.`col_time_nokey`) OR table2.`col_varchar_key` <= 2) AND table1.`IS_GRANTABLE` IN ( 5, 8, 8 )) OR table2.`col_int_nokey` LIKE 'wait/synch/cond%') OR table2.`col_int_key` IN ( 9, 2, 1 )) AND table1.`TABLE_NAME` > 'zs') AND table1.`TABLE_SCHEMA` IN ( 2, 3, 6 )) ORDER BY table1.`PRIVILEGE_TYPE` LIMIT 179", length=703, parser_state=0x7f3339d77640) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6534
|
# 2015-02-18T00:31:51 [65310] #13 0x000000000065878b in dispatch_command (command=COM_QUERY, thd=0x7f331804f070, packet=0x7f3318055071 "", packet_length=704) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1300
|
# 2015-02-18T00:31:51 [65310] #14 0x0000000000657ada in do_command (thd=0x7f331804f070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:996
|
# 2015-02-18T00:31:51 [65310] #15 0x0000000000780141 in do_handle_one_connection (thd_arg=0x7f331804f070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1375
|
# 2015-02-18T00:31:51 [65310] #16 0x000000000077fea7 in handle_one_connection (arg=0x7f331804f070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1289
|
# 2015-02-18T00:31:51 [65310] #17 0x00007f333b348e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
# 2015-02-18T00:31:51 [65310] #18 0x00007f333a238cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
# 2015-02-18T00:31:51 [65310] #19 0x0000000000000000 in ?? ()
|
Happened once |
# 2015-02-18T00:34:08 [427] #3 <signal handler called>
|
# 2015-02-18T00:34:08 [427] #4 0x00000000005ad8f5 in Protocol::send_result_set_metadata (this=0x7f0f1ac395f8, list=0x7f0f1ac3d588, flags=5) at /home/elenst/bzr/10.0/sql/protocol.cc:756
|
# 2015-02-18T00:34:08 [427] #5 0x0000000000620b03 in select_send::send_result_set_metadata (this=0x7f0f1a449fd8, list=..., flags=5) at /home/elenst/bzr/10.0/sql/sql_class.cc:2481
|
# 2015-02-18T00:34:08 [427] #6 0x0000000000699a5a in JOIN::exec_inner (this=0x7f0f0d3e8f18) at /home/elenst/bzr/10.0/sql/sql_select.cc:3080
|
# 2015-02-18T00:34:08 [427] #7 0x0000000000696d26 in JOIN::exec (this=0x7f0f0d3e8f18) at /home/elenst/bzr/10.0/sql/sql_select.cc:2370
|
# 2015-02-18T00:34:08 [427] #8 0x000000000069a343 in mysql_select (thd=0x7f0f1ac39070, rref_pointer_array=0x7f0f1ac3d6e8, tables=0x7f0f1a448310, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f0f1a449fd8, unit=0x7f0f1ac3cd80, select_lex=0x7f0f1ac3d470) at /home/elenst/bzr/10.0/sql/sql_select.cc:3310
|
# 2015-02-18T00:34:08 [427] #9 0x000000000069046f in handle_select (thd=0x7f0f1ac39070, lex=0x7f0f1ac3ccb8, result=0x7f0f1a449fd8, setup_tables_done_option=0) at /home/elenst/bzr/10.0/sql/sql_select.cc:373
|
# 2015-02-18T00:34:08 [427] #10 0x000000000066340e in execute_sqlcom_select (thd=0x7f0f1ac39070, all_tables=0x7f0f1a448310) at /home/elenst/bzr/10.0/sql/sql_parse.cc:5258
|
# 2015-02-18T00:34:08 [427] #11 0x000000000065b592 in mysql_execute_command (thd=0x7f0f1ac39070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:2546
|
# 2015-02-18T00:34:08 [427] #12 0x00000000006660d4 in mysql_parse (thd=0x7f0f1ac39070, rawbuf=0x7f0f1a448088 "SELECT * FROM INFORMATION_SCHEMA.`ROUTINES` AS table1 LIMIT 37", length=62, parser_state=0x7f0f1b1cd640) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6513
|
# 2015-02-18T00:34:08 [427] #13 0x000000000065878b in dispatch_command (command=COM_QUERY, thd=0x7f0f1ac39070, packet=0x7f0f1ac3f071 "", packet_length=63) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1300
|
# 2015-02-18T00:34:08 [427] #14 0x0000000000657ada in do_command (thd=0x7f0f1ac39070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:996
|
# 2015-02-18T00:34:08 [427] #15 0x0000000000780141 in do_handle_one_connection (thd_arg=0x7f0f1ac39070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1375
|
# 2015-02-18T00:34:08 [427] #16 0x000000000077fea7 in handle_one_connection (arg=0x7f0f1ac39070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1289
|
# 2015-02-18T00:34:08 [427] #17 0x00007f0f3dc1ee9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
# 2015-02-18T00:34:08 [427] #18 0x00007f0f3cb0ecbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
# 2015-02-18T00:34:08 [427] #19 0x0000000000000000 in ?? ()
|
Happened once |
# 2015-02-18T00:44:19 [1015] #3 <signal handler called>
|
# 2015-02-18T00:44:19 [1015] #4 0x00000000005b096c in Field::is_null (this=0x7f561beab758, row_offset=0) at /home/elenst/bzr/10.0/sql/field.h:676
|
# 2015-02-18T00:44:19 [1015] #5 0x00000000007b9f3a in JOIN_CACHE::read_record_field (this=0x7f560dc4b550, copy=0x7f560dc4b7e8, blob_in_rec_buff=false) at /home/elenst/bzr/10.0/sql/sql_join_c
|
ache.cc:1813
|
# 2015-02-18T00:44:19 [1015] #6 0x00000000007b9dab in JOIN_CACHE::read_all_record_fields (this=0x7f560dc4b550) at /home/elenst/bzr/10.0/sql/sql_join_cache.cc:1745
|
# 2015-02-18T00:44:19 [1015] #7 0x00000000007b9ab5 in JOIN_CACHE::get_record (this=0x7f560dc4b550) at /home/elenst/bzr/10.0/sql/sql_join_cache.cc:1612
|
# 2015-02-18T00:44:19 [1015] #8 0x00000000007bc98c in JOIN_CACHE_BNL::read_next_candidate_for_match (this=0x7f560dc4b550, rec_ptr=0x7f560dc06298 "") at /home/elenst/bzr/10.0/sql/sql_join_cac
|
he.cc:3573
|
# 2015-02-18T00:44:19 [1015] #9 0x00000000007bac9a in JOIN_CACHE::join_matching_records (this=0x7f560dc4b550, skip_last=false) at /home/elenst/bzr/10.0/sql/sql_join_cache.cc:2294
|
# 2015-02-18T00:44:19 [1015] #10 0x00000000007ba6f9 in JOIN_CACHE::join_records (this=0x7f560dc4b550, skip_last=false) at /home/elenst/bzr/10.0/sql/sql_join_cache.cc:2092
|
# 2015-02-18T00:44:19 [1015] #11 0x00000000006be3f4 in sub_select_cache (join=0x7f5608406088, join_tab=0x7f5608b14c28, end_of_records=true) at /home/elenst/bzr/10.0/sql/sql_select.cc:17569
|
# 2015-02-18T00:44:19 [1015] #12 0x00000000006be5f0 in sub_select (join=0x7f5608406088, join_tab=0x7f5608b14900, end_of_records=true) at /home/elenst/bzr/10.0/sql/sql_select.cc:17739
|
# 2015-02-18T00:44:19 [1015] #13 0x00000000006be0ee in do_select (join=0x7f5608406088, fields=0x7f561d853588, table=0x0, procedure=0x0) at /home/elenst/bzr/10.0/sql/sql_select.cc:17450
|
# 2015-02-18T00:44:19 [1015] #14 0x0000000000699a86 in JOIN::exec_inner (this=0x7f5608406088) at /home/elenst/bzr/10.0/sql/sql_select.cc:3081
|
# 2015-02-18T00:44:19 [1015] #15 0x0000000000696d26 in JOIN::exec (this=0x7f5608406088) at /home/elenst/bzr/10.0/sql/sql_select.cc:2370
|
# 2015-02-18T00:44:19 [1015] #16 0x000000000069a343 in mysql_select (thd=0x7f561d84f070, rref_pointer_array=0x7f561d8536e8, tables=0x7f5619453a80, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f5608ea1fb8, unit=0x7f561d852d80, select_lex=0x7f561d853470) at /home/elenst/bzr/10.0/sql/sql_select.cc:3310
|
# 2015-02-18T00:44:19 [1015] #17 0x000000000069046f in handle_select (thd=0x7f561d84f070, lex=0x7f561d852cb8, result=0x7f5608ea1fb8, setup_tables_done_option=0) at /home/elenst/bzr/10.0/sql/sql_select.cc:373
|
# 2015-02-18T00:44:19 [1015] #18 0x000000000066340e in execute_sqlcom_select (thd=0x7f561d84f070, all_tables=0x7f5619453a80) at /home/elenst/bzr/10.0/sql/sql_parse.cc:5258
|
# 2015-02-18T00:44:19 [1015] #19 0x000000000065b592 in mysql_execute_command (thd=0x7f561d84f070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:2546
|
# 2015-02-18T00:44:19 [1015] #20 0x00000000006660d4 in mysql_parse (thd=0x7f561d84f070, rawbuf=0x7f5619453088 "SELECT * FROM (INFORMATION_SCHEMA.`COLUMN_PRIVILEGES` AS table1 RIGHT OUTER JOIN INFORMATION_SCHEMA.`INNODB_METRICS` AS table2 ON ( table2.`NAME` = table1.`PRIVILEGE_TYPE` ) ) LIMIT 14", length=184, parser_state=0x7f563f47f640) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6513
|
# 2015-02-18T00:44:19 [1015] #21 0x000000000065878b in dispatch_command (command=COM_QUERY, thd=0x7f561d84f070, packet=0x7f561d855071 "", packet_length=185) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1300
|
# 2015-02-18T00:44:19 [1015] #22 0x0000000000657ada in do_command (thd=0x7f561d84f070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:996
|
# 2015-02-18T00:44:19 [1015] #23 0x0000000000780141 in do_handle_one_connection (thd_arg=0x7f561d84f070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1375
|
# 2015-02-18T00:44:19 [1015] #24 0x000000000077fea7 in handle_one_connection (arg=0x7f561d84f070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1289
|
# 2015-02-18T00:44:19 [1015] #25 0x00007f5640a50e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
# 2015-02-18T00:44:19 [1015] #26 0x00007f563f940cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
# 2015-02-18T00:44:19 [1015] #27 0x0000000000000000 in ?? ()
|
Happened once |
# 2015-02-18T00:49:31 [1968] #3 <signal handler called>
|
# 2015-02-18T00:49:31 [1968] #4 0x0000000000871083 in Item_field::used_tables (this=0x7f34e1c61720) at /home/elenst/bzr/10.0/sql/item.cc:2691
|
# 2015-02-18T00:49:31 [1968] #5 0x00000000005b2155 in Item::const_item (this=0x7f34e1c61720) at /home/elenst/bzr/10.0/sql/item.h:1101
|
# 2015-02-18T00:49:31 [1968] #6 0x00000000006b992c in create_tmp_table (thd=0x7f34f1fe9070, param=0x7f34e1c52278, fields=..., group=0x0, distinct=false, save_sum_fields=false, select_options
|
=2684619520, rows_limit=18446744073709551615, table_alias=0xf1fabf "", do_not_open=false, keep_row_order=false) at /home/elenst/bzr/10.0/sql/sql_select.cc:15970
|
# 2015-02-18T00:49:31 [1968] #7 0x0000000000695809 in JOIN::init_execution (this=0x7f34e1c52088) at /home/elenst/bzr/10.0/sql/sql_select.cc:1981
|
# 2015-02-18T00:49:31 [1968] #8 0x0000000000697a41 in JOIN::exec_inner (this=0x7f34e1c52088) at /home/elenst/bzr/10.0/sql/sql_select.cc:2577
|
# 2015-02-18T00:49:31 [1968] #9 0x0000000000696d26 in JOIN::exec (this=0x7f34e1c52088) at /home/elenst/bzr/10.0/sql/sql_select.cc:2370
|
# 2015-02-18T00:49:31 [1968] #10 0x000000000069a343 in mysql_select (thd=0x7f34f1fe9070, rref_pointer_array=0x7f34f1fed6e8, tables=0x7f34e9d72af0, wild_num=1, fields=..., conds=0x0, og_num=1,
|
order=0x7f34e9d73da0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f34e1c5fc68, unit=0x7f34f1fecd80, select_lex=0x7f34f1fed470) at /home/elenst/bzr/10.0/sql/sq
|
l_select.cc:3310
|
# 2015-02-18T00:49:31 [1968] #11 0x000000000069046f in handle_select (thd=0x7f34f1fe9070, lex=0x7f34f1feccb8, result=0x7f34e1c5fc68, setup_tables_done_option=0) at /home/elenst/bzr/10.0/sql/s
|
ql_select.cc:373
|
# 2015-02-18T00:49:31 [1968] #12 0x000000000066340e in execute_sqlcom_select (thd=0x7f34f1fe9070, all_tables=0x7f34e9d72af0) at /home/elenst/bzr/10.0/sql/sql_parse.cc:5258
|
# 2015-02-18T00:49:31 [1968] #13 0x000000000065b592 in mysql_execute_command (thd=0x7f34f1fe9070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:2546
|
# 2015-02-18T00:49:31 [1968] #14 0x00000000006660d4 in mysql_parse (thd=0x7f34f1fe9070, rawbuf=0x7f34e9d72088 "SELECT * FROM (INFORMATION_SCHEMA.`INNODB_BUFFER_PAGE` AS table1 LEFT JOIN perfo
|
rmance_schema.`events_stages_history_long` AS table2 ON ( table2.`NESTING_EVENT_ID` = table1.`NUMBER_RECORDS` ) ) ORDER BY table2.`NESTING_EVENT_TYPE` LIMIT 145", length=240, parser_state=0x7
|
f34fb2ff640) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6513
|
# 2015-02-18T00:49:31 [1968] #15 0x000000000065878b in dispatch_command (command=COM_QUERY, thd=0x7f34f1fe9070, packet=0x7f34f1fef071 " SELECT * FROM (INFORMATION_SCHEMA.`INNODB_BUFFER_PAGE`
|
AS table1 LEFT JOIN performance_schema.`events_stages_history_long` AS table2 ON ( table2.`NESTING_EVENT_ID` = table1.`NUMBER_RECORDS` ) ) ORDER BY table2.`NESTING_EVENT_TYPE` LIMIT 145", pac
|
ket_length=241) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1300
|
# 2015-02-18T00:49:31 [1968] #16 0x0000000000657ada in do_command (thd=0x7f34f1fe9070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:996
|
# 2015-02-18T00:49:31 [1968] #17 0x0000000000780141 in do_handle_one_connection (thd_arg=0x7f34f1fe9070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1375
|
# 2015-02-18T00:49:31 [1968] #18 0x000000000077fea7 in handle_one_connection (arg=0x7f34f1fe9070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1289
|
# 2015-02-18T00:49:31 [1968] #19 0x00007f350e83fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
# 2015-02-18T00:49:31 [1968] #20 0x00007f350d72fcbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
# 2015-02-18T00:49:31 [1968] #21 0x0000000000000000 in ?? ()
|
Some other stack traces
observed on this or very similar tests outside the "10 trials" experiment. Row numbers might be slightly off (previous revisions)
# 2015-02-17T19:38:52 [22318] #6 <signal handler called>
|
# 2015-02-17T19:38:52 [22318] #7 0x00000000008aa624 in Item_cond::walk (this=0x7f2e650bb6d0, processor=&virtual table offset 688, walk_subquery=true, arg=0x7f2e621d5088
|
"\030Z\035b.\177") at /home/elenst/bzr/10.0/sql/item_cmpfunc.cc:4517
|
# 2015-02-17T19:38:52 [22318] #8 0x0000000000864c80 in find_all_keys (param=0x7f2e95d99ef0, select=0x7f2e650bb810, fs_info=0x7f2e95d99e80, buffpek_pointers=0x7f2e95d9a1
|
10, tempfile=0x7f2e95d99f70, pq=0x0, found_rows=0x7f2e95d9a3b8) at /home/elenst/bzr/10.0/sql/filesort.cc:729
|
# 2015-02-17T19:38:52 [22318] #9 0x00000000008639b6 in filesort (thd=0x7f2e7b828070, table=0x7f2e621d5088, sortorder=0x7f2e7788f170, s_length=2, select=0x7f2e650bb810,
|
max_rows=86, sort_positions=false, examined_rows=0x7f2e95d9a3c0, found_rows=0x7f2e95d9a3b8) at /home/elenst/bzr/10.0/sql/filesort.cc:298
|
# 2015-02-17T19:38:52 [22318] #10 0x00000000006e2731 in create_sort_index (thd=0x7f2e7b828070, join=0x7f2e650b6378, order=0x7f2e7784bc48, filesort_limit=86, select_limit
|
=86, is_order_by=true) at /home/elenst/bzr/10.0/sql/sql_select.cc:20766
|
# 2015-02-17T19:38:52 [22318] #11 0x00000000006b7d83 in JOIN::exec_inner (this=0x7f2e650b6378) at /home/elenst/bzr/10.0/sql/sql_select.cc:3051
|
# 2015-02-17T19:38:52 [22318] #12 0x00000000006b549c in JOIN::exec (this=0x7f2e650b6378) at /home/elenst/bzr/10.0/sql/sql_select.cc:2370
|
# 2015-02-17T19:38:52 [22318] #13 0x00000000006b8831 in mysql_select (thd=0x7f2e7b828070, rref_pointer_array=0x7f2e7b82c6e8, tables=0x7f2e7784a498, wild_num=1, fields=..
|
., conds=0x7f2e7784b9f8, og_num=3, order=0x7f2e7784bc48, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f2e650b6358, unit=0x7f2e7b82bd80, se
|
lect_lex=0x7f2e7b82c470) at /home/elenst/bzr/10.0/sql/sql_select.cc:3310
|
# 2015-02-17T19:38:52 [22318] #14 0x00000000006aee01 in handle_select (thd=0x7f2e7b828070, lex=0x7f2e7b82bcb8, result=0x7f2e650b6358, setup_tables_done_option=0) at /hom
|
e/elenst/bzr/10.0/sql/sql_select.cc:373
|
# 2015-02-17T19:38:52 [22318] #15 0x0000000000683660 in execute_sqlcom_select (thd=0x7f2e7b828070, all_tables=0x7f2e7784a498) at /home/elenst/bzr/10.0/sql/sql_parse.cc:5
|
258
|
# 2015-02-17T19:38:52 [22318] #16 0x000000000067b991 in mysql_execute_command (thd=0x7f2e7b828070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:2546
|
# 2015-02-17T19:38:52 [22318] #17 0x00000000006861b7 in mysql_parse (thd=0x7f2e7b828070, rawbuf=0x7f2e7784a088 "SELECT * FROM INFORMATION_SCHEMA.`STATISTICS` AS table1 W
|
HERE NOT ( ( table1.`INDEX_NAME` IN ( 6, 5, 6 ) OR table1.`COLUMN_NAME` LIKE '%myisam%') OR table1.`NULLABLE` LIKE 'wait%') ORDER BY table1.`SEQ_IN_INDEX`, table1.`COMME
|
NT`, table1.`COMMENT` LIMIT 86", length=256, parser_state=0x7f2e95d9b650) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6513
|
# 2015-02-17T19:38:52 [22318] #18 0x0000000000678c01 in dispatch_command (command=COM_QUERY, thd=0x7f2e7b828070, packet=0x7f2e813ed071 " SELECT * FROM INFORMATION_SCHEMA
|
.`STATISTICS` AS table1 WHERE NOT ( ( table1.`INDEX_NAME` IN ( 6, 5, 6 ) OR table1.`COLUMN_NAME` LIKE '%myisam%') OR table1.`NULLABLE` LIKE 'wait%') ORDER BY table1.`SEQ
|
_IN_INDEX`, table1.`COMMENT`, table1.`COMMENT` LIMIT 86", packet_length=257) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1300
|
# 2015-02-17T19:38:52 [22318] #19 0x0000000000677f97 in do_command (thd=0x7f2e7b828070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:996
|
# 2015-02-17T19:38:52 [22318] #20 0x00000000007953ef in do_handle_one_connection (thd_arg=0x7f2e7b828070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1375
|
# 2015-02-17T19:38:52 [22318] #21 0x0000000000795142 in handle_one_connection (arg=0x7f2e7b828070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1289
|
# 2015-02-17T19:38:52 [22318] #22 0x00007f2e95af8b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
# 2015-02-17T19:38:52 [22318] #23 0x00007f2e93dae70d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
# 2015-02-17T20:06:26 [23292] #6 <signal handler called>
|
# 2015-02-17T20:06:26 [23292] #7 0x00000000006e6832 in change_refs_to_tmp_fields (thd=0x7faeb580e070, ref_pointer_array=0x7faea24b39c0, res_selected_fields=..., res_all
|
_fields=..., elements=31, all_fields=...) at /home/elenst/bzr/10.0/sql/sql_select.cc:22419
|
# 2015-02-17T20:06:26 [23292] #8 0x00000000006b65da in JOIN::exec_inner (this=0x7faeb15899a0) at /home/elenst/bzr/10.0/sql/sql_select.cc:2654
|
# 2015-02-17T20:06:26 [23292] #9 0x00000000006b549c in JOIN::exec (this=0x7faeb15899a0) at /home/elenst/bzr/10.0/sql/sql_select.cc:2370
|
# 2015-02-17T20:06:26 [23292] #10 0x00000000006b8831 in mysql_select (thd=0x7faeb580e070, rref_pointer_array=0x7faeb58126e8, tables=0x7faeb1455c08, wild_num=1, fields=..
|
., conds=0x7faeb1664e48, og_num=1, order=0x7faeb1664f78, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7faeb1589980, unit=0x7faeb5811d80, se
|
lect_lex=0x7faeb5812470) at /home/elenst/bzr/10.0/sql/sql_select.cc:3310
|
# 2015-02-17T20:06:26 [23292] #11 0x00000000006aee01 in handle_select (thd=0x7faeb580e070, lex=0x7faeb5811cb8, result=0x7faeb1589980, setup_tables_done_option=0) at /hom
|
e/elenst/bzr/10.0/sql/sql_select.cc:373
|
# 2015-02-17T20:06:26 [23292] #12 0x0000000000683660 in execute_sqlcom_select (thd=0x7faeb580e070, all_tables=0x7faeb1455c08) at /home/elenst/bzr/10.0/sql/sql_parse.cc:5
|
258
|
# 2015-02-17T20:06:26 [23292] #13 0x000000000067b991 in mysql_execute_command (thd=0x7faeb580e070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:2546
|
# 2015-02-17T20:06:26 [23292] #14 0x00000000006861b7 in mysql_parse (thd=0x7faeb580e070, rawbuf=0x7faeb1455088 "SELECT * FROM (test.`D` AS table1 STRAIGHT_JOIN INFORMATI
|
ON_SCHEMA.`COLUMNS` AS table2 ON ( table2.`DATA_TYPE` = table1.`col_datetime_key` ) ) WHERE NOT ( ( ( table1.`col_varchar_key` <> table1.`col_datetime_nokey` AND table2.
|
`NUMERIC_PRECISION` <> table2.`DATETIME_PRECISION`) OR table1.`col_int_nokey` LIKE 'wait/synch/mutex/%') AND table2.`COLUMN_TYPE` >= table1.`col_time_key`) ORDER BY tabl
|
e2.`COLUMN_COMMENT` LIMIT 44", length=423, parser_state=0x7faecdd60650) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6513
|
# 2015-02-17T20:06:26 [23292] #15 0x0000000000678c01 in dispatch_command (command=COM_QUERY, thd=0x7faeb580e070, packet=0x7faeb5814071 " SELECT * FROM (test.`D` AS table
|
1 STRAIGHT_JOIN INFORMATION_SCHEMA.`COLUMNS` AS table2 ON ( table2.`DATA_TYPE` = table1.`col_datetime_key` ) ) WHERE NOT ( ( ( table1.`col_varchar_key` <> table1.`col_da
|
tetime_nokey` AND table2.`NUMERIC_PRECISION` <> table2.`DATETIME_PRECISION`) OR table1.`col_int_nokey` LIKE 'wait/synch/mutex/%') AND table2.`COLUMN_TYPE` >= table1.`col
|
_time_key`) ORDER BY table2.`COLUMN_COMMENT` LIMIT 44", packet_length=424) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1300
|
# 2015-02-17T20:06:26 [23292] #16 0x0000000000677f97 in do_command (thd=0x7faeb580e070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:996
|
# 2015-02-17T20:06:26 [23292] #17 0x00000000007953ef in do_handle_one_connection (thd_arg=0x7faeb580e070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1375
|
# 2015-02-17T20:06:26 [23292] #18 0x0000000000795142 in handle_one_connection (arg=0x7faeb580e070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1289
|
# 2015-02-17T20:06:26 [23292] #19 0x00007faecfb88b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
# 2015-02-17T20:06:26 [23292] #20 0x00007faecde3e70d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
# 2015-02-17T20:09:57 [23691] #6 <signal handler called>
|
# 2015-02-17T20:09:57 [23691] #7 __memcpy_ssse3 () at ../sysdeps/x86_64/multiarch/memcpy-ssse3.S:91
|
# 2015-02-17T20:09:57 [23691] #8 0x0000000000d5029e in write_tail (info=0x7faf434dc070, block=0x7faf4002fc00, row_part=0x8f8f8f8f8f900f5f <Address 0x8f8f8f8f8f900f5f out of bounds>, org_length=4031) at /home/elenst/bzr/10.0/storage/maria/ma_blockrec.c:1964
|
# 2015-02-17T20:09:57 [23691] #9 0x0000000000d52695 in write_block_record (info=0x7faf434dc070, old_record=0x0, record=0x7faf43494088 "\377\222", row=0x7faf434dc0c8, bitmap_blocks=0x7faf434dc0c8, head_block_is_read=1 '\001', row_pos=0x7faf6e53be20, undo_lsn=1, old_record_checksum=0) at /home/elenst/bzr/10.0/storage/maria/ma_blockrec.c:2895
|
# 2015-02-17T20:09:57 [23691] #10 0x0000000000d53fca in allocate_and_write_block_record (info=0x7faf434dc070, record=0x7faf43494088 "\377\222", row=0x7faf434dc0c8, undo_lsn=1) at /home/elenst/bzr/10.0/storage/maria/ma_blockrec.c:3528
|
# 2015-02-17T20:09:57 [23691] #11 0x0000000000d540de in _ma_write_init_block_record (info=0x7faf434dc070, record=0x7faf43494088 "\377\222") at /home/elenst/bzr/10.0/storage/maria/ma_blockrec.c:3568
|
# 2015-02-17T20:09:57 [23691] #12 0x0000000000d649be in maria_write (info=0x7faf434dc070, record=0x7faf43494088 "\377\222") at /home/elenst/bzr/10.0/storage/maria/ma_write.c:156
|
# 2015-02-17T20:09:57 [23691] #13 0x0000000000cf4b25 in ha_maria::write_row (this=0x7faf45993888, buf=0x7faf43494088 "\377\222") at /home/elenst/bzr/10.0/storage/maria/ha_maria.cc:1280
|
# 2015-02-17T20:09:57 [23691] #14 0x00000000006f0990 in handler::ha_write_tmp_row (this=0x7faf45993888, buf=0x7faf43494088 "\377\222") at /home/elenst/bzr/10.0/sql/sql_class.h:4942
|
# 2015-02-17T20:09:57 [23691] #15 0x00000000006de6fa in end_write (join=0x7faf40c86968, join_tab=0x7faf409645f0, end_of_records=false) at /home/elenst/bzr/10.0/sql/sql_select.cc:19119
|
# 2015-02-17T20:09:57 [23691] #16 0x00000000007cfc54 in JOIN_CACHE::generate_full_extensions (this=0x7faf40964b48, rec_ptr=0x7faf4352d125 "\001\222") at /home/elenst/bzr/10.0/sql/sql_join_cache.cc:2403
|
# 2015-02-17T20:09:57 [23691] #17 0x00000000007cff1f in JOIN_CACHE::join_null_complements (this=0x7faf40964b48, skip_last=false) at /home/elenst/bzr/10.0/sql/sql_join_cache.cc:2550
|
# 2015-02-17T20:09:57 [23691] #18 0x00000000007cf531 in JOIN_CACHE::join_records (this=0x7faf40964b48, skip_last=false) at /home/elenst/bzr/10.0/sql/sql_join_cache.cc:2126
|
# 2015-02-17T20:09:57 [23691] #19 0x00000000006daef9 in sub_select_cache (join=0x7faf40c86968, join_tab=0x7faf409642c8, end_of_records=false) at /home/elenst/bzr/10.0/sql/sql_select.cc:17589
|
# 2015-02-17T20:09:57 [23691] #20 0x00000000006db960 in evaluate_join_record (join=0x7faf40c86968, join_tab=0x7faf40963fa0, error=0) at /home/elenst/bzr/10.0/sql/sql_select.cc:18007
|
# 2015-02-17T20:09:57 [23691] #21 0x00000000006db3eb in sub_select (join=0x7faf40c86968, join_tab=0x7faf40963fa0, end_of_records=false) at /home/elenst/bzr/10.0/sql/sql_select.cc:17824
|
# 2015-02-17T20:09:57 [23691] #22 0x00000000006daabe in do_select (join=0x7faf40c86968, fields=0x0, table=0x7faf4350d088, procedure=0x0) at /home/elenst/bzr/10.0/sql/sql_select.cc:17447
|
# 2015-02-17T20:09:57 [23691] #23 0x00000000006b63ac in JOIN::exec_inner (this=0x7faf40c86968) at /home/elenst/bzr/10.0/sql/sql_select.cc:2624
|
# 2015-02-17T20:09:57 [23691] #24 0x00000000006b549c in JOIN::exec (this=0x7faf40c86968) at /home/elenst/bzr/10.0/sql/sql_select.cc:2370
|
# 2015-02-17T20:09:57 [23691] #25 0x00000000006b8831 in mysql_select (thd=0x7faf560b4070, rref_pointer_array=0x7faf560b86e8, tables=0x7faf45853af8, wild_num=1, fields=..., conds=0x0, og_num=4, order=0x7faf45854d50, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7faf40c86948, unit=0x7faf560b7d80, select_lex=0x7faf560b8470) at /home/elenst/bzr/10.0/sql/sql_select.cc:3310
|
# 2015-02-17T20:09:57 [23691] #26 0x00000000006aee01 in handle_select (thd=0x7faf560b4070, lex=0x7faf560b7cb8, result=0x7faf40c86948, setup_tables_done_option=0) at /home/elenst/bzr/10.0/sql/sql_select.cc:373
|
# 2015-02-17T20:09:57 [23691] #27 0x0000000000683660 in execute_sqlcom_select (thd=0x7faf560b4070, all_tables=0x7faf45853af8) at /home/elenst/bzr/10.0/sql/sql_parse.cc:5258
|
# 2015-02-17T20:09:57 [23691] #28 0x000000000067b991 in mysql_execute_command (thd=0x7faf560b4070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:2546
|
# 2015-02-17T20:09:57 [23691] #29 0x00000000006861b7 in mysql_parse (thd=0x7faf560b4070, rawbuf=0x7faf45853088 "SELECT * FROM (mysql.`help_topic` AS table1 LEFT OUTER JOIN performance_schema.`session_connect_attrs` AS table2 ON ( table2.`ATTR_VALUE` = table1.`help_category_id` ) ) ORDER BY table1.`example`, table1.`url`, table2.`PROCESSLIST_ID`, table2.`PROCESSLIST_ID` LIMIT 34", length=268, parser_state=0x7faf6e53d650) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6513
|
# 2015-02-17T20:09:57 [23691] #30 0x0000000000678c01 in dispatch_command (command=COM_QUERY, thd=0x7faf560b4070, packet=0x7faf560ba071 " SELECT * FROM (mysql.`help_topic` AS table1 LEFT OUTER JOIN performance_schema.`session_connect_attrs` AS table2 ON ( table2.`ATTR_VALUE` = table1.`help_category_id` ) ) ORDER BY table1.`example`, table1.`url`, table2.`PROCESSLIST_ID`, table2.`PROCESSLIST_ID` LIMIT 34", packet_length=269) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1300
|
# 2015-02-17T20:09:57 [23691] #31 0x0000000000677f97 in do_command (thd=0x7faf560b4070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:996
|
# 2015-02-17T20:09:57 [23691] #32 0x00000000007953ef in do_handle_one_connection (thd_arg=0x7faf560b4070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1375
|
# 2015-02-17T20:09:57 [23691] #33 0x0000000000795142 in handle_one_connection (arg=0x7faf560b4070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1289
|
# 2015-02-17T20:09:57 [23691] #34 0x00007faf703aeb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
# 2015-02-17T20:09:57 [23691] #35 0x00007faf6e66470d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
# 2015-02-17T20:09:57 [23691] #36 0x0000000000000000 in ?? ()
|
# 2015-02-17T19:12:57 [21300] #6 <signal handler called>
|
# 2015-02-17T19:12:57 [21300] #7 0x0000000000894d3a in Item_ident::get_depended_from (this=0x7f960c412730) at /home/elenst/bzr/10.0/sql/item.cc:9761
|
# 2015-02-17T19:12:57 [21300] #8 0x0000000000881c3f in Item_field::used_tables (this=0x7f960c412730) at /home/elenst/bzr/10.0/sql/item.cc:2693
|
# 2015-02-17T19:12:57 [21300] #9 0x00000000008ca2b6 in Item_func::fix_fields (this=0x7f960c412958, thd=0x7f96262da070, ref=0x7f960c412b00) at /home/elenst/bzr/10.0/sql/item_func.cc:224
|
# 2015-02-17T19:12:57 [21300] #10 0x00000000008ab9ad in Item_func_like::fix_fields (this=0x7f960c412958, thd=0x7f96262da070, ref=0x7f960c412b00) at /home/elenst/bzr/10.0/sql/item_cmpfunc.cc:4944
|
# 2015-02-17T19:12:57 [21300] #11 0x00000000008a9fc2 in Item_cond::fix_fields (this=0x7f960c412620, thd=0x7f96262da070, ref=0x7f961f233df0) at /home/elenst/bzr/10.0/sql/item_cmpfunc.cc:4391
|
# 2015-02-17T19:12:57 [21300] #12 0x00000000006279db in setup_conds (thd=0x7f96262da070, tables=0x7f961f072ef8, leaves=..., conds=0x7f961f233df0) at /home/elenst/bzr/10.0/sql/sql_base.cc:8549
|
# 2015-02-17T19:12:57 [21300] #13 0x00000000006f2fc7 in setup_without_group (thd=0x7f96262da070, ref_pointer_array=0x7f9605b34230, tables=0x7f961f072ef8, leaves=..., fields=..., all_fields=..., conds=0x7f961f233df0, order=0x7f960c413f80, group=0x0, hidden_group_fields=0x7f961f233cd0, reserved=0x7f96262de70c) at /home/elenst/bzr/10.0/sql/sql_select.cc:633
|
# 2015-02-17T19:12:57 [21300] #14 0x00000000006afbfe in JOIN::prepare (this=0x7f961f2339d0, rref_pointer_array=0x7f96262de6e8, tables_init=0x7f961f072ef8, wild_num=1, conds_init=0x7f960c412620, og_num=1, order_init=0x7f960c413f80, skip_order_by=false, group_init=0x0, having_init=0x7f960c413e38, proc_param_init=0x0, select_lex_arg=0x7f96262de470, unit_arg=0x7f96262ddd80) at /home/elenst/bzr/10.0/sql/sql_select.cc:790
|
# 2015-02-17T19:12:57 [21300] #15 0x00000000006b8783 in mysql_select (thd=0x7f96262da070, rref_pointer_array=0x7f96262de6e8, tables=0x7f961f072ef8, wild_num=1, fields=..., conds=0x7f960c412620, og_num=1, order=0x7f960c413f80, group=0x0, having=0x7f960c413e38, proc_param=0x0, select_options=2147748608, result=0x7f961f2339b0, unit=0x7f96262ddd80, select_lex=0x7f96262de470) at /home/elenst/bzr/10.0/sql/sql_select.cc:3288
|
# 2015-02-17T19:12:57 [21300] #16 0x00000000006aee01 in handle_select (thd=0x7f96262da070, lex=0x7f96262ddcb8, result=0x7f961f2339b0, setup_tables_done_option=0) at /home/elenst/bzr/10.0/sql/sql_select.cc:373
|
# 2015-02-17T19:12:57 [21300] #17 0x0000000000683660 in execute_sqlcom_select (thd=0x7f96262da070, all_tables=0x7f961f072ef8) at /home/elenst/bzr/10.0/sql/sql_parse.cc:5258
|
# 2015-02-17T19:12:57 [21300] #18 0x000000000067b991 in mysql_execute_command (thd=0x7f96262da070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:2546
|
# 2015-02-17T19:12:57 [21300] #19 0x00000000006861b7 in mysql_parse (thd=0x7f96262da070, rawbuf=0x7f961f072088 "SELECT * FROM (test.`E` AS table1 RIGHT OUTER JOIN test.`CC` AS table2 ON ( table2.`col_date_key` = table1.`col_time_key` ) ) WHERE ( (NOT ( ( ( (NOT (NOT ( ( ( table1.`col_varchar_key` <= '2006-10-09 07:16:24.020085' OR table1.`col_int_nokey` LIKE 'wait/synch/rwlock%') OR table1.`col_time_key` LIKE 'wait%') OR table1.`pk` LIKE 'wait%') AND table2.`col_int_key` <= table1.`col_varchar_key`) AND table2.`col_time_key` != 'y') OR table1.`col_time_key` LIKE '%myisam%') AND table2.`col_int_key` <= '2009-01-09 23:09:37.051335') OR table1.`col_varchar_key` < 9) AND table1.`col_date_key` LIKE 'wait%') AND table2.`col_time_key` LIKE 'wait/synch/cond%') HAVING (NOT (table2.`pk` != 8 IS NULL AND table1.`col_date_key` < '2008-11-10 15:06:40.031497') AND table1.`pk` <> 4) ORDER BY table1.`pk` LIMIT 251", length=799, parser_state=0x7f963af88650) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6513
|
# 2015-02-17T19:12:57 [21300] #20 0x0000000000678c01 in dispatch_command (command=COM_QUERY, thd=0x7f96262da070, packet=0x7f962637c071 " SELECT * FROM (test.`E` AS table1 RIGHT OUTER JOIN test.`CC` AS table2 ON ( table2.`col_date_key` = table1.`col_time_key` ) ) WHERE ( (NOT ( ( ( (NOT (NOT ( ( ( table1.`col_varchar_key` <= '2006-10-09 07:16:24.020085' OR table1.`col_int_nokey` LIKE 'wait/synch/rwlock%') OR table1.`col_time_key` LIKE 'wait%') OR table1.`pk` LIKE 'wait%') AND table2.`col_int_key` <= table1.`col_varchar_key`) AND table2.`col_time_key` != 'y') OR table1.`col_time_key` LIKE '%myisam%') AND table2.`col_int_key` <= '2009-01-09 23:09:37.051335') OR table1.`col_varchar_key` < 9) AND table1.`col_date_key` LIKE 'wait%') AND table2.`col_time_key` LIKE 'wait/synch/cond%') HAVING (NOT (table2.`pk` != 8 IS NULL AND table1.`col_date_key` < '2008-11-10 15:06:40.031497') AND table1.`pk` <> 4) ORDER BY table1.`pk` LIMIT 251", packet_length=800) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1300
|
# 2015-02-17T19:12:57 [21300] #21 0x0000000000677f97 in do_command (thd=0x7f96262da070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:996
|
# 2015-02-17T19:12:57 [21300] #22 0x00000000007953ef in do_handle_one_connection (thd_arg=0x7f96262da070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1375
|
# 2015-02-17T19:12:57 [21300] #23 0x0000000000795142 in handle_one_connection (arg=0x7f96262da070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1289
|
# 2015-02-17T19:12:57 [21300] #24 0x00007f963ac9cb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
# 2015-02-17T19:12:57 [21300] #25 0x00007f9638f5270d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
# 2015-02-17T19:12:57 [21300] #26 0x0000000000000000 in ?? ()
|
mysqld: /home/elenst/bzr/10.0/sql/sql_show.cc:4856: int get_all_tables(THD*, TABLE_LIST*, COND*): Assertion `table_name->length <= (64*3)' failed.
|
150217 18:15:21 [ERROR] mysqld got signal 6 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see http://kb.askmonty.org/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.0.17-MariaDB-debug-log
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=11
|
max_threads=153
|
thread_count=9
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467212 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x0x7f33d3c0a070
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f33ee20ce28 thread_stack 0x48000
|
Fatal signal 11 while backtracing
|
Attachments
Issue Links
- relates to
-
MDEV-7555 Server crashes in functions related to stored procedures
- Closed