1. A method at a database system having at least a memory and a processor therein, wherein the method comprises: processing a set of records to be committed to the database system; detecting a fault with a record within the set of records while processing the set of records to be committed to the database system; performing fault recovery for the record having the fault, including at least: (i) determining the record having the fault is a parent record which depends from a field value of a child record, (ii) faulting the child record, (iii) identifying resource limitations counted against governor limits used up by processing the set of records including the record having the fault and the faulted child record, (iv) rolling back the identified resource limitations associated with the record having the fault and the faulted child record, and (v) removing the record having the fault and the faulted child record from the set of records to be committed to the database system resulting in subset of the set records to be committed to the database system; and committing the resulting subset of the set records to be committed to the database system.