Page MenuHomePhabricator

Unfinished migration to db1048 causing issues
Closed, ResolvedPublic

Description

It looks like some people are having trouble querying db1047 the way it's set up right now. For example:

MySQL said: Table 'MobileWebEditing_7675117' is marked as crashed and should be repaired

That happens when executing the sql in this change: http://git.wikimedia.org/blobdiff/analytics%2Flimn-mobile-data.git/ca19e8d56ee71402a827a43fec9c5b66c06eed02/mobile%2Fconfig.yaml


Version: unspecified
Severity: normal

Details

Reference
bz64445

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:22 AM
bzimport set Reference to bz64445.

For background, we announced yesterday that we would migrate event logging to write to db1048 instead of db1047. Sean is in the process of finishing this up and has set up db1047 to use federated tables with the CONNECT engine to access data on db1048. It seems there's some glitch with/around this setup, as this issue shows.

This bug happened: https://mariadb.atlassian.net/browse/MDEV-6142

Not going to try to fix it, just get db1047 replicating as planned.