Foreign database (ForeignDBRepo, LoadBalancer) conflicts with $wgSharedDB / $wgSharedTables
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	liangent
	May 25 2013, 9:18 PM

Description

Env:

Primary database: wikidb
Shared database: shareddb
Shared table: page
ForeignDBRepo database: filedb

Issue:

In ForeignDBRepo, it sends a query:

SELECT page_id FROM shareddb.page WHERE page_namespace = '6' AND page_title = 'filename' LIMIT 1

Expected:

SELECT page_id FROM filedb.page WHERE page_namespace = '6' AND page_title = 'filename' LIMIT 1

Version: 1.22.0
Severity: normal

• bzimport raised the priority of this task from to High.Nov 22 2014, 1:31 AM

• bzimport set Reference to bz48819.

• bzimport added a subscriber: Unknown Object (MLST).

Related URL: https://gerrit.wikimedia.org/r/65489 (Gerrit Change I45db6860d0a4b4480e0b93aa7e750f096424e40f)

Also in LoadBalancer::openForeignConnection()

Change 65489 merged by jenkins-bot:
Never prefix table names with $wgSharedDB when used in foreign DB

Marking as resolved fix since patch merged.

• Gilles raised the priority of this task from High to Unbreak Now!.Dec 4 2014, 10:21 AM

• Gilles moved this task from Untriaged to Done on the Multimedia board.

• Gilles lowered the priority of this task from Unbreak Now! to High.Dec 4 2014, 11:22 AM