[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:                                       
-----------------------------------+----------------------------------------

Comment(by ecronin@…):

 Automatic if the process has write access to registry.db, which it doesn't
 if you're doing 'port outdated' and not 'sudo port outdated'.  The
 original description doesn't mention if any of the commands were tried as
 root, but that would explain why the journal didn't fix it automatically.

 I thought a fix went into base right after the 2.0 release to use the
 extended sqlite error messages to catch this, but maybe it was only to
 print a better but still unhelpful error message.  If "Error:
 /opt/local/bin/port: port installed failed: sqlite error: SQL logic error
 or missing database (1) while executing query: " is now the new "you need
 to open the database as root so it can be repaired from the journal" error
 we still need to do better at catching the sqlite library error and
 translating it to something the user has a chance at understanding

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