Request manual merge of my account

Asked by Sense Egbert Hofstede

Using Launchpad account merge interface I tried to merge the account 'sense-ubuntu' into my account 'sense'. The first one was created by Launchpad when it imported translations from GNOME, just before I got a chance to register my new email address with Launchpad.

However, each time I try to confirm the merge request Launchpad times out, both on and outside edge. I have tried this a lot of times now, probably more than fifty, but it keeps timing out and the merge is never completed.

The latest Error ID is OOPS-1675EB3058. This problem is most likely caused by bug #162510.

I request a manual merge since this is preventing me from associating my (new) @ubuntu.com email address with my Launchpad account.

Question information

Language:
English Edit question
Status:
Solved
For:
Launchpad itself Edit question
Assignee:
Curtis Hovey Edit question
Solved by:
Sense Egbert Hofstede
Solved:
Last query:
Last reply:
Revision history for this message
Curtis Hovey (sinzui) said :
#1

You need to keep repeating this until it completes. Each step of the merge is being saved, you are slowly doing the merge. You may have to do this many times (27 trys is the worst I have heard).

Revision history for this message
Sense Egbert Hofstede (sense) said :
#2

I have tried for over 120 times in a row, but I still cannot merge the account 'sense-ubuntu' into 'sense'. This is getting really annoying as now I cannot use my @ubuntu.com email address on Launchpad.
It seems that are there too many imported contributions for 'sense-ubuntu' that Launchpad isn't capable of merging this. Therefore I am yet again asking for a manual merge.

Revision history for this message
Curtis Hovey (sinzui) said :
#3

What you are doing is the only way to complete what you started :( There is no other way to accomplish the merge. There might be a browser or desktop extension to automate this. I do not know what else can be done.

Revision history for this message
Curtis Hovey (sinzui) said :
#4

Ubuntu constructs <email address hidden> by mining Launchpad data. Launchpad does not provision or maintain them. I do not think they are transferable, at least, I do know know how a report process could know that you transferred the address to another user. I think you need to talk to someone in the Ubuntu community who maintains the Lp sync code to change your address.

Revision history for this message
Sense Egbert Hofstede (sense) said :
#5

I've been running the command 'while x=0; do curl --verbose --referer https://launchpad.net/token/{CONFIRMATIONCODE}/+accountmerge --data "VALIDATE=Confirm" https://launchpad.net/token/{CONFIRMATIONCODE}/+accountmerge; done' virtually uninterrupted (apart for a few seconds twice) since Friday evening (about 22.00 UTC) until today (about 14:00 UTC Sunday).

The merging process still isn't finished, despite the fact that each request takes about 15 seconds and CURL has been running for about 40 hours now. Is this normal, or doesn't Launchpad save all steps of the merge?

Revision history for this message
Curtis Hovey (sinzui) said :
#6

Launchpad does save all the steps. I think something else is amiss. production data was copied to staging yesterday, and I can see from the timeout that the death is in a function. I suspect that we cannot never complete and commit what is expected to be a small step:

Module lp.registry.model.person, line 3642, in _mergeTranslationMessage

LaunchpadTimeoutError: Statement:
UPDATE TranslationMessage
SET submitter=455815\n WHERE submitter=3368841
CONTEXT: SQL statement "UPDATE POFileTranslator SET date_last_touched = CURRENT_TIMESTAMP AT TIME ZONE \'UTC\', latest_message = $1 FROM POFile, TranslationTemplateItem WHERE person = $2 AND TranslationTemplateItem.potmsgset= $3 AND TranslationTemplateItem.potemplate=pofile.potemplate AND pofile.language= $4 AND POFileTranslator.pofile = pofile.id"
PL/pgSQL function "mv_pofiletranslator_translationmessage" line 68 at SQL statement',)

I will attempt to reconstruct the query and ask an admin to run it. Then you might be able to complete the merge.

Revision history for this message
Sense Egbert Hofstede (sense) said :
#7

That would be awesome. Thanks for your efforts!

Revision history for this message
Sense Egbert Hofstede (sense) said :
#8

Have you had time to look into this query?

Revision history for this message
Curtis Hovey (sinzui) said :
#9

I am so sorry for not following up on this. I did check and the query was a trigger, not a function that i hoped to run offline. We are working on a final fix for this issue. I expect we can merge you profile in the next 2 weeks.

Revision history for this message
Curtis Hovey (sinzui) said :
#10

We have just release a major change to the merge infrastructure to perform the hard work offline. Try merging again. I expect Lp to send you an email with in 1 hour to confirm it is complete.

Revision history for this message
Sense Egbert Hofstede (sense) said :
#11

My accounts are now succesfully merged! Thank you for your assistance!