Page MenuHomePhabricator

Database error at uk:Сетакон page
Closed, ResolvedPublic

Description

When opening page: https://uk.wikipedia.org/wiki/%D0%A1%D0%B5%D1%82%D0%B0%D0%BA%D0%BE%D0%BD

This error is displayed:

A database query error has occurred. This may indicate a bug in the software.

  Function: WikiPage::insertRedirectEntry
  Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.16.22)

Details

Related Gerrit Patches:

Event Timeline

Bunyk created this task.Nov 26 2015, 10:22 PM
Bunyk raised the priority of this task from to High.
Bunyk updated the task description. (Show Details)
Bunyk added a subscriber: Bunyk.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 26 2015, 10:22 PM
Krenair added a subscriber: Krenair.
Pidlisnuk lowered the priority of this task from High to Low.Nov 26 2015, 10:24 PM
Pidlisnuk set Security to None.
Pidlisnuk added a subscriber: Pidlisnuk.

I am an ordinary association has two pages of history, and the result was a database error

Pidlisnuk raised the priority of this task from Low to Needs Triage.Nov 26 2015, 10:30 PM
Restricted Application added a subscriber: StudiesWorld. · View Herald TranscriptNov 26 2015, 10:30 PM
aaron added a subscriber: aaron.Nov 26 2015, 10:46 PM

Did this happen when editing or changing the page somehow or just by viewing it?

Looks like page views (from "+channel:exception +message:*insertRedirectEntry*" in ES log). A spike of errors happened at 22:00 due to contention.

Change 255658 had a related patch set uploaded (by Aaron Schulz):
Defer the redirect table update in WikiPage::insertRedirect()

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

FYI, a similar error happened recently when a user tried to edit a recently history-merged page on eswiki. Probably due to the conflict between the real-time edit and some pending (deferred) activity due to the merging. T119820

Change 255658 merged by jenkins-bot:
Defer the redirect table update in WikiPage::insertRedirect()

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

aaron closed this task as Resolved.Dec 4 2015, 8:35 PM
aaron claimed this task.

This should stop happening on the next code deployment.