date: 2026-11-05T23:11:34Z  commit: cf41f7c64dcf1dea6da0643f5793bd2e5dd1f03e
environment: {"COMPOSE_PROJECT_NAME": "hlpipe-lab4-grades-20261106", "COMPOSE_FILE": "compose.yaml", "LB_HTTP_PORT": "18084", "LB_STATS_PORT": "24844", "BASE_URL": "http://127.0.0.1:18084", "EVIDENCE_DIR": "evidence/sqlalchemy-2026-11-06/grade4", "NO_PROXY": "localhost,127.0.0.1,::1"}
$ sh scripts/overload-leftovers.sh
date: 2026-11-05T23:11:34Z  commit: cf41f7c64dcf1dea6da0643f5793bd2e5dd1f03e
# make overload-leftovers (scripts/overload-leftovers.sh) после серии памяти: невидимые намерения от 503 по
# таймауту видны сверке свежими, уборка API удаляет их после UPLOAD_GRACE_SECONDS; стенд тот же
$ make reconcile   # dry-run
{
  "mode": "dry-run",
  "skipped": false,
  "grace_seconds": 3600,
  "skew_seconds": 60,
  "deep": false,
  "page_size": 1000,
  "scanned": {
    "objects": 1677,
    "rows": 1699
  },
  "found": {
    "orphan_stale": 0,
    "orphan_fresh": 0,
    "missing": 0,
    "size_mismatch": 0,
    "sha_mismatch": 0,
    "pending_stale": 0,
    "pending_fresh": 30,
    "quarantined": 0,
    "healed": 0
  },
  "fixed": {
    "orphan_stale": 0,
    "missing": 0,
    "size_mismatch": 0,
    "sha_mismatch": 0,
    "pending_stale": 0,
    "healed": 0
  },
  "rechecked": {},
  "errors": 0,
  "samples": {
    "pending_fresh": [
      "01a1adef-d982-7568-a4e4-806e55ce3d37",
      "01a1adf0-0885-72da-8cd6-e61660a24073",
      "01a1adf0-2ab2-76bf-a42e-03cf494bbb35",
      "01a1adf5-c5a6-711d-97a4-c202111e7c42",
      "01a1adf7-ed0e-7329-8a26-e57af871c267",
      "01a1adf7-ed0e-77d0-a406-bd7fa28751fd",
      "01a1adf7-ed32-779f-b1e9-55f318fe3c1a",
      "01a1adf7-ed9f-746c-b073-3b5f60212364",
      "01a1adf7-edd6-75a8-8ec9-00fc1928a524",
      "01a1adf7-ee71-758d-9272-f4b18b6bf7d2",
      "01a1adf7-ee79-74b8-bd88-0dfb1b312025",
      "01a1adf7-ee9d-71c6-a259-23b00a895555",
      "01a1adf7-ee9f-7223-8e24-e9a09fffc11e",
      "01a1adf7-eea6-70b8-9cb1-8131305b4d53",
      "01a1adf7-eeb4-758c-a256-6aaee7f64398",
      "01a1adf7-eec8-744e-bfc8-f1c5c60dd827",
      "01a1adf7-eee6-75e4-8965-019e89d931c8",
      "01a1adf7-ef01-71fb-8618-78cc5cd3c960",
      "01a1adf7-f11a-70f1-846b-e890c223dacd",
      "01a1adf7-f98f-7035-92f1-190362580270"
    ]
  },
  "cost": {
    "seconds": 0.288,
    "requests": {
      "s3_list": 2,
      "s3_head": 0,
      "s3_get": 0,
      "s3_delete": 0,
      "sql": 2
    },
    "waited_seconds": {
      "s3_list": 0.261,
      "sql": 0.017
    },
    "hashed_bytes": 0,
    "cpu_seconds": 0.611,
    "max_rss_mib": 110.1
  }
}
$ psql -c "SELECT status, count(*), min(created_at), max(created_at) FROM attachments GROUP BY status ORDER BY status"
 status  | count |              min              |              max              
---------+-------+-------------------------------+-------------------------------
 pending |    30 | 2026-11-05 22:58:59.586832+00 | 2026-11-05 23:10:14.949798+00
 ready   |  1669 | 2026-11-05 21:02:17.920667+00 | 2026-11-05 23:11:27.041409+00
(2 rows)

$ until [ "$(psql -tAc "SELECT count(*) FROM attachments WHERE status = 'pending'")" = 0 ]; do sleep 10; done
pending = 0 в 2026-11-05T23:25:40Z
$ docker compose logs --since 2026-11-05T23:11:34Z api | audit.attachment_discarded и attachments.swept
{'abandoned': 30} swept 30 first 2026-11-05T23:14:02Z last 2026-11-05T23:25:32Z
$ psql -c "SELECT status, count(*), min(created_at), max(created_at) FROM attachments GROUP BY status ORDER BY status"
 status | count |              min              |              max              
--------+-------+-------------------------------+-------------------------------
 ready  |  1669 | 2026-11-05 21:02:17.920667+00 | 2026-11-05 23:11:27.041409+00
(1 row)

$ make reconcile   # dry-run после уборки
{
  "mode": "dry-run",
  "skipped": false,
  "grace_seconds": 3600,
  "skew_seconds": 60,
  "deep": false,
  "page_size": 1000,
  "scanned": {
    "objects": 1669,
    "rows": 1669
  },
  "found": {
    "orphan_stale": 0,
    "orphan_fresh": 0,
    "missing": 0,
    "size_mismatch": 0,
    "sha_mismatch": 0,
    "pending_stale": 0,
    "pending_fresh": 0,
    "quarantined": 0,
    "healed": 0
  },
  "fixed": {
    "orphan_stale": 0,
    "missing": 0,
    "size_mismatch": 0,
    "sha_mismatch": 0,
    "pending_stale": 0,
    "healed": 0
  },
  "rechecked": {},
  "errors": 0,
  "samples": {},
  "cost": {
    "seconds": 0.18,
    "requests": {
      "s3_list": 2,
      "s3_head": 0,
      "s3_get": 0,
      "s3_delete": 0,
      "sql": 2
    },
    "waited_seconds": {
      "s3_list": 0.155,
      "sql": 0.015
    },
    "hashed_bytes": 0,
    "cpu_seconds": 0.596,
    "max_rss_mib": 110.2
  }
}
exit_code: 0  elapsed_seconds: 847.812
