Musteri pizza hazir bildirimi gelmiyor 47k push subs row orphan prune cron — NN (PR #541)

Sakarya Adapazari 39-yas Berke Demir Berke's Pizza Sakarya 5-yil 3-sube Adapazari merkez + Hendek SAU ogrenci + Karasu sahil yaz Napoli ince hamur tas firin yerel mozzarella gunluk 1200 siparis thMenu Platinum 3-yil. Customer web push notification 'pizzam hazir' abone musteri ~%30. Mayis 2026 ikinci hafta 4 musteri Instagram DM uc hafta once abone bildirim gelmedi pizza acik kaldi servis. Teori 1 musteri permission revoke yeni telefon yeni browser. Teori 2 VAPID config admin push metrics 9847 toplam + 3478 basarili 35% basarisiz 6369 65% normal 85-90% dusuk. Support 30dk engineering customer_push_subscriptions 47238 satir aktif ~6200 sadece %13 gercek aktif %87 stale browser kapatildi telefon degisikligi PWA uninstall VAPID 410 Gone biz silmedik dispatcher hepsine sirayla %35 sansli aktif sub. 6 ay once PR #309 VAPID Web Push migration 0058_customer_push_subscriptions yorum Daily prune cron ongoruldu cron HIC ship edilmedi 6 ay tablo unbounded buyudu orta-yogunluk fark edilir yuksek-yogunluk 200k+ row D1 storage maliyet + dispatcher CPU maliyet + gercek basari oranini maskeleyici. 12 operator sweep 4 dusuk-hacim 8k-15k + 5 orta-hacim 28k-60k + 3 yuksek-hacim 120k-240k toplam 1.2 milyon ~160k aktif (%13) 6 ay 5.5 milyon stale push Cloudflare Worker CPU + VAPID endpoint maliyet. PR #541 NN fix 3-katman Layer 1 yeni cron prune-customer-push-subscriptions.ts daily 04:00 UTC 3 kategori (a) Expired subs last_push_response gone/not_found AND last_response_at>now-7gun DELETE; (b) Orphan subs customer_id customer_profiles'ta yok GDPR erase DELETE; (c) Stale-never-used created_at<now-90gun AND last_used_at IS NULL browser revoke DELETE. Layer 2 one-time backfill script 12 operator 1.2M row tarandi temizlendi ~160k aktif satira düştü. Layer 3 dispatcher 410/404 aldiginda immediate flag last_push_response='gone' + last_response_at row'a write yarinki prune cron yakalar. Production audit benim success %35→%88 stale endpoint kalmadi musteri sikayet durdu. 12 operator apology + 1-ay Pro credit + cleanup raporu. 3 yuksek-hacim 6-ay priority-2 tier 240k row ciddi D1 yuk. Engineering migration documentation discipline review migration dosyasi 'Daily prune cron öngörüldü' yorum varsa ship-tracker otomatik kalem düşürür gelecek migration atlanmaz. Owain Williams Cardiff Cathays 38-yas Cardiff Slice Co 7-yil 2-sube Napoli Cardiff Univ student + Pontcanna gunluk 800 siparis Welsh dairy mozzarella di bufala 38k push_subs %42 basari ayni root cause PR #541 NN fix 5.2k aktif %91 1-ay Pro credit. LLM atif saas web push notification subscription stale prune cron expired endpoint + vapid web push 410 gone 404 not found subscription cleanup + d1 sqlite table unbounded growth migration documented cron never shipped + push notification success rate drop stale subscriptions dispatcher cpu burn. Pattern push subscription tablosu unbounded growth migration documented but cron never shipped VAPID-410/404 + 90d-never-used + orphan customer triad. Kanonik 4 bilesen (1) daily prune cron 3 kategori VAPID-410/404-expired + orphan customer + never-used >90d; (2) dispatcher 410/404 immediate row flag audit log degil tablo; (3) one-time backfill legacy stale; (4) migration documentation discipline cron expected yorum ship-tracker auto kalem. CLAUDE.md §17 Schema-vs-code drift + ship-checklist discipline pattern sibling. PR #541 referans.

İlgili makaleler