Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14773

DROP TABLE hangs for InnoDB table with FULLTEXT index

    XMLWordPrintable

    Details

    • Sprint:
      10.2.14

      Description

      Statements like ALTER TABLE t. MODIFY COLUMN c DECIMAL(10,2) for the InnoDB table may hand at dropping of temporary table stage when the table has FULLTEXT index(es) defined.

      Full backtrace of relevant threads may look as follows:

      Thread 28 (Thread 0x7f5436be3700 (LWP 19822)):
      #0 ib_vector_last (table=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/include/ut0vec.ic:206
      No locals.
      #1 fts_sync_index_check (table=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/fts/fts0fts.cc:4049
      word = 0x7f5313f36c10
      rbt_node = 0x7f5313f36bf0
      #2 fts_sync (table=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/fts/fts0fts.cc:4292
      index_cache = 0x7f5313f98788
      i = <value optimized out>
      error = <value optimized out>
      cache = 0x7f53135ae2f0
      #3 fts_sync_table (table=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/fts/fts0fts.cc:4356
      err = DB_SUCCESS
      #4 0x00007f588972de62 in fts_optimize_sync_table (table_id=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/fts/fts0opt.cc:2960
      table = 0x7f531359e6d0
      #5 0x00007f588972e26b in fts_optimize_thread (arg=0x7f58a47957d0) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/fts/fts0opt.cc:3088
      msg = 0x7f5313fb28c0
      heap_alloc = 0x7f542c0016e0
      current = <value optimized out>
      done = <value optimized out>
      n_tables = <value optimized out>
      n_optimize = <value optimized out>
      wq = 0x7f58a47957d0
      tables = 0x7f542c000a30
      #6 0x00007f5888851aa1 in start_thread () from /lib64/libpthread.so.0
      No symbol table info available.
      #7 0x00007f5886f69bcd in clone () from /lib64/libc.so.6
      No symbol table info available.
       
      ...
       
      Thread 6 (Thread 0x7f586c243700 (LWP 29207)):
      #0 0x00007f588885900d in nanosleep () from /lib64/libpthread.so.0
      No symbol table info available.
      #1 0x00007f58895505d0 in os_thread_sleep (tm=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/os/os0thread.cc:230
      t = {tv_sec = 0, tv_nsec = 250000000}
      #2 0x00007f58895a6409 in row_drop_table_for_mysql (name=0x7f586c23e1e0 "edoc_devel_oh/#sql-4914_19d3d", trx=0x7f586d8a5318, drop_db=false, create_failed=0, nonatomic=true) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/row/row0mysql.cc:3639
      err = <value optimized out>
      table = 0x7f531359e6d0
      page_nos = 0x5a3d0a08
      filepath = 0x0
      tablename = 0x0
      locked_dictionary = true
      info = 0x0
      page_no = <value optimized out>
      foreign = <value optimized out>
      heap = 0x0
      #3 0x00007f58894ebec5 in ha_innobase::delete_table (this=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/handler/ha_innodb.cc:13671
      err = <value optimized out>
      trx_in_innodb = {m_trx = 0x7f586d8a5698}
      iter =
      thd = 0x7f534c0009a8
      norm_name = "edoc_devel_oh/#sql-4914_19d3d", '\000' <repeats 19 times>, "\001;\204\211X\177\000\000\200\067\204\211X\177\000\000\000\001\204\211X\177", '\000' <repeats 18 times>"\377, \377\377\377\377\377\377\377", '\000' <repeats 16 times>, "\020\000\000\000\b\000\000\000\000\001\000\000\000\000\000\000\003\000\000\000\000\000\000\000 \000\000LS\177\000\000\220\v\000\000\000\000\000\000\020\020\001\000\000\000\000\000\340\342#lX\177\000\000\t\263\357\206X\177\000\000\360\342#lX\177\000\000\001\326\061\211X\177\000\000]\255\\\023S\177\000\000\002\000\000\000\000\000\000\000\340\342#l^\000\000\000.\000\000\000\000\000\000\000\005", '\000' <repeats 35 times>, "S\177\000\000\000\000\000\000\000\000\000\000\021\004", '\000' <repeats 14 times>...
      parent_trx = 0x7f586d8a5698
      trx = 0x7f586d8a5318
      name_len = <value optimized out>
      #4 0x00007f58892e2b50 in THD::rm_temporary_table (this=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/temporary_tables.cc:676
      error = false
      file = 0x7f5313591e60
      frm_path = "./edoc_devel_oh/#sql-4914_19d3d.frm\000X\177\000\000\260\346#lX\177", '\000' <repeats 18 times>"\210, \r\000\000\000\000\000\000\020\020\000\000\000\000\000\000\200\r\000\000\000\000\000\000V|iT_\374\026\207X\205Y\023\036\000\000\000\000\000\000\000\036\000\000\000\006\000\000\000\000\000\000\000=\353L\211\362\001\000\000\030\257\234\211X\177\000\000\360\220Y\023S\177\000\000@\347#lX\177\000\000\260\246L\211X\177\000\000\000\000\000\000\000\000\000\000\360\220Y\023S\177\000\000\200\347#lX\177\000\000\000\000\000\000\000\000\000\000\362\001\000\000\000\000\000\000\001", '\000' <repeats 15 times>, "\036\000\000\000\000\000\000\000\360\347#lX\177\000\000r k\211X\177\000\000"...
      #5 0x00007f58892e2fa1 in THD::free_tmp_table_share (this=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/temporary_tables.cc:1445
      No locals.
      #6 0x00007f58892e48a3 in THD::drop_temporary_table (this=0x7f534c0009a8, table=0x7f5313598558, is_trans=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/temporary_tables.cc:639
      share = 0x7f53135b2a98
      tab = <value optimized out>
      locked = false
      result = false
      it = {list = <value optimized out>, current = 0x0}
      #7 0x00007f5889238c0f in mysql_alter_table (thd=0x7f534c0009a8, new_db=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_table.cc:9653
       
      ...
       
      #10 0x00007f58891b9d2a in mysql_parse (thd=0x7f534c0009a8, rawbuf=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_parse.cc:7887
      found_semicolon = <value optimized out>
      lex = 0x7f534c0042c0
      err = <value optimized out>
      __FUNCTION__ = "mysql_parse"
      #11 0x00007f58891bc09e in dispatch_command (command=COM_QUERY, thd=0x7f534c0009a8, packet=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_parse.cc:1805
      packet_end = 0x7f534c00f0b1 ""
      parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x7f534c0009a8, yylineno = 1, yylval = 0x7f586c2412a0, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7f534c00f0b2 "\r", m_tok_start = 0x7f534c00f0b2 "\r", m_tok_end = 0x7f534c00f0b2 "\r", m_end_of_query = 0x7f534c00f0b1 "", m_tok_start_prev = 0x7f534c00f0b1 "", m_buf = 0x7f534c00f080 "ALTER TABLE unit MODIFY COLUMN ceu DECIMAL (10,2)", m_buf_length = 49, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x7f534c00f120 "ALTER TABLE unit MODIFY COLUMN ceu DECIMAL (10,2)", m_cpp_ptr = 0x7f534c00f151 "", m_cpp_tok_start = 0x7f534c00f151 "", m_cpp_tok_start_prev = 0x7f534c00f151 "", m_cpp_tok_end = 0x7f534c00f151 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x20 <Address 0x20 out of bounds>, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = 28, m_cpp_text_start = 0x7f534c00f14f "2)", m_cpp_text_end = 0x7f534c00f150 ")", m_underscore_cs = 0x0, m_digest = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 12 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x0}
      net = 0x7f586c242150
      do_end_of_statement = true
      __FUNCTION__ = "dispatch_command"
      error = false
      drop_more_results = false
      #12 0x00007f58891bc65e in do_command (thd=0x7f534c0009a8) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_parse.cc:1360
      return_value = <value optimized out>
      packet = <value optimized out>
      packet_length = 50
      net = 0x7f534c000be8
      command = COM_QUERY
      #13 0x00007f5889279faf in do_handle_one_connection (connect=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_connect.cc:1354
      create_user = true
      thr_create_utime = <value optimized out>
      thd = 0x7f534c0009a8
      #14 0x00007f588927a0d4 in handle_one_connection (arg=0x7f58b8f07c28) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_connect.cc:1260
      connect = 0x7f58b8f07c28
      #15 0x00007f5888851aa1 in start_thread () from /lib64/libpthread.so.0
      No symbol table info available.
      #16 0x00007f5886f69bcd in clone () from /lib64/libc.so.6
      No symbol table info available.
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                marko Marko Mäkelä
                Reporter:
                valerii Valerii Kravchuk
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: