Re: diff not shown/descriptions not stored properly
On 08/24/2011 02:11 PM, Erik Esterer wrote:
Hello list,
Hello Erik
I just found two packages where a diff between old and new description
isn't available, even though it should. A fast research indicates that
there is a problem with storing the descriptions correctly (see the
results below). I never saw the problem before, maybe a recent change
introduced this?
Thanks for the report.
No, this is not a problem of a recent change.
This is a bug of this page of the DDT.
The database ist ok:
ddtp=> SELECT * from package_version_tb where
package='libboost-iostreams1.46.1';
package | version | description_id
--------------------------+----------+----------------
libboost-iostreams1.46.1 | 1.46.1-1 | 58917
libboost-iostreams1.46.1 | 1.46.1-3 | 58917
libboost-iostreams1.46.1 | 1.46.1-4 | 58917
libboost-iostreams1.46.1 | 1.46.1-5 | 58917
libboost-iostreams1.46.1 | 1.46.1-6 | 58917
libboost-iostreams1.46.1 | 1.46.1-7 | 86059
(6 rows)
The old first database layout save the _first_ found package name in
the description table. This page use this (old) field. If a description has
more than one package... we run in this bug
ddtp=> SELECT description_id,package from description_tb where
package='libboost-iostreams1.46.1';
description_id | package
----------------+--------------------------
86059 | libboost-iostreams1.46.1
libboost-iostreams1.46.1:
The package has an old description in Wheezy[1], but it's not in the
database for libboost-iostreams1.46.1[2] (only the new description).
The old description is only listed as a description for
libboost-iostreams1.42.0[3]
[1] http://packages.debian.org/wheezy/libboost-iostreams1.46.1
[2] http://ddtp.debian.net/ddt.cgi?package=libboost-iostreams1.46.1
[3] http://ddtp.debian.net/ddt.cgi?desc_id=58917
libwebkitgtk-1.0-0:
The package has an old description in Wheezy[4] but it's not in the
database[5 (only the new description)]. I couldn't find the old
description in the database at all.
[4] http://packages.debian.org/wheezy/libwebkitgtk-1.0-0
[5] http://packages.debian.org/wheezy/libwebkitgtk-1.0-0
the same...
ddtp=> SELECT * from package_version_tb where
package='libwebkitgtk-1.0-0' order by package;
package | version | description_id
--------------------+---------+----------------
libwebkitgtk-1.0-0 | 1.4.1-1 | 44770
libwebkitgtk-1.0-0 | 1.4.1-2 | 44770
libwebkitgtk-1.0-0 | 1.4.2-1 | 44770
libwebkitgtk-1.0-0 | 1.4.2-2 | 85000
(4 rows)
I will check, if we have the same problem with the new web interface...
Thanks
Gruss
Grisu
Reply to: