MacPorts reinstall : problem, sqlite error: database disk image is malformed

[gwilom@…]

Hello,

Due to a premature shutdown of my computer (battery), my macport registry is malformed : I execute :

sudo port selfupdate

and it the result

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 610)
    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 it possible to repair the database or reinstall port (the uninstall procedure doesn't work because of the registry problem) ?

for information, i try :

sudo port -fp uninstall installed

And this is the result :

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 610)
    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

Thanks for the help.

[mf2k (Frank Schima)]

Trac is not for tech support. Follow-up on the ​Macports Users mailing list instead.