[10:48:46] <arturo>	 !log toolsbeta deploying https://gitlab.wikimedia.org/repos/cloud/toolforge/buildservice/-/merge_requests/6 on toolsbeta
[10:48:48] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolsbeta/SAL
[14:34:06] <arturo>	 !log toolsbeta deploying https://gitlab.wikimedia.org/repos/cloud/toolforge/buildservice/-/merge_requests/6 again with newer image (T342338, T321188)
[14:34:11] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolsbeta/SAL
[14:34:11] <stashbot>	 T342338: toolforge docker registry: unable to pull docker-registry.tools.wmflabs.org/toolforge-distroless-base:latest - https://phabricator.wikimedia.org/T342338
[14:34:12] <stashbot>	 T321188: [tbs] fix/improve the updating of the buildpack/tekton images in the local repo - https://phabricator.wikimedia.org/T321188
[15:19:41] <arturo>	 !log tools deploying https://gitlab.wikimedia.org/repos/cloud/toolforge/buildservice/-/merge_requests/6 again with newer image (T342338, T321188)
[15:19:46] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL
[15:19:46] <stashbot>	 T342338: toolforge docker registry: unable to pull docker-registry.tools.wmflabs.org/toolforge-distroless-base:latest - https://phabricator.wikimedia.org/T342338
[15:19:47] <stashbot>	 T321188: [tbs] fix/improve the updating of the buildpack/tekton images in the local repo - https://phabricator.wikimedia.org/T321188
[18:47:36] <Cumulonimbus>	 Hi. I have a question about the wiki-replicas/mariadb. If I do an explain query on "recentchanges" and join "actor", i also see a bunch of rows with "dependent subquery". what are these and where do they come from?
[18:51:08] <taavi>	 Cumulonimbus: do you have a specific example I could look at?
[18:54:57] <Cumulonimbus>	 https://paste.toolforge.org/view/ddf1edb8
[18:59:56] <taavi>	 those are the queries used to retract private data from the replicas. for example, rows in the actor view are only shown when they're visible in some other publicly available column
[18:59:57] <taavi>	 https://wikitech.wikimedia.org/wiki/News/Actor_storage_changes_on_the_Wiki_Replicas
[19:09:06] <Cumulonimbus>	 So the actor table is a computed table then?
[19:14:20] <taavi>	 in general, all of the wiki replicas tables have some sort of filtering that ensures only data that's publicly available via other means is exposed
[19:16:33] <Cumulonimbus>	 Thanks for your help.
[19:26:47] <wm-bb>	 <lucaswerkmeister> Cumulonimbus: you can use actor_recentchanges instead of actor to get a view that’s only filtered by recentchanges, not archive and ipblocks and so on
[19:26:49] <wm-bb>	 <lucaswerkmeister> see https://wikitech.wikimedia.org/wiki/News/Actor_storage_changes_on_the_Wiki_Replicas#The_actor_table_seems_really_slow--so_does_comment
[19:32:16] <Cumulonimbus>	 Thanks for tip. I am currently learning about performance.
[19:35:01] <wm-bb>	 <lucaswerkmeister> you can also try pasting your query into https://sql-optimizer.toolforge.org/ and see if it has any useful tips
[20:50:23] <hexmode[m]>	 Does wmcs provide an endpoint I can point kubectl to?  Should I search for an answer before I ask that question?
[21:48:29] <bd808>	 hexmode[m]: are you asking if you can use kubectl from outside the Toolforge project? I think the answer to that today is no, but taavi would probably know better.
[21:50:21] <bd808>	 We have fairly new support for using terraform with Cloud VPS projects (<https://wikitech.wikimedia.org/wiki/Help:Using_Terraform_on_Cloud_VPS>), but I don't think we have had a reason to expose the Toolforge kubernetes cluster API to the internet.
[22:15:22] <hexmode[m]>	 bd808: thanks for the info.  I am mostly curious at this point, but you gave me a useful datapoint.
[22:45:14] <wikibugs>	 !log tools.wikibugs Updated channels.yaml to: 39a3afa7267b01d24970a552aa5f575298b206b1 Add #mediawiki-core-bots
[22:45:18] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.wikibugs/SAL