Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18147

[Draft] Assertion `templ->mysql_col_len >= len' failed in row_sel_field_store_in_mysql_format_func

    XMLWordPrintable

Details

    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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.