port sql database error

[Riccardo Mottola]

Hi,

during/after upgrade I got this:
$ port outdated
Error: process_cmd failed: sqlite error: another row available (100) 
while executing query: SELECT cxx_stdlib FROM registry.ports WHERE id=1184

Compared to the past, this time no reboot or other trick fixed the 
problem by by itself...

I do:

$ sqlite3 /opt/local/var/macports/registry/registry.db "select * from 
ports where id=1184"
1184|xmlcatmgr|435d94eb7431bfb474662c034bffac8cbde64759424e188613ed8a7f8287ba96-1298|/opt/local/var/macports/software/xmlcatmgr/xmlcatmgr-2.2_1.darwin_10.x86_64.tbz2|0|2.2|1|||installed|1737559896|image|x86_64|0|darwin|10||0

This means only one!

what can I do?

port installed works

I tried "port reclaim". It appeared to work and complete, did two 
passes. Now... I get the error on another id!

$ port outdated
Error: process_cmd failed: sqlite error: another row available (100) 
while executing query: SELECT cxx_stdlib FROM registry.ports WHERE id=1218

Which corresponds to another port:
1218|pkgconfig|677ba022ffa40ea6642b68951fc2422ebf9a966224178524a7b3f0c5e7269d32-3295|/opt/local/var/macports/software/pkgconfig/pkgconfig-0.29.2_0.darwin_10.x86_64.tbz2|0|0.29.2|0|||installed|1737587718|image|x86_64|0|darwin|10||0


now I am confused and worried.

Riccardo