Hi,
our hosting provider upgraded to mysql 5 (5.0.32-Debian_7etch4-log).
With this MediaWiki stopped working completely with an internal error saying he could not find the table:
//--------------------------------------- MediaWiki internal error.
Original exception: exception 'DBQueryError' with message 'A database error has occurred Query: SELECT value,exptime FROM `wiki_objectcache` WHERE keyname='usr_web36_5-wiki_:messages' Function: MediaWikiBagOStuff::_doquery Error: 1146 Table 'usr_web36_5.wiki_objectcache' doesn't exist (localhost) ' in /var/www/web36/html/test/wiki/includes/Database.php:844 Stack trace: [..] //---------------------------------------
I can still see the tables with phpMyAdmin, but I also cannot access them in any way (structure, content, repair, etc.). Strange enough, only the MediaWiki tables are affected. Other tables in the same database still work normal.
Any ideas how to repair those tables?
Thanks, Matthias
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Matthias Korn wrote:
our hosting provider upgraded to mysql 5 (5.0.32-Debian_7etch4-log).
[snip]
I can still see the tables with phpMyAdmin, but I also cannot access them in any way (structure, content, repair, etc.). Strange enough, only the MediaWiki tables are affected. Other tables in the same database still work normal.
Any ideas how to repair those tables?
Probably, your hosting provider either:
* manually copied all the per-database MyISAM files but forgot about all the InnoDB data files
or
* disabled InnoDB accidentally.
- -- brion
Brion Vibber wrote:
Probably, your hosting provider either:
- manually copied all the per-database MyISAM files but forgot about all
the InnoDB data files
or
- disabled InnoDB accidentally.
or
* forgot to run mysql_upgrade.
Thanks,
I think this is the problem. Are there any possibility to recover the tables? Unfortunately, I am not sure if they really copied the files.
Regards, Matthias Korn
Am Wed, 04 Jun 2008 16:10:03 -0700 schrieb Brion Vibber brion@wikimedia.org:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Matthias Korn wrote:
our hosting provider upgraded to mysql 5 (5.0.32-Debian_7etch4-log).
[snip]
I can still see the tables with phpMyAdmin, but I also cannot access them in any way (structure, content, repair, etc.). Strange enough, only the MediaWiki tables are affected. Other tables in the same database still work normal.
Any ideas how to repair those tables?
Probably, your hosting provider either:
- manually copied all the per-database MyISAM files but forgot about
all the InnoDB data files
or
- disabled InnoDB accidentally.
- -- brion
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.8 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkhHIMsACgkQwRnhpk1wk45wmACfS0+bmr31SQkyC9dMFxZIhLEa 2vYAn31A8gY5W1O+xDXtvdsd6ttuxqxD =7uUU -----END PGP SIGNATURE-----
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On Jun 5, 2008, at 9:57 AM, Matthias Korn wrote:
Thanks,
I think this is the problem. Are there any possibility to recover the tables? Unfortunately, I am not sure if they really copied the files.
backup?
mediawiki-l@lists.wikimedia.org