Re: [Analytics] db1047 corruption issues on Edit schema - use analytics-store

2016-03-30 Thread Tilman Bayer
On Tue, Mar 29, 2016 at 3:44 AM, Jaime Crespo wrote: > There seems to be issues with the Edit_13457736 table on the db log, > on the db1047 host. > > db1047 may be known better by some of you as you as > "s1-analytics-slave" or "analytics-slave". You can use dbstore1002 for > the time being ("anal

Re: [Analytics] db1047 corruption issues on Edit schema - use analytics-store

2016-03-30 Thread Jaime Crespo
You can call it restart, or you can call it (un)controlled crash. The data issues where affecting the whole server, and I had to drop the previously mentioned table (which mysql refused to do while running). Things seem back to normal now, but of course tables will take some time to get refilled,

Re: [Analytics] db1047 corruption issues on Edit schema - use analytics-store

2016-03-30 Thread Nuria Ruiz
Jaime: Seems that there are still problems. Please see: https://phabricator.wikimedia.org/T131236 Thanks, Nuria On Wed, Mar 30, 2016 at 1:54 AM, Jaime Crespo wrote: > You can call it restart, or you can call it (un)controlled crash. The > data issues where affecting the whole server, and I ha

Re: [Analytics] db1047 corruption issues on Edit schema - use analytics-store

2016-03-30 Thread Tilman Bayer
On Wed, Mar 30, 2016 at 10:24 AM, Nuria Ruiz wrote: > Jaime: > > Seems that there are still problems. > Please see: https://phabricator.wikimedia.org/T131236 > Thanks Nuria - actually I filed that bug on Jaime's request (i.e. he already knows about it), and the data discrepancies described there c

Re: [Analytics] db1047 corruption issues on Edit schema - use analytics-store

2016-03-30 Thread Dan Andreescu
For anyone who has reports affected by this (a LOT of people), please let us know if you'd like them to be re-run once the table stabilizes. On Wed, Mar 30, 2016 at 1:30 PM, Tilman Bayer wrote: > On Wed, Mar 30, 2016 at 10:24 AM, Nuria Ruiz wrote: > > Jaime: > > > > Seems that there are still p