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

Assertion `!page_has_siblings(block->frame)' failed. in btr_pcur_store_position

    XMLWordPrintable

Details

    Description

      Assert hit during RQG testing
      mysqld: storage/innobase/btr/btr0pcur.cc:161: void btr_pcur_store_position(btr_pcur_t*, mtr_t*): Assertion `!page_has_siblings(block->frame)' failed.
      ...
      Query (0x62b0001f8238): UPDATE t4 SET col1 = 2 LIMIT 2
      Status: KILL_CONNECTION
      (rr) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
      #1  0x0000335a440ba801 in __GI_abort () at abort.c:79
      #2  0x0000335a440aa39a in __assert_fail_base (fmt=0x335a442317d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55b597e63a40 "!page_has_siblings(block->frame)", 
          file=file@entry=0x55b597e637a0 "/home/mleich/10.5_new/storage/innobase/btr/btr0pcur.cc", line=line@entry=161, 
          function=function@entry=0x55b597e64800 <btr_pcur_store_position(btr_pcur_t*, mtr_t*)::__PRETTY_FUNCTION__> "void btr_pcur_store_position(btr_pcur_t*, mtr_t*)") at assert.c:92
      #3  0x0000335a440aa412 in __GI___assert_fail (assertion=0x55b597e63a40 "!page_has_siblings(block->frame)", file=0x55b597e637a0 "/home/mleich/10.5_new/storage/innobase/btr/btr0pcur.cc", line=161, 
          function=0x55b597e64800 <btr_pcur_store_position(btr_pcur_t*, mtr_t*)::__PRETTY_FUNCTION__> "void btr_pcur_store_position(btr_pcur_t*, mtr_t*)") at assert.c:101
      #4  0x000055b5968e1650 in btr_pcur_store_position (cursor=0x621000ed5b80, mtr=0x5df0481e0490) at storage/innobase/btr/btr0pcur.cc:161
      #5  0x000055b59670b296 in row_search_mvcc (buf=0x61a00009c0b8 "\377", mode=PAGE_CUR_G, prebuilt=0x621000ed59a0, match_mode=0, direction=0) at storage/innobase/row/row0sel.cc:4677
      #6  0x000055b5962f7b5a in ha_innobase::index_read (this=0x61d000909cb8, buf=0x61a00009c0b8 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at storage/innobase/handler/ha_innodb.cc:8961
      #7  0x000055b5962fadce in ha_innobase::index_first (this=0x61d000909cb8, buf=0x61a00009c0b8 "\377") at innobase/handler/ha_innodb.cc:9335
      #8  0x000055b595808c47 in handler::ha_index_first (this=0x61d000909cb8, buf=0x61a00009c0b8 "\377") at sql/handler.cc:3140
      #9  0x000055b595c41688 in rr_index_first (info=0x5df0481e1240) at sql/records.cc:427
      #10 0x000055b594e710e8 in READ_RECORD::read_record (this=0x5df0481e1240) at sql/records.h:79
      #11 0x000055b59531a0ac in mysql_update (thd=0x62b000229218, table_list=0x62b0001f83a0, fields=..., values=..., conds=0x0, order_num=0, order=0x0, limit=2, ignore=false, found_return=0x5df0481e1c70, updated_return=0x5df0481e1cb0)
          at sql/sql_update.cc:843
      #12 0x000055b59502b10b in mysql_execute_command (thd=0x62b000229218) at sql/sql_parse.cc:4401
      #13 0x000055b595044139 in mysql_parse (thd=0x62b000229218, rawbuf=0x62b0001f8238 "UPDATE t4 SET col1 = 2 LIMIT 2  /* E_R Thread20 QNO 280 CON_ID 32 */", length=68, parser_state=0x5df0481e28f0, is_com_multi=false, is_next_command=false)
          at sql/sql_parse.cc:7992
      #14 0x000055b59501ac8d in dispatch_command (command=COM_QUERY, thd=0x62b000229218, packet=0x629000bcc219 " UPDATE t4 SET col1 = 2 LIMIT 2  /* E_R Thread20 QNO 280 CON_ID 32 */ ", packet_length=70, is_com_multi=false, is_next_command=false)
          at sql/sql_parse.cc:1874
      #15 0x000055b59501750b in do_command (thd=0x62b000229218) at sql/sql_parse.cc:1355
      #16 0x000055b595444a48 in do_handle_one_connection (connect=0x6080000062b8, put_in_cache=true) at sql/sql_connect.cc:1411
      #17 0x000055b5954443a6 in handle_one_connection (arg=0x6080000062b8) at sql/sql_connect.cc:1313
      #18 0x000055b5960fe097 in pfs_spawn_thread (arg=0x61500000be98) at storage/perfschema/pfs.cc:2201
      #19 0x00003fd870a4d6db in start_thread (arg=0x5df0481e4300) at pthread_create.c:463
      #20 0x0000335a4419b88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      (rr)
       
      origin/10.5 574ef3800567a24a57812d46118579fb08aaf243 2020-06-13T11:59:34+03:00
       
      RQG
      git clone https://github.com/mleich1/rqg --branch experimental RQG
      origin/experimental 611a31e38a3bc157392c0748c95991b6a248bb3b 2020-06-09T15:31:46+02:00
       
      perl rqg.pl \
      --grammar=conf/mariadb/table_stress_innodb_nocopy.yy \
      --gendata=conf/mariadb/table_stress.zz \
      --gendata_sql=conf/mariadb/table_stress.sql \
      --mysqld=--innodb_use_native_aio=1 \
      --mysqld=--innodb_stats_persistent=off \
      --mysqld=--innodb_lock_schedule_algorithm=fcfs \
      --mysqld=--loose-idle_write_transaction_timeout=0 \
      --mysqld=--loose-idle_transaction_timeout=0 \
      --mysqld=--loose-idle_readonly_transaction_timeout=0 \
      --mysqld=--connect_timeout=60 \
      --mysqld=--interactive_timeout=28800 \
      --mysqld=--slave_net_timeout=60 \
      --mysqld=--net_read_timeout=30 \
      --mysqld=--net_write_timeout=60 \
      --mysqld=--loose-table_lock_wait_timeout=50 \
      --mysqld=--wait_timeout=28800 \
      --mysqld=--lock-wait-timeout=86400 \
      --mysqld=--innodb-lock-wait-timeout=50 \
      --no-mask \
      --queries=10000000 \
      --seed=random \
      --reporters=Backtrace \
      --reporters=ErrorLog \
      --reporters=Deadlock1 \
      --validators=None \
      --mysqld=--log_output=none \
      --mysqld=--log-bin \
      --mysqld=--log_bin_trust_function_creators=1 \
      --mysqld=--loose-max-statement-time=30 \
      --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
      --engine=InnoDB \
      --restart_timeout=120 \
      --duration=300 \
      --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \
      --mysqld=--loose-innodb-sync-debug \
      --threads=33 \
      --mysqld=--innodb_page_size=4K \
      --mysqld=--innodb-buffer-pool-size=256M \
      --duration=300 \
      --no_mask \
      ... certain local settings ...
       
       
      
      

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              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.