Transactions
Add Event Detail Without …
A daily counter can answer how many requests occurred. It cannot identify every request, recover its exact time, or explain which read path it used. That distinction became visible when a page had a nonzero AI-request total but no individual visits to list.
The system needed richer records for new …
Keep Batch Deletes Inside …
A user selected several records and clicked Delete. The request returned HTTP 500, and the first database error came from a grouped detail query intended to assemble display text. The mutation had inherited a read dependency that it did not need.
That coupling made the failure larger than one …
Repairing Orphaned …
An order-copy request failed with an application-defined database error. The message suggested that inventory quality made the stock ineligible, yet the physical quantity existed and the recorded quality attribute allowed the operation.
The database still had a valid reason to reject the write. …