[UDD] Suspicious data in carnivore table

On 17/08/12 at 09:14 +0200, Andreas Tille wrote:

Hi,

I do not think that we should mix up past DPL with current one but
carnivore_names tries to do so:

udd=> SELECT * from carnivore_names where id = 154 ;
id | name
154 | Sam Hocevar
154 | Samuel Hocevar
154 | Stefano Zacchiroli

Any clue what might have went wrong here?

I think it's due to the email address that both
Stefano and Samuel have as uid on their PGP keys.

Lucas


To UNSUBSCRIBE, email to
with a subject of "unsubscribe". Trouble? Contact
Archive: http://lists.debian.org/

Hi Lucas,

On Fri, Aug 17, 2012 at 10:02:30AM +0200, Lucas Nussbaum wrote:

On 17/08/12 at 09:14 +0200, Andreas Tille wrote:
> Hi,
>
> I do not think that we should mix up past DPL with current one but
> carnivore_names tries to do so:
>
> udd=> SELECT * from carnivore_names where id = 154 ;
> id | name
> 154 | Sam Hocevar
> 154 | Samuel Hocevar
> 154 | Stefano Zacchiroli
>
> Any clue what might have went wrong here?

I think it's due to the email address that both
Stefano and Samuel have as uid on their PGP keys.

This might be some reason but I can tell for sure that this situation
was not the case at least until and of June this year. I'm trying to
normalise different names for the same person for the teammetrics and
I'm using a bit hackish but somehow working script

http://anonscm.debian.org/gitweb/?p...py;hb=HEAD

to do so. It is the first time that this issue occured and I think
it just should not happen.

I have not dived into the creation of carnivore tables but I wonder
whether this could be prevented somehow.

Kind regards

Andreas.

http://fam-tille.de


To UNSUBSCRIBE, email to
with a subject of "unsubscribe". Trouble? Contact
Archive: http://lists.debian.org/

On Fri, Aug 17, 2012 at 10:07:53AM +0200, Andreas Tille wrote:

On Fri, Aug 17, 2012 at 10:02:30AM +0200, Lucas Nussbaum wrote:
> On 17/08/12 at 09:14 +0200, Andreas Tille wrote:
> > I do not think that we should mix up past DPL with current one but
> > carnivore_names tries to do so:
> >
> > udd=> SELECT * from carnivore_names where id = 154 ;
> > id | name
> > 154 | Sam Hocevar
> > 154 | Samuel Hocevar
> > 154 | Stefano Zacchiroli
>
> I think it's due to the email address that both
> Stefano and Samuel have as uid on their PGP keys.

This might be some reason but I can tell for sure that this situation
was not the case at least until and of June this year.

DDPO was using an outdated copy of UDD until recently.

I have not dived into the creation of carnivore tables but I wonder
whether this could be prevented somehow.

I have just committed a fix for this.
http://anonscm.debian.org/viewvc/qa...ct_data?r1'62&r2(05

The approach is similar to how merging by some names is prevented.
http://anonscm.debian.org/viewvc/qa...ct_data?r1'61&r2'62

Regards,

Bart Martens


To UNSUBSCRIBE, email to
with a subject of "unsubscribe". Trouble? Contact
Archive: http://lists.debian.org/

On Fri, Aug 17, 2012 at 05:16:53PM +0000, Bart Martens wrote:

I have just committed a fix for this.
http://anonscm.debian.org/viewvc/qa...ct_data?r1'62&r2(05

Thanks. I can confirm that this fixed the issue in UDD.

Kind regards

Andreas.

http://fam-tille.de


To UNSUBSCRIBE, email to
with a subject of "unsubscribe". Trouble? Contact
Archive: http://lists.debian.org/