Unstable to testing delay

Description

Before being included in the stable distributions, packages first go into unstable, then into testing (see Debian releases). From 2005-11-02 to 2006-01-17, we have measured the time taken for a package from getting from unstable to testing (as packages seldom move from testing to stable).

Results

Minimum delay (days)AverageMaximum
-286.069675
It is surprising to note that packages appear in testing BEFORE they appear in unstable. This needs further investigation ; is that a bug in our software ?

Delay <=Number of packagesPercentage
01314662%
7 days1480470%
2 weeks1844387%
3 weeks1924391%
6 weeks2065198%
3 months21080100%

Top 30 slowest packages:

NameVersionDelay
libapache-miniwiki-perl0.92-175
libproc-process-perl0.39-175
libspoon-perl0.20-175
r5rs-doc20010328-675
gmt-doc-pdf4.0-270
mysqltcl3.01-170
gmt-examples4.0-270
gmt-tutorial-pdf4.0-270
gmt-doc4.0-270
lvm-common1.5.2070
gmt4.0-270
omniidl44.0.6-268
pppstatus0.4.2-867
libcos4-dev4.0.6-266
omniorb4-nameserver4.0.6-266
libomniorb4c24.0.6-266
libcos4c24.0.6-266
python2.4-omniorb2-omg2.6-266
omniorb4-doc4.0.6-266
omniorb4-idl4.0.6-266
omniidl4-python2.6-266
libomnithread3-dev4.0.6-266
python2.3-omniorb2-omg2.6-266
python2.4-omniorb22.6-266
python-omniorb22.6-266
python2.3-omniorb22.6-266
libomnithread3c24.0.6-266
python2.2-omniorb22.6-266
omniorb44.0.6-266
python2.1-omniorb22.6-266

Packages with negative delays:

NameVersionDelay
openvpn2.0.5-1-4
liblog-log4perl-perl1.01-1-10
libgnomedb2-41.2.1-4-13
ifenslave-2.40.07+2.5.15-7-13
xtoolwait1.3-5-13
xrootconsole1:0.5-1-13
gkrellmitime1.0.1-2-13
libmdsp-dev0.11-7-13
sg-utils1.02-1-13
unicon-im3.0.4-9-13
gimp-dcraw1.21-1-13
libgsm-tools1.0.10-13-13
freewnn-common1.1.0+1.1.1-a020-1-13
airstrike-common0.99+1.0pre6a-3-13
cdrdao1:1.1.9-3-13
libguilegtk-1.2-dev0.31-3-13
tea10.1-1-13
libsyck0-dev0.55-3-13
octave-forge2005.06.13-2-13
gstreamer0.8-misc0.8.11-2-13
i2c-2.4.27-2-3861:2.9.2-1-13
zope-cmfplone2.1-2-13
spew1.0.5-1-13
xfce4-mcs-manager-dev4.2.2-1-13
libgeda-doc20050820-1-13
mono-classlib-2.01.1.9.2-1-13
leaktracer2.4-5-13
libibtk00.0.14-10-13
gstreamer0.8-oss0.8.11-2-13
libxalan18c21.8-5-13
libwxbase2.4-dev2.4.4.1.1-13
xfont-nexus0.0.1-3-28

SQL queries

insert into movement select t.pid,t.testing,t.unstable from (select distinct
    l1.package_id as pid, min(l1.day) as testing, min(l2.day) as unstable from lifetimes as l1 left join lifetimes as l2 on
    l1.package_id=l2.package_id and l1.archive_id = 11 and l2.archive_id = 4 where l1.archive_id is not null and
    l2.archive_id is not null group by l1.package_id) as t;
create table delay (name varchar(64), version varchar(64), delay int);
insert into delay select u.name,v.version,datediff(m.unstable,m.testing) as delay from movement as m, units as u, packages as p, versions as v where p.id = m.package_id and v.id = p.version_id and u.id = p.unit_id order by delay desc;
select min(delay),avg(delay),max(delay) from delay;
Version 1.9 last modified by StephaneLauriere on 06/02/2006 at 11:33

Comments 0

No comments for this document

Attachments 0

No attachments for this document

Creator: Berke on 2006/01/17 09:53
Copyright EDOS Consortium
1.1.1