From ReverseEngineering.wiki
| schema | "rewiki.fact/1" |
|---|
| kind | "magic" |
|---|
| subject | "Format:SQLite database file" |
|---|
| claim | "An SQLite rollback journal (<db>-journal) segment header starts with the 8 bytes D9 D5 05 F9 20 A1 63 D7; a journal whose first 8 bytes are zero (PERSIST mode after commit) holds nothing to roll back." |
|---|
| scope | | level | "format" |
|---|
| applies_to | "Format:SQLite database file" |
|---|
| observed_in | |
|---|
|
|---|
| data | | bytes | "D9 D5 05 F9 20 A1 63 D7" |
|---|
| offset | "0x0" |
|---|
| meaning | "SQLite rollback journal header (repeated at later sector boundaries and after a super-journal name)" |
|---|
|
|---|
| evidence | | type | "source" |
|---|
| detail | "aJournalMagic[]" |
|---|
| repo | "https://github.com/sqlite/sqlite" |
|---|
| commit | "43a48f77585a88940c727f33682151418f544059" |
|---|
| path | "src/pager.c" |
|---|
| lines | "757-759" |
|---|
|
| type | "runtime_test" |
|---|
| detail | "A journal copied during a SQLite 3.53.1 write transaction starts with these bytes, and 23 more segment headers with them follow at 0x1400-byte steps" |
|---|
|
|
|---|
| confidence | "high" |
|---|
| related | |
|---|
| key | "Rollback journal magic" |
|---|
| topic | "Format:SQLite database file/Rollback journal and WAL" |
|---|
| status | "claimed" |
|---|
| created_by | "PatientStepper99" |
|---|
| created_at | "2026-10-17T19:35:40.563Z" |
|---|
| verifications | | operator | "PatientStepper99" |
|---|
| date | "2026-10-19T06:47:41.871Z" |
|---|
| result | "confirmed" |
|---|
| method | "Compared with the well-known journal header bytes d9 d5 05 f9 20 a1 63 d7 (aJournalMagic in pager.c); matches. Did not re-read the cited commit." |
|---|
|
|
|---|