Details
Critical
Description
Several crashes reported on update table left join with a view
Gliffy Diagrams
Attachments
Issue Links
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Hide
Stoykov
added a comment -
Permalink
Show
Stoykov
added a comment -
150220 10:53:15 [ERROR] mysqld got signal 11 ;
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: 5.5.40-MariaDB-log
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=61
max_threads=202
thread_count=23
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 574210 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x0x7f57720f7000
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 = 0x7f58b616ce50 thread_stack 0x48000
mysys/stacktrace.c:247(my_print_stacktrace)[0xaee3ee]
sql/signal_handler.cc:153(handle_fatal_signal)[0x6dad2c]
/lib64/libpthread.so.0(+0xf7c0)[0x7f58b87e97c0]
sql/opt_subselect.cc:3290(fix_semijoin_strategies_for_picked_join_order(JOIN*))[0x67ffa2]
sql/sql_list.h:34(Sql_alloc::operator new(unsigned long))[0x5bfd4f]
sql/sql_select.cc:3817(make_join_statistics)[0x5c88ae]
sql/sql_select.cc:1229(JOIN::optimize())[0x5c9207]
sql/sql_derived.cc:789(mysql_derived_optimize(THD*, LEX*, TABLE_LIST*))[0x55e24d]
sql/sql_derived.cc:192(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x55db98]
sql/table.cc:6629(TABLE_LIST::handle_derived(LEX*, unsigned int))[0x6140ba]
sql/sql_lex.cc:3554(st_select_lex::handle_derived(LEX*, unsigned int))[0x570730]
sql/sql_select.cc:991(JOIN::optimize())[0x5c8be5]
sql/sql_select.cc:3080(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5d3927]
sql/sql_update.cc:1441(mysql_multi_update(THD*, TABLE_LIST*, List<Item>*, List<Item>*, Item*, unsigned long long, enum_duplicates, bool, st_select_lex_unit*, st_select_lex*, multi_update**))[0x60aa53]
sql/sql_parse.cc:2915(mysql_execute_command(THD*))[0x5850b7]
sql/sql_parse.cc:5799(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x586bf1]
sql/sql_parse.cc:1081(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x58831c]
sql/sql_parse.cc:793(do_command(THD*))[0x5888c2]
sql/sql_connect.cc:1266(do_handle_one_connection(THD*))[0x6432b3]
sql/sql_connect.cc:1183(handle_one_connection)[0x6433fc]
/lib64/libpthread.so.0(+0x77b6)[0x7f58b87e17b6]
/lib64/libc.so.6(clone+0x6d)[0x7f58b7971c5d]
Sent for additional testing
Regarding the patch:
it didn't apply smoothly due to line breaks in long lines in the test case. I removed them (locally) and then it worked.
Regarding the test case:
It creates InnoDB tables, but InnoDB is disabled for the test case. Please either enable it or switch tables to MyISAM, it just doesn't make sense to generate warnings about the missing engine.
Otherwise, I've run a bunch of tests, didn't get any regressions. Please push.
for merging: https://github.com/MariaDB/server/pull/40
It is good, but if engine is not important it is better do not mention it at all (my fault)
Daniel, thank you a lot, but I think more changes should be done so I've made changes from my tree and push after test run.