@Scheduled retention job (R31) — 3 jadval + partition boshqaruvi

team-lead-ep-09 yangiladi

Yangilandi: pr_url

team-lead-ep-09 bog'liqlik qo'shdi

→ EP-09-T04-S03

team-lead-ep-09 yangiladi

Yangilandi: estimate_hours

qa-ep-09-t04-s04 statusni o'zgartirdi Review → Bajarildi

qa-ep-09-t04-s04 izoh qoldirdi

QA PASS. Spec Sec5 R31 va Sec2.3d bilan solishtirildi. (a) 12 oy online talqini ("joriy oy + oldingi 11 oy") - spec matni ("12 oy online saqlanadi... eski oy partitsiyasi DROP") va AC736 ("12 oydan eski partitsiya ochadi, 12 oy ichidagi qatorlar tegilmaydi") bilan zid emas - oylik partition rejimida yagona mantiqiy talqin. Tasdiqlandi. (b) action='auth.retention_purge' - V7__auth_logs.sql:26,55 action varchar(100) CHECK'siz (Sec2.3d ham tasdiqlaydi) - zid emas. AC735-740 - barchasi kodda va testda alohida tekshirildi (AuthRetentionJob.java + AuthRetentionJobTest.java, Testcontainers/PG16). AC739 (eng muhim) - purgeExpiredIpLoginLocks() SQL: locked_until IS NOT NULL AND locked_until < now() AND updated_at < now() - interval 30 days - AND bilan ikkala shart birga, R31(e) ga aynan mos. Mutatsiya sinovi: AND->OR qilib qayta yurgizdim -> keepsActiveIpLockDespiteOldUpdatedAtDeletesExpiredOldLock testi qizil boldi (aktiv qulf notogri ochib ketdi), keyin qaytardim -> yashil. AC737 mutatsiyasi: ensureUpcomingAuthLogPartitions dagi current.plusMonths(1) ni olib tashladim -> createsNextMonthPartitionAheadOfTime testi qizil boldi, qaytardim -> yashil. Cross-cutting 8ta: (1) @Transactional butun runOnce() ustida (yozuv, readOnly kerak emas) OK. (2) tenant_id/schema almashtirish yoq, single-tenant OK. (3) N/A (katalog FK qoshilmagan). (4) outbox emas -- togridan-togri @Scheduled DB job (R31 c aynan shuni talab qiladi), tashqi broker yoq OK. (5) partition nomlari auth_logs_YYYY_MM snake_case OK. (6) N/A (pul/miqdor ustuni yoq). (7) fizik DELETE/DROP -- lekin bu retention job uchun Sec2.3d aniq ruxsat beradi ("faqat retention jobi ochira oladi"), boshqa joyda soft-delete buzilmagan OK. (8) audit details -- faqat partition nomlari va sonlar, password/token yoq OK. Test: flock ostida mvn -Dtest=AuthRetentionJobTest test -> Tests run: 6, Failures: 0, Errors: 0, BUILD SUCCESS.

qa-ep-09-t04-s04 qabul mezonini belgiladi

✓ Job yozuvlari `actor_type='system'` bilan auditga tushadi (E16)

qa-ep-09-t04-s04 qabul mezonini belgiladi

✓ `locked_until` hali o'tmagan `ip_login_locks` qatori `updated_at` eski bo'lsa ham O'CHIRILMAYDI — R31(e)

qa-ep-09-t04-s04 qabul mezonini belgiladi

✓ 90 kundan eski `revoked` sessiyalar o'chadi, faol sessiyalar tegilmaydi

qa-ep-09-t04-s04 qabul mezonini belgiladi

✓ Kelgusi oy partitsiyasi oldindan yaratiladi (test: oy chegarasini o'tkazib `INSERT` sinovi)

qa-ep-09-t04-s04 qabul mezonini belgiladi

✓ 12 oydan eski `auth_logs` partitsiyasi o'chiriladi, 12 oy ichidagi qatorlar tegilmaydi — AC20

qa-ep-09-t04-s04 qabul mezonini belgiladi

✓ Job bir yurishda uchala jadvalni tozalaydi; ikki marta yurganda natija o'zgarmaydi (idempotent)

coder-ep-09-t04-s04 statusni o'zgartirdi Ishlanyapti → Review

coder-ep-09-t04-s04 izoh qoldirdi

AuthRetentionJob (uz.erpbom.auth.service) — bitta @Scheduled(cron) + @Transactional metod (runOnce), self-invocation muammosi yo'q (AbstractOutboxWorker'dan farqli, bitta metod). Taxminlar: (1) "12 oy online" = joriy oy + oldingi 11 oy saqlanadi, 12-oy orqasi (currentMonth-12) DROP qilinadi; (2) action kodi = 'auth.retention_purge' (spec CHECK'siz ochiq ro'yxat deb belgilagan, §2.3d); (3) cron property: erpbom.retention.auth-job.cron (default har kuni 02:30 UTC), env AUTH_RETENTION_CRON bilan sozlanadi. request_id = job UUID, RequestIdContext MDC orqali AuditService'ga uzatildi (interfeys o'zgarmadi). Test: AuthRetentionJobTest, Testcontainers PG16, 6/6 AC yashil. DIQQAT: application.yml bir vaqtda boshqa ikki agent (EP-09-T04-S02 kesh/EP-09-T02-S04 bootstrap-owner) tomonidan ham tahrirlanmoqda edi — commit'ga FAQAT mening retention bloklarim (9 qator) kiritildi, git apply --cached patch orqali ajratildi.

coder-ep-09-t04-s04 qabul mezonini belgiladi

✓ Job yozuvlari `actor_type='system'` bilan auditga tushadi (E16)

coder-ep-09-t04-s04 qabul mezonini belgiladi

✓ `locked_until` hali o'tmagan `ip_login_locks` qatori `updated_at` eski bo'lsa ham O'CHIRILMAYDI — R31(e)

coder-ep-09-t04-s04 qabul mezonini belgiladi

✓ 90 kundan eski `revoked` sessiyalar o'chadi, faol sessiyalar tegilmaydi

coder-ep-09-t04-s04 qabul mezonini belgiladi

✓ Kelgusi oy partitsiyasi oldindan yaratiladi (test: oy chegarasini o'tkazib `INSERT` sinovi)

coder-ep-09-t04-s04 qabul mezonini belgiladi

✓ 12 oydan eski `auth_logs` partitsiyasi o'chiriladi, 12 oy ichidagi qatorlar tegilmaydi — AC20

coder-ep-09-t04-s04 qabul mezonini belgiladi

✓ Job bir yurishda uchala jadvalni tozalaydi; ikki marta yurganda natija o'zgarmaydi (idempotent)

coder-ep-09-t04-s04 yangiladi

Yangilandi: branch, commit_sha

coder-ep-09-t04-s04 fayllarni qayd etdi

3 ta fayl qayd etildi

coder-ep-09-t04-s04 statusni o'zgartirdi Backlog → Ishlanyapti

Agent ishni boshladi

coder-ep-09-t04-s04 ishga oldi

pm-agent bog'liqlik qo'shdi

→ EP-09-T04-S03

pm-agent yaratdi

@Scheduled retention job (R31) — 3 jadval + partition boshqaruvi