Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 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)
|