Page MenuHomePhabricator

Toolviews table (s53734__toolviews_p) not updated since 2025-10-22
Closed, ResolvedPublicBUG REPORT

Description

$ ssh dev.toolforge.org
$ become toolviews
$ sql tools
Your MariaDB connection id is 480962265
Server version: 10.6.22-MariaDB-log MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use s53734__toolviews_p;
MariaDB [s53734__toolviews_p]> select max(request_day) from daily_raw_views;
+------------------+
| max(request_day) |
+------------------+
| 2025-10-22       |
+------------------+
1 row in set (0.003 sec)

This is suspiciously the same date that T284558: Pull toolviews data from Kubernetes HAProxy or ingress-nginx instead of the front nginx was resolved.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
bd808 renamed this task from s53734__toolviews_p not updated since 2025-10-22 to Toolviews table (s53734__toolviews_p) not updated since 2025-10-22.Oct 27 2025, 10:02 PM
taavi triaged this task as High priority.

Hmh, I should have checked this after making the change. Anyway, it seems like the issue is a Hiera issue somewhere:

taavi@tools-k8s-haproxy-8:~$ sudo cat /etc/toolviews.yaml  | head -n 3
mysql_host: localhost
mysql_db: example_db
mysql_user: example_user

Mentioned in SAL (#wikimedia-cloud) [2025-10-27T22:09:23Z] <taavi> copy toolviews database hiera data to a place where haproxy nodes can see them T408454

Tracking further improvements in T408457.