Last modified: 2013-10-10 17:03:29 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T55640, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 53640 - "links" MariaDB database view is broken on Wikimedia Labs
"links" MariaDB database view is broken on Wikimedia Labs
Status: RESOLVED FIXED
Product: Wikimedia Labs
Classification: Unclassified
tools (Other open bugs)
unspecified
All All
: Unprioritized normal
: ---
Assigned To: Marc A. Pelletier
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-09-01 02:26 UTC by MZMcBride
Modified: 2013-10-10 17:03 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description MZMcBride 2013-09-01 02:26:04 UTC
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?)
Comment 1 Marc A. Pelletier 2013-09-01 02:43:14 UTC
(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.
Comment 2 Marc A. Pelletier 2013-10-10 17:03:29 UTC
All views were updated and, given that the data is redundant, no views to the obsolede links_old will be made.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links