Bug#79493: marked as done (http://nm.debian.org/ is broken)
Your message dated Wed, 13 Dec 2000 21:57:11 +1100
with message-id <20001213215711.A2713@eye-net.com.au>
and subject line Bug#79493: http://nm.debian.org/ is broken
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Darren Benham
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 13 Dec 2000 02:44:34 +0000
>From goswin.brederlow@student.uni-tuebingen.de Tue Dec 12 20:44:33 2000
Return-path: <goswin.brederlow@student.uni-tuebingen.de>
Received: from mailout02.sul.t-online.com [194.25.134.17]
by master.debian.org with esmtp (Exim 3.12 1 (Debian))
id 1461uD-0003t9-00; Tue, 12 Dec 2000 20:44:33 -0600
Received: from fwd01.sul.t-online.com
by mailout02.sul.t-online.com with smtp
id 1461u7-0000wR-00; Wed, 13 Dec 2000 03:44:27 +0100
Received: from dual.intern.brederlow.de (520045864123-0001@[62.157.82.178]) by fmrl01.sul.t-online.com
with esmtp id 1461ty-0tJ1sGC; Wed, 13 Dec 2000 03:44:18 +0100
Received: from mrvn by dual.intern.brederlow.de with local (Exim 3.16 #1 (Debian))
id 1461ts-0000UG-00; Wed, 13 Dec 2000 03:44:12 +0100
From: Goswin Brederlow <goswin.brederlow@student.uni-tuebingen.de>
To: Debian Bug Tracking System <submit@bugs.debian.org>
Subject: http://nm.debian.org/ is broken
X-Reportbug-Version: 1.3
X-Mailer: reportbug 1.3
Date: Wed, 13 Dec 2000 03:44:12 +0100
Message-Id: <[🔎] E1461ts-0000UG-00@dual.intern.brederlow.de>
X-Sender: 520045864123-0001@t-dialin.net
Delivered-To: submit@bugs.debian.org
Package: www.debian.org
Version: N/A; reported 2000-12-13
Severity: normal
...
Aggregate Statistics
To give you some idea of the size of the application process and where, as a whole, applicants are in the
system we have provided some overall statistics. The waiting times are taken from data for the last two
months and are incremental for each stage except for the 'New Maintainers Processed' line which is the
total time from application to becoming a new maintainer.
SELECT date_part('epoch', age(manager_date,apply_date))/86400 FROM applicant WHERE
manager_date IS NOT NULL AND age('now'::date, manager_date) < '2 months' AND manager_date>
apply_date ORDER by age(manager_date,apply_date) LIMIT 1 OFFSET 99
35.0416666666667 SELECT date_part('epoch', age(am_confirm_date,manager_date))/86400 FROM
applicant WHERE am_confirm_date IS NOT NULL AND age('now'::date, am_confirm_date) < '2
months' AND am_confirm_date> manager_date ORDER by age(am_confirm_date,manager_date) LIMIT
1 OFFSET 27
2 SELECT date_part('epoch', age(am_contact,am_confirm_date))/86400 FROM applicant WHERE
am_contact IS NOT NULL AND age('now'::date, am_contact) < '2 months' AND am_contact>
am_confirm_date ORDER by age(am_contact,am_confirm_date) LIMIT 1 OFFSET 3
1 SELECT date_part('epoch', age(decision,am_contact))/86400 FROM applicant WHERE decision IS
NOT NULL AND age('now'::date, decision) < '2 months' AND decision> am_contact ORDER by
age(decision,am_contact) LIMIT 1 OFFSET 64
20 SELECT date_part('epoch', age(newmaint,decision))/86400 FROM applicant WHERE newmaint IS
NOT NULL AND age('now'::date, newmaint) < '2 months' AND newmaint> decision ORDER by
age(newmaint,decision) LIMIT 1 OFFSET 38
8 SELECT date_part('epoch', age(newmaint,apply_date))/86400 FROM applicant WHERE newmaint IS
NOT NULL AND age('now'::date, newmaint) < '2 months' AND newmaint> apply_date ORDER by
age(newmaint,apply_date) LIMIT 1
OFFSET 41
Something is broken there.
MfG
Goswin
-- System Information
Debian Release: woody
Architecture: i386
Kernel: Linux dual 2.2.17 #1 SMP Mon Sep 4 06:13:20 CEST 2000 i686
---------------------------------------
Received: (at 79493-done) by bugs.debian.org; 13 Dec 2000 10:57:17 +0000
>From csmall@eye-net.com.au Wed Dec 13 04:57:17 2000
Return-path: <csmall@eye-net.com.au>
Received: from gonzo.eye-net.com.au [203.41.228.17]
by master.debian.org with esmtp (Exim 3.12 1 (Debian))
id 1469b1-0005oD-00; Wed, 13 Dec 2000 04:57:16 -0600
Received: by gonzo.eye-net.com.au (Postfix, from userid 1000)
id B09DFC5E0; Wed, 13 Dec 2000 21:57:11 +1100 (EST)
Date: Wed, 13 Dec 2000 21:57:11 +1100
To: Goswin Brederlow <goswin.brederlow@student.uni-tuebingen.de>,
79493-done@bugs.debian.org
Subject: Re: Bug#79493: http://nm.debian.org/ is broken
Message-ID: <20001213215711.A2713@eye-net.com.au>
References: <[🔎] E1461ts-0000UG-00@dual.intern.brederlow.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
In-Reply-To: <[🔎] E1461ts-0000UG-00@dual.intern.brederlow.de>; from goswin.brederlow@student.uni-tuebingen.de on Wed, Dec 13, 2000 at 03:44:12AM +0100
From: csmall@eye-net.com.au (Craig Small)
Delivered-To: 79493-done@bugs.debian.org
On Wed, Dec 13, 2000 at 03:44:12AM +0100, Goswin Brederlow wrote:
> SELECT date_part('epoch', age(manager_date,apply_date))/86400 FROM applicant WHERE
> manager_date IS NOT NULL AND age('now'::date, manager_date) < '2 months' AND manager_date>
> apply_date ORDER by age(manager_date,apply_date) LIMIT 1 OFFSET 99
> 35.0416666666667 SELECT date_part('epoch', age(am_confirm_date,manager_date))/86400 FROM
aww, someone saw my debug code.
It's gone now, my evil SQL is safe once again.
closing bug.
- Craig
--
Craig Small VK2XLZ GnuPG:1C1B D893 1418 2AF4 45EE 95CB C76C E5AC 12CA DFA5
Eye-Net Consulting http://www.eye-net.com.au/ <csmall@eye-net.com.au>
MIEEE <csmall@ieee.org> Debian developer <csmall@debian.org>
Reply to: