[MacPorts] #32686: Registry DB corrupted after selfupdate

[MacPorts]

#32686: Registry DB corrupted after selfupdate
-----------------------------------+----------------------------------------
 Reporter:  falkschramm@…          |       Owner:  macports-tickets@…                   
     Type:  defect                 |      Status:  new                                  
 Priority:  Normal                 |   Milestone:                                       
Component:  base                   |     Version:  2.0.3                                
 Keywords:                         |        Port:                                       
-----------------------------------+----------------------------------------
Changes (by ryandesign@…):

 * cc: falkschramm@… (removed)
  * component:  ports => base


Old description:

> Hi there,
> After running "port selfupdate" today the registry DB seems to be
> corrupted. Before "port list outdated" was running fine. After the
> selfupdate it fails with the following error message:
> Error: /opt/local/bin/port: port installed failed: sqlite error: SQL
> logic error or missing
> database (1) while executing query: SELECT name FROM registry.ports WHERE
> id=572
>
> Looking into the /opt/local/var/macports/registry/registry.db file with
> sqlite3 the file seems to be corrupted:
> sqlite> SELECT id FROM ports;
> Fails after ID 571 with "Error: database disk image is malformed".
>
> So far it seems that the selfupdate corrupted the registry.db file.
> Is there any way to rebuild/reconstruct the file?
>
> Thanks in advance,
> Falk

New description:

 Hi there, [[br]]
 After running "{{{port selfupdate}}}" today the registry DB seems to be
 corrupted. Before "{{{port list outdated}}}" was running fine. After the
 selfupdate it fails with the following error message:
 {{{
 Error: /opt/local/bin/port: port installed failed: sqlite error: SQL logic
 error or missing
 database (1) while executing query: SELECT name FROM registry.ports WHERE
 id=572
 }}}

 Looking into the /opt/local/var/macports/registry/registry.db file with
 sqlite3 the file seems to be corrupted:
 {{{
 sqlite> SELECT id FROM ports;
 }}}
 Fails after ID 571 with "{{{Error: database disk image is malformed}}}".

 So far it seems that the selfupdate corrupted the registry.db file. [[br]]
 Is there any way to rebuild/reconstruct the file?

 Thanks in advance, [[br]]
 Falk

--

Comment:

 I don't know why your registry corrupted, nor how to fix it. But I do want
 to point out that [wiki:FAQ#portlist "port list" doesn't do what you think
 it does].

-- 
Ticket URL: <https://trac.macports.org/ticket/32686#comment:2>
MacPorts <http://www.macports.org/>
Ports system for Mac OS