[MDEV-22676] InnoDB: Failing assertion: result != FTS_INVALID upon DML on table with unique blob - Jira

Details

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL)
Fix Version/s: 10.5, 10.6
Component/s: Full-text Search, Server, Storage Engine - InnoDB
Labels:
- fixed

Description

--source include/have_innodb.inc

CREATE OR REPLACE TABLE t1 (f TEXT UNIQUE, FULLTEXT(f)) ENGINE=InnoDB;

INSERT INTO t1 VALUES ('foo');

CREATE OR REPLACE TABLE t2 (a VARCHAR(255)) ENGINE=InnoDB;

INSERT INTO t2 VALUES ('foobar'),('qux');

UPDATE t1 JOIN t2 SET f = a;

# Cleanup

DROP TABLE t1, t2;

10.4 dc22acfd
2020-05-22 21:48:19 0x7f68383bc700 InnoDB: Assertion failure in file /data/src/10.4/storage/innobase/fts/fts0fts.cc line 2208
InnoDB: Failing assertion: result != FTS_INVALID

#6 0x000055bcd1df1052 in ut_dbg_assertion_failed (expr=0x55bcd26066cc "result != FTS_INVALID", file=0x55bcd2605f70 "/data/src/10.4/storage/innobase/fts/fts0fts.cc", line=2208) at /data/src/10.4/storage/innobase/ut/ut0dbg.cc:60
#7 0x000055bcd1f54995 in fts_trx_row_get_new_state (old_state=FTS_DELETE, event=FTS_DELETE) at /data/src/10.4/storage/innobase/fts/fts0fts.cc:2208
#8 0x000055bcd1f54deb in fts_trx_table_add_op (ftt=0x7f67f01b61b0, doc_id=1, state=FTS_DELETE, fts_indexes=0x0) at /data/src/10.4/storage/innobase/fts/fts0fts.cc:2398
#9 0x000055bcd1f54f45 in fts_trx_add_op (trx=0x7f6838e54140, table=0x7f67f000bc30, doc_id=1, state=FTS_DELETE, fts_indexes=0x0) at /data/src/10.4/storage/innobase/fts/fts0fts.cc:2445
#10 0x000055bcd1d12e7b in row_fts_do_update (trx=0x7f6838e54140, table=0x7f67f000bc30, old_doc_id=1, new_doc_id=3) at /data/src/10.4/storage/innobase/row/row0mysql.cc:1701
#11 0x000055bcd1d13049 in row_fts_update_or_delete (prebuilt=0x7f67f0052b40) at /data/src/10.4/storage/innobase/row/row0mysql.cc:1738
#12 0x000055bcd1d1396c in row_update_for_mysql (prebuilt=0x7f67f0052b40) at /data/src/10.4/storage/innobase/row/row0mysql.cc:1921
#13 0x000055bcd1b6c2f4 in ha_innobase::update_row (this=0x7f67f000b3f8, old_row=0x7f67f004a408 "\374\006", new_row=0x7f67f004a3f0 "\374\003") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:8796
#14 0x000055bcd192df2c in handler::ha_update_row (this=0x7f67f000b3f8, old_data=0x7f67f004a408 "\374\006", new_data=0x7f67f004a3f0 "\374\003") at /data/src/10.4/sql/handler.cc:6751
#15 0x000055bcd16dac4f in multi_update::send_data (this=0x7f67f0014a78, not_used_values=...) at /data/src/10.4/sql/sql_update.cc:2527
#16 0x000055bcd16473b1 in end_send (join=0x7f67f0014b50, join_tab=0x7f67f0017408, end_of_records=false) at /data/src/10.4/sql/sql_select.cc:21555
#17 0x000055bcd1644a43 in evaluate_join_record (join=0x7f67f0014b50, join_tab=0x7f67f0017060, error=0) at /data/src/10.4/sql/sql_select.cc:20586
#18 0x000055bcd16444de in sub_select (join=0x7f67f0014b50, join_tab=0x7f67f0017060, end_of_records=false) at /data/src/10.4/sql/sql_select.cc:20405
#19 0x000055bcd1644a43 in evaluate_join_record (join=0x7f67f0014b50, join_tab=0x7f67f0016cb8, error=0) at /data/src/10.4/sql/sql_select.cc:20586
#20 0x000055bcd1644329 in sub_select (join=0x7f67f0014b50, join_tab=0x7f67f0016cb8, end_of_records=false) at /data/src/10.4/sql/sql_select.cc:20366
#21 0x000055bcd16437b8 in do_select (join=0x7f67f0014b50, procedure=0x0) at /data/src/10.4/sql/sql_select.cc:19904
#22 0x000055bcd16186a1 in JOIN::exec_inner (this=0x7f67f0014b50) at /data/src/10.4/sql/sql_select.cc:4459
#23 0x000055bcd16177de in JOIN::exec (this=0x7f67f0014b50) at /data/src/10.4/sql/sql_select.cc:4241
#24 0x000055bcd1618ef3 in mysql_select (thd=0x7f67f0000af0, tables=0x7f67f0013280, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x7f67f0014a78, unit=0x7f67f0004a18, select_lex=0x7f67f0005210) at /data/src/10.4/sql/sql_select.cc:4673
#25 0x000055bcd16d8ab4 in mysql_multi_update (thd=0x7f67f0000af0, table_list=0x7f67f0013280, fields=0x7f67f0005358, values=0x7f67f00058e0, conds=0x0, options=0, handle_duplicates=DUP_ERROR, ignore=false, unit=0x7f67f0004a18, select_lex=0x7f67f0005210, result=0x7f68383baf00) at /data/src/10.4/sql/sql_update.cc:1927
#26 0x000055bcd15c7845 in mysql_execute_command (thd=0x7f67f0000af0) at /data/src/10.4/sql/sql_parse.cc:4445
#27 0x000055bcd15d3509 in mysql_parse (thd=0x7f67f0000af0, rawbuf=0x7f67f0013198 "UPDATE t1 JOIN t2 SET f = a", length=27, parser_state=0x7f68383bb570, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7900
#28 0x000055bcd15bfab9 in dispatch_command (command=COM_QUERY, thd=0x7f67f0000af0, packet=0x7f67f0156a01 "UPDATE t1 JOIN t2 SET f = a", packet_length=27, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1842
#29 0x000055bcd15be25b in do_command (thd=0x7f67f0000af0) at /data/src/10.4/sql/sql_parse.cc:1360
#30 0x000055bcd1745e6a in do_handle_one_connection (connect=0x55bcd56a89f0) at /data/src/10.4/sql/sql_connect.cc:1412
#31 0x000055bcd1745bb9 in handle_one_connection (arg=0x55bcd56a89f0) at /data/src/10.4/sql/sql_connect.cc:1316
#32 0x000055bcd2143291 in pfs_spawn_thread (arg=0x55bcd56c42d0) at /data/src/10.4/storage/perfschema/pfs.cc:1869
#33 0x00007f6840f9b4a4 in start_thread (arg=0x7f68383bc700) at pthread_create.c:456
#34 0x00007f683f0cfd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Reproducible on 10.4 and 10.5, non-debug, debug and asan builds alike.
The test case is not applicable to earlier versions due to the use of the unique blob.

Attachments

Issue Links

is caused by

MDEV-371 Unique indexes for blobs

Closed

relates to

MDEV-23722 InnoDB: Failing assertion: result != FTS_INVALID in fts_trx_row_get_new_state

Closed

MDEV-30028 InnoDB: Failing assertion: result != FTS_INVALID with versioned table

Closed

MDEV-30455 Assertion result != FTS_INVALID in fts_trx_row_get_new_state()

Confirmed

Activity

Ascending order - Click to sort in descending order

Thirunarayanan Balathandayuthapani added a comment - 2020-05-26 09:33

--source include/have_innodb.inc

CREATE TABLE t1 (f TEXT) ENGINE=InnoDB;

INSERT INTO t1(f) VALUES ('foo');

CREATE OR REPLACE TABLE t2 (a VARCHAR(255)) ENGINE=InnoDB;

INSERT INTO t2 VALUES ('foobar'),('qux');

UPDATE t1 JOIN t2 SET f = a;

select * from t1;

foobar

DROP TABLE t1, t2;

--source include/have_innodb.inc

CREATE TABLE t1 (f TEXT unique) ENGINE=InnoDB;

INSERT INTO t1(f) VALUES ('foo');

CREATE OR REPLACE TABLE t2 (a VARCHAR(255)) ENGINE=InnoDB;

INSERT INTO t2 VALUES ('foobar'),('qux');

UPDATE t1 JOIN t2 SET f = a;

select * from t1;

qux

DROP TABLE t1, t2;

I am not sure how update queries behaves differently based on unique blob index. Could be related to ~~MDEV-371~~

Thirunarayanan Balathandayuthapani added a comment - 2020-05-26 09:33 --source include/have_innodb.inc CREATE TABLE t1 (f TEXT) ENGINE=InnoDB; INSERT INTO t1(f) VALUES ( 'foo' ); CREATE OR REPLACE TABLE t2 (a VARCHAR (255)) ENGINE=InnoDB; INSERT INTO t2 VALUES ( 'foobar' ),( 'qux' ); UPDATE t1 JOIN t2 SET f = a; select * from t1; f foobar DROP TABLE t1, t2; --source include/have_innodb.inc CREATE TABLE t1 (f TEXT unique ) ENGINE=InnoDB; INSERT INTO t1(f) VALUES ( 'foo' ); CREATE OR REPLACE TABLE t2 (a VARCHAR (255)) ENGINE=InnoDB; INSERT INTO t2 VALUES ( 'foobar' ),( 'qux' ); UPDATE t1 JOIN t2 SET f = a; select * from t1; f qux DROP TABLE t1, t2; I am not sure how update queries behaves differently based on unique blob index. Could be related to MDEV-371

Elena Stepanova added a comment - 2022-01-09 19:52

The commit below made the failure (at least with this test case) disappear in 10.5.

commit d543363f25f96a6cf1779904ea483c59effa1796

Author: Nikita Malyavin

Date:   Thu Sep 24 21:59:28 2020 +1000

    MDEV-22714 Assertion failed upon multi-update on table WITHOUT OVERLAPS

I am not sure whether it actually fixed the underlying problem or just hid it, In the latter case we might need a new test case for 10.5+.
However, on 10.4, the originally reported one still causes the failure

Elena Stepanova added a comment - 2022-01-09 19:52 The commit below made the failure (at least with this test case) disappear in 10.5. commit d543363f25f96a6cf1779904ea483c59effa1796 Author: Nikita Malyavin Date: Thu Sep 24 21:59:28 2020 +1000 MDEV-22714 Assertion failed upon multi-update on table WITHOUT OVERLAPS I am not sure whether it actually fixed the underlying problem or just hid it, In the latter case we might need a new test case for 10.5+. However, on 10.4, the originally reported one still causes the failure

Elena Stepanova added a comment - 2022-02-14 22:05

Here is a test case which reproduces the same assertion failure on all 10.4+. It doesn't do multi-update, so I'm not absolutely sure it's the same problem, but since they don't think there is much point in creating a new JIRA, I'll just put it here for now.

--source include/have_innodb.inc

CREATE TABLE t1 (

  FTS_DOC_ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,

  f INT,

  b TEXT,

  UNIQUE(b),

  FULLTEXT (b),

  UNIQUE (f)

) ENGINE=InnoDB;

INSERT INTO t1 (f,b) VALUES (10,'bar'),(11,NULL);

ALTER TABLE t1 FORCE;

START TRANSACTION;

REPLACE INTO t1 SELECT * FROM t1;

REPLACE INTO t1 SELECT * FROM t1;

# Cleanup

DROP TABLE t1;

10.7 c62720d0
2022-02-15 00:04:46 0x7f1545518700 InnoDB: Assertion failure in file /data/src/10.7/storage/innobase/fts/fts0fts.cc line 2142
InnoDB: Failing assertion: result != FTS_INVALID

#6 0x000055c82fce320b in ut_dbg_assertion_failed (expr=0x55c8304596ac "result != FTS_INVALID", file=0x55c830458a40 "/data/src/10.7/storage/innobase/fts/fts0fts.cc", line=2142) at /data/src/10.7/storage/innobase/ut/ut0dbg.cc:60
#7 0x000055c82fe14ea6 in fts_trx_row_get_new_state (old_state=FTS_INSERT, event=FTS_INSERT) at /data/src/10.7/storage/innobase/fts/fts0fts.cc:2142
#8 0x000055c82fe152ea in fts_trx_table_add_op (ftt=0x7f14f0107e58, doc_id=2, state=FTS_INSERT, fts_indexes=0x0) at /data/src/10.7/storage/innobase/fts/fts0fts.cc:2332
#9 0x000055c82fe1545f in fts_trx_add_op (trx=0x7f15467c21e0, table=0x7f14f007a7b8, doc_id=2, state=FTS_INSERT, fts_indexes=0x0) at /data/src/10.7/storage/innobase/fts/fts0fts.cc:2379
#10 0x000055c82fc2ba53 in row_insert_for_mysql (mysql_rec=0x7f14f0b34bf8 "\376\002", prebuilt=0x7f14f0116be8, ins_mode=ROW_INS_NORMAL) at /data/src/10.7/storage/innobase/row/row0mysql.cc:1392
#11 0x000055c82fa6c087 in ha_innobase::write_row (this=0x7f14f0232cc0, record=0x7f14f0b34bf8 "\376\002") at /data/src/10.7/storage/innobase/handler/ha_innodb.cc:7878
#12 0x000055c82f69c59b in handler::ha_write_row (this=0x7f14f0232cc0, buf=0x7f14f0b34bf8 "\376\002") at /data/src/10.7/sql/handler.cc:7519
#13 0x000055c82f290938 in write_record (thd=0x7f14f0000db8, table=0x7f14f0213ea8, info=0x7f14f0017178, sink=0x0) at /data/src/10.7/sql/sql_insert.cc:1833
#14 0x000055c82f297701 in select_insert::send_data (this=0x7f14f0017128, values=...) at /data/src/10.7/sql/sql_insert.cc:4120
#15 0x000055c82f399be3 in select_result_sink::send_data_with_check (this=0x7f14f0017128, items=..., u=0x7f14f00051c0, sent=1) at /data/src/10.7/sql/sql_class.h:5605
#16 0x000055c82f37ff08 in end_send (join=0x7f14f00171e8, join_tab=0x7f14f0103bc0, end_of_records=false) at /data/src/10.7/sql/sql_select.cc:22335
#17 0x000055c82f37d412 in evaluate_join_record (join=0x7f14f00171e8, join_tab=0x7f14f0103810, error=0) at /data/src/10.7/sql/sql_select.cc:21329
#18 0x000055c82f394182 in AGGR_OP::end_send (this=0x7f14f00192e0) at /data/src/10.7/sql/sql_select.cc:29551
#19 0x000055c82f37c67e in sub_select_postjoin_aggr (join=0x7f14f00171e8, join_tab=0x7f14f0103810, end_of_records=true) at /data/src/10.7/sql/sql_select.cc:20809
#20 0x000055c82f37c9df in sub_select (join=0x7f14f00171e8, join_tab=0x7f14f0103460, end_of_records=true) at /data/src/10.7/sql/sql_select.cc:21044
#21 0x000055c82f37c162 in do_select (join=0x7f14f00171e8, procedure=0x0) at /data/src/10.7/sql/sql_select.cc:20646
#22 0x000055c82f34f77c in JOIN::exec_inner (this=0x7f14f00171e8) at /data/src/10.7/sql/sql_select.cc:4751
#23 0x000055c82f34e7f1 in JOIN::exec (this=0x7f14f00171e8) at /data/src/10.7/sql/sql_select.cc:4529
#24 0x000055c82f350122 in mysql_select (thd=0x7f14f0000db8, tables=0x7f14f00161a8, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2202245794560, result=0x7f14f0017128, unit=0x7f14f00051c0, select_lex=0x7f14f0015bd0) at /data/src/10.7/sql/sql_select.cc:5009
#25 0x000055c82f33f41b in handle_select (thd=0x7f14f0000db8, lex=0x7f14f00050e8, result=0x7f14f0017128, setup_tables_done_option=1073741824) at /data/src/10.7/sql/sql_select.cc:545
#26 0x000055c82f2e2647 in mysql_execute_command (thd=0x7f14f0000db8, is_called_from_prepared_stmt=false) at /data/src/10.7/sql/sql_parse.cc:4708
#27 0x000055c82f2ed593 in mysql_parse (thd=0x7f14f0000db8, rawbuf=0x7f14f0015400 "REPLACE INTO t1 SELECT * FROM t1", length=32, parser_state=0x7f1545517500) at /data/src/10.7/sql/sql_parse.cc:8027
#28 0x000055c82f2d9bf8 in dispatch_command (command=COM_QUERY, thd=0x7f14f0000db8, packet=0x7f14f000b989 "REPLACE INTO t1 SELECT * FROM t1", packet_length=32, blocking=true) at /data/src/10.7/sql/sql_parse.cc:1894
#29 0x000055c82f2d85b2 in do_command (thd=0x7f14f0000db8, blocking=true) at /data/src/10.7/sql/sql_parse.cc:1402
#30 0x000055c82f4a86e8 in do_handle_one_connection (connect=0x55c833998978, put_in_cache=true) at /data/src/10.7/sql/sql_connect.cc:1418
#31 0x000055c82f4a8387 in handle_one_connection (arg=0x55c83399b118) at /data/src/10.7/sql/sql_connect.cc:1312
#32 0x000055c82f99102e in pfs_spawn_thread (arg=0x55c8339984e8) at /data/src/10.7/storage/perfschema/pfs.cc:2201
#33 0x00007f154c631ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
#34 0x00007f154c230def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Elena Stepanova added a comment - 2022-02-14 22:05 Here is a test case which reproduces the same assertion failure on all 10.4+. It doesn't do multi-update, so I'm not absolutely sure it's the same problem, but since they don't think there is much point in creating a new JIRA, I'll just put it here for now. --source include/have_innodb.inc CREATE TABLE t1 ( FTS_DOC_ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , f INT , b TEXT, UNIQUE (b), FULLTEXT (b), UNIQUE (f) ) ENGINE=InnoDB; INSERT INTO t1 (f,b) VALUES (10, 'bar' ),(11, NULL ); ALTER TABLE t1 FORCE ; START TRANSACTION ; REPLACE INTO t1 SELECT * FROM t1; REPLACE INTO t1 SELECT * FROM t1; # Cleanup DROP TABLE t1; 10.7 c62720d0 2022-02-15 00:04:46 0x7f1545518700 InnoDB: Assertion failure in file /data/src/10.7/storage/innobase/fts/fts0fts.cc line 2142 InnoDB: Failing assertion: result != FTS_INVALID #6 0x000055c82fce320b in ut_dbg_assertion_failed (expr=0x55c8304596ac "result != FTS_INVALID", file=0x55c830458a40 "/data/src/10.7/storage/innobase/fts/fts0fts.cc", line=2142) at /data/src/10.7/storage/innobase/ut/ut0dbg.cc:60 #7 0x000055c82fe14ea6 in fts_trx_row_get_new_state (old_state=FTS_INSERT, event=FTS_INSERT) at /data/src/10.7/storage/innobase/fts/fts0fts.cc:2142 #8 0x000055c82fe152ea in fts_trx_table_add_op (ftt=0x7f14f0107e58, doc_id=2, state=FTS_INSERT, fts_indexes=0x0) at /data/src/10.7/storage/innobase/fts/fts0fts.cc:2332 #9 0x000055c82fe1545f in fts_trx_add_op (trx=0x7f15467c21e0, table=0x7f14f007a7b8, doc_id=2, state=FTS_INSERT, fts_indexes=0x0) at /data/src/10.7/storage/innobase/fts/fts0fts.cc:2379 #10 0x000055c82fc2ba53 in row_insert_for_mysql (mysql_rec=0x7f14f0b34bf8 "\376\002", prebuilt=0x7f14f0116be8, ins_mode=ROW_INS_NORMAL) at /data/src/10.7/storage/innobase/row/row0mysql.cc:1392 #11 0x000055c82fa6c087 in ha_innobase::write_row (this=0x7f14f0232cc0, record=0x7f14f0b34bf8 "\376\002") at /data/src/10.7/storage/innobase/handler/ha_innodb.cc:7878 #12 0x000055c82f69c59b in handler::ha_write_row (this=0x7f14f0232cc0, buf=0x7f14f0b34bf8 "\376\002") at /data/src/10.7/sql/handler.cc:7519 #13 0x000055c82f290938 in write_record (thd=0x7f14f0000db8, table=0x7f14f0213ea8, info=0x7f14f0017178, sink=0x0) at /data/src/10.7/sql/sql_insert.cc:1833 #14 0x000055c82f297701 in select_insert::send_data (this=0x7f14f0017128, values=...) at /data/src/10.7/sql/sql_insert.cc:4120 #15 0x000055c82f399be3 in select_result_sink::send_data_with_check (this=0x7f14f0017128, items=..., u=0x7f14f00051c0, sent=1) at /data/src/10.7/sql/sql_class.h:5605 #16 0x000055c82f37ff08 in end_send (join=0x7f14f00171e8, join_tab=0x7f14f0103bc0, end_of_records=false) at /data/src/10.7/sql/sql_select.cc:22335 #17 0x000055c82f37d412 in evaluate_join_record (join=0x7f14f00171e8, join_tab=0x7f14f0103810, error=0) at /data/src/10.7/sql/sql_select.cc:21329 #18 0x000055c82f394182 in AGGR_OP::end_send (this=0x7f14f00192e0) at /data/src/10.7/sql/sql_select.cc:29551 #19 0x000055c82f37c67e in sub_select_postjoin_aggr (join=0x7f14f00171e8, join_tab=0x7f14f0103810, end_of_records=true) at /data/src/10.7/sql/sql_select.cc:20809 #20 0x000055c82f37c9df in sub_select (join=0x7f14f00171e8, join_tab=0x7f14f0103460, end_of_records=true) at /data/src/10.7/sql/sql_select.cc:21044 #21 0x000055c82f37c162 in do_select (join=0x7f14f00171e8, procedure=0x0) at /data/src/10.7/sql/sql_select.cc:20646 #22 0x000055c82f34f77c in JOIN::exec_inner (this=0x7f14f00171e8) at /data/src/10.7/sql/sql_select.cc:4751 #23 0x000055c82f34e7f1 in JOIN::exec (this=0x7f14f00171e8) at /data/src/10.7/sql/sql_select.cc:4529 #24 0x000055c82f350122 in mysql_select (thd=0x7f14f0000db8, tables=0x7f14f00161a8, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2202245794560, result=0x7f14f0017128, unit=0x7f14f00051c0, select_lex=0x7f14f0015bd0) at /data/src/10.7/sql/sql_select.cc:5009 #25 0x000055c82f33f41b in handle_select (thd=0x7f14f0000db8, lex=0x7f14f00050e8, result=0x7f14f0017128, setup_tables_done_option=1073741824) at /data/src/10.7/sql/sql_select.cc:545 #26 0x000055c82f2e2647 in mysql_execute_command (thd=0x7f14f0000db8, is_called_from_prepared_stmt=false) at /data/src/10.7/sql/sql_parse.cc:4708 #27 0x000055c82f2ed593 in mysql_parse (thd=0x7f14f0000db8, rawbuf=0x7f14f0015400 "REPLACE INTO t1 SELECT * FROM t1", length=32, parser_state=0x7f1545517500) at /data/src/10.7/sql/sql_parse.cc:8027 #28 0x000055c82f2d9bf8 in dispatch_command (command=COM_QUERY, thd=0x7f14f0000db8, packet=0x7f14f000b989 "REPLACE INTO t1 SELECT * FROM t1", packet_length=32, blocking=true) at /data/src/10.7/sql/sql_parse.cc:1894 #29 0x000055c82f2d85b2 in do_command (thd=0x7f14f0000db8, blocking=true) at /data/src/10.7/sql/sql_parse.cc:1402 #30 0x000055c82f4a86e8 in do_handle_one_connection (connect=0x55c833998978, put_in_cache=true) at /data/src/10.7/sql/sql_connect.cc:1418 #31 0x000055c82f4a8387 in handle_one_connection (arg=0x55c83399b118) at /data/src/10.7/sql/sql_connect.cc:1312 #32 0x000055c82f99102e in pfs_spawn_thread (arg=0x55c8339984e8) at /data/src/10.7/storage/perfschema/pfs.cc:2201 #33 0x00007f154c631ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477 #34 0x00007f154c230def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Aleksey Midenkov added a comment - 2024-12-17 16:30

Does not repro on 10.5.28 7b0f59da43b:

CREATE OR REPLACE TABLE t1 (f TEXT UNIQUE, FULLTEXT(f)) ENGINE=InnoDB;

INSERT INTO t1 VALUES ('foo');

CREATE OR REPLACE TABLE t2 (a VARCHAR(255)) ENGINE=InnoDB;

INSERT INTO t2 VALUES ('foobar'),('qux');

UPDATE t1 JOIN t2 SET f = a;

DROP TABLE t1, t2;

bug/hi.b                                 [ pass ]    138

Aleksey Midenkov added a comment - 2024-12-17 16:30 Does not repro on 10.5.28 7b0f59da43b: CREATE OR REPLACE TABLE t1 (f TEXT UNIQUE, FULLTEXT(f)) ENGINE=InnoDB; INSERT INTO t1 VALUES ('foo'); CREATE OR REPLACE TABLE t2 (a VARCHAR(255)) ENGINE=InnoDB; INSERT INTO t2 VALUES ('foobar'),('qux'); UPDATE t1 JOIN t2 SET f = a; DROP TABLE t1, t2; bug/hi.b [ pass ] 138

Aleksey Midenkov added a comment - 2024-12-17 16:30

Does not repro on 10.5.28 7b0f59da43b:

CREATE OR REPLACE TABLE t1 (f TEXT UNIQUE, FULLTEXT(f)) ENGINE=InnoDB;

INSERT INTO t1 VALUES ('foo');

CREATE OR REPLACE TABLE t2 (a VARCHAR(255)) ENGINE=InnoDB;

INSERT INTO t2 VALUES ('foobar'),('qux');

UPDATE t1 JOIN t2 SET f = a;

DROP TABLE t1, t2;

bug/hi.b                                 [ pass ]    138

Aleksey Midenkov added a comment - 2024-12-17 16:30 Does not repro on 10.5.28 7b0f59da43b: CREATE OR REPLACE TABLE t1 (f TEXT UNIQUE, FULLTEXT(f)) ENGINE=InnoDB; INSERT INTO t1 VALUES ('foo'); CREATE OR REPLACE TABLE t2 (a VARCHAR(255)) ENGINE=InnoDB; INSERT INTO t2 VALUES ('foobar'),('qux'); UPDATE t1 JOIN t2 SET f = a; DROP TABLE t1, t2; bug/hi.b [ pass ] 138

MariaDB Server

InnoDB: Failing assertion: result != FTS_INVALID upon DML on table with unique blob

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration