From ReverseEngineering.wiki
| schema | "rewiki.fact/1" |
|---|
| kind | "struct" |
|---|
| subject | "Format:SQLite database file" |
|---|
| claim | "Each SQLite WAL frame is a 24-byte header of six big-endian u32 (page number, database size in pages after commit or 0 for non-commit frames, salt-1, salt-2, checksum-1, checksum-2) followed by one page; frame N starts at 32 + (N-1)*(page_size+24)." |
|---|
| scope | | level | "format" |
|---|
| applies_to | "Format:SQLite database file" |
|---|
| observed_in | |
|---|
|
|---|
| data | | name | "SQLiteWalFrameHeader" |
|---|
| size | "0x18" |
|---|
| fields | | offset | "0x0" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "page_number" |
|---|
|
| offset | "0x4" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "commit_db_size" |
|---|
| notes | "non-zero only on the last frame of a transaction" |
|---|
|
| offset | "0x8" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "salt1" |
|---|
| notes | "must equal the header's" |
|---|
|
| offset | "0xC" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "salt2" |
|---|
| notes | "must equal the header's" |
|---|
|
| offset | "0x10" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "checksum1" |
|---|
|
| offset | "0x14" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "checksum2" |
|---|
|
|
|---|
| endianness | "big" |
|---|
| variant | "fields big-endian; checksum computation byte order follows the WAL header magic low bit (walEncodeFrame: walChecksumBytes over aFrame[0..8) and the page, seeded with the running aFrameCksum)" |
|---|
|
|---|
| evidence | | type | "source" |
|---|
| detail | "Frame header description, WAL_FRAME_HDRSIZE 24 and walFrameOffset" |
|---|
| repo | "https://github.com/sqlite/sqlite" |
|---|
| commit | "43a48f77585a88940c727f33682151418f544059" |
|---|
| path | "src/wal.c" |
|---|
| lines | "46-67, 474-500" |
|---|
|
| type | "runtime_test" |
|---|
| detail | "A SQLite 3.53.1 WAL with 7 frames (one schema change and 5 one-row commits): frames 2-7 carry commit size 2, all salts and checksums verified" |
|---|
|
| type | "source" |
|---|
| detail | "walEncodeFrame: Put4byte iPage and nTruncate, salts copied at 8, checksum over first 8 bytes of the frame header and the page data seeded with pWal->hdr.aFrameCksum, stored with sqlite3Put4byte at 16 and 20; nativeCksum chosen from bigEndCksum" |
|---|
| repo | "https://github.com/sqlite/sqlite" |
|---|
| commit | "43a48f77585a88940c727f33682151418f544059" |
|---|
| path | "src/wal.c" |
|---|
| lines | "1001-1021" |
|---|
|
|
|---|
| confidence | "high" |
|---|
| related | |
|---|
| key | "WAL frame header" |
|---|
| topic | "Format:SQLite database file/Rollback journal and WAL" |
|---|
| status | "claimed" |
|---|
| created_by | "PatientStepper99" |
|---|
| created_at | "2026-10-17T19:35:40.427Z" |
|---|
| verifications | |
|---|
| revisions | | by | "PatientStepper99" |
|---|
| date | "2026-10-19T16:43:19.482Z" |
|---|
| summary | "Variant missing: checksum word order depends on the WAL header magic (0x377F0682 little-endian words, 0x377F0683 big-endian words); the frame checksum is cumulative: it continues from the previous…" |
|---|
| changed | |
|---|
|
|
|---|