Uploaded image for project: 'WiredTiger'
  1. WiredTiger
  2. WT-11246

__hs_delete_record: Retrieved wrong update from history store

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • 2023-07-25 Absolute unit

      This was found during the investigation of WT-11242:

      [2023/06/30 06:15:15.049]     [1688105701:475058][45987:0xffff9e7b8100], t, file:T00003.wt, WT_SESSION.checkpoint: [WT_VERB_DEFAULT][ERROR]: __hs_delete_record, 1143: WiredTiger assertion failed: '!((hs_tw)->stop_txn != ((18446744073709551615UL) - 10) || (hs_tw)->stop_ts != (18446744073709551615UL))'. Retrieved wrong update from history store: empty tombstone with stop timestamp
      [2023/06/30 06:15:15.049]     [1688105701:475083][45987:0xffff9e7b8100], t, file:T00003.wt, WT_SESSION.checkpoint: [WT_VERB_DEFAULT][ERROR]: __wt_abort, 28: aborting WiredTiger library
      [2023/06/30 06:15:15.049]     Aborted (core dumped) 

      Config:

      ############################################
      #  RUN PARAMETERS: V3
      ############################################
      assert.read_timestamp=0
      backup=0
      backup.incremental=off
      backup.incr_granularity=11043
      block_cache=0
      block_cache.cache_on_checkpoint=0
      block_cache.cache_on_writes=1
      block_cache.size=87
      btree.huffman_value=0
      buffer_alignment=0
      cache=690
      cache.evict_max=4
      cache.eviction_dirty_target=0
      cache.eviction_dirty_trigger=0
      cache.minimum=20
      checkpoint=on
      checkpoint.log_size=178
      checkpoint.wait=57
      debug.checkpoint_retention=4
      debug.cursor_reposition=0
      debug.eviction=1
      debug.log_retention=4
      debug.realloc_exact=0
      debug.realloc_malloc=0
      debug.slow_checkpoint=1
      debug.table_logging=0
      debug.update_restore_evict=0
      disk.data_extend=0
      disk.direct_io=0
      disk.encryption=none
      disk.mmap=1
      disk.mmap_all=0
      file_manager.close_handle_minimum=10
      file_manager.close_idle_time=41
      file_manager.close_scan_interval=0
      format.abort=0
      format.independent_thread_rng=1
      format.major_timeout=0
      import=0
      logging=0
      logging.compression=none
      logging.file_max=280189
      logging.prealloc=0
      logging.remove=1
      ops.alter=0
      ops.compaction=0
      ops.hs_cursor=1
      ops.bound_cursor=0
      ops.prepare=1
      ops.random_cursor=0
      ops.salvage=0
      ops.verify=1
      quiet=1
      random.data_seed=9596518
      random.extra_seed=6001262
      runs.in_memory=0
      runs.ops=0
      runs.predictable_replay=0
      runs.rows=1000000
      runs.tables=3
      runs.threads=22
      runs.timer=16
      runs.verify_failure_dump=0
      statistics.mode=fast
      statistics_log.sources=off
      stress.aggressive_stash_free=0
      stress.aggressive_sweep=0
      stress.checkpoint=1
      stress.checkpoint_evict_page=1
      stress.checkpoint_prepare=1
      stress.evict_reposition=0
      stress.failpoint_eviction_fail_after_reconciliation=1
      stress.failpoint_hs_delete_key_from_ts=0
      stress.hs_checkpoint_delay=1
      stress.hs_search=0
      stress.hs_sweep=0
      stress.prepare_resolution_1=0
      stress.sleep_before_read_overflow_onpage=0
      stress.split_1=0
      stress.split_2=0
      stress.split_3=0
      stress.split_4=0
      stress.split_5=0
      stress.split_6=0
      stress.split_7=0
      stress.split_8=0
      tiered_storage.flush_frequency=0
      tiered_storage.storage_source=off
      transaction.implicit=0
      transaction.timestamps=1
      wiredtiger.config=off
      wiredtiger.rwlock=1
      wiredtiger.leak_memory=0
      ############################################
      #  TABLE PARAMETERS: table 1
      ############################################
      table1.btree.compression=zstd
      table1.btree.dictionary=0
      table1.btree.internal_key_truncation=1
      table1.btree.internal_page_max=13
      table1.btree.leaf_page_max=15
      table1.btree.memory_page_max=1
      table1.btree.repeat_data_pct=49
      table1.btree.split_pct=64
      table1.btree.value_max=2002
      table1.btree.value_min=17
      table1.disk.checksum=off
      table1.disk.firstfit=1
      table1.ops.pareto=0
      table1.ops.pareto.skew=69
      table1.ops.pct.delete=45
      table1.ops.pct.insert=14
      table1.ops.pct.modify=20
      table1.ops.pct.read=20
      table1.ops.pct.write=1
      table1.ops.truncate=0
      table1.runs.mirror=0
      table1.runs.source=table
      table1.runs.type=variable-length column-store
      ############################################
      #  TABLE PARAMETERS: table 2
      ############################################
      table2.btree.compression=zstd
      table2.btree.dictionary=0
      table2.btree.internal_key_truncation=1
      table2.btree.internal_page_max=16
      table2.btree.key_max=102
      table2.btree.key_min=31
      table2.btree.leaf_page_max=11
      table2.btree.memory_page_max=10
      table2.btree.prefix_len=0
      table2.btree.prefix_compression=1
      table2.btree.prefix_compression_min=6
      table2.btree.reverse=0
      table2.btree.split_pct=66
      table2.btree.value_max=1586
      table2.btree.value_min=10
      table2.disk.checksum=on
      table2.disk.firstfit=0
      table2.ops.pareto=1
      table2.ops.pareto.skew=49
      table2.ops.pct.delete=0
      table2.ops.pct.insert=100
      table2.ops.pct.modify=0
      table2.ops.pct.read=0
      table2.ops.pct.write=0
      table2.ops.truncate=0
      table2.runs.mirror=0
      table2.runs.source=table
      table2.runs.type=row-store
      ############################################
      #  TABLE PARAMETERS: table 3
      ############################################
      table3.btree.compression=snappy
      table3.btree.dictionary=0
      table3.btree.internal_key_truncation=1
      table3.btree.internal_page_max=11
      table3.btree.key_max=48
      table3.btree.key_min=14
      table3.btree.leaf_page_max=12
      table3.btree.memory_page_max=4
      table3.btree.prefix_len=0
      table3.btree.prefix_compression=1
      table3.btree.prefix_compression_min=8
      table3.btree.reverse=0
      table3.btree.split_pct=63
      table3.btree.value_max=2642
      table3.btree.value_min=18
      table3.disk.checksum=unencrypted
      table3.disk.firstfit=0
      table3.ops.pareto=1
      table3.ops.pareto.skew=62
      table3.ops.pct.delete=19
      table3.ops.pct.insert=48
      table3.ops.pct.modify=0
      table3.ops.pct.read=29
      table3.ops.pct.write=4
      table3.ops.truncate=0
      table3.runs.mirror=0
      table3.runs.source=table
      table3.runs.type=row-store
      ############################################
      

            Assignee:
            chenhao.qu@mongodb.com Chenhao Qu
            Reporter:
            etienne.petrel@mongodb.com Etienne Petrel
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: