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

[PS8QA] handle_fatal_signal (sig=11) in my_strnncollsp_simple | ctype-simple.cc:190

    XMLWordPrintable

    Details

      Description

      Testcase
       

      rm -Rf /dev/shm/1545137885
      mkdir -p /dev/shm/1545137885/tmp
      
      /qa/ps8/PS171218-percona-server-8.0.13-2-linux-x86_64-opt/bin/mysqld --no-defaults --initialize-insecure  --basedir=/qa/ps8/PS171218-percona-server-8.0.13-2-linux-x86_64-opt --datadir=/dev/shm/1545137885/data
      
      /qa/ps8/PS171218-percona-server-8.0.13-2-linux-x86_64-opt/bin/mysqld --no-defaults --basedir=/qa/ps8/PS171218-percona-server-8.0.13-2-linux-x86_64-opt --datadir=/dev/shm/1545137885/data --tmpdir=/dev/shm/1545137885/tmp --port=34683 --pid-file=/dev/shm/1545137885/pid.pid --core-file --socket=/dev/shm/1545137885/socket.sock --early-plugin-load=keyring_file.so --keyring_file_data=keyring --sql_mode= --encrypt_tmp_files=1 --log-error=/dev/shm/1545137885/error.log.out &
      
      SQL
      -----
      
      CREATE DATABASE test;
      USE test;
      set tmp_table_size=1024;
      ALTER DATABASE DEFAULT CHARACTER SET latin7;
      create TABLE t1(a text,b text);
      insert into t1 values(7553,'7553');
      insert into t1 values(662,'aaaaaaaaaaaaaaaaaaaa');
      insert INTO t1 values(1,10),(2,20);
      replace into t1 values(@id,"REPLACE,deleting the duplicate");
      INSERT INTO t1 VALUES(2,"ccccc");
      INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4);
      INSERT INTO t1 VALUES(_utf32 0x000000e4000000e500010000,-3);
      INSERT INTO t1 SET b=repeat('a',600);
      INSERT INTO t1 VALUES(1,"aaa"),(2,"bbb"),(3,"ccc");
      insert into t1 values("john","doe"),("John","Doe");
      INSERT INTO t1 VALUES(1,0),(1,1);
      insert into t1 values(4811,'4811');
      INSERT INTO t1 VALUES(3,'2001-01-01 10:11:02');
      insert INTO t1 values('a','a'),('b','b'),('c','c'),('aa','aa'),('bb','bb'),('cc','cc');
      insert into t1 values(8799,'8799');
      insert into t1 values(7436,'7436');
      SELECT GROUP_CONCAT(DISTINCT UCASE(b)) FROM t1;
      

      GDB info

      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
      #1  0x0000000001c89c27 in my_write_core (sig=sig@entry=11) at stacktrace.cc:278
      #2  0x0000000000fdeddd in handle_fatal_signal (sig=11) at signal_handler.cc:254
      #3  <signal handler called>
      #4  my_strnncollsp_simple (cs=<optimized out>, a=0x7e6410c3d950b088 <error: Cannot access memory at address 0x7e6410c3d950b088>, a_length=<optimized out>, b=0x7d98000000000000 <error: Cannot access memory at address 0x7d98000000000000>, b_length=0) at ctype-simple.cc:190
      #5  0x0000000000d1985f in group_concat_key_cmp_with_distinct (arg=0x7f8040133cf8, key1=0x7f804011aa04, key2=0x7f804011a810) at item_sum.cc:3824
      #6  0x0000000000fad6e4 in (anonymous namespace)::Merge_chunk_less::operator() (b=<optimized out>, a=<optimized out>, this=0x7f80996de5a0) at uniques.cc:687
      #7  Priority_queue<Merge_chunk*, std::vector<Merge_chunk*, Malloc_allocator<Merge_chunk*> >, (anonymous namespace)::Merge_chunk_less>::reverse_heapify (i=<optimized out>, this=0x7f80996de5a0) at ../include/priority_queue.h:151
      #8  Priority_queue<Merge_chunk*, std::vector<Merge_chunk*, Malloc_allocator<Merge_chunk*> >, (anonymous namespace)::Merge_chunk_less>::push (x=@0x7f80996de598: 0x7f80401360e0, this=0x7f80996de5a0) at ../include/priority_queue.h:228
      #9  merge_walk (file=0x7f8040136448, compare_arg=<optimized out>, compare=<optimized out>, walk_action_arg=0x7f8040133cf8, walk_action=0xd1b350 <dump_leaf_key(void*, unsigned int, void*)>, end=0x7f8040136118, begin=0x7f80401360a8, key_length=10, merge_buffer_size=1014, merge_buffer=0x7f804011a810 "") at uniques.cc:774
      #10 Unique::walk (this=0x7f8040136098, action=action@entry=0xd1b350 <dump_leaf_key(void*, unsigned int, void*)>, walk_action_arg=walk_action_arg@entry=0x7f8040133cf8) at uniques.cc:881
      #11 0x0000000000d1b8ab in Item_func_group_concat::val_str (this=0x7f8040133cf8) at item_sum.cc:4388
      #12 0x0000000000c5da3f in Item::send (this=0x7f8040133cf8, protocol=0x7f8040001e18, buffer=<optimized out>) at item.cc:6528
      #13 0x0000000000e4dd09 in THD::send_result_set_row (this=0x7f8040000b50, row_items=row_items@entry=0x7f8040135240) at sql_class.cc:2827
      #14 0x0000000001124397 in Query_result_send::send_data (this=0x7f8040134c98, items=...) at query_result.cc:94
      #15 0x0000000000e70f7a in end_send_group (join=0x7f8040134de0, qep_tab=<optimized out>, end_of_records=<optimized out>) at sql_executor.cc:3326
      #16 0x0000000000e74137 in sub_select (join=0x7f8040134de0, qep_tab=0x7f80401356d8, end_of_records=<optimized out>) at sql_executor.cc:1429
      #17 0x0000000000e7097b in do_select (join=0x7f8040134de0) at sql_executor.cc:1169
      #18 JOIN::exec (this=0x7f8040134de0) at sql_executor.cc:281
      #19 0x0000000000efa394 in Sql_cmd_dml::execute_inner (this=0x7f8040134c68, thd=0x7f8040000b50) at sql_select.cc:698
      #20 0x0000000000eff83f in Sql_cmd_dml::execute (this=0x7f8040134c68, thd=0x7f8040000b50) at sql_select.cc:596
      #21 0x0000000000eaa10a in mysql_execute_command (thd=thd@entry=0x7f8040000b50, first_level=first_level@entry=true) at sql_parse.cc:4518
      #22 0x0000000000eaf8dc in mysql_parse (thd=thd@entry=0x7f8040000b50, parser_state=parser_state@entry=0x7f80996dfd90, update_userstat=update_userstat@entry=false, force_primary_storage_engine=force_primary_storage_engine@entry=false) at sql_parse.cc:5259
      #23 0x0000000000eb2e7f in dispatch_command (thd=thd@entry=0x7f8040000b50, com_data=com_data@entry=0x7f80996e0cc0, command=COM_QUERY) at sql_parse.cc:1734
      #24 0x0000000000eb3af0 in do_command (thd=thd@entry=0x7f8040000b50) at sql_parse.cc:1290
      #25 0x0000000000fcda48 in handle_connection (arg=arg@entry=0x487a890) at conn_handler/connection_handler_per_thread.cc:317
      #26 0x0000000001d3587f in pfs_spawn_thread (arg=0x4b5c0a0) at pfs.cc:2836
      #27 0x00007f80ae9806ba in start_thread (arg=0x7f80996e1700) at pthread_create.c:333
      #28 0x00007f80accd841d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                laurynas.biveinis Laurynas Biveinis
                Reporter:
                ramesh.sivaraman Ramesh Sivaraman
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

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