Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Description
A similar failure MDEV-22676 was attributed to MDEV-371. This one does not use unique blobs and affects also 10.3.
--source include/have_innodb.inc
|
|
CREATE TABLE t (c CHAR(8), FULLTEXT INDEX ft(c)) ENGINE=InnoDB; |
INSERT INTO t (c) VALUES ('x'); |
ALTER TABLE t ADD FTS_DOC_ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY; |
ALTER TABLE t ADD SYSTEM VERSIONING; |
REPLACE INTO t SELECT * FROM t; |
ALTER IGNORE TABLE t FORCE, ALGORITHM=COPY; |
|
# Cleanup
|
DROP TABLE t; |
10.3 df4c3d96 |
2022-11-18 01:40:37 0x7f24deefb300 InnoDB: Assertion failure in file /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/fts/fts0fts.cc line 2199
|
InnoDB: Failing assertion: result != FTS_INVALID
|
|
#6 0x00005638d61e7205 in ut_dbg_assertion_failed (expr=0x5638d73d3300 "result != FTS_INVALID", file=0x5638d73d1740 "/home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/fts/fts0fts.cc", line=2199) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/ut/ut0dbg.cc:60
|
#7 0x00005638d648a7d6 in fts_trx_row_get_new_state (old_state=FTS_INSERT, event=FTS_INSERT) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/fts/fts0fts.cc:2199
|
#8 0x00005638d648b38c in fts_trx_table_add_op (ftt=0x61900012f948, doc_id=1, state=FTS_INSERT, fts_indexes=0x0) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/fts/fts0fts.cc:2387
|
#9 0x00005638d648b7b6 in fts_trx_add_op (trx=0x7f24ebb408b8, table=0x619000120d08, doc_id=1, state=FTS_INSERT, fts_indexes=0x0) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/fts/fts0fts.cc:2434
|
#10 0x00005638d60106c3 in row_insert_for_mysql (mysql_rec=0x61900012edb8 "\375x \001", prebuilt=0x621000099d88, ins_mode=ROW_INS_NORMAL) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/row/row0mysql.cc:1494
|
#11 0x00005638d5cde051 in ha_innobase::write_row (this=0x61c0000d38a8, record=0x61900012edb8 "\375x \001") at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/handler/ha_innodb.cc:8201
|
#12 0x00005638d5796b41 in handler::ha_write_row (this=0x61c0000d38a8, buf=0x61900012edb8 "\375x \001") at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/handler.cc:6495
|
#13 0x00005638d526fd32 in copy_data_between_tables (thd=0x62a0000ba208, from=0x61f000047c88, to=0x61f000049888, create=..., ignore=true, order_num=0, order=0x0, copied=0x7f24deef5b40, deleted=0x7f24deef5b60, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=0x7f24deef6830) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_table.cc:10833
|
#14 0x00005638d526b093 in mysql_alter_table (thd=0x62a0000ba208, new_db=0x62a0000be918, new_name=0x62a0000bed00, create_info=0x7f24deef7550, table_list=0x62b000000358, alter_info=0x7f24deef7450, order_num=0, order=0x0, ignore=true) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_table.cc:10262
|
#15 0x00005638d53d394c in Sql_cmd_alter_table::execute (this=0x62b000000a08, thd=0x62a0000ba208) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_alter.cc:512
|
#16 0x00005638d501f844 in mysql_execute_command (thd=0x62a0000ba208) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:6076
|
#17 0x00005638d502b676 in mysql_parse (thd=0x62a0000ba208, rawbuf=0x62b000000228 "ALTER IGNORE TABLE t FORCE, ALGORITHM=COPY", length=42, parser_state=0x7f24deef9950, is_com_multi=false, is_next_command=false) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:7855
|
#18 0x00005638d5002cc4 in dispatch_command (command=COM_QUERY, thd=0x62a0000ba208, packet=0x629000136209 "ALTER IGNORE TABLE t FORCE, ALGORITHM=COPY", packet_length=42, is_com_multi=false, is_next_command=false) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:1852
|
#19 0x00005638d4fff87c in do_command (thd=0x62a0000ba208) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:1398
|
#20 0x00005638d53c3236 in do_handle_one_connection (connect=0x608000000ea8) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_connect.cc:1403
|
#21 0x00005638d53c2b32 in handle_one_connection (arg=0x608000000ea8) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_connect.cc:1308
|
#22 0x00005638d696f88d in pfs_spawn_thread (arg=0x615000007608) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/perfschema/pfs.cc:1869
|
#23 0x00007f24f58dbea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#24 0x00007f24f57fbaef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Reproducible on all 10.3+, debug and non-debug.
Attachments
Issue Links
- duplicates
-
MDEV-25004 Missing row in FTS_DOC_ID_INDEX during DELETE HISTORY
- Closed
- relates to
-
MDEV-22676 InnoDB: Failing assertion: result != FTS_INVALID upon DML on table with unique blob
- Open