Page MenuHomePhabricator

rook (Vivian Rook)
User

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Friday

  • Clear sailing ahead.

User Details

User Since
Jun 7 2021, 2:32 AM (159 w, 2 d)
Availability
Available
LDAP User
Vivian Rook
MediaWiki User
VRook (WMF) [ Global Accounts ]

Recent Activity

Sun, Jun 23

rook closed T368216: New upstream release for Pywikibot as Resolved.
Sun, Jun 23, 12:39 PM · PAWS

Thu, Jun 20

rook closed T368076: update to g4 flavor as Resolved.
Thu, Jun 20, 3:59 PM · superset.wmcloud.org
rook closed T368060: update tf-infra-test to g4 as Resolved.
Thu, Jun 20, 3:48 PM · Cloud-VPS
rook created T368076: update to g4 flavor.
Thu, Jun 20, 3:28 PM · superset.wmcloud.org
rook closed T361606: Remove superset-123-4 cluster as Resolved.
Thu, Jun 20, 3:28 PM · superset.wmcloud.org
rook closed T367945: superset.wmcloud.org down, a subtask of T367939: All TestSupersetWithAuth.test_login_and_oauth_permisson of superset_tests fails with ConnectionError, as Resolved.
Thu, Jun 20, 3:28 PM · Upstream, Pywikibot-tests, Pywikibot
rook closed T367945: superset.wmcloud.org down as Resolved.
Thu, Jun 20, 3:28 PM · superset.wmcloud.org
rook created T368060: update tf-infra-test to g4.
Thu, Jun 20, 2:45 PM · Cloud-VPS

Wed, Jun 19

rook added a comment to T367945: superset.wmcloud.org down.

Ok, it's back online on version 3.1.1 with a restored db from June 18.

Wed, Jun 19, 5:00 PM · superset.wmcloud.org
rook closed T367983: update superset to 4.0.1 as Declined.
Wed, Jun 19, 4:59 PM · superset.wmcloud.org
rook updated subscribers of T367945: superset.wmcloud.org down.
Wed, Jun 19, 3:15 PM · superset.wmcloud.org
rook added a comment to T367945: superset.wmcloud.org down.

This went down as part of a shift to g4 vm flavors. It's back, but it looks like 4.0.0 was deployed, so the query history doesn't work. I'm unsure if that will cause other problems, and we may have to wipe everything and reload fresh. There are more details in T364022 about the query history.

Wed, Jun 19, 3:15 PM · superset.wmcloud.org
rook created T367983: update superset to 4.0.1.
Wed, Jun 19, 2:51 PM · superset.wmcloud.org

Tue, Jun 18

rook closed T367630: github action building main rather than branch as Resolved.
Tue, Jun 18, 5:00 PM · Quarry

Sat, Jun 15

rook created T367630: github action building main rather than branch.
Sat, Jun 15, 10:47 AM · Quarry

Thu, Jun 13

rook closed T367337: jupyterlab to 4.2.2 as Resolved.
Thu, Jun 13, 2:20 PM · PAWS
rook closed T366055: Update images as Resolved.
Thu, Jun 13, 2:19 PM · PAWS

Wed, Jun 12

rook created T367337: jupyterlab to 4.2.2.
Wed, Jun 12, 4:31 PM · PAWS

Tue, Jun 11

rook closed T366058: update singleuser to 24.04 as Resolved.
Tue, Jun 11, 6:46 PM · PAWS
rook closed T366058: update singleuser to 24.04, a subtask of T366055: Update images, as Resolved.
Tue, Jun 11, 6:45 PM · PAWS

Thu, Jun 6

rook added a comment to T366058: update singleuser to 24.04.

Installing as root seems to get R working, and seems to still allow package install. Though bash kernel does not seem to work, pip shows it as installed, but the link does not appear in jupyterlab

Thu, Jun 6, 4:12 PM · PAWS
rook added a comment to T363917: paws not connecting to any reconciliation services.

https://github.com/OpenRefine/CommonsExtension/issues/101 is closed and seems to fix the issue. When a new release is made we can try this with an updated plugin.

Thu, Jun 6, 12:09 PM · PAWS

Fri, May 31

rook closed T366226: New upstream release for Pywikibot as Resolved.
Fri, May 31, 7:43 PM · PAWS
rook added a comment to T366244: Increase Object Storage quota for QRank.

+1

Fri, May 31, 5:22 PM · Cloud-VPS (Quota-requests)
rook added a comment to T366058: update singleuser to 24.04.

Rstudio is installing, but not R notebook/console

Fri, May 31, 12:37 PM · PAWS

Thu, May 30

rook added a comment to T365822: TfInfraTest project.

Changing project name to lowercase only.

root@cloudcontrol1005:~# openstack project delete TfInfraTest
root@cloudcontrol1005:~# openstack project create --description 'tofu infra tests' tofuinfratest --domain default
+-------------+------------------+
| Field       | Value            |
+-------------+------------------+
| description | tofu infra tests |
| domain_id   | default          |
| enabled     | True             |
| id          | tofuinfratest    |
| is_domain   | False            |
| name        | tofuinfratest    |
| options     | {}               |
| parent_id   | default          |
| tags        | []               |
+-------------+------------------+
root@cloudcontrol1005:~# openstack role add --project tofuinfratest --user rook member
root@cloudcontrol1005:~# openstack role add --project tofuinfratest --user rook reader
Thu, May 30, 4:15 PM · Cloud-VPS (Project-requests)
rook added a comment to T365725: Update chart version on PR?.

changes in T366121 seem to have mostly resolved this. Further discovery in T366183

Thu, May 30, 3:52 PM · PAWS
rook closed T365725: Update chart version on PR? as Resolved.
Thu, May 30, 3:52 PM · PAWS
rook closed T366121: ingress-nginx and prometheus not idempotent as Resolved.
Thu, May 30, 3:50 PM · PAWS
rook added a comment to T366121: ingress-nginx and prometheus not idempotent.

https://github.com/toolforge/paws/pull/429 seems to work

Thu, May 30, 3:40 PM · PAWS

Wed, May 29

rook added a comment to T366183: jupyterhub helm deploy show changed in ansible.

I agree, that the checksums and secrets could be stored as annotations. Though the image puller job would be more difficult to manage in a similar fashion. And in this case, the thing being deployed is the main part of the project, so not reporting changes isn't ideal. Leaving it as always showing changed, may be the better option.

Wed, May 29, 4:27 PM · PAWS
rook added a comment to T366121: ingress-nginx and prometheus not idempotent.

https://github.com/ansible-collections/kubernetes.core/issues/732

Wed, May 29, 3:59 PM · PAWS
rook created T366183: jupyterhub helm deploy show changed in ansible.
Wed, May 29, 2:10 PM · PAWS
rook created T366182: update prometheus.
Wed, May 29, 2:08 PM · PAWS
rook added a comment to T366121: ingress-nginx and prometheus not idempotent.

This appears to be the same issue with prometheus. Removing:

set_values:
  - value: prometheus.retention=30d
    value_type: string

gets it working as expected.

Wed, May 29, 1:12 PM · PAWS
rook merged task T366122: prometheus not idempotent into T366121: ingress-nginx and prometheus not idempotent.
Wed, May 29, 1:11 PM · PAWS
rook renamed T366121: ingress-nginx and prometheus not idempotent from ingress-nginx not idempotent to ingress-nginx and prometheus not idempotent.
Wed, May 29, 1:11 PM · PAWS
rook merged T366122: prometheus not idempotent into T366121: ingress-nginx and prometheus not idempotent.
Wed, May 29, 1:10 PM · PAWS
rook added a comment to T366121: ingress-nginx and prometheus not idempotent.

This would appear to be a limitation of the helm ansible module. It seems to be seeing the set_values as a difference:

set_values:
  - value: controller.service.type=NodePort
    value_type: string
  - value: controller.service.enableHttps=false
    value_type: string
  - value: controller.service.nodePorts.http=30001
    value_type: string
  - value: controller.config.proxy-body-size=4m
    value_type: string
  - value: controller.config.allow-snippet-annotations=true
    value_type: string

Regardless of if they were already applied. Removing them makes the process deploy without changes, but of course also causes it to not work.

Wed, May 29, 1:05 PM · PAWS
rook closed T366163: ansible to version 9.6.0 as Resolved.
Wed, May 29, 11:31 AM · PAWS
rook created T366163: ansible to version 9.6.0.
Wed, May 29, 11:24 AM · PAWS

Tue, May 28

rook created T366124: periodic error from tofu when state in object storage.
Tue, May 28, 9:53 PM · Cloud-VPS, PAWS
rook created T366122: prometheus not idempotent.
Tue, May 28, 9:29 PM · PAWS
rook updated the task description for T366121: ingress-nginx and prometheus not idempotent.
Tue, May 28, 9:28 PM · PAWS
rook created T366121: ingress-nginx and prometheus not idempotent.
Tue, May 28, 9:27 PM · PAWS
rook closed T366112: tox, a subtask of T366107: move testing off blubberoid, as Resolved.
Tue, May 28, 7:39 PM · Quarry
rook closed T366112: tox as Resolved.
Tue, May 28, 7:39 PM · Quarry
rook closed T366107: move testing off blubberoid as Resolved.
Tue, May 28, 7:39 PM · Quarry
rook created T366112: tox.
Tue, May 28, 7:21 PM · Quarry
rook closed T366109: tox as Resolved.
Tue, May 28, 7:15 PM · PAWS
rook closed T366109: tox, a subtask of T366055: Update images, as Resolved.
Tue, May 28, 7:14 PM · PAWS
rook closed T366110: helm-lint image as Resolved.
Tue, May 28, 7:10 PM · PAWS
rook closed T366110: helm-lint image, a subtask of T366055: Update images, as Resolved.
Tue, May 28, 7:10 PM · PAWS
rook created T366110: helm-lint image.
Tue, May 28, 7:04 PM · PAWS
rook created T366109: tox.
Tue, May 28, 7:03 PM · PAWS
rook closed T366090: Investigate adding quarto as Resolved.
Tue, May 28, 7:01 PM · PAWS
rook added a comment to T366090: Investigate adding quarto.

Seems to work. Generated:
https://public-paws.wmcloud.org/User:VRook_(WMF)/quarto.html
with quarto render quarto.ipynb --to html

Tue, May 28, 7:00 PM · PAWS
rook created T366107: move testing off blubberoid.
Tue, May 28, 6:57 PM · Quarry
rook closed T366064: jobber image to alpine 3.20.0, a subtask of T366055: Update images, as Resolved.
Tue, May 28, 6:16 PM · PAWS
rook closed T366064: jobber image to alpine 3.20.0 as Resolved.
Tue, May 28, 6:16 PM · PAWS
rook closed T366056: nbserve to 24.04 as Resolved.
Tue, May 28, 5:38 PM · PAWS
rook closed T366056: nbserve to 24.04, a subtask of T366055: Update images, as Resolved.
Tue, May 28, 5:37 PM · PAWS
rook closed T366057: update renderer to 24.04 as Resolved.
Tue, May 28, 5:20 PM · PAWS
rook closed T366057: update renderer to 24.04, a subtask of T366055: Update images, as Resolved.
Tue, May 28, 5:20 PM · PAWS
rook closed T366063: minesweeper image to alpine 3.20.0 as Resolved.
Tue, May 28, 5:20 PM · PAWS
rook closed T366063: minesweeper image to alpine 3.20.0, a subtask of T366055: Update images, as Resolved.
Tue, May 28, 5:19 PM · PAWS
rook created T366090: Investigate adding quarto.
Tue, May 28, 4:22 PM · PAWS
rook renamed T366055: Update images from Update images to 24.04 to Update images.
Tue, May 28, 12:57 PM · PAWS
rook created T366064: jobber image to alpine 3.20.0.
Tue, May 28, 12:54 PM · PAWS
rook created T366063: minesweeper image to alpine 3.20.0.
Tue, May 28, 12:54 PM · PAWS
rook created T366058: update singleuser to 24.04.
Tue, May 28, 12:09 PM · PAWS
rook created T366057: update renderer to 24.04.
Tue, May 28, 12:08 PM · PAWS
rook created T366056: nbserve to 24.04.
Tue, May 28, 12:08 PM · PAWS
rook created T366055: Update images.
Tue, May 28, 12:07 PM · PAWS

May 24 2024

rook added a comment to T365830: move project to TfInfraTest.

I keep getting kicked off ssh mid tofu test. Though it seems to mostly be working. I'll leave it off for the weekend and test it more in the week.

May 24 2024, 9:18 PM · Cloud-VPS
rook created T365830: move project to TfInfraTest.
May 24 2024, 3:15 PM · Cloud-VPS
rook closed T365822: TfInfraTest project as Resolved.
May 24 2024, 2:51 PM · Cloud-VPS (Project-requests)
rook closed T365822: TfInfraTest project, a subtask of T365820: object store for tf-infra-test, as Resolved.
May 24 2024, 2:50 PM · Cloud-VPS
rook added a comment to T365822: TfInfraTest project.
root@cloudcontrol1005:~# openstack project create --description 'TfInfraTest' TfInfraTest --domain default
+-------------+-------------+
| Field       | Value       |
+-------------+-------------+
| description | TfInfraTest |
| domain_id   | default     |
| enabled     | True        |
| id          | TfInfraTest |
| is_domain   | False       |
| name        | TfInfraTest |
| options     | {}          |
| parent_id   | default     |
| tags        | []          |
+-------------+-------------+
root@cloudcontrol1005:~# openstack role add --project TfInfraTest --user rook member
root@cloudcontrol1005:~# openstack role add --project TfInfraTest --user rook reader
May 24 2024, 2:50 PM · Cloud-VPS (Project-requests)
rook added a parent task for T365822: TfInfraTest project: T365820: object store for tf-infra-test.
May 24 2024, 2:24 PM · Cloud-VPS (Project-requests)
rook added a subtask for T365820: object store for tf-infra-test: T365822: TfInfraTest project.
May 24 2024, 2:24 PM · Cloud-VPS
rook created T365822: TfInfraTest project.
May 24 2024, 2:24 PM · Cloud-VPS (Project-requests)
rook updated the task description for T365820: object store for tf-infra-test.
May 24 2024, 1:55 PM · Cloud-VPS
rook created T365820: object store for tf-infra-test.
May 24 2024, 1:50 PM · Cloud-VPS

May 23 2024

rook closed T365719: jupyterlab to 4.2.1 as Resolved.
May 23 2024, 3:43 PM · PAWS
rook created T365725: Update chart version on PR?.
May 23 2024, 3:22 PM · PAWS
rook created T365719: jupyterlab to 4.2.1.
May 23 2024, 2:34 PM · PAWS

May 22 2024

rook merged T365539: New upstream release for OpenRefine into T363732: update openrefine.
May 22 2024, 4:27 PM · PAWS
rook merged task T365539: New upstream release for OpenRefine into T363732: update openrefine.
May 22 2024, 4:27 PM · PAWS
rook updated the task description for T363732: update openrefine.
May 22 2024, 4:27 PM · PAWS
rook closed T365590: move prometheus later in deploy as Resolved.
May 22 2024, 2:20 PM · PAWS
rook created T365590: move prometheus later in deploy.
May 22 2024, 1:18 PM · PAWS

May 21 2024

rook closed T362213: Error 500 when clicking "stop query" as Resolved.
May 21 2024, 5:00 PM · Quarry
rook closed T365496: quarry down as Resolved.
May 21 2024, 3:52 PM · Quarry
rook added a comment to T365496: quarry down.

Restarting the services seems to have things connecting again.
kubectl rollout restart deployment.apps/redis deployment.apps/web deployment.apps/worker

May 21 2024, 3:52 PM · Quarry
rook added a comment to T365496: quarry down.

Still appears to be down. Web page is loading, but queries are giving:
Access denied for user 'quarry'@'172.16.2.72' (using password: NO)

May 21 2024, 3:50 PM · Quarry
rook reopened T365496: quarry down as "Open".
May 21 2024, 3:49 PM · Quarry
rook updated subscribers of T365496: quarry down.

@fnegri fixed it

May 21 2024, 3:31 PM · Quarry
rook closed T365496: quarry down as Resolved.
May 21 2024, 3:30 PM · Quarry
rook added a comment to T365496: quarry down.

Looks like none of the web pods are running. Logs give

[2024-05-21 15:28:04 +0000] [11] [ERROR] Error handling request /
Traceback (most recent call last):
  File "/usr/local/lib/python3.7/site-packages/gunicorn/workers/sync.py", line 135, in handle
    self.handle_request(listener, req, client, addr)
  File "/usr/local/lib/python3.7/site-packages/gunicorn/workers/sync.py", line 178, in handle_request
    respiter = self.wsgi(environ, resp.start_response)
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2464, in __call__
    return self.wsgi_app(environ, start_response)
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2450, in wsgi_app
    response = self.handle_exception(e)
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1867, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise
    raise value
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise
    raise value
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/app/quarry/web/app.py", line 82, in index
    stats_count_users=global_conn.session.query(User).count(),
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3091, in count
    return self._from_self(col).enable_eagerloads(False).scalar()
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2832, in scalar
    ret = self.one()
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2809, in one
    return self._iter().one()
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2850, in _iter
    execution_options={"_sa_orm_load_options": self.load_options},
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1689, in execute
    result = conn._execute_20(statement, params or {}, execution_options)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1583, in _execute_20
    return meth(self, args_10style, kwargs_10style, execution_options)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 324, in _execute_on_connection
    self, multiparams, params, execution_options
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1462, in _execute_clauseelement
    cache_hit=cache_hit,
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1669, in _execute_context
    conn = self._revalidate_connection()
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 560, in _revalidate_connection
    self._invalid_transaction()
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 540, in _invalid_transaction
    code="8s2b",
sqlalchemy.exc.PendingRollbackError: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
May 21 2024, 3:29 PM · Quarry