[Wikidata-bugs] [Maniphest] [Commented On] T176277: Provision a separate DB shard for wbc_entity_usage

2017-09-24 Thread Marostegui
Marostegui added a comment. In T176277#3619796, @hoo wrote: Additional question: (How) Would this work for labs? There should not be too many issues for this to apply to the new labs servers, as we'd only need to add a new instance to the hosts (and sanitarium hosts) while doing all the split.

[Wikidata-bugs] [Maniphest] [Commented On] T168295: Some language codes for sitelinks are capitalised differently from labels

2017-09-24 Thread Nikerabbit
Nikerabbit added a comment. The standard is quite clear on the recommended formatting, and also that language codes are case insensitive. Internally MediaWiki uses lowercase language codes, and unfortunately those are exposed in user visible places such as when used as subpage for mediawiki

[Wikidata-bugs] [Maniphest] [Updated] T168295: Some language codes for sitelinks are capitalised differently from labels

2017-09-24 Thread Smalyshev
Smalyshev added a project: Language-Team. TASK DETAILhttps://phabricator.wikimedia.org/T168295EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Esc3300, Smalyshev, Nikki, Aklapper, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst,

[Wikidata-bugs] [Maniphest] [Claimed] T173772: Create mechanism to update categories database in graph storage

2017-09-24 Thread Smalyshev
Smalyshev claimed this task. TASK DETAILhttps://phabricator.wikimedia.org/T173772EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: User-Smalyshev, Lydia_Pintscher, daniel, Aklapper, Smalyshev, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden,

[Wikidata-bugs] [Maniphest] [Created] T176593: Reload WDQS dataset

2017-09-24 Thread Smalyshev
Smalyshev created this task.Smalyshev added a project: Wikidata-Query-Service.Herald added a subscriber: Aklapper.Herald added projects: Wikidata, Discovery. TASK DESCRIPTIONAfter T121274 and T175948 are merged and deployed, we will need to reload the data for all servers. If we want to do any

[Wikidata-bugs] [Maniphest] [Changed Subscribers] T175948: Add normalized predicates to Blazegraph vocabulary

2017-09-24 Thread Smalyshev
Smalyshev added a subscriber: Gehel.Smalyshev added a comment. The tricky part here is that once we deploy the change, we'd need to reload immediately (since the dictionary would be incompatible). But we don't want to take all servers down at the same time. So we need a way to run server with

[Wikidata-bugs] [Maniphest] [Updated] T173980: Include hidden status in category RDF

2017-09-24 Thread Smalyshev
Smalyshev added a project: User-Smalyshev. TASK DETAILhttps://phabricator.wikimedia.org/T173980EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Aklapper, Multichill, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst,

[Wikidata-bugs] [Maniphest] [Declined] T166139: Query optimizer for labels should be using sub queries

2017-09-24 Thread Smalyshev
Smalyshev closed this task as "Declined".Smalyshev added a comment. Looks like proposed change doesn't provide performance improvement, so closing.TASK DETAILhttps://phabricator.wikimedia.org/T166139EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc:

[Wikidata-bugs] [Maniphest] [Updated] T173243: UnsupportedOperationException on property path in EXISTS

2017-09-24 Thread Smalyshev
Smalyshev added a project: Upstream.Smalyshev added a comment. Filed https://jira.blazegraph.com/browse/BLZG-9056 upstreamTASK DETAILhttps://phabricator.wikimedia.org/T173243EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Aklapper, Smalyshev,

[Wikidata-bugs] [Maniphest] [Triaged] T173243: UnsupportedOperationException on property path in EXISTS

2017-09-24 Thread Smalyshev
Smalyshev triaged this task as "Normal" priority.Smalyshev moved this task from All WDQS-related tasks to Blazegraph on the Wikidata-Query-Service board. TASK DETAILhttps://phabricator.wikimedia.org/T173243WORKBOARDhttps://phabricator.wikimedia.org/project/board/891/EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T157676: Provide access to category information from WDQS SPARQL

2017-09-24 Thread gerritbot
gerritbot added a comment. Change 379838 merged by jenkins-bot: [wikidata/query/rdf@master] Add stored query for category traversal https://gerrit.wikimedia.org/r/379838TASK DETAILhttps://phabricator.wikimedia.org/T157676EMAIL

[Wikidata-bugs] [Maniphest] [Triaged] T175380: Queries with wikibase:statements or wikibase:sitelinks are slow

2017-09-24 Thread Smalyshev
Smalyshev triaged this task as "Normal" priority. TASK DETAILhttps://phabricator.wikimedia.org/T175380EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Aklapper, Smalyshev, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, Avner,

[Wikidata-bugs] [Maniphest] [Triaged] T173954: Add shortcut to specify labels in label service

2017-09-24 Thread Smalyshev
Smalyshev triaged this task as "Low" priority.Smalyshev added a project: Need-volunteer.Smalyshev added a comment. Can be done, by having Optimizer step that rewrites that. Not sure it's a big win, but wouldn't hurt probably.TASK DETAILhttps://phabricator.wikimedia.org/T173954EMAIL

[Wikidata-bugs] [Maniphest] [Triaged] T175840: Using label service twice in one query results in obscure error message

2017-09-24 Thread Smalyshev
Smalyshev triaged this task as "Normal" priority. TASK DETAILhttps://phabricator.wikimedia.org/T175840EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Lucas_Werkmeister_WMDE, Aklapper, GoranSMilovanovic, QZanden, EBjune, merbst, Avner,

[Wikidata-bugs] [Maniphest] [Changed Subscribers] T134131: Watch for exceptions in Wikidata dumper logs

2017-09-24 Thread Smalyshev
Smalyshev added a subscriber: ArielGlenn.Smalyshev added a comment. @ArielGlenn do we have any system for controlling/reporting dump failures?TASK DETAILhttps://phabricator.wikimedia.org/T134131EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc:

[Wikidata-bugs] [Maniphest] [Commented On] T157798: Provide access to image sizes from WDQS SPARQL

2017-09-24 Thread Smalyshev
Smalyshev added a comment. do I understand it correctly that support for such things as sizes of pages behind sitelinks and other their metadata access could be added too? It is technically easy to add anything that is in page_props (on wikidata), and is slightly harder but still not too hard to

[Wikidata-bugs] [Maniphest] [Updated] T153061: [Bug] SPARQL sub queries avoid timeouts

2017-09-24 Thread Smalyshev
Smalyshev added a project: WDQS-Optimizer. TASK DETAILhttps://phabricator.wikimedia.org/T153061EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Esc3300, Jonas, Aklapper, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune,

[Wikidata-bugs] [Maniphest] [Updated] T167858: hint:runFirst throws exception

2017-09-24 Thread Smalyshev
Smalyshev added a project: WDQS-Optimizer. TASK DETAILhttps://phabricator.wikimedia.org/T167858EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Aklapper, WikidataFacts, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst,

[Wikidata-bugs] [Maniphest] [Updated] T154280: SPARQL queries using VALUES time out

2017-09-24 Thread Smalyshev
Smalyshev added a project: WDQS-Optimizer. TASK DETAILhttps://phabricator.wikimedia.org/T154280EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Esc3300, Smalyshev, Nikki, Aklapper, Multichill, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden,

[Wikidata-bugs] [Maniphest] [Updated] T168973: Checking if a book is an instance of work is slow without explicit gearing hint

2017-09-24 Thread Smalyshev
Smalyshev added a project: WDQS-Optimizer. TASK DETAILhttps://phabricator.wikimedia.org/T168973EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Jonas, Lydia_Pintscher, gerritbot, Aklapper, Smalyshev, Lucas_Werkmeister_WMDE, GoranSMilovanovic,

[Wikidata-bugs] [Maniphest] [Updated] T168876: MWAPI service throws “could not find binding for parameter” if optimizer is not disabled

2017-09-24 Thread Smalyshev
Smalyshev added a project: WDQS-Optimizer. TASK DETAILhttps://phabricator.wikimedia.org/T168876EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: robbi5, Smalyshev, Lucas_Werkmeister_WMDE, Aklapper, GoranSMilovanovic, QZanden, EBjune, merbst, Avner,

[Wikidata-bugs] [Maniphest] [Updated] T161885: Services wikibase:box and wikibase:around timeout

2017-09-24 Thread Smalyshev
Smalyshev added a project: WDQS-Optimizer. TASK DETAILhttps://phabricator.wikimedia.org/T161885EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: PokestarFan, jayvdb, Smalyshev, Jonas, Aklapper, Lucas_Werkmeister_WMDE, GoranSMilovanovic, Jrbranaa,

[Wikidata-bugs] [Maniphest] [Updated] T170196: Categorymembers: Join on redirect items causes results to explode.

2017-09-24 Thread Smalyshev
Smalyshev added a project: WDQS-Optimizer. TASK DETAILhttps://phabricator.wikimedia.org/T170196EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: PokestarFan, Smalyshev, Esc3300, famewi, Aklapper, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden,

[Wikidata-bugs] [Maniphest] [Commented On] T153353: Blazegraph not properly using labels from sub-queries for filtering (omitting rows), unless they're selected

2017-09-24 Thread Smalyshev
Smalyshev added a comment. Doesn't look like it's T147577 since that is fixed but this one still happens.TASK DETAILhttps://phabricator.wikimedia.org/T153353EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Aklapper, Smalyshev, hoo,

[Wikidata-bugs] [Maniphest] [Updated] T126121: Blazegraph Query optimizer pessimises query Aliases_of_properties_which_are_used_more_than_once

2017-09-24 Thread Smalyshev
Smalyshev added a project: WDQS-Optimizer. TASK DETAILhttps://phabricator.wikimedia.org/T126121EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Aklapper, JanZerebecki, StudiesWorld, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden,

[Wikidata-bugs] [Maniphest] [Updated] T126122: Blazegraph Query optimizer pessimises query Deprecated_statements

2017-09-24 Thread Smalyshev
Smalyshev added a project: WDQS-Optimizer. TASK DETAILhttps://phabricator.wikimedia.org/T126122EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Aklapper, JanZerebecki, StudiesWorld, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden,

[Wikidata-bugs] [Maniphest] [Commented On] T171027: "2062 Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis

2017-09-24 Thread matej_suchanek
matej_suchanek added a comment. rc_type is almost unused in Wikibase (not used for filtering).TASK DETAILhttps://phabricator.wikimedia.org/T171027EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: matej_suchanekCc: matej_suchanek, Ankry, Ladsgroup, Lsanabria,

[Wikidata-bugs] [Maniphest] [Created] T176577: Some values of "Instance of counts" are not updating anymore

2017-09-24 Thread Sjoerddebruin
Sjoerddebruin created this task.Sjoerddebruin added projects: Wikidata, WMDE-Analytics-Engineering.Herald added a subscriber: Aklapper. TASK DESCRIPTIONAs you can see here, some of the values of "Instance of counts" on "Wikidata Datamodel Statements" aren't updating anymore. Are the queries

[Wikidata-bugs] [Maniphest] [Triaged] T174536: dashboard for most active accounts

2017-09-24 Thread Lydia_Pintscher
Lydia_Pintscher triaged this task as "High" priority. TASK DETAILhttps://phabricator.wikimedia.org/T174536EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Lydia_PintscherCc: Sjoerddebruin, Samtar, Aklapper, Lydia_Pintscher, GoranSMilovanovic, QZanden, Izno,

[Wikidata-bugs] [Maniphest] [Updated] T176565: EasyQuery gadget: Malformed query

2017-09-24 Thread matej_suchanek
matej_suchanek edited projects, added Wikidata-Gadgets; removed Gadgets. TASK DETAILhttps://phabricator.wikimedia.org/T176565EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: matej_suchanekCc: Aklapper, Yurik, GoranSMilovanovic, QZanden, dachary, Izno,