Page MenuHomePhabricator

Table 'centralauth_p.globalblocks' doesn't exist
Closed, ResolvedPublic

Description

I went to use (example IP) https://tools.wmflabs.org/meta/stalktoy/12.34.56.00 and found:

Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centralauth_p.globalblocks' doesn't exist

I checked with my labs user:

tools.maurelio@tools-sgebastion-07:~$ sql centralauth;
MariaDB [centralauth_p]> show tables;
+---------------------------+
| Tables_in_centralauth_p   |
+---------------------------+
| global_group_permissions  |
| global_group_restrictions |
| global_preferences        |
| global_user_groups        |
| globaluser                |
| localuser                 |
| renameuser_status         |
| wikiset                   |
+---------------------------+
8 rows in set (0.00 sec)

Is the globalblocks table now living elsewhere outside the centralauth_p database or is not being suddenly avalaible over there a mistake? centralauth_p.globalblocks shouldn't have any nonpublic information and I've been querying it last week. I've looked at metawiki_p and meta_p but didn't found any table called globalblocks so I'm not sure what has happened with it.

Event Timeline

It's not immediately obvious to me how to remove that table on all but one database -- if someone can suggest an alternative patch to https://gerrit.wikimedia.org/r/#/c/operations/puppet/+/550888/ then I'll do what I can to get it applied.

Change 551577 had a related patch set uploaded (by Andrew Bogott; owner: Andrew Bogott):
[operations/puppet@production] Depool labsdb1009

https://gerrit.wikimedia.org/r/551577

Change 551579 had a related patch set uploaded (by Andrew Bogott; owner: Andrew Bogott):
[operations/puppet@production] Revert "Depool labsdb1009"

https://gerrit.wikimedia.org/r/551579

Change 551577 merged by Andrew Bogott:
[operations/puppet@production] Depool labsdb1009

https://gerrit.wikimedia.org/r/551577

Mentioned in SAL (#wikimedia-cloud) [2019-11-18T17:46:35Z] <andrewbogott> running maintain-views --all-databases --replace-all —clean on labsdb1009 T238480

Change 551579 merged by Andrew Bogott:
[operations/puppet@production] Revert "Depool labsdb1009"

https://gerrit.wikimedia.org/r/551579

Mentioned in SAL (#wikimedia-cloud) [2019-11-18T18:19:03Z] <andrewbogott> running maintain-views --all-databases --replace-all —clean on labsdb1010 T238480

Mentioned in SAL (#wikimedia-cloud) [2019-11-18T18:42:26Z] <andrewbogott> repooled labsdb1009 and 1010 T238480

Mentioned in SAL (#wikimedia-cloud) [2019-11-18T18:44:05Z] <andrewbogott> depooling labsdb1011 and killing remaining user queries T238480

Mentioned in SAL (#wikimedia-cloud) [2019-11-18T18:54:43Z] <andrewbogott> running maintain-views --all-databases --replace-all —clean on labsdb1011 T238480

I'm pretty sure this is now resolved. Let me know if not!