Page MenuHomePhabricator
Create Task
Maniphest T108551

Database locked error while publishing article using CX
Closed, DuplicatePublic
Actions

Description

While analysing CX article creation logs, following error was noted

'2', 'en', 'es', 'Pitchi.com', '{\"servedby\":\"mw####\",\"error\":{\"code\":\"readonly\",\"info\":\"The wiki is currently in read-only mode\",\"readonlyreason\":\"The database has been automatically locked while the slave database servers ', '20150809221918', 'Mirek Alcest'

But I see that https://es.wikipedia.org/wiki/Pitchi.com was indeed created. Source language was en, target language is es. But the contenttranslation tag was not added to the article.

@aaron, any clue on how this can happen? or how to prevent it.

I saw only one instance of this error so far .

Related Objects
Search...

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
· · ·
DuplicateNoneT108551 Database locked error while publishing article using CX
ResolvedaaronT95501 Fix causes of replica lag and get it to under 5 seconds at peak
· · ·

Event Timeline

santhosh created this task.Aug 10 2015, 5:01 AM
santhosh raised the priority of this task from to Medium.
santhosh updated the task description. (Show Details)
santhosh added projects: ContentTranslation-Release6, ContentTranslation.
santhosh added subscribers: santhosh, Aklapper, aaron.
santhosh added a comment.Aug 10 2015, 7:00 AM

Further analysis showed that from August 6th onwards(last deployment date), contenttranslation tags were not added to several articles published. For all such articles, while publishing, following error is reported

{"xhr":{"readyState":4,"responseText":"","status":200,"statusText":"OK"},"textStatus":"parsererror","exception":{}}

AFAIK, this indicate the api returned something that the jquery ajax could not parse. All of such articles was published, just that the tag is missing.

santhosh mentioned this in T108559: While publishing, 'parsererror' is returned, even if publishing succeeds, tags are missing for such articles.Aug 10 2015, 7:08 AM
Amire80 moved this task from Needs Triage to CX6 on the ContentTranslation board.Aug 11 2015, 12:16 PM
Amire80 subscribed.

I saw only one instance of this error so far .

The title sounds scary, but it was indeed only once, then it's Normal prio. Should be raised if it happens more frequently.

Amire80 moved this task from Backlog to Bugs on the ContentTranslation-Release6 board.Aug 14 2015, 1:17 PM
Amire80 added a comment.Oct 1 2015, 8:41 PM

Has this happened again? If it only happened once, I'm inclined to closing it or making the priority lowest.

aaron added a comment.Oct 1 2015, 8:45 PM

Any slave lag spikes will cause this. Avoiding those is T95501.

Amire80 added a subtask: T95501: Fix causes of replica lag and get it to under 5 seconds at peak.Oct 7 2015, 9:20 AM
Amire80 moved this task from CX6 to Upstream/Other teams on the ContentTranslation board.
Amire80 removed a project: ContentTranslation-Release6.Oct 13 2015, 8:24 PM
Amire80 set Security to None.
Amire80 added a project: Essential-Work.Oct 15 2015, 7:18 PM
aaron closed this task as a duplicate of T95501: Fix causes of replica lag and get it to under 5 seconds at peak.Mar 25 2016, 7:31 PM
aaron closed subtask T95501: Fix causes of replica lag and get it to under 5 seconds at peak as Resolved.Mar 25 2021, 12:20 AM
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 · Credits