I rewrote my package database consistency check script. It now reads all data directly from the db.tar.gz files (it doesn't read the filename attribute name yet, and still assumes pkgname-pkgver-pkgrel.pkg.tar.gz). It checks whether all packages in the db are present and have correct md5sums. The script is now in arch/scripts/check-package-db-consistency.sh in CVS. Here is the result: Checking current i686 ... Checking current x86_64 ... Checking extra i686 ... Package "/home/ftp/extra/os/i686/ion-3rc_20070506-1.pkg.tar.gz" missing. Package "/home/ftp/extra/os/i686/tmda-1.1.11-1.pkg.tar.gz" missing. Checking extra x86_64 ... Checking unstable i686 ... Checking unstable x86_64 ... Checking community i686 ... Checking community x86_64 ... Checking testing i686 ... Checking testing x86_64 ... Package "/home/ftp/testing/os/x86_64/xf86-video-unichrome-0.2.6-4.1.pkg.tar.gz" has wrong md5sum (file: "23d1a54367e3340dc7d89cfb48230a6b", database: "04d77dff29205c19c89245deb3a7fb6a")