Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (f1 TEXT, f2 TEXT, FULLTEXT KEY (f2)) ENGINE=InnoDB DEFAULT CHARSET UTF8; |
INSERT INTO t1 (f1) VALUES ('foo'),('bar'); |
DELETE FROM t1 LIMIT 1; |
ALTER TABLE t1 ADD FULLTEXT KEY (f1); |
SET @optimize_fulltext.save= @@innodb_optimize_fulltext_only; |
SET GLOBAL innodb_optimize_fulltext_only= 1; |
OPTIMIZE TABLE t1; |
|
# Cleanup
|
DROP TABLE t1; |
SET GLOBAL innodb_optimize_fulltext_only= @optimize_fulltext.save; |
10.2 5ec9b88e111 |
mysqld: /data/src/10.2/storage/innobase/trx/trx0rec.cc:956: ulint trx_undo_page_report_modify(ib_page_t*, trx_t*, dict_index_t*, const rec_t*, const ulint*, const upd_t*, ulint, const dtuple_t*, mtr_t*): Assertion `memcmp(field, field_ref_zero, 7)' failed.
|
181207 1:12:38 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f2d2253cee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x0000564dca4c8fcc in trx_undo_page_report_modify (undo_page=0x7f2d17e00000 "", trx=0x7f2d1c4af278, index=0x7f2cc8059558, rec=0x7f2d17da8080 "bar", offsets=0x7f2d1c20f8a0, update=0x0, cmpl_info=0, row=0x7f2cc8133458, mtr=0x7f2d1c20eda0) at /data/src/10.2/storage/innobase/trx/trx0rec.cc:956
|
#9 0x0000564dca4cc321 in trx_undo_report_row_operation (thr=0x7f2cc80afc78, index=0x7f2cc8059558, clust_entry=0x7f2cc8133458, update=0x0, cmpl_info=0, rec=0x7f2d17da8080 "bar", offsets=0x7f2d1c20f8a0, roll_ptr=0x7f2d1c20f338) at /data/src/10.2/storage/innobase/trx/trx0rec.cc:2103
|
#10 0x0000564dca52406a in btr_cur_del_mark_set_clust_rec (block=0x7f2d177df690, rec=0x7f2d17da8080 "bar", index=0x7f2cc8059558, offsets=0x7f2d1c20f8a0, thr=0x7f2cc80afc78, entry=0x7f2cc8133458, mtr=0x7f2d1c20fbc0) at /data/src/10.2/storage/innobase/btr/btr0cur.cc:4832
|
#11 0x0000564dca47b37e in row_upd_del_mark_clust_rec (node=0x7f2cc80af408, index=0x7f2cc8059558, offsets=0x7f2d1c20f8a0, thr=0x7f2cc80afc78, referenced=0, foreign=false, mtr=0x7f2d1c20fbc0) at /data/src/10.2/storage/innobase/row/row0upd.cc:2984
|
#12 0x0000564dca47bc1f in row_upd_clust_step (node=0x7f2cc80af408, thr=0x7f2cc80afc78) at /data/src/10.2/storage/innobase/row/row0upd.cc:3158
|
#13 0x0000564dca47c100 in row_upd (node=0x7f2cc80af408, thr=0x7f2cc80afc78) at /data/src/10.2/storage/innobase/row/row0upd.cc:3279
|
#14 0x0000564dca47c5d9 in row_upd_step (thr=0x7f2cc80afc78) at /data/src/10.2/storage/innobase/row/row0upd.cc:3425
|
#15 0x0000564dca3d16b8 in que_thr_step (thr=0x7f2cc80afc78) at /data/src/10.2/storage/innobase/que/que0que.cc:1027
|
#16 0x0000564dca3d1993 in que_run_threads_low (thr=0x7f2cc80afc78) at /data/src/10.2/storage/innobase/que/que0que.cc:1107
|
#17 0x0000564dca3d1b3c in que_run_threads (thr=0x7f2cc80afc78) at /data/src/10.2/storage/innobase/que/que0que.cc:1147
|
#18 0x0000564dca62fcb1 in fts_eval_sql (trx=0x7f2d1c4af278, graph=0x7f2cc80afba0) at /data/src/10.2/storage/innobase/fts/fts0sql.cc:240
|
#19 0x0000564dca621cea in fts_optimize_write_word (trx=0x7f2d1c4af278, fts_table=0x7f2cc805fd00, word=0x7f2cc8041158, nodes=0x7f2cc8063228) at /data/src/10.2/storage/innobase/fts/fts0opt.cc:1471
|
#20 0x0000564dca622152 in fts_optimize_compact (optim=0x7f2cc805fce8, index=0x7f2cc8055358, start_time=1544137958) at /data/src/10.2/storage/innobase/fts/fts0opt.cc:1561
|
#21 0x0000564dca62277a in fts_optimize_words (optim=0x7f2cc805fce8, index=0x7f2cc8055358, word=0x7f2d1c2109b0) at /data/src/10.2/storage/innobase/fts/fts0opt.cc:1815
|
#22 0x0000564dca622f16 in fts_optimize_index (optim=0x7f2cc805fce8, index=0x7f2cc8055358) at /data/src/10.2/storage/innobase/fts/fts0opt.cc:2000
|
#23 0x0000564dca623868 in fts_optimize_indexes (optim=0x7f2cc805fce8) at /data/src/10.2/storage/innobase/fts/fts0opt.cc:2304
|
#24 0x0000564dca623bd1 in fts_optimize_table (table=0x7f2cc809a918) at /data/src/10.2/storage/innobase/fts/fts0opt.cc:2477
|
#25 0x0000564dca2f37a8 in ha_innobase::optimize (this=0x7f2cc8046fc8, thd=0x7f2cc8000b00, check_opt=0x7f2cc80055f0) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:14630
|
#26 0x0000564dc9fd84d1 in handler::ha_optimize (this=0x7f2cc8046fc8, thd=0x7f2cc8000b00, check_opt=0x7f2cc80055f0) at /data/src/10.2/sql/handler.cc:4115
|
#27 0x0000564dc9eb401f in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7f2cc8000b00, tables=0x7f2cc8012518, check_opt=0x7f2cc80055f0, operator_name=0x564dca82dfc8 "optimize", lock_type=TL_WRITE, org_open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x564dc9fd8450 <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /data/src/10.2/sql/sql_admin.cc:798
|
#28 0x0000564dc9eb63bc in Sql_cmd_optimize_table::execute (this=0x7f2cc8012b30, thd=0x7f2cc8000b00) at /data/src/10.2/sql/sql_admin.cc:1370
|
#29 0x0000564dc9d5e35b in mysql_execute_command (thd=0x7f2cc8000b00) at /data/src/10.2/sql/sql_parse.cc:6226
|
#30 0x0000564dc9d631bd in mysql_parse (thd=0x7f2cc8000b00, rawbuf=0x7f2cc8012448 "OPTIMIZE TABLE t1", length=17, parser_state=0x7f2d1c212200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:8013
|
#31 0x0000564dc9d50af5 in dispatch_command (command=COM_QUERY, thd=0x7f2cc8000b00, packet=0x7f2cc80960c1 "", packet_length=17, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824
|
#32 0x0000564dc9d4f458 in do_command (thd=0x7f2cc8000b00) at /data/src/10.2/sql/sql_parse.cc:1378
|
#33 0x0000564dc9ea1bc9 in do_handle_one_connection (connect=0x564dcde4ee00) at /data/src/10.2/sql/sql_connect.cc:1335
|
#34 0x0000564dc9ea1956 in handle_one_connection (arg=0x564dcde4ee00) at /data/src/10.2/sql/sql_connect.cc:1241
|
#35 0x0000564dca2c75ee in pfs_spawn_thread (arg=0x564dcdd9a2b0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
|
#36 0x00007f2d23ff8494 in start_thread (arg=0x7f2d1c213700) at pthread_create.c:333
|
#37 0x00007f2d225f993f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Not reproducible on 10.1.