import { execFile } from "node:child_process"; import { mkdtemp, readFile, rm } from "node:fs/promises"; import { tmpdir } from "node:os"; import { join } from "node:path"; import { DatabaseSync } from "node:sqlite"; import { fileURLToPath } from "node:url"; import { Worker } from "node:worker_threads"; export type Strategy = "select-only" | "unique"; type Attempt = { request: "A" | "B"; observedVacant: boolean; reservationId: number | null; }; const room = "会議室 A"; const startsAt = "10:00"; const rustWorker = fileURLToPath(new URL("./reservation-worker/target/debug/reservation-worker", import.meta.url)); const schema = await readFile(new URL("./reservation-schema.sql", import.meta.url), "utf8"); function reserve(dbPath: string, gate: SharedArrayBuffer, strategy: Strategy, request: Attempt["request"]) { return new Promise((resolve, reject) => { const worker = new Worker(new URL("./reservation-attempt.mts", import.meta.url), { workerData: { dbPath, gate, strategy, request, room, startsAt }, }); let result: Attempt | undefined; let failure: Error | undefined; worker.once("message", (message: Attempt) => { result = message; }); worker.once("error", (error) => { failure = error; }); worker.once("exit", (code) => { if (code === 0 && result) resolve(result); else reject(failure ?? new Error("Reservation attempt did not complete")); }); }); } function applyJobs(path: string, crash: boolean) { const args = crash ? [path, "--crash-before-commit"] : [path]; return new Promise<{ exitCode: number; processed: number }>((resolve, reject) => { execFile(rustWorker, args, { timeout: 5000, maxBuffer: 4096 }, (error, stdout) => { if (crash && error?.code === 23) return resolve({ exitCode: 23, processed: 0 }); if (error) return reject(new Error("Rust worker did not complete", { cause: error })); const processed = Number(stdout.trim()); if (!/^\d+$/.test(stdout.trim())) return reject(new Error("Invalid worker output")); resolve({ exitCode: 0, processed }); }); }); } function snapshot(db: DatabaseSync) { return { reservations: Number(db.prepare("SELECT count(*) AS total FROM reservations").get()?.total), pending: Number(db.prepare("SELECT count(*) AS total FROM outbox WHERE done = 0").get()?.total), receipts: Number(db.prepare("SELECT count(*) AS total FROM receipts").get()?.total), }; } export async function runReservationLab(strategy: Strategy, crash: boolean) { // 各実験に新しいDBを作り、実験同士で予約や制約を共有しない。 const folder = await mkdtemp(join(tmpdir(), "cs-reservations-")); const path = join(folder, "lab.sqlite"); try { const db = new DatabaseSync(path); try { db.exec(schema); if (strategy === "unique") { db.exec("CREATE UNIQUE INDEX one_reservation_per_slot ON reservations (room, starts_at);"); } const gate = new SharedArrayBuffer(Int32Array.BYTES_PER_ELEMENT); const results = await Promise.allSettled([ reserve(path, gate, strategy, "A"), reserve(path, gate, strategy, "B"), ]); // 失敗時も、両方の接続が閉じてからDBを片付ける。 const attempts = results.map((result) => { if (result.status === "rejected") throw result.reason; return result.value; }); const queued = snapshot(db); const interrupted = crash ? { ...await applyJobs(path, true), ...snapshot(db) } : null; const completed = { ...await applyJobs(path, false), ...snapshot(db) }; const replay = { ...await applyJobs(path, false), ...snapshot(db) }; return { strategy, room, startsAt, attempts, queued, interrupted, completed, replay }; } finally { db.close(); } } finally { await rm(folder, { recursive: true, force: true }); } }