{
  "pass": true,
  "results": [
    {
      "scenario": "before commit process crash",
      "command": [
        "/opt/homebrew/opt/python@3.14/bin/python3.14",
        "/Users/magicliang/Desktop/Programming/git/hexo-blog/examples/system-design/labs/35/session-dispatch/crash_child.py",
        "/var/folders/69/dwg4b48n54l79z0hv04311bw0000gn/T/tmp7syre_kh/before.sqlite",
        "before"
      ],
      "child_exit": 23,
      "child_stdout": "{\"fault\": \"os._exit before commit\", \"pid\": 39141}\n",
      "child_stderr": "",
      "rows_after_crash": [],
      "pending_events_after_crash": [],
      "retry": {
        "id": "new-generated-id",
        "request_id": "request-1",
        "driver_id": "driver-1",
        "order_id": "order-1",
        "generation": 1,
        "state": "offered",
        "created_ms": 1100,
        "expires_ms": 6100
      },
      "first_ack_rows": 1,
      "duplicate_ack_rows": 0,
      "authoritative_retry_state": "accepted",
      "local_duplicate_deliveries": 2,
      "local_effects": 1
    },
    {
      "scenario": "after commit process crash",
      "command": [
        "/opt/homebrew/opt/python@3.14/bin/python3.14",
        "/Users/magicliang/Desktop/Programming/git/hexo-blog/examples/system-design/labs/35/session-dispatch/crash_child.py",
        "/var/folders/69/dwg4b48n54l79z0hv04311bw0000gn/T/tmp7syre_kh/after.sqlite",
        "after"
      ],
      "child_exit": 24,
      "child_stdout": "{\"fault\": \"os._exit after commit before HTTP response\", \"pid\": 39142, \"offer\": {\"id\": \"offer-1\", \"request_id\": \"request-1\", \"driver_id\": \"driver-1\", \"order_id\": \"order-1\", \"generation\": 1, \"state\": \"offered\", \"created_ms\": 1000, \"expires_ms\": 6000}}\n",
      "child_stderr": "",
      "rows_after_crash": [
        {
          "id": "offer-1",
          "request_id": "request-1",
          "driver_id": "driver-1",
          "order_id": "order-1",
          "generation": 1,
          "state": "offered",
          "created_ms": 1000,
          "expires_ms": 6000
        }
      ],
      "pending_events_after_crash": [
        {
          "event_id": "offer-1:offered",
          "id": "offer-1",
          "request_id": "request-1",
          "driver_id": "driver-1",
          "order_id": "order-1",
          "generation": 1,
          "state": "offered",
          "created_ms": 1000,
          "expires_ms": 6000
        }
      ],
      "retry": {
        "id": "offer-1",
        "request_id": "request-1",
        "driver_id": "driver-1",
        "order_id": "order-1",
        "generation": 1,
        "state": "offered",
        "created_ms": 1000,
        "expires_ms": 6000
      },
      "first_ack_rows": 1,
      "duplicate_ack_rows": 0,
      "authoritative_retry_state": "accepted",
      "local_duplicate_deliveries": 2,
      "local_effects": 1
    }
  ],
  "boundary": "real process exit and SQLite recovery; delivery deduplication is in-memory model, not network proof"
}
