sqlite error on self update

[joerg van den hoff]

no solution but a remark:

this looks like the registry.db sqlite database is really broken (that's what sqlite is telling you 
after all...).

sqlite has a reputation for being very resilient against database corruption. so my best guess would 
be hardware problems (power outage in the midst of an operation, disk error, something like that).

any further information when and how it happened?

since it seems that you have not installed too many ports, maybe starting over once again is the way 
to go? but maybe someone else has a better idea ....

joerg

On 18.02.20 13:21 , Daniele Tartarini wrote:
> Hi,
> 
> I have installed from scratch MacPorts on Catilina.
> After installing few ports I run self upgrade and I got the error below,
> any idea how to fix it?
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> * sudo port selfupdatePassword: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 683)
> 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 in advance,
> 
> 
> cheers
> 
> D
>