Internal API error for translation save API
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	• santhosh
	Mar 10 2016, 11:52 AM

Description

When I analysed the errors for past weeks for cxsave API from eventlogging, I got some 12 occurances of this error:

{"servedby":"mw1116","error":{"code":"internal_api_error_DBQueryError","info":"[4326b26f] Database query error"},"errorCode":"internal_api_error_DBQueryError"}

The sourceLanguage sourceTitle targetLanguage information for these translations are given below

en	Michael Maloney	he
fr	Ousmane Dembélé	es
en	List of prizes known as the Nobel of a field	ar
en	APEX Airlines	my
en	Hong Kong International Airport	my
en	Attalid dynasty	sq
en	List of A Song of Ice and Fire characters	pt
en	Zach Sobiech	it
en	Delrina	es
ru	Кофе	ba
en	Adewale Akinnuoye-Agbaje	ar
en	Euler's laws of motion	ca

Minimum timestamp is 20160303230233 - so I infer that they are side effect March 3rd deployment where we deployed the storage migration of CX.

Details

	Subject	Repo	Branch	Lines +/-
	Reduce duplicate key errors on inserts	mediawiki/extensions/ContentTranslation	master	+41 -25

Customize query in gerrit

Related Objects

Mentioned In: T134245: Internal database error while saving translations

Event Timeline

• santhosh created this task.Mar 10 2016, 11:52 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 10 2016, 11:52 AM

• santhosh triaged this task as High priority.Mar 10 2016, 11:53 AM

• santhosh added a project: LE-CX8-Sprint break.

• santhosh added a subscriber: Nikerabbit.

Except 3 items, all of the above articles are successfully published in target wiki using CX

Arrbee edited projects, added LE-CX8-Sprint 4; removed LE-CX8-Sprint break.Mar 14 2016, 6:51 AM

• santhosh assigned this task to Nikerabbit.Mar 15 2016, 5:35 AM

Nikerabbit moved this task from Backlog to In Progress on the LE-CX8-Sprint 4 board.Mar 15 2016, 9:09 AM

From logstash:

Query:
INSERT  INTO `cx_corpora` (cxc_translation_id,cxc_section_id,cxc_origin,cxc_sequence_id,cxc_timestamp,cxc_content)
VALUES ('125397','mwKw','Apertium','242','20160307111802','[removed]');

Function: ContentTranslation\TranslationStorageManager::create
Error: 1062 Duplicate entry '125397-Apertium-mwKw-20160307111802' for key 'cx_corpora_unique' (10.64.16.18)

Likely a race condition on creation (time of check vs. time of insertion). Unlikely to cause any significant data loss.

Change 277485 had a related patch set uploaded (by Nikerabbit):
Reduce duplicate key errors on inserts

https://gerrit.wikimedia.org/r/277485

gerritbot added a project: Patch-For-Review.Mar 15 2016, 10:38 AM

Nikerabbit moved this task from In Progress to In Review on the LE-CX8-Sprint 4 board.Mar 15 2016, 10:42 AM

Change 277485 merged by jenkins-bot:
Reduce duplicate key errors on inserts

https://gerrit.wikimedia.org/r/277485

Nikerabbit moved this task from In Review to QA on the LE-CX8-Sprint 4 board.Mar 16 2016, 9:47 AM

ReleaseTaggerBot added a project: MW-1.27-release (WMF-deploy-2016-03-22_(1.27.0-wmf.18)).Mar 16 2016, 10:00 AM

Amire80 added a project: Essential-Work.Mar 19 2016, 11:36 AM

Amire80 moved this task from Needs Triage to CX8 on the ContentTranslation board.Mar 23 2016, 6:37 AM

Arrbee moved this task from QA to Done on the LE-CX8-Sprint 4 board.Mar 29 2016, 6:40 AM

Arrbee closed this task as Resolved.Mar 29 2016, 7:49 AM

• santhosh mentioned this in T134245: Internal database error while saving translations.May 4 2016, 3:31 AM

• Petar.petkovic removed a project: Patch-For-Review.Sep 12 2018, 10:13 AM

• Petar.petkovic removed a subscriber: gerritbot.

Internal API error for translation save APIClosed, ResolvedPublicActions

Description

Details

Related Objects

Event Timeline

Internal API error for translation save API
Closed, ResolvedPublic
Actions