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 = ?
> > > > 聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽WHERE 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.
--
Trond Myklebust
Linux NFS client maintainer, PrimaryData
trond.myklebust@xxxxxxxxxxxxxxx
��.n��������+%������w��{.n�����{��w��� jg��� �����ݢj����G���� ���j:+v���w�m������w�������h�����٥
