1. A method performed in a host system having a database therein to store rows and a processor to execute operations, wherein the method comprises: saving a plurality of rows in the database as a set of rows, wherein one or more of the plurality of rows is associated with at least one side effect that is triggered to execute prior to saving or after saving but prior to committing the one or more rows, and wherein the one or more side effects comprises at least one of a pre-operation trigger, a post-operation trigger, or a code snippet; determining that one or more faults has occurred in saving the set of rows in the database; rolling back the set of rows to a known start state; rolling back any side effects that were permitted to execute; rolling back any resource usage counted against governor limits by executing side effects; forming a new set of rows at the known start state including any of the plurality of rows which are not associated with the one or more faults having occurred when saving the set of rows in the database by removing all rows associated with the one or more faults during the saving of the set of rows in the database; saving the new set of rows in the database from the known start state without fault; and updating resources used and checking against governor limits.