Last modified: 2014-08-01 08:38:46 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T70993, the corresponding Phabricator task for complete and up-to-date bug report information.

Bug 68993 - Replication lag on analytics-store.eqiad.wmnet >12 hours for s1 replicas


Summary:	Replication lag on analytics-store.eqiad.wmnet >12 hours for s1 replicas

Status:	RESOLVED FIXED

Product:	Analytics
Classification:	Unclassified
Component:	General/Unknown (Other open bugs)
Version:	unspecified
Hardware:	All All

Importance:	Unprioritized normal
Target Milestone:	---
Assigned To:	christian

URL:
Whiteboard:	u=Community c=General/Unknown p=0 s=2...
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2014-08-01 08:34 UTC by christian
Modified:	2014-08-01 08:38 UTC (History)
CC List:	5 users (show)

See Also:
Web browser:	---
Mobile Platform:	---
Assignee Huggle Beta Tester:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description christian 2014-08-01 08:34:54 UTC

Replication lag on analytics-store.eqiad.wmnet was >12 hours since 2014-07-30

Affected databases:
  enwiki
  log

Corresponding RT ticket:
  https://rt.wikimedia.org/Ticket/Display.html?id=8032

Comment 1 christian 2014-08-01 08:38:46 UTC

(In reply to christian from comment #0)
> Corresponding RT ticket:
>   https://rt.wikimedia.org/Ticket/Display.html?id=8032

Ops did not do any work on the databases.

Instead, “only” two long running queries were causing the lag.

We escalated with the the query's owners.
* One query got killed.
* One query finished while discussing the query.

Replication lag is back to normal again for analytics-store.eqiad.wmnet.

Wikimedia Bugzilla is closed!

Search

Personal tools

Navigation

Links