[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:  ports                  |     Version:  2.0.3                                
 Keywords:                         |        Port:                                       
-----------------------------------+----------------------------------------
 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

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