Your message dated Wed, 13 Dec 2000 21:57:11 +1100
with message-id <[EMAIL PROTECTED]>
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 [EMAIL PROTECTED] Tue Dec 12 20:44:33 2000
Return-path: <[EMAIL PROTECTED]>
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 ([EMAIL PROTECTED]) 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 <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
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: <[EMAIL PROTECTED]>
X-Sender: [EMAIL PROTECTED]
Delivered-To: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] Wed Dec 13 04:57:17 2000
Return-path: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
Subject: Re: Bug#79493: http://nm.debian.org/ is broken
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
In-Reply-To: <[EMAIL PROTECTED]>; from [EMAIL PROTECTED] on Wed, Dec 13, 2000
at 03:44:12AM +0100
From: [EMAIL PROTECTED] (Craig Small)
Delivered-To: [EMAIL PROTECTED]
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/ <[EMAIL PROTECTED]>
MIEEE <[EMAIL PROTECTED]> Debian developer <[EMAIL PROTECTED]>
