Hi,
I'm running Mediawiki 1.19.1 on Debian/stable server via
lighttpd/php5-cgi. Earlier today I decided I wanted to enable
wgDebugToolbar in my LocalSettings.php - done that, but now the wiki was
not responding any more.
I've immediately reverted that change (and it really was only that change,
I compared with the backups) but still the wiki was not responding.
top(1) showed that one of the php5-cgi process was using up a lot of CPU
time, so I decided to kill that process and restarted the webserver. But
still, accesssing the wiki was not possible: the page was "Loading...",
but nothing got delivered back to the browser. Deleted cookies, tried
another browser, still the wiki appeared to be unusable.
Looking at the MySQL database serving the wiki, I could see what was going
on:
------
307 Query REPLACE /* MessageBlobStore::updateModule 10.0.0.123 */
INTO `mw_msg_resource` (mr_resource,mr_lang,mr_blob,mr_timestamp) VALUES
('user.tokens','en','{}','20120926011737')
307 Query SELECT /* MessageBlobStore::updateModule 10.0.0.123 */
mr_blob FROM `mw_msg_resource` WHERE mr_resource = 'user.options' AND
mr_lang = 'en' LIMIT 1
------
These two queries where sent over and over again to the database by the
php5-cgi process, ~10 times per second or so. Restarting the database did
not help, as soon as I accessed the wiki again, these queries appeared
again.
I've had this issues before, with 1.19.0, IIRC. I did not dig deeper
though, somehow the next morning the wiki was "just" working again. But
the issue was the same: changed something in the config and then these
strange queries appeared.
I've put the LocalSettings.php and the database query log here:
https://trent.utfs.org/bits/mediawiki/
Some more notes:
* I've switched from lighttpd/php5-cgi to apache2/mod_php5, still the
same: when the wiki is accessed, those strange queries appear and the
wiki page "loads" until php's maximum execution time is exceeded..
* I'm using the APC cache. Disabling that (and wgMainCacheType) did no
help either.
* I'm not using any Mediawiki extensions.
Anyone got an idea what might be going on here?
Thanks,
Christian.
--
BOFH excuse #148:
Insert coin for new game