Description

Many pages listed in http://quarry.wmflabs.org/query/1257, eg. the third one, have pp_propname = 'wikibase_item' and a pp_value although they are not connected with an item. Purging neither on the client nor the repo helps. Note that all those pages are redirects, so maybe the problem occurred when they were redirected.

We can see another problem in the line with page_title = Bitva_u_Bibrakte which has pp_value = 'q635028', ie. with lowercase. (There are even more.) This should be investigated as it can cause invalid results when JOINing with wikidatawiki.page_title.

I got the first problem reported by @Edgars2007 few weeks ago.

Status	Assigned	Task
Resolved	Addshore	T119738 Problems with page_props on clients
Open	None	T107722 [Task] Make client ChangeHandler scale by batching updates
Resolved	hoo	T138409 [Task] Terms usage tracking: Only track parts of the language fallback chain that were actually used
Open	None	T146838 Allow seeking in UsageLookup::getPagesUsing results
Resolved	Addshore	T172748 Clean up lowercase q-IDs from page_props table

Event Timeline

matej_suchanek created this task.Nov 26 2015, 8:18 PM

matej_suchanek raised the priority of this task from to Needs Triage.

matej_suchanek updated the task description. (Show Details)

matej_suchanek added a project: MediaWiki-extensions-WikibaseClient.

matej_suchanek added subscribers: matej_suchanek, Edgars2007.

Restricted Application added a project: Wikidata. · View Herald TranscriptNov 26 2015, 8:18 PM

Restricted Application added subscribers: StudiesWorld, Aklapper. · View Herald Transcript

I can't reproduce these issues locally, might have been something failing a long time ago. Null editing the pages in question should fix the rows.

Do you have an recent examples of page where this happened?

Both cases can indeed be fixed by doing a null edit.
For the first issue, the most recent case would be https://cs.wikipedia.org/w/index.php?title=Mistr_Klosterneuburgsk%C3%A9ho_olt%C3%A1%C5%99e&redirect=no.

SELECT * FROM cswiki_p.page_props WHERE pp_propname = "wikibase_item" AND pp_value LIKE "q%";

gives 1700+ results now on cswiki.

matej_suchanek mentioned this in T124664: "Ghost" connection of redirects with Wikidata items.Jan 25 2016, 7:38 PM

New cases of page props getting inconsistent would probably be addressed by T107722. For the old cases (also where we have lower case ids), we need to mass purge (with forcelinkupdate) these pages.

• MZMcBride subscribed.Jan 25 2016, 10:38 PM

matej_suchanek added a subtask: T107722: [Task] Make client ChangeHandler scale by batching updates.Jan 26 2016, 6:28 AM

XXN merged a task: T124664: "Ghost" connection of redirects with Wikidata items.Jan 27 2016, 4:59 PM

XXN added subscribers: Lydia_Pintscher, XXN.

Esc3300 updated the task description. (Show Details)Mar 2 2017, 6:08 PM

This seems to be problem with wbc_entity_usage as well where pages connected to merged items still track the redirected one.

matej_suchanek added a subtask: T172748: Clean up lowercase q-IDs from page_props table.Aug 8 2017, 1:01 PM

About the lowercase issue, see T172642. This problem seems unrelated to the question about articles linked to redirected items.

Restricted Application added a subscriber: PokestarFan. · View Herald TranscriptAug 8 2017, 4:35 PM

Esc3300 mentioned this in T173008: Create a maintenance script for pruning stale entity subscriptions and run periodically.Aug 10 2017, 4:30 PM

• Tbayer mentioned this in T209891: Analyze results of sameAs A/B test.Dec 4 2018, 8:27 PM

Addshore closed subtask T172748: Clean up lowercase q-IDs from page_props table as Resolved.Mar 21 2019, 9:19 AM

matej_suchanek mentioned this in T226900: Special:Unconnectedpages displays pages connected with a Wikidata item.Jul 4 2019, 3:54 PM

This might have been fixed with T233520 resolved.

I'm going to go ahead and close this inactive ticket per the comment above.
T233520#6416660 was recently reopened but I dont think also having this open serves us at all.

Restricted Application added a project: User-Addshore. · View Herald TranscriptOct 29 2020, 6:17 PM

Problems with page_props on clients
Closed, ResolvedPublic
Actions

Description

Related Objects
Search...

Event Timeline

Problems with page_props on clientsClosed, ResolvedPublicActions

Description

Related ObjectsSearch...

Event Timeline

Problems with page_props on clients
Closed, ResolvedPublic
Actions

Related Objects
Search...