An operator rotated the vault keys and then deleted the old row from
The database uses SQLite in WAL mode, and this is a frame from
A write-ahead log stores the modified page in full, old content included. Find what the operator thought was gone.
vault_keys to "clean up". The table now looks like this:bash
id | rotated_at | label
---+-----------------------+---------------
3 | 2026-11-14T00:00:11Z | rotation-2026-11The 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.