www-infrastructure-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Turner (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (INFRA-3292) JIRA data associated with wong usernames after activemq JIRA merge
Date Mon, 17 Jan 2011 09:46:44 GMT

     [ https://issues.apache.org/jira/browse/INFRA-3292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jeff Turner resolved INFRA-3292.
--------------------------------

    Resolution: Fixed

Fixed with 896 lines of hacky pl/pgsql.

> JIRA data associated with wong usernames after activemq JIRA merge
> ------------------------------------------------------------------
>
>                 Key: INFRA-3292
>                 URL: https://issues.apache.org/jira/browse/INFRA-3292
>             Project: Infrastructure
>          Issue Type: Sub-task
>      Security Level: public(Regular issues) 
>          Components: JIRA
>            Reporter: Jeff Turner
>            Assignee: Jeff Turner
>
> In November we used the JIRA Project Importer to import data from the activemq JIRA into
the main JIRA. The JIRA project importer treats identical usernames as identical users. This
was often not the case for us. For instance, 'jason' on the main JIRA is 'jason lane', whereas
'jason' in the activemq JIRA is 'Jason van Zyl'.  After the import, all of Jason van Zyl's
content is now owned by Jason Lane.
> There are 254 cases of an identical username belonging to different people: 
> jira_3135=# select s.username,s.fullname as activemq_user, p.fullname as mainjira_user
from subjira.userdetails s, public.userdetails p, duplicate_usernames d where d.status='d'
and s.username=d.username and p.username=d.username order by s.username;
> ||   username  ||      activemq_user       |      mainjira_user        ||
> |  a3aan      | Adriaan Wisse            | Adriaan Koster |
> |  abdel      | Abdellatif               | abdel |
> |  akr        | Andreas Kruthoff         | Andriy |
> |  alexg      | Alexander Gordt          | Alex Grönholm |
> |  allan      | Allan Brighton           | Allan Emord |
> |  amittal    | amit tallmor             | Ajay Mittal |
> |  andi       | Andreas Wetzel           | Andreas Schamberger |
> |  andreas    | Andreas Eisenberg        | Andreas Fester |
> |  andres     | Andres                   | Andrés Meggiotto |
> |  andrewr    | Andrew                   | Andrew Ryan |
> |  anil       | Anil Kumar Sekharamantri | Anil Saldhana |
> |  anjana     | Anjana Karkoon           | Anjana Fernando |
> |  anne       | Anne Diefenbach          | Anne |
> |  anthony    | Anthony Martins Araújo   | Anthony HERVE |
> |  arachnid   | Arachnid                 | Nick Johnson |
> |  arpit      | arpit shah               | Arpit Singh Pandya |
> |  ashish     | Ashish Sharma            | Ashish Pareek |
> |  ashoknan   | Ashok                    | kan |
> |  aw         | Andrew Wason             | Allen Wittenauer |
> |  bastian    | Bastian Bowe             | Bastian Ibach |
> |  bdm        | B. DM                    | Brent Moore |
> |  ben        | Benjamin Loo             | Ben Stringer |
> |  benjamin   | Ben Pachol               | fantoni benjamin |
> |  binh       | B L                      | Binh Nguyen |
> |  blah       | shawn hwang              | blah |
> |  blaze      | Scott Brooks             | Zoltán Baranyi |
> |  bm         | BM                       | Benno Markiewicz |
> |  bobd       | Rob Dingwell             | Bob Doncaster |
> |  brett      | Brett Morgan             | Brett Lefebvre |
> |  brian      | Brian Oliver             | Brian M Dube |
> |  brianf     | Brian Feaver             | Brian Fox |
> |  bruce      | Bruce Mitchener          | bruce sherrod |
> |  bschmidt   | Bryan Schmidt            | Björn Schmidt |
> |  bud        | Buddhika Siddhisena      | Bud P. Bruegger |
> |  buzdin     | Dmitry Buzdin            | Konstantin Buzdin |
> |  bvkeirsb   | Bart Vankeirsbilck       | - |
> |  carolyn    | Ning Li                  | Carolyn Kelly |
> |  cedric     | cedric                   | Cédric Damioli |
> |  chanaka    | Chanaka Liyanaarachchi   | G.D.N.C.Pathiragoda |
> |  charliec   | Charlie C.               | Carl Byström |
> |  charliem   | Charles Moulliard        | Charlie Mason |
> |  chetan     | Chetan Sarva             | chetan nayak |
> |  chrisj     | Chris Josephes           | Chris Johnson |
> |  chrism3    | Christian Warmuth        | Chris W. |
> |  clang      | Christian Lang           | Claudio |
> |  cliu       | Chuck Liu                | Cele Liu |
> |  cmadsen    | Christian Madsen         | carsten madsen |
> |  colin      | Colin O'Brien            | Zhang Guilin |
> |  craig      | Craig S. Wilson          | Craig Turner |
> |  crossley   | jesse crossley           | David Crossley |
> |  daedalus   | max sperlich             | Neal Granroth |
> |  damian     | Damian Guy               | Damian Gajda |
> |  dan        | Dan Washusen             | Dan |
> |  daniel     | Daniel Wong              | Daniel McLean |
> |  davidc     | Dave Clark               | davidchung |
> |  davide     | Davide Marrone           | Davide Maestroni |
> |  davidg     | David Grigglestone       | David Garrett |
> |  denmer     | full name                | Dennis Merkel |
> |  dennis     | Dennis Loktionov         | Dennis Kuehn |
> |  dewdrop    | Suong  Thu Thi Tran      | Dew Drop |
> |  dfense     | Dedek                    | jerry gallo |
> |  dietrich   | Dietrich Bollmann        | bjoern |
> |  dimas      | Dmitry Andrianov         | Dmitry Semibratov |
> |  djames     | Dan James                | Dave James |
> |  dmarks     | Dan Marks                | Dominik Marks |
> |  don        | Don Coleman              | Don Stewart |
> |  dwoods     | Donald Woods             | Darren Woods |
> |  eengstrom  | Eric Engstrom            | Erik Engstrom |
> |  eric       | eRIC                     | SAUVAGEAU Eric |
> |  erich      | Erich Liebmann           | Erich Pletsch |
> |  falk       | Falk Langhammer          | Falk Bauer |
> |  farhad     | Farhad Dehghani          | Farhad Khan |
> |  flo        | denis                    | ntr |
> |  florian    | Florian Wiesner          | florian pitschi |
> |  flow       | Todd Fincannon           | Lukasz |
> |  fossil     | Paul Foss                | Victor Pakhomov |
> |  frank      | Fran Costanzo            | YunFeng Ma |
> |  frederic   | Frederic Gedin           | Frédéric Blanc |
> |  fritz      | Fritz Oconer             | Yuan Hui Lee |
> |  galaxy     | Galaxy                   | TianYu |
> |  gavin      | &#37101;&#27704;&#21326; | Gavin Mathias |
> |  gus        | David Weinkauf           | Gustavo Fernandez |
> |  hammett    | hamilton                 | hamilton verissimo |
> |  henrib     | Henri Bonnehuit          | Henri Biestro |
> |  hks        | Handinata Kusuma         | Harri K. Salminen |
> |  hok        | Heiko Selber             | Ivan Vasilev |
> |  holger     | Holger Hoffstätte        | Holger Weiss |
> |  humberto   | Humberto                 | Humberto Cervantes |
> |  hut        | huteng                   | Bruno Chauvet |
> |  ianp       | Ian Phillips             | Ian Priest |
> |  ignatz     | Chris Baker              | Ignat Zapolsky |
> |  igor       | Igor Katkov              | Igor Peshansky |
> |  ivan       | Ivan Price               | Ivan Latysh |
> |  ivanm      | Ivan Moscoso             | Ivan Murashko |
> |  james      | James Chamberlain        | James Jose |
> |  janw       | Jan Willem               | Jan |
> |  jarek      | Jaroslaw Cora            | Jaroslaw Odzga |
> |  jason      | Jason van Zyl            | jason lane |
> |  javadev    | Luiz Geraldo Silva Braz  | Jabber W |
> |  jaya       | Jaya Srinivasan          | Jayalakshmi |
> |  jb         | Jim Beattie              | Jan Bulrych |
> |  jdeveloper | SK CHAKRABORTY           | saeed yousefi |
> |  jef        | Jef Newsom               | Jef Waltman |
> |  jem        | Jem Day                  | John Mendenhall |
> |  jenny      | Jenny Ng                 | Jenny N Zhang |
> |  jeremy     | Jérémy DE ROYER          | Jeremy Quinn |
> |  jin        | jinchen                  | jin adachi |
> |  jmanning   | Jonathan Manning         | Jackie Manning |
> |  joachim    | Joachim Björklund        | Joachim Pfisterer |
> |  john       | john shuai               | John Reuning |
> |  johnc      | John Cavacas             | john c |
> |  jon        | jon madison              | Jon Stevens |
> |  jonas      | Jonas Gustafsson         | Jonas |
> |  jonathan   | Jonathan Demers          | Jonathan Lee |
> |  jpierson   | Jay Pierson              | Jeff Pierson |
> |  jtorres    | Jay Torres               | Jeremy Torres |
> |  jzhang     | James Zhang              | jian zhang |
> |  kalyani    | kalyanip                 | Kalyani Chennupati |
> |  kannan     | Kannan                   | Abhilash Kumar |
> |  keithb     | Keith Braithwaite        | Keith Brophy |
> |  kelvin     | kelvin wright            | Kelvin Kakugawa |
> |  kevin      | Kevin O'Neill            | kevin |
> |  kjones     | Kent A. Jones            | Kevin Jones |
> |  konrad     | Konrad Podloucky         | Konrad Kleine |
> |  kos        | Konstantin Sobolev       | Konstantin Nikolaev |
> |  kris       | krishna                  | Kris |
> |  kristoffer | Kristoffer Erlandsson    | Kristoffer Peterhänsel |
> |  kumar      | Kumar                    | KumarMarkkaSagayam |
> |  kurt       | kurt                     | Kurt LeClerc |
> |  lakshmi    | Lakshmi                  | Vanitha |
> |  lars       | Lars Gohlke              | Lars Eilebrecht |
> |  lee        | Lurga                    | Lee.Li |
> |  leo        | Matthias L. Jugel        | Leo Tu |
> |  lindholm   | George Lindholm          | Morten Lindholm |
> |  lionel     | Lionel Porcheron         | lionel saurat |
> |  lr         | Tomas Lebovic            | Laurent Raufaste |
> |  lsmadja    | laurent                  | ludovic SMADJA |
> |  ludde      | Rickard Lundin           | Marcus Ludvigson |
> |  ludo       | Ludovic lalande          | ludovic poitou |
> |  luk        | Lucas Koenig             | Łukasz Zaręba |
> |  lukas      | Lukas Theussl            | Lukas JOSEFIK |
> |  maarten    | Maarten Grootendorst     | Maarten van Schouwen |
> |  magnus     | Magnus Heino             | Magnus Strand |
> |  manish     | Manish                   | Manish Khettry |
> |  manoj      | mano                     | Manoj Kasichainula |
> |  marc       | marc huang               | Marc Boguerra |
> |  marco      | Marco Malar              | Marc Salvetti |
> |  markus     | Markus Müller            | Markus Hansen |
> |  mart       | martin schlienger        | Martin Ellis |
> |  martin     | Martin Testrot           | Martin Kendall |
> |  martinc    | Martin Carpella          | Martin Cooper |
> |  mash       | Manish Shah              | Mikhail sholokhov |
> |  mast       | Mathias Stalas           | Martin Stenderup |
> |  mats       | Mats Lindh               | Mats Bolstad |
> |  matteo     | Matvey                   | Matteo Caprari |
> |  matty      | matthew rodwell          | Matej Kraus |
> |  maxim      | maxim                    | Maxim Pavlov |
> |  mcnamara   | tim mcnamara             | Sarah McNamara |
> |  memphis    | Travis E                 | Mario Harnisch |
> |  mikem      | Michael Musenbrock       | Mike Matrigali |
> |  mkuppe     | Mathew Kuppe             | Markus Alexander Kuppe |
> |  moritz     | Andreas Kemkes           | Moritz Siuts |
> |  ms         | Mathis Schwuchow         | Martin Strand |
> |  msantos    | Marlon Santos            | Marco Paulo Silva Santos |
> |  natedawg   | Nathan                   | Nathan Kontny |
> |  nbw        | N W                      | N. White |
> |  neil       | Neil Figg                | Neil Sharman |
> |  nick       | nick                     | Nick Lanham |
> |  nigel      | Nigel Leck               | Nigel |
> |  nn         | nobuyuki nakae           | mik |
> |  obi        | Ole Bille                | Andreas Oberritter |
> |  olav       | Olav Maassen             | Olav Sandstaa |
> |  oleg       | Oleg Alexeyev            | Oleg Gusakov |
> |  oli        | Olivier                  | Oliver Bayer |
> |  onno       | Massimiliano Onorato     | Onno Scheffers |
> |  oscar      | Oscar Picasso            | Oscar del Rio |
> |  parul      | Parul Jain               | Parul Bhagat |
> |  pascal     | Pascal Benarousse        | Pascal Dihé |
> |  pat        | Patrick                  | Patrick R. |
> |  patrick    | Patrick Ehrensperger     | Patrick Cogan |
> |  pelle      | Pelle Braendgaard        | Per Bondesson |
> |  per        | Per Hammer               | per hultkrantz |
> |  pete       | Peter Hannaway           | Peter Ertl |
> |  phil       | Philip Luppens           | Phil Barnes |
> |  pm         | Paul Morris              | Aissam BAZZAOUI |
> |  pope       | Alex Popescu             | K. Adam Christensen |
> |  pratik     | pratik singh             | PRATIK KHERA |
> |  radha      | Radha Manickam           | Radha Gopireddy |
> |  raja       | raja                     | Rajagopal. V |
> |  ranjan     | Ranjan                   | Priya Ranjan Kumar |
> |  rbrown     | Robert Brown             | Richard Brown |
> |  rd         | Rohit Dubey              | diasp |
> |  reto       | Reto Breitenmoser        | Reto Bachmann-Gmür |
> |  reza       | reza shahbazi            | Reza |
> |  richie     | Constantin Pavloff       | Richard J. Barbalace |
> |  ritesh     | Ritesh Samanpure         | Ritesh Sandupatla |
> |  rj         | joris roger              | Richard Jones |
> |  rjoshi     | Rohit Joshi              | Rajesh Joshi |
> |  robd       | Rob Dupuis               | robd |
> |  roberto    | Roberto de Castro        | Roberto Fonti |
> |  robj       | Rob Janney               | Rob Jellinghaus |
> |  roelof     | Roelof Naude             | Roelof Blom |
> |  roger      | Roger Joelsson           | Roger Rached |
> |  rogerio    | Rogério Sorroche         | Rogério Pereira Araújo |
> |  sam        | Sam Kuhn                 | Sam Abeyratne |
> |  sandeep    | sandeep                  | Sandeep Raman |
> |  santosh    | Santosh                  | santosh malviya |
> |  satish     | sateesh                  | Satish Bhatti |
> |  scamp      | francois ostyn           | Sal Campana |
> |  senthil    | senthil kumar            | Senthil Subramanian |
> |  shawn      | Shawn Chain              | Shawn Church |
> |  shrisha    | Shrisha Chandrashekar    | Shrisha Radhakrishna |
> |  sms        | StephanMestach           | Santhosh Srinivasan |
> |  somegeek   | muhilan                  | ilango gurusamy |
> |  spd        | Joe Gonzales             | avi hirsh |
> |  squiddle   | Christian                | Christian Schröder |
> |  srihari    | Srihari Srinivasan       | Srihari Reddy |
> |  srikanth   | srikanth.M               | srikanth |
> |  stang      | Shan Yuk Tang            | Stanley G |
> |  stef       | chaigneau                | Stefan Tauner |
> |  stefan     | Stefan Voss              | Stefan Liebig |
> |  stephan    | Stephan Schmidt          | Stephan Michels |
> |  steve      | steve patrick            | Steve Hardy |
> |  stijn      | Stijn de Witt            | Stijn Vermeeren |
> |  sujatha    | sujatha.ganesuni         | g sujatha |
> |  sunil      | Sunil Guttula            | sunil patil |
> |  surendra   | Surendra Agrawal         | Surendra Movva |
> |  takai      | TAKAI Naoto              | Osvaldo Kotaro Takai |
> |  tamas      | Csaba Tamas              | Tamas Ruff |
> |  tao        | tao                      | Tao Jiang |
> |  tcc        | T.C. Chou                | tommy chheng |
> |  td         | gokhan ozer              | Tony DeCarlo |
> |  tde        | Thomas Demande           | Tim Ebringer |
> |  tee        | Tee D                    | Daniel Teske |
> |  tnguyen    | Trong Nguyen             | Trang Nguyen |
> |  tobias     | Tobias Emmerich          | Tobias Neubert |
> |  toby       | Toby Miller              | toby cabot |
> |  tomb       | Bártfai Tamás            | Thomas Burns |
> |  tomek      | Tomek Kaczanowski        | Tomasz Stec |
> |  toml       | Tom Litton               | Tom Leccese |
> |  torr       | Todd Orr                 | Torr Liu |
> |  tristan    | Tristan                  | Tristan King |
> |  tsandor    | Thomas Sandor            | Tamas Sandor |
> |  turnerj    | Joshua Turner            | John Turner |
> |  vaibhav    | Vaibhav Ghadi            | vaibhav kale |
> |  vds        | Vernon Stinebaker        | vinay |
> |  venkatk    | K Venkatasubramaniyan    | Venkatesh K Reddy |
> |  victor     | Victor                   | Victor Ortega |
> |  viktor     | Viktor Matic             | viktor doernberg |
> |  wilhelm    | Dirk Wilhelm             | Wilhelm Lehmann |
> |  wyvern     | Adrian Bridgett          | Igor Kushnarev |
> |  xudong     | xudong                   | Michael Xu |
> |  yaytay     | Jim Talbut               | Yaytay |
> |  zli        | Zhao Li                  | Zhong Li |
> | (254 rows) |

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message