D1 - There was a problem restoring your database, please try again later

What is the error number?

7500

What is the error message?

There was a problem restoring your database, please try again later

What is the issue or error you’re encountering

Inaccurate Time Travel Rollback in D1 Leading to Data Loss​

What are the steps to reproduce the issue?

We recently attempted to roll back our database by 30 minutes, but encountered persistent issues. Both the CLI and UI methods resulted in error messages. We then incrementally tried to roll back by 1 hour, 2 hours, up to 8 hours, with each attempt also resulting in an error message.

Despite these error messages, we later discovered that the database had actually rolled back by 8 hours. This unexpected behavior caused a significant loss of user data, far exceeding our intended rollback of just 30 minutes.

The built-in backup functionality seems faulty, and there is no alternative method to export data from the database.

Screenshot of the error

Hi there,

Have you tried Time Travel to restore the database to a point in time shortly before this happened?