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

Assertion failure: dict0dict.cc:1872:table->get_ref_count() == 0

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Incomplete
    • 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  0x0000000004617198 in my_write_core (sig=6) at /qa/8pxc/PXC-8.0/mysys/stacktrace.cc:278
      #2  0x00000000034784cd in handle_fatal_signal (sig=6) at /qa/8pxc/PXC-8.0/sql/signal_handler.cc:266
      #3  <signal handler called>
      #4  0x00007ffaba60e428 in __GI_raise ([email protected]=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      #5  0x00007ffaba61002a in __GI_abort () at abort.c:89
      #6  0x0000000004b6f08d in ut_dbg_assertion_failed (expr=0x5eb4b9e "table->get_ref_count() == 0", file=0x5eb42c0 "/qa/8pxc/PXC-8.0/storage/innobase/dict/dict0dict.cc", line=1872) at /qa/8pxc/PXC-8.0/storage/innobase/ut/ut0dbg.cc:90
      #7  0x0000000004c5dcac in dict_table_remove_from_cache_low (table=0x7ffa534510b8, lru_evict=0) at /qa/8pxc/PXC-8.0/storage/innobase/dict/dict0dict.cc:1872
      #8  0x0000000004c5e427 in dict_table_remove_from_cache (table=0x7ffa534510b8) at /qa/8pxc/PXC-8.0/storage/innobase/dict/dict0dict.cc:1955
      #9  0x000000000486e65e in ha_innobase::open (this=0x7ffa53490028, name=0x7ffa59f6af88 "./test/t1", open_flags=2, table_def=0x7ffa59f8f088) at /qa/8pxc/PXC-8.0/storage/innobase/handler/ha_innodb.cc:7079
      #10 0x0000000002edf47f in handler::ha_open (this=0x7ffa53490028, table_arg=0x7ffa5a01ec20, name=0x7ffa59f6af88 "./test/t1", mode=2, test_if_locked=2, table_def=0x7ffa59f8f088) at /qa/8pxc/PXC-8.0/sql/handler.cc:2989
      #11 0x00000000033f38ec in open_table_from_share (thd=0x7ffa77c24000, share=0x7ffa59f6ac28, alias=0x7ffa534724a8 "t3", db_stat=39, prgflag=8, ha_open_flags=0, outparam=0x7ffa5a01ec20, is_create_table=false, table_def_param=0x7ffa59f8f088) at /qa/8pxc/PXC-8.0/sql/table.cc:3187
      #12 0x00000000031c15cc in open_table (thd=0x7ffa77c24000, table_list=0x7ffa53474470, ot_ctx=0x7ffaba4ff930) at /qa/8pxc/PXC-8.0/sql/sql_base.cc:3383
      #13 0x00000000031c53bf in open_and_process_table (thd=0x7ffa77c24000, lex=0x7ffa77c28800, tables=0x7ffa53474470, counter=0x7ffa77c28858, prelocking_strategy=0x7ffaba4ffdc0, has_prelocking_list=false, ot_ctx=0x7ffaba4ff930) at /qa/8pxc/PXC-8.0/sql/sql_base.cc:5072
      #14 0x00000000031c6a0b in open_tables (thd=0x7ffa77c24000, start=0x7ffaba4ffdb0, counter=0x7ffa77c28858, flags=0, prelocking_strategy=0x7ffaba4ffdc0) at /qa/8pxc/PXC-8.0/sql/sql_base.cc:5723
      #15 0x00000000031c8eb8 in open_tables_for_query (thd=0x7ffa77c24000, tables=0x7ffa53472db0, flags=0) at /qa/8pxc/PXC-8.0/sql/sql_base.cc:6733
      #16 0x00000000033059f4 in Sql_cmd_dml::prepare (this=0x7ffa53475570, thd=0x7ffa77c24000) at /qa/8pxc/PXC-8.0/sql/sql_select.cc:403
      #17 0x00000000033061b7 in Sql_cmd_dml::execute (this=0x7ffa53475570, thd=0x7ffa77c24000) at /qa/8pxc/PXC-8.0/sql/sql_select.cc:552
      #18 0x000000000329f62b in mysql_execute_command (thd=0x7ffa77c24000, first_level=true) at /qa/8pxc/PXC-8.0/sql/sql_parse.cc:5186
      #19 0x00000000032a22a6 in mysql_parse (thd=0x7ffa77c24000, parser_state=0x7ffaba501bc0, update_userstat=false, force_primary_storage_engine=false) at /qa/8pxc/PXC-8.0/sql/sql_parse.cc:6003
      #20 0x00000000032a5c97 in wsrep_mysql_parse (thd=0x7ffa77c24000, rawbuf=0x7ffa53471028 "select t1.name, t2.name, t2.id,t3.id from t1 right join t2 on (t1.id = t2.owner) right join t1 as t3 on t3.id=t2.owner", length=118, parser_state=0x7ffaba501bc0, update_userstat=false, force_primary_storage_engine=false) at /qa/8pxc/PXC-8.0/sql/sql_parse.cc:7178
      #21 0x000000000329464c in dispatch_command (thd=0x7ffa77c24000, com_data=0x7ffaba502890, command=COM_QUERY) at /qa/8pxc/PXC-8.0/sql/sql_parse.cc:2021
      #22 0x0000000003291f2f in do_command (thd=0x7ffa77c24000) at /qa/8pxc/PXC-8.0/sql/sql_parse.cc:1415
      #23 0x0000000003460c2e in handle_connection (arg=0x7ffa9469acd0) at /qa/8pxc/PXC-8.0/sql/conn_handler/connection_handler_per_thread.cc:317
      #24 0x000000000470dbec in pfs_spawn_thread (arg=0x7ffa9467de20) at /qa/8pxc/PXC-8.0/storage/perfschema/pfs.cc:2836
      #25 0x00007ffabc32c6ba in start_thread (arg=0x7ffaba503700) at pthread_create.c:333
      #26 0x00007ffaba6e041d 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:
              2 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 - 1 hour, 5 minutes
                  1h 5m

                  Smart Checklist