Page MenuHomePhabricator

Cannot load from mysql.proc. The table is probably corrupted
Closed, ResolvedPublic

Description

Author: daniel

Description:
I'm trying to load some stored procedures onto the tool labs replica
but I get: ERROR 1548 (HY000) at line 1: Cannot load from mysql.proc. The table is probably corrupted

This happens for server 192.168.99.7

The error is triggered by

DROP PROCEDURE IF EXISTS InsertLabel;


Version: unspecified
Severity: normal

Details

Reference
bz60907

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:58 AM
bzimport added a project: Toolforge.
bzimport set Reference to bz60907.

Assigning to Sean as DBA. 192.168.99.7 should be s7/10.64.37.5:3308.

The table was intact but not upgraded to the structure expected by MariaDB 5.5.

The problem occurred upstream on sanitarium db1057:3308 during or before April 2013 (earliest extent of the error log) where mysql_upgrade was either forgotten or failed to complete. labsdb1003 then inherited the out-of-date table during a rebuild.

Both db1057:3308 and labsdb1003:3308 have been repaired. Other instances are unaffected.