Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-38714

[Draft] Server crash in add_key_equal_fields, ASAN errors in Used_tables_and_const_cache::used_tables_and_const_cache_join

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 12.2
    • N/A
    • None
    • None

    Description

      Reproducible, needs cleaning.
      Non-deterministic, run with --repeat=N
      Fails within ~10 attempts on at least 10.6, 11.8 (also on previous minor releases), and main.

      JIRA returns a number of tickets for "Used_tables_and_const_cache::used_tables_and_const_cache_join", but at least judging by the summary, none obviously fits (no 2nd execution, no FK, no views, etc.)

      # Remaining options:
      		 
      # Basedir: /data/bld/11.8-asan
      		 
      # Search pattern(s): (?^s:Used_tables_and_const_cache::used_tables_and_const_cache_join)
      		 
       
      		 
      --disable_abort_on_error
      		 
      GRANT ALL ON *.* TO rqg@localhost;
      		 
      CREATE DATABASE IF NOT EXISTS app_periods;
      		 
      CREATE TABLE IF NOT EXISTS app_periods.t4 (s TIMESTAMP, e TIMESTAMP, PERIOD FOR p(s,e));
      		 
      --connect (con21_0,localhost,root,,)
      		 
      --connect (con23_0,localhost,root,,)
      		 
      --connect (con25_0,localhost,root,,)
      		 
      CREATE TABLE IF NOT EXISTS app_periods.t8 (id INT, f BLOB /*!100403 UNIQUE */, s DATE, e DATE, PERIOD FOR p(s,e));
      		 
      CREATE DATABASE IF NOT EXISTS multi_trigger_db;
      		 
      CREATE TABLE IF NOT EXISTS multi_trigger_db.tlog (pk INT NOT NULL AUTO_INCREMENT PRIMARY KEY, dt TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), tbl VARCHAR(16), tp ENUM('BEFORE','AFTER'), op ENUM('INSERT','UPDATE','DELETE'), fld BLOB);
      		 
      CREATE TRIGGER IF NOT EXISTS app_periods.v BEFORE UPDATE ON app_periods.t8 FOR EACH ROW INSERT INTO multi_trigger_db.tlog (tbl,tp,op,fld) VALUES ('t8','BEFORE','UPDATE',NEW.f);
      		 
      --connection con21_0
      		 
      USE app_periods;
      		 
      REPLACE INTO app_periods.t8 VALUES ();
      		 
      --connection con23_0
      		 
      --send
      		 
      BACKUP STAGE START;
      		 
      --connection con25_0
      		 
      --send
      		 
      CREATE TRIGGER IF NOT EXISTS multi_trigger_db.b AFTER INSERT ON multi_trigger_db.tlog FOR EACH ROW INSERT INTO multi_trigger_db.tlog2 VALUES (NEW.pk, NOW(), NEW.fld);
      		 
      --connection con21_0
      		 
      --send
      		 
      UPDATE t8 alias1 NATURAL JOIN t4 alias2 SET alias1.s = alias2.s WHERE e BETWEEN '1970-01-01' AND '1970-01-01';
      		 
      --connection con23_0
      		 
      --reap
      		 
      BACKUP STAGE BLOCK_COMMIT;

      11.8 8a0f327675e9b4a1e0ae2e3a97fe001122a9db03

      		 
      ==2763530==ERROR: AddressSanitizer: heap-use-after-free on address 0x62500029ea08 at pc 0x5610fb5bbe21 bp 0x7f6297760820 sp 0x7f6297760818
      		 
      READ of size 8 at 0x62500029ea08 thread T6
      		 
      2026-01-30 14:46:03 0 [Note] /share8t/bld/11.8-asan-ubsan/sql/mariadbd (initiated by: unknown): Normal shutdown
      		 
          #0 0x5610fb5bbe20 in Item_field::used_tables() const /data/bld/11.8-asan-ubsan/sql/item.cc:3658
      		 
          #1 0x5610f9a28302 in Used_tables_and_const_cache::used_tables_and_const_cache_join(Item const*) /data/bld/11.8-asan-ubsan/sql/item.h:5665
      		 
          #2 0x5610fb8312eb in Item_func::fix_fields(THD*, Item**) /data/bld/11.8-asan-ubsan/sql/item_func.cc:389
      		 
          #3 0x5610f9adaa33 in Item::fix_fields_if_needed(THD*, Item**) /data/bld/11.8-asan-ubsan/sql/item.h:1179
      		 
          #4 0x5610f9adab6c in Item::fix_fields_if_needed_for_scalar(THD*, Item**) /data/bld/11.8-asan-ubsan/sql/item.h:1188
      		 
          #5 0x5610fb6cef9f in Item::fix_fields_if_needed_for_bool(THD*, Item**) /data/bld/11.8-asan-ubsan/sql/item.h:1192
      		 
          #6 0x5610fb6cef9f in Item_cond::fix_fields(THD*, Item**) /data/bld/11.8-asan-ubsan/sql/item_cmpfunc.cc:5139
      		 
          #7 0x5610f9adaa33 in Item::fix_fields_if_needed(THD*, Item**) /data/bld/11.8-asan-ubsan/sql/item.h:1179
      		 
          #8 0x5610f9adab6c in Item::fix_fields_if_needed_for_scalar(THD*, Item**) /data/bld/11.8-asan-ubsan/sql/item.h:1188
      		 
          #9 0x5610f9cc5257 in Item::fix_fields_if_needed_for_bool(THD*, Item**) /data/bld/11.8-asan-ubsan/sql/item.h:1192
      		 
          #10 0x5610f9cc5257 in setup_on_expr(THD*, TABLE_LIST*, bool) /data/bld/11.8-asan-ubsan/sql/sql_base.cc:8932
      		 
          #11 0x5610f9cc6cc4 in setup_conds(THD*, TABLE_LIST*, List<TABLE_LIST>&, Item**) /data/bld/11.8-asan-ubsan/sql/sql_base.cc:9051
      		 
          #12 0x5610fa300a4c in setup_without_group /data/bld/11.8-asan-ubsan/sql/sql_select.cc:956
      		 
          #13 0x5610fa3051d5 in JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*) /data/bld/11.8-asan-ubsan/sql/sql_select.cc:1594
      		 
          #14 0x5610fa6d758c in Sql_cmd_update::prepare_inner(THD*) /data/bld/11.8-asan-ubsan/sql/sql_update.cc:3136
      		 
          #15 0x5610fa20b50e in Sql_cmd_dml::prepare(THD*) /data/bld/11.8-asan-ubsan/sql/sql_select.cc:34541
      		 
          #16 0x5610fa214f17 in Sql_cmd_dml::execute(THD*) /data/bld/11.8-asan-ubsan/sql/sql_select.cc:34595
      		 
          #17 0x5610fa080791 in mysql_execute_command(THD*, bool) /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:4440
      		 
          #18 0x5610fa09b050 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:7953
      		 
          #19 0x5610fa0a443f in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:1921
      		 
          #20 0x5610fa0b1415 in do_command(THD*, bool) /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:1431
      		 
          #21 0x5610fa8fd5f7 in do_handle_one_connection(CONNECT*, bool) /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1504
      		 
          #22 0x5610fa8fe760 in handle_one_connection /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1416
      		 
          #23 0x5610fc3cc8bf in pfs_spawn_thread /data/bld/11.8-asan-ubsan/storage/perfschema/pfs.cc:2198
      		 
          #24 0x7f62a46a81c3 in start_thread nptl/pthread_create.c:442
      		 
          #25 0x7f62a472885b in clone3 ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      		 
       
      		 
      0x62500029ea08 is located 2312 bytes inside of 8184-byte region [0x62500029e100,0x6250002a00f8)
      		 
      freed by thread T7 here:
      		 
          #0 0x7f62a5ab76a8 in __interceptor_free ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:52
      		 
          #1 0x5610fd6a5812 in my_free /data/bld/11.8-asan-ubsan/mysys/my_malloc.c:218
      		 
          #2 0x5610fd6782e7 in root_free /data/bld/11.8-asan-ubsan/mysys/my_alloc.c:77
      		 
          #3 0x5610fd67a3c3 in free_root /data/bld/11.8-asan-ubsan/mysys/my_alloc.c:517
      		 
          #4 0x5610fa72b918 in closefrm(TABLE*) /data/bld/11.8-asan-ubsan/sql/table.cc:4882
      		 
          #5 0x5610faf4038d in intern_close_table /data/bld/11.8-asan-ubsan/sql/table_cache.cc:230
      		 
          #6 0x5610faf41d8d in tc_purge() /data/bld/11.8-asan-ubsan/sql/table_cache.cc:324
      		 
          #7 0x5610f9cb1c7c in purge_tables() /data/bld/11.8-asan-ubsan/sql/sql_base.cc:335
      		 
          #8 0x5610f9cb1fc8 in flush_tables(THD*, flush_tables_type) /data/bld/11.8-asan-ubsan/sql/sql_base.cc:565
      		 
          #9 0x5610faf80ba5 in backup_block_ddl /data/bld/11.8-asan-ubsan/sql/backup.cc:295
      		 
          #10 0x5610faf831aa in run_backup_stage(THD*, backup_stages) /data/bld/11.8-asan-ubsan/sql/backup.cc:127
      		 
          #11 0x5610fa08a453 in mysql_execute_command(THD*, bool) /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:5022
      		 
          #12 0x5610fa09b050 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:7953
      		 
          #13 0x5610fa0a443f in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:1921
      		 
          #14 0x5610fa0b1415 in do_command(THD*, bool) /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:1431
      		 
          #15 0x5610fa8fd5f7 in do_handle_one_connection(CONNECT*, bool) /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1504
      		 
          #16 0x5610fa8fe760 in handle_one_connection /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1416
      		 
          #17 0x5610fc3cc8bf in pfs_spawn_thread /data/bld/11.8-asan-ubsan/storage/perfschema/pfs.cc:2198
      		 
          #18 0x7f62a46a81c3 in start_thread nptl/pthread_create.c:442
      		 
       
      		 
      previously allocated by thread T6 here:
      		 
          #0 0x7f62a5ab89cf in __interceptor_malloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:69
      		 
          #1 0x5610fd6a50b8 in my_malloc /data/bld/11.8-asan-ubsan/mysys/my_malloc.c:93
      		 
          #2 0x5610fd678173 in root_alloc /data/bld/11.8-asan-ubsan/mysys/my_alloc.c:66
      		 
          #3 0x5610fd678726 in init_alloc_root /data/bld/11.8-asan-ubsan/mysys/my_alloc.c:178
      		 
          #4 0x5610fa7b6cb5 in init_sql_alloc(unsigned int, st_mem_root*, unsigned int, unsigned int, unsigned long) /data/bld/11.8-asan-ubsan/sql/thr_malloc.cc:64
      		 
          #5 0x5610fa78a748 in open_table_from_share(THD*, TABLE_SHARE*, st_mysql_const_lex_string const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, List<String>*) /data/bld/11.8-asan-ubsan/sql/table.cc:4365
      		 
          #6 0x5610f9cf6826 in open_table(THD*, TABLE_LIST*, Open_table_context*) /data/bld/11.8-asan-ubsan/sql/sql_base.cc:2319
      		 
          #7 0x5610f9cfd299 in open_and_process_table /data/bld/11.8-asan-ubsan/sql/sql_base.cc:4271
      		 
          #8 0x5610f9d036e0 in open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) /data/bld/11.8-asan-ubsan/sql/sql_base.cc:4754
      		 
          #9 0x5610f9d09ebf in open_tables /data/bld/11.8-asan-ubsan/sql/sql_base.h:275
      		 
          #10 0x5610f9d09ebf in open_tables_for_query(THD*, TABLE_LIST*, unsigned int*, unsigned int, DML_prelocking_strategy*) /data/bld/11.8-asan-ubsan/sql/sql_base.cc:5935
      		 
          #11 0x5610fa20b461 in Sql_cmd_dml::prepare(THD*) /data/bld/11.8-asan-ubsan/sql/sql_select.cc:34532
      		 
          #12 0x5610fa214f17 in Sql_cmd_dml::execute(THD*) /data/bld/11.8-asan-ubsan/sql/sql_select.cc:34595
      		 
          #13 0x5610fa080791 in mysql_execute_command(THD*, bool) /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:4440
      		 
          #14 0x5610fa09b050 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:7953
      		 
          #15 0x5610fa0a443f in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:1921
      		 
          #16 0x5610fa0b1415 in do_command(THD*, bool) /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:1431
      		 
          #17 0x5610fa8fd5f7 in do_handle_one_connection(CONNECT*, bool) /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1504
      		 
          #18 0x5610fa8fe760 in handle_one_connection /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1416
      		 
          #19 0x5610fc3cc8bf in pfs_spawn_thread /data/bld/11.8-asan-ubsan/storage/perfschema/pfs.cc:2198
      		 
          #20 0x7f62a46a81c3 in start_thread nptl/pthread_create.c:442
      		 
       
      		 
      Thread T6 created by T0 here:
      		 
          #0 0x7f62a5a49726 in __interceptor_pthread_create ../../../../src/libsanitizer/asan/asan_interceptors.cpp:207
      		 
          #1 0x5610fc3c887b in my_thread_create /data/bld/11.8-asan-ubsan/storage/perfschema/my_thread.h:38
      		 
          #2 0x5610fc3ccd3c in pfs_spawn_thread_v1 /data/bld/11.8-asan-ubsan/storage/perfschema/pfs.cc:2249
      		 
          #3 0x5610f98e6aeb in inline_mysql_thread_create /data/bld/11.8-asan-ubsan/include/mysql/psi/mysql_thread.h:1139
      		 
          #4 0x5610f98e6aeb in create_thread_to_handle_connection(CONNECT*) /data/bld/11.8-asan-ubsan/sql/mysqld.cc:6272
      		 
          #5 0x5610f98f96f8 in create_new_thread(CONNECT*) /data/bld/11.8-asan-ubsan/sql/mysqld.cc:6334
      		 
          #6 0x5610f98f9920 in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /data/bld/11.8-asan-ubsan/sql/mysqld.cc:6396
      		 
          #7 0x5610f98fa561 in handle_connections_sockets() /data/bld/11.8-asan-ubsan/sql/mysqld.cc:6508
      		 
          #8 0x5610f98faa0d in run_main_loop /data/bld/11.8-asan-ubsan/sql/mysqld.cc:5750
      		 
          #9 0x5610f98fbfc1 in mysqld_main(int, char**) /data/bld/11.8-asan-ubsan/sql/mysqld.cc:6173
      		 
          #10 0x5610f98ccd01 in main /data/bld/11.8-asan-ubsan/sql/main.cc:34
      		 
          #11 0x7f62a4646249 in __libc_start_call_main ../sysdeps/nptl/libc_start_call_main.h:58
      		 
       
      		 
      Thread T7 created by T0 here:
      		 
          #0 0x7f62a5a49726 in __interceptor_pthread_create ../../../../src/libsanitizer/asan/asan_interceptors.cpp:207
      		 
          #1 0x5610fc3c887b in my_thread_create /data/bld/11.8-asan-ubsan/storage/perfschema/my_thread.h:38
      		 
          #2 0x5610fc3ccd3c in pfs_spawn_thread_v1 /data/bld/11.8-asan-ubsan/storage/perfschema/pfs.cc:2249
      		 
          #3 0x5610f98e6aeb in inline_mysql_thread_create /data/bld/11.8-asan-ubsan/include/mysql/psi/mysql_thread.h:1139
      		 
          #4 0x5610f98e6aeb in create_thread_to_handle_connection(CONNECT*) /data/bld/11.8-asan-ubsan/sql/mysqld.cc:6272
      		 
          #5 0x5610f98f96f8 in create_new_thread(CONNECT*) /data/bld/11.8-asan-ubsan/sql/mysqld.cc:6334
      		 
          #6 0x5610f98f9920 in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /data/bld/11.8-asan-ubsan/sql/mysqld.cc:6396
      		 
          #7 0x5610f98fa561 in handle_connections_sockets() /data/bld/11.8-asan-ubsan/sql/mysqld.cc:6508
      		 
          #8 0x5610f98faa0d in run_main_loop /data/bld/11.8-asan-ubsan/sql/mysqld.cc:5750
      		 
          #9 0x5610f98fbfc1 in mysqld_main(int, char**) /data/bld/11.8-asan-ubsan/sql/mysqld.cc:6173
      		 
          #10 0x5610f98ccd01 in main /data/bld/11.8-asan-ubsan/sql/main.cc:34
      		 
          #11 0x7f62a4646249 in __libc_start_call_main ../sysdeps/nptl/libc_start_call_main.h:58
      		 
       
      		 
      SUMMARY: AddressSanitizer: heap-use-after-free /data/bld/11.8-asan-ubsan/sql/item.cc:3658 in Item_field::used_tables() const
      		 
      Shadow bytes around the buggy address:
      		 
        0x0c4a8004bcf0: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
        0x0c4a8004bd00: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
        0x0c4a8004bd10: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
        0x0c4a8004bd20: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
        0x0c4a8004bd30: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
      =>0x0c4a8004bd40: fd[fd]fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
        0x0c4a8004bd50: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
        0x0c4a8004bd60: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
        0x0c4a8004bd70: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
        0x0c4a8004bd80: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
        0x0c4a8004bd90: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
      Shadow byte legend (one shadow byte represents 8 application bytes):
      		 
        Addressable:           00
      		 
        Partially addressable: 01 02 03 04 05 06 07 
        Heap left redzone:       fa
      		 
        Freed heap region:       fd
      		 
        Stack left redzone:      f1
      		 
        Stack mid redzone:       f2
      		 
        Stack right redzone:     f3
      		 
        Stack after return:      f5
      		 
        Stack use after scope:   f8
      		 
        Global redzone:          f9
      		 
        Global init order:       f6
      		 
        Poisoned by user:        f7
      		 
        Container overflow:      fc
      		 
        Array cookie:            ac
      		 
        Intra object redzone:    bb
      		 
        ASan internal:           fe
      		 
        Left alloca redzone:     ca
      		 
        Right alloca redzone:    cb
      		 
      ==2763530==ABORTING
      		 
      260130 14:46:05 [ERROR] /share8t/bld/11.8-asan-ubsan/sql/mariadbd got signal 6 ;
      		 
      Sorry, we probably made a mistake, and this is a bug.
      		 
       
      		 
      Your assistance in bug reporting will enable us to fix this for the next release.
      		 
      To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
      		 
      a bug on https://jira.mariadb.org/.
      		 
       
      		 
      Please include the information from the server start above, to the end of the
      		 
      information below.
      		 
       
      		 
      Server version: 11.8.6-MariaDB-asan-debug-log source revision: 8a0f327675e9b4a1e0ae2e3a97fe001122a9db03
      		 
       
      		 
      The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
      		 
      contains instructions to obtain a better version of the backtrace below.
      		 
      Following these instructions will help MariaDB developers provide a fix quicker.
      		 
       
      		 
      Attempting backtrace. Include this in the bug report.
      		 
      (note: Retrieving this information may fail)
      		 
       
      		 
      Thread pointer: 0x62c0000e0218
      		 
      stack_bottom = 0x7f6297765000 thread_stack 0xb00000
      		 
      sanitizer_common/sanitizer_common_interceptors.inc:4277(__interceptor_backtrace.part.0)[0x7f62a5a51f31]
      		 
      mysys/stacktrace.c:215(my_print_stacktrace)[0x5610fd6b7a88]
      		 
      sql/signal_handler.cc:227(handle_fatal_signal)[0x5610fb44571b]
      		 
      libc_sigaction.c:0(__restore_rt)[0x7f62a465b050]
      		 
      nptl/pthread_kill.c:44(__pthread_kill_implementation)[0x7f62a46a9ebc]
      		 
      posix/raise.c:27(__GI_raise)[0x7f62a465afb2]
      		 
      stdlib/abort.c:81(__GI_abort)[0x7f62a4645472]
      		 
      sanitizer_common/sanitizer_posix_libcdep.cpp:137(__sanitizer::Abort())[0x7f62a5ad650f]
      		 
      sanitizer_common/sanitizer_termination.cpp:59(__sanitizer::Die())[0x7f62a5ae2ba1]
      		 
      asan/asan_report.cpp:190(__asan::ScopedInErrorReport::~ScopedInErrorReport())[0x7f62a5ac1f5e]
      		 
      asan/asan_report.cpp:479(__asan::ReportGenericError(unsigned long, unsigned long, unsigned long, unsigned long, bool, unsigned long, unsigned int, bool))[0x7f62a5ac14c6]
      		 
      asan/asan_rtl.cpp:123(__asan_report_load8)[0x7f62a5ac25ac]
      		 
      sql/item.cc:3658(Item_field::used_tables() const)[0x5610fb5bbe21]
      		 
      sql/opt_range.cc:5665(Used_tables_and_const_cache::used_tables_and_const_cache_join(Item const*))[0x5610f9a28303]
      		 
      sql/item_func.cc:390(Item_func::fix_fields(THD*, Item**))[0x5610fb8312ec]
      		 
      sql/set_var.cc:1180(Item::fix_fields_if_needed(THD*, Item**))[0x5610f9adaa34]
      		 
      sql/set_var.cc:1188(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x5610f9adab6d]
      		 
      sql/item_cmpfunc.cc:5139(Item_cond::fix_fields(THD*, Item**))[0x5610fb6cefa0]
      		 
      sql/set_var.cc:1180(Item::fix_fields_if_needed(THD*, Item**))[0x5610f9adaa34]
      		 
      sql/set_var.cc:1188(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x5610f9adab6d]
      		 
      sql/sql_base.cc:8932(setup_on_expr(THD*, TABLE_LIST*, bool))[0x5610f9cc5258]
      		 
      sql/sql_base.cc:9051(setup_conds(THD*, TABLE_LIST*, List<TABLE_LIST>&, Item**))[0x5610f9cc6cc5]
      		 
      sql/sql_select.cc:956(setup_without_group(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, List<TABLE_LIST>&, List<Item>&, List<Item>&, Item**, st_order*, st_order*, List<Window_spec>&, List<Item_window_func>&, bool*))[0x5610fa300a4d]
      		 
      sql/sql_select.cc:1594(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x5610fa3051d6]
      		 
      sql/sql_update.cc:3136(Sql_cmd_update::prepare_inner(THD*))[0x5610fa6d758d]
      		 
      sql/sql_select.cc:34541(Sql_cmd_dml::prepare(THD*))[0x5610fa20b50f]
      		 
      sql/sql_select.cc:34595(Sql_cmd_dml::execute(THD*))[0x5610fa214f18]
      		 
      sql/sql_parse.cc:4440(mysql_execute_command(THD*, bool))[0x5610fa080792]
      		 
      sql/sql_parse.cc:7953(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5610fa09b051]
      		 
      sql/sql_parse.cc:1921(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5610fa0a4440]
      		 
      sql/sql_parse.cc:1431(do_command(THD*, bool))[0x5610fa0b1416]
      		 
      sql/sql_connect.cc:1504(do_handle_one_connection(CONNECT*, bool))[0x5610fa8fd5f8]
      		 
      sql/sql_connect.cc:1416(handle_one_connection)[0x5610fa8fe761]
      		 
      perfschema/pfs.cc:2201(pfs_spawn_thread)[0x5610fc3cc8c0]
      		 
      nptl/pthread_create.c:442(start_thread)[0x7f62a46a81c4]
      		 
      x86_64/clone3.S:83(clone3)[0x7f62a472885c]
      		 
       
      		 
      Connection ID (thread ID): 5
      		 
      Status: KILL_SERVER
      		 
      Query (0x62d000316438): UPDATE t8 alias1 NATURAL JOIN t4 alias2 SET alias1.s = alias2.s WHERE e BETWEEN '1970-01-01' AND '1970-01-01'


      #2  <signal handler called>
      		 
      #3  0x00005556cf8b3fee in Bitmap<64u>::merge (map2=..., this=<optimized out>) at /data/bld/11.8-rel/sql/sql_bitmap.h:211
      		 
      #4  add_key_field (join=join@entry=0x7f8c2c016c18, key_fields=key_fields@entry=0x7f8c485e8798, and_level=and_level@entry=0, cond=cond@entry=0x7f8c2c0156a0, field=field@entry=0x7f8c2c053cf8, eq_func=eq_func@entry=true, value=<optimized out>, usable_tables=<optimized out>, sargables=<optimized out>, row_col_no=0, num_values=1) at /data/bld/11.8-rel/sql/sql_select.cc:6776
      		 
      #5  0x00005556cf8b41d5 in add_key_equal_fields (join=join@entry=0x7f8c2c016c18, key_fields=key_fields@entry=0x7f8c485e8798, and_level=0, cond=cond@entry=0x7f8c2c0156a0, field_item=0x7f8c2c015018, eq_func=eq_func@entry=true, val=<optimized out>, usable_tables=<optimized out>, sargables=<optimized out>, row_col_no=0, num_values=1) at /data/bld/11.8-rel/sql/sql_select.cc:6897
      		 
      #6  0x00005556cf8bcfef in Item_bool_func2::add_key_fields_optimize_op (this=0x7f8c2c0156a0, join=<optimized out>, key_fields=<optimized out>, and_level=0x7f8c485e8794, usable_tables=18446744073709551615, sargables=0x7f8c485e8918, equal_func=<optimized out>) at /data/bld/11.8-rel/sql/sql_select.cc:7191
      		 
      #7  0x00005556cfb54e9f in Item_func_eq::add_key_fields (this=<optimized out>, join=<optimized out>, key_fields=<optimized out>, and_level=<optimized out>, usable_tables=<optimized out>, sargables=<optimized out>) at /data/bld/11.8-rel/sql/item_cmpfunc.h:837
      		 
      #8  0x00005556cf8bc353 in Item_cond_and::add_key_fields (this=<optimized out>, join=0x7f8c2c016c18, key_fields=0x7f8c485e8798, and_level=0x7f8c485e8794, usable_tables=18446744073709551615, sargables=0x7f8c485e8918) at /data/bld/11.8-rel/sql/sql_select.cc:6972
      		 
      #9  0x00005556cf8bd719 in update_ref_and_keys (thd=thd@entry=0x7f8c2c000c68, keyuse=keyuse@entry=0x7f8c2c016f70, join_tab=join_tab@entry=0x7f8c2c0181a0, tables=<optimized out>, cond=<optimized out>, normal_tables=normal_tables@entry=18446744073709551615, select_lex=<optimized out>, sargables=<optimized out>) at /data/bld/11.8-rel/sql/sql_select.cc:7712
      		 
      #10 0x00005556cf8f4862 in make_join_statistics (join=join@entry=0x7f8c2c016c18, tables_list=..., keyuse_array=keyuse_array@entry=0x7f8c2c016f70) at /data/bld/11.8-rel/sql/sql_select.cc:5883
      		 
      #11 0x00005556cf8fb368 in JOIN::optimize_inner (this=this@entry=0x7f8c2c016c18) at /data/bld/11.8-rel/sql/sql_select.cc:2750
      		 
      #12 0x00005556cf8fba03 in JOIN::optimize (this=this@entry=0x7f8c2c016c18) at /data/bld/11.8-rel/sql/sql_select.cc:2007
      		 
      #13 0x00005556cf8fd91c in Sql_cmd_dml::execute_inner (this=this@entry=0x7f8c2c014a38, thd=thd@entry=0x7f8c2c000c68) at /data/bld/11.8-rel/sql/sql_select.cc:34684
      		 
      #14 0x00005556cf9694d5 in Sql_cmd_update::execute_inner (this=0x7f8c2c014a38, thd=0x7f8c2c000c68) at /data/bld/11.8-rel/sql/sql_update.cc:3211
      		 
      #15 0x00005556cf8b44bd in Sql_cmd_dml::execute (this=0x7f8c2c014a38, thd=0x7f8c2c000c68) at /data/bld/11.8-rel/sql/sql_select.cc:34627
      		 
      #16 0x00005556cf8790c6 in mysql_execute_command (thd=thd@entry=0x7f8c2c000c68, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/11.8-rel/sql/sql_parse.cc:4440
      		 
      #17 0x00005556cf87d7d6 in mysql_parse (thd=0x7f8c2c000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/bld/11.8-rel/sql/sql_parse.cc:7953
      		 
      #18 0x00005556cf880205 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f8c2c000c68, packet=packet@entry=0x7f8c2c008869 "UPDATE t8 alias1 NATURAL JOIN t4 alias2 SET alias1.s = alias2.s WHERE e BETWEEN '1970-01-01' AND '1970-01-01'", packet_length=packet_length@entry=109, blocking=blocking@entry=true) at /data/bld/11.8-rel/sql/sql_parse.cc:2020
      		 
      #19 0x00005556cf88199f in do_command (thd=thd@entry=0x7f8c2c000c68, blocking=blocking@entry=true) at /data/bld/11.8-rel/sql/sql_parse.cc:1431
      		 
      #20 0x00005556cf9b25e5 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55571195d2c8, put_in_cache=put_in_cache@entry=true) at /data/bld/11.8-rel/sql/sql_connect.cc:1504
      		 
      #21 0x00005556cf9b293d in handle_one_connection (arg=arg@entry=0x55571195d2c8) at /data/bld/11.8-rel/sql/sql_connect.cc:1416
      		 
      #22 0x00005556cfd6ecac in pfs_spawn_thread (arg=0x555711950688) at /data/bld/11.8-rel/storage/perfschema/pfs.cc:2198
      		 
      #23 0x00007f8c4efc91c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      		 
      #24 0x00007f8c4f04985c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

      Attachments

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.