Page MenuHomeMiraheze

Unstick schema change
Closed, ResolvedPublic

Description

(
    [ID] => 661222
    [USER] => mediawiki
    [DB] => 1134819wiki
    [COMMAND] => Query
    [TIME] => 29214
    [STATE] => Waiting for table metadata lock
    [INFO] => CREATE /* MwSql::execute www-data@mw11 */ INDEX oi_timestamp ON `oldimage` (oi_timestamp)
    [TIME_MS] => 29214759.322
    [STAGE] => 0
    [MAX_STAGE] => 0
    [PROGRESS] => 0.000
    [MEMORY_USED] => 94336
    [MAX_MEMORY_USED] => 94336
    [EXAMINED_ROWS] => 0
    [QUERY_ID] => 28462463
    [INFO_BINARY] => CREATE /* MwSql::execute www-data@mw11 */ INDEX oi_timestamp ON `oldimage` (oi_timestamp)
    [TID] => 27097
)

Event Timeline

RhinosF1 triaged this task as High priority.Oct 13 2021, 06:40
RhinosF1 created this task.
John claimed this task.
John subscribed.

This was caused by the DB backup testing it seems, as once I killed the backup the query become unstuck.