Page two skipped four records
A list endpoint pages with an offset and a limit. Users report that scrolling occasionally shows the same row twice, and an export job silently missed several records entirely.
Nothing is broken in the query. Rows are being inserted while the client walks the pages, so by the time it asks for the next offset, everything has shifted underneath it.
Replace what the client sends to ask for the next page.
Components — tap one, then tap a slot on the diagram
!An export walked every page and still missed records. Others appeared twice.
Outside every boundary: Client (walking pages), Rows (being written to; FAILED: shifting), an empty slot for the how the next page is asked for Connections: Client calls how the next page is asked for (step 1) how the next page is asked for calls Rows — after this row (step 2)
Clientwalking pages
Rowsbeing written toshifting