Tidy Library: Unexpected error when using Tidy Library option

[ifarzana]

CMS Version: 2.3.17 and 3.0.0

Issue: The Tidy Library function is attempting to remove media that is still being referenced by a saved report, which is not currently in use.

Steps:

1. Create a Report Schedule and Run task to generate a saved report
2. From the Report Schedule grid click on Reset to Previous run (which will make the saved report as unused)
3. Go to the Settings page
4. Click on Tidy Library
5. Check Remove all media not currently in use?
6. Click Yes

We encountered the following error:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (cms.saved_report, CONSTRAINT saved_report_ibfk_2 FOREIGN KEY (mediaId) REFERENCES media (mediaId))