Page protection log shows the main page of the Finnish-language Wikinews as nonexistent
Open, Needs TriagePublic
Actions

Assigned To

None

Authored By

	Ejs-80
	Feb 7 2019, 12:22 PM

Description

If you look at the protection log of the Finnish-language Wikinews and search for "Wikiuutiset:Etusivu" (the main page of the fiwikinews) , you can see that the link is red, although the main page exists:
https://fi.wikinews.org/wiki/Toiminnot:Loki?type=protect&user=&page=&wpdate=2019-02-07&uselang=en

Additionally, if you place the cursor at the text "Wikiuutiset:Etusivu", you get a tooltip which says "Wikiuutiset:Etusivu (sivua ei ole)" i.e. claims that the (main) page does not exist. That is incorrect, of course, which can be easily confirmed by clicking the link. Same thing occurs with the text "hist" (link to the revision history of the main page).

However, if you (for example) search the protection log with the performer and/or the target, the problem goes away, and you see Wikiuutiset:Etusivu as a page that exists (as it should):
https://fi.wikinews.org/wiki/Toiminnot:Loki?type=protect&user=Ejs-80&page=&wpdate=2019-02-07&uselang=en
https://fi.wikinews.org/w/index.php?type=protect&title=Toiminnot:Loki&page=Wikiuutiset%3AEtusivu&uselang=en
https://fi.wikinews.org/wiki/Toiminnot:Loki?type=protect&user=Crt&page=Wikiuutiset%3AEtusivu&wpdate=2019-02-07&uselang=en

Due to the so-called soft closure and the later re-opening of the fiwikinews, the main page has had several logged actions done to it:
https://fi.wikinews.org/wiki/Toiminnot:Loki?type=&user=&page=Wikiuutiset%3AEtusivu
https://meta.wikimedia.org/wiki/Proposals_for_closing_projects/Closure_of_Finnish_Wikinews#Soft_close
https://meta.wikimedia.org/wiki/Steward_requests/Miscellaneous/2018-12#Reactivation_of_Finnish_Wikinews_(and_clearing_of_soft_close)

The aforementioned problem existed before I removed the main page protection today and placed it again shortly afterwards. I didn't notice any differences between the situations before and after my actions regarding the main page. I used both Mozilla Firefox 65.0 (64-bit) for Fedora and Google Chrome 72.0.3626.81 (Official Build) (64-bit) and observed the exact same thing with both of them.

Related Objects

Mentioned Here: T14103: Finnish Wikinews' sitename, namespace and word forms

Event Timeline

Ejs-80 created this task.Feb 7 2019, 12:22 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 7 2019, 12:22 PM

Ejs-80 updated the task description. (Show Details)Feb 7 2019, 12:36 PM

Ejs-80 updated the task description. (Show Details)Feb 7 2019, 12:41 PM

Ejs-80 updated the task description. (Show Details)Feb 7 2019, 12:45 PM

Jni subscribed.Feb 7 2019, 1:07 PM

The link to the Wikiuutiset:Etusivu (aka the main page) appears as red also in the deletion log if you select ”Page undeletion” from the ”Type of deletion” drop-down list:

https://fi.wikinews.org/wiki/Toiminnot:Loki?type=delete&user=&page=&wpdate=2019-02-24&tagfilter=&subtype=restore&uselang=en

On the other hand, if you choose a specific target, the link is blue:
https://fi.wikinews.org/wiki/Toiminnot:Loki?type=delete&user=&page=Wikiuutiset%3AEtusivu&wpdate=2019-02-24&tagfilter=&subtype=restore&uselang=en

If you check my deleted contributions, all links to the Wikiuutiset:Hiekkalaatikko (the sandbox page; search for ”25 November 2007”) are red, although the page itself exists. When I searched my deleted edits in the Wikiuutiset namespace (id 4) only, Wikiuutiset:Hiekkalaatikko didn’ t show up at all and the resulting message was: ”No changes were found matching these criteria.” Pathoschild imported revisions into that page from Wikimedia Incubator on 25 November 2007. Apparently the list of my deleted contributions (which I can see with temporary admin rights) still lists the edits that I did on Incubator and were removed before the import, but when I click their revision links, I get this message: ”Invalid or missing revision. You may have a bad link, or the revision may have been restored or removed from the archive.”

A good number of revisions were imported into the main page Wikiuutiset:Etusivu on 25 November 2007. Additionally, by looking at T14103#158520, we learn that there occurred some errors while moving pages to the Wikiuutiset namespace (id 4) in 2007.

I'm removing the import and export project - it's possible that a bug existed in 2007 when the import(s) took place, but we're not going to try and solve an import bug based on evidence from 12 years ago.

Early in the log, the page in namespace 0 called "Wikiuutiset:Etusivu" was protected. No such page currently exists (which is unsurprising, given Wikiuutiset is now a namespace name). I imagine what is happening here is that MediaWiki is storing the fact that this namespace-0 page doesn't exist in a link cache, and then, later in the log when a page in namespace 4 called "Etusivu" is referenced (which does exist), the cache entry is hit and a red link is shown.

Indeed, if you show few enough log entries so that the old page in namespace 0 is no longer visible (like this), you see that the red link turns blue.

This does not appear to be an issue with the wikimedia/objectcache library, nor with usage of that interface. It looks like this is either a data corruption problem (bad information stored in the database), or a bug in Special:Log, or perhaps something that is confusing but working correctly.

1997kB moved this task from To triage to Special:Contributions / Special:DeletedContributions on the MediaWiki-Special-pages board.Dec 24 2019, 2:02 PM

1997kB moved this task from Special:Contributions / Special:DeletedContributions to To triage on the MediaWiki-Special-pages board.Dec 24 2019, 2:33 PM

Pppery added a project: Wikimedia-database-issue (Bad data).Dec 13 2023, 3:01 AM

I'm trying to see if it's something in the db but can't find anything suspicious:

wikiadmin2023@10.192.32.161(fiwikinews)> select * from logging where log_id = 8881;
+--------+----------+------------+----------------+---------------+-----------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+----------+
| log_id | log_type | log_action | log_timestamp  | log_namespace | log_title | log_comment_id | log_params                                                                                                                                                                                                                                                                                                                                                                                         | log_deleted | log_actor | log_page |
+--------+----------+------------+----------------+---------------+-----------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+----------+
|   8881 | protect  | protect    | 20190207104708 |             4 | Etusivu   |          25982 | a:4:{s:14:"4::description";s:58:"‎[edit=autoconfirmed] (ikuinen)‎[move=sysop] (ikuinen)";s:14:"5:bool:cascade";b:0;s:7:"details";a:2:{i:0;a:4:{s:4:"type";s:4:"edit";s:5:"level";s:13:"autoconfirmed";s:6:"expiry";s:8:"infinity";s:7:"cascade";b:0;}i:1;a:4:{s:4:"type";s:4:"move";s:5:"level";s:5:"sysop";s:6:"expiry";s:8:"infinity";s:7:"cascade";b:0;}}s:17:"associated_rev_id";i:55148;}     |           0 |         2 |      202 |
+--------+----------+------------+----------------+---------------+-----------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+----------+
1 row in set (0.001 sec)

wikiadmin2023@10.192.32.161(fiwikinews)> select * from log_search where ls_log_id = 8881;
+-------------------+----------+-----------+
| ls_field          | ls_value | ls_log_id |
+-------------------+----------+-----------+
| associated_rev_id | 55148    |      8881 |
| pr_id             | 74       |      8881 |
| pr_id             | 75       |      8881 |
+-------------------+----------+-----------+
3 rows in set (0.001 sec)

Page protection log shows the main page of the Finnish-language Wikinews as nonexistentOpen, Needs TriagePublicActions

Description

Related Objects

Event Timeline

Page protection log shows the main page of the Finnish-language Wikinews as nonexistent
Open, Needs TriagePublic
Actions