Page MenuHomePhabricator

meta_p.wiki and meta_p.legacy tables not filled on all servers
Closed, ResolvedPublic

Description

On the database replica servers, the meta_p.wiki and meta_p.legacy tables only contain one entry - for centralauth - on s1.labsdb through s5.labsdb. They are OK on s6.labsdb and s7.labsdb.

This breaks two of my tools, which I have fixed by using s6.labsdb for now, but I assume there are many other tools on Tool Labs that rely on these tables.


Version: unspecified
Severity: major

Details

Reference
bz70893

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:46 AM
bzimport set Reference to bz70893.
bzimport added a subscriber: Unknown Object (MLST).
Krenair subscribed.
krenair@tools-bastion-01:~$ mysql --defaults-file=~/replica.my.cnf -h labsdb1001.eqiad.wmnet meta_p -s
MariaDB [meta_p]> select count(*) from wiki;
count(*)
858
MariaDB [meta_p]> exit;
krenair@tools-bastion-01:~$ mysql --defaults-file=~/replica.my.cnf -h labsdb1002.eqiad.wmnet meta_p -s
MariaDB [meta_p]> select count(*) from wiki;
count(*)
858
MariaDB [meta_p]> exit;
krenair@tools-bastion-01:~$ mysql --defaults-file=~/replica.my.cnf -h labsdb1003.eqiad.wmnet meta_p -s
MariaDB [meta_p]> select count(*) from wiki;
count(*)
858
MariaDB [meta_p]> exit;

So they all seem fine. I think this was likely resolved months ago.

Krenair claimed this task.
Krenair removed Krenair as the assignee of this task.
Krenair set Security to None.