Wise transfer 11 ay bekledi thMenu dormancy cron hesabimi zombiye cevirdi — in-flight payout gate (PR #598 AAA F3)

Sivas Merkez 39-yas freelance grafik tasarimci + komisyon pazarlamacisi Pelin @pelin-design 6-yil bagimsiz. 2024 Mart thMenu affiliate ilk 6 ay 3 restaurant referans $640 komisyon. Mart 2024 Wise ilk uluslararasi transfer talep Wise compliance review AML first-time international transfer. Pelin review devam ediyor email sonra unuttu aile sagligi + yeni full-time is + freelance geri plan. 11 ay sonra Subat 2026 geri donduğunde dashboard widget Hesabiniz anonimlestirildi geri yuklemek icin support yazin. Isim Deleted User #affiliate_4827 profile photo placeholder Wise IBAN bos AMA Wise transfer status: processing banner Mart 2024 transfer hala in flight. Pelin sok param mi kayboldu sonra supheli dormancy yuzunden anonimlestirildim mi sonra korku geri yukleme prosedur ne support yazdi 12 ay dokunmadim ama Wise pending. Engineering 3 soru (1) Pelin anonimlestirildi mi Supabase SELECT display_name email payout_info_id evet closeDormantAffiliates; (2) Wise hala processing mi GET /v1/transfers/{id} evet status processing amount $640 destination PELIN IBAN cached anonimlestirme oncesi compliance 11 ay devam; (3) tetikleyici audit log 2025-12-02 03:00 UTC closeDormantAffiliates affiliate_id pelin_id last_activity 2024-12-01 12 months elapsed action anonymise + purge payout_info. Uc evet Pelin anonimlestirildi Wise transfer in flight IBAN/ACH/recipient bilgisi silindi → Wise compliance bitirip transfer success olursa thMenu money movement recipientsiz isleyemez compliance reject ederse reversal yapmasi gereken hesap var ama destination bilgisi yok. Yanlis teori (1) D1 backup restore eski affiliate_payout_info Mart 2024 backup IBAN recover ama GDPR risky data subject right ihlal; (2) yeni signup transfer yeni hesaba bind Wise source-destination mismatch original Pelin Akin IBAN compliance reject. Dogru teori dormancy crona in-flight payout check eklenmeliydi onceden anonimlestirilmemeliydi transfer pending. Adli analiz cloudflare/src/cron-jobs/affiliate.ts:closeDormantAffiliates (1) last_activity_at < now - 12 months dormant affiliate cek; (2) iterate; (3) UPDATE affiliate_profiles SET display_name Deleted User + email NULL; (4) DELETE FROM affiliate_payout_info WHERE affiliate_id; (5) audit log. Eksik check affiliate_payouts.status IN (requested approved processing) rowlari varsa skip et. PR #593 ZZ F1 reverse_affiliate_payout RPC recipient olmadan reversal yapamaz Wise webhook funds_refunded/charged_back reverse handler SELECT iban NULL recipient_missing manuel intervention flag. Edge case zincir dormancy → anonymise → purge payout_info → in-flight payout reversal impossible Pelin $640 limbo. PR #598 batch AAA F3 3-katmanli fix Layer 1 batched in-flight payout fetch Supabase SELECT affiliate_id FROM affiliate_payouts WHERE status IN (requested approved processing) Set<affiliate_id> inFlightSet. Layer 2 iteration if inFlightSet.has(affiliate.id) skip dormancy in-flight payout continue. Layer 3 fetch fail soft-fail return early yanlis skip yapmak yanlis anonymise yapmaktan daha guvenli kaybedilmis dormancy 1 gun late kaybedilmis in-flight payout reversal hatasi kisisel veri karisir. Pelin manuel reconcile super-admin D1 backup affiliate_profiles restore + affiliate_payout_info eski IBAN reinsert + journal entry reconcile + money_movement_journal manual_reconcile entry. Email + Wise arrival + 1-yil Pro credit + Hall of Fame Twitter 1.6k. Production audit 24-ay dormancy cron audit log + affiliate_payouts in-flight cross-correlate 3 affiliate edge case manuel reconcile each. PR #598 deploy 7-ay 0 yeni incident. Rhys Cardiff Cathays food blogger scotsfood £580 summer 2024 Wise compliance review 12 ay paralel. Pattern irreversible state-change cron (anonymise archive purge hard-delete) in-flight external commitment check soft-fail skip retry. Wise + Stripe + ACH + PayPal + IRS 1099 + Resend her irreversible cron enumerate + skip-set. Sibling sweep process-deletions + prune-orphan-customer-artefacts + prune-affiliate-coupon-daily-count AAA-B. Implementation irreversible side-effect identify + batched fetch + skip-set + iteration skip + soft-fail + audit log skipped: in-flight + production audit cross-correlate + PR template checkbox. PR #598 referans.

İlgili makaleler