database disk image is malformed

[Ryan Schmidt]

On Mar 27, 2020, at 17:07, Gael Arnaud wrote:

> Am facing an error with the following message each time I try to install a new port 
> 
> Error: rev-upgrade failed: sqlite error: database disk image is malformed (11) while executing query: SELECT id, path FROM registry.files WHERE active = '1' AND binary IS NULL
> Error: Follow https://guide.macports.org/#project.tickets to report a bug.
> 
> I Guess, I need to uninstall and reinstall macport, but before doing such a drastic step, I wanted to be sure there were no other ways to avoid this long and fastidious process.. 

There have been a few previous reports of this, and yes, in those cases, uninstalling and reinstalling was necessary, since there isn't a known way to uncorrupt a corrupted database. You could wait and see if somebody else has a better suggestion but I'm not sure there is one.

https://trac.macports.org/ticket/55942

SQLite is very old and well-tested software. On good hardware it should not corrupt databases, so the corruption could indicate a hardware problem, such as with your disk or memory. Or, if you are running in a virtual machine and the VM crashed or was turned off unexpectedly, it could indicate that the VM does not properly guarantee that writes to the virtual disk are propagated to the physical disk immediately.

http://sqlite.1065341.n5.nabble.com/Corrupted-database-On-tree-page-76852-cell-303-Rowid-18741471-out-of-order-td104891.html