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

Assertion 'm_idx >= 0' failed in plan_idx QEP_share d::idx() const.

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • 8.0.x, Not 5.7.x
    • 8.0.19-10
    • None

    Description

      GDB info

      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
      #1  0x000000000475d0a3 in my_write_core (sig=6) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/mysys/stacktrace.cc:278
      #2  0x000000000359acc4 in handle_fatal_signal (sig=6) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/signal_handler.cc:264
      #3  <signal handler called>
      #4  0x00007fcfb5372428 in __GI_raise ([email protected]=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      #5  0x00007fcfb537402a in __GI_abort () at abort.c:89
      #6  0x00007fcfb536abd7 in __assert_fail_base (fmt=<optimized out>, [email protected]=0x5249065 "m_idx >= 0", [email protected]=0x5249008 "/mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_opt_exec_shared.h", [email protected]=255, [email protected]=0x524c880 <QEP_shared::idx() const::__PRETTY_FUNCTION__> "plan_idx QEP_shared::idx() const") at assert.c:92
      #7  0x00007fcfb536ac82 in __GI___assert_fail (assertion=0x5249065 "m_idx >= 0", file=0x5249008 "/mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_opt_exec_shared.h", line=255, function=0x524c880 <QEP_shared::idx() const::__PRETTY_FUNCTION__> "plan_idx QEP_shared::idx() const") at assert.c:101
      #8  0x000000000305f4c9 in QEP_shared::idx (this=0x7fcf67a9f2f8) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_opt_exec_shared.h:255
      #9  0x000000000305f525 in QEP_shared_owner::idx (this=0x7fcf67a9f3d0) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_opt_exec_shared.h:462
      #10 0x00000000034b7a4f in trace_tmp_table (trace=0x7fcf7ec267f0, table=0x7fcf97bf5980) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_tmp_table.cc:2399
      #11 0x00000000034b8e29 in create_ondisk_from_heap (thd=0x7fcf7ec24000, wtable=0x7fcf67c15028, start_recinfo=0x7fcf67c15e70, recinfo=0x7fcf67a9f218, error=135, ignore_last_dup=true, is_duplicate=0x7fcf97bf63d3) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_tmp_table.cc:2769
      #12 0x00000000034c8d14 in Query_result_union::send_data (this=0x7fcf67a9f1a8, thd=0x7fcf7ec24000, values=...) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_union.cc:99
      #13 0x000000000333ef68 in end_send (join=0x7fcf67a9aca0, qep_tab=0x7fcf67aa3fe8, end_of_records=false) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:3190
      #14 0x000000000333ab3c in evaluate_join_record (join=0x7fcf67a9aca0, qep_tab=0x7fcf67aa3d48) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1901
      #15 0x000000000334895b in QEP_tmp_table::end_send (this=0x7fcf67aa54a0) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:6556
      #16 0x00000000033395cd in sub_select_op (join=0x7fcf67a9aca0, qep_tab=0x7fcf67aa3d48, end_of_records=true) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1276
      #17 0x000000000333975f in sub_select (join=0x7fcf67a9aca0, qep_tab=0x7fcf67aa3aa8, end_of_records=true) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1446
      #18 0x000000000333975f in sub_select (join=0x7fcf67a9aca0, qep_tab=0x7fcf67aa3808, end_of_records=true) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1446
      #19 0x000000000333975f in sub_select (join=0x7fcf67a9aca0, qep_tab=0x7fcf67aa3568, end_of_records=true) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1446
      #20 0x000000000333975f in sub_select (join=0x7fcf67a9aca0, qep_tab=0x7fcf67aa32c8, end_of_records=true) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1446
      #21 0x000000000333975f in sub_select (join=0x7fcf67a9aca0, qep_tab=0x7fcf67aa3028, end_of_records=true) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1446
      #22 0x000000000333975f in sub_select (join=0x7fcf67a9aca0, qep_tab=0x7fcf67aa2d88, end_of_records=true) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1446
      #23 0x00000000033391f6 in do_select (join=0x7fcf67a9aca0) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1167
      #24 0x0000000003336080 in JOIN::exec (this=0x7fcf67a9aca0) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:282
      #25 0x0000000003120508 in subselect_hash_sj_engine::exec (this=0x7fcf67a9f148) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_subselect.cc:3656
      #26 0x0000000003116063 in Item_subselect::exec (this=0x7fcf67744708) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_subselect.cc:771
      #27 0x00000000031163ef in Item_in_subselect::exec (this=0x7fcf67744708) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_subselect.cc:843
      #28 0x00000000031192a5 in Item_in_subselect::val_bool (this=0x7fcf67744708) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_subselect.cc:1598
      #29 0x00000000030482ea in Item_in_optimizer::val_int (this=0x7fcf67a8bd80) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_cmpfunc.cc:2013
      #30 0x0000000003014eef in Item::val_bool (this=0x7fcf67a8bd80) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item.cc:203
      #31 0x0000000003055434 in Item_cond_and::val_int (this=0x7fcf67a94220) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_cmpfunc.cc:5160
      #32 0x000000000333a5bf in evaluate_join_record (join=0x7fcf67a8cb80, qep_tab=0x7fcf67a94df8) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1762
      #33 0x0000000003339cfe in sub_select (join=0x7fcf67a8cb80, qep_tab=0x7fcf67a94df8, end_of_records=false) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1563
      #34 0x000000000333ab3c in evaluate_join_record (join=0x7fcf67a8cb80, qep_tab=0x7fcf67a94b58) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1901
      #35 0x0000000003339cfe in sub_select (join=0x7fcf67a8cb80, qep_tab=0x7fcf67a94b58, end_of_records=false) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1563
      #36 0x000000000333ab3c in evaluate_join_record (join=0x7fcf67a8cb80, qep_tab=0x7fcf67a948b8) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1901
      #37 0x0000000003339cfe in sub_select (join=0x7fcf67a8cb80, qep_tab=0x7fcf67a948b8, end_of_records=false) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1563
      #38 0x00000000033391c4 in do_select (join=0x7fcf67a8cb80) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:1166
      #39 0x0000000003336080 in JOIN::exec (this=0x7fcf67a8cb80) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_executor.cc:282
      #40 0x00000000034212d7 in handle_query (thd=0x7fcf7ec24000, lex=0x7fcf7ec28800, result=0x7fcf67a82440, added_options=0, removed_options=0) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_select.cc:203
      #41 0x00000000033bb2f5 in execute_show (thd=0x7fcf7ec24000, all_tables=0x7fcf67cc1c98) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:5730
      #42 0x00000000033b28ff in mysql_execute_command (thd=0x7fcf7ec24000, first_level=true) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:3482
      #43 0x00000000033bc297 in mysql_parse (thd=0x7fcf7ec24000, parser_state=0x7fcf97bfac80, update_userstat=false, force_primary_storage_engine=false) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:6076
      #44 0x00000000033bfd0d in wsrep_mysql_parse (thd=0x7fcf7ec24000, rawbuf=0x7fcf67743028 "SHOW TABLE STATUS FROM test WHERE name IN ( SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_TYPE='BASE TABLE')", length=147, parser_state=0x7fcf97bfac80, update_userstat=false, force_primary_storage_engine=false) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:7263
      #45 0x00000000033ae3c9 in dispatch_command (thd=0x7fcf7ec24000, com_data=0x7fcf97bfcc50, command=COM_QUERY) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:2050
      #46 0x00000000033abb85 in do_command (thd=0x7fcf7ec24000) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:1419
      #47 0x000000000358428f in handle_connection (arg=0x7fcf86d1fa00) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/conn_handler/connection_handler_per_thread.cc:311
      #48 0x0000000004853dc6 in pfs_spawn_thread (arg=0x7fcf6a9e1120) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/perfschema/pfs.cc:2836
      #49 0x00007fcfb709c6ba in start_thread (arg=0x7fcf97bfe700) at pthread_create.c:333
      #50 0x00007fcfb544441d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      

      Attachments

        Activity

          People

            kamil.holubicki Kamil Holubicki
            ramesh.sivaraman Ramesh Sivaraman (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 days, 1 hour, 35 minutes
                2d 1h 35m

                Smart Checklist