[nullhaven]
All challenges
Forensics★★★☆☆100 pts

The row that was deleted

Godmode · 1d ago · 2 solved

An operator rotated the vault keys and then deleted the old row from vault_keys to "clean up". The table now looks like this:
bash
id | rotated_at            | label
---+-----------------------+---------------
 3 | 2026-11-14T00:00:11Z  | rotation-2026-11

The database uses SQLite in WAL mode, and this is a frame from -wal captured before the checkpoint:
r
00000000  53 51 4c 69 74 65 20 66  6f 72 6d 61 74 20 33 00  |SQLite format 3.|
00000010  02 00 10 00 00 00 00 00  00 00 00 00 0e 00 00 00  |................|
00000020  05 00 00 00 00 00 00 00  00 00 00 00 76 61 75 6c  |............vaul|
00000030  74 5f 6b 65 79 73 1f 05  05 00 15 01 81 01 07 17  |t_keys..........|
00000040  17 17 01 03 03 00 13 02  17 01 85 01 07 17 17 17  |................|
00000050  32 30 32 36 2d 31 30 2d  30 32 54 30 33 3a 31 32  |2026-10-02T03:12|
00000060  3a 34 34 5a 08 6c 65 67  61 63 79 2d 72 6f 74 61  |:44Z.legacy-rota|
00000070  74 69 6f 6e 14 00 00 00  00 00 00 00 00 00 00 00  |tion............|
00000080  6e 75 6c 6c 68 61 76 65  6e 7b 77 61 6c 5f 6b 65  |nullhaven{wal_ke|
00000090  65 70 73 5f 74 68 65 5f  6f 6c 64 5f 72 6f 77 7d  |eps_the_old_row}|
000000a0  22 61 63 74 69 76 65                              |"active|

A write-ahead log stores the modified page in full, old content included. Find what the operator thought was gone.

Submitting a flag needs an account

That's what records your points and lets you claim the first blood under your name.

Free, no e-mail verification. You land back on this challenge.

Solved by · 2

  1. 1
    ZE
    zeroD First blood1d ago
  2. 2
    JE
    Jetboy011d ago