MediaWiki Internal Error on Create Account (User::addToDatabase: hit a key conflict attempting to insert user 'SomeUserName')

134 views
Skip to first unread message

Gerald O'Sullivan

unread,
May 28, 2017, 12:56:24 AM5/28/17
to iDempiere
This not a problem with the iDempiere system, but with the wiki instead. 

When I try to create a new user in order to login, I an error message about a key conflict attempting to insert user.

Note that I have not created the user before, so it is not a duplicate.

For example, if I enrol a made-up user name "SomeUserName:, I get the same error:


Internal error

[05391bcac485871929104ff3] /w-en/index.php?title=Special:CreateAccount&returnto=Main+Page MWException from line 3990 of /home/idempiere/mediawiki-1.27.1/includes/user/User.php: User::addToDatabase: hit a key conflict attempting to insert user 'SomeUserName' row, but it was not present in select!

Backtrace:

#0 /home/idempiere/mediawiki-1.27.1/includes/auth/AuthManager.php(1342): User->addToDatabase()
#1 /home/idempiere/mediawiki-1.27.1/includes/auth/AuthManager.php(1069): MediaWiki\Auth\AuthManager->continueAccountCreation(array)
#2 /home/idempiere/mediawiki-1.27.1/includes/specialpage/AuthManagerSpecialPage.php(360): MediaWiki\Auth\AuthManager->beginAccountCreation(User, array, string)
#3 /home/idempiere/mediawiki-1.27.1/includes/specialpage/AuthManagerSpecialPage.php(484): AuthManagerSpecialPage->performAuthenticationStep(string, array)
#4 [internal function]: AuthManagerSpecialPage->handleFormSubmit(array, VFormHTMLForm)
#5 /home/idempiere/mediawiki-1.27.1/includes/htmlform/HTMLForm.php(613): call_user_func(array, array, VFormHTMLForm)
#6 /home/idempiere/mediawiki-1.27.1/includes/specialpage/AuthManagerSpecialPage.php(418): HTMLForm->trySubmit()
#7 /home/idempiere/mediawiki-1.27.1/includes/specialpage/LoginSignupSpecialPage.php(293): AuthManagerSpecialPage->trySubmit()
#8 /home/idempiere/mediawiki-1.27.1/includes/specialpage/SpecialPage.php(479): LoginSignupSpecialPage->execute(NULL)
#9 /home/idempiere/mediawiki-1.27.1/includes/specialpage/SpecialPageFactory.php(576): SpecialPage->run(NULL)
#10 /home/idempiere/mediawiki-1.27.1/includes/MediaWiki.php(282): SpecialPageFactory::executePath(Title, RequestContext)
#11 /home/idempiere/mediawiki-1.27.1/includes/MediaWiki.php(745): MediaWiki->performRequest()
#12 /home/idempiere/mediawiki-1.27.1/includes/MediaWiki.php(519): MediaWiki->main()
#13 /home/idempiere/mediawiki-1.27.1/index.php(43): MediaWiki->run()
#14 {main}

Carlos Antonio Ruiz Gomez

unread,
May 29, 2017, 10:48:42 PM5/29/17
to idem...@googlegroups.com
Hi Gerald,

This error has been hitting us intermittently since some time.

I just noticed you're trying to create the user coming from the english wiki (w-en)

Can you please try with the main wiki and give us feedback if that solves the problem?
Here:
http://wiki.idempiere.org/w/index.php?title=Special:CreateAccount&returnto=Main+Page

Regards,

Carlos Ruiz
--

Gerald O'Sullivan

unread,
Jun 9, 2017, 10:23:49 AM6/9/17
to idem...@googlegroups.com
Hi Carlos

Sorry for the slow response.

Yes, I can confirm that the problem does NOT occur on the main wiki page. I am now successfully enrolled on the system!

Many thanks for your assistance and good luck with hunting down the cause. Intermittent errors are the worst. At least you have one extra data point :-)

Best 
Gerald

--
You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/AsXrR6eR4Ng/unsubscribe.
To unsubscribe from this group and all its topics, send an email to idempiere+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/caf1803f-5407-7d10-c563-22d3a11a271f%40gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages