[Apt-Rpm] bug in sqlite repodata handling

[Alexander 'Leo' Bergolth]

Hi!

When trying to install xorg-x11-drv-fglrx-libs, apt-get fails with

-------------------- 8< --------------------
Get:1 http://wolfcastle.wu-wien.ac.at RPMS.livna/ 
xorg-x11-drv-fglrx-libs 8.476-1.8.04.lvn8 [5635kB]
Failed to fetch 
http://wolfcastle.wu-wien.ac.at/dist/f8-i386//RPMS.livna/./kmod-fglrx-8.476-1.8.04.lvn8.i686.rpm 
  Size mismatch
E: Some files failed to download
-------------------- 8< --------------------


apt-cache showpkg displays:
-------------------- 8< --------------------
# apt-cache showpkg xorg-x11-drv-fglrx
Package: xorg-x11-drv-fglrx
Versions:
8.476-1.8.04.lvn8.i386(/var/lib/apt/lists/wolfcastle.wu-wien.ac.at_dist_f8-i386_RPMS.livna_repodata_primary.sqlite)
[...]
-------------------- 8< --------------------


apt-cache show prints the correct size:
-------------------- 8< --------------------
apt> show xorg-x11-drv-fglrx
Package: xorg-x11-drv-fglrx
Section: User Interface/X Hardware Support
Installed Size: 19940697
Packager: rpm.livna.org <http://bugzilla.livna.org>
Version: 8.476-1.8.04.lvn8
[...]
Size: 9715327
-------------------- 8< --------------------


However, apt-get install --print-uris yields the following:
-------------------- 8< --------------------
'http://wolfcastle.wu-wien.ac.at/dist/f8-i386//RPMS.livna/./xorg-x11-drv-fglrx-8.476-1.8.04.lvn8.i386.rpm' 
xorg-x11-drv-fglrx-8.476-1.8.04.lvn8.i386.rpm 9715327 
7caf729361b7f39ed73440556485739174f91d87

'http://wolfcastle.wu-wien.ac.at/dist/f8-i386//RPMS.livna/./xorg-x11-drv-fglrx-8.476-1.8.04.lvn8.i386.rpm' 
xorg-x11-drv-fglrx-8.476-1.8.04.lvn8.i386.rpm 5634610 
7caf729361b7f39ed73440556485739174f91d87
-------------------- 8< --------------------


The sqlite db info looks correct, the second file size displayed by apt 
seems to be the file size of xorg-x11-drv-fglrx-libs:
-------------------- 8< --------------------
# sqlite3 
/var/lib/apt/lists/wolfcastle.wu-wien.ac.at_dist_f8-i386_RPMS.livna_repodata_primary.sqlite
sqlite> select name, location_href, version, release, size_package, 
pkgid from packages where name IN ('xorg-x11-drv-fglrx', 
'xorg-x11-drv-fglrx-libs') AND release ='1.8.04.lvn8';

xorg-x11-drv-fglrx|xorg-x11-drv-fglrx-8.476-1.8.04.lvn8.i386.rpm|8.476|1.8.04.lvn8|9715327|7caf729361b7f39ed73440556485739174f91d87
xorg-x11-drv-fglrx-libs|xorg-x11-drv-fglrx-libs-8.476-1.8.04.lvn8.i386.rpm|8.476|1.8.04.lvn8|5634610|7e499058aa2ba105a02d5a2de4348d6d1e05ed2b
-------------------- 8< --------------------


This corresponds to the file-info in the repository:
-------------------- 8< --------------------
# ls -l xorg-x11-drv-fglrx-8.476-1.8.04.lvn8.i386.rpm 
xorg-x11-drv-fglrx-libs-8.476-1.8.04.lvn8.i386.rpm

-rw-r--r--  1 root root 9715327 Apr 23 18:00 
xorg-x11-drv-fglrx-8.476-1.8.04.lvn8.i386.rpm
-rw-r--r--  2 root root 5634610 Apr 23 18:00 
xorg-x11-drv-fglrx-libs-8.476-1.8.04.lvn8.i386.rpm
-------------------- 8< --------------------


Package information about xorg-x11-drv-fglrx-libs generally seems to be 
broken:
-------------------- 8< --------------------
apt> show xorg-x11-drv-fglrx-libs
Package: name
Section: rpm_group
Installed Size: 0
Packager: rpm_packager
Version: epoch:version-release
Architecture: arch
Size: 0
MD5Sum: pkgId
Filename: location_href
Summary: summary
Description:
  description
-------------------- 8< --------------------


Clearing /var/lib/apt/lists and rereading repository information doesn't 
fix the problem.

apt-cache dump [1] displays both xorg-x11-drv-fglrx and 
xorg-x11-drv-fglrx-libs.

Cheers,
--leo

[1] http://leo.kloburg.at/tmp/apt-cache-dump.txt.gz

-- 
e-mail   ::: Leo.Bergolth (at) wu-wien.ac.at
fax      ::: +43-1-31336-906050
location ::: Computer Center | Vienna University of Economics | Austria