Try wrapping your insert query in a transaction. If insert fails, rollback transaction. At this point the database is returned to normal and you should be able to continue processing.

Charlie