Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-2457

Assertion `key_part_no < actual_key_parts' failed in bool KEY::has_records_per_key(uint) const

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Cannot Reproduce
    • 8.0.13-galera3-internal
    • None
    • None

    Description

      GDB info

      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
      #1  0x0000000004626c6e in my_write_core (sig=6) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/mysys/stacktrace.cc:278
      #2  0x0000000003480b89 in handle_fatal_signal (sig=6) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/signal_handler.cc:266
      #3  <signal handler called>
      #4  0x00007f4e9cc8e428 in __GI_raise ([email protected]=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      #5  0x00007f4e9cc9002a in __GI_abort () at abort.c:89
      #6  0x00007f4e9cc86bd7 in __assert_fail_base (fmt=<optimized out>, [email protected]=0x500a0b0 "key_part_no < actual_key_parts", [email protected]=0x500a060 "/mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/key.h", [email protected]=206, [email protected]=0x5010120 <KEY::has_records_per_key(unsigned int) const::__PRETTY_FUNCTION__> "bool KEY::has_records_per_key(uint) const") at assert.c:92
      #7  0x00007f4e9cc86c82 in __GI___assert_fail (assertion=0x500a0b0 "key_part_no < actual_key_parts", file=0x500a060 "/mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/key.h", line=206, function=0x5010120 <KEY::has_records_per_key(unsigned int) const::__PRETTY_FUNCTION__> "bool KEY::has_records_per_key(uint) const") at assert.c:101
      #8  0x0000000002efe4b0 in KEY::has_records_per_key (this=0x7f4e60e3bf30, key_part_no=1) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/key.h:206
      #9  0x00000000045538b6 in dd::info_schema::Table_statistics::read_stat_by_open_table (this=0x7f4e59028ec8, thd=0x7f4e59024000, schema_name_ptr=..., table_name_ptr=..., index_name_ptr=..., partition_name=0x0, column_name_ptr=..., column_ordinal_position=1, stype=dd::info_schema::enum_table_stats_type::INDEX_COLUMN_CARDINALITY) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/dd/info_schema/table_stats.cc:813
      #10 0x0000000004552331 in dd::info_schema::Table_statistics::read_stat (this=0x7f4e59028ec8, thd=0x7f4e59024000, schema_name_ptr=..., table_name_ptr=..., index_name_ptr=..., partition_name=0x0, column_name_ptr=..., index_ordinal_position=0, column_ordinal_position=1, engine_name_ptr=..., se_private_id=0, ts_se_private_data=0x0, tbl_se_private_data=0x0, [email protected]: 18446744073709551615, [email protected]: 0, stype=dd::info_schema::enum_table_stats_type::INDEX_COLUMN_CARDINALITY) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/dd/info_schema/table_stats.cc:470
      #11 0x0000000002fbfa21 in Item_func_internal_index_column_cardinality::val_int (this=0x7f4e593a9860) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_func.cc:8400
      #12 0x0000000002f228a9 in Item::send (this=0x7f4e593a9860, protocol=0x7f4e59025358, buffer=0x7f4e7857ace0) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item.cc:6557
      #13 0x0000000002f256f4 in Item_ref::send (this=0x7f4e3c3a71f8, prot=0x7f4e59025358, tmp=0x7f4e7857ace0) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item.cc:7448
      #14 0x0000000002f26780 in Item_view_ref::send (this=0x7f4e3c3a71f8, prot=0x7f4e59025358, tmp=0x7f4e7857ace0) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item.cc:7731
      #15 0x00000000031f5c32 in THD::send_result_set_row (this=0x7f4e59024000, row_items=0x7f4e3c3421d0) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_class.cc:3193
      #16 0x00000000036a1886 in Query_result_send::send_data (this=0x7f4e3c3a5b48, items=...) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/query_result.cc:107
      #17 0x000000000322e6b5 in end_send (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b82b8, end_of_records=false) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:3140
      #18 0x000000000322a326 in evaluate_join_record (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b8020) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1852
      #19 0x000000000322a899 in evaluate_null_complemented_join_record (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b8020) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1973
      #20 0x00000000032296f6 in sub_select (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b8020, end_of_records=false) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1552
      #21 0x000000000322a326 in evaluate_join_record (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b7d88) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1852
      #22 0x0000000003229699 in sub_select (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b7d88, end_of_records=false) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1546
      #23 0x000000000322a326 in evaluate_join_record (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b7af0) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1852
      #24 0x0000000003229699 in sub_select (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b7af0, end_of_records=false) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1546
      #25 0x000000000322a326 in evaluate_join_record (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b7858) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1852
      #26 0x0000000003229699 in sub_select (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b7858, end_of_records=false) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1546
      #27 0x000000000322a326 in evaluate_join_record (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b75c0) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1852
      #28 0x0000000003229699 in sub_select (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b75c0, end_of_records=false) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1546
      #29 0x00000000036e2ec3 in JOIN_CACHE::generate_full_extensions (this=0x7f4e3c3b8550, rec_ptr=0x7f4e3c4060c0 "\001") at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_join_buffer.cc:2005
      #30 0x00000000036e2bd2 in JOIN_CACHE_BNL::join_matching_records (this=0x7f4e3c3b8550, skip_last=false) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_join_buffer.cc:1902
      #31 0x00000000036e24b9 in JOIN_CACHE::join_records (this=0x7f4e3c3b8550, skip_last=false) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_join_buffer.cc:1728
      #32 0x00000000036e5ad7 in JOIN_CACHE::end_send (this=0x7f4e3c3b8550) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_join_buffer.h:495
      #33 0x0000000003228f87 in sub_select_op (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b7328, end_of_records=true) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1278
      #34 0x0000000003229119 in sub_select (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b7090, end_of_records=true) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1429
      #35 0x0000000003229119 in sub_select (join=0x7f4e3c3a8a40, qep_tab=0x7f4e3c3b6df8, end_of_records=true) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1429
      #36 0x0000000003228bbf in do_select (join=0x7f4e3c3a8a40) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1169
      #37 0x0000000003225ae4 in JOIN::exec (this=0x7f4e3c3a8a40) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:281
      #38 0x000000000330f240 in Sql_cmd_dml::execute_inner (this=0x7f4e3c343390, thd=0x7f4e59024000) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_select.cc:716
      #39 0x000000000330ec67 in Sql_cmd_dml::execute (this=0x7f4e3c343390, thd=0x7f4e59024000) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_select.cc:614
      #40 0x00000000032a7dda in mysql_execute_command (thd=0x7f4e59024000, first_level=true) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:5194
      #41 0x00000000032aaa5c in mysql_parse (thd=0x7f4e59024000, parser_state=0x7f4e7857f3c0, update_userstat=false, force_primary_storage_engine=false) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:6011
      #42 0x00000000032ae44d in wsrep_mysql_parse (thd=0x7f4e59024000, rawbuf=0x7f4e3c342028 "SELECT * FROM information_schema.statistics", length=43, parser_state=0x7f4e7857f3c0, update_userstat=false, force_primary_storage_engine=false) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:7186
      #43 0x000000000329cd44 in dispatch_command (thd=0x7f4e59024000, com_data=0x7f4e78580c90, command=COM_QUERY) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:2023
      #44 0x000000000329a627 in do_command (thd=0x7f4e59024000) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:1417
      #45 0x00000000034692ea in handle_connection (arg=0x7f4e76b3e490) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/conn_handler/connection_handler_per_thread.cc:317
      #46 0x000000000471d6c2 in pfs_spawn_thread (arg=0x7f4e76af6120) at /mnt/workspace/pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/perfschema/pfs.cc:2836
      #47 0x00007f4e9e9ac6ba in start_thread (arg=0x7f4e78582700) at pthread_create.c:333
      #48 0x00007f4e9cd6041d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ramesh.sivaraman Ramesh Sivaraman (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist