Registry DB error - update failure

[meng.uom@…]

Hi, I wanted to update macports today, but got the following error message:

sqlite error: database disk image is malformed (11) while executing query: ATTACH DATABASE '/opt/local/var/macports/registry/registry.db' AS registry
    while executing
"registry::open $db_path"
    (procedure "mportinit" line 633)
    invoked from within
"mportinit ui_options global_options global_variations"
Error: /opt/local/bin/port: Failed to initialize MacPorts, sqlite error: database disk image is malformed (11) while executing query: ATTACH DATABASE '/opt/local/var/macports/registry/registry.db' AS registry

Is there any way to fix this issue?

Many thanks. :D

Sofia.

[neverpanic (Clemens Lang)]

I'm afraid there's probably no way to fix this. If you have a backup, try restoring /opt/local/var/macports/registry/registry.db. If you don't have a backup you'll probably need a re-install.

[pixilla (Bradley Giesbrecht)]

I have had some luck in the past open the db with sqlite and letting it repair what it knows how to repair.

This has worked for me in the past:

$ sudo sqlite3 /opt/local/var/macports/registry/registry.db
SQLite version 3.7.14 2012-09-03 15:42:36
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .quit
$

[neverpanic (Clemens Lang)]

There's nothing we can do about this, unfortunately.