Audit log backfill from request history

Project: Engineering
Type: Story
Status: Done Done
Priority: High
Reporter: Lukas Brandt <lukas.brandt@acme-hq.example>
Assignee: Marek Nowak <marek.nowak@acme-hq.example>
Labels: audit-log
Components: identity-service
Fix versions: identity-service 2026.08.13
Sprint: Sprint 48
Story points: 3
Parent: ENG-1510 Approvals audit log
Created: 30 Jul 2026, 08:51 UTC
Updated: 14 Aug 2026, 07:00 UTC
Resolved: 14 Aug 2026, 07:00 UTC

Description

Mira's call: the log shouldn't start empty. Piet's script (in his handover, ENG-1565) writes past decisions into the audit log from each request's history.

Acceptance criteria

Every decision since January 2025, per region, run once with the release.
Each entry marked "from request history": who decided, when, approve or refuse; the reason from 29 July; no address (never kept).
The nightly 400-day job treats them like any other entry.

Linked issues

relates to ENG-1510 Approvals audit log Done
relates to ENG-1565 Piet's last week: hand the Textbridge and Mailcrest code in notifier to Elif Done
relates to SUP-1098 Vossberg: All requests times out Done
relates to ENG-1626 Audit log backfill holds locks on access requests: commit every 5,000 rows Done

Comments (3)

Marek Nowak · 31 Jul 2026, 07:20 UTC

Ready. Rehearsed on copies next week.

Elif Yildiz · 13 Aug 2026, 06:15 UTCInternal note

EU run held locks on access requests from 07:12 to 07:33 (SUP-1098); stopped at 07:26. UK and US ran clean. Batching in ENG-1626, EU rerun tonight at 19:00.

Marek Nowak · 14 Aug 2026, 07:00 UTC

EU rerun 19:00 to 19:40. Last night's 400-day run trimmed the backfill to decisions from 9 July 2025, as planned.