Page MenuHomePhabricator
Create Task
Maniphest T67762

on bug submit: Incorrect key file for table './bugzilla/bugs_fulltext.MYI
Closed, ResolvedPublic
Actions

Description

Software error:

DBD::mysql::db do failed: Incorrect key file for table:

'./bugzilla/bugs_fulltext.MYI'

try to repair it

[for Statement "UPDATE bugs_fulltext SET comments = ?, comments_noprivate = ? WHERE bug_id = ?"] at Bugzilla/Bug.pm line 1091
Bugzilla::Bug::_sync_fulltext('Bugzilla::Bug=HASH(0x3f4c0f0)', 'update_short_desc', undef, 'update_comments', 'ARRAY(0x4294a08)') called at Bugzilla/Bug.pm line 1023
Bugzilla::Bug::update('Bugzilla::Bug=HASH(0x3f4c0f0)') called at /srv/org/wikimedia/bugzilla/process_bug.cgi line 366
For help, please send mail to the webmaster (webmaster@wikimedia.org), giving this error message and the time and date of the error.

Version: wmf-deployment
Severity: normal

Details

Reference
bz65762

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:23 AM
• bzimport added a project: Wikimedia-Bugzilla.
• bzimport set Reference to bz65762.
• bzimport added a subscriber: Unknown Object (MLST).
hashar created this task.May 26 2014, 9:05 AM
hashar added a comment.May 26 2014, 9:06 AM

Happened on a few bugs this morning. The last one was adding a comment and resolving https://bugzilla.wikimedia.org/show_bug.cgi?id=65677 . The change went in just fine though.

hashar added a comment.May 26 2014, 9:18 AM

Giuseppe "_joe_" Lavagetto repaired table bugzilla.bugs_fulltext on db1001 as it was marked as crashed

Aklapper added a comment.May 26 2014, 10:28 AM

Urgh. Thanks for quickly handling this. :-/

Gerrit Notification Bot changed status in bug 65677 without previously inserting the comment with the link to the Gerrit change, as usual.

Upstream closed as INVALID:
https://bugzilla.mozilla.org/show_bug.cgi?id=955799#c1

Aklapper added a comment.May 27 2014, 2:11 AM

Oh, I now see the outage thread on ops@ (outage 2014-05-26 08:30:25). Alright.

hashar added a comment.May 27 2014, 7:21 AM

The table being crashed, that prevented the Gerrit bot comment to be submitted though the status (i.e. NEW -> PATCH_TO_REVIEW) would.

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL