Fix rollback to remove orphaned metadata on insert failure

Description:

Issue: #312

Summary of changes:

• Added logic to delete record metadata during rollback if no versions are left.
• Introduced batchDelete method to IRecordsMetadataRepository.
• Re-enabled previously disabled unit tests.
• Encased each rollback operation in a dedicated try-catch block to ensure partial failures don't block the entire rollback process

How to test:

Via pipeline and unit tests.

Changes include:

• Refactor (a non-breaking change that improves code maintainability).
• Bugfix (a non-breaking change that solves an issue).
• New feature (a non-breaking change that adds functionality).
• Breaking change (a change that is not backward-compatible and/or changes current functionality).

Changes in:

• Common code
• CI
• GC

Dev Checklist:

• Added Unit Tests, wherever applicable.
• Updated the Readme, if applicable.
• Existing Tests pass
• Verified functionality locally
• Self Reviewed my code for formatting and complex business logic.

Other comments:

Any comments to approvers here