Checkpoint can miss transactions with commit times before stable

XMLWordPrintableJSON

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

      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
          159 kB
          Ravi Giri
        2. PrepareTxn.png
          166 kB
          Ravi Giri
        3. Screenshot 2024-02-07 at 1.24.13 pm.png
          42 kB
          Ravi Giri
        4. Screenshot 2024-02-07 at 1.24.51 pm.png
          44 kB
          Ravi Giri
        5. Screenshot 2024-02-07 at 1.25.15 pm.png
          69 kB
          Ravi Giri
        6. Screenshot 2024-02-14 at 8.02.35 am.png
          200 kB
          Ravi Giri
        7. Screenshot 2024-03-18 at 3.47.02 am.png
          402 kB
          Ravi Giri
        8. Screenshot 2024-03-18 at 3.47.10 am.png
          347 kB
          Ravi Giri
        9. Screenshot 2024-03-18 at 9.00.50 am.png
          120 kB
          Ravi Giri

              Assignee:
              Ravi Giri
              Reporter:
              Keith Bostic (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              19 Start watching this issue

                Created:
                Updated:
                Resolved: