[Wikidata-bugs] [Maniphest] T362508: WDQS updater misbehaving in codfw

2024-04-19 Thread bking
bking added a subscriber: RKemper.
bking added a comment.


  Unfortunately, @RKemper noticed that our data-transfer cookbook seems to have 
some issues applying the correct Kafka offsets. We'll spin off a separate 
ticket for that.

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

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

To: bking
Cc: RKemper, dr0ptp4kt, bking, dcausse, Aklapper, Danny_Benjafield_WMDE, 
Isabelladantes1983, Themindcoder, Adamm71, S8321414, Jersione, Hellket777, 
LisafBia6531, Astuthiodit_1, 786, Biggs657, karapayneWMDE, Invadibot, 
maantietaja, Juan90264, Alter-paule, Beast1978, ItamarWMDE, Un1tY, Akuckartz, 
Dringsim, Hook696, Kent7301, joker88john, CucyNoiD, Nandana, Gaboe420, 
Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, 
QZanden, EBjune, KimKelting, LawExplorer, Lewizho99, Maathavan, _jensen, 
rosalieper, Neuronton, 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] T362508: WDQS updater misbehaving in codfw

2024-04-19 Thread bking
bking updated the task description.

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

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

To: bking
Cc: RKemper, dr0ptp4kt, bking, dcausse, Aklapper, Danny_Benjafield_WMDE, 
Isabelladantes1983, Themindcoder, Adamm71, S8321414, Jersione, Hellket777, 
LisafBia6531, Astuthiodit_1, 786, Biggs657, karapayneWMDE, Invadibot, 
maantietaja, Juan90264, Alter-paule, Beast1978, ItamarWMDE, Un1tY, Akuckartz, 
Dringsim, Hook696, Kent7301, joker88john, CucyNoiD, Nandana, Gaboe420, 
Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, 
QZanden, EBjune, KimKelting, LawExplorer, Lewizho99, Maathavan, _jensen, 
rosalieper, Neuronton, 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] T316876: wdqs: replace git-fat with git-lfs

2024-04-16 Thread bking
bking added a subscriber: Gehel.
bking added a comment.


  @dancy  I can confirm that this is still on our radar. @Gehel is working on 
the archiva to gitlab migration in T358612 
<https://phabricator.wikimedia.org/T358612> , and the git-fat to git-lfs 
migration should be a part of that process.

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

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

To: bking
Cc: Gehel, dancy, RKemper, bking, demon, Aklapper, Danny_Benjafield_WMDE, 
S8321414, Astuthiodit_1, AWesterinen, TheReadOnly, BTullis, karapayneWMDE, 
Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, NebulousIris, 
Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, 
EBjune, KimKelting, merbst, LawExplorer, _jensen, rosalieper, Liudvikas, 
Scott_WUaS, Jonas, Xmlizer, thcipriani, jkroll, Wikidata-bugs, Jdouglas, aude, 
Tobias1984, Manybubbles, Mbch331, Jay8g, Krenair, jeremyb
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T361114: Alert Search Platform and/or DPE SRE when Wikidata is lagged

2024-04-08 Thread bking
bking added a comment.


  @Lucas_Werkmeister_WMDE @dcausse I should be able to help out with this one 
within the next 2 weeks. Typically we would create the alerts in the alerts 
repo <https://gerrit.wikimedia.org/r/q/project:operations/alerts> . Our 
AlertManager implementation requires a distinct alert for each team. If y'all 
wanna work together on this in a pairing session LMK, I'm typically around from 
1300 UTC - 2200 UTC .

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

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

To: bking
Cc: Lucas_Werkmeister_WMDE, dcausse, Aklapper, bking, Danny_Benjafield_WMDE, 
S8321414, Astuthiodit_1, AWesterinen, BTullis, karapayneWMDE, Invadibot, 
maantietaja, ItamarWMDE, Akuckartz, Nandana, Namenlos314, Lahi, Gq86, 
GoranSMilovanovic, QZanden, EBjune, KimKelting, merbst, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, 
Tobias1984, Manybubbles, 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] T327689: Use rsync instead of NFS for wdqs data reload cookbook

2024-04-04 Thread bking
bking edited projects, added Data-Platform-SRE (2024.03.25 - 2024.04.14); 
removed Data-Platform-SRE.

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

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

To: bking
Cc: Gehel, ArielGlenn, bking, Aklapper, Danny_Benjafield_WMDE, S8321414, 
Astuthiodit_1, AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, 
ItamarWMDE, Akuckartz, Nandana, Namenlos314, Lahi, Gq86, 
Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, KimKelting, merbst, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T327689: Use rsync instead of NFS for wdqs data reload cookbook

2024-04-04 Thread bking
bking added a project: Data-Platform-SRE.

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

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

To: bking
Cc: Gehel, ArielGlenn, bking, Aklapper, Danny_Benjafield_WMDE, S8321414, 
Astuthiodit_1, AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, 
ItamarWMDE, Akuckartz, Nandana, Namenlos314, Lahi, Gq86, 
Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, KimKelting, merbst, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T327689: Use rsync instead of NFS for wdqs data reload cookbook

2024-04-04 Thread bking
bking moved this task from monitoring to needs discussion or investigation on 
the Wikidata board.
bking closed this task as "Declined".
bking added a comment.


  This ticket resurfaced due to recent discussions around the data reload 
process (see T349069 <https://phabricator.wikimedia.org/T349069> and T359062 
<https://phabricator.wikimedia.org/T359062> , among others). At this point, it 
seems unlikely that we'll change to rsync; it's more likely we'll use a 
different process that doesn't involve the dumps server. As such, I'm closing 
this one out.

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/71/

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

To: bking
Cc: Gehel, ArielGlenn, bking, Aklapper, Danny_Benjafield_WMDE, S8321414, 
Astuthiodit_1, AWesterinen, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, KimKelting, merbst, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, 
Tobias1984, Manybubbles, 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] T361114: Alert Search Platform and/or DPE SRE when Wikidata is lagged

2024-03-27 Thread bking
bking created this task.
bking added projects: Wikidata-Query-Service, Discovery-Search (Current work), 
Wikidata, Patch-For-Review, Data-Platform-SRE.
Restricted Application removed a project: Patch-For-Review.

TASK DESCRIPTION
  Per parent ticket, our inaccurate MaxLag calculation caused throttling on 
WDQS, which translates into direct user impact on Wikidata. Unfortunately, 
Search Platform/DPE SRE did not know this was happening, as we do not receive 
alerts for this condition.
  
  Wikidata does have its own alerts dashboard 
<https://grafana.wikimedia.org/d/TUJ0V-0Zk/wikidata-alerts?orgId=1=5m=now-2d=now>,
 which suggests we could use existing alerts.
  
  Creating this ticket to:
  
  - research existing wikidata alerts
  - add Search Platform/DPE to throttling-related alerts, or create new ones 
for our teams.

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

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

To: dcausse, bking
Cc: dcausse, Aklapper, bking, Danny_Benjafield_WMDE, S8321414, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, KimKelting, merbst, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, 
Tobias1984, Manybubbles, 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] T361106: Restore wdqs1013 with a data transfer

2024-03-27 Thread bking
bking created this task.
bking added projects: Wikidata-Query-Service, Discovery-Search (Current work), 
Wikidata, Patch-For-Review, Data-Platform-SRE.
Restricted Application removed a project: Patch-For-Review.

TASK DESCRIPTION
  `wdqs1013` is too far behind and we'll need to perform a data transfer after 
we address the issues in the parent ticket.

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

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

To: bking
Cc: dcausse, Aklapper, bking, Danny_Benjafield_WMDE, S8321414, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, KimKelting, merbst, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, 
Tobias1984, Manybubbles, 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] T360993: WDQS lag propagation to wikidata not working as intended

2024-03-26 Thread bking
bking added a comment.


  Per `sudo cumin A:prometheus 'w'` from a cumin host, there are 8 active 
prometheus hosts.
  
  We also have 3 load balancer pools for each wdqs host 
<https://config-master.wikimedia.org/pybal/codfw/>:
  
  - wdqs
  - wdqs-ssl
  - wdqs-heavy-queries
  
  Each one of these represents a separate healthcheck as well.

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

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

To: dcausse, bking
Cc: bking, Aklapper, dcausse, Danny_Benjafield_WMDE, Isabelladantes1983, 
Themindcoder, Adamm71, S8321414, Jersione, Hellket777, LisafBia6531, 
Astuthiodit_1, AWesterinen, 786, Biggs657, karapayneWMDE, Invadibot, 
maantietaja, Juan90264, Alter-paule, Beast1978, ItamarWMDE, Un1tY, Akuckartz, 
Hook696, Kent7301, joker88john, CucyNoiD, Nandana, Namenlos314, Gaboe420, 
Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, KimKelting, merbst, LawExplorer, Lewizho99, 
Maathavan, _jensen, rosalieper, Neuronton, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T360993: WDQS lag propagation to wikidata not working as intended

2024-03-26 Thread bking
bking added a comment.


  > It is possible that this metric is polluted with monitoring queries that do 
not relate to serving user traffic
  
  I did a little checking around this. Prometheus blackbox checks are defined 
here 
<https://gerrit.wikimedia.org/r/plugins/gitiles/operations/puppet/+/refs/heads/production/modules/profile/manifests/query_service/monitor/wikidata_public.pp>
 . Their frequency is defined by the `scrape_interval` setting for the 
probes-custom_puppet-http.yaml job 
<https://gerrit.wikimedia.org/r/plugins/gitiles/operations/puppet/+/refs/heads/production/modules/prometheus/manifests/blackbox/check/http.pp#90>
 , which is currently 15 seconds. Since we require a unique check per team, 
that should be around 8 queries per minute per Prometheus host.
  
  Note that there are separate Prometheus checks that use the jmx exporter 
instead of blackbox, each with a frequency of 60 seconds. Looking at 
`prometheus1006`, I see the following:
  
  - jmx_wdqs_updater
  - jmx_query_service_streaming_updater
  - jmx_wdqs_blazegraph
  
  My next step is to figure out how many of the Prometheus hosts are actively 
polling each WDQS endpoint.

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

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

To: bking
Cc: bking, Aklapper, dcausse, Danny_Benjafield_WMDE, S8321414, Astuthiodit_1, 
AWesterinen, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, 
Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, KimKelting, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T358727: Reclaim recently-decommed CP host for WDQS (see T352253)

2024-03-19 Thread bking
bking closed this task as "Resolved".
bking moved this task from Backlog to Done on the Data-Platform-SRE (2024.03.04 
- 2024.03.24) board.
bking added a comment.


  Apologies for not posting this sooner. `wdqs1025` has been ready for use 
since the above request was merged. Closing this for now, but work continues in 
T359062 <https://phabricator.wikimedia.org/T359062> .

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/7020/

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

To: VRiley-WMF, bking
Cc: cmooney, Jclark-ctr, VRiley-WMF, ssingh, RKemper, dr0ptp4kt, wiki_willy, 
bking, georg, Wunderlandmeli, Danny_Benjafield_WMDE, Astuthiodit_1, BTullis, 
karapayneWMDE, joanna_borun, Invadibot, Devnull, maantietaja, Muchiri124, 
ItamarWMDE, Akuckartz, Legado_Shulgin, ReaperDawn, Nandana, Davinaclare77, 
Techguru.pc, Lahi, Gq86, GoranSMilovanovic, Hfbn0, QZanden, EBjune, KimKelting, 
LawExplorer, Zppix, _jensen, rosalieper, Scott_WUaS, Wong128hk, Wikidata-bugs, 
aude, faidon, Mbch331, Jay8g, fgiunchedi
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T359062: Assess Wikidata dump import hardware

2024-03-19 Thread bking
bking closed subtask T358727: Reclaim recently-decommed CP host for WDQS (see 
T352253) as Resolved.

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

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

To: dr0ptp4kt, bking
Cc: ssingh, bking, dr0ptp4kt, Aklapper, Danny_Benjafield_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, EBjune, KimKelting, 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] T359062: Assess Wikidata dump import hardware

2024-03-08 Thread bking
bking added a comment.


  @ssingh @dr0ptp4kt hold up on the testing for on your hosts for now...we 
might be able to get an NVMe into this year's budget, will let you know.
  
  @dr0ptp4kt If you want to run i/o tests on the existing hosts, I recommend 
the approach detailed in this wikitech page 
<https://wikitech.wikimedia.org/wiki/Kafka/Kafka-main-raid-performance-testing-2019>
 . Brendan Gregg is considered an expert on computer performance and 
benchmarking, you might try his approach 
<https://www.brendangregg.com/blog/2014-01-10/benchmarking-the-cloud.html> as 
well.

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

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

To: dr0ptp4kt, bking
Cc: ssingh, bking, dr0ptp4kt, Aklapper, Danny_Benjafield_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, EBjune, KimKelting, 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] T359062: Assess Wikidata dump import hardware

2024-03-07 Thread bking
bking added a comment.


  @dr0ptp4kt `wdqs1025` should be ready for your I/O tests. Let us know how it 
goes!

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

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

To: dr0ptp4kt, bking
Cc: bking, dr0ptp4kt, Aklapper, Danny_Benjafield_WMDE, Isabelladantes1983, 
Themindcoder, Adamm71, Jersione, Hellket777, LisafBia6531, Astuthiodit_1, 786, 
Biggs657, karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, 
Beast1978, ItamarWMDE, Un1tY, Akuckartz, Hook696, Kent7301, joker88john, 
CucyNoiD, Nandana, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, 
Bsandipan, GoranSMilovanovic, QZanden, EBjune, KimKelting, LawExplorer, 
Lewizho99, Maathavan, _jensen, rosalieper, Neuronton, 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] T358727: Reclaim recently-decommed CP host for WDQS (see T352253)

2024-03-06 Thread bking
bking added a comment.


  @Jclark-ctr Thanks for the tip, I've added a patch and will try the reimage 
again.

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

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

To: VRiley-WMF, bking
Cc: cmooney, Jclark-ctr, VRiley-WMF, ssingh, RKemper, dr0ptp4kt, wiki_willy, 
bking, Wunderlandmeli, Danny_Benjafield_WMDE, Isabelladantes1983, Themindcoder, 
Adamm71, Jersione, Hellket777, LisafBia6531, Astuthiodit_1, 786, BTullis, 
Biggs657, karapayneWMDE, joanna_borun, Invadibot, Devnull, maantietaja, 
Juan90264, Muchiri124, Alter-paule, Beast1978, ItamarWMDE, Un1tY, Akuckartz, 
Hook696, Kent7301, joker88john, Legado_Shulgin, ReaperDawn, CucyNoiD, Nandana, 
Gaboe420, Giuliamocci, Davinaclare77, Cpaulf30, Techguru.pc, Lahi, Gq86, Af420, 
Bsandipan, GoranSMilovanovic, Hfbn0, QZanden, EBjune, KimKelting, LawExplorer, 
Lewizho99, Zppix, Maathavan, _jensen, rosalieper, Neuronton, Scott_WUaS, 
Wong128hk, Wikidata-bugs, aude, faidon, Mbch331, Jay8g, fgiunchedi
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T358727: Reclaim recently-decommed CP host for WDQS (see T352253)

2024-03-06 Thread bking
bking added a comment.


  @VRiley-WMF
  
  Unfortunately, I'm still getting errors (screenshot) 
<https://ewr1.vultrobjects.com/work/disk_errors_wdqs1025.png>  when I try to 
boot up the host. Are you able to reseat the cables and disks?

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

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

To: VRiley-WMF, bking
Cc: cmooney, Jclark-ctr, VRiley-WMF, ssingh, RKemper, dr0ptp4kt, wiki_willy, 
bking, Wunderlandmeli, Danny_Benjafield_WMDE, Astuthiodit_1, BTullis, 
karapayneWMDE, joanna_borun, Invadibot, Devnull, maantietaja, Muchiri124, 
ItamarWMDE, Akuckartz, Legado_Shulgin, ReaperDawn, Nandana, Davinaclare77, 
Techguru.pc, Lahi, Gq86, GoranSMilovanovic, Hfbn0, QZanden, EBjune, KimKelting, 
LawExplorer, Zppix, _jensen, rosalieper, Scott_WUaS, Wong128hk, Wikidata-bugs, 
aude, faidon, Mbch331, Jay8g, fgiunchedi
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T358727: Reclaim recently-decommed CP host for WDQS (see T352253)

2024-03-06 Thread bking
bking reopened this task as "Open".
bking added a comment.


  @VRiley-WMF `wdqs1025` is failing to reimage. I can't see any disks in the 
DRAC interface, are you able to check the disks and see if they're properly 
seated?

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

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

To: VRiley-WMF, bking
Cc: cmooney, Jclark-ctr, VRiley-WMF, ssingh, RKemper, dr0ptp4kt, wiki_willy, 
bking, Wunderlandmeli, Danny_Benjafield_WMDE, Astuthiodit_1, BTullis, 
karapayneWMDE, joanna_borun, Invadibot, Devnull, maantietaja, Muchiri124, 
ItamarWMDE, Akuckartz, Legado_Shulgin, ReaperDawn, Nandana, Davinaclare77, 
Techguru.pc, Lahi, Gq86, GoranSMilovanovic, Hfbn0, QZanden, EBjune, KimKelting, 
LawExplorer, Zppix, _jensen, rosalieper, Scott_WUaS, Wong128hk, Wikidata-bugs, 
aude, faidon, Mbch331, Jay8g, fgiunchedi
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T359062: Assess Wikidata dump import hardware

2024-03-06 Thread bking
bking reopened subtask T358727: Reclaim recently-decommed CP host for WDQS (see 
T352253) as Open.

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

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

To: dr0ptp4kt, bking
Cc: dr0ptp4kt, Aklapper, Danny_Benjafield_WMDE, Astuthiodit_1, karapayneWMDE, 
Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, Gq86, 
GoranSMilovanovic, QZanden, EBjune, KimKelting, 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] T358727: Reclaim recently-decommed CP host for WDQS (see T352253)

2024-03-05 Thread bking
bking added a parent task: T359062: Assess Wikidata dump import hardware.

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

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

To: VRiley-WMF, bking
Cc: cmooney, Jclark-ctr, VRiley-WMF, ssingh, RKemper, dr0ptp4kt, wiki_willy, 
bking, Wunderlandmeli, Danny_Benjafield_WMDE, Astuthiodit_1, BTullis, 
karapayneWMDE, joanna_borun, Invadibot, Devnull, maantietaja, Muchiri124, 
ItamarWMDE, Akuckartz, Legado_Shulgin, ReaperDawn, Nandana, Davinaclare77, 
Techguru.pc, Lahi, Gq86, GoranSMilovanovic, Hfbn0, QZanden, EBjune, KimKelting, 
LawExplorer, Zppix, _jensen, rosalieper, Scott_WUaS, Wong128hk, Wikidata-bugs, 
aude, faidon, Mbch331, Jay8g, fgiunchedi
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T359062: Assess Wikidata dump import hardware

2024-03-05 Thread bking
bking added a subtask: T358727: Reclaim recently-decommed CP host for WDQS (see 
T352253).

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

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

To: dr0ptp4kt, bking
Cc: dr0ptp4kt, Aklapper, Danny_Benjafield_WMDE, Astuthiodit_1, karapayneWMDE, 
Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, Gq86, 
GoranSMilovanovic, QZanden, EBjune, KimKelting, 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] T358727: Reclaim recently-decommed CP host for WDQS (see T352253)

2024-03-01 Thread bking
bking added a comment.


  @VRiley-WMF or @Jclark-ctr are there any other lifecycle steps I need to take 
to get this host back into production as `wdqs1025`? This host was already 
decommissioned, so I'm not sure what to do to get it back into production.
  
  I can't seem to reach `cp1086.mgmt.eqiad.wmnet` , FWiW.

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

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

To: VRiley-WMF, bking
Cc: Jclark-ctr, VRiley-WMF, ssingh, RKemper, dr0ptp4kt, wiki_willy, bking, 
Wunderlandmeli, Danny_Benjafield_WMDE, Astuthiodit_1, AWesterinen, BTullis, 
karapayneWMDE, joanna_borun, Invadibot, Devnull, maantietaja, Muchiri124, 
ItamarWMDE, Akuckartz, Legado_Shulgin, ReaperDawn, Nandana, Namenlos314, 
Davinaclare77, Techguru.pc, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, Hfbn0, QZanden, EBjune, KimKelting, merbst, LawExplorer, 
Zppix, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, Wong128hk, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, faidon, Mbch331, Jay8g, 
fgiunchedi
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T358727: Reclaim recently-decommed CP host for WDQS (see T352253)

2024-02-28 Thread bking
bking updated the task description.

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

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

To: bking
Cc: ssingh, RKemper, dr0ptp4kt, wiki_willy, bking, AWesterinen, BTullis, 
Namenlos314, Gq86, Lucas_Werkmeister_WMDE, EBjune, KimKelting, merbst, Jonas, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
fgiunchedi
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T358727: Reclaim recently-decommed CP host for WDQS (see T352253)

2024-02-28 Thread bking
bking created this task.
bking added projects: Data-Platform-SRE, Wikidata-Query-Service, ops-eqiad.

TASK DESCRIPTION
  Hello DC Ops,
  
  Per T352253 <https://phabricator.wikimedia.org/T352253> , @dr0ptp4kt 
requested one of the recently-decommed CP hosts for the WDQS graph split 
experiment <https://phabricator.wikimedia.org/T337013>  (specifically, we are 
curious if NVME drives can speed up our data reload process).
  
  Creating ticket based on @wiki_willy 's request in the earlier ticket 
<https://phabricator.wikimedia.org/T352253#9572739> :
  
  - **hostname ** wdqs1025.eqiad.wnet
  - **racking info** any 10G RACK
  - **network setup** private VLAN
  - **raid/partitioning** 
`modules/install_server/files/autoinstall/partman/custom/cacheproxy.cfg` from 
puppet repo
  - **OS**  Debian Bullseye
  - **main poc ** @bking (IRC: inflatador)
  - **needed for:**  1 month (decom by end of March)
  
  Thanks for taking a look! Please let me know if you need more info.

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

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

To: bking
Cc: ssingh, RKemper, dr0ptp4kt, wiki_willy, bking, AWesterinen, BTullis, 
Namenlos314, Gq86, Lucas_Werkmeister_WMDE, EBjune, KimKelting, merbst, Jonas, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
fgiunchedi
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T350464: Expose SPARQL endpoints with full wikidata data set and with split graph to enable experimentation on federation with a split graph

2024-01-16 Thread bking
bking closed subtask T352878: Troubleshoot recurring systemd unit failures and 
availability issues for wdqs1022-24 as Resolved.

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

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

To: bking
Cc: Gehel, Aklapper, Danny_Benjafield_WMDE, Astuthiodit_1, AWesterinen, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, 
EBjune, KimKelting, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
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] T354555: WDQS graph split hosts: Remove throttling/banning mechanisms and investigate external connectivity

2024-01-11 Thread bking
bking moved this task from In Progress to Done on the Data-Platform-SRE 
(2023/24 Q3 Milestone 1) board.
bking closed this task as "Resolved".
bking claimed this task.
bking added a comment.


  Merging/applying the above patch added TLS to the test hosts, using the 
domain "wdqs-test.eqiad.wmnet". You can also access individual hosts by their 
FQDN (such as https://wdqs1022.eqiad.wmnet). Closing...

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/6881/

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

To: bking
Cc: BTullis, Aklapper, RKemper, bking, dcausse, Danny_Benjafield_WMDE, 
Astuthiodit_1, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, 
Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, KimKelting, 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] T336577: Update WDQS Runbook following update lag incident

2024-01-09 Thread bking
bking closed this task as "Resolved".
bking moved this task from Backlog to Done on the Data-Platform-SRE (2023/24 Q3 
Milestone 1) board.
bking claimed this task.

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/6881/

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

To: bking
Cc: bking, dcausse, Gehel, Aklapper, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, Zabe, LSobanski, maantietaja, 
lmata, ItamarWMDE, Akuckartz, PatsagornY, DannyS712, Nandana, Namenlos314, 
jijiki, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, 
KimKelting, merbst, LawExplorer, elukey, _jensen, rosalieper, Scott_WUaS, 
Jonas, Xmlizer, Wong128hk, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Bawolff, Manybubbles, ArielGlenn, He7d3r, Jdforrester-WMF, Mbch331, Jay8g, 
akosiaris, fgiunchedi
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T336134: wdqs2*** lagged for more than one day

2024-01-09 Thread bking
bking closed subtask T336577: Update WDQS Runbook following update lag incident 
as Resolved.

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

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

To: bking
Cc: karapayneWMDE, bking, Aklapper, Bugreporter, Danny_Benjafield_WMDE, 
Astuthiodit_1, AWesterinen, Invadibot, Zabe, maantietaja, lmata, ItamarWMDE, 
Akuckartz, PatsagornY, DannyS712, Nandana, Namenlos314, jijiki, Lahi, Gq86, 
Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, KimKelting, merbst, 
LawExplorer, elukey, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, 
Wong128hk, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Bawolff, 
Manybubbles, ArielGlenn, He7d3r, Jdforrester-WMF, Mbch331, Jay8g, akosiaris
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


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

2024-01-09 Thread bking
bking added a comment.


  Based on a quick read of the linked documentation and a small addition, I 
believe we have satisfied the requirements. Closing...

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

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

To: bking
Cc: bking, dcausse, Gehel, Aklapper, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, Zabe, LSobanski, maantietaja, 
lmata, ItamarWMDE, Akuckartz, PatsagornY, DannyS712, Nandana, Namenlos314, 
jijiki, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, 
KimKelting, merbst, LawExplorer, elukey, _jensen, rosalieper, Scott_WUaS, 
Jonas, Xmlizer, Wong128hk, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Bawolff, Manybubbles, ArielGlenn, He7d3r, Jdforrester-WMF, Mbch331, Jay8g, 
akosiaris, fgiunchedi
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T354555: WDQS graph split hosts: Remove throttling/banning mechanisms and investigate external connectivity

2024-01-09 Thread bking
bking changed the task status from "Open" to "In Progress".
bking moved this task from Backlog to Needs Review on the Data-Platform-SRE 
(2023/24 Q3 Milestone 1) board.
bking added a subscriber: BTullis.
bking added a comment.


  Per pairing session with @BTullis , the wdqs test hosts are not running 
envoy, so only the cleartext ports are available. If TLS is required, we can 
enable it in puppet by inculding the `profile::tlsproxy::envoy` profile, as we 
do in `modules/role/manifests/wdqs/public.pp`.
  
  @dcausse let us know if you think we should enable TLS. If not, feel free to 
close out this ticket.

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/6881/

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

To: bking
Cc: BTullis, Aklapper, RKemper, bking, dcausse, Danny_Benjafield_WMDE, 
Astuthiodit_1, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, 
Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, KimKelting, 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] T354555: WDQS graph split hosts: Remove throttling/banning mechanisms and investigate external connectivity

2024-01-09 Thread bking
bking renamed this task from "WDQS graph split hosts: Remove throttling/banning 
mechanisms and improve hadoop access" to "WDQS graph split hosts: Remove 
throttling/banning mechanisms and investigate external connectivity".

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

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

To: bking
Cc: Aklapper, RKemper, bking, dcausse, Danny_Benjafield_WMDE, Astuthiodit_1, 
BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, 
Lahi, Gq86, GoranSMilovanovic, QZanden, KimKelting, 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] T354555: WDQS graph split hosts: Remove throttling/banning mechanisms and improve hadoop access

2024-01-09 Thread bking
bking updated the task description.

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

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

To: bking
Cc: Aklapper, RKemper, bking, dcausse, Danny_Benjafield_WMDE, Astuthiodit_1, 
BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, 
Lahi, Gq86, GoranSMilovanovic, QZanden, KimKelting, 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] T354555: WDQS graph split hosts: Remove throttling/banning mechanisms and improve hadoop access

2024-01-09 Thread bking
bking updated the task description.

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

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

To: bking
Cc: Aklapper, RKemper, bking, dcausse, Danny_Benjafield_WMDE, Astuthiodit_1, 
BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, 
Lahi, Gq86, GoranSMilovanovic, QZanden, KimKelting, 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] T354555: WDQS graph split hosts: Remove throttling/banning mechanisms and improve hadoop access

2024-01-09 Thread bking
bking updated the task description.

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

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

To: bking
Cc: Aklapper, RKemper, bking, dcausse, Danny_Benjafield_WMDE, Astuthiodit_1, 
BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, 
Lahi, Gq86, GoranSMilovanovic, QZanden, KimKelting, 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] T354555: WDQS graph split hosts: Remove throttling/banning mechanisms and improve hadoop access

2024-01-08 Thread bking
bking created this task.
bking added projects: Wikidata, Data-Platform-SRE.
Restricted Application added a subscriber: Aklapper.

TASK DESCRIPTION
  Per IRC conversation with @dcausse , we have a couple of issues with the 
graph split hosts:
  
  - Querying the test hosts is resulting in bans: `"You have been banned until 
2024-01-09T19:15:34.264Z"` . These hosts (all members of the 'test' tier) are 
not publicly accessible, so throttling/banning mechanisms can be removed.
  
  - Hadoop access only works via cleartext HTTP. Investigate why we can't reach 
the hadoop hosts using TLS and correct if possible.

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

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

To: bking
Cc: Aklapper, RKemper, bking, dcausse, Danny_Benjafield_WMDE, Astuthiodit_1, 
BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, 
Lahi, Gq86, GoranSMilovanovic, QZanden, KimKelting, 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] T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator

2024-01-08 Thread bking
bking edited projects, added Data-Platform-SRE; removed Data-Platform-SRE 
(2023/24 Q3 Milestone 1).

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

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

To: bking
Cc: dcausse, JMeybohm, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, KimKelting, merbst, LawExplorer, _jensen, 
rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, 
Tobias1984, Manybubbles, 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] T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator

2024-01-05 Thread bking
bking updated the task description.

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

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

To: bking
Cc: dcausse, JMeybohm, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator

2024-01-05 Thread bking
bking edited projects, added Data-Platform-SRE (2023/24 Q3 Milestone 1); 
removed Data-Platform-SRE.

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

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

To: bking
Cc: dcausse, JMeybohm, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator

2024-01-05 Thread bking
bking claimed this task.

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

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

To: bking
Cc: dcausse, JMeybohm, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T347284: Restore service for https://query.wikidata.org/bigdata/ldf

2023-12-20 Thread bking
bking closed subtask T347355: Create alerts for 
https://query.wikidata.org/bigdata/ldf as Resolved.

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

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

To: bking
Cc: RKemper, bking, MisterSynergy, dcausse, Aklapper, Danny_Benjafield_WMDE, 
Astuthiodit_1, AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, 
ItamarWMDE, Akuckartz, Nandana, Namenlos314, Lahi, Gq86, 
Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T352921: Review alerts for miscweb-hosted domains commons-query.wikimedia.org and query.wikidata.org

2023-12-18 Thread bking
bking closed this task as "Resolved".

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

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

To: bking
Cc: Aklapper, Gehel, BTullis, bking, Dzahn, Danny_Benjafield_WMDE, 
Astuthiodit_1, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 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] T352921: Review alerts for miscweb-hosted domains commons-query.wikimedia.org and query.wikidata.org

2023-12-18 Thread bking
bking added a comment.


  No objections from the Search Platform side. Side note, our new team (Data 
Platform SRE) is reviewing its alerts and alerting strategy, 
<https://phabricator.wikimedia.org/T345698> so our config may change in the 
near future.

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

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

To: bking
Cc: Aklapper, Gehel, BTullis, bking, Dzahn, Danny_Benjafield_WMDE, 
Astuthiodit_1, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 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] T350106: Implement a spark job that converts a RDF triples table into a RDF file format

2023-12-07 Thread bking
bking added a comment.


  I started a transfer from of the gzip files mentioned above to `wdqs1023` 
from `wdqs1024 ` (wdqs hosts have 10Gbps Ethernet vs. 1Gps for the stat 
machines, so this should be faster).
  
  You can set a temporary iptables rule to allow traffic between hosts on an 
arbitrary port:
  
  On destination: ` iptables -I INPUT 1 -p tcp --dport ${PORT} -s ${SENDER -j 
ACCEPT `
  
  Remember to disable Puppet first, and re-enable it afterwards!

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

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

To: dr0ptp4kt, bking
Cc: RKemper, EBernhardson, Aklapper, BTullis, bking, dr0ptp4kt, JAllemandou, 
dcausse, Danny_Benjafield_WMDE, Isabelladantes1983, Themindcoder, Adamm71, 
Jersione, Hellket777, LisafBia6531, Astuthiodit_1, AWesterinen, 786, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, 
ItamarWMDE, Un1tY, Akuckartz, Hook696, Kent7301, joker88john, CucyNoiD, 
Nandana, Namenlos314, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, 
Bsandipan, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, Lewizho99, Maathavan, _jensen, rosalieper, Neuronton, Scott_WUaS, 
Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
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] T352921: Review alerts for miscweb-hosted domains commons-query.wikimedia.org and query.wikidata.org

2023-12-06 Thread bking
bking updated the task description.

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

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

To: bking
Cc: Aklapper, Gehel, BTullis, bking, Dzahn, me, Danny_Benjafield_WMDE, 
Astuthiodit_1, BeautifulBold, Suran38, karapayneWMDE, Invadibot, maantietaja, 
Peteosx1x, NavinRizwi, ItamarWMDE, Akuckartz, Nandana, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, Dinoguy1000, 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] T352921: Review alerts for miscweb-hosted domains commons-query.wikimedia.org and query.wikidata.org

2023-12-06 Thread bking
bking created this task.
bking added projects: Data-Platform-SRE, Epic, Wikidata.

TASK DESCRIPTION
  Per IRC conversation with @Dzahn , we noticed that there a couple of Data 
Platform SRE-owned sites ( commons-query.wikimedia.org and query.wikidata.org) 
hosted at least in part from the miscweb servers.  (I think it's just the web 
UI for each service).
  
  Creating this ticket to:
  
  - Review alerts for these sites
  - Ensure we have correct alerts (teams, urgency, etc) for each site.
  - Update docs for the above as needed.

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

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

To: bking
Cc: Aklapper, Gehel, BTullis, bking, Dzahn, me, Danny_Benjafield_WMDE, 
Astuthiodit_1, BeautifulBold, Suran38, karapayneWMDE, Invadibot, maantietaja, 
Peteosx1x, NavinRizwi, ItamarWMDE, Akuckartz, Nandana, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, Dinoguy1000, 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] T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator

2023-12-06 Thread bking
bking updated the task description.

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

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

To: bking
Cc: dcausse, JMeybohm, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T347355: Create alerts for https://query.wikidata.org/bigdata/ldf

2023-12-05 Thread bking
bking added a comment.


  Reverted the last change after we some alerts for the following hosts: `1008 
1009 1010 1011 2008 2014`
  
  I suspect this has something to do with the tiers, since the ldf_host var was 
set in public.yaml...will check and respond here.

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

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

To: bking
Cc: Gehel, Dzahn, LSobanski, Aklapper, bking, Danny_Benjafield_WMDE, 
Astuthiodit_1, AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, 
ItamarWMDE, Akuckartz, Nandana, Namenlos314, Lahi, Gq86, 
Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T349095: Migrate staging rdf-streaming-updater to flink operator

2023-11-30 Thread bking
bking closed this task as "Resolved".
bking moved this task from In Progress to Done on the Data-Platform-SRE board.
bking added a comment.


  Apologies for the confusion. We have already migrated the 
rdf-streaming-updater to production, so I'm closing this ticket (which is 
focused on staging) as well.

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/6524/

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

To: bking
Cc: pfischer, EBernhardson, dcausse, BTullis, Aklapper, bking, 
Danny_Benjafield_WMDE, Isabelladantes1983, Themindcoder, Adamm71, Jersione, 
Hellket777, LisafBia6531, Astuthiodit_1, AWesterinen, 786, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, 
ItamarWMDE, Un1tY, Akuckartz, Hook696, Kent7301, joker88john, CucyNoiD, 
Nandana, Namenlos314, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, 
Bsandipan, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, Lewizho99, Maathavan, _jensen, rosalieper, Neuronton, Scott_WUaS, 
Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
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] T326409: Migrate the wdqs streaming updater flink jobs to flink-k8s-operator deployment model

2023-11-30 Thread bking
bking closed subtask T349095: Migrate staging rdf-streaming-updater to flink 
operator as Resolved.

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

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

To: bking
Cc: Gehel, BTullis, JMeybohm, gmodena, Ottomata, bking, Aklapper, dcausse, 
Danny_Benjafield_WMDE, Kappakayala, Astuthiodit_1, AWesterinen, Arnoldokoth, 
karapayneWMDE, Invadibot, maantietaja, wkandek, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, jijiki, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
Mbch331, Clement_Goubert
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T347355: Create alerts for https://query.wikidata.org/bigdata/ldf

2023-11-30 Thread bking
bking added a comment.


  After some thought, I think the problem is the blackbox check's association 
with miscweb. We are actually cutting around miscweb when we access the ldf 
endpoint, so we should put the blackbox check outside of 
`modules/profile/manifests/microsites/query_service.pp` , which creates said 
association.

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

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

To: bking
Cc: Gehel, Dzahn, LSobanski, Aklapper, bking, Danny_Benjafield_WMDE, 
Astuthiodit_1, AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, 
ItamarWMDE, Akuckartz, Nandana, Namenlos314, Lahi, Gq86, 
Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T347504: WDQS graph split: load data from dumps into new hosts

2023-11-30 Thread bking
bking moved this task from In Progress to Blocked / Waiting on the 
Data-Platform-SRE board.
bking added a comment.


  Moving to "blocked/waiting" until we have confirmation on the reload data.

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/6524/

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

To: bking
Cc: dr0ptp4kt, RKemper, dcausse, Aklapper, bking, Danny_Benjafield_WMDE, 
Astuthiodit_1, AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, 
ItamarWMDE, Akuckartz, Nandana, Namenlos314, Lahi, Gq86, 
Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T347355: Create alerts for https://query.wikidata.org/bigdata/ldf

2023-11-29 Thread bking
bking added a comment.


  We've silenced the alert for another 24 hours. The network probes Grafana 
dashboard 
<https://grafana-rw.wikimedia.org/d/O0nHhdhnz/network-probes-overview?forceLogin=true=1=probes%2Fcustom=All=3>
 is still showing 0% availability for our ldf probe .

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

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

To: bking
Cc: Gehel, Dzahn, LSobanski, Aklapper, bking, Danny_Benjafield_WMDE, 
Isabelladantes1983, Themindcoder, Adamm71, Jersione, Hellket777, LisafBia6531, 
Astuthiodit_1, AWesterinen, 786, BTullis, Biggs657, karapayneWMDE, Invadibot, 
maantietaja, Juan90264, Alter-paule, Beast1978, ItamarWMDE, Un1tY, Akuckartz, 
Hook696, Kent7301, joker88john, CucyNoiD, Nandana, Namenlos314, Gaboe420, 
Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Lewizho99, Maathavan, 
_jensen, rosalieper, Neuronton, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T326409: Migrate the wdqs streaming updater flink jobs to flink-k8s-operator deployment model

2023-11-29 Thread bking
bking moved this task from In Progress to Done on the Data-Platform-SRE board.
bking closed this task as "Resolved".

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/6524/

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

To: bking
Cc: Gehel, BTullis, JMeybohm, gmodena, Ottomata, bking, Aklapper, dcausse, 
Danny_Benjafield_WMDE, Kappakayala, Astuthiodit_1, AWesterinen, Arnoldokoth, 
karapayneWMDE, Invadibot, maantietaja, wkandek, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, jijiki, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
Mbch331, Clement_Goubert
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T326409: Migrate the wdqs streaming updater flink jobs to flink-k8s-operator deployment model

2023-11-29 Thread bking
bking added a comment.


  I'm happy to say the flink operator migration is complete. Commons and 
wikidata are stable in both CODFW and EQIAD. As such, I'm resolving this 
ticket. Post-migration cleanup work continues in T350784 
<https://phabricator.wikimedia.org/T350784> .

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

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

To: bking
Cc: Gehel, BTullis, JMeybohm, gmodena, Ottomata, bking, Aklapper, dcausse, 
Danny_Benjafield_WMDE, Kappakayala, Astuthiodit_1, AWesterinen, Arnoldokoth, 
karapayneWMDE, Invadibot, maantietaja, wkandek, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, jijiki, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
Mbch331, Clement_Goubert
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T326409: Migrate the wdqs streaming updater flink jobs to flink-k8s-operator deployment model

2023-11-29 Thread bking
bking updated the task description.

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

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

To: bking
Cc: Gehel, BTullis, JMeybohm, gmodena, Ottomata, bking, Aklapper, dcausse, 
Danny_Benjafield_WMDE, Kappakayala, Astuthiodit_1, AWesterinen, Arnoldokoth, 
karapayneWMDE, Invadibot, maantietaja, wkandek, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, jijiki, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
Mbch331, Clement_Goubert
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator

2023-11-29 Thread bking
bking updated the task description.

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

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

To: bking
Cc: dcausse, JMeybohm, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T326409: Migrate the wdqs streaming updater flink jobs to flink-k8s-operator deployment model

2023-11-29 Thread bking
bking updated the task description.

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

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

To: bking
Cc: Gehel, BTullis, JMeybohm, gmodena, Ottomata, bking, Aklapper, dcausse, 
Danny_Benjafield_WMDE, Kappakayala, Astuthiodit_1, AWesterinen, Arnoldokoth, 
karapayneWMDE, Invadibot, maantietaja, wkandek, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, jijiki, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
Mbch331, Clement_Goubert
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator

2023-11-29 Thread bking
bking updated the task description.

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

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

To: bking
Cc: dcausse, JMeybohm, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator

2023-11-29 Thread bking
bking updated the task description.

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

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

To: bking
Cc: dcausse, JMeybohm, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T326409: Migrate the wdqs streaming updater flink jobs to flink-k8s-operator deployment model

2023-11-29 Thread bking
bking updated the task description.

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

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

To: bking
Cc: Gehel, BTullis, JMeybohm, gmodena, Ottomata, bking, Aklapper, dcausse, 
Danny_Benjafield_WMDE, Kappakayala, Astuthiodit_1, AWesterinen, Arnoldokoth, 
karapayneWMDE, Invadibot, maantietaja, wkandek, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, jijiki, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
Mbch331, Clement_Goubert
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator

2023-11-29 Thread bking
bking added a comment.


  [ ] remove unused secrets from kubernetes.yaml on private puppet

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

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

To: bking
Cc: dcausse, JMeybohm, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T347355: Create alerts for https://query.wikidata.org/bigdata/ldf

2023-11-28 Thread bking
bking added a comment.


  I've created another 24-hour silence for this alert, UUID 
59b5ca30-1aeb-4d06-b083-7023a373ccb3 .

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

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

To: bking
Cc: Gehel, Dzahn, LSobanski, Aklapper, bking, Danny_Benjafield_WMDE, 
Isabelladantes1983, Themindcoder, Adamm71, Jersione, Hellket777, LisafBia6531, 
Astuthiodit_1, AWesterinen, 786, BTullis, Biggs657, karapayneWMDE, Invadibot, 
maantietaja, Juan90264, Alter-paule, Beast1978, ItamarWMDE, Un1tY, Akuckartz, 
Hook696, Kent7301, joker88john, CucyNoiD, Nandana, Namenlos314, Gaboe420, 
Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Lewizho99, Maathavan, 
_jensen, rosalieper, Neuronton, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T347355: Create alerts for https://query.wikidata.org/bigdata/ldf

2023-11-27 Thread bking
bking added a comment.


  The probe is getting a 500 error, which is spawning phab tickets for 
serviceops-collab team (see T352084 <https://phabricator.wikimedia.org/T352084> 
). As such, I've set a 24-hour suppression in alertmanager (UUID 
fc02d897-8a64-4ebb-a362-77a765a7f155 )  . Will revisit once I'm back at work 
tomorrow.

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

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

To: bking
Cc: Dzahn, LSobanski, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T347355: Create alerts for https://query.wikidata.org/bigdata/ldf

2023-11-27 Thread bking
bking added a comment.


  Looks like the check targets are rendered at 
`/srv/prometheus/ops/targets/probes-custom_puppet-http.yaml` on the prom hosts
  after merging the above patch, the target config for LDF endpoint looks like 
this <https://phabricator.wikimedia.org/P53914#218087>
  
  and the blackbox config at 
`/etc/prometheus/blackbox.yml.d/query_wikidata_org.yml` looks like this 
<https://phabricator.wikimedia.org/P53914> .

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

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

To: bking
Cc: Dzahn, LSobanski, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T347504: WDQS graph split: load data from dumps into new hosts

2023-11-27 Thread bking
bking added a comment.


  Looks like the data reload for lexemes completed. @dcausse , are you able to 
check the data from the reload and make sure it's usable? Let me know if I can 
help.

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

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

To: bking
Cc: RKemper, dcausse, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T241128: EPIC: Reduce the time needed to do the initial WDQS import

2023-11-20 Thread bking
bking updated the task description.

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

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

To: bking
Cc: MPhamWMF, Gehel, Addshore, dcausse, Aklapper, me, Danny_Benjafield_WMDE, 
Astuthiodit_1, AWesterinen, BeautifulBold, Suran38, karapayneWMDE, Invadibot, 
maantietaja, Peteosx1x, NavinRizwi, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, 
EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, 
jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Dinoguy1000, Manybubbles, 
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] T241128: EPIC: Reduce the time needed to do the initial WDQS import

2023-11-20 Thread bking
bking updated the task description.

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

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

To: bking
Cc: MPhamWMF, Gehel, Addshore, dcausse, Aklapper, me, Danny_Benjafield_WMDE, 
Astuthiodit_1, AWesterinen, BeautifulBold, Suran38, karapayneWMDE, Invadibot, 
maantietaja, Peteosx1x, NavinRizwi, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, 
EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, 
jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Dinoguy1000, Manybubbles, 
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] T351662: Test hardware-based performance optimizations for WDQS import

2023-11-20 Thread bking
bking added a comment.


  Thanks @Addshore , this is a wealth of great info!
  
  Your observation
  
  > CPU clock speed makes a big difference with the first 10 batches of RDF 
taking 2 hours less on a c2-standard-8 3.1-3.8 Ghz machine instead of a 
n1-standard-8 2.2-3.7 Ghz machine. This was a reduction from 6 hours to 4 hours.
  
  Seems to line up with the observations from T336443 
<https://phabricator.wikimedia.org/T336443> . Will get a data-reload started on 
`wdqs1024` and report back.

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

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

To: bking
Cc: RKemper, Aklapper, dcausse, Addshore, Gehel, MPhamWMF, bking, me, 
Danny_Benjafield_WMDE, Astuthiodit_1, AWesterinen, BeautifulBold, Suran38, 
karapayneWMDE, Invadibot, maantietaja, Peteosx1x, NavinRizwi, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Dinoguy1000, Manybubbles, 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] T326409: Migrate the wdqs streaming updater flink jobs to flink-k8s-operator deployment model

2023-11-20 Thread bking
bking updated the task description.

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

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

To: bking
Cc: Gehel, BTullis, JMeybohm, gmodena, Ottomata, bking, Aklapper, dcausse, 
Danny_Benjafield_WMDE, Kappakayala, Astuthiodit_1, AWesterinen, Arnoldokoth, 
karapayneWMDE, Invadibot, maantietaja, wkandek, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, jijiki, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
Mbch331, Clement_Goubert
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T351662: Test hardware-based performance optimizations for WDQS import

2023-11-20 Thread bking
bking added a comment.


  We'll test I/O `wdqs1014` (R440 
<https://phabricator.wikimedia.org/diffusion/EPOC/>) and `wdqs1015` (R450 
<https://phabricator.wikimedia.org/diffusion/EPRO/>) using `fio`. This Wikitech 
page 
<https://wikitech.wikimedia.org/wiki/Kafka/Kafka-main-raid-performance-testing-2019>
 might be useful

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

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

To: bking
Cc: RKemper, Aklapper, dcausse, Addshore, Gehel, MPhamWMF, bking, me, 
Danny_Benjafield_WMDE, Astuthiodit_1, AWesterinen, BeautifulBold, Suran38, 
karapayneWMDE, Invadibot, maantietaja, Peteosx1x, NavinRizwi, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Dinoguy1000, Manybubbles, 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] T351662: Test hardware-based performance optimizations for WDQS import

2023-11-20 Thread bking
bking created this task.
bking added projects: Wikidata, Wikidata-Query-Service, Epic.

TASK DESCRIPTION
  Per today's Search Platform triage meeting, I'm creating this ticket to 
specifically test hardware optimizations that could speed up the import 
process. This is in contrast to T336443 
<https://phabricator.wikimedia.org/T336443> , where we are trying to figure out 
why a data reload is so much slower for our newest R450 
<https://phabricator.wikimedia.org/diffusion/EPRO/> chassis.
  
  AC:
  
  - Look into possible hardware optimizations
  - Determine good benchmarking test
  - Enable optimizations one-at-a-time and capture results

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

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

To: bking
Cc: RKemper, Aklapper, dcausse, Addshore, Gehel, MPhamWMF, bking, me, 
Danny_Benjafield_WMDE, Astuthiodit_1, AWesterinen, BeautifulBold, Suran38, 
karapayneWMDE, Invadibot, maantietaja, Peteosx1x, NavinRizwi, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Dinoguy1000, Manybubbles, 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] T347504: WDQS graph split: load data from dumps into new hosts

2023-11-20 Thread bking
bking added a comment.


  Update: The wikidata dump finished on wdqs1022 ( Wikidata dump loaded in 25 
days, 13:32:17.263762) .
  
  But all 3 hosts are stuck at the moment; I'm not sure what happened but each 
of their individual tasks are stuck at 0%. Maybe the dumps server locked up?

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

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

To: bking
Cc: RKemper, dcausse, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T347355: Create alerts for https://query.wikidata.org/bigdata/ldf

2023-11-14 Thread bking
bking claimed this task.
bking moved this task from Prioritized Backlog to In Progress on the 
Data-Platform-SRE board.

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/6524/

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

To: bking
Cc: Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, AWesterinen, 
BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, 
EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, 
jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T347355: Create alerts for https://query.wikidata.org/bigdata/ldf

2023-11-14 Thread bking
bking added a comment.


  team-sre/probes.yaml 
<https://github.com/wikimedia/operations-alerts/blob/master/team-sre/probes.yaml>
 in the alerts repo looks like a good place to start.
  
  That file also references `prometheus::blackbox::check::http` , which looks 
like an easy way to set add monitoring via the puppet repo.

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

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

To: bking
Cc: Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, AWesterinen, 
BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, 
EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, 
jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T349095: Migrate staging rdf-streaming-updater to flink operator

2023-11-13 Thread bking
bking added a comment.


  Both apps (commons and wikidata) are stable in staging-eqiad now:
  
bking@deploy2002:~/deployment-charts$ kubectl get 
flinkdeployments.flink.apache.org
NAME JOB STATUS   LIFECYCLE STATE
flink-app-commonsRUNNING  STABLE
flink-app-wikidata   RUNNING  STABLE
  
  Assuming the service remains stable, we should be able to migrate the 
production rdf-streaming-updater shortly.

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

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

To: bking
Cc: pfischer, EBernhardson, dcausse, BTullis, Aklapper, bking, 
Danny_Benjafield_WMDE, Isabelladantes1983, Themindcoder, Adamm71, Jersione, 
Hellket777, LisafBia6531, Astuthiodit_1, AWesterinen, 786, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, 
ItamarWMDE, Un1tY, Akuckartz, Hook696, Kent7301, joker88john, CucyNoiD, 
Nandana, Namenlos314, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, 
Bsandipan, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, Lewizho99, Maathavan, _jensen, rosalieper, Neuronton, Scott_WUaS, 
Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
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] T347504: WDQS graph split: load data from dumps into new hosts

2023-11-13 Thread bking
bking added a comment.


  Another progress report: We are 80% (869/1104) done on the leading host 
(wdqs1022).

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

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

To: bking
Cc: RKemper, dcausse, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator

2023-11-08 Thread bking
bking updated the task description.

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

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

To: bking
Cc: dcausse, JMeybohm, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator

2023-11-08 Thread bking
bking added a project: Wikidata-Query-Service.

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

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

To: bking
Cc: dcausse, JMeybohm, Aklapper, bking, AWesterinen, BTullis, Namenlos314, 
Gq86, Lucas_Werkmeister_WMDE, EBjune, merbst, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T347504: WDQS graph split: load data from dumps into new hosts

2023-11-07 Thread bking
bking added a comment.


  In T347504#9307835 <https://phabricator.wikimedia.org/T347504#9307835>, 
@dcausse wrote:
  
  > @bking thanks for triggering the import, could you update the task 
description with the dump files you used? (needed because we have to explicitly 
keep the corresponding partition in hdfs).
  
  Updated description as requested.

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

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

To: bking
Cc: RKemper, dcausse, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T347504: WDQS graph split: load data from dumps into new hosts

2023-11-07 Thread bking
bking updated the task description.

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

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

To: bking
Cc: RKemper, dcausse, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T349095: Migrate staging rdf-streaming-updater to flink operator

2023-11-06 Thread bking
bking added a comment.


  Current status:
  
  flink-operator is listening for rdf-streaming-updater
  rdf-streaming-updater job deploys, but it seems like it can't connect to 
kafka:
  
{"@timestamp":"2023-11-06T23:03:13.111Z","log.level": 
"INFO","message":"[AdminClient 
clientId=wcqs_streaming_updater_test:KafkaSource:eqiad.mediawiki.page-suppress-enumerator-admin-client]
 Disconnecting from node -1 due to socket connection setup timeout. The timeout 
value is 21318 ms.", "ecs.version": 
"1.2.0","process.thread.name":"kafka-admin-client-thread | 
wcqs_streaming_updater_test:KafkaSource:eqiad.mediawiki.page-suppress-enumerator-admin-client","log.logger":"org.apache.kafka.clients.NetworkClient"}
  
  Will pick up tomorrow.

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

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

To: bking
Cc: pfischer, EBernhardson, dcausse, BTullis, Aklapper, bking, 
Danny_Benjafield_WMDE, Isabelladantes1983, Themindcoder, Adamm71, Jersione, 
Hellket777, LisafBia6531, Astuthiodit_1, AWesterinen, 786, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, 
ItamarWMDE, Un1tY, Akuckartz, Hook696, Kent7301, joker88john, CucyNoiD, 
Nandana, Namenlos314, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, 
Bsandipan, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, Lewizho99, Maathavan, _jensen, rosalieper, Neuronton, Scott_WUaS, 
Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
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] T347504: WDQS graph split: load data from dumps into new hosts

2023-11-02 Thread bking
bking closed subtask T349011: Improve data-reload cookbook based on graph split 
needs as Resolved.

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

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

To: bking
Cc: RKemper, dcausse, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T347504: WDQS graph split: load data from dumps into new hosts

2023-10-31 Thread bking
bking added a comment.


  Progress report:
  `wdqs1022`: started reload 2023-10-24  UTC . Munging finished 2023-10-26 
0003 UTC. So far, we've processed 409/1104 munged files, which works out to 
~37% complete over a period of ~1 wk total, ~5 days if we don't count the 
munging step. Assuming nothing goes wrong, we should expect this to complete in 
~ 9 days.

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

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

To: bking
Cc: RKemper, dcausse, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T326409: Migrate the wdqs streaming updater flink jobs to flink-k8s-operator deployment model

2023-10-27 Thread bking
bking removed a subtask: T346456: Improve concurrency limits configuration of 
the wdqs updater.

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

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

To: bking
Cc: Gehel, BTullis, JMeybohm, gmodena, Ottomata, bking, Aklapper, dcausse, 
Danny_Benjafield_WMDE, Kappakayala, Astuthiodit_1, AWesterinen, Arnoldokoth, 
karapayneWMDE, Invadibot, maantietaja, wkandek, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, jijiki, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T346456: Improve concurrency limits configuration of the wdqs updater

2023-10-27 Thread bking
bking removed a parent task: T326409: Migrate the wdqs streaming updater flink 
jobs to flink-k8s-operator deployment model.

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

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

To: dcausse, bking
Cc: Aklapper, bking, Clement_Goubert, dcausse, Danny_Benjafield_WMDE, 
Isabelladantes1983, Themindcoder, Kappakayala, Adamm71, Jersione, Hellket777, 
LisafBia6531, Astuthiodit_1, AWesterinen, 786, Arnoldokoth, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, wkandek, JMeybohm, 
Alter-paule, Beast1978, ItamarWMDE, Un1tY, Akuckartz, Hook696, Kent7301, 
joker88john, CucyNoiD, Nandana, Namenlos314, jijiki, Gaboe420, Giuliamocci, 
Cpaulf30, Lahi, Gq86, Af420, Bsandipan, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Lewizho99, Maathavan, 
_jensen, rosalieper, Neuronton, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T346456: Improve concurrency limits configuration of the wdqs updater

2023-10-27 Thread bking
bking added a parent task: T326409: Migrate the wdqs streaming updater flink 
jobs to flink-k8s-operator deployment model.

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

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

To: dcausse, bking
Cc: Aklapper, bking, Clement_Goubert, dcausse, Danny_Benjafield_WMDE, 
Isabelladantes1983, Themindcoder, Kappakayala, Adamm71, Jersione, Hellket777, 
LisafBia6531, Astuthiodit_1, AWesterinen, 786, Arnoldokoth, Biggs657, 
karapayneWMDE, Invadibot, maantietaja, Juan90264, wkandek, JMeybohm, 
Alter-paule, Beast1978, ItamarWMDE, Un1tY, Akuckartz, Hook696, Kent7301, 
joker88john, CucyNoiD, Nandana, Namenlos314, jijiki, Gaboe420, Giuliamocci, 
Cpaulf30, Lahi, Gq86, Af420, Bsandipan, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Lewizho99, Maathavan, 
_jensen, rosalieper, Neuronton, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T326409: Migrate the wdqs streaming updater flink jobs to flink-k8s-operator deployment model

2023-10-27 Thread bking
bking added a subtask: T346456: Improve concurrency limits configuration of the 
wdqs updater.

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

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

To: bking
Cc: Gehel, BTullis, JMeybohm, gmodena, Ottomata, bking, Aklapper, dcausse, 
Danny_Benjafield_WMDE, Kappakayala, Astuthiodit_1, AWesterinen, Arnoldokoth, 
karapayneWMDE, Invadibot, maantietaja, wkandek, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, jijiki, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T347605: Document process for getting JNL files/consider automation

2023-10-24 Thread bking
bking triaged this task as "Low" priority.
bking closed this task as "Resolved".
bking added a comment.


  In T347605#9249978 <https://phabricator.wikimedia.org/T347605#9249978>, 
@dr0ptp4kt wrote:
  
  > @bking just wanted to express my gratitude for the support on this ticket 
and its friends T344905: Publish WDQS JNL files to dumps.wikimedia.org 
<https://phabricator.wikimedia.org/T344905> and T347647: 2023-09-18 
latest-all.ttl.gz WDQS dump `Fatal error munging RDF 
org.openrdf.rio.RDFParseException: Expected '.', found 'g'` 
<https://phabricator.wikimedia.org/T347647>. FWIW I do think it would be good 
to automate this. As a matter of getting to a functional WDQS local environment 
replete with BlazeGraph data, it would accelerate things a lot. I think my only 
reservations are that:
  
  
  
  > 1. It takes time to automate. Any rough guess on level of effort for that? 
I understand that'd inform relative prioritization against the large pile of 
other things.
  
  I appreciate your appreciation! I only wish I'd gotten something useful up in 
R2. For a truly reliable process, we'd need to implement @Addshore 's 
suggestions around "...checksum[ming] of the thing prior to all of the copying, 
and also a timestamp the thing was taken from."
  
  Unfortunately, because the initial process took a lot longer than expected 
and we have a lot of other things on our plate, this has been deprioritized for 
the time being. I'll try to work on it in my spare time, and we can revisit the 
discussion next quarter for sure. Sorry for the trouble!

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

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

To: bking
Cc: jochemla, Addshore, dr0ptp4kt, Aklapper, bking, Danny_Benjafield_WMDE, 
Astuthiodit_1, AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, 
ItamarWMDE, Akuckartz, Nandana, Namenlos314, Lahi, Gq86, 
Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T349147: Follow up on rdf-streaming-updater failure 2023-10-17

2023-10-23 Thread bking
bking closed this task as "Resolved".
bking moved this task from In Progress to Done on the Data-Platform-SRE board.
bking added a comment.


  Redeployed WCQS and WDQS jobs in eqiad and codfw envs:
  
INFO 2023-10-23T18:20:23+ [   root] Job WDQS Streaming Updater saved at 
s3://rdf-streaming-updater-eqiad/wikidata/savepoints/savepoint-58eeb7-bfbd904324d1
  INFO 2023-10-23T18:20:41+ [   root] Job WDQS Streaming Updater 
redeployed with id 224443f0230a92da72ed2685c72ae31b
INFO 2023-10-23T18:22:22+ [   root] Job WCQS Streaming Updater saved at 
s3://rdf-streaming-updater-eqiad/commons/savepoints/savepoint-acf5e9-6f13a4603e5d
INFO 2023-10-23T18:22:44+ [   root] Job WCQS Streaming Updater 
redeployed with id 7f68e99fba0fee14cedb5785a5bf7366

INFO 2023-10-23T18:36:06+ [   root] Job WDQS Streaming Updater saved at 
s3://rdf-streaming-updater-codfw/wikidata/savepoints/savepoint-b33dad-3de40d4dd970
INFO 2023-10-23T18:36:37+ [   root] Job WDQS Streaming Updater 
redeployed with id f62514bad9d4122b6183991be623fb4b
INFO 2023-10-23T18:40:24+ [   root] Job WCQS Streaming Updater saved at 
s3://rdf-streaming-updater-codfw/commons/savepoints/savepoint-df3b32-94b9b266ca05
INFO 2023-10-23T18:40:58+ [   root] Job WCQS Streaming Updater 
redeployed with id 4d8b66ac061a59e554db836331200471
  
  Based on the rdf-streaming-updater logs and producer lag metric, the deploys 
appear to be healthy. As such, I'm closing out this ticket. Feel free to reopen 
if we do need to take another look.

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/6524/

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

To: bking
Cc: dcausse, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T349147: Follow up on rdf-streaming-updater failure 2023-10-17

2023-10-20 Thread bking
bking added a subscriber: dcausse.
bking added a comment.


  Deployed `flink-1.16.1-rdf-0.3.136` release for WCQS and WDQS staging, via:
  
python3 flink/flink-job.py \
   --env staging \
   --job-name "WDQS Streaming Updater" \
   deploy \
   --jar 
lib/streaming-updater-producer-0.3.136-jar-with-dependencies.jar \
   --options-file flink/rdf-streaming-updater.yaml \
   --initial-state savepoint_20231020T1833/savepoint-136f27-ef9b47abb496
   
python3 flink/flink-job.py \
   --env staging \
   --job-name "WCQS Streaming Updater" \
   deploy \
   --jar 
lib/streaming-updater-producer-0.3.136-jar-with-dependencies.jar \
   --options-file flink/rdf-streaming-updater.yaml \
   --initial-state savepoint_20231020T1839/savepoint-3bb938-19b20ca910eb
  
  Will start on prod Monday if everything looks OK. @dcausse can you verify 
that staging is healthy if you get a chance?

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

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

To: bking
Cc: dcausse, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T347505: Prepare new WDQS hosts for graph splitting

2023-10-20 Thread bking
bking closed this task as "Resolved".
bking moved this task from In Progress to Done on the Data-Platform-SRE board.
bking added a comment.


  Work is complete...resolving.

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/6524/

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

To: bking
Cc: dr0ptp4kt, dcausse, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, 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] T337013: [Epic] Splitting the graph in WDQS

2023-10-20 Thread bking
bking closed subtask T347505: Prepare new WDQS hosts for graph splitting as 
Resolved.

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

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

To: bking
Cc: dr0ptp4kt, RKemper, bking, tfmorris, elal, karapayneWMDE, Aklapper, 
Lydia_Pintscher, me, Danny_Benjafield_WMDE, Astuthiodit_1, AWesterinen, 
BeautifulBold, Suran38, Invadibot, maantietaja, Peteosx1x, NavinRizwi, 
ItamarWMDE, Akuckartz, Nandana, Namenlos314, Lahi, Gq86, 
Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Dinoguy1000, Manybubbles, 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] T349095: Migrate staging rdf-streaming-updater to flink operator

2023-10-18 Thread bking
bking added a comment.


  
  
Create a savepoint by incrementing the nonce value in the 
helmfile.d/dse-k8s-services/values.yaml and deploy
Destroy the deployment on the dse-k8s cluster
  
  /srv/deployment-charts/helmfile.d/dse-k8s-services/rdf-streaming-updater/$ 
helmfile -e dse-k8s-eqiad -i destroy
  
Merge the change to delete the deployment from the dse-k8s cluster
Destroy the deployment on the staging cluster
  
  /srv/deployment-charts/helmfile.d/services/rdf-streaming-updater/$ helmfile 
-e staging -i destroy
  
  Clone the deployment-charts repo into homedir BEFORE merging the changes. 
That way, we can cleanly undeploy the production environments.
  
Merge the change to change the chart in use for the staging deployment, 
including:
the new savepoint location
the updated chart
the options for zookeeper-ha
TBD
Deploy the updated service to staging
  
  /srv/deployment-charts/helmfile.d/services/rdf-streaming-updater/$ helmfile 
-e staging -i apply --context=5

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

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

To: bking
Cc: pfischer, EBernhardson, dcausse, BTullis, Aklapper, bking, 
Danny_Benjafield_WMDE, Astuthiodit_1, AWesterinen, karapayneWMDE, Invadibot, 
maantietaja, ItamarWMDE, Akuckartz, Nandana, Namenlos314, Lahi, Gq86, 
Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T349147: Follow up on rdf-streaming-updater failure 2023-10-17

2023-10-17 Thread bking
bking created this task.
bking added projects: Wikidata-Query-Service, Data-Platform-SRE.
Restricted Application added a subscriber: Aklapper.

TASK DESCRIPTION
  We had a brief outage of the RDF streaming updater today. Users could have 
been impacted from about ~2022 - 2050 UTC. Specifically, they would have 
received stale results when querying hosts in eqiad.
  
  Creating this ticket to recap the incident and determine follow-up actions, 
if needed.

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

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

To: bking
Cc: Aklapper, bking, AWesterinen, BTullis, Namenlos314, Gq86, 
Lucas_Werkmeister_WMDE, EBjune, merbst, Jonas, Xmlizer, jkroll, Wikidata-bugs, 
Jdouglas, aude, Tobias1984, Manybubbles
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T349095: Migrate staging rdf-streaming-updater to flink operator

2023-10-17 Thread bking
bking added a comment.


  We could also deploy via a new namespace, but I wonder what implications that 
would have for our monitoring/tooling etc. Open to feedback/suggestions on this 
one.

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

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

To: bking
Cc: pfischer, EBernhardson, dcausse, BTullis, Aklapper, bking, 
Danny_Benjafield_WMDE, Astuthiodit_1, AWesterinen, karapayneWMDE, Invadibot, 
maantietaja, ItamarWMDE, Akuckartz, Nandana, Namenlos314, Lahi, Gq86, 
Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T326409: Migrate the wdqs streaming updater flink jobs to flink-k8s-operator deployment model

2023-10-17 Thread bking
bking added a subtask: T349095: Migrate staging rdf-streaming-updater to flink 
operator.

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

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

To: bking
Cc: Gehel, BTullis, JMeybohm, gmodena, Ottomata, bking, Aklapper, dcausse, 
Danny_Benjafield_WMDE, Kappakayala, Astuthiodit_1, AWesterinen, Arnoldokoth, 
karapayneWMDE, Invadibot, maantietaja, wkandek, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, jijiki, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
Mbch331, Clement_Goubert
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T349095: Migrate staging rdf-streaming-updater to flink operator

2023-10-17 Thread bking
bking added a parent task: T326409: Migrate the wdqs streaming updater flink 
jobs to flink-k8s-operator deployment model.

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

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

To: bking
Cc: Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, AWesterinen, 
BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, 
EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, 
jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 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] T349095: Migrate staging rdf-streaming-updater to flink operator

2023-10-17 Thread bking
bking created this task.
bking added projects: Wikidata-Query-Service, Data-Platform-SRE.
Restricted Application added a subscriber: Aklapper.

TASK DESCRIPTION
  We have tested the flink operator mode in dse-k8s 
<https://phabricator.wikimedia.org/T342149> . Our next step is to migrate the 
staging application to flink operator mode.
  
  Creating this ticket to:
  
  - Migrate the application
  - Confirm operation

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

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

To: bking
Cc: Aklapper, bking, AWesterinen, BTullis, Namenlos314, Gq86, 
Lucas_Werkmeister_WMDE, EBjune, merbst, Jonas, Xmlizer, jkroll, Wikidata-bugs, 
Jdouglas, aude, Tobias1984, Manybubbles
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T326409: Migrate the wdqs streaming updater flink jobs to flink-k8s-operator deployment model

2023-10-17 Thread bking
bking updated the task description.

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

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

To: bking
Cc: Gehel, BTullis, JMeybohm, gmodena, Ottomata, bking, Aklapper, dcausse, 
Danny_Benjafield_WMDE, Kappakayala, Astuthiodit_1, AWesterinen, Arnoldokoth, 
karapayneWMDE, Invadibot, maantietaja, wkandek, ItamarWMDE, Akuckartz, Nandana, 
Namenlos314, jijiki, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, 
Mbch331, Clement_Goubert
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


[Wikidata-bugs] [Maniphest] T347504: WDQS graph split: load data from dumps into new hosts

2023-10-16 Thread bking
bking added a comment.


  Apologies for not catching this earlier:
  
  - to be aligned with the dumps that are imported into hdfs we must select a 
particular set of files, when selecting a "-all" file the preceding "lexemes" 
one must be taken, e.g. if wikidata-20230925-all-BETA.ttl.bz2 is taken 
wikidata-20230922-lexemes-BETA.ttl.bz2 must be taken.
  
  This will require a change to the cookbook; I've created T349011 
<https://phabricator.wikimedia.org/T349011> for this purpose.

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

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

To: bking
Cc: RKemper, dcausse, Aklapper, bking, Danny_Benjafield_WMDE, Astuthiodit_1, 
AWesterinen, BTullis, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org


  1   2   3   4   >