2.10.1 macports SQL error on 10.6

[Riccardo Mottola]

Hi Joshua,

Joshua Root wrote:
> 
> First install the macports.sqlext port. Then run this command (all one
> line):
> 
> sqlite3 /opt/local/var/macports/registry/registry.db ".load
> /opt/local/lib/sqlite3/macports.sqlext" "PRAGMA integrity_check"
> 
> That will check that the database is internally consistent. It does not
> however check that the data is correct with respect to external factors,
> e.g. whether the files that each port is recorded as installing actually
> exist in the filesystem.

returns "ok"

>> Deleting everything takes some time, so before doing it...
> 
> If you're no longer seeing errors, no need to delete anything I guess.
> It's probably worth running a test with smartctl (from the smartmontools
> port), just in case.

smartctl returns nothing to worry about, status pass and also attributes
look quite fine - for what I can tell.

Possibly indeed somethign self-healed, maybe a flush issue in sqlite, a
fsck...

Thanks - Riccardo
'