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

Crash during read_histogram_for_table with optimizer_use_condition_selectivity set to 4

Details

    Description

      set @@optimizer_use_condition_selectivity=4;
      set @@use_stat_tables= PREFERABLY;
      explain
      SELECT * FROM INFORMATION_SCHEMA.PROFILING, mysql.user;
      

      Attachments

        Issue Links

          Activity

            #0  0x00007f9b5b0a0121 in pthread_kill () from /lib64/libpthread.so.0
            #1  0x00007f9b5c6d16ae in my_write_core (sig=6) at /home/varun/varun/stable/mysys/stacktrace.c:481
            #2  0x00007f9b5bf19006 in handle_fatal_signal (sig=6) at /home/varun/varun/stable/sql/signal_handler.cc:305
            #3  <signal handler called>
            #4  0x00007f9b595974c9 in raise () from /lib64/libc.so.6
            #5  0x00007f9b59598958 in abort () from /lib64/libc.so.6
            #6  0x00007f9b5c6d63d6 in safe_mutex_lock (mp=0x7f9b3800d2a0, my_flags=0, file=0x7f9b5c7b5aa8 "/home/varun/varun/stable/sql/sql_statistics.cc", line=2398) at /home/varun/varun/stable/mysys/thr_mutex.c:246
            #7  0x00007f9b5bcd3426 in inline_mysql_mutex_lock (that=0x7f9b3800d2a0, src_file=0x7f9b5c7b5aa8 "/home/varun/varun/stable/sql/sql_statistics.cc", src_line=2398) at /home/varun/varun/stable/include/mysql/psi/mysql_thread.h:710
            #8  0x00007f9b5bcd48ab in alloc_histograms_for_table_share (thd=0x7f9b38000b00, table_share=0x7f9b3800d0f0, is_safe=false) at /home/varun/varun/stable/sql/sql_statistics.cc:2398
            #9  0x00007f9b5bcd62d9 in read_histograms_for_table (thd=0x7f9b38000b00, table=0x7f9b3800c558, stat_tables=0x7f9b540d3ba0) at /home/varun/varun/stable/sql/sql_statistics.cc:3204
            #10 0x00007f9b5bcd6733 in read_statistics_for_tables_if_needed (thd=0x7f9b38000b00, tables=0x7f9b38015570) at /home/varun/varun/stable/sql/sql_statistics.cc:3287
            #11 0x00007f9b5bb8abff in open_and_lock_tables (thd=0x7f9b38000b00, options=..., tables=0x7f9b38015570, derived=true, flags=0, prelocking_strategy=0x7f9b540d4f60) at /home/varun/varun/stable/sql/sql_base.cc:4963
            #12 0x00007f9b5bb4aca5 in open_and_lock_tables (thd=0x7f9b38000b00, tables=0x7f9b38015570, derived=true, flags=0) at /home/varun/varun/stable/sql/sql_base.h:500
            #13 0x00007f9b5bc23a2c in execute_sqlcom_select (thd=0x7f9b38000b00, all_tables=0x7f9b38015570) at /home/varun/varun/stable/sql/sql_parse.cc:6470
            #14 0x00007f9b5bc1a5a4 in mysql_execute_command (thd=0x7f9b38000b00) at /home/varun/varun/stable/sql/sql_parse.cc:3771
            #15 0x00007f9b5bc27cc9 in mysql_parse (thd=0x7f9b38000b00, rawbuf=0x7f9b38014e88 "explain\nSELECT * FROM INFORMATION_SCHEMA.PROFILING, mysql.user WHERE password_expired = PAGE_FAULTS_MINOR", length=105, parser_state=0x7f9b540d65f0, is_com_multi=false, is_next_command=false) at /home/varun/varun/stable/sql/sql_parse.cc:8078
            #16 0x00007f9b5bc1501d in dispatch_command (command=COM_QUERY, thd=0x7f9b38000b00, packet=0x7f9b38092c61 "explain\nSELECT * FROM INFORMATION_SCHEMA.PROFILING, mysql.user WHERE password_expired = PAGE_FAULTS_MINOR", packet_length=105, is_com_multi=false, is_next_command=false) at /home/varun/varun/stable/sql/sql_parse.cc:1850
            #17 0x00007f9b5bc13a43 in do_command (thd=0x7f9b38000b00) at /home/varun/varun/stable/sql/sql_parse.cc:1395
            #18 0x00007f9b5bd7d926 in do_handle_one_connection (connect=0x7f9b5e2267f0) at /home/varun/varun/stable/sql/sql_connect.cc:1402
            #19 0x00007f9b5bd7d6aa in handle_one_connection (arg=0x7f9b5e2267f0) at /home/varun/varun/stable/sql/sql_connect.cc:1308
            #20 0x00007f9b5c149fb8 in pfs_spawn_thread (arg=0x7f9b5e22d7d0) at /home/varun/varun/stable/storage/perfschema/pfs.cc:1862
            #21 0x00007f9b5b09b0db in start_thread () from /lib64/libpthread.so.0
            #22 0x00007f9b59648e3d in clone () from /lib64/libc.so.6
            

            varun Varun Gupta (Inactive) added a comment - #0 0x00007f9b5b0a0121 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00007f9b5c6d16ae in my_write_core (sig=6) at /home/varun/varun/stable/mysys/stacktrace.c:481 #2 0x00007f9b5bf19006 in handle_fatal_signal (sig=6) at /home/varun/varun/stable/sql/signal_handler.cc:305 #3 <signal handler called> #4 0x00007f9b595974c9 in raise () from /lib64/libc.so.6 #5 0x00007f9b59598958 in abort () from /lib64/libc.so.6 #6 0x00007f9b5c6d63d6 in safe_mutex_lock (mp=0x7f9b3800d2a0, my_flags=0, file=0x7f9b5c7b5aa8 "/home/varun/varun/stable/sql/sql_statistics.cc", line=2398) at /home/varun/varun/stable/mysys/thr_mutex.c:246 #7 0x00007f9b5bcd3426 in inline_mysql_mutex_lock (that=0x7f9b3800d2a0, src_file=0x7f9b5c7b5aa8 "/home/varun/varun/stable/sql/sql_statistics.cc", src_line=2398) at /home/varun/varun/stable/include/mysql/psi/mysql_thread.h:710 #8 0x00007f9b5bcd48ab in alloc_histograms_for_table_share (thd=0x7f9b38000b00, table_share=0x7f9b3800d0f0, is_safe=false) at /home/varun/varun/stable/sql/sql_statistics.cc:2398 #9 0x00007f9b5bcd62d9 in read_histograms_for_table (thd=0x7f9b38000b00, table=0x7f9b3800c558, stat_tables=0x7f9b540d3ba0) at /home/varun/varun/stable/sql/sql_statistics.cc:3204 #10 0x00007f9b5bcd6733 in read_statistics_for_tables_if_needed (thd=0x7f9b38000b00, tables=0x7f9b38015570) at /home/varun/varun/stable/sql/sql_statistics.cc:3287 #11 0x00007f9b5bb8abff in open_and_lock_tables (thd=0x7f9b38000b00, options=..., tables=0x7f9b38015570, derived=true, flags=0, prelocking_strategy=0x7f9b540d4f60) at /home/varun/varun/stable/sql/sql_base.cc:4963 #12 0x00007f9b5bb4aca5 in open_and_lock_tables (thd=0x7f9b38000b00, tables=0x7f9b38015570, derived=true, flags=0) at /home/varun/varun/stable/sql/sql_base.h:500 #13 0x00007f9b5bc23a2c in execute_sqlcom_select (thd=0x7f9b38000b00, all_tables=0x7f9b38015570) at /home/varun/varun/stable/sql/sql_parse.cc:6470 #14 0x00007f9b5bc1a5a4 in mysql_execute_command (thd=0x7f9b38000b00) at /home/varun/varun/stable/sql/sql_parse.cc:3771 #15 0x00007f9b5bc27cc9 in mysql_parse (thd=0x7f9b38000b00, rawbuf=0x7f9b38014e88 "explain\nSELECT * FROM INFORMATION_SCHEMA.PROFILING, mysql.user WHERE password_expired = PAGE_FAULTS_MINOR", length=105, parser_state=0x7f9b540d65f0, is_com_multi=false, is_next_command=false) at /home/varun/varun/stable/sql/sql_parse.cc:8078 #16 0x00007f9b5bc1501d in dispatch_command (command=COM_QUERY, thd=0x7f9b38000b00, packet=0x7f9b38092c61 "explain\nSELECT * FROM INFORMATION_SCHEMA.PROFILING, mysql.user WHERE password_expired = PAGE_FAULTS_MINOR", packet_length=105, is_com_multi=false, is_next_command=false) at /home/varun/varun/stable/sql/sql_parse.cc:1850 #17 0x00007f9b5bc13a43 in do_command (thd=0x7f9b38000b00) at /home/varun/varun/stable/sql/sql_parse.cc:1395 #18 0x00007f9b5bd7d926 in do_handle_one_connection (connect=0x7f9b5e2267f0) at /home/varun/varun/stable/sql/sql_connect.cc:1402 #19 0x00007f9b5bd7d6aa in handle_one_connection (arg=0x7f9b5e2267f0) at /home/varun/varun/stable/sql/sql_connect.cc:1308 #20 0x00007f9b5c149fb8 in pfs_spawn_thread (arg=0x7f9b5e22d7d0) at /home/varun/varun/stable/storage/perfschema/pfs.cc:1862 #21 0x00007f9b5b09b0db in start_thread () from /lib64/libpthread.so.0 #22 0x00007f9b59648e3d in clone () from /lib64/libc.so.6
            varun Varun Gupta (Inactive) added a comment - Patch http://lists.askmonty.org/pipermail/commits/2018-August/012816.html

            Ok to push.

            psergei Sergei Petrunia added a comment - Ok to push.

            People

              varun Varun Gupta (Inactive)
              varun Varun Gupta (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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