[Wikidata-bugs] [Maniphest] [Created] T252068: WQDS Data Reload

2020-05-06 Thread RKemper
RKemper created this task. RKemper added a project: Wikidata-Query-Service. Restricted Application added a subscriber: Aklapper. Restricted Application added a project: Wikidata. TASK DESCRIPTION We have already done the reload on `wdqs1010`, so now we need to xfer to the various other

[Wikidata-bugs] [Maniphest] [Commented On] T252068: WQDS Data Reload

2020-05-06 Thread RKemper
RKemper added a comment. `wdqs1010` is one of our test servers Therefore can screw up `wdqs1010` as much as we want, but not the others --- we need to transfer that data to each server which implies we need to open a port for data transfer we have 2 primary DC: eqiad and

[Wikidata-bugs] [Maniphest] [Commented On] T252068: WQDS Data Reload

2020-05-06 Thread RKemper
RKemper added a comment. should also circle back and fix https://github.com/wikimedia/puppet/blob/production/manifests/site.pp#L2207-L2242,` wdqs200[78]` are declared twice TASK DETAIL https://phabricator.wikimedia.org/T252068 EMAIL PREFERENCES https://phabricator.wikimedia.org

[Wikidata-bugs] [Maniphest] [Commented On] T252068: WQDS Data Reload

2020-05-19 Thread RKemper
RKemper added a comment. Data transfer is done across all instances as of last friday, along with a wdqs-categories reload that we tacked on. Circling back to mark this ticket as done. TASK DETAIL https://phabricator.wikimedia.org/T252068 EMAIL PREFERENCES https

[Wikidata-bugs] [Maniphest] [Unblock] T245135: Too many values for wikibase:geoLatitude and wikibase:geoLongitude in WDQS

2020-05-19 Thread RKemper
RKemper closed subtask T252068: WQDS Data Reload as "Resolved". TASK DETAIL https://phabricator.wikimedia.org/T245135 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: Lucas_Werkmeister_WMDE, Aklapper, Dipsacus_fullon

[Wikidata-bugs] [Maniphest] [Closed] T252068: WQDS Data Reload

2020-05-19 Thread RKemper
RKemper closed this task as "Resolved". RKemper added a comment. Still need to circle back to dependent tickets and verify that those problems are solved TASK DETAIL https://phabricator.wikimedia.org/T252068 EMAIL PREFERENCES https://phabricator.wikimedia.org/sett

[Wikidata-bugs] [Maniphest] [Unblock] T240831: Sometimes Q77104211 shows up in sparql query as having a wrong value for P2397, however item is deleted since December 3rd 2019

2020-05-19 Thread RKemper
RKemper closed subtask T252068: WQDS Data Reload as "Resolved". TASK DETAIL https://phabricator.wikimedia.org/T240831 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: Gehel, Aklapper, Mbch331, CBogen, darthmon_wmde, Nandana,

[Wikidata-bugs] [Maniphest] [Unblock] T230588: Wikidata Query Service is swapping items and properties

2020-05-19 Thread RKemper
RKemper closed subtask T252068: WQDS Data Reload as "Resolved". TASK DETAIL https://phabricator.wikimedia.org/T230588 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Zbyszko, RKemper Cc: Ghuron, Nikki, Toni_001, Dipsacus_fullon

[Wikidata-bugs] [Maniphest] T258739: wdqs admins should have access to nginx logs, jstack on wdqs machines

2020-07-23 Thread RKemper
RKemper renamed this task from "wdqs admins should have access to nginx logs on wdqs machines" to "wdqs admins should have access to nginx logs, jstack on wdqs machines". TASK DETAIL https://phabricator.wikimedia.org/T258739 EMAIL PREFERENCES https://phabricator.wi

[Wikidata-bugs] [Maniphest] T258739: wdqs admins should have access to nginx logs, jstack on wdqs machines

2020-07-23 Thread RKemper
RKemper added a project: Sustainability (Incident Followup). TASK DETAIL https://phabricator.wikimedia.org/T258739 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: RKemper, CDanis, dcausse, Aklapper, Dzahn, lmata, Alter-paule, Beast1978

[Wikidata-bugs] [Maniphest] T258739: wdqs admins should have access to nginx logs, jstack on wdqs machines

2020-07-27 Thread RKemper
RKemper added a comment. We discussed this during this week's SRE meeting and resolved to enable full root access for wdqs admins, rather than granularly expanding access one file at a time. This also lines up better with how we currently manage Elasticsearch, where admins have root a

[Wikidata-bugs] [Maniphest] T261204: Wikidata lexeme ttl dumps should be in a "predictable" folder

2020-09-12 Thread RKemper
RKemper added a comment. dumpsgen 58563 0.0 0.0 4276 700 ?Ss 20:50 0:00 /bin/sh -c python3 /srv/deployment/dumps/dumps/xmldumps-backup/generatemiscdumps.py --configfile /etc/dumps/confs/addschanges.conf --dumptype incrdumps --quiet dumpsgen 58565 0.0 0.0 57976

[Wikidata-bugs] [Maniphest] T261204: Wikidata lexeme ttl dumps should be in a "predictable" folder

2020-09-12 Thread RKemper
RKemper moved this task from Needs review to Needs Reporting on the Discovery-Search (Current work) board. RKemper added a comment. We'll want to monitor across the next week to verify all looks good. TASK DETAIL https://phabricator.wikimedia.org/T261204 WORKBOARD

[Wikidata-bugs] [Maniphest] T346455: Allow federated queries with the NFDI4Culture Knowledge Graph

2024-04-26 Thread RKemper
RKemper moved this task from Needs Review to Done on the Data-Platform-SRE (2024.04.15 - 2024.05.05) board. RKemper closed this task as "Resolved". RKemper added a comment. Here's an example CURL command we can use to verify when the service is properly supporting `application

[Wikidata-bugs] [Maniphest] T362920: Benchmark Blazegraph import with increased buffer capacity (and other factors)

2024-05-01 Thread RKemper
RKemper added a comment. We'll use wdqs2023 to compare against wdqs1023 (same hardware). 1023 is scholarly-articles so that's what we'll want to load 2023 with. TASK DETAIL https://phabricator.wikimedia.org/T362920 EMAIL PREFERENCES https://phabricator.wikimedia.org

[Wikidata-bugs] [Maniphest] T362920: Benchmark Blazegraph import with increased buffer capacity (and other factors)

2024-05-02 Thread RKemper
RKemper added a comment. Actually we'll use `wdqs1021` since we're not confident NFS will work seamlessly between eqiad and codfw (we use nsf to procure the dumps that the data-reload is run from). Gearing up to kick off a data reload on `wdqs1021` after a quick patch to ena

[Wikidata-bugs] [Maniphest] T362920: Benchmark Blazegraph import with increased buffer capacity (and other factors)

2024-05-02 Thread RKemper
RKemper added a subscriber: dcausse. RKemper added a comment. I'm realizing I don't remember enough about how we load specific graph splits (scholarly vs main). But it's possible we won't need the above nfs patch if our previous process was to manually download th

[Wikidata-bugs] [Maniphest] T362920: Benchmark Blazegraph import with increased buffer capacity (and other factors)

2024-05-06 Thread RKemper
RKemper added a comment. @dr0ptp4kt > we saw that this took about 3702 minutes, or about 2.57 //hours// Typo you'll want to fix here and in the original: 2.57 **days** TASK DETAIL https://phabricator.wikimedia.org/T362920 EMAIL PREFERENCES https://phabricator.wikim

[Wikidata-bugs] [Maniphest] T362920: Benchmark Blazegraph import with increased buffer capacity (and other factors)

2024-05-06 Thread RKemper
RKemper added a comment. Kicked off the second run like so: (1) `vi /etc/wdqs/RWStore.wikidata.properties` (added a trailing 0 to buffersize) (2) `date | tee /home/ryankemper/loadData2.log; time sudo /home/ryankemper/loadData.sh -n wdq -d /srv/T362920/nt_wd_schol -s 0 -e 0 2>

[Wikidata-bugs] [Maniphest] T364363: [Epic] Productionize federated wdqs graph-split endpoints

2024-05-06 Thread RKemper
RKemper created this task. RKemper added projects: Wikidata, Wikidata-Query-Service, Epic, Discovery-Search (Current work). TASK DESCRIPTION This epic tracks the SRE operational work to get at least a couple wdqs hosts fully in production with the new graph split way of doing things (`main

[Wikidata-bugs] [Maniphest] T364364: Provision DNS and certificates for wdqs graph split domains

2024-05-06 Thread RKemper
RKemper created this task. RKemper added projects: Wikidata, Wikidata-Query-Service, Epic, Discovery-Search (Current work). TASK DESCRIPTION Acceptance Criteria --- - DNS records in place - Certs provisioned via CFSSL TASK DETAIL https://phabricator.wikimedia.org

[Wikidata-bugs] [Maniphest] T364366: Implement puppet logic for wdqs graph split

2024-05-06 Thread RKemper
RKemper created this task. RKemper added projects: Wikidata, Wikidata-Query-Service, Epic, Discovery-Search (Current work). TASK DESCRIPTION Context --- Currently our graph split hosts are just `wdqs-test` hosts, which are only exposed via dedicated temporary endpoints such as

[Wikidata-bugs] [Maniphest] T364367: Create dedicated UIs for wdqs graph split endpoints

2024-05-06 Thread RKemper
RKemper created this task. RKemper added projects: Wikidata, Wikidata-Query-Service, Epic, Discovery-Search (Current work). TASK DESCRIPTION Context --- The UI for wdqs (e.g. query.wikidata.org) lives on `miscweb`. We'll want to create slightly different UIs for the two typ

[Wikidata-bugs] [Maniphest] T364368: Create separate pybal pools for wdqs graph split (main vs scholarly)

2024-05-06 Thread RKemper
RKemper created this task. RKemper added projects: Wikidata, Wikidata-Query-Service, Epic, Discovery-Search (Current work). TASK DESCRIPTION Context --- Currently we've got one pybal pool per-DC for public `wdqs` (https://config-master.wikimedia.org/pybal/eqiad/wdqs) correspo

[Wikidata-bugs] [Maniphest] T316876: wdqs: replace git-fat with git-lfs

2024-05-08 Thread RKemper
RKemper added a comment. @dancy Should be fixed now. Here's a previously failing patch I ran a recheck on: https://gerrit.wikimedia.org/r/c/operations/puppet/+/1028565/4#message-8d03a9f159d1ec58172e8606d84deaf43bbcbbb0 TASK DETAIL https://phabricator.wikimedia.org/T316876

[Wikidata-bugs] [Maniphest] T365735: Consider creating a separate WDQS server type for categories

2024-05-23 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T365735 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: bking, Aklapper, Danny_Benjafield_WMDE, S8321414, Astuthiodit_1, AWesterinen, BTullis

[Wikidata-bugs] [Maniphest] T313751: Create WDQS uptime SLO

2022-08-21 Thread RKemper
RKemper added a comment. Aisha has written some Jupyter notebooks to pull together a random selection from groupings of query by time-to-completion and query structure (which operators are used, basically). On the ops side of things we'll need to decide between whether we want to

[Wikidata-bugs] [Maniphest] T313751: Create WDQS uptime SLO

2022-08-26 Thread RKemper
RKemper added a comment. Some quick pros/cons of two possible approaches to getting the SLI metrics: approach #1 is to run a query or set of queries per-dc at a certain frequency, approach #2 is just to run a query on each host at a certain frequency * Approach #1: Hit `wdqs.svc.{codfw

[Wikidata-bugs] [Maniphest] T315124: Add OpenDataSweden to the SPARQL whitelist

2022-08-29 Thread RKemper
RKemper moved this task from Needs review to Needs Reporting on the Discovery-Search (Current work) board. RKemper added a comment. This has been deployed. TASK DETAIL https://phabricator.wikimedia.org/T315124 WORKBOARD https://phabricator.wikimedia.org/project/board/1227/ EMAIL

[Wikidata-bugs] [Maniphest] T313751: Create WDQS uptime SLO

2022-09-13 Thread RKemper
RKemper added a comment. Intro (some context for traffic team) - Search team is working on creating an SLI to measure uptime of WDQS. We want our SLI to map as well to the actual user experience as possible, so to that end we're trying to co

[Wikidata-bugs] [Maniphest] T313751: Create WDQS uptime SLO

2022-10-04 Thread RKemper
RKemper added a comment. Gehel and I met with bblack today. Some highlights: - Best to use real user traffic if possible, rather than artificial. However this might be difficult for our use case (given that some subset of queries we consider invalid/failing) - If going

[Wikidata-bugs] [Maniphest] T313751: Create WDQS uptime SLO

2022-10-04 Thread RKemper
RKemper added a comment. With respect to the SLO itself, our goal is an SLO that captures the promise we make about service availability: namely, that WDQS is available on a **best-effort** basis. In practice, this means that if an issue arises out of "business hours", it'

[Wikidata-bugs] [Maniphest] T313751: Create WDQS uptime SLO

2022-10-13 Thread RKemper
RKemper added a comment. The current approach we're trying to work towards is recording the nginx response codes for requests. That will give us insight into the number of failures we're seeing. At a high level, these are the various response codes we expect for different

[Wikidata-bugs] [Maniphest] T313751: Create WDQS uptime SLO

2022-10-13 Thread RKemper
RKemper added a comment. With respect to recording nginx request responses: **Getting direct logs**: One idea is to add `/var/log/nginx/access.log` to `RollingFileAppender` in `modules/query_service/templates/logback.xml.erb` (https://github.com/wikimedia/puppet/blob

[Wikidata-bugs] [Maniphest] T316236: Reload WCQS from dumps

2022-10-31 Thread RKemper
RKemper removed a subtask: T322037: Data-transfer.py cookbook: stop prometheus-blazegraph-exporter service. TASK DETAIL https://phabricator.wikimedia.org/T316236 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: bking, RKemper Cc: dcaro, bking

[Wikidata-bugs] [Maniphest] T321855: Using DISTINCT with VALUES returns more results than expected

2022-10-31 Thread RKemper
RKemper renamed this task from "Using DISTINCT with VALUES returns more results that expected" to "Using DISTINCT with VALUES returns more results than expected". TASK DETAIL https://phabricator.wikimedia.org/T321855 EMAIL PREFERENCES https://phabricator.wikimedi

[Wikidata-bugs] [Maniphest] T323064: Create WDQS Uptime SLO && WDQS/WCQS update lag SLO dashboards in Grizzly

2022-11-14 Thread RKemper
RKemper created this task. RKemper added projects: Wikidata-Query-Service, Wikidata, Discovery-Search (Current work). TASK DESCRIPTION We use Grizzly <https://gerrit.wikimedia.org/r/plugins/gitiles/operations/grafana-grizzly/+/refs/heads/master> to create org-wide SLO dashboards

[Wikidata-bugs] [Maniphest] T323066: Understand meaning of trafficserver wdqs request data vs turnilo webrequest data

2022-11-14 Thread RKemper
RKemper created this task. RKemper added projects: Wikidata-Query-Service, Wikidata, Discovery-Search (Current work). TASK DESCRIPTION We've got our (WIP) WDQS uptime SLO dashboard <https://grafana.wikimedia.org/d/l-3CMlN4z/wdqs-uptime-slo?orgId=1&viewPanel=9>. Separately,

[Wikidata-bugs] [Maniphest] T323066: Understand meaning of trafficserver wdqs request data vs turnilo webrequest data

2022-11-22 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T323066 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: bking, Aklapper, Gehel, RKemper, Astuthiodit_1, AWesterinen, karapayneWMDE, Invadibot, MPhamWMF

[Wikidata-bugs] [Maniphest] T323066: Understand meaning of trafficserver wdqs request data vs turnilo webrequest data

2022-11-22 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T323066 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: bking, Aklapper, Gehel, RKemper, Astuthiodit_1, AWesterinen, karapayneWMDE, Invadibot, MPhamWMF

[Wikidata-bugs] [Maniphest] T316236: Reload WCQS from dumps

2022-11-22 Thread RKemper
RKemper moved this task from Needs review to Needs Reporting on the Discovery-Search (Current work) board. RKemper added a comment. Moved to `Needs Reporting`. Usually we leave tickets open but move them to needs reporting and then gehel closes as resolved after he reviews them, but I&#x

[Wikidata-bugs] [Maniphest] T323066: Understand meaning of trafficserver wdqs request data vs turnilo webrequest data

2022-11-23 Thread RKemper
RKemper added a comment. Comparing grafana <https://grafana-rw.wikimedia.org/d/l-3CMlN4z/wdqs-uptime-slo?forceLogin&from=now-2d&orgId=1&to=now&var-Datacenter=eqiad&var-Period_Days=7d&var-SLO_Threshold=.95&viewPanel=10> to turnilo <https://turnilo.wi

[Wikidata-bugs] [Maniphest] T313751: Create WDQS uptime SLO

2022-11-23 Thread RKemper
RKemper added a comment. In T313751#8388946 <https://phabricator.wikimedia.org/T313751#8388946>, @Gehel wrote: > A few comments on the current dashboard <https://grafana.wikimedia.org/d/l-3CMlN4z/wdqs-uptime-slo?orgId=1&from=now-30d&to=now&var-Datacenter=eqiad&a

[Wikidata-bugs] [Maniphest] T323935: Migrate query service data-transfer/reload cookbooks to new spicerack class API

2022-11-28 Thread RKemper
RKemper created this task. RKemper added projects: Wikidata, Discovery-Search. Restricted Application added a subscriber: Aklapper. TASK DESCRIPTION TASK DETAIL https://phabricator.wikimedia.org/T323935 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences

[Wikidata-bugs] [Maniphest] T323066: Understand meaning of trafficserver wdqs request data vs turnilo webrequest data

2022-12-06 Thread RKemper
RKemper added a comment. Looked at `sum(increase(trafficserver_backend_requests_seconds_count{status="200", backend="wdqs.discovery.wmnet", site="$Datacenter"}[60m])) / 128` on Graphite vs the turnilo data. General shape is mostly the same but the numbers we

[Wikidata-bugs] [Maniphest] T323066: Understand meaning of trafficserver wdqs request data vs turnilo webrequest data

2022-12-06 Thread RKemper
RKemper added a comment. F35842059: image.png <https://phabricator.wikimedia.org/F35842059> F35842062: image.png <https://phabricator.wikimedia.org/F35842062> Okay so ultimately we got the two data sources to be in alignment by: - Switching the graphite

[Wikidata-bugs] [Maniphest] T323066: Understand meaning of trafficserver wdqs request data vs turnilo webrequest data

2022-12-06 Thread RKemper
RKemper moved this task from In Progress to Needs Reporting on the Discovery-Search (Current work) board. RKemper added a comment. Given the above, we're pretty confident that after accounting for cache misses and bucketing the turnilo vs graphite data similarly, that we see pretty muc

[Wikidata-bugs] [Maniphest] T314703: Structured data for deleted files on Commons still visible in SPARQL engine after deletion

2022-12-06 Thread RKemper
RKemper reopened subtask T316236: Reload WCQS from dumps as "Open". TASK DETAIL https://phabricator.wikimedia.org/T314703 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: dcausse, RKemper Cc: Gehel, RP88, Bugreporter, HenkvD, Aklapper,

[Wikidata-bugs] [Maniphest] T316236: Reload WCQS from dumps

2022-12-06 Thread RKemper
RKemper reopened this task as "Open". RKemper added a comment. In T316236#8415706 <https://phabricator.wikimedia.org/T316236#8415706>, @RKemper wrote: > Moved to `Needs Reporting`. Usually we leave tickets open but move them to needs reporting and then gehel closes a

[Wikidata-bugs] [Maniphest] T301167: Service implementation for wdqs20[09,10,11,12]

2022-12-07 Thread RKemper
RKemper moved this task from Prioritized to Blocked/Waiting on the Discovery-Search (Current work) board. RKemper added a comment. Waiting for data reload to complete on `wdqs2009` (or another host) before we finish data transfers and pool these hosts TASK DETAIL https

[Wikidata-bugs] [Maniphest] T323064: Create WDQS Uptime SLO && WDQS/WCQS update lag SLO dashboards in Grizzly

2022-12-08 Thread RKemper
RKemper added a comment. ryankemper@grafana1002:/srv/grafana-grizzly$ grr diff slo_dashboards.jsonnet Dashboard/slo-logstash-tmpl no differences Dashboard/slo-trafficserver-tmpl no differences Dashboard/slo-varnish-tmpl no differences Dashboard/slo-wdqs-tmpl not present in

[Wikidata-bugs] [Maniphest] T323064: Create WDQS Uptime SLO dashboard in Grizzly

2022-12-08 Thread RKemper
RKemper renamed this task from "Create WDQS Uptime SLO && WDQS/WCQS update lag SLO dashboards in Grizzly" to "Create WDQS Uptime SLO dashboard in Grizzly". RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T32306

[Wikidata-bugs] [Maniphest] T323064: Create WDQS Uptime SLO dashboard in Grizzly

2022-12-08 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T323064 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: Aklapper, Gehel, RKemper, Adamm71, Jersione, Hellket777, LisafBia6531, Astuthiodit_1, AWesterinen

[Wikidata-bugs] [Maniphest] T301167: Service implementation for wdqs20[09,10,11,12]

2023-01-17 Thread RKemper
RKemper added a comment. In T301167#8516140 <https://phabricator.wikimedia.org/T301167#8516140>, @jcrespo wrote: > One tip to avoid having people on call (like me) worrying about pending implementation services is to add the hiera key `profile::monitoring::notifications_enabl

[Wikidata-bugs] [Maniphest] T327210: Very high maxlag on Wikidata

2023-01-17 Thread RKemper
RKemper closed this task as "Resolved". RKemper claimed this task. RKemper added a comment. A WDQS server's blazegraph was deadlocked, and I restarted it. Leaving the deadlock let the server "realize" how far behind it was. I forgot to depool the server after th

[Wikidata-bugs] [Maniphest] T324788: Create WDQS/WCQS update lag SLO dashboard in Grizzly

2023-02-01 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T324788 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: RKemper, Aklapper, Astuthiodit_1, AWesterinen, karapayneWMDE, Invadibot, MPhamWMF, maantietaja

[Wikidata-bugs] [Maniphest] T324811: Create WDQS Lag SLO dashboard with Grizzly && documentation

2023-02-01 Thread RKemper
RKemper renamed this task from "Create WDQS Lag SLO dashboard with Grizzly" to "Create WDQS Lag SLO dashboard with Grizzly && documentation". RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T324811 EMAIL PREFERENCES https

[Wikidata-bugs] [Maniphest] T301167: Service implementation for wdqs20[09,10,11,12]

2023-02-27 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T301167 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: bking, RKemper Cc: jcrespo, bking, Aklapper, RKemper, Themindcoder, Adamm71, Jersione, Hellket777

[Wikidata-bugs] [Maniphest] T301167: Service implementation for wdqs20[09,10,11,12]

2023-02-27 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T301167 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: bking, RKemper Cc: jcrespo, bking, Aklapper, RKemper, Themindcoder, Adamm71, Jersione, Hellket777

[Wikidata-bugs] [Maniphest] T301167: Service implementation for wdqs20[09,10,11,12]

2023-02-27 Thread RKemper
RKemper added a comment. Arbitrarily chosen `wdqs2012` is happy as seen by our query test suite: F36875227: image.png <https://phabricator.wikimedia.org/F36875227> All that should be left is decoming wdqs200[1-3] TASK DETAIL https://phabricator.wikimedia.org/T301167

[Wikidata-bugs] [Maniphest] T301167: Service implementation for wdqs20[09,10,11,12]

2023-02-27 Thread RKemper
RKemper added a comment. In T301167#8650988 <https://phabricator.wikimedia.org/T301167#8650988>, @RKemper wrote: > Arbitrarily chosen `wdqs2012` is happy as seen by our query test suite: > > F36875227: image.png <https://phabricator.wikimedia.org/F36875227> >

[Wikidata-bugs] [Maniphest] T301167: Service implementation for wdqs20[09,10,11,12]

2023-02-27 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T301167 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: bking, RKemper Cc: jcrespo, bking, Aklapper, RKemper, Themindcoder, Adamm71, Jersione, Hellket777

[Wikidata-bugs] [Maniphest] T301167: Service implementation for wdqs20[09,10,11,12]

2023-02-28 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T301167 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: bking, RKemper Cc: jcrespo, bking, Aklapper, RKemper, Themindcoder, Adamm71, Jersione, Hellket777

[Wikidata-bugs] [Maniphest] T324811: Create WDQS Lag SLO dashboard with Grizzly && documentation

2023-02-28 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T324811 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: RKemper, Gehel, Aklapper, Astuthiodit_1, karapayneWMDE, Invadibot, MPhamWMF, maantietaja, CBogen

[Wikidata-bugs] [Maniphest] T324811: Create WDQS Lag SLO dashboard with Grizzly && documentation

2023-02-28 Thread RKemper
RKemper added a comment. Fully deployed latest (working) dashboard: ryankemper@grafana1002:~/grafana-grizzly$ grr diff slo_dashboards.jsonnet Dashboard/slo-WDQS changes detected: --- Remote +++ Local @@ -86,7 +86,7 @@ "span": 6,

[Wikidata-bugs] [Maniphest] T324811: Create WDQS Lag SLO dashboard with Grizzly && documentation

2023-02-28 Thread RKemper
RKemper moved this task from Ready for Dev -- SRE/Ops to Needs Reporting on the Discovery-Search (Current work) board. RKemper claimed this task. TASK DETAIL https://phabricator.wikimedia.org/T324811 WORKBOARD https://phabricator.wikimedia.org/project/board/1227/ EMAIL PREFERENCES https

[Wikidata-bugs] [Maniphest] T313751: Create WDQS uptime SLO

2023-02-28 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T313751 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: RLazarus, Gehel, MPhamWMF, Aklapper, Astuthiodit_1, AWesterinen, karapayneWMDE, Invadibot

[Wikidata-bugs] [Maniphest] T313751: Create WDQS uptime SLO

2023-02-28 Thread RKemper
RKemper added a subtask: T325324: Evaluate options to soften wdqs paging. TASK DETAIL https://phabricator.wikimedia.org/T313751 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: RLazarus, Gehel, MPhamWMF, Aklapper, Astuthiodit_1

[Wikidata-bugs] [Maniphest] T303134: Should wdqs LVS checks page

2023-02-28 Thread RKemper
RKemper added a parent task: T325324: Evaluate options to soften wdqs paging. TASK DETAIL https://phabricator.wikimedia.org/T303134 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: bking, RKemper, jbond, Aklapper, Astuthiodit_1

[Wikidata-bugs] [Maniphest] T301167: Service implementation for wdqs20[09,10,11,12]

2023-03-02 Thread RKemper
RKemper added a comment. Decom ticket for dc-ops: T331074 <https://phabricator.wikimedia.org/T331074> TASK DETAIL https://phabricator.wikimedia.org/T301167 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: bking, RKemper Cc: jcrespo,

[Wikidata-bugs] [Maniphest] T333656: Decommission query-preview.wikidata.org

2023-04-03 Thread RKemper
RKemper renamed this task from "Decommission query-preview.wikdiata.org" to "Decommission query-preview.wikidata.org". TASK DETAIL https://phabricator.wikimedia.org/T333656 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To:

[Wikidata-bugs] [Maniphest] T333656: Decommission query-preview.wikidata.org

2023-04-12 Thread RKemper
RKemper added a comment. In T333656#8773505 <https://phabricator.wikimedia.org/T333656#8773505>, @Dzahn wrote: > hi @RKemper was wondering if you can bring this one up in your team meeting or so (no rush, but would be nice to have): https://gerrit.wikimedia.org/r/c/opera

[Wikidata-bugs] [Maniphest] T333656: Decommission query-preview.wikidata.org

2023-04-13 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T333656 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Dzahn, RKemper Cc: Lydia_Pintscher, Dzahn, RKemper, Aklapper, Gehel, Themindcoder, Adamm71, Jersione

[Wikidata-bugs] [Maniphest] T333656: Decommission query-preview.wikidata.org

2023-04-13 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T333656 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Dzahn, RKemper Cc: Lydia_Pintscher, Dzahn, RKemper, Aklapper, Gehel, Themindcoder, Adamm71, Jersione

[Wikidata-bugs] [Maniphest] T303134: Should wdqs LVS checks page

2023-04-17 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T303134 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: bking, RKemper, jbond, Aklapper, Astuthiodit_1, AWesterinen, karapayneWMDE, Invadibot, MPhamWMF

[Wikidata-bugs] [Maniphest] T333656: Decommission query-preview.wikidata.org

2023-05-04 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T333656 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: Lydia_Pintscher, Dzahn, RKemper, Aklapper, Gehel, Astuthiodit_1, AWesterinen, karapayneWMDE

[Wikidata-bugs] [Maniphest] T323064: Create WDQS Uptime SLO dashboard in Grizzly

2023-05-09 Thread RKemper
RKemper added a comment. Forgot to link patch but here's the (hopefully final) grizzly patch to get this where we want it: https://gerrit.wikimedia.org/r/c/operations/grafana-grizzly/+/917938 (patch already merged & deployed) TASK DETAIL https://phabricator.wikimedia.or

[Wikidata-bugs] [Maniphest] T313751: Create WDQS uptime SLO

2023-05-09 Thread RKemper
RKemper moved this task from In Progress to Needs Reporting on the Discovery-Search (Current work) board. RKemper added a comment. With https://gerrit.wikimedia.org/r/c/operations/grafana-grizzly/+/917938, we now have the grizzly dashboard where we want it. That was the last blocker for

[Wikidata-bugs] [Maniphest] T303134: Should wdqs LVS checks page

2023-05-09 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T303134 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: bking, RKemper, jbond, Aklapper, Astuthiodit_1, AWesterinen, karapayneWMDE, Invadibot, MPhamWMF

[Wikidata-bugs] [Maniphest] T336577: Update WDQS Runbook following update lag incident

2023-05-15 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T336577 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: Gehel, Aklapper, Astuthiodit_1, AWesterinen, karapayneWMDE, Invadibot, Zabe, MPhamWMF

[Wikidata-bugs] [Maniphest] T324811: Create WDQS Lag SLO dashboard with Grizzly && documentation

2023-05-22 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T324811 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: RKemper, Gehel, Aklapper, Astuthiodit_1, karapayneWMDE, Invadibot, MPhamWMF, maantietaja

[Wikidata-bugs] [Maniphest] T324811: Create WDQS Lag SLO dashboard with Grizzly && documentation

2023-05-22 Thread RKemper
RKemper changed the point value for this task from "3" to "5". TASK DETAIL https://phabricator.wikimedia.org/T324811 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: RKemper, Gehel, Aklapper, Astuthiodit_1, kara

[Wikidata-bugs] [Maniphest] T324811: Create WDQS Lag SLO dashboard with Grizzly && documentation

2023-05-22 Thread RKemper
RKemper added a comment. Documentation aspect of this ticket's already done. Basically two things left to do to close this ticket out: - Understand the current non-grizzly dashboard (https://grafana-rw.wikimedia.org/d/yCBd7Tdnk/wdqs-wcqs-lag-slo?forceLogin&orgId=1&editPane

[Wikidata-bugs] [Maniphest] T335994: Allow federated queries to the UNESCO SPARQL endpoint

2023-05-22 Thread RKemper
RKemper added a comment. Thanks for the patience on this! This is getting deployed today. TASK DETAIL https://phabricator.wikimedia.org/T335994 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: RKemper, Olea, PKM, Aklapper, dcausse

[Wikidata-bugs] [Maniphest] T334823: Add https://opendata.aragon.es/sparql to the list of federated endpoints for WDQS and WCQS

2023-05-30 Thread RKemper
RKemper moved this task from To Be Deployed to Needs Reporting on the Discovery-Search (Current work) board. RKemper added a comment. Should be deployed as of today. TASK DETAIL https://phabricator.wikimedia.org/T334823 WORKBOARD https://phabricator.wikimedia.org/project/board/1227

[Wikidata-bugs] [Maniphest] T332314: Configure new WDQS servers in codfw (wdqs20[13-22])

2023-06-29 Thread RKemper
RKemper added a comment. Merged patch (had wrong ticket in commit message): https://gerrit.wikimedia.org/r/c/operations/puppet/+/934403 TASK DETAIL https://phabricator.wikimedia.org/T332314 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: bking

[Wikidata-bugs] [Maniphest] T280001: Set up puppet configuration for new WCQS cluster

2021-09-23 Thread RKemper
RKemper added a comment. [conftool changes following merge of https://gerrit.wikimedia.org/r/c/operations/puppet/+/713959] - Now running conftool-merge to sync any changes to conftool

[Wikidata-bugs] [Maniphest] T280001: Set up puppet configuration for new WCQS cluster

2021-09-23 Thread RKemper
RKemper added a comment. [Steps for deploy of https://gerrit.wikimedia.org/r/723254] --- merge https://gerrit.wikimedia.org/r/c/operations/puppet/+/723254 (on cumin) => sudo cumin 'O:lvs::balancer' 'sud

[Wikidata-bugs] [Maniphest] T280247: Create WCQS UI microsite deployment

2021-09-28 Thread RKemper
RKemper added a comment. ~/wmf/rdf/queries [master!]% ./test.sh -s http://localhost:/ Running 1592.sparqlcurl -G --data-urlencode query@1592.sparql --data format=json --data random=62170 http://localhost://sparql -s PASSED $KEEP is no, nuked /tmp/querytest

[Wikidata-bugs] [Maniphest] T282117: WCQS needs to be exposed through a wikimedia.org domain

2021-09-28 Thread RKemper
RKemper added a comment. [Log of failed authdns-update following https://gerrit.wikimedia.org/r/724520] -- ryankemper@authdns1001:~$ sudo -i authdns-update Updating authdns1001.wikimedia.org (self

[Wikidata-bugs] [Maniphest] T288231: Deploy the wdqs streaming updater to production

2021-10-14 Thread RKemper
RKemper added a comment. [data-transfer cookbook -> kafka offset output] --- (including this output since it's the first time we've relied on the new kafka offset part of the data-transfer process; won't be posting t

[Wikidata-bugs] [Maniphest] T288231: Deploy the wdqs streaming updater to production

2021-10-15 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T288231 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: Zbyszko, RKemper, Aklapper, dcausse, Suran38, Biggs657, Invadibot, Lalamarie69, MPhamWMF

[Wikidata-bugs] [Maniphest] T288231: Deploy the wdqs streaming updater to production

2021-10-15 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T288231 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: Zbyszko, RKemper, Aklapper, dcausse, Suran38, Biggs657, Invadibot, Lalamarie69, MPhamWMF

[Wikidata-bugs] [Maniphest] T288231: Deploy the wdqs streaming updater to production

2021-10-15 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T288231 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: Zbyszko, RKemper, Aklapper, dcausse, Suran38, Biggs657, Invadibot, Lalamarie69, MPhamWMF

[Wikidata-bugs] [Maniphest] T293638: Create and update the process for separate WCQS mutation topic

2021-10-18 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T293638 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: Ottomata, Aklapper, Zbyszko, Invadibot, MPhamWMF, maantietaja, CBogen, Akuckartz, Nandana

[Wikidata-bugs] [Maniphest] T288231: Deploy the wdqs streaming updater to production

2021-10-18 Thread RKemper
RKemper updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T288231 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: elukey, Zbyszko, RKemper, Aklapper, dcausse, Suran38, Biggs657, Invadibot, Lalamarie69, MPhamWMF

[Wikidata-bugs] [Maniphest] T294865: wcqs1002 and wcqs2001 unresponsive

2021-11-03 Thread RKemper
RKemper added a parent task: T260568: [EPIC] Productionize WCQS. TASK DETAIL https://phabricator.wikimedia.org/T294865 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: RKemper, Gehel, Aklapper, Suran38, Biggs657, joanna_borun, Invadibot

[Wikidata-bugs] [Maniphest] T260568: [EPIC] Productionize WCQS

2021-11-03 Thread RKemper
RKemper added a subtask: T294865: wcqs1002 and wcqs2001 unresponsive. TASK DETAIL https://phabricator.wikimedia.org/T260568 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: GFontenelle_WMF, So9q, Fuzheado, Zache, ttaylor, CBogen, Gehel

[Wikidata-bugs] [Maniphest] T294961: Resolve kernel hang on wcqs* instances

2021-11-03 Thread RKemper
RKemper added a parent task: T294865: wcqs1002 and wcqs2001 unresponsive. TASK DETAIL https://phabricator.wikimedia.org/T294961 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: MoritzMuehlenhoff, RKemper, Aklapper, Gehel, CBogen, ttaylor

[Wikidata-bugs] [Maniphest] T294865: wcqs1002 and wcqs2001 unresponsive

2021-11-03 Thread RKemper
RKemper added a subtask: T294961: Resolve kernel hang on wcqs* instances. TASK DETAIL https://phabricator.wikimedia.org/T294865 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: RKemper Cc: RKemper, Gehel, Aklapper, Suran38, Biggs657, joanna_borun

  1   2   3   >