Maniphest T119742

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

Assigned To

Authored By

	Bunyk
	Nov 26 2015, 10:22 PM

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

	Subject	Repo	Branch	Lines +/-
	Defer the redirect table update in WikiPage::insertRedirect()	mediawiki/core	master	+33 -17

Customize query in gerrit

Related Objects

Mentioned Here: T119820: Lock wait timeout when trying to save "Anexo:Ascensos y descensos de la Categoría Primera A" on eswiki

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 subscribed.

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 26 2015, 10:22 PM

Krenair added projects: DBA, MediaWiki-libs-Rdbms.Nov 26 2015, 10:22 PM

Krenair subscribed.

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

intracer subscribed.Nov 26 2015, 10:33 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

gerritbot added a project: Patch-For-Review.Nov 26 2015, 11:17 PM

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()