Description:
When running the new test "selects" in the tree "mysql-6.0-perfschema" the engine crashed in ha_perfschema. See the following backtrace:
warning: Can't read pathname for load map: Input/output error.
Core was generated by `/work/bzr/mysql-6.0-perfschema/sql/mysqld --defaults-group-suffix=.1 --defaults'.
Program terminated with signal 6, Aborted.
#0 0xffffe410 in __kernel_vsyscall ()
#0 0xffffe410 in __kernel_vsyscall ()
#1 0xb7f0f397 in pthread_kill () from /lib/libpthread.so.0
#2 0x08996cee in my_write_core (sig=6) at stacktrace.c:309
#3 0x08372ac2 in handle_segfault (sig=6) at mysqld.cc:2734
#4 <signal handler called>
#5 0xffffe410 in __kernel_vsyscall ()
#6 0xb7c928f5 in raise () from /lib/libc.so.6
#7 0xb7c941e1 in abort () from /lib/libc.so.6
#8 0xb7c8bc1e in __assert_fail () from /lib/libc.so.6
#9 0x08a36115 in ha_perfschema::rnd_init (this=0x9b62250, scan=true) at ha_perfschema.cc:250
#10 0x08291935 in handler::ha_rnd_init (this=0x9b62250, scan=true) at handler.h:1582
#11 0x084b6c59 in init_read_record (info=0x9b71f14, thd=0x9984838, table=0x9b61b68,
select=0x9b72428, use_record_cache=1, print_error=true, disable_rr_cache=false)
at records.cc:258
#12 0x083fa6ee in join_init_read_record (tab=0x9b71ed0) at sql_select.cc:17085
#13 0x083fddff in sub_select (join=0x9b62c48, join_tab=0x9b71ed0, end_of_records=false)
at sql_select.cc:16280
#14 0x083fdbb1 in evaluate_join_record (join=0x9b62c48, join_tab=0x9b71d20, error=0)
at sql_select.cc:16548
#15 0x083fdfa6 in sub_select (join=0x9b62c48, join_tab=0x9b71d20, end_of_records=false)
at sql_select.cc:16315
#16 0x0840a975 in do_select (join=0x9b62c48, fields=0x9985c3c, table=0x0, procedure=0x0)
at sql_select.cc:15844
#17 0x084229a1 in JOIN::exec (this=0x9b62c48) at sql_select.cc:2886
#18 0x0841d5fd in mysql_select (thd=0x9984838, rref_pointer_array=0x9985cac, tables=0x9a70710,
wild_num=0, fields=@0x9985c3c, conds=0x9b523d0, og_num=0, order=0x0, group=0x0, having=0x0,
proc_param=0x0, select_options=2147764736, result=0x9b524f8, unit=0x99858fc,
select_lex=0x9985ba8) at sql_select.cc:3067
#19 0x08422cb2 in handle_select (thd=0x9984838, lex=0x99858a0, result=0x9b524f8,
setup_tables_done_option=0) at sql_select.cc:310
#20 0x08384a36 in execute_sqlcom_select (thd=0x9984838, all_tables=0x9a70710) at sql_parse.cc:4994
#21 0x083864e1 in mysql_execute_command (thd=0x9984838) at sql_parse.cc:2186
#22 0x0838f0d3 in mysql_parse (thd=0x9984838,
inBuf=0x9a701a8 "SELECT EVENT_ID FROM performance_schema.EVENTS_WAITS_CURRENT\nWHERE THREAD_ID IN\n(SELECT THREAD_ID FROM performance_schema.PROCESSLIST)\nAND EVENT_NAME IN\n(SELECT NAME FROM performance_schema.SETUP_INST"..., length=247, found_semicolon=0xaadf7e30) at sql_parse.cc:6097
#23 0x0838fad4 in dispatch_command (command=COM_QUERY, thd=0x9984838, packet=0x9a8b499 "",
packet_length=247) at sql_parse.cc:1076
#24 0x08390db0 in do_command (thd=0x9984838) at sql_parse.cc:758
#25 0x0837c502 in do_handle_one_connection (thd_arg=0x9984838) at sql_connect.cc:1156
#26 0x0837c5c1 in handle_one_connection (arg=0x9984838) at sql_connect.cc:1108
#27 0x08a47790 in pfs_spawn_thread (arg=0x9af2200) at pfs.cc:1012
#28 0xb7f0a192 in start_thread () from /lib/libpthread.so.0
#29 0xb7d2c02e in clone () from /lib/libc.so.6
Could be the same as
Bug #45496 (Patch pending): Performance schema: assertion fails in ha_perfschema::rnd_init:223
How to repeat:
run selects.test in "mysql-6.0-perfschema". Take the test from
http://lists.mysql.com/commits/79255
as long as it is not pushed.
Description: When running the new test "selects" in the tree "mysql-6.0-perfschema" the engine crashed in ha_perfschema. See the following backtrace: warning: Can't read pathname for load map: Input/output error. Core was generated by `/work/bzr/mysql-6.0-perfschema/sql/mysqld --defaults-group-suffix=.1 --defaults'. Program terminated with signal 6, Aborted. #0 0xffffe410 in __kernel_vsyscall () #0 0xffffe410 in __kernel_vsyscall () #1 0xb7f0f397 in pthread_kill () from /lib/libpthread.so.0 #2 0x08996cee in my_write_core (sig=6) at stacktrace.c:309 #3 0x08372ac2 in handle_segfault (sig=6) at mysqld.cc:2734 #4 <signal handler called> #5 0xffffe410 in __kernel_vsyscall () #6 0xb7c928f5 in raise () from /lib/libc.so.6 #7 0xb7c941e1 in abort () from /lib/libc.so.6 #8 0xb7c8bc1e in __assert_fail () from /lib/libc.so.6 #9 0x08a36115 in ha_perfschema::rnd_init (this=0x9b62250, scan=true) at ha_perfschema.cc:250 #10 0x08291935 in handler::ha_rnd_init (this=0x9b62250, scan=true) at handler.h:1582 #11 0x084b6c59 in init_read_record (info=0x9b71f14, thd=0x9984838, table=0x9b61b68, select=0x9b72428, use_record_cache=1, print_error=true, disable_rr_cache=false) at records.cc:258 #12 0x083fa6ee in join_init_read_record (tab=0x9b71ed0) at sql_select.cc:17085 #13 0x083fddff in sub_select (join=0x9b62c48, join_tab=0x9b71ed0, end_of_records=false) at sql_select.cc:16280 #14 0x083fdbb1 in evaluate_join_record (join=0x9b62c48, join_tab=0x9b71d20, error=0) at sql_select.cc:16548 #15 0x083fdfa6 in sub_select (join=0x9b62c48, join_tab=0x9b71d20, end_of_records=false) at sql_select.cc:16315 #16 0x0840a975 in do_select (join=0x9b62c48, fields=0x9985c3c, table=0x0, procedure=0x0) at sql_select.cc:15844 #17 0x084229a1 in JOIN::exec (this=0x9b62c48) at sql_select.cc:2886 #18 0x0841d5fd in mysql_select (thd=0x9984838, rref_pointer_array=0x9985cac, tables=0x9a70710, wild_num=0, fields=@0x9985c3c, conds=0x9b523d0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x9b524f8, unit=0x99858fc, select_lex=0x9985ba8) at sql_select.cc:3067 #19 0x08422cb2 in handle_select (thd=0x9984838, lex=0x99858a0, result=0x9b524f8, setup_tables_done_option=0) at sql_select.cc:310 #20 0x08384a36 in execute_sqlcom_select (thd=0x9984838, all_tables=0x9a70710) at sql_parse.cc:4994 #21 0x083864e1 in mysql_execute_command (thd=0x9984838) at sql_parse.cc:2186 #22 0x0838f0d3 in mysql_parse (thd=0x9984838, inBuf=0x9a701a8 "SELECT EVENT_ID FROM performance_schema.EVENTS_WAITS_CURRENT\nWHERE THREAD_ID IN\n(SELECT THREAD_ID FROM performance_schema.PROCESSLIST)\nAND EVENT_NAME IN\n(SELECT NAME FROM performance_schema.SETUP_INST"..., length=247, found_semicolon=0xaadf7e30) at sql_parse.cc:6097 #23 0x0838fad4 in dispatch_command (command=COM_QUERY, thd=0x9984838, packet=0x9a8b499 "", packet_length=247) at sql_parse.cc:1076 #24 0x08390db0 in do_command (thd=0x9984838) at sql_parse.cc:758 #25 0x0837c502 in do_handle_one_connection (thd_arg=0x9984838) at sql_connect.cc:1156 #26 0x0837c5c1 in handle_one_connection (arg=0x9984838) at sql_connect.cc:1108 #27 0x08a47790 in pfs_spawn_thread (arg=0x9af2200) at pfs.cc:1012 #28 0xb7f0a192 in start_thread () from /lib/libpthread.so.0 #29 0xb7d2c02e in clone () from /lib/libc.so.6 Could be the same as Bug #45496 (Patch pending): Performance schema: assertion fails in ha_perfschema::rnd_init:223 How to repeat: run selects.test in "mysql-6.0-perfschema". Take the test from http://lists.mysql.com/commits/79255 as long as it is not pushed.