Topic on Extension talk:ConfirmAccount

Everytime I fill and click the request account button the page loads for a while before it goes blank. Log:

2017-10-18 01:40:16 fbc2b63702c5 wikidb: [71e6cc371daeb32c40983f62] /Special:RequestAccount   Wikimedia\Rdbms\DBQueryError from line 1075 of /var/www/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 

 Query: INSERT  INTO `account_requests` (acr_id,acr_name,acr_email,acr_real_name,acr_registration,acr_bio,acr_notes,acr_urls,acr_type,acr_areas,acr_filename,acr_storage_key,acr_comment,acr_ip,acr_xff,acr_agent,acr_deleted,acr_email_token,acr_email_token_expires) VALUES (NULL,'Wawa','wawa@gmail.com','','20171018013815','','na','','0','',NULL,'wikidb:acctrequest:ip:209.58.135.67','','209.58.135.67','','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36','0','cdf2692dd4d49a49037dae473e6b92d3','20171117013815')

 Function: UserAccountRequest::insertOn

 Error: 1205 Lock wait timeout exceeded; try restarting transaction (percona)

 #0 /var/www/includes/libs/rdbms/database/Database.php(933): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

 #1 /var/www/includes/libs/rdbms/database/Database.php(1515): Wikimedia\Rdbms\Database->query(string, string)

 #2 /var/www/extensions/ConfirmAccount/backend/UserAccountRequest.php(358): Wikimedia\Rdbms\Database->insert(string, array, string)

 #3 /var/www/extensions/ConfirmAccount/business/AccountRequestSubmission.php(245): UserAccountRequest->insertOn()

 #4 /var/www/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php(344): AccountRequestSubmission->submit(RequestContext)

 #5 /var/www/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php(84): RequestAccountPage->doSubmit()

 #6 /var/www/includes/specialpage/SpecialPage.php(522): RequestAccountPage->execute(NULL)

 #7 /var/www/includes/specialpage/SpecialPageFactory.php(578): SpecialPage->run(NULL)

 #8 /var/www/includes/MediaWiki.php(287): SpecialPageFactory::executePath(Title, RequestContext)

 #9 /var/www/includes/MediaWiki.php(862): MediaWiki->performRequest()

 #10 /var/www/includes/MediaWiki.php(523): MediaWiki->main()

 #11 /var/www/index.php(43): MediaWiki->run()

 #12 {main}

Database schema updater was run more than once with no difference in results.

Locking usually just indicates contention. I can't reproduce this on PostgreSQL, which also has similar row-level locking. It might be interference by another extension. You can use SHOW ENGINE INNODB STATUS to see the last deadlock. You might need to adjust innodb_lock_wait_timeout and turn on innodb_deadlock_detect (see https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlock-detection.html ).

I did enable innodb_print_all_deadlocks. innodb_lock_wait_timeout was already at 120 innodb_deadlock_detect was enabled. Please see the SHOW ENGINE INNODB STATUS output here https://pastebin.com/m9KUwHBf. After multiple failed attempts: https://pastebin.com/cRvB8bEa