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

Block instant alter operation for the table with FULLTEXT index

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (FTS_DOC_ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, c TEXT, KEY (FTS_DOC_ID), FULLTEXT fk (c)) ENGINE=InnoDB;
      INSERT INTO t1 (c) VALUES ('foo');
      ALTER TABLE t1 ADD d GEOMETRY DEFAULT ST_GEOMFROMTEXT('Point(1 1)');
      REPLACE INTO t1 (d) VALUES (NULL);
       
      # Cleanup
      DROP TABLE t1;
      

      10.3 e1e142e7

      mysqld: /data/src/10.3/storage/innobase/fts/fts0fts.cc:3228: void fts_fetch_doc_from_rec(fts_get_doc_t*, dict_index_t*, btr_pcur_t*, ulint*, fts_doc_t*): Assertion `!page_rec_is_comp(clust_rec) || rec_get_status(clust_rec) == REC_STATUS_ORDINARY' failed.
      190802 17:08:54 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f0cf5864f12 in __GI___assert_fail (assertion=0x560c450ce008 "!page_rec_is_comp(clust_rec) || rec_get_status(clust_rec) == REC_STATUS_ORDINARY", file=0x560c450cd500 "/data/src/10.3/storage/innobase/fts/fts0fts.cc", line=3228, function=0x560c450d05e0 <fts_fetch_doc_from_rec(fts_get_doc_t*, dict_index_t*, btr_pcur_t*, unsigned long*, fts_doc_t*)::__PRETTY_FUNCTION__> "void fts_fetch_doc_from_rec(fts_get_doc_t*, dict_index_t*, btr_pcur_t*, ulint*, fts_doc_t*)") at assert.c:101
      #8  0x0000560c44ae80f2 in fts_fetch_doc_from_rec (get_doc=0x7f0c9c03d6c8, clust_index=0x7f0c9c0a8258, pcur=0x7f0cf0062500, offsets=0x7f0c9c050478, doc=0x7f0cf00623b0) at /data/src/10.3/storage/innobase/fts/fts0fts.cc:3228
      #9  0x0000560c44ae8df1 in fts_add_doc_by_id (ftt=0x7f0c9c0450d8, doc_id=2, fts_indexes=0x0) at /data/src/10.3/storage/innobase/fts/fts0fts.cc:3540
      #10 0x0000560c44ae743e in fts_add (ftt=0x7f0c9c0450d8, row=0x7f0c9c010f80) at /data/src/10.3/storage/innobase/fts/fts0fts.cc:2847
      #11 0x0000560c44ae7be5 in fts_commit_table (ftt=0x7f0c9c0450d8) at /data/src/10.3/storage/innobase/fts/fts0fts.cc:3019
      #12 0x0000560c44ae7cd9 in fts_commit (trx=0x7f0ceb3ff0f0) at /data/src/10.3/storage/innobase/fts/fts0fts.cc:3068
      #13 0x0000560c449a58b2 in trx_commit_low (trx=0x7f0ceb3ff0f0, mtr=0x7f0cf0062c50) at /data/src/10.3/storage/innobase/trx/trx0trx.cc:1445
      #14 0x0000560c449a5a7d in trx_commit (trx=0x7f0ceb3ff0f0) at /data/src/10.3/storage/innobase/trx/trx0trx.cc:1534
      #15 0x0000560c449a5e86 in trx_commit_for_mysql (trx=0x7f0ceb3ff0f0) at /data/src/10.3/storage/innobase/trx/trx0trx.cc:1670
      #16 0x0000560c447811fd in innobase_commit_low (trx=0x7f0ceb3ff0f0) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:4407
      #17 0x0000560c44781592 in innobase_commit_ordered_2 (trx=0x7f0ceb3ff0f0, thd=0x7f0c9c000b00) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:4521
      #18 0x0000560c44781a80 in innobase_commit (hton=0x560c47b1f910, thd=0x7f0c9c000b00, commit_trx=false) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:4637
      #19 0x0000560c445765ec in commit_one_phase_2 (thd=0x7f0c9c000b00, all=false, trans=0x7f0c9c004030, is_real_trans=true) at /data/src/10.3/sql/handler.cc:1641
      #20 0x0000560c445764e8 in ha_commit_one_phase (thd=0x7f0c9c000b00, all=false) at /data/src/10.3/sql/handler.cc:1621
      #21 0x0000560c44575c81 in ha_commit_trans (thd=0x7f0c9c000b00, all=false) at /data/src/10.3/sql/handler.cc:1483
      #22 0x0000560c443ef006 in trans_commit_stmt (thd=0x7f0c9c000b00) at /data/src/10.3/sql/transaction.cc:505
      #23 0x0000560c4427f90b in mysql_execute_command (thd=0x7f0c9c000b00) at /data/src/10.3/sql/sql_parse.cc:6098
      #24 0x0000560c44284602 in mysql_parse (thd=0x7f0c9c000b00, rawbuf=0x7f0c9c012818 "REPLACE INTO t1 (d) VALUES (NULL)", length=33, parser_state=0x7f0cf00645e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7829
      #25 0x0000560c44272200 in dispatch_command (command=COM_QUERY, thd=0x7f0c9c000b00, packet=0x7f0c9c160121 "REPLACE INTO t1 (d) VALUES (NULL)", packet_length=33, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1856
      #26 0x0000560c44270c23 in do_command (thd=0x7f0c9c000b00) at /data/src/10.3/sql/sql_parse.cc:1401
      #27 0x0000560c443daa4c in do_handle_one_connection (connect=0x560c47e553b0) at /data/src/10.3/sql/sql_connect.cc:1403
      #28 0x0000560c443da7ae in handle_one_connection (arg=0x560c47e553b0) at /data/src/10.3/sql/sql_connect.cc:1308
      #29 0x0000560c44cb5ed8 in pfs_spawn_thread (arg=0x560c47d9daa0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #30 0x00007f0cf73d94a4 in start_thread (arg=0x7f0cf0065700) at pthread_create.c:456
      #31 0x00007f0cf5921d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Not reproducible on 10.2 and 10.4.
      No obvious problem on a non-debug build.

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.