Maniphest T199316

"sql wikishared" doesn't work on mwmaint1001
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Amire80
	Jul 11 2018, 11:38 AM

Description

On terbium I periodically ran queries on the wikishared database, using sql wikishared. Now on mwmaint1001, if I try to run this command, I get:

amire80@mwmaint1001:~/home-terbium/cxscriptsg$ sql wikishared
Error: unable to get reader index

If I try with the --wiki option, I get the following:

amire80@mwmaint1001:~/home-terbium/cxscriptsg$ sql --wiki=wikishared
no version entry for `wikishared`.
[Wed Jul 11 11:36:18 2018] [hphp] [6208:7f7981c563c0:0:000001] [] 
Fatal error: no version entry for `wikishared`.
 in /srv/mediawiki/multiversion/MWMultiVersion.php on line 380

Not sure if it's because of the re-implementation of the sql command itself or because of the migration from terbium to mwmaint1001. Probably the former.

(Sorry about the overtagging—I wasn't sure where to put it.)

Details

	Subject	Repo	Branch	Lines +/-
	Make "sql wikishared" work again	operations/puppet	production	+7 -0

Customize query in gerrit

Event Timeline

Amire80 created this task.Jul 11 2018, 11:38 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 11 2018, 11:38 AM

jcrespo edited projects, added MediaWiki-Platform-Team-Archived; removed SRE, DBA.Jul 11 2018, 11:46 AM

jcrespo added a subscriber: Anomie.

The new way to access that be something like sql wikishared --cluster=extension1. The old sql script had a special case doing the equivalent for "wikishared" (and only "wikishared").

A similar special case could be added to the new wrapper script if needed. That case might look like

wikishared)
    # Back compat access to 'wikishared' on the extension1 cluster.
    exec mwscript mysql.php --wiki=metawiki --wikidb=wikishared --cluster=extension1 "$@"
    ;;

Thanks. This helps as a workaround, but would be nice to fix fully.

CCicalese_WMF edited projects, added Core-Platform-Team-Old; removed MediaWiki-Platform-Team-Archived.Jul 12 2018, 1:02 AM

tstarling moved this task from Inbox to Backlog on the Core-Platform-Team-Old board.Jul 17 2018, 1:53 AM

Change 446530 had a related patch set uploaded (by Tim Starling; owner: Tim Starling):
[operations/puppet@production] Make "sql wikishared" work again

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

gerritbot added a project: Patch-For-Review.Jul 18 2018, 6:04 AM

Change 446530 merged by Tim Starling:
[operations/puppet@production] Make "sql wikishared" work again

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

tstarling closed this task as Resolved.Jul 19 2018, 6:28 AM

tstarling claimed this task.

Thanks, @tstarling!

CCicalese_WMF moved this task from Backlog to CPT-Q1-Jul-Sep-2018 on the Core-Platform-Team-Old board.Aug 6 2018, 10:44 PM

CCicalese_WMF edited projects, added Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018); removed Core-Platform-Team-Old.

CCicalese_WMF moved this task from Backlog to Closed on the Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018) board.

Aklapper removed a subscriber: Anomie.Oct 16 2020, 5:38 PM

Maintenance_bot removed a project: Patch-For-Review.Oct 16 2020, 6:18 PM