feat: handle not ready events as recoverable errors

Add test cases to validate the handling of the not-ready-to-process-events scenario as a recoverable error. Update the error handling logic to include this new case, ensuring consistent error reporting for both ErrStatusRowLocked and ErrNotReadyToProcessEvents.