https://bugzilla.wikimedia.org/show_bug.cgi?id=71043
--- Comment #4 from metatron <[email protected]> --- Database is now accessible through c3 again, but unusable because of a continuing lock. Waiting for table metadata lock | SELECT * FROM p50380g50769__wvs2.v_daystats Limit 10 +----------------------+---------------+--------+ | Database | Table | In_use | +----------------------+---------------+--------+ | p50380g50769__wvs2ds | _xlog_v1 | 0 | | p50380g50769__wvs2ds | daystats_grok | 0 | | p50380g50769__wvs2ds | xlog | 1 | | p50380g50769__wvs2ds | daystats2 | 1 | +----------------------+---------------+--------+ I'm not able to unlock/see what kind of process is holding this lock. What's that process? After yesterdays IRC conversation db suddenly changed to a state as it should look like if unattached/unused: +--------------------+------------------------+--------+- | Database | Table | In_use | +--------------------+------------------------+--------+- | p50380g50769__wvs2 | xcache | 0 | | p50380g50769__wvs2 | v_daystatsimp | 0 | | p50380g50769__wvs2 | pagemap | 0 | | p50380g50769__wvs2 | daystats2 | 0 | | p50380g50769__wvs2 | import_dumps | 0 | | p50380g50769__wvs2 | v_import_grok | 0 | | p50380g50769__wvs2 | rawstats2 | 0 | | p50380g50769__wvs2 | tmp | 0 | | p50380g50769__wvs2 | meta | 0 | | p50380g50769__wvs2 | topstats | 0 | | p50380g50769__wvs2 | v_daystats_unique | 0 | | p50380g50769__wvs2 | v_topstats | 0 | | p50380g50769__wvs2 | projectmap | 0 | | p50380g50769__wvs2 | v_rawstats3 | 0 | | p50380g50769__wvs2 | import_status | 0 | | p50380g50769__wvs2 | filter | 0 | | p50380g50769__wvs2 | xstate | 0 | | p50380g50769__wvs2 | topinfo | 0 | | p50380g50769__wvs2 | v_rawstats3top | 0 | | p50380g50769__wvs2 | xlog | 0 | | p50380g50769__wvs2 | catmap | 0 | | p50380g50769__wvs2 | v_tmptop_day | 0 | | p50380g50769__wvs2 | rawstats3 | 0 | | p50380g50769__wvs2 | v_tmptop_month | 0 | | p50380g50769__wvs2 | tmptop_day | 0 | | p50380g50769__wvs2 | l10n | 0 | | p50380g50769__wvs2 | v_daystats | 0 | | p50380g50769__wvs2 | xconfig | 0 | | p50380g50769__wvs2 | rawstats1 | 0 | | p50380g50769__wvs2 | import_grok | 0 | | p50380g50769__wvs2 | import_requests | 0 | | p50380g50769__wvs2 | daystatsimp | 0 | | p50380g50769__wvs2 | v_daystats_unique_grok | 0 | | p50380g50769__wvs2 | v_topstats_dev | 0 | | p50380g50769__wvs2 | tmptop_month | 0 | +--------------------+------------------------+--------+- Still not sure what was going on here, but as said, the current persistent lock is blocking db-usage. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
