Bug#663730: closed by Bart Martens <bartm@alioth.debian.org> (qa.debian.org bug fixed in revision 2761)

[Bart Martens <bartm@debian.org>]

reopen 663730
stop

On Wed, Jul 18, 2012 at 04:00:14PM +0100, Matthew Vernon wrote:
> Hi,
> 
> On 28/05/12 09:24, Debian Bug Tracking System wrote:
> >This is an automatic notification regarding your Bug report
> >which was filed against the qa.debian.org package:
> >
> >#663730: qa.debian.org: falsely merges two people
> >
> >It has been closed by Bart Martens<bartm@alioth.debian.org>.
> 
> I've just checked, and the qa page still seems to be wrong. Should I
> re-open this bug? It was closed over a month ago...

Thanks for bringing this to my attention Matthew.

Your name was added here:
http://anonscm.debian.org/viewvc/qa/trunk/carnivore/extract_data?view=markup

Your name is in this file on quantz:
/srv/qa.debian.org/carnivore/extract_data

So the change was deployed.

This file reads from carnivore.db:
/srv/qa.debian.org/web/developer.php

Maybe this file contains wrong data:
/srv/qa.debian.org/data/ddpo/results/carnivore.db

This script pulls the data from UDD:
/srv/qa.debian.org/data/ddpo/extract_carnivore.pl

Looking in UDD:

psql -U guest -h udd.debian.org -p 5452 udd

udd=> select id, email from carnivore_emails where id=304;
 id  |              email              
-----+---------------------------------
 304 | matthew@debian.org
 304 | matthewv@chiark.greenend.org.uk
 304 | mcv21@cus.cam.ac.uk
(3 rows)

udd=> select id,email from carnivore_emails where id=972;
 id  |         email          
-----+------------------------
 972 | sunergos@vernshome.net
(1 row)

Looks OK in UDD.

But when I run a modified extract_carnivore.pl :

id=972 email=sunergos@vernshome.net
id=972 email=matthew@debian.org

So I modified extract_carnivore.pl like this:

#my $dbh = DBI->connect( "dbi:Pg:dbname=udd;port=5441;host=localhost", "guest" ) or die;
my $dbh = DBI->connect( "dbi:Pg:dbname=udd;port=5452;host=udd.debian.org", "guest" ) or die;

Then the output is :

id=304 email=matthew@debian.org
id=972 email=sunergos@vernshome.net

So the problem seems to be that the copy of UDD on quantz is not up to date.
Who takes care of synchronizing the UDD copy on quantz ?  OK, let's reopen this
bug and ask around for how to solve this.

Regards,

Bart Martens