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

ulint rec_get_converted_size_comp_prefix_low(const dict_index_t*, const dfield_t*, ulint, ulint*, rec_comp_status_t, bool): Assertion `len <= col->len || ((col->mtype) == 5 || (col->mtype) == 14) || (col->len == 0 && col->mtype == 1)' failed

    XMLWordPrintable

Details

    Description

      The problem was found during RQG testing and affects
      		 
      10.4 39a8caa51c115e7750c2355374413056932665eb 2019-01-07
      		 
      10.3 d27bea9e9a8a89861870980f63a1b350e31da302 2019-01-07
      		 
      No replay of the probem on actual 10.2.
      		 
       
      		 
      [21595] | Version: '10.3.13-MariaDB-debug-log'  socket: ...
      		 
      [21595] | mysqld: storage/innobase/rem/rem0rec.cc:1131: ulint rec_get_converted_size_comp_prefix_low(const dict_index_t*, const dfield_t*, ulint, ulint*, rec_comp_status_t, bool): Assertion `len <= col->len || ((col->mtype) == 5 || (col->mtype) == 14) || (col->len == 0 && col->mtype == 1)' failed.
      		 
      [21595] | 190108 10:59:55 [ERROR] mysqld got signal 6 ;
      		 
      ...
      		 
      Query (0x7ff068012d40): INSERT INTO t1 (col2,col_int ) VALUES /* 1 */ (1,1), (1,1)  /* E_R Thread6 QNO 26 CON_ID 20 */
      		 
      [21595] | Connection ID (thread ID): 20
      		 
       [21595] | Status: NOT_KILLED
      		 
       
      		 
      #3  <signal handler called>
      		 
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
      		 
      #5  0x00007ff1168bbf5d in __GI_abort () at abort.c:90
      		 
      #6  0x00007ff1168b1f17 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5566b4c2afb8 "len <= col->len || ((col->mtype) == 5 || (col->mtype) == 14) || (col->len == 0 && col->mtype == 1)", file=file@entry=0x5566b4c2a4c0 "storage/innobase/rem/rem0rec.cc", line=line@entry=1131, function=function@entry=0x5566b4c2ca80 <rec_get_converted_size_comp_prefix_low(dict_index_t const*, dfield_t const*, unsigned long, unsigned long*, rec_comp_status_t, bool)::__PRETTY_FUNCTION__> "ulint rec_get_converted_size_comp_prefix_low(const dict_index_t*, const dfield_t*, ulint, ulint*, rec_comp_status_t, bool)") at assert.c:92
      		 
      #7  0x00007ff1168b1fc2 in __GI___assert_fail (assertion=0x5566b4c2afb8 "len <= col->len || ((col->mtype) == 5 || (col->mtype) == 14) || (col->len == 0 && col->mtype == 1)", file=0x5566b4c2a4c0 "storage/innobase/rem/rem0rec.cc", line=1131, function=0x5566b4c2ca80 <rec_get_converted_size_comp_prefix_low(dict_index_t const*, dfield_t const*, unsigned long, unsigned long*, rec_comp_status_t, bool)::__PRETTY_FUNCTION__> "ulint rec_get_converted_size_comp_prefix_low(const dict_index_t*, const dfield_t*, ulint, ulint*, rec_comp_status_t, bool)") at assert.c:101
      		 
      #8  0x00005566b449c6fd in rec_get_converted_size_comp_prefix_low (index=0x7ff07002f398, fields=0x7ff06801dec0, n_fields=3, extra=0x7ff10cb088d0, status=REC_STATUS_ORDINARY, temp=true) at storage/innobase/rem/rem0rec.cc:1131
      		 
      #9  0x00005566b449e3af in rec_get_converted_size_temp (index=0x7ff07002f398, fields=0x7ff06801dec0, n_fields=3, extra=0x7ff10cb088d0, status=REC_STATUS_ORDINARY) at storage/innobase/rem/rem0rec.cc:1676
      		 
      #10 0x00005566b44f8e85 in row_log_table_delete (rec=0x7ff0f44e00ae "", index=0x7ff070025548, offsets=0x7ff068020058, sys=0x0) at storage/innobase/row/row0log.cc:742
      		 
      #11 0x00005566b4736f70 in row_undo_ins_remove_clust_rec (node=0x7ff068021ff8) at storage/innobase/row/row0uins.cc:120
      		 
      #12 0x00005566b47386d1 in row_undo_ins (node=0x7ff068021ff8, thr=0x7ff06801e478) at storage/innobase/row/row0uins.cc:612
      		 
      #13 0x00005566b453adf8 in row_undo (node=0x7ff068021ff8, thr=0x7ff06801e478) at storage/innobase/row/row0undo.cc:301
      		 
      #14 0x00005566b453b05a in row_undo_step (thr=0x7ff06801e478) at storage/innobase/row/row0undo.cc:360
      		 
      #15 0x00005566b448e97f in que_thr_step (thr=0x7ff06801e478) at storage/innobase/que/que0que.cc:1040
      		 
      #16 0x00005566b448ebd3 in que_run_threads_low (thr=0x7ff06801e478) at storage/innobase/que/que0que.cc:1104
      		 
      #17 0x00005566b448edc5 in que_run_threads (thr=0x7ff06801e478) at storage/innobase/que/que0que.cc:1144
      		 
      #18 0x00005566b459a162 in trx_rollback_to_savepoint_low (trx=0x7ff10cd16378, savept=0x7ff10cb09600) at storage/innobase/trx/trx0roll.cc:141
      		 
      #19 0x00005566b459a517 in trx_rollback_to_savepoint (trx=0x7ff10cd16378, savept=0x7ff10cb09600) at storage/innobase/trx/trx0roll.cc:189
      		 
      #20 0x00005566b44e6e99 in row_mysql_handle_errors (new_err=0x7ff10cb095f8, trx=0x7ff10cd16378, thr=0x7ff068021730, savept=0x7ff10cb09600) at storage/innobase/row/row0mysql.cc:735
      		 
      #21 0x00005566b44e8d54 in row_insert_for_mysql (mysql_rec=0x7ff06801c518 "\371\001", prebuilt=0x7ff068020f68, ins_mode=ROW_INS_NORMAL) at storage/innobase/row/row0mysql.cc:1472
      		 
      #22 0x00005566b438c034 in ha_innobase::write_row (this=0x7ff0680207c0, record=0x7ff06801c518 "\371\001") at storage/innobase/handler/ha_innodb.cc:8051
      		 
      #23 0x00005566b4186903 in handler::ha_write_row (this=0x7ff0680207c0, buf=0x7ff06801c518 "\371\001") at sql/handler.cc:6237
      		 
      #24 0x00005566b3e46709 in write_record (thd=0x7ff068000ce8, table=0x7ff06801f098, info=0x7ff10cb09b90) at sql/sql_insert.cc:2020
      		 
      #25 0x00005566b3e43af9 in mysql_insert (thd=0x7ff068000ce8, table_list=0x7ff068012ea8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at sql/sql_insert.cc:1063
      		 
      #26 0x00005566b3e84e42 in mysql_execute_command (thd=0x7ff068000ce8) at sql/sql_parse.cc:4725
      		 
      #27 0x00005566b3e8fe7b in mysql_parse (thd=0x7ff068000ce8, rawbuf=0x7ff068012d40 "INSERT INTO t1 (col2,col_int ) VALUES /* 1 */ (1,1), (1,1)  /* E_R Thread6 QNO 26 CON_ID 20 */", length=94, parser_state=0x7ff10cb0a630, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:8092
      		 
      #28 0x00005566b3e7cd80 in dispatch_command (command=COM_QUERY, thd=0x7ff068000ce8, packet=0x7ff06800aa09 "INSERT INTO t1 (col2,col_int ) VALUES /* 1 */ (1,1), (1,1)  /* E_R Thread6 QNO 26 CON_ID 20 */ ", packet_length=95, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:1850
      		 
      #29 0x00005566b3e7b7e1 in do_command (thd=0x7ff068000ce8) at sql/sql_parse.cc:1395
      		 
      #30 0x00005566b3fe258c in do_handle_one_connection (connect=0x5566b7c6aa58) at sql/sql_connect.cc:1402
      		 
      #31 0x00005566b3fe2303 in handle_one_connection (arg=0x5566b7c6aa58) at sql/sql_connect.cc:1308
      		 
      #32 0x00007ff11755d7fc in start_thread (arg=0x7ff10cb0b700) at pthread_create.c:465
      		 
      #33 0x00007ff116997b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      		 
       
      		 
      /work/RQG_new2/rqg.pl \ 
      --duration=300 \
      		 
      --queries=1000000 \
      		 
      --threads=10 \
      		 
      --no_mask \
      		 
      --seed=random \
      		 
      --gendata=conf/mariadb/table_stress.zz \
      		 
      --engine=InnoDB \
      		 
      --noarchiving \
      		 
      --gendata_sql=conf/mariadb/table_stress.sql \
      		 
      --mysqld=--innodb-lock-wait-timeout=50 \
      		 
      --mysqld=--loose-idle_readonly_transaction_timeout=0 \
      		 
      --mysqld=--wait_timeout=28800 \ 
      --mysqld=--interactive_timeout=28800 \
      		 
      --mysqld=--net_read_timeout=30 \
      		 
      --mysqld=--log-output=none \
      		 
      --mysqld=--slave_net_timeout=60 \
      		 
      --mysqld=--loose-idle_write_transaction_timeout=0 \
      		 
      --mysqld=--connect_timeout=60 \ 
      --mysqld=--net_write_timeout=60 \
      		 
      --mysqld=--innodb_stats_persistent=off \
      		 
      --mysqld=--loose-idle_transaction_timeout=0 \
      		 
      --mysqld=--loose_innodb_use_native_aio=0 \
      		 
      --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \
      		 
      --mysqld=--loose-table_lock_wait_timeout=50 \
      		 
      --mysqld=--lock-wait-timeout=86400 \
      		 
      --whitelist_statuses='STATUS_SERVER_CRASHED' \
      		 
      --whitelist_patterns='mysqld:.{1,150}innobase.{1,1000} Assertion .{1,500} failed.' \
      		 
      --blacklist_statuses='STATUS_OK' \
      		 
      --reporters=Backtrace,ErrorLog \
      		 
      --validators=None \
      		 
      --transformers=None \ 
      --grammar=/work/RQG_new2/storage/1546941572/c00000.yy \
      		 
      --workdir=/work/RQG_new2/storage/1546941572/19 \
      		 
      --vardir=/dev/shm/vardir/1546941572/19 \
      		 
      --mtr-build-thread=966 \
      		 
      --basedir1=<path_to_binaries>

      Attachments

        1. 000018.log
          166 kB
        2. c00000.yy
          0.7 kB
        3. MDEV-18165.tgz
          2 kB

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17376 Server fails to set ADD_PK_INDEX, DROP_PK_INDEX if unique index nominated as PK

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18086 Assertion `len <= col->len || ((col->mtype) == 5 || (col->mtype) == 14) || (col->len == 0 && col->mtype == 1)' failed in rec_get_converted_size_comp_prefix_low upon UPDATE after upgrade from 10.1

          • Major - Major loss of function.
          • Closed

          Activity

            People

              marko Marko Mäkelä
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.