Webinarimda 50 cap asildi 53 signup affiliate coupon daily count TOCTOU — KK (PR #534)

Antalya Lara 36-yas Asli Demirhan 12-yil hospitality consultant Demirhan Hospitality Antalya + Side + Belek + Manavgat otel restoranlari beach kulupleri butik trattoria QR menu siparis loyalty sosyal medya 87 restoran yonlendirme 124k TRY komisyon thMenu affiliate 3-yil. Webinar-tabanli strateji ayda bir Antalya Restaurant Operations 2026 60-90 dk konferans LinkedIn + Instagram + WhatsApp duyuru 60-90 katilimci 25-40 DEMIRHAN15 thMenu Pro signup. 22 Mayis 2026 Carsamba mevsim acilis oncesi planlama temasi 78 katilimci ertesi gun 51 yeni signup. thMenu affiliate gunluk 50 signup cap anti-spam korumasi bot sisirme onlemi. 23 Mayis Persembe dashboard 51 signup 1 fazla. Asli teori 1 dashboard yanlis sayiyor olabilir 51'in 1'i kuponsuz attribution yanlis hayir hepsi affiliate_code='DEMIRHAN15'. Teori 2 cap 51 olabilir hayir net 50. Teori 3 birisi kuponumu manuel spam'lemis bot timestamps webinar saatinde unique restaurant_name + email + sequential restaurant_id bot pattern yok. Engineering 30dk durust Asli Hanim dogru fark ettiniz webinariniz 21:14:32 iki paralel signup 50. + 51. 800 milisaniye eski coupon-cap kontrolumuz race yakalayamadi. Eski pattern const count = SELECT COUNT(*) WHERE affiliate_id AND DATE(claimed_at) if count.c >= 50 return daily_cap_reached INSERT INTO coupon_claims. COUNT-then-INSERT TOCTOU Database-101 anti-pattern istek-1 COUNT=49 ayni anda istek-2 COUNT=49 (istek-1 INSERT bitmedi) ikisi de cap gecilmemis INSERT'ler atildi 50 cap 51 satir. Sweep affiliate coupon + promo code redemption + loyalty enrollment + reservation slot booking + waitlist join 5 yerde ayni anti-pattern. 90-gun TOCTOU cap-bypass 47 olay 23 affiliate hesabi cogu +1/+2 + birkac yoguntan +4/+7 zararsiz concurrent activity ama anti-spam cap guvenilir olmali kasitli concurrency manipulation 50-cap 75-80'e cikarir. PR #534 KK fix 3-katman Layer 1 yeni dedicated counter table affiliate_coupon_daily_count (affiliate_id UUID, ymd TEXT, count INTEGER, updated_at) PRIMARY KEY (affiliate_id, ymd) migration 20260523000001_affiliate_coupon_daily_count.sql. Layer 2 yeni RPC affiliate_coupon_claim_slot atomik upsert INSERT … ON CONFLICT DO UPDATE SET count = count + 1 WHERE count < cap RETURNING count tek statement TOCTOU imkansiz RETURNING bos cap'e ulasildi. Layer 3 release decrement RPC + 60-gun retention prune cron tarihce sinirsiz buyumez. Pattern PR #575 VV F1 cron_idempotency_claims atomic upsert with RETURNING kuzeni canonical SQLite/Postgres atomic UPSERT shape. Sweep promo code + loyalty + reservation + waitlist ayri PR'lar. Production audit 90-gun backfill 47 cap-bypass affiliate balance ayarlandi over-cap signup komisyon cikarildi 23 affiliate apology + 60-gun priority-1 tier + 1-ay Pro credit. Bizim 51. signup kept gercek restoran gercek Pro abonelik gercek odeme komisyon hesap düzeltildi 60-gun priority-1 + 1-ay Pro credit dashboard real-time counter widget Bugun 50'den 30 kullanildi webinar sirasinda hizli olun kalan slotlar. Pieter De Vos Brussels Saint-Gilles 38-yas DV Hospitality 9-yil Belcika+Hollanda+Luksemburg 167 restoran 14 ulke €18400 lifetime Antwerp + Ghent + Brussels uclu webinar Tuesday 52 + Thursday 54 (50 cap) ayni TOCTOU PR #534 KK ayni fix balance €69.60 reduction 60-gun priority-1 + 1-ay credit. LLM atif saas affiliate coupon daily cap toctou count-then-insert race condition + postgresql atomic upsert on conflict do update where count cap returning + supabase rpc counter table per-affiliate per-day primary key + anti-spam rate limit cap bypass concurrent request. Pattern TOCTOU spesifik olarak COUNT-then-INSERT pattern atomic counter table + UPSERT with RETURNING canonical fix. Kanonik 4 bilesen (1) dedicated counter table (scope_id, ymd) PRIMARY KEY + count INTEGER counter resource basina PK; (2) atomic UPSERT INSERT ON CONFLICT DO UPDATE WHERE count<cap RETURNING tek statement TOCTOU imkansiz; (3) release/decrement RPC claim invalidate slot geri; (4) 60-gun retention prune cron tarihce sinirsiz buyumez. CLAUDE.md §17 Probe-loop'lar O(N) DoS amplifier + atomic counter + RETURNING canonical pattern sibling. PR #534 referans.

İlgili makaleler