[MDEV-18147] [Draft] Assertion `templ->mysql_col_len >= len' failed in row_sel_field_store_in_mysql_format_func Created: 2019-01-06  Updated: 2019-11-05  Resolved: 2019-11-05

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-20940 Data corruption after partition maint... Confirmed
Relates
relates to MDEV-18366 Crash on SELECT on a table that conta... Closed
relates to MDEV-18217 [Draft] [ERROR] InnoDB: Apparent cor... Closed

 Description   

https://travis-ci.org/elenst/travis-tests/jobs/475398155

10.4 2465d3e00b

mysqld: /data/src/10.4/storage/innobase/row/row0sel.cc:2814: void row_sel_field_store_in_mysql_format_func(byte*, const mysql_row_templ_t*, const dict_index_t*, ulint, const byte*, ulint): Assertion `templ->mysql_col_len >= len' failed.
190106 13:36:28 [ERROR] mysqld got signal 6 ;
 
#7  0x00007f563b340ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x00005580babca3c4 in row_sel_field_store_in_mysql_format_func (dest=0x7f55b43b6393 "", templ=0x7f55b4310a00, index=0x7f55a0355378, field_no=36, data=0x7f561d7e160c "", len=192) at /data/src/10.4/storage/innobase/row/row0sel.cc:2814
#9  0x00005580babcafce in row_sel_store_mysql_field_func (mysql_rec=0x7f55b43b6318 "\251\311\370\377\377\377\377\377", prebuilt=0x7f55b4177c58, rec=0x7f561d7e0092 "\200", index=0x7f55a0355378, offsets=0x7f56242509e0, field_no=36, templ=0x7f55b4310a00) at /data/src/10.4/storage/innobase/row/row0sel.cc:3030
#10 0x00005580babcb531 in row_sel_store_mysql_rec (mysql_rec=0x7f55b43b6318 "\251\311\370\377\377\377\377\377", prebuilt=0x7f55b4177c58, rec=0x7f561d7e0092 "\200", vrow=0x0, rec_clust=false, index=0x7f55a0355378, offsets=0x7f56242509e0) at /data/src/10.4/storage/innobase/row/row0sel.cc:3160
#11 0x00005580babd1151 in row_search_mvcc (buf=0x7f55b43b6318 "\251\311\370\377\377\377\377\377", mode=PAGE_CUR_G, prebuilt=0x7f55b4177c58, match_mode=0, direction=0) at /data/src/10.4/storage/innobase/row/row0sel.cc:5444
#12 0x00005580baa302ef in ha_innobase::index_read (this=0x7f55b415d778, buf=0x7f55b43b6318 "\251\311\370\377\377\377\377\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9285
#13 0x00005580baa31146 in ha_innobase::index_first (this=0x7f55b415d778, buf=0x7f55b43b6318 "\251\311\370\377\377\377\377\377") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9662
#14 0x00005580baa31351 in ha_innobase::rnd_next (this=0x7f55b415d778, buf=0x7f55b43b6318 "\251\311\370\377\377\377\377\377") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9755
#15 0x00005580ba6fe445 in handler::ha_rnd_next (this=0x7f55b415d778, buf=0x7f55b43b6318 "\251\311\370\377\377\377\377\377") at /data/src/10.4/sql/handler.cc:2800
#16 0x00005580ba88797b in rr_sequential (info=0x7f56242515f0) at /data/src/10.4/sql/records.cc:481
#17 0x00005580ba3458f7 in READ_RECORD::read_record (this=0x7f56242515f0) at /data/src/10.4/sql/records.h:73
#18 0x00005580ba8a5719 in mysql_delete (thd=0x7f55b4000b00, table_list=0x7f55b4013d78, conds=0x7f55b4014580, order_list=0x7f55b40053a8, limit=1, options=0, result=0x0) at /data/src/10.4/sql/sql_delete.cc:731
#19 0x00005580ba3eb226 in mysql_execute_command (thd=0x7f55b4000b00) at /data/src/10.4/sql/sql_parse.cc:4928
#20 0x00005580ba3f5244 in mysql_parse (thd=0x7f55b4000b00, rawbuf=0x7f55b4013b88 "DELETE FROM `table100_innodb_int_autoinc` WHERE `col_int` < 8 LIMIT 1  /* QNO 2005 CON_ID 16 */", length=95, parser_state=0x7f5624252650, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8104
#21 0x00005580ba3e246e in dispatch_command (command=COM_QUERY, thd=0x7f55b4000b00, packet=0x7f55b400b321 " DELETE FROM `table100_innodb_int_autoinc` WHERE `col_int` < 8 LIMIT 1  /* QNO 2005 CON_ID 16 */ ", packet_length=97, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1851
#22 0x00005580ba3e0e92 in do_command (thd=0x7f55b4000b00) at /data/src/10.4/sql/sql_parse.cc:1396
#23 0x00005580ba54d0ba in do_handle_one_connection (connect=0x5580bebfcd30) at /data/src/10.4/sql/sql_connect.cc:1402
#24 0x00005580ba54ce3e in handle_one_connection (arg=0x5580bebfcd30) at /data/src/10.4/sql/sql_connect.cc:1308
#25 0x00007f563cdfc494 in start_thread (arg=0x7f5624253700) at pthread_create.c:333
#26 0x00007f563b3fd93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
 
Query (0x7f55b4013b88): DELETE FROM `table100_innodb_int_autoinc` WHERE `col_int` < 8 LIMIT 1  /* QNO 2005 CON_ID 16 */
Connection ID (thread ID): 16
Status: NOT_KILLED

Reproducible rather easily with

github.com/MariaDB/randgen elenst-dev 4ca4216dbdd, mariadb-toolbox master dc4259a9cb

perl ./runall-new.pl --basedir=/home/travis/server/10.4 --vardir=/home/travis/logs/vardir4 --duration=350 --threads=6 --seed=1546700721 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/userstat.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/locks-10.4-extra.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/replication/replication.yy --gendata=conf/replication/replication-5.1.zz  --transformers=ExecuteAsIntersect,ExecuteAsExcept,ExecuteAsCTE,ExecuteAsExecuteImmediate,ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView --redefine=conf/mariadb/versioning.yy --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff

However, when I try to convert it to MTR, it starts failing with MDEV-18146 instead.



 Comments   
Comment by Elena Stepanova [ 2019-11-05 ]

Closing as a duplicate of MDEV-20940, because it has a test case.

Generated at Thu Feb 08 08:41:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.