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

Checkpoint can miss transactions with commit times before stable

    • Storage Engines
    • 8
    • StorEng - 2024-01-23, 2024-02-06 tapioooooooooooooca, 2024-02-20_A_near-death_puffin, 2024-03-05 - Claronald, 2024-03-19 - PacificOcean

      There's a window where a checkpoint can fail to include a transaction's updates with commit times before stable. If:

      1. the commit timestamp is checked at transaction commit and the transaction sleeps
      2. stable is then moved past the commit timestamp
      3. checkpoint selects a stable timestamp and runs

      The checkpoint will not include changes for a commit timestamp that is before the checkpoint's stable timestamp.

        1. NormalTxn.png
          NormalTxn.png
          159 kB
        2. PrepareTxn.png
          PrepareTxn.png
          166 kB
        3. Screenshot 2024-02-07 at 1.24.13 pm.png
          Screenshot 2024-02-07 at 1.24.13 pm.png
          42 kB
        4. Screenshot 2024-02-07 at 1.24.51 pm.png
          Screenshot 2024-02-07 at 1.24.51 pm.png
          44 kB
        5. Screenshot 2024-02-07 at 1.25.15 pm.png
          Screenshot 2024-02-07 at 1.25.15 pm.png
          69 kB
        6. Screenshot 2024-02-14 at 8.02.35 am.png
          Screenshot 2024-02-14 at 8.02.35 am.png
          200 kB
        7. Screenshot 2024-03-18 at 3.47.02 am.png
          Screenshot 2024-03-18 at 3.47.02 am.png
          402 kB
        8. Screenshot 2024-03-18 at 3.47.10 am.png
          Screenshot 2024-03-18 at 3.47.10 am.png
          347 kB
        9. Screenshot 2024-03-18 at 9.00.50 am.png
          Screenshot 2024-03-18 at 9.00.50 am.png
          120 kB

            Assignee:
            ravi.giri@mongodb.com Ravi Giri
            Reporter:
            keith.bostic@mongodb.com Keith Bostic (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            19 Start watching this issue

              Created:
              Updated:
              Resolved: