Hi,
just a quick heads up that the replication lag on both * analytics-store.eqiad.wmnet (i.e.: dbstore1002), and * s1-analytics-slave (i.e.: db1047) is currently at 41 hours and quickly increasing.
I filed RT ticket 8636: https://rt.wikimedia.org/Ticket/Display.html?id=8636
Best regards, Christian
Hi,
On Sun, Oct 12, 2014 at 11:31:23PM +0200, Christian Aistleitner wrote:
just a quick heads up that the replication lag on both
- analytics-store.eqiad.wmnet (i.e.: dbstore1002), and
The lag on analytics-store.eqiad.wmnet (i.e.: dbstore1002) is back to normal. So if you run queries against EventLogging tables, use that host for now.
- s1-analytics-slave (i.e.: db1047)
The lag on s1-analytics-slave (i.e.: db1047) is decreasing, but has not yet fully recovered (currently around 38 hours).
Best regards, Christian
Thanks Christian.
On Tue, Oct 14, 2014 at 3:28 AM, Christian Aistleitner < christian@quelltextlich.at> wrote:
Hi,
On Sun, Oct 12, 2014 at 11:31:23PM +0200, Christian Aistleitner wrote:
just a quick heads up that the replication lag on both
- analytics-store.eqiad.wmnet (i.e.: dbstore1002), and
The lag on analytics-store.eqiad.wmnet (i.e.: dbstore1002) is back to normal. So if you run queries against EventLogging tables, use that host for now.
- s1-analytics-slave (i.e.: db1047)
The lag on s1-analytics-slave (i.e.: db1047) is decreasing, but has not yet fully recovered (currently around 38 hours).
Best regards, Christian
-- ---- quelltextlich e.U. ---- \ ---- Christian Aistleitner ---- Companies' registry: 360296y in Linz Christian Aistleitner Kefermarkterstrasze 6a/3 Email: christian@quelltextlich.at 4293 Gutau, Austria Phone: +43 7946 / 20 5 81 Fax: +43 7946 / 20 5 81 Homepage: http://quelltextlich.at/
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Hi,
On Tue, Oct 14, 2014 at 12:28:55PM +0200, Christian Aistleitner wrote:
[ replication lag for log database ]
The lag on s1-analytics-slave (i.e.: db1047) is decreasing, but has not yet fully recovered (currently around 38 hours).
The replication lag on s1-analytics-slave is gone too. So m2 tables are up-to-date again.
Have fun, Christian