Page MenuHomePhabricator

"links" MariaDB database view is broken on Wikimedia Labs
Closed, ResolvedPublic

Description

From bug 52928 comment 1:

Therefore I've renamed it to "links_old" for now, to be dropped after a
suitable cooling-off period.

Consequently, we're now seeing this error:


MariaDB [enwiki_p]> select * from links limit 1;

ERROR 1356 (HY000): View 'enwiki_p.links' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

The "links" view should be updated.

(Are the views in Puppet?)


Version: unspecified
Severity: normal
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=52928

Details

Reference
bz53640

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:10 AM
bzimport added a project: Toolforge.
bzimport set Reference to bz53640.

(Are the views in Puppet?)

Yes and no; the scripts that maintains them is in git at:

https://git.wikimedia.org/blob/operations%2Fsoftware/71f53cb204f53dba2fe3a30567aee659711cb8cf/maintain-replicas%2Fmaintain-replicas.pl

(views should be updated)

Given that the table is on its way to crossing the Styx, it's not clear to me whether it is worth it to create a links_old view or just eliminate links entirely.

All views were updated and, given that the data is redundant, no views to the obsolede links_old will be made.