Page MenuHomePhabricator

Function: WikiPage::insertOn Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.0.205)
Closed, DuplicatePublic

Description

Today when I was trying to Import some templates in hiwikiversity from enwiki. I get below error.

आयात विफल हुआ: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: INSERT IGNORE INTO `page` (page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len) VALUES ('10','Cite_web','','0','1','0.449833574053','20180626090321','0','0') Function: WikiPage::insertOn Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.0.205)

Steps of reproduction

Event Timeline

Restricted Application added a project: User-Jayprakash12345. · View Herald TranscriptJun 26 2018, 9:09 AM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Is this reproducible? What are the steps to reproduce? Also, the screenshot is missing an URL address.
Please see and follow https://mediawiki.org/wiki/How_to_report_a_bug when creating tasks.

Could you please verify that the problem still exists? This might have been a temporary issue / cache issues on the client side, if I understand the SRE team correctly.

Could you please verify that the problem still exists?

This time I get Service Temporarily Unavailable Error after few minutes later.

TTO added a subscriber: TTO.

Bad things happen if you try to do huge imports. To make the import work, try turning off "import all revisions of the page" - it's not required for license compliance so long as you link back to the source page (which the import process does automatically anyway).

The root issue here is T121336: Better handling of timeouts during the import process.

Vvjjkkii renamed this task from Function: WikiPage::insertOn Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.0.205) to gaaaaaaaaa.Jul 1 2018, 1:01 AM
Vvjjkkii reopened this task as Open.
Vvjjkkii triaged this task as High priority.
Vvjjkkii updated the task description. (Show Details)
Vvjjkkii removed a subscriber: Aklapper.
JJMC89 renamed this task from gaaaaaaaaa to Function: WikiPage::insertOn Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.0.205).Jul 1 2018, 2:46 AM
JJMC89 raised the priority of this task from High to Needs Triage.
JJMC89 updated the task description. (Show Details)
JJMC89 added a subscriber: Aklapper.