Page MenuHomePhabricator
Create Task
Maniphest T204476

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

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.

Related Objects
Search...

Event Timeline

KartikMistry created this task.Sep 17 2018, 8:36 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 17 2018, 8:36 AM
• Marostegui added a comment.Sep 17 2018, 8:42 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?

jcrespo added a parent task: T30499: [DO NOT USE] 1205: Lock wait timeout exceeded; try restarting transaction (tracking).Sep 17 2018, 8:46 AM
jcrespo edited projects, added MediaWiki-Core-Snapshots, Wikimedia-production-error; removed DBA.
TTO subscribed.Sep 17 2018, 8:52 AM

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

KartikMistry added a comment.Sep 17 2018, 10:51 AM
In T204476#4587739, @TTO wrote:

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.

KartikMistry added a comment.Sep 17 2018, 10:52 AM

Also, as per https://gu.wikipedia.org/wiki/%E0%AA%B5%E0%AA%BF%E0%AA%B6%E0%AB%87%E0%AA%B7:%E0%AA%B2%E0%AB%89%E0%AA%97/import (ie Import log), template is imported.

• Marostegui unsubscribed.Sep 17 2018, 10:57 AM
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
Krinkle moved this task from Untriaged to Apr 2019 / 1.33.wmf.25+ on the Wikimedia-production-error board.
TTO closed this task as a duplicate of T121336: Better handling of timeouts during the import process.Sep 18 2018, 11:11 PM
Krinkle moved this task from Apr 2019 / 1.33.wmf.25+ to Resolved on the Wikimedia-production-error board.Mar 25 2019, 10:35 PM
Restricted Application added a subscriber: Liuxinyu970226. · View Herald TranscriptMar 25 2019, 10:35 PM
Liuxinyu970226 unsubscribed.Mar 26 2019, 12:14 AM
• mmodell changed the subtype of this task from "Task" to "Production Error".Aug 28 2019, 11:08 PM
Aklapper mentioned this in T236595: Error importing module to outreach wiki.Oct 26 2019, 5:14 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL