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

InnoDB: Failing assertion: dfield_get_len(field) == sizeof(doc_id)

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.11, 11.0, 11.1, 11.2, 11.3, 11.4
    • 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3, 11.4
    • None
    • None

    Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (b text, vb text AS (b), FTS_DOC_ID bigint(20) NOT NULL, FULLTEXT KEY (b))engine=innodb;
      INSERT INTO t1 (b,FTS_DOC_ID) VALUES (1,1);
      

      10.2 ad1fb06982d70c7ef61ac7

      2022-02-11 17:45:42 0x7f36f4ffd700  InnoDB: Assertion failure in file /10.2/src/storage/innobase/fts/fts0fts.cc line 5170
      InnoDB: Failing assertion: dfield_get_len(field) == sizeof(doc_id)
      InnoDB: We intentionally generate a memory trap.
      InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      InnoDB: If you get repeated assertion failures or crashes, even
      InnoDB: immediately after the mysqld startup, there may be
      InnoDB: corruption in the InnoDB tablespace. Please refer to
      InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
      InnoDB: about forcing recovery.
      220211 17:45:42 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.2.43-MariaDB-debug-log
       
      ut/ut0dbg.cc:60(_sub_D_00099_0)[0x563c8dcae004]
      fts/fts0fts.cc:5171(fts_get_doc_id_from_row(dict_table_t*, dtuple_t*))[0x563c8df13654]
      row/row0mysql.cc:1445(row_insert_for_mysql(unsigned char const*, row_prebuilt_t*))[0x563c8dae757a]
      handler/ha_innodb.cc:8285(ha_innobase::write_row(unsigned char*))[0x563c8d823e1c]
      sql/handler.cc:6118(handler::ha_write_row(unsigned char*))[0x563c8d310af2]
      sql/sql_insert.cc:1951(write_record(THD*, TABLE*, st_copy_info*))[0x563c8cc47eaa]
      sql/sql_insert.cc:1066(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool))[0x563c8cc41905]
      sql/sql_parse.cc:4217(mysql_execute_command(THD*))[0x563c8cca8d4d]
      sql/sql_parse.cc:7793(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x563c8ccc1628]
      sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x563c8cc9a82d]
      sql/sql_parse.cc:1381(do_command(THD*))[0x563c8cc975f8]
      sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x563c8d023c3e]
      sql/sql_connect.cc:1242(handle_one_connection)[0x563c8d023501]
      perfschema/pfs.cc:1871(pfs_spawn_thread)[0x563c8e3c408e]
      nptl/pthread_create.c:478(start_thread)[0x7f370bc27609]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f370b800293]
       
      Query (0x62b000000290): INSERT INTO t1 (b,FTS_DOC_ID) VALUES (1,1)
      

      --source include/have_innodb.inc
       
      CREATE TABLE t1 ( a char(50), b text, vb text AS (b), FTS_DOC_ID bigint(20) NOT NULL , UNIQUE KEY (b))engine=innodb;
      INSERT INTO t1 (a,b,FTS_DOC_ID) VALUES (1,1,1);
      ALTER  TABLE t1 ADD FULLTEXT INDEX (a);
      

      10.4 8a7776a83d6251221779bef

      2022-02-11 17:11:08 0x7f4c033d6300  InnoDB: Assertion failure in file 10.4/src/storage/innobase/fts/fts0fts.cc line 5123
      InnoDB: Failing assertion: dfield_get_len(field) == sizeof(doc_id)
      InnoDB: We intentionally generate a memory trap.
      InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      InnoDB: If you get repeated assertion failures or crashes, even
      InnoDB: immediately after the mysqld startup, there may be
      InnoDB: corruption in the InnoDB tablespace. Please refer to
      InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
      InnoDB: about forcing recovery.
      220211 17:11:08 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.4.24-MariaDB-debug-log
       
      /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb)[0x7f4c19aa018b]
      /lib/x86_64-linux-gnu/libc.so.6(abort+0x12b)[0x7f4c19a7f859]
      ut/ut0dbg.cc:60(_sub_D_00099_0)[0x55aaf96646f4]
      fts/fts0fts.cc:5124(fts_get_doc_id_from_row(dict_table_t*, dtuple_t*))[0x55aaf9919766]
      row/row0mysql.cc:1438(row_insert_for_mysql(unsigned char const*, row_prebuilt_t*, ins_mode_t))[0x55aaf94ab122]
      handler/ha_innodb.cc:8168(ha_innobase::write_row(unsigned char const*))[0x55aaf91355ac]
      sql/handler.cc:6774(handler::ha_write_row(unsigned char const*))[0x55aaf871644f]
      sql/sql_table.cc:10985(copy_data_between_tables(THD*, TABLE*, TABLE*, List<Create_field>&, bool, unsigned int, st_order*, unsigned long long*, unsigned long long*, Alter_info::enum_enable_or_disable, Alter_table_ctx*))[0x55aaf81c46b8]
      sql/sql_table.cc:10405(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool))[0x55aaf81bf888]
      sql/sql_alter.cc:520(Sql_cmd_alter_table::execute(THD*))[0x55aaf834359a]
      sql/sql_parse.cc:6192(mysql_execute_command(THD*))[0x55aaf7f50693]
      sql/sql_parse.cc:7995(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55aaf7f5c1cf]
      sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55aaf7f32956]
      sql/sql_parse.cc:1373(do_command(THD*))[0x55aaf7f2f3d3]
      sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x55aaf832aacb]
      sql/sql_connect.cc:1317(handle_one_connection)[0x55aaf832a224]
      perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55aaf902aa6b]
      nptl/pthread_create.c:478(start_thread)[0x7f4c19fa9609]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f4c19b7c293]
       
       
      Query (0x62b0000a1290): ALTER  TABLE t1 ADD FULLTEXT INDEX (a)
      

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            alice Alice Sherepa
            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.