Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.2.14
-
Centos 7
Description
Crash in 10.2.14 when using an EXCEPT CLAUSE:
reproduced with employees sample database.
Load database.
CREATE TABLE salaries_tmp SELECT * FROM salaries LIMIT 1000000; |
SELECT * FROM salaries EXCEPT (SELECT * FROM salaries_tmp); |
Crash:
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: 200305 11:20:50 [ERROR] mysqld got signal 11 ;
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: This could be because you hit a bug. It is also possible that this binary
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: or one of the libraries it was linked against is corrupt, improperly built,
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: or misconfigured. This error can also be caused by malfunctioning hardware.
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: We will try our best to scrape up some info that will hopefully help
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: diagnose the problem, but since we have already crashed,
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: something is definitely wrong and this may fail.
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Server version: 10.2.14-MariaDB
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: key_buffer_size=134217728
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: read_buffer_size=131072
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: max_used_connections=1
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: max_threads=153
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: thread_count=7
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: It is possible that mysqld could use up to
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467310 K
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Hope that's ok; if not, decrease some variables in the equation.
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Thread pointer: 0x564add3daf08
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Attempting backtrace. You can use the following information to find out
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: where mysqld died. If you see no messages after this, something went
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: terribly wrong...
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: stack_bottom = 0x7f63a7123d30 thread_stack 0x49000
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: mysys/stacktrace.c:268(my_print_stacktrace)[0x564adabd958e]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/signal_handler.cc:168(handle_fatal_signal)[0x564ada66dcc5]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sigaction.c:0(__restore_rt)[0x7f63b42845f0]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: maria/ma_unique.c:114(_ma_unique_hash)[0x564adaacf920]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: maria/ha_maria.cc:3960(ha_maria::find_unique_row(unsigned char*, unsigned int))[
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_union.cc:187(select_unit::send_data(List<Item>&))[0x564ada540c33]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_select.cc:20234(end_send(JOIN*, st_join_table*, bool))[0x564ada4f3a4f]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_class.h:3663(THD::get_stmt_da())[0x564ada4db1c3]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_select.cc:19074(sub_select(JOIN*, st_join_table*, bool))[0x564ada4e3bbe]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_select.cc:18611(do_select)[0x564ada5035af]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_select.cc:3425(JOIN::exec())[0x564ada5037c3]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_union.cc:1437(st_select_lex_unit::exec())[0x564ada5425eb]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_union.cc:41(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*,
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_class.h:3653(handle_select(THD*, LEX*, select_result*, unsigned long))[0
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_parse.cc:6515(execute_sqlcom_select(THD*, TABLE_LIST*))[0x564ada3ca5c1]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_parse.cc:3739(mysql_execute_command(THD*))[0x564ada4b16a0]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_parse.cc:7982(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_parse.cc:1838(dispatch_command(enum_server_command, THD*, char*, unsigne
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_parse.cc:1388(do_command(THD*))[0x564ada4b8e29]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x564ada57fcca]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_connect.cc:1243(handle_one_connection)[0x564ada57fded]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: pthread_create.c:0(start_thread)[0x7f63b427ce65]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: /lib64/libc.so.6(clone+0x6d)[0x7f63b261d88d]
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Trying to get some variables.
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Some pointers may be invalid and cause the dump to abort.
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Query (0x564add3e8690): select * from salaries except (select * from salaries_tm
|
Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Connection ID (thread ID): 10
|
Attachments
Issue Links
- duplicates
-
MDEV-13749 Server crashes in _ma_unique_hash / JOIN_CACHE::generate_full_extensions on INTERSECT
- Closed