============================================================
 STOCKLAB — SL-001 FINAL AST PATCH
 UTC: 2026-09-10 10:13:06
 RC: /data/files/bmw/stocklab-release-candidate-celery-20260910-124000
============================================================

### 1. CONTEXT
uid=0(root) gid=0(root) groups=0(root)
c11180b688559acaa14b249b5052a2a60a08cb578217eda5b19d4cb5e15b9841  /data/files/bmw/stocklab-release-candidate-celery-20260910-124000/app/workers/recompute.py

### 2. AST PATCH
BEFORE SHA256: c11180b688559acaa14b249b5052a2a60a08cb578217eda5b19d4cb5e15b9841
Existing SL-001 predicates: 0
select(FinancialPeriod) nodes: 1
security_id == security.id: True
period_type == "FY": True
period_end <= as_of: 0
Backup created: /data/files/bmw/stocklab-release-candidate-celery-20260910-124000/app/workers/recompute.py.before-sl001-ast
Exact source-line occurrences: 1
FAIL: resulting source does not contain exactly one SL-001 predicate. NO modification.

### 3. FINAL RC VERIFICATION
SL-001 occurrences: 0
AST parse: PASS
0004:             select(FinancialPeriod)
0005:             .where(FinancialPeriod.security_id == security.id, FinancialPeriod.period_type == "FY")
0006:             .order_by(FinancialPeriod.period_end.desc())
0007:             .limit(11)
0014:         db.execute(select(Price).where(Price.security_id == security.id).order_by(Price.date.desc()).limit(1))
SL-001 STATUS: FAIL

### 4. RC DIFF AGAINST PRE-SL001 BACKUP

### 5. FINAL HASHES
c11180b688559acaa14b249b5052a2a60a08cb578217eda5b19d4cb5e15b9841  /data/files/bmw/stocklab-release-candidate-celery-20260910-124000/app/workers/recompute.py
c11180b688559acaa14b249b5052a2a60a08cb578217eda5b19d4cb5e15b9841  /data/files/bmw/stocklab-release-candidate-celery-20260910-124000/app/workers/recompute.py.before-sl001-ast

### 6. PRODUCTION SAFETY CHECK
stocklab-redis	Up 28 hours (healthy)	docker.io/library/redis:7-alpine	6379/tcp
stocklab-db	Up 27 hours (healthy)	docker.io/library/postgres:16-alpine	5432/tcp
stocklab-release-qa-redis	Up 21 hours	docker.io/library/redis:7	127.0.0.1:56379->6379/tcp
stocklab-frontend	Up 19 hours (healthy)	localhost/stocklab-frontend:release-qa-20260909-182234	3000/tcp
stocklab-backend	Up 16 hours (healthy)	localhost/stocklab-backend:screener-percent-final-20260909-194639	8000/tcp
stocklab-worker	Up 16 hours (healthy)	localhost/stocklab-backend:screener-percent-final-20260909-194639	8000/tcp
stocklab-beat	Up 16 hours	localhost/stocklab-backend:screener-percent-final-20260909-194639	8000/tcp

stocklab-backend image=localhost/stocklab-backend:screener-percent-final-20260909-194639 restart=0
stocklab-worker image=localhost/stocklab-backend:screener-percent-final-20260909-194639 restart=0
stocklab-beat image=localhost/stocklab-backend:screener-percent-final-20260909-194639 restart=0

============================================================
 DONE
 Production was NOT restarted/rebuilt.
 PostgreSQL was NOT written.
 Redis was NOT written.
 LOG: /data/files/bmw/stocklab-sl001-ast-final-20260910-101306.log
============================================================