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

Server crash, fatal error or assertion failures somewhere in btr_cur_compress_if_useful

    XMLWordPrintable

Details

    Description

      The test case is for reproducing purposes only, don't put it into the regression suite as is. It is non-deterministic, run with --repeat. It currently fails for me very quickly, in 1-3 attempts on 10.5+ and slightly longer on 10.3-10.4; but it can vary on different machines and builds.

      Run with --mysqld=--innodb-page-size=4K.

      --source include/have_sequence.inc
      		 
      --source include/have_innodb.inc
      		 
      --source include/have_innodb_4k.inc
      		 
       
      		 
      CREATE TABLE t (a MULTIPOINT NOT NULL, b INT DEFAULT 0 INVISIBLE, id INT, c BINARY(220), d VARCHAR(128), PRIMARY KEY (a(9),c,id,b), SPATIAL(a), UNIQUE(id)) ENGINE=InnoDB;
      		 
      INSERT INTO t (id,c,b,a,d) SELECT seq,'',1,MULTIPOINTFromText('MULTIPOINT(0.60 0.04,0.30 0.19,0.98 0.22,0.42 0.06)'),'quxx' FROM seq_1_to_1024;
      		 
      REPLACE INTO t SELECT * FROM t;
      		 
       
      		 
      --sleep 5
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t;

      10.5 debug 3fabdc3c

      		 
      mariadbd: /data/src/10.5/storage/innobase/rem/rem0cmp.cc:273: int cmp_data(ulint, ulint, const byte*, ulint, const byte*, ulint): Assertion `len1 == DATA_MBR_LEN' failed.
      		 
      220516  2:13:30 [ERROR] mysqld got signal 6 ;
      		 
       
      		 
      #7  0x00007f9e5970f662 in __GI___assert_fail (assertion=0x5558b6d8f78e "len1 == DATA_MBR_LEN", file=0x5558b6d8f6d8 "/data/src/10.5/storage/innobase/rem/rem0cmp.cc", line=273, function=0x5558b6d8f708 "int cmp_data(ulint, ulint, const byte*, ulint, const byte*, ulint)") at assert.c:101
      		 
      #8  0x00005558b65a87c1 in cmp_data (mtype=14, prtype=3583, data1=0x7f9e00001d40 "", len1=4, data2=0x7f9e4ee0311c "", len2=4) at /data/src/10.5/storage/innobase/rem/rem0cmp.cc:273
      		 
      #9  0x00005558b65a91f9 in cmp_dtuple_rec_with_match_low (dtuple=0x7f9e00001cb8, rec=0x7f9e4ee030fc "333333\323?\\\217\302\365(\\\357?{\024\256G\341z\244?)\\\217\302\365(\314?", offsets=0x7f9e38ff6740, n_cmp=2, matched_fields=0x7f9e38ff66d8) at /data/src/10.5/storage/innobase/rem/rem0cmp.cc:411
      		 
      #10 0x00005558b6566ccd in page_cur_search_with_match (block=0x7f9e4ec1cd98, index=0x7f9e1c1cc798, tuple=0x7f9e00001cb8, mode=PAGE_CUR_LE, iup_matched_fields=0x7f9e38ff6ec8, ilow_matched_fields=0x7f9e38ff6ec0, cursor=0x7f9e00009c60, rtr_info=0x0) at /data/src/10.5/storage/innobase/page/page0cur.cc:454
      		 
      #11 0x00005558b6856a88 in page_cur_search (block=0x7f9e4ec1cd98, index=0x7f9e1c1cc798, tuple=0x7f9e00001cb8, mode=PAGE_CUR_LE, cursor=0x7f9e00009c60) at /data/src/10.5/storage/innobase/include/page0cur.inl:216
      		 
      #12 0x00005558b685c3a0 in rtr_cur_restore_position (latch_mode=34, btr_cur=0x7f9e38ff7ac0, level=2, mtr=0x7f9e38ff8150) at /data/src/10.5/storage/innobase/gis/gis0sea.cc:1369
      		 
      #13 0x00005558b6859611 in rtr_get_father_node (index=0x7f9e1c1cc798, level=2, tuple=0x7f9e00002408, sea_cur=0x7f9e38ff7ac0, btr_cur=0x7f9e38ff7410, page_no=225, mtr=0x7f9e38ff8150) at /data/src/10.5/storage/innobase/gis/gis0sea.cc:711
      		 
      #14 0x00005558b6859fd7 in rtr_page_get_father_node_ptr (offsets=0x7f9e0000e4c8, heap=0x7f9e0000e448, sea_cur=0x7f9e38ff7ac0, cursor=0x7f9e38ff7410, mtr=0x7f9e38ff8150) at /data/src/10.5/storage/innobase/gis/gis0sea.cc:845
      		 
      #15 0x00005558b685a45c in rtr_page_get_father_block (offsets=0x0, heap=0x7f9e0000e448, index=0x7f9e1c1cc798, block=0x7f9e4ec33f70, mtr=0x7f9e38ff8150, sea_cur=0x7f9e38ff7ac0, cursor=0x7f9e38ff7410) at /data/src/10.5/storage/innobase/gis/gis0sea.cc:915
      		 
      #16 0x00005558b66fe1c5 in btr_compress (cursor=0x7f9e38ff7ac0, adjust=0, mtr=0x7f9e38ff8150) at /data/src/10.5/storage/innobase/btr/btr0btr.cc:3447
      		 
      #17 0x00005558b6730702 in btr_cur_compress_if_useful (cursor=0x7f9e38ff7ac0, adjust=0, mtr=0x7f9e38ff8150) at /data/src/10.5/storage/innobase/btr/btr0cur.cc:5471
      		 
      #18 0x00005558b6732615 in btr_cur_pessimistic_delete (err=0x7f9e38ff7a64, has_reserved_extents=1, cursor=0x7f9e38ff7ac0, flags=16, rollback=false, mtr=0x7f9e38ff8150) at /data/src/10.5/storage/innobase/btr/btr0cur.cc:5901
      		 
      #19 0x00005558b685239b in rtr_node_ptr_delete (cursor=0x7f9e38ff7ac0, mtr=0x7f9e38ff8150) at /data/src/10.5/storage/innobase/gis/gis0rtree.cc:1608
      		 
      #20 0x00005558b6700d23 in btr_discard_page (cursor=0x7f9e38ff7ee0, mtr=0x7f9e38ff8150) at /data/src/10.5/storage/innobase/btr/btr0btr.cc:4072
      		 
      #21 0x00005558b673215b in btr_cur_pessimistic_delete (err=0x7f9e38ff7ed0, has_reserved_extents=0, cursor=0x7f9e38ff7ee0, flags=0, rollback=false, mtr=0x7f9e38ff8150) at /data/src/10.5/storage/innobase/btr/btr0cur.cc:5816
      		 
      #22 0x00005558b663793b in row_purge_remove_sec_if_poss_tree (node=0x5558b8e42c08, index=0x7f9e1c1cc798, entry=0x7f9e000013f8) at /data/src/10.5/storage/innobase/row/row0purge.cc:364
      		 
      #23 0x00005558b66382b8 in row_purge_remove_sec_if_poss (node=0x5558b8e42c08, index=0x7f9e1c1cc798, entry=0x7f9e000013f8) at /data/src/10.5/storage/innobase/row/row0purge.cc:575
      		 
      #24 0x00005558b66384ac in row_purge_del_mark (node=0x5558b8e42c08) at /data/src/10.5/storage/innobase/row/row0purge.cc:640
      		 
      #25 0x00005558b6639ea3 in row_purge_record_func (node=0x5558b8e42c08, undo_rec=0x7f9de8002eb0 "\002W\016\030\024", thr=0x5558b8e42a28, updated_extern=false) at /data/src/10.5/storage/innobase/row/row0purge.cc:1051
      		 
      #26 0x00005558b663a16d in row_purge (node=0x5558b8e42c08, undo_rec=0x7f9de8002eb0 "\002W\016\030\024", thr=0x5558b8e42a28) at /data/src/10.5/storage/innobase/row/row0purge.cc:1112
      		 
      #27 0x00005558b663a2e9 in row_purge_step (thr=0x5558b8e42a28) at /data/src/10.5/storage/innobase/row/row0purge.cc:1161
      		 
      #28 0x00005558b65a2617 in que_thr_step (thr=0x5558b8e42a28) at /data/src/10.5/storage/innobase/que/que0que.cc:946
      		 
      #29 0x00005558b65a28aa in que_run_threads_low (thr=0x5558b8e42a28) at /data/src/10.5/storage/innobase/que/que0que.cc:1008
      		 
      #30 0x00005558b65a2b0c in que_run_threads (thr=0x5558b8e42a28) at /data/src/10.5/storage/innobase/que/que0que.cc:1048
      		 
      #31 0x00005558b667e9f4 in srv_task_execute () at /data/src/10.5/storage/innobase/srv/srv0srv.cc:1766
      		 
      #32 0x00005558b667f2ab in purge_worker_callback () at /data/src/10.5/storage/innobase/srv/srv0srv.cc:1944
      		 
      #33 0x00005558b688ac64 in tpool::task_group::execute (this=0x5558b7eccec0 <purge_task_group>, t=0x5558b7eccc40 <purge_worker_task>) at /data/src/10.5/tpool/task_group.cc:55
      		 
      #34 0x00005558b688afba in tpool::task::execute (this=0x5558b7eccc40 <purge_worker_task>) at /data/src/10.5/tpool/task.cc:47
      		 
      #35 0x00005558b6883e2f in tpool::thread_pool_generic::worker_main (this=0x5558b8b35b50, thread_var=0x5558b8b45370) at /data/src/10.5/tpool/tpool_generic.cc:598
      		 
      #36 0x00005558b688aa04 in std::__invoke_impl<void, void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__f=@0x7f9e34001418: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x5558b6883d9a <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>, __t=@0x7f9e34001410: 0x5558b8b35b50) at /usr/include/c++/10/bits/invoke.h:73
      		 
      #37 0x00005558b688a8f4 in std::__invoke<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__fn=@0x7f9e34001418: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x5558b6883d9a <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>) at /usr/include/c++/10/bits/invoke.h:95
      		 
      #38 0x00005558b688a827 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::_M_invoke<0ul, 1ul, 2ul> (this=0x7f9e34001408) at /usr/include/c++/10/thread:264
      		 
      #39 0x00005558b688a7c4 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::operator() (this=0x7f9e34001408) at /usr/include/c++/10/thread:271
      		 
      #40 0x00005558b688a7a8 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> > >::_M_run (this=0x7f9e34001400) at /usr/include/c++/10/thread:215
      		 
      #41 0x00007f9e59acced0 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
      		 
      #42 0x00007f9e59bdbea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
      		 
      #43 0x00007f9e597d8def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

      10.5 non-debug 3fabdc3c

      		 
      #3  <signal handler called>
      		 
      #4  0x000055b9869890df in btr_cur_compress_if_useful (cursor=cursor@entry=0x7f89027fa180, adjust=adjust@entry=0, mtr=mtr@entry=0x7f89027fb130) at /data/src/10.5/storage/innobase/btr/btr0cur.cc:5459
      		 
      #5  0x000055b986a41706 in rtr_node_ptr_delete (mtr=0x7f89027fb130, cursor=0x7f89027fa180) at /data/src/10.5/storage/innobase/gis/gis0rtree.cc:1613
      		 
      #6  rtr_merge_and_update_mbr (cursor=cursor@entry=0x7f89027fa220, cursor2=cursor2@entry=0x7f89027fa180, offsets=<optimized out>, offsets2=offsets2@entry=0x7f88e40024a0, child_page=child_page@entry=0x7f89117ba000 "", mtr=mtr@entry=0x7f89027fb130) at /data/src/10.5/storage/innobase/gis/gis0rtree.cc:1592
      		 
      #7  0x000055b986974780 in btr_compress (cursor=cursor@entry=0x7f89027fa870, adjust=adjust@entry=0, mtr=mtr@entry=0x7f89027fb130) at /data/src/10.5/storage/innobase/btr/btr0btr.cc:3750
      		 
      #8  0x000055b9869890bc in btr_cur_compress_if_useful (cursor=cursor@entry=0x7f89027fa870, adjust=adjust@entry=0, mtr=mtr@entry=0x7f89027fb130) at /data/src/10.5/storage/innobase/btr/btr0cur.cc:5471
      		 
      #9  0x000055b986992f92 in btr_cur_pessimistic_delete (err=err@entry=0x7f89027fa79c, has_reserved_extents=has_reserved_extents@entry=1, cursor=cursor@entry=0x7f89027fa870, flags=flags@entry=16, rollback=rollback@entry=false, mtr=mtr@entry=0x7f89027fb130) at /data/src/10.5/storage/innobase/btr/btr0cur.cc:5901
      		 
      #10 0x000055b986a3f03e in rtr_node_ptr_delete (cursor=cursor@entry=0x7f89027fa870, mtr=mtr@entry=0x7f89027fb130) at /data/src/10.5/storage/innobase/gis/gis0rtree.cc:1608
      		 
      #11 0x000055b986974643 in btr_compress (cursor=cursor@entry=0x7f89027faec0, adjust=adjust@entry=0, mtr=mtr@entry=0x7f89027fb130) at /data/src/10.5/storage/innobase/btr/btr0btr.cc:3595
      		 
      #12 0x000055b9869890bc in btr_cur_compress_if_useful (cursor=cursor@entry=0x7f89027faec0, adjust=adjust@entry=0, mtr=mtr@entry=0x7f89027fb130) at /data/src/10.5/storage/innobase/btr/btr0cur.cc:5471
      		 
      #13 0x000055b986992f92 in btr_cur_pessimistic_delete (err=err@entry=0x7f89027fae90, has_reserved_extents=has_reserved_extents@entry=0, cursor=cursor@entry=0x7f89027faec0, flags=flags@entry=0, rollback=rollback@entry=false, mtr=mtr@entry=0x7f89027fb130) at /data/src/10.5/storage/innobase/btr/btr0cur.cc:5901
      		 
      #14 0x000055b9869077ea in row_purge_remove_sec_if_poss_tree (node=0x55b989b78de0, index=0x7f88601a3540, entry=0x7f88e4001060) at /data/src/10.5/storage/innobase/row/row0purge.cc:364
      		 
      #15 0x000055b986907fdc in row_purge_remove_sec_if_poss (entry=0x7f88e4001060, index=<optimized out>, node=0x55b989b78de0) at /data/src/10.5/storage/innobase/row/row0purge.cc:575
      		 
      #16 row_purge_del_mark (node=0x55b989b78de0) at /data/src/10.5/storage/innobase/row/row0purge.cc:640
      		 
      #17 row_purge_record_func (node=0x55b989b78de0, undo_rec=0x7f88fc0c4660 "\002W\016\n\024", thr=0x55b989b78c00, updated_extern=<optimized out>) at /data/src/10.5/storage/innobase/row/row0purge.cc:1051
      		 
      #18 0x000055b9869089c2 in row_purge (thr=0x55b989b78c00, undo_rec=0x7f88fc0c4660 "\002W\016\n\024", node=0x55b989b78de0) at /data/src/10.5/storage/innobase/row/row0purge.cc:1112
      		 
      #19 row_purge_step (thr=thr@entry=0x55b989b78c00) at /data/src/10.5/storage/innobase/row/row0purge.cc:1161
      		 
      #20 0x000055b9868c7f06 in que_thr_step (thr=0x7f89027fbc80) at /data/src/10.5/storage/innobase/que/que0que.cc:946
      		 
      #21 que_run_threads_low (thr=0x7f89027fbc80) at /data/src/10.5/storage/innobase/que/que0que.cc:1008
      		 
      #22 que_run_threads (thr=thr@entry=0x55b989b78c00) at /data/src/10.5/storage/innobase/que/que0que.cc:1048
      		 
      #23 0x000055b9869288b7 in srv_task_execute () at /data/src/10.5/storage/innobase/srv/srv0srv.cc:1766
      		 
      #24 purge_worker_callback () at /data/src/10.5/storage/innobase/srv/srv0srv.cc:1944
      		 
      #25 0x000055b986a68fd9 in tpool::task_group::execute (this=0x55b987d5d760 <purge_task_group>, t=0x55b987d3f920 <purge_worker_task>) at /data/src/10.5/tpool/task_group.cc:55
      		 
      #26 0x000055b986a6822f in tpool::thread_pool_generic::worker_main (this=0x55b989947570, thread_var=0x55b989957010) at /data/src/10.5/tpool/tpool_generic.cc:598
      		 
      #27 0x00007f8918253ed0 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
      		 
      #28 0x00007f8918360ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
      		 
      #29 0x00007f8917f77def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

      On 10.3-10.4 the failure is similar to MDEV-27675:

      10.3 debug 8c28b27f

      		 
      mysqld: /data/src/10.3/storage/innobase/gis/gis0sea.cc:722: void rtr_get_father_node(dict_index_t*, ulint, const dtuple_t*, btr_cur_t*, btr_cur_t*, ulint, mtr_t*): Assertion `ret' failed.
      		 
       
      		 
      #7  0x00007f9aefccf662 in __GI___assert_fail (assertion=0x5579179a4367 "ret", file=0x5579179a3d70 "/data/src/10.3/storage/innobase/gis/gis0sea.cc", line=722, function=0x5579179a4300 "void rtr_get_father_node(dict_index_t*, ulint, const dtuple_t*, btr_cur_t*, btr_cur_t*, ulint, mtr_t*)") at assert.c:101
      		 
      #8  0x00005579173d2769 in rtr_get_father_node (index=0x7f9a980dfa20, level=2, tuple=0x7f9aa400add0, sea_cur=0x7f9abb7fca00, btr_cur=0x7f9abb7fc260, page_no=226, mtr=0x7f9abb7fd300) at /data/src/10.3/storage/innobase/gis/gis0sea.cc:722
      		 
      #9  0x00005579173d30bd in rtr_page_get_father_node_ptr (offsets=0x7f9aa400e5d0, heap=0x7f9aa400e550, sea_cur=0x7f9abb7fca00, cursor=0x7f9abb7fc260, mtr=0x7f9abb7fd300) at /data/src/10.3/storage/innobase/gis/gis0sea.cc:850
      		 
      #10 0x00005579173d354c in rtr_page_get_father_block (offsets=0x0, heap=0x7f9aa400e550, index=0x7f9a980dfa20, block=0x7f9ae909d780, mtr=0x7f9abb7fd300, sea_cur=0x7f9abb7fca00, cursor=0x7f9abb7fc260) at /data/src/10.3/storage/innobase/gis/gis0sea.cc:920
      		 
      #11 0x000055791724d087 in btr_compress (cursor=0x7f9abb7fca00, adjust=0, mtr=0x7f9abb7fd300) at /data/src/10.3/storage/innobase/btr/btr0btr.cc:3581
      		 
      #12 0x000055791727e42c in btr_cur_compress_if_useful (cursor=0x7f9abb7fca00, adjust=0, mtr=0x7f9abb7fd300) at /data/src/10.3/storage/innobase/btr/btr0cur.cc:5467
      		 
      #13 0x0000557917280387 in btr_cur_pessimistic_delete (err=0x7f9abb7fc8c4, has_reserved_extents=1, cursor=0x7f9abb7fca00, flags=16, rollback=false, mtr=0x7f9abb7fd300) at /data/src/10.3/storage/innobase/btr/btr0cur.cc:5903
      		 
      #14 0x00005579173cb335 in rtr_node_ptr_delete (cursor=0x7f9abb7fca00, mtr=0x7f9abb7fd300) at /data/src/10.3/storage/innobase/gis/gis0rtree.cc:1716
      		 
      #15 0x000055791724da2e in btr_compress (cursor=0x7f9abb7fd090, adjust=0, mtr=0x7f9abb7fd300) at /data/src/10.3/storage/innobase/btr/btr0btr.cc:3755
      		 
      #16 0x000055791727e42c in btr_cur_compress_if_useful (cursor=0x7f9abb7fd090, adjust=0, mtr=0x7f9abb7fd300) at /data/src/10.3/storage/innobase/btr/btr0cur.cc:5467
      		 
      #17 0x0000557917280387 in btr_cur_pessimistic_delete (err=0x7f9abb7fd080, has_reserved_extents=0, cursor=0x7f9abb7fd090, flags=0, rollback=false, mtr=0x7f9abb7fd300) at /data/src/10.3/storage/innobase/btr/btr0cur.cc:5903
      		 
      #18 0x0000557917174f86 in row_purge_remove_sec_if_poss_tree (node=0x557919119910, index=0x7f9a980dfa20, entry=0x7f9aa400c400) at /data/src/10.3/storage/innobase/row/row0purge.cc:470
      		 
      #19 0x0000557917175b03 in row_purge_remove_sec_if_poss (node=0x557919119910, index=0x7f9a980dfa20, entry=0x7f9aa400c400) at /data/src/10.3/storage/innobase/row/row0purge.cc:704
      		 
      #20 0x0000557917175cfa in row_purge_del_mark (node=0x557919119910) at /data/src/10.3/storage/innobase/row/row0purge.cc:769
      		 
      #21 0x00005579171778db in row_purge_record_func (node=0x557919119910, undo_rec=0x7f9aac04ae60 "\002X\016\201\376\026", thr=0x557919119490, updated_extern=false) at /data/src/10.3/storage/innobase/row/row0purge.cc:1195
      		 
      #22 0x0000557917177be5 in row_purge (node=0x557919119910, undo_rec=0x7f9aac04ae60 "\002X\016\201\376\026", thr=0x557919119490) at /data/src/10.3/storage/innobase/row/row0purge.cc:1261
      		 
      #23 0x0000557917177f7d in row_purge_step (thr=0x557919119490) at /data/src/10.3/storage/innobase/row/row0purge.cc:1339
      		 
      #24 0x00005579170e30c7 in que_thr_step (thr=0x557919119490) at /data/src/10.3/storage/innobase/que/que0que.cc:1038
      		 
      #25 0x00005579170e335a in que_run_threads_low (thr=0x557919119490) at /data/src/10.3/storage/innobase/que/que0que.cc:1100
      		 
      #26 0x00005579170e35bc in que_run_threads (thr=0x557919119490) at /data/src/10.3/storage/innobase/que/que0que.cc:1140
      		 
      #27 0x00005579171cd318 in srv_task_execute (slot=0x557917ebfab0 <srv_sys+1264>) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:2456
      		 
      #28 0x00005579171cd597 in srv_worker_thread (arg=0x0) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:2511
      		 
      #29 0x00007f9aefe68ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
      		 
      #30 0x00007f9aefd98def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

      10.3 non-debug 8c28b27f

      		 
      2022-05-16  2:14:55 3 [ERROR] [FATAL] InnoDB: Corruption of index `a` of table `test`.`t` parent page 229 child page 317; child COMPACT RECORD(info_bits=0, 2 fields): {[32]333333 ?\   (\ ?{  G z ?)\   ( ?(0x333333333333D33F5C8FC2F5285CEF3F7B14AE47E17AA43F295C8FC2F528CC3F),[4]    (0x00000018)}; parent COMPACT RECORD(info_bits=0, 2 fields): {[32]333333 ?\   (\ ?{  G z ?)\   ( ?(0x333333333333D33F5C8FC2F5285CEF3F7B14AE47E17AA43F295C8FC2F528CC3F),[4]    (0x00000018)}. You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup, see https://mariadb.com/kb/en/library/innodb-recovery-modes/ about forcing recovery. Then dump + drop + reimport.
      		 
      220516  2:14:55 [ERROR] mysqld got signal 6 ;
      		 
       
      		 
      #6  0x000055c2f4f6f3c3 in ib::fatal::~fatal (this=<optimized out>, __in_chrg=<optimized out>) at /data/src/10.3/storage/innobase/ut/ut0ut.cc:606
      		 
      #7  0x000055c2f4f90d90 in rtr_page_get_father_node_ptr (offsets=0x7f5a500101a8, heap=<optimized out>, sea_cur=<optimized out>, cursor=<optimized out>, mtr=<optimized out>) at /data/src/10.3/storage/innobase/include/ut0ut.h:356
      		 
      #8  0x000055c2f554bf2e in btr_compress (cursor=cursor@entry=0x7f5a63ffda40, adjust=adjust@entry=0, mtr=mtr@entry=0x7f5a63ffe150) at /data/src/10.3/storage/innobase/btr/btr0btr.cc:3581
      		 
      #9  0x000055c2f555b34e in btr_cur_compress_if_useful (cursor=cursor@entry=0x7f5a63ffda40, adjust=adjust@entry=0, mtr=mtr@entry=0x7f5a63ffe150) at /data/src/10.3/storage/innobase/btr/btr0cur.cc:5467
      		 
      #10 0x000055c2f561d7dd in rtr_node_ptr_delete (cursor=0x7f5a63ffda40, mtr=0x7f5a63ffe150) at /data/src/10.3/storage/innobase/gis/gis0rtree.cc:1721
      		 
      #11 0x000055c2f5547115 in btr_discard_page (cursor=cursor@entry=0x7f5a63ffdee0, mtr=mtr@entry=0x7f5a63ffe150) at /data/src/10.3/storage/innobase/btr/btr0btr.cc:4230
      		 
      #12 0x000055c2f5563bc5 in btr_cur_pessimistic_delete (err=err@entry=0x7f5a63ffdeb0, has_reserved_extents=has_reserved_extents@entry=0, cursor=cursor@entry=0x7f5a63ffdee0, flags=flags@entry=0, rollback=rollback@entry=false, mtr=mtr@entry=0x7f5a63ffe150) at /data/src/10.3/storage/innobase/btr/btr0cur.cc:5808
      		 
      #13 0x000055c2f54df07a in row_purge_remove_sec_if_poss_tree (node=0x55c2f7466288, index=0x7f5a3c169f98, entry=0x7f5a5000cf08) at /data/src/10.3/storage/innobase/row/row0purge.cc:470
      		 
      #14 0x000055c2f54df89e in row_purge_remove_sec_if_poss (entry=0x7f5a5000cf08, index=<optimized out>, node=0x55c2f7466288) at /data/src/10.3/storage/innobase/row/row0purge.cc:704
      		 
      #15 row_purge_del_mark (node=0x55c2f7466288) at /data/src/10.3/storage/innobase/row/row0purge.cc:769
      		 
      #16 row_purge_record_func (node=0x55c2f7466288, undo_rec=0x7f5a5c096740 "\002X\016\204\212\024", thr=0x55c2f7465e80, updated_extern=<optimized out>) at /data/src/10.3/storage/innobase/row/row0purge.cc:1195
      		 
      #17 0x000055c2f54e06ab in row_purge (thr=0x55c2f7465e80, undo_rec=0x7f5a5c096740 "\002X\016\204\212\024", node=0x55c2f7466288) at /data/src/10.3/storage/innobase/row/row0purge.cc:1261
      		 
      #18 row_purge_step (thr=thr@entry=0x55c2f7465e80) at /data/src/10.3/storage/innobase/row/row0purge.cc:1339
      		 
      #19 0x000055c2f54a4a59 in que_thr_step (thr=0x55c2f7466288) at /data/src/10.3/storage/innobase/que/que0que.cc:1038
      		 
      #20 que_run_threads_low (thr=0x55c2f7466288) at /data/src/10.3/storage/innobase/que/que0que.cc:1100
      		 
      #21 que_run_threads (thr=thr@entry=0x55c2f7465e80) at /data/src/10.3/storage/innobase/que/que0que.cc:1140
      		 
      #22 0x000055c2f5506b35 in srv_task_execute () at /data/src/10.3/storage/innobase/srv/srv0srv.cc:2456
      		 
      #23 srv_worker_thread (arg=<optimized out>) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:2511
      		 
      #24 0x00007f5a8c26bea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
      		 
      #25 0x00007f5a8c19bdef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

      The test case is not applicable to 10.2 due to the use of an invisible column (which I couldn't get rid of).

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27675 Index corruption / assertion failure in rtr_page_get_father_node_ptr with spatial key

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33476 Assertion `success' failed in btr_compress; assertion: btr_page_get_next(latch_leaves.blocks[0]->frame) == page_get_page_no(page)

          • Major - Major loss of function.
          • Closed

          Activity

            People

              vlad.lesin Vladislav Lesin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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