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

InnoDB: Failing assertion: buf != field_ref_zero in row_merge_buf_add or FATAL error FIL_PAGE_TYPE=17855 on BLOB read file

    XMLWordPrintable

Details

    Description

      10.5 5ca14daf non-debug

      2020-10-20 13:57:51 0x7ffa875d9300  InnoDB: Assertion failure in file /data/src/10.5/storage/innobase/row/row0merge.cc line 727
      InnoDB: Failing assertion: buf != field_ref_zero
       
      #6  0x000056249806fdd1 in ut_dbg_assertion_failed (expr=expr@entry=0x56249a543fe0 "buf != field_ref_zero", file=file@entry=0x56249a543de0 "/data/src/10.5/storage/innobase/row/row0merge.cc", line=line@entry=727) at /data/src/10.5/storage/innobase/ut/ut0dbg.cc:60
      #7  0x0000562498042eb0 in row_merge_buf_add (buf=<optimized out>, fts_index=<optimized out>, old_table=<optimized out>, new_table=<optimized out>, psort_info=<optimized out>, row=<optimized out>, ext=<optimized out>, doc_id=<optimized out>, conv_heap=<optimized out>, err=<optimized out>, v_heap=<optimized out>, my_table=<optimized out>, trx=<optimized out>) at /data/src/10.5/storage/innobase/row/row0merge.cc:727
      #8  0x00005624998999e7 in row_merge_read_clustered_index (trx=<optimized out>, table=<optimized out>, old_table=<optimized out>, new_table=<optimized out>, online=<optimized out>, index=<optimized out>, fts_sort_idx=<optimized out>, psort_info=<optimized out>, files=<optimized out>, key_numbers=<optimized out>, n_index=<optimized out>, defaults=<optimized out>, add_v=<optimized out>, col_map=<optimized out>, add_autoinc=<optimized out>, sequence=..., block=<optimized out>, skip_pk_sort=<optimized out>, tmpfd=<optimized out>, stage=<optimized out>, pct_cost=<optimized out>, crypt_block=<optimized out>, eval_table=<optimized out>, allow_not_null=<optimized out>) at /data/src/10.5/storage/innobase/row/row0merge.cc:2338
      #9  0x00005624998a0bd8 in row_merge_build_indexes (trx=<optimized out>, old_table=<optimized out>, new_table=<optimized out>, online=<optimized out>, indexes=<optimized out>, key_numbers=<optimized out>, n_indexes=<optimized out>, table=<optimized out>, defaults=<optimized out>, col_map=<optimized out>, add_autoinc=<optimized out>, sequence=..., skip_pk_sort=<optimized out>, stage=<optimized out>, add_v=<optimized out>, eval_table=<optimized out>, allow_not_null=<optimized out>) at /data/src/10.5/storage/innobase/row/row0merge.cc:4522
      #10 0x000056249967421a in ha_innobase::inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=<optimized out>) at /data/src/10.5/storage/innobase/handler/handler0alter.cc:8408
      #11 0x00005624986ee792 in handler::ha_inplace_alter_table (ha_alter_info=0x7ffa875d1b30, altered_table=0x7ffa875d24d0, this=<optimized out>) at /data/src/10.5/sql/handler.h:4526
      #12 mysql_inplace_alter_table (target_mdl_request=0x7ffa875d1ed0, alter_ctx=0x7ffa875d3590, ha_alter_info=0x7ffa875d1b30, altered_table=0x7ffa875d24d0, table=<optimized out>, table_list=0x62b0000a1360, thd=0x62b00009a218) at /data/src/10.5/sql/sql_table.cc:7990
      #13 mysql_alter_table (thd=thd@entry=0x62b00009a218, new_db=new_db@entry=0x62b00009eaa0, new_name=new_name@entry=0x62b00009eea0, create_info=create_info@entry=0x7ffa875d5100, table_list=<optimized out>, table_list@entry=0x62b0000a1360, alter_info=alter_info@entry=0x7ffa875d4ff0, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /data/src/10.5/sql/sql_table.cc:10571
      #14 0x0000562498831a06 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x62b00009a218) at /data/src/10.5/sql/structs.h:559
      #15 0x000056249848aa23 in mysql_execute_command (thd=0x62b00009a218) at /data/src/10.5/sql/sql_parse.cc:5952
      #16 0x000056249845177d in mysql_parse (thd=thd@entry=0x62b00009a218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7ffa875d6f20, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.5/sql/sql_parse.cc:7994
      #17 0x000056249847da81 in dispatch_command (command=COM_QUERY, thd=0x62b00009a218, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.5/sql/sql_class.h:1254
      #18 0x0000562498483865 in do_command (thd=0x62b00009a218) at /data/src/10.5/sql/sql_parse.cc:1348
      #19 0x000056249882012d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x608000002cb8, put_in_cache=put_in_cache@entry=true) at /data/src/10.5/sql/sql_connect.cc:1410
      #20 0x0000562498820cbd in handle_one_connection (arg=arg@entry=0x608000002cb8) at /data/src/10.5/sql/sql_connect.cc:1312
      #21 0x0000562499408819 in pfs_spawn_thread (arg=0x61500000aa98) at /data/src/10.5/storage/perfschema/pfs.cc:2201
      #22 0x00007ffa9664a609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #23 0x00007ffa9621e293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      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.