Hi,
just a quick heads up that the replication lag on analytics' s5 slave (s5-analytics-slave.eqiad.wmnet, db73.pmtpa.wmnet) slowly rose to
2 hours since 2013-12-10 ~12:00 UTC.
I filed RT ticket 6487: https://rt.wikimedia.org/Ticket/Display.html?id=6487
Best regards, Christian
My RT account is still being approved, so I can't look at the ticket, but the only query running on s5-analytics right now is one of mine. Id=210249 It has been running for nearly 14 days, but I don't suspect that it would suddenly begin to affect replication now.
-Aaron
On Tue, Dec 10, 2013 at 6:58 PM, Christian Aistleitner < christian@quelltextlich.at> wrote:
Hi,
just a quick heads up that the replication lag on analytics' s5 slave (s5-analytics-slave.eqiad.wmnet, db73.pmtpa.wmnet) slowly rose to
2 hours since 2013-12-10 ~12:00 UTC.
I filed RT ticket 6487: https://rt.wikimedia.org/Ticket/Display.html?id=6487
Best regards, Christian
-- ---- quelltextlich e.U. ---- \ ---- Christian Aistleitner ---- Companies' registry: 360296y in Linz Christian Aistleitner Gruendbergstrasze 65a Email: christian@quelltextlich.at 4040 Linz, Austria Phone: +43 732 / 26 95 63 Fax: +43 732 / 26 95 63 Homepage: http://quelltextlich.at/
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Hi Aaron,
On Wed, Dec 11, 2013 at 08:21:31AM -0600, Aaron Halfaker wrote:
My RT account is still being approved, so I can't look at the ticket, but the only query running on s5-analytics right now is one of mine.
I prefer to not copy RT information onto public mailing lists, but ops did not pinpoint a single query to be the culprit, but a combination of several different jobs, and the fact that it seems to be the only pmtpa box for S5 for now.
Best regards, Christian
Hi,
On Wed, Dec 11, 2013 at 01:58:23AM +0100, Christian Aistleitner wrote:
just a quick heads up that the replication lag on analytics' s5 slave (s5-analytics-slave.eqiad.wmnet, db73.pmtpa.wmnet) slowly rose to
2 hours since 2013-12-10 ~12:00 UTC.
Sean updated the s5-analytics-slave.eqiad.wmnet alias from
db73.pmtpa.wmnet (lagging ~15 hours)
to
db1017.eqiad.wmnet (lagging <2 seconds)
. Thanks Sean!
Best regards, Christian