Hi @Lubos,
I have just sent an urgent email regarding a Manager Cloud database that became inaccessible after running Vacuum.
The issue is affecting only one business in our Cloud account. We received a “database is locked” message, and now the business only shows 0% – 0/0 and cannot be opened.
This is our primary accounting database. I would greatly appreciate it if you could please review our email when you have a chance.
Thank you very much.
Hello @Jade,
Welcome to the forum.
Unfortunately, altering the database will render it unusable.
While Manager uses SQLite, Manager isn’t a relational database, it is an object database at it’s core, so using relational database facilities like vacuum is likely to break the data file.
You need to import an unvacuumed version of your data file.
In case you need to save some space, you can backup without attachments.
Hi @Ealfardan,
Thank you for your response.
We are using Manager Cloud and, unfortunately, we do not have an unvacuumed backup of this business.
Since the database is hosted on Manager Cloud, could you please check if there are any server-side backups, snapshots, or recovery options available for our account prior to the VACUUM operation?
This is our primary accounting database, and only this one business is affected. We would be extremely grateful if there is any possibility of restoring it.
Thank you very much for your time and assistance.
Sorry @Ealfardan but Vacuum function is part of Manager, one can execute this by clicking on the Database size like in example, see screenshots, clicking on the 1 Mb:
opens the vacuum window:
This vacuum has been a feature ever since I started using Manager.
Hi @eko,
Thank you for pointing that out. That is exactly what happened in our case.
We did not use any external SQLite tools or modify the database manually. We simply used the Vacuum function that is built into Manager Cloud from the database size page.
After the process, the database became inaccessible, showed a “database is locked” message, and now only displays 0% – 0/0.
Since this was performed using a built-in Manager feature, we are hoping the Manager team can investigate whether this is an unexpected issue and whether there are any recovery options available for our cloud database.
Thank you again for bringing this up.
I would also like to clarify that we did not intentionally modify the database using any external tools. We simply used the built-in Vacuum function available in Manager Cloud.
Our business relies entirely on Manager Cloud, and we do not have any local backups or exported copies because all of our accounting data is stored there.
If there is any possibility of recovering the database from your side, such as an internal backup or snapshot, we would be sincerely grateful. We have already sent our account details by email for your review.
Thank you again for your time and assistance.
Try restarting the server first. In many cases, this will release the lock left after a VACUUM.
If the issue persists, it likely means the database remains locked or corrupted. At that point, you’ll need developer @Lubos assistance to restore the database from a snapshot/backup.
