Page MenuHomePhabricator

Lock wait timeout exceeded from WikiPage::insertOn (Unable to import "Template:IPA_Symbol")
Closed, DuplicatePublic

Description

When trying to import Template: IPA Symbol from enwiki -> guwiki import page gives:

આયાત નિષ્ફળ: 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','IPA_symbol','','0','1','0.294925257920','20180917083120','0','0') Function: WikiPage::insertOn Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.192.32.103)

I retried, but result is same.

Note: આયાત નિષ્ફળ = Import failed.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 17 2018, 8:36 AM

We have an innodb_lock_wait_timeout of 50 seconds (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_lock_wait_timeout) so I assume your process is taking more than that and hence MySQL is giving up.
Is there anyway for you to do that import in smaller chunks?

TTO added a subscriber: TTO.Sep 17 2018, 8:52 AM

Do you really need to import all revisions? Just the most recent revision is sufficient for license compliance.

Do you really need to import all revisions? Just the most recent revision is sufficient for license compliance.

Thanks. I'll take care about this in future.

Krinkle renamed this task from Import fails for Template:IPA Symbol to Lock wait timeout exceeded from WikiPage::insertOn (Unable to import "Template:IPA_Symbol").Sep 18 2018, 9:03 PM
Restricted Application added a subscriber: Liuxinyu970226. · View Herald TranscriptMar 25 2019, 10:35 PM
mmodell changed the subtype of this task from "Task" to "Production Error".Wed, Aug 28, 11:08 PM