Page MenuHomePhabricator

Default sidebar cached after restoring MediaWiki:Sidebar from backup
Closed, DeclinedPublic

Description

Author: huck.finn

Description:
I tested the whole BACKUP and RESTORE process using 2 separate Linux machines (first has Fedora 7 core, the second Fedora 9 core). All prerequisities for MediaWiki were installed.

  1. I created backup from my working wiki.

nice -n 19 /usr/bin/mysqldump -u wikiuser -pheslo --default-character-set=latin1 wikidb -c | nice -n 19 /bin/gzip -9 > ~/backup/wiki-sql-$(date '+%a').sql.gz

This file has been created: wiki-sql-So.sql.gz

  1. I created a new empty wiki (the same version 1.11) on the 2nd machine. I used the same install parameters as with the first wiki. I ran also the install script.

Than I copied the content of my first wiki over the entire <MediaWiki-folder> content.

I unpacked the .gz file and restored the content of MySQL:
super~ ]# mysql -u root -p wikidb < wiki-sql-So.sql

Everything seems to be restored fine except of Mediawiki:Sidebar values. The new wiki shows the initial defualt settings instead of the setting from the working wiki.

I use the "cs - czech language" setting.

Regards, Huck.


Version: 1.11.x
Severity: normal
OS: Linux
URL: http://www.wikiskripta.cz/pfuk/
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=5092

Details

Reference
bz16146

Event Timeline

bzimport raised the priority of this task from to Low.Nov 21 2014, 10:22 PM
bzimport set Reference to bz16146.
bzimport added a subscriber: Unknown Object (MLST).
  • Bug 16144 has been marked as a duplicate of this bug. ***

huck.finn wrote:

Bug 16144 contains an unfinished entry of my report. I'am sorry for a preliminery 'mousepo'. This report is the complete one.

huck.finn wrote:

Supplement of the observation: the content of Mediawiki:Sidebar is correct however MediaWiki software does not reflect it. Once I slightly edit Mediawiki:Sidebar page (ie. I make no essential change) the display shows the navigation correctly according to the restored values.

Thus it is likely that MW software checks content of Mediawiki:Sidebar only after its first edit.

(In reply to comment #3)

Supplement of the observation: the content of Mediawiki:Sidebar is correct
however MediaWiki software does not reflect it. Once I slightly edit
Mediawiki:Sidebar page (ie. I make no essential change) the display shows the
navigation correctly according to the restored values.

Thus it is likely that MW software checks content of Mediawiki:Sidebar only
after its first edit.

Changing summary to reflect this.

@Nemo_bis: Did you encounter this issue back in 2014? I'm wondering as I can't reproduce this, and I suspect it might have been fixed since 2008...

In T18146#2909555, @TTO wrote:

@Nemo_bis: Did you encounter this issue back in 2014?

In 2014 I was just importing my bugzilla votes, I think, but IIRC this happened at Wiktionary recently. See also https://phabricator.wikimedia.org/T7092#1050140
I've never found a reliable way to reproduce the bug.

IIRC this happened at Wiktionary recently. See also https://phabricator.wikimedia.org/T7092#1050140

It doesn't look like that had anything to do with importation, and in any case, the task was resolved last year, which might have solved this issue as a nice side-effect.

Looking more closely at the task description, this is about someone restoring their wiki from an SQL dump. MediaWiki has no way of knowing that it's just been reincarnated from an SQL dump, so it can't clear its own caches in this situation. It looks like this was probably a case of someone needing to clear their memcached or whatever other cache they were using; I don't think MediaWiki can do anything to help here. Hence declined.

I was actually looking into the situation with XML dumps, since this is in MediaWiki-Core-Snapshots. Even in that context, I couldn't make this bug happen, and the code paths to prevent it (even when $wgEnableSidebarCache is true) look to be firmly in place.