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. …