Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5163

[PS8QA] handle_fatal_signal (sig=11) in DsMrr_impl::dsmrr_init

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 8.0.12-2rc1, 5.6.42-84.2, 5.7.23-25
    • Fix Version/s: 8.0.13-3, 5.6.43-84.3, 5.7.25-28
    • Component/s: None
    • Labels:
      None

      Description

      # mysqld options required for replay: --plugin-load=TokuDB=ha_tokudb.so --sql_mode= 
      CREATE DATABASE test;
      USE test;
      create temporary TABLE t1(c1 int,c2 int,c3 char(1),c4 text(1),c5 blob(1),c6 CHAR (1),c7 varchar(1),c8 DATE,c9 decimal(6,3),primary key (c1),index (c3,c4(1),c5(1)),index (c2)) engine=TokuDB;
      INSERT INTO t1 VALUES(),(),();
      SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1=''OR c2='#C2' GROUP BY c1; 

      Leads to (on optimized);

      Core was generated by `/sda/PS151218-percona-server-8.0.13-2-linux-x86_64-opt/bin/mysqld --no-defaults'.
      Program terminated with signal SIGSEGV, Segmentation fault.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      [Current thread is 1 (Thread 0x7f7c3825e700 (LWP 1537))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x0000556bb1cbcb37 in my_write_core (sig=sig@entry=11) at stacktrace.cc:278
      #2  0x0000556bb0fe5805 in handle_fatal_signal (sig=11) at signal_handler.cc:254
      #3  <signal handler called>
      #4  DsMrr_impl::dsmrr_init (this=0x7f7bb587ad50, seq_funcs=0x7f7c3825b7d0, seq_init_param=0x7f7bb58fc140, n_ranges=1, mode=332, 
          buf=0x7f7c3825b7b0) at handler.cc:6629
      #5  0x0000556bb0dadf96 in QUICK_RANGE_SELECT::reset (this=0x7f7bb58fc140) at opt_range.cc:10694
      #6  0x0000556bb0daedbe in QUICK_RANGE_SELECT::init_ror_merged_scan (this=0x7f7bb58fc140, reuse_handler=<optimized out>)
          at opt_range.cc:2012
      #7  0x0000556bb0dcc378 in QUICK_ROR_UNION_SELECT::reset (this=0x7f7bb5895500) at opt_range.cc:2204
      #8  0x0000556bb0df8f9c in IndexRangeScanIterator::Init (this=0x7f7bb58da248) at records.cc:337
      #9  0x0000556bb0e856d6 in sub_select (join=0x7f7bb58d9300, qep_tab=0x7f7bb58da1f0, end_of_records=<optimized out>)
          at sql_executor.cc:1509
      #10 0x0000556bb0e81f8d in do_select (join=0x7f7bb58d9300) at sql_executor.cc:1168
      #11 JOIN::exec (this=0x7f7bb58d9300) at sql_executor.cc:281
      #12 0x0000556bb0f08764 in Sql_cmd_dml::execute_inner (this=0x7f7bb58d8c78, thd=0x7f7bb5817000) at sql_select.cc:698
      #13 0x0000556bb0f103c0 in Sql_cmd_dml::execute (this=0x7f7bb58d8c78, thd=0x7f7bb5817000) at sql_select.cc:596
      #14 0x0000556bb0ebcb03 in mysql_execute_command (thd=thd@entry=0x7f7bb5817000, first_level=first_level@entry=true)
          at sql_parse.cc:4518
      #15 0x0000556bb0ebfe3b in mysql_parse (thd=thd@entry=0x7f7bb5817000, parser_state=parser_state@entry=0x7f7c3825cd30, 
          update_userstat=update_userstat@entry=false, force_primary_storage_engine=force_primary_storage_engine@entry=false)
          at sql_parse.cc:5259
      #16 0x0000556bb0ec31f9 in dispatch_command (thd=thd@entry=0x7f7bb5817000, com_data=com_data@entry=0x7f7c3825dc60, command=COM_QUERY)
          at sql_parse.cc:1734
      #17 0x0000556bb0ec3d69 in do_command (thd=thd@entry=0x7f7bb5817000) at sql_parse.cc:1290
      #18 0x0000556bb0fd6ea0 in handle_connection (arg=arg@entry=0x7f7bece997f0) at conn_handler/connection_handler_per_thread.cc:317
      #19 0x0000556bb1d687bf in pfs_spawn_thread (arg=0x7f7c2dff8a20) at pfs.cc:2836
      #20 0x00007f7c3a0ae6db in start_thread (arg=0x7f7c3825e700) at pthread_create.c:463
      #21 0x00007f7c3838088f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      And on debug asserts with;

      mysqld: /git/PS-8.0-trunk_dbg/sql/handler.cc:6624: int DsMrr_impl::dsmrr_init(RANGE_SEQ_IF*, void*, uint, uint, HANDLER_BUFFER*): Assertion `table != __null' failed.
      

       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                george.lorch George Lorch
                Reporter:
                roel.vandepaar Roel Van de Paar (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 4 hours, 50 minutes
                  4h 50m