[Mediawiki-l] mediawiki 1.9.3 error (objectcache?)

[lonelyprophet at hotmail.com]

Hi, I'm having real problems with my mediawiki database.
I'm using 1.9.3, with MySQL 5.0.27-standard, and PHP 5.2.1

The problem is in two stages:

1. The following error appeared, suddenly and unexpectedly. No upgrades to 
the DB aside from entries/edits being made to the wiki, and no changes to 
the php files or anything else in the directory where the wiki is installed.

Original exception: exception 'DBQueryError' with message 'A database error 
has occurred Query: SELECT value,exptime FROM `objectcache` WHERE 
keyname='DBNAME:messages-hash' Function: MediaWikiBagOStuff::_doquery Error: 
1033 Incorrect information in file: './DBNAME/objectcache.frm' (localhost) ' 
in /DBLOCATION/includes/Database.php:708 Stack trace:
0 /DBLOCATION/includes/Database.php(665): 
Database->reportQueryError('Incorrect infor...', 1033, 'SELECT value,ex...', 
'MediaWikiBagOSt...', false)
1 /DBLOCATION/includes/BagOStuff.php(396): Database->query('SELECT 
value,ex...', 'MediaWikiBagOSt...')
2 /DBLOCATION/includes/BagOStuff.php(296): 
MediaWikiBagOStuff->_doquery('SELECT value,ex...')
3 /DBLOCATION/includes/BagOStuff.php(236): SqlBagOStuff->_query('SELECT 
value,ex...', 'DBNAME...')
4 /DBLOCATION/includes/MessageCache.php(206): SqlBagOStuff->get('DBNAME...')
5 /DBLOCATION/includes/MessageCache.php(442): MessageCache->load()
6 /DBLOCATION/includes/GlobalFunctions.php(420): 
MessageCache->get('mainpage', true, true)
7 /DBLOCATION/includes/GlobalFunctions.php(379): wfMsgGetKey('mainpage', 
true, true, true)
8 /DBLOCATION/includes/GlobalFunctions.php(328): wfMsgReal('mainpage', 
Array, true, true)
9 /DBLOCATION/includes/Title.php(275): wfMsgForContent()
10 /DBLOCATION/includes/Wiki.php(74): Title::newMainPage('mainpage')
11 /DBLOCATION/index.php(17): MediaWiki->checkInitialQueries()
12 {main}

Exception caught inside exception handler: exception 'DBUnexpectedError' 
with message 'Error in fetchObject(): Incorrect information in file: 
'./DBNAME/page.frm' (localhost)' in /DBLOCATION/includes/Database.php:825 
Stack trace:
0 /DBLOCATION/includes/MessageCache.php(315): Database->fetchObject(false)
1 /DBLOCATION/includes/MessageCache.php(252): MessageCache->loadFromDB()
2 /DBLOCATION/includes/MessageCache.php(442): MessageCache->load()
3 /DBLOCATION/includes/GlobalFunctions.php(420): 
MessageCache->get('databaseerror', true, false)
4 /DBLOCATION/includes/GlobalFunctions.php(379): 
wfMsgGetKey('databaseerror', true, false, true)
5 /DBLOCATION/includes/Exception.php(18): wfMsgReal('databaseerror', Array)
6 /DBLOCATION/includes/Database.php(212): MWException->msg('databaseerror', 
'Database error')
7 /DBLOCATION/includes/Exception.php(109): DBQueryError->getPageTitle()
8 /DBLOCATION/includes/Exception.php(76): MWException->htmlHeader()
9 /DBLOCATION/includes/Exception.php(95): MWException->reportHTML()
10 /DBLOCATION/includes/Exception.php(171): MWException->report()
11 /DBLOCATION/includes/Exception.php(205): wfReportException()
12 [internal function]: wfExceptionHandler(Object(DBQueryError))
13 {main}

Paths renamed for security reasons. When I checked out the DB and tried to 
repair it (which didn't work) I saw that the table objectcache was giving 
out an SQL #1033 error. So, I figured that was the problem.


2. I tried truncating the objectcache table, but got the #1033 error again. 
So, I dropped the table and recreated it using the following SQL:

DROP TABLE IF EXISTS `objectcache`;
CREATE TABLE `objectcache` (
`keyname` char(255) character set latin1 collate latin1_bin NOT NULL default 
'',
`value` mediumblob,
`exptime` datetime default NULL,
UNIQUE KEY `keyname` (`keyname`),
KEY `exptime` (`exptime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

I'm now getting the following error:

Database error
A database query syntax error has occurred. This may indicate a bug in the 
software. The last attempted database query was:
(SQL query hidden)
from within function "MessageCache::loadFromDB". MySQL returned error "1033: 
Incorrect information in file: './DBNAME/page.frm' (localhost)".

The last part of this statement seems to change randomly between page.frm, 
user.frm and job.frm

I have checked my backup of the SQL database and it seems the content under
--
-- Dumping data for table `objectcache`
--
is all corrupted with lots of bizarre symbols etc. I tried entering it 
anyway, via the statement I saw in the backup .sql file I have:
LOCK TABLES `objectcache` WRITE;
/*!40000 ALTER TABLE `objectcache` DISABLE KEYS */;
INSERT INTO `objectcache` (`keyname`, `value`, `exptime`) VALUES

But, it made no difference.



Is there a way to fix this without losing all the content of the DB (i.e. 
the entries/articles and so on), or am I going to have to ditch the whole 
thing and start up again?

Thanks in advance!

Steve