Rss DataBase Errors

[JamieB]

Hi,

Since my upgrade to 3.6.7 PL1 I have been get lots of DB errors

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT text, headers, dateline
FROM externalcache
WHERE cachehash = 'e736f52fb099d9b7f6663788ddbab17f' AND
dateline >= 1180439397;

MySQL Error : Got error 134 from storage engine
Error Number : 1030
Date : Tuesday, May 29th 2007 @ 12:50:57 PM
Script : http://www.myforum/forum/external.php?type=RSS2
Referrer :
IP Address : 82.20.216.102
Username : Unregistered
Classname : vB_Database

Any Idea of what's wrong ?

[Boxy]

The table may be corrupt, try repairing the externalcache table.


Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

AdminCP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

[JamieB]

Thanks that got it....

externalcache Check Warning: Table is marked as crashed

Error: Checksum for key: 2 doesn't match checksum for records externalcache Check
Error: Corrupt externalcache

----------------------------------------------------------------------
externalcache Check Status: OK
externalcache Optimize Status: Table is already up to date


Many thanks


-----------------------------------------------------

It keeps crashing that table, i'll run it a good few times and post back if it continues

Now getting

externalcache Check Warning: Table is marked as crashed

externalcache Check Error: Found key at page 1024 that points to record outside datafile

externalcache Check Error: Corrupt

externalcache

[JamieB]

Errors keep coming back.....

I've tried repairing loads of times now...

Also...

Webhost had to repair externalcache analyze which was Corrupt

Its only when external data is turned on in options, turn it off and no db errors.

Possible bug in PL1 ? I've no suspect issues as far I'm aware off.

[Boxy]

Table corruptions are more likely to be server related. Corruptions are generally caused by busy server resulting in timeouts, MySQL dying or being restarted etc when writing to a table.

[JamieB]

Table corruptions are more likely to be server related. Corruptions are generally caused by busy server resulting in timeouts, MySQL dying or being restarted etc when writing to a table.

Thank You I will check with server host