> On Mar 17, 2017, at 10:36 AM, Trond Myklebust <trondmy@xxxxxxxxxxxxxxx> wrote: > > On Fri, 2017-03-17 at 10:25 -0400, Chuck Lever wrote: >>> On Mar 16, 2017, at 2:23 PM, Chuck Lever <chucklever@xxxxxxxxx> >>> wrote: >>> >>>> >>>> On Mar 16, 2017, at 2:18 PM, Trond Myklebust <trondmy@primarydata >>>> .com> wrote: >>>> >>>> On Thu, 2017-03-16 at 13:59 -0400, Chuck Lever wrote: >>>>> When I tried to add a comment to bug 291, this resulted: >>>>> >>>>> DBD::mysql::db do failed: Incorrect key file for table >>>>> './nfsv4_bugzilla/bugs_fulltext.MYI'; try to repair it [for >>>>> Statement >>>>> "UPDATE bugs_fulltext SET comments = ?, comments_noprivate = ? >>>>> 鑱借伣鑱借伣鑱借伣鑱借伣鑱借伣鑱借伣鑱借伣鑱絎HERE bug_id = ?"] at Bugzilla/Bug.pm line 938. >>>>> Bugzilla::Bug::_sync_fulltext(Bugzilla::Bug=HASH(0x3a1a >>>>> 278)) >>>>> called at Bugzilla/Bug.pm line 886 >>>>> Bugzilla::Bug::update(Bugzilla::Bug=HASH(0x3a1a278), >>>>> "2017-03- >>>>> 16 10:58:16") called at /home/linux- >>>>> nfs.org/nfsv4_bugzilla/process_bug.cgi line 547 >>>>> >>>>> Happened twice out of two attempts. >>>> >>>> The backing mariadb database needed repair following a crash. I'm >>>> hoping it is working now. Can you please retry? >>> >>> Still not working. I guess this looks like the same error message. >>> >>> DBD::mysql::db do failed: Incorrect key file for table >>> './nfsv4_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 938. >>> Bugzilla::Bug::_sync_fulltext(Bugzilla::Bug=HASH(0x421c4d8)) >>> called at Bugzilla/Bug.pm line 886 >>> Bugzilla::Bug::update(Bugzilla::Bug=HASH(0x421c4d8), "2017-03- >>> 16 11:22:07") called at /home/linux- >>> nfs.org/nfsv4_bugzilla/process_bug.cgi line 547 >> >> P'haps the easiest approach is to restore from a known-good backup, >> and then replay recent changes. >> > I did a rebuild of the database table entries after your second attempt > failed yesterday. I've seen no further errors in the logs since then. Confirmed, it appears to be working now. Thanks! -- Chuck Lever -- To unsubscribe from this list: send the line "unsubscribe linux-nfs" in the body of a message to majordomo@xxxxxxxxxxxxxxx More majordomo info at http://vger.kernel.org/majordomo-info.html
