[Wikidata-bugs] [Maniphest] T295229: Replication database don't have some information from production page_props

2021-11-07 Thread Marostegui 
Marostegui added a comment.


  Nowadays with ROW based replication on clouddb* hosts it is very unlikely 
that we have unknown data drifts (of course this can still happen!) on big and 
very accessed tables. If we had any, replication would break because of data 
mismatch.

TASK DETAIL
  https://phabricator.wikimedia.org/T295229

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Marostegui
Cc: Marostegui, Reedy, RhinosF1, Majavah, Aklapper, Base, Kanzat, Invadibot, 
maantietaja, Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T295229: Replication database don't have some information from production page_props

2021-11-07 Thread Reedy 
Reedy added a comment.


  Done against a production mysql server
  
MariaDB [ukwiki]> select page_id, page_title, pp_propname, pp_value  
-> from page
-> join page_props on page_id = pp_page
-> where page_title = 'Шипайло' and page_namespace=0;
+-++++
| page_id | page_title | pp_propname| pp_value   |
+-++++
| 4157074 | Шипайло| disambiguation ||
| 4157074 | Шипайло| wikibase_item  | Q106255766 |
+-++++
2 rows in set (0.000 sec)

MariaDB [ukwiki]> 
  
  compared against labs
  
MariaDB [ukwiki_p]> select page_id, page_title, pp_propname, pp_value
-> 
-> from page
-> 
-> left join page_props on page_id = pp_page
-> 
-> where page_title = 'Шипайло';
+-++++
| page_id | page_title | pp_propname| pp_value   |
+-++++
| 4157074 | Шипайло| disambiguation ||
| 4157074 | Шипайло| wikibase_item  | Q106255766 |
+-++++
2 rows in set (1.98 sec)
  
  Possibly replag?

TASK DETAIL
  https://phabricator.wikimedia.org/T295229

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Reedy
Cc: Reedy, RhinosF1, Majavah, Aklapper, Base, Kanzat, Invadibot, maantietaja, 
Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, 
_jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T295259: Occupations of Q5603 does not all show in query result

2021-11-07 Thread Mahir256 
Mahir256 closed this task as "Invalid".
Mahir256 added a comment.


  Per 
https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format#Truthy_statements,
 "Truthy statement predicates have prefix `wdt:` with the property name (e.g. 
`wdt:P2`)" and "[I]f there is a preferred statement for property P2, then only 
preferred statements for P2 will be considered truthy. Otherwise, all 
normal-rank statements for P2 are considered truthy." As your screenshot 
indicates, "visual artist" is a preferred occupation statement (the little 
shaded up arrow on the left) and the other occupations are normal-rank 
statements (the little shaded dot between the two blank arrows).

TASK DETAIL
  https://phabricator.wikimedia.org/T295259

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Mahir256
Cc: Mahir256, Zayca, Aklapper, Invadibot, maantietaja, Akuckartz, Nandana, 
Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T295259: Occupations of Q5603 does not all show in query result

2021-11-07 Thread Zayca 
Zayca created this task.
Zayca added a project: Wikidata.
Restricted Application added a subscriber: Aklapper.

TASK DESCRIPTION
  **Problem:**
  
  - The query does not return all the occupations of Q5603
  
  **List of steps to reproduce** (step by step, including full links if 
applicable):
  
  - Run the following query in the query service
  
  
  
SELECT DISTINCT ?occupation ?occupationLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language 
"[AUTO_LANGUAGE]". }
  { SELECT DISTINCT ?occupation WHERE { wd:Q5603 wdt:P106 ?occupation. } }
}
  
  **What happens?**:
  
  - Only one occupation(wd:Q3391743 visual artist) is returned
  
  **What should have happened instead?**:
  
  - Q5603 has more than 10 occupations shown on the wikidata page and they 
should all be shown in the query result.
  
  **Browser information, screenshots/mockups, other information, etc. (if 
applicable)**:
  
  - Wikidata page
  
  F34736905: image.png 
  
  - Query and result
  
  F34736907: image.png 

TASK DETAIL
  https://phabricator.wikimedia.org/T295259

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Zayca
Cc: Zayca, Aklapper, Invadibot, maantietaja, Akuckartz, Nandana, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org