{question}
I am trying to restore a database backup and hitting the error below. Why can't I successfully restore, and what does this error mean?
ERROR 1832 (HY000): Restoring partitions on `<DB_NAME>`. Couldn't find backup file for partition 0 of database.
{question}
{answer}
SingleStore is a distributed database where each database spans multiple nodes and hosts. In order to make backup and restore operations as fast as possible, each node is taking its own part of the backup or restore procedure. The process takes a backup or restores partitions stored on a node simultaneously as on other nodes, in parallel.
For this reason, it is always necessary that the backup destination drive is accessible from all nodes in the cluster, and this backup destination uses precisely the same path on every node.
ERROR 1832 (HY000): Restoring partitions on `<DB_NAME>`. Couldn't find backup file for partition 0 of database.
In the vast majority of cases, this error means that some of the nodes were not able to find the backup files so the restore of the database can't start.
To fix this error, make sure that:
- The backup drive is mounted / accessible from ALL nodes in the cluster.
- The path to the backup drive is exactly the same on every node in the cluster.
- The permissions of the backup files and the directory where the files are placed allow the OS user running the `memsqld` process to access the backup files.
{answer}