IDEMPOTENCE FOR DATABASE TRANSACTIONS

A method, machine, and computer-readable medium are provided. A server receives, from a client, a request for an outcome of an identified set of one or more commands that were previously sent by the client in a session. The identified set of one or more commands, if completed in the session, would cause performance of a first server operation that commits a transaction, and a second server operation that sends, to the client, an indication that the identified set of one or more commands has committed. The server determines that at least one transaction caused by the identified set of one or more commands has committed and whether any transactions caused by the identified set of one or more commands has not committed. Based at least in part on this determination, the server sends, to the client, a response to the request that indicates that at least one transaction in the identified set of one or more commands has committed but that at least one other transaction in the identified set of one or more commands has not committed.