MacPorts Sync: Sync fails with error - Error: process_cmd failed: sqlite error: another row available

[RobK88]

Harrys-and-Moms-MacBook-Pro:~ grinch$ sudo port -v selfupdate
--->  Checking for newer releases of MacPorts
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100    63  100    63    0     0    520      0 --:--:-- --:--:-- --:--:--   525
MacPorts base version 2.10.1 installed,
MacPorts base version 2.10.1 available.
--->  MacPorts base is already the latest version
--->  Updating the ports tree
Synchronizing local ports tree from rsync://rsync.macports.org/macports/release/tarballs/ports.tar.gz

Willkommen auf dem RSYNC-server auf ftp.fau.de.
Nicht all unsere Mirror sind per rsync verfuegbar.

Welcome to the RSYNC daemon on ftp.fau.de.
Not all of our mirrors are available through rsync.


receiving file list ... done
./

sent 74 bytes  received 102 bytes  70.40 bytes/sec
total size is 35199362  speedup is 199996.38
Creating port index in /opt/local/var/macports/sources/rsync.macports.org/macports/release/tarballs/ports

Total number of ports parsed:	0 
Ports successfully parsed:	0 
Ports failed:			0 
Up-to-date ports skipped:	39557


The ports tree has been updated.
Error: process_cmd failed: sqlite error: another row available (100) while executing query: SELECT cxx_stdlib FROM registry.ports WHERE id=736
Harrys-and-Moms-MacBook-Pro:~ grinch$

[RobK88]

port outdated also fails

Harrys-and-Moms-MacBook-Pro:~ grinch$ port outdated
Error: process_cmd failed: sqlite error: another row available (100) while executing query: SELECT cxx_stdlib FROM registry.ports WHERE id=736

[RobK88]

Here is the workaround:

Harrys-and-Moms-MacBook-Pro:~ grinch$ sudo port -df selfupdate

etc etc

The ports tree has been updated.
All installed ports are up to date.

Harrys-and-Moms-MacBook-Pro:~ grinch$ port outdated
No installed ports are outdated.

[sbgraphic (Eric Scheurer)]

Thanks for the workaround, works for me !