{
  "scenario": "real_process_kill_and_sqlite_recovery",
  "observations": [
    {
      "checkpoint": "after_seat_update",
      "argv": [
        "/opt/homebrew/opt/python@3.14/bin/python3.14",
        "crash_worker.py",
        "/Users/magicliang/Desktop/Programming/git/hexo-blog/examples/system-design/evidence/35/session-ticket/runs/04-process-crashes/after_seat_update.sqlite",
        "56d7eb6f55ca47a7a25a5c6efef96347",
        "after_seat_update"
      ],
      "worker_exit": -9,
      "before_retry": {
        "seats": [
          {
            "id": 1,
            "state": "HELD",
            "hold_id": "e27900b1e98e4d3cb97753a9f3cb629e",
            "expires_at": 1300
          }
        ],
        "orders": [
          {
            "id": "56d7eb6f55ca47a7a25a5c6efef96347",
            "buyer": "alice",
            "request_key": "one",
            "seat_id": 1,
            "hold_id": "e27900b1e98e4d3cb97753a9f3cb629e",
            "expires_at": 1300,
            "state": "HELD",
            "amount_cents": 10000,
            "currency": "CNY"
          }
        ],
        "payments": [],
        "ledger": []
      },
      "retry": "BOOKED",
      "ledger_after_retry": 1,
      "integrity": "ok",
      "journal_mode": "delete"
    },
    {
      "checkpoint": "before_commit",
      "argv": [
        "/opt/homebrew/opt/python@3.14/bin/python3.14",
        "crash_worker.py",
        "/Users/magicliang/Desktop/Programming/git/hexo-blog/examples/system-design/evidence/35/session-ticket/runs/04-process-crashes/before_commit.sqlite",
        "594b18cd7b914ac5b4da959fc170008c",
        "before_commit"
      ],
      "worker_exit": -9,
      "before_retry": {
        "seats": [
          {
            "id": 1,
            "state": "HELD",
            "hold_id": "63b1503a2e5f4867a65b1edc0059736e",
            "expires_at": 1300
          }
        ],
        "orders": [
          {
            "id": "594b18cd7b914ac5b4da959fc170008c",
            "buyer": "alice",
            "request_key": "one",
            "seat_id": 1,
            "hold_id": "63b1503a2e5f4867a65b1edc0059736e",
            "expires_at": 1300,
            "state": "HELD",
            "amount_cents": 10000,
            "currency": "CNY"
          }
        ],
        "payments": [],
        "ledger": []
      },
      "retry": "BOOKED",
      "ledger_after_retry": 1,
      "integrity": "ok",
      "journal_mode": "delete"
    },
    {
      "checkpoint": "after_commit_before_response",
      "argv": [
        "/opt/homebrew/opt/python@3.14/bin/python3.14",
        "crash_worker.py",
        "/Users/magicliang/Desktop/Programming/git/hexo-blog/examples/system-design/evidence/35/session-ticket/runs/04-process-crashes/after_commit_before_response.sqlite",
        "9d74ece3814c49dd88b2531786d3b34e",
        "after_commit_before_response"
      ],
      "worker_exit": -9,
      "before_retry": {
        "seats": [
          {
            "id": 1,
            "state": "SOLD",
            "hold_id": "b91e644d3f794825a75cdd9b6e206fd2",
            "expires_at": 1300
          }
        ],
        "orders": [
          {
            "id": "9d74ece3814c49dd88b2531786d3b34e",
            "buyer": "alice",
            "request_key": "one",
            "seat_id": 1,
            "hold_id": "b91e644d3f794825a75cdd9b6e206fd2",
            "expires_at": 1300,
            "state": "PAID",
            "amount_cents": 10000,
            "currency": "CNY"
          }
        ],
        "payments": [
          {
            "id": "crash-payment",
            "order_id": "9d74ece3814c49dd88b2531786d3b34e",
            "amount_cents": 10000,
            "currency": "CNY",
            "result": "BOOKED"
          }
        ],
        "ledger": [
          {
            "payment_id": "crash-payment",
            "order_id": "9d74ece3814c49dd88b2531786d3b34e",
            "amount_cents": 10000
          }
        ]
      },
      "retry": "BOOKED",
      "ledger_after_retry": 1,
      "integrity": "ok",
      "journal_mode": "delete"
    }
  ],
  "scope": "process SIGKILL on local SQLite, not machine power loss or replicated DB recovery",
  "pass": true
}
