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 =3D ?, comments_noprivate =3D ?
WHERE bug_id =3D ?"] at Bugzilla/Bug.pm line 938.
Bugzilla::Bug::_sync_fulltext(Bugzilla::Bug=3DHASH(0x3a1a278)) =
called at Bugzilla/Bug.pm line 886
Bugzilla::Bug::update(Bugzilla::Bug=3DHASH(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.
--
Chuck Lever
[email protected]
T24gVGh1LCAyMDE3LTAzLTE2IGF0IDEzOjU5IC0wNDAwLCBDaHVjayBMZXZlciB3cm90ZToNCj4g
V2hlbiBJIHRyaWVkIHRvIGFkZCBhIGNvbW1lbnQgdG8gYnVnIDI5MSwgdGhpcyByZXN1bHRlZDoN
Cj4gDQo+IERCRDo6bXlzcWw6OmRiIGRvIGZhaWxlZDogSW5jb3JyZWN0IGtleSBmaWxlIGZvciB0
YWJsZQ0KPiAnLi9uZnN2NF9idWd6aWxsYS9idWdzX2Z1bGx0ZXh0Lk1ZSSc7IHRyeSB0byByZXBh
aXIgaXQgW2ZvciBTdGF0ZW1lbnQNCj4gIlVQREFURSBidWdzX2Z1bGx0ZXh0IFNFVCBjb21tZW50
cyA9ID8sIGNvbW1lbnRzX25vcHJpdmF0ZSA9ID8NCj4gwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg
wqDCoMKgV0hFUkUgYnVnX2lkID0gPyJdIGF0IEJ1Z3ppbGxhL0J1Zy5wbSBsaW5lIDkzOC4NCj4g
CUJ1Z3ppbGxhOjpCdWc6Ol9zeW5jX2Z1bGx0ZXh0KEJ1Z3ppbGxhOjpCdWc9SEFTSCgweDNhMWEy
NzgpKQ0KPiBjYWxsZWQgYXQgQnVnemlsbGEvQnVnLnBtIGxpbmUgODg2DQo+IAlCdWd6aWxsYTo6
QnVnOjp1cGRhdGUoQnVnemlsbGE6OkJ1Zz1IQVNIKDB4M2ExYTI3OCksICIyMDE3LTAzLQ0KPiAx
NiAxMDo1ODoxNiIpIGNhbGxlZCBhdCAvaG9tZS9saW51eC0NCj4gbmZzLm9yZy9uZnN2NF9idWd6
aWxsYS9wcm9jZXNzX2J1Zy5jZ2kgbGluZSA1NDcNCj4gDQo+IEhhcHBlbmVkIHR3aWNlIG91dCBv
ZiB0d28gYXR0ZW1wdHMuDQoNClRoZSBiYWNraW5nIG1hcmlhZGIgZGF0YWJhc2UgbmVlZGVkIHJl
cGFpciBmb2xsb3dpbmcgYSBjcmFzaC4gSSdtDQpob3BpbmcgaXQgaXMgd29ya2luZyBub3cuIENh
biB5b3UgcGxlYXNlIHJldHJ5Pw0KDQotLSANClRyb25kIE15a2xlYnVzdA0KTGludXggTkZTIGNs
aWVudCBtYWludGFpbmVyLCBQcmltYXJ5RGF0YQ0KdHJvbmQubXlrbGVidXN0QHByaW1hcnlkYXRh
LmNvbQ0K
> On Mar 16, 2017, at 2:18 PM, Trond Myklebust <[email protected]> =
wrote:
>=20
> On Thu, 2017-03-16 at 13:59 -0400, Chuck Lever wrote:
>> When I tried to add a comment to bug 291, this resulted:
>>=20
>> 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 =3D ?, comments_noprivate =3D ?
>> =E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=
=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BDWHERE =
bug_id =3D ?"] at Bugzilla/Bug.pm line 938.
>> Bugzilla::Bug::_sync_fulltext(Bugzilla::Bug=3DHASH(0x3a1a278))
>> called at Bugzilla/Bug.pm line 886
>> Bugzilla::Bug::update(Bugzilla::Bug=3DHASH(0x3a1a278), "2017-03-
>> 16 10:58:16") called at /home/linux-
>> nfs.org/nfsv4_bugzilla/process_bug.cgi line 547
>>=20
>> Happened twice out of two attempts.
>=20
> 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 =3D ?, comments_noprivate =3D ?
WHERE bug_id =3D ?"] at Bugzilla/Bug.pm line 938.
Bugzilla::Bug::_sync_fulltext(Bugzilla::Bug=3DHASH(0x421c4d8)) =
called at Bugzilla/Bug.pm line 886
Bugzilla::Bug::update(Bugzilla::Bug=3DHASH(0x421c4d8), =
"2017-03-16 11:22:07") called at =
/home/linux-nfs.org/nfsv4_bugzilla/process_bug.cgi line 547
--
Chuck Lever
[email protected]
> On Mar 16, 2017, at 2:23 PM, Chuck Lever <[email protected]> wrote:
>=20
>>=20
>> On Mar 16, 2017, at 2:18 PM, Trond Myklebust =
<[email protected]> wrote:
>>=20
>> On Thu, 2017-03-16 at 13:59 -0400, Chuck Lever wrote:
>>> When I tried to add a comment to bug 291, this resulted:
>>>=20
>>> 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 =3D ?, comments_noprivate =3D ?
>>> =E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=
=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BD=E8=81=BDWHERE =
bug_id =3D ?"] at Bugzilla/Bug.pm line 938.
>>> Bugzilla::Bug::_sync_fulltext(Bugzilla::Bug=3DHASH(0x3a1a278))
>>> called at Bugzilla/Bug.pm line 886
>>> Bugzilla::Bug::update(Bugzilla::Bug=3DHASH(0x3a1a278), "2017-03-
>>> 16 10:58:16") called at /home/linux-
>>> nfs.org/nfsv4_bugzilla/process_bug.cgi line 547
>>>=20
>>> Happened twice out of two attempts.
>>=20
>> The backing mariadb database needed repair following a crash. I'm
>> hoping it is working now. Can you please retry?
>=20
> Still not working. I guess this looks like the same error message.
>=20
> 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 =3D ?, comments_noprivate =3D ?
> WHERE bug_id =3D ?"] at Bugzilla/Bug.pm line 938.
> Bugzilla::Bug::_sync_fulltext(Bugzilla::Bug=3DHASH(0x421c4d8)) =
called at Bugzilla/Bug.pm line 886
> Bugzilla::Bug::update(Bugzilla::Bug=3DHASH(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.
--
Chuck Lever
[email protected]
T24gRnJpLCAyMDE3LTAzLTE3IGF0IDEwOjI1IC0wNDAwLCBDaHVjayBMZXZlciB3cm90ZToNCj4g
PiBPbiBNYXIgMTYsIDIwMTcsIGF0IDI6MjMgUE0sIENodWNrIExldmVyIDxjaHVja2xldmVyQGdt
YWlsLmNvbT4NCj4gPiB3cm90ZToNCj4gPiANCj4gPiA+IA0KPiA+ID4gT24gTWFyIDE2LCAyMDE3
LCBhdCAyOjE4IFBNLCBUcm9uZCBNeWtsZWJ1c3QgPHRyb25kbXlAcHJpbWFyeWRhdGENCj4gPiA+
IC5jb20+IHdyb3RlOg0KPiA+ID4gDQo+ID4gPiBPbiBUaHUsIDIwMTctMDMtMTYgYXQgMTM6NTkg
LTA0MDAsIENodWNrIExldmVyIHdyb3RlOg0KPiA+ID4gPiBXaGVuIEkgdHJpZWQgdG8gYWRkIGEg
Y29tbWVudCB0byBidWcgMjkxLCB0aGlzIHJlc3VsdGVkOg0KPiA+ID4gPiANCj4gPiA+ID4gREJE
OjpteXNxbDo6ZGIgZG8gZmFpbGVkOiBJbmNvcnJlY3Qga2V5IGZpbGUgZm9yIHRhYmxlDQo+ID4g
PiA+ICcuL25mc3Y0X2J1Z3ppbGxhL2J1Z3NfZnVsbHRleHQuTVlJJzsgdHJ5IHRvIHJlcGFpciBp
dCBbZm9yDQo+ID4gPiA+IFN0YXRlbWVudA0KPiA+ID4gPiAiVVBEQVRFIGJ1Z3NfZnVsbHRleHQg
U0VUIGNvbW1lbnRzID0gPywgY29tbWVudHNfbm9wcml2YXRlID0gPw0KPiA+ID4gPiDogb3ogb3o
gb3ogb3ogb3ogb3ogb3ogb3ogb3ogb3ogb3ogb3ogb3ogb3ogb1XSEVSRSBidWdfaWQgPSA/Il0g
YXQgQnVnemlsbGEvQnVnLnBtIGxpbmUgOTM4Lg0KPiA+ID4gPiAJQnVnemlsbGE6OkJ1Zzo6X3N5
bmNfZnVsbHRleHQoQnVnemlsbGE6OkJ1Zz1IQVNIKDB4M2ExYQ0KPiA+ID4gPiAyNzgpKQ0KPiA+
ID4gPiBjYWxsZWQgYXQgQnVnemlsbGEvQnVnLnBtIGxpbmUgODg2DQo+ID4gPiA+IAlCdWd6aWxs
YTo6QnVnOjp1cGRhdGUoQnVnemlsbGE6OkJ1Zz1IQVNIKDB4M2ExYTI3OCksDQo+ID4gPiA+ICIy
MDE3LTAzLQ0KPiA+ID4gPiAxNiAxMDo1ODoxNiIpIGNhbGxlZCBhdCAvaG9tZS9saW51eC0NCj4g
PiA+ID4gbmZzLm9yZy9uZnN2NF9idWd6aWxsYS9wcm9jZXNzX2J1Zy5jZ2kgbGluZSA1NDcNCj4g
PiA+ID4gDQo+ID4gPiA+IEhhcHBlbmVkIHR3aWNlIG91dCBvZiB0d28gYXR0ZW1wdHMuDQo+ID4g
PiANCj4gPiA+IFRoZSBiYWNraW5nIG1hcmlhZGIgZGF0YWJhc2UgbmVlZGVkIHJlcGFpciBmb2xs
b3dpbmcgYSBjcmFzaC4gSSdtDQo+ID4gPiBob3BpbmcgaXQgaXMgd29ya2luZyBub3cuIENhbiB5
b3UgcGxlYXNlIHJldHJ5Pw0KPiA+IA0KPiA+IFN0aWxsIG5vdCB3b3JraW5nLiBJIGd1ZXNzIHRo
aXMgbG9va3MgbGlrZSB0aGUgc2FtZSBlcnJvciBtZXNzYWdlLg0KPiA+IA0KPiA+IERCRDo6bXlz
cWw6OmRiIGRvIGZhaWxlZDogSW5jb3JyZWN0IGtleSBmaWxlIGZvciB0YWJsZQ0KPiA+ICcuL25m
c3Y0X2J1Z3ppbGxhL2J1Z3NfZnVsbHRleHQuTVlJJzsgdHJ5IHRvIHJlcGFpciBpdCBbZm9yDQo+
ID4gU3RhdGVtZW50ICJVUERBVEUgYnVnc19mdWxsdGV4dCBTRVQgY29tbWVudHMgPSA/LA0KPiA+
IGNvbW1lbnRzX25vcHJpdmF0ZSA9ID8NCj4gPiDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg
V0hFUkUgYnVnX2lkID0gPyJdIGF0IEJ1Z3ppbGxhL0J1Zy5wbSBsaW5lIDkzOC4NCj4gPiAJQnVn
emlsbGE6OkJ1Zzo6X3N5bmNfZnVsbHRleHQoQnVnemlsbGE6OkJ1Zz1IQVNIKDB4NDIxYzRkOCkp
DQo+ID4gY2FsbGVkIGF0IEJ1Z3ppbGxhL0J1Zy5wbSBsaW5lIDg4Ng0KPiA+IAlCdWd6aWxsYTo6
QnVnOjp1cGRhdGUoQnVnemlsbGE6OkJ1Zz1IQVNIKDB4NDIxYzRkOCksICIyMDE3LTAzLQ0KPiA+
IDE2IDExOjIyOjA3IikgY2FsbGVkIGF0IC9ob21lL2xpbnV4LQ0KPiA+IG5mcy5vcmcvbmZzdjRf
YnVnemlsbGEvcHJvY2Vzc19idWcuY2dpIGxpbmUgNTQ3DQo+IA0KPiBQJ2hhcHMgdGhlIGVhc2ll
c3QgYXBwcm9hY2ggaXMgdG8gcmVzdG9yZSBmcm9tIGEga25vd24tZ29vZCBiYWNrdXAsDQo+IGFu
ZCB0aGVuIHJlcGxheSByZWNlbnQgY2hhbmdlcy4NCj4gDQpJIGRpZCBhIHJlYnVpbGQgb2YgdGhl
IGRhdGFiYXNlIHRhYmxlIGVudHJpZXMgYWZ0ZXIgeW91ciBzZWNvbmQgYXR0ZW1wdA0KZmFpbGVk
IHllc3RlcmRheS4gSSd2ZSBzZWVuIG5vIGZ1cnRoZXIgZXJyb3JzIGluIHRoZSBsb2dzIHNpbmNl
IHRoZW4uDQoNCi0tIA0KVHJvbmQgTXlrbGVidXN0DQpMaW51eCBORlMgY2xpZW50IG1haW50YWlu
ZXIsIFByaW1hcnlEYXRhDQp0cm9uZC5teWtsZWJ1c3RAcHJpbWFyeWRhdGEuY29tDQo=
> On Mar 17, 2017, at 10:36 AM, Trond Myklebust <[email protected]> wrote:
>
> On Fri, 2017-03-17 at 10:25 -0400, Chuck Lever wrote:
>>> On Mar 16, 2017, at 2:23 PM, Chuck Lever <[email protected]>
>>> 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