page-lsn · shipping · also pageLSN, page_LSN

Page LSN

A page LSN records the log sequence number of the latest logged change reflected in a database page under the engine's recovery protocol.

In original ARIES, redo uses the page LSN, after dirty-page-table and recovery-LSN filtering, to avoid reapplying an update already present on the page. The page state and its LSN must agree; the number alone does not detect torn or corrupt pages. Undo does not reuse that redo test: history has first been repeated, and compensation records track rollback progress. [1] A page LSN is not the global durable-log flush position or a timestamp, and this description must not be generalized to every engine. [2]

Relations

related

log-sequence-number, write-ahead-log, compensation-log-record, torn-write, fuzzy-checkpoint

Citations

1. Mohan, Haderle, Lindsay, Pirahesh and Schwarz. ARIES. ACM TODS 17(1), 1992, sections 3, 5.2 and 6.2-6.3. (accessed 2026-10-15)
2. C. Mohan. Repeating History Beyond ARIES. VLDB 1999, sections 3.2.1-3.2.2. (accessed 2026-10-15)
3. Hesela: ARIES rollback progress, with a synthetic executable trace (accessed 2026-10-15)

JSON: /data/terms/page-lsn.json