Last modified: 2014-02-06 05:01:53 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T62907, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 60907 - Cannot load from mysql.proc. The table is probably corrupted
Cannot load from mysql.proc. The table is probably corrupted
Status: RESOLVED FIXED
Product: Wikimedia Labs
Classification: Unclassified
tools (Other open bugs)
unspecified
All All
: Unprioritized normal
: ---
Assigned To: Sean Pringle
:
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2014-02-05 16:59 UTC by Daniel Schwen
Modified: 2014-02-06 05:01 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Daniel Schwen 2014-02-05 16:59:23 UTC 
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;
Comment 1 Tim Landscheidt 2014-02-05 17:37:54 UTC 
Assigning to Sean as DBA.  192.168.99.7 should be s7/10.64.37.5:3308.
Comment 2 Sean Pringle 2014-02-06 05:01:53 UTC 
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.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links