Import error: Lock wait timeout exceeded
Closed, DuplicatePublic
Actions

Assigned To

None

Authored By

	MF-Warburg
	Dec 18 2020, 1:15 PM

Description

Some days ago, importing to eo.wikivoyage, I got an error like this several times:

Malsukcesis la importo: Error 1205: Lock wait timeout exceeded; try restarting transaction (10.64.32.197) Function: WikiPage::insertOn 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 (0,'Rondonio',,0,1,'0.731602890478','20201215152942',0,0)

"Rondonio" (or in other cases other page names) seems to be the name of the page where the error occured.
I believe this was caused by XML files that were "too big" (around 3 or 4 MB, smaller files were imported without problem).
What's causing this and can the error message be made clearer?

Event Timeline

MF-Warburg created this task.Dec 18 2020, 1:15 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 18 2020, 1:15 PM

@MF-Warburg were you importing all revisions? Were templates included? Let us know as much as possible exactly what was going in, so we can go spelunking in the db and the logs with good info. The date, too, if you can recall. Thanks!

I was importing all revisions. Templates were not included resp. in a separate files.

It happened on December 15, and first occurred at ca. 15:30 UTC. I got the error on 9 different files, I believe. Some hours later, @jhsoby managed to import them though he might have split them into smaller files.

Krinkle closed this task as a duplicate of T219702: Page import can fail with "Lock wait timeout exceeded" in WikiPage::insertOn.Apr 9 2022, 8:45 PM

Import error: Lock wait timeout exceededClosed, DuplicatePublicActions

Description

Event Timeline

Import error: Lock wait timeout exceeded
Closed, DuplicatePublic
Actions