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

InnoDB: Failing assertion: table->cached && table->fts != __null | fts0opt.cc line 2576

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      GDB info

      #0  0x00007f44130c7771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
      #1  0x0000000000af8484 in my_write_core (sig=6) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/mysys/stacktrace.c:424
      #2  0x000000000075bf72 in handle_fatal_signal (sig=6) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/signal_handler.cc:248
      #3  <signal handler called>
      #4  0x00007f441124f5d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
      #5  0x00007f4411250cc8 in __GI_abort () at abort.c:90
      #6  0x0000000000dcbaf5 in fts_optimize_add_table (table=0x7f43d8096b78) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/storage/innobase/fts/fts0opt.cc:2576
      #7  0x0000000000d7abbf in dict_load_columns (table=0x7f43d8096b78, heap=0x7f43d870f000) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/storage/innobase/dict/dict0load.cc:1572
      #8  0x0000000000d7cf82 in dict_load_table (name=0x7f44135f76d0 "test/wp", cached=1, ignore_err=DICT_ERR_IGNORE_NONE) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/storage/innobase/dict/dict0load.cc:2581
      #9  0x0000000000d64622 in dict_table_open_on_name (table_name=0x7f44135f76d0 "test/wp", dict_locked=0, try_drop=1, ignore_err=DICT_ERR_IGNORE_NONE) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/storage/innobase/dict/dict0dict.cc:1131
      #10 0x0000000000b58326 in ha_innobase::open (this=0x7f43db7eca10, name=0x7f43e12c4f50 "./test/wp", mode=2, test_if_locked=2) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/storage/innobase/handler/ha_innodb.cc:5961
      #11 0x000000000066a131 in handler::ha_open (this=0x7f43db7eca10, table_arg=0x7f43e12da800, name=0x7f43e12c4f50 "./test/wp", mode=2, test_if_locked=2) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/handler.cc:2829
      #12 0x00000000008e5b3d in open_table_from_share (thd=0x7f43eab31000, share=0x7f43e12c4c10, alias=0x7f43db7e3670 "wp", db_stat=39, prgflag=44, ha_open_flags=0, outparam=0x7f43e12da800, is_create_table=false) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/table.cc:2450
      #13 0x000000000079e2cb in open_table (thd=0x7f43eab31000, table_list=0x7f43db7e3678, ot_ctx=0x7f44135f8140) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_base.cc:3230
      #14 0x00000000007a0bc5 in open_and_process_table (thd=0x7f43eab31000, lex=0x7f44135f8300, tables=0x7f43db7e3678, counter=0x7f44135f83c0, flags=1282, prelocking_strategy=0x7f44135f8240, has_prelocking_list=false, ot_ctx=0x7f44135f8140) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_base.cc:4811
      #15 0x00000000007a1a47 in open_tables (thd=0x7f43eab31000, start=0x7f44135f8200, counter=0x7f44135f83c0, flags=1282, prelocking_strategy=0x7f44135f8240) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_base.cc:5318
      #16 0x00000000007a2d5e in open_normal_and_derived_tables (thd=0x7f43eab31000, tables=0x7f43db7e3678, flags=1282) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_base.cc:6053
      #17 0x00000000008669aa in fill_schema_table_by_open (thd=0x7f43eab31000, is_show_fields_or_keys=false, table=0x7f43ddffe010, schema_table=0x1519ce0 <schema_tables+832>, orig_db_name=0x7f43e1058eb0, orig_table_name=0x7f43e3152c40, open_tables_state_backup=0x7f44135f9720, can_deadlock=true) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_show.cc:3919
      #18 0x0000000000868f0c in get_all_tables (thd=0x7f43eab31000, tables=0x7f43e301f458, cond=0x7f43e301fb98) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_show.cc:4871
      #19 0x0000000000876910 in do_fill_table (thd=0x7f43eab31000, table_list=0x7f43e301f458, join_table=0x7f43dbf8eb50) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_show.cc:8060
      #20 0x0000000000876cdd in get_schema_tables_result (join=0x7f43dbf8e010, executed_place=PROCESSED_BY_JOIN_EXEC) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_show.cc:8161
      #21 0x0000000000848ed0 in JOIN::prepare_result (this=0x7f43dbf8e010, columns_list=0x7f44135f9b40) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_select.cc:827
      #22 0x00000000007df309 in JOIN::exec (this=0x7f43dbf8e010) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_executor.cc:116
      #23 0x00000000008499b3 in mysql_execute_select (thd=0x7f43eab31000, select_lex=0x7f43eab33b28, free_join=true) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_select.cc:1105
      #24 0x0000000000849ca5 in mysql_select (thd=0x7f43eab31000, tables=0x7f43e301f458, wild_num=0, fields=..., conds=0x7f43e301fb98, order=0x7f43eab33cf0, group=0x7f43eab33c28, having=0x0, select_options=71404620800, result=0x7f43e3020d30, unit=0x7f43eab334e0, select_lex=0x7f43eab33b28) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_select.cc:1226
      #25 0x0000000000847d76 in handle_select (thd=0x7f43eab31000, result=0x7f43e3020d30, setup_tables_done_option=0) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_select.cc:110
      #26 0x000000000081e245 in execute_sqlcom_select (thd=0x7f43eab31000, all_tables=0x7f43e301f458) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_parse.cc:6472
      #27 0x00000000008138f9 in mysql_execute_command (thd=0x7f43eab31000) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_parse.cc:3413
      #28 0x00000000008218c9 in mysql_parse (thd=0x7f43eab31000, rawbuf=0x7f43e301f010 "select referenced_table_schema, referenced_table_name from information_schema.key_column_usage where constraint_schema = 'db-1'", length=127, parser_state=0x7f44135fb4b0) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_parse.cc:7922
      #29 0x0000000000820b4e in wsrep_mysql_parse (thd=0x7f43eab31000, rawbuf=0x7f43e301f010 "select referenced_table_schema, referenced_table_name from information_schema.key_column_usage where constraint_schema = 'db-1'", length=127, parser_state=0x7f44135fb4b0) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_parse.cc:7622
      #30 0x000000000080f940 in dispatch_command (command=COM_QUERY, thd=0x7f43eab31000, packet=0x7f43eab37001 "select referenced_table_schema, referenced_table_name from information_schema.key_column_usage where constraint_schema = 'db-1';", packet_length=128) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_parse.cc:1739
      #31 0x000000000080dedd in do_command (thd=0x7f43eab31000) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_parse.cc:1186
      #32 0x00000000007d4627 in do_handle_one_connection (thd_arg=0x7f440a3de000) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_connect.cc:1580
      #33 0x00000000007d431b in handle_one_connection (arg=0x7f440a3de000) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_connect.cc:1477
      #34 0x0000000000b40fb1 in pfs_spawn_thread (arg=0x7f440abfef60) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/storage/perfschema/pfs.cc:1860
      #35 0x00007f44130c2df5 in start_thread (arg=0x7f44135fc700) at pthread_create.c:308
      #36 0x00007f44113101ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                ramesh.sivaraman Ramesh Sivaraman
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: