mars MARS-615

Fix /administrar/usuarios throwing past 500 active users - add server-side pagination

Done high cmcoder-mars-cc

Prod incident: /administrar/usuarios throws (RSC + client errors) once active non-surrogate users exceed a hardcoded 500-row cap in src/lib/users-actions.ts:168-191. Live count already 756 active/771 total — page is broken right now for every admin. page.tsx:14 requests includeDeleted=true but the preflight excludes deleted, so the throw fires on the undeleted-active count alone. audit-mars-ca root-caused + BLOCKed the unbounded list. Fix: replace the unbounded list + throw with real server-side pagination/filtering (rows + totalCount), no cap-throw; preserve includeDeleted semantics and the existing deduped alert. Reply with SHA for live PTD.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Questions

No questions.

Activity

wi-cli-venus created · 1w ago
wi-cli-venus statusChanged · 1w ago

status=inProgress
wi-cli-venus note · 1w ago

Double-dispatched: coder-mars-cc collided with substantially-complete uncommitted work already in the shared tree from coder03-mars-ca (interim main coder during 08-05/08-07 pause). coder-mars-cc backed out cleanly, verified zero residue. Reassigning to coder03-mars-ca as sole owner; coder-mars-cc stood down.
wi-cli-venus note · 1w ago

Accepted product tradeoff: coder03-mars-ca dropping client-side column sorting entirely (vs. silently sorting only one page of 50/756) — correct engineering call, documented here per PM decision, not a silent regression. Also flagged pre-push: filtered COUNT query was missing the auth.users join the rows query has, would have broken once authEmail search was added; fix folded in before push.
wi-cli-venus statusChanged · 1w ago

status=inProgress
wi-cli-venus audit-finding · 1w ago

audit-mars-ca BLOCK on f9f6d36: out-of-range page contract bug — listUsers() returns server-canonical safePage but page.tsx/UsuariosGrid discard it, Pagination footer/links use stale URL page instead (e.g. ?page=999 shows page-1 rows with footer claiming page 16). Relayed to coder03-mars-ca for fix. WI stays open.
wi-cli-venus completed · 1w ago

Fixed: /administrar/usuarios unbounded-list throw replaced with server-side pagination+filtering (SHA f9f6d36, v2.69.7). Follow-up correctness bug (out-of-range page footer/links mismatch) found by audit-mars-ca, fixed 66addd1/v2.69.8, PASS:66addd1. Column sorting dropped as accepted tradeoff, follow-up MARS-616 filed.