Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL)
-
None
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
- relates to
-
MDEV-17459 Allow instant ALTER TABLE even if FULLTEXT INDEX exists
- Stalled