database disk image is malformed Error opening database

This site is best viewed in a modern browser with JavaScript enabled.

database disk image is malformed Error opening database

Bond0102

Hi,
I have encountered the database corruption when running my application in virtual machine.
When try to open the database, it complains about the error in the title.

The only way to recover is to remove the -loc file but then all the changes I have made have been lost.

What would causing the database corruption and how to recover?

Thanks.

Bernardo

Hello!

So it appears that the corruption is on the -loc file, that is a WAL file

I suspect that the only known thing that can cause db corruption of SQLite database is opening the file via a network share. Are you doing that?

If not, is it possible to reproduce the problem?

I don't know what "title" is in "error in the title"

Are you sure that only a single app is accessing the database?

Please share more details, like the OS in the VM, the URI you use to open the db, etc.

Bond0102

Hi,

Yes, you're right. The database is located on the network drive.
May I know why would open the file via network drive will lead to file corruption?

If it happen again, is it possible to recover it?

The "error in the title" refer to "database disk image is malformed Error opening database"

Only single access to the database.
VM running in Windows 10.
Before the issue happened, I hibernate the VM by leaving the database connected. The next day I turned it on, then found it is corrupted and never can connect the database anymore.

Thanks.

Bernardo

You should not do it. One of the reasons the replication exists is exactly to avoid these problems.

You must have a running app on the device/machine in which the network share is located, and it must open the database locally. Then you can have another instance of the app running on the other device, connected to each other, and opening another local database.

This will solve the issue.