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

Investigate: Lost committed prepared transaction

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • 13
    • Storage - Ra 2021-09-06

      There was a failure where mongod is stuck on waitUntilPreparedUnitOfWorkCommitsOrAborts as it is waiting for a prepared transaction to commit.

      From this comment, the prepared update has txnid = 2019 and flags = 8 (WT_UPDATE_PREPARE_RESTORED_FROM_DS).

      From this comment, the prepared update (on the index) has also a txnid = 2019 but its flags = 9 (WT_UPDATE_PREPARE_RESTORED_FROM_DS
      WT_UPDATE_DS).
       
      According to the dump, there is no session with txn.id = 2019 which means the transaction is committed. Somehow the update does not reach the disk.
       

            Assignee:
            backlog-server-storage-engines [DO NOT USE] Backlog - Storage Engines Team
            Reporter:
            etienne.petrel@mongodb.com Etienne Petrel
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: