Last modified: 2013-08-22 21:47:44 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 T50819, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 48819 - Foreign database (ForeignDBRepo, LoadBalancer) conflicts with $wgSharedDB / $wgSharedTables
Foreign database (ForeignDBRepo, LoadBalancer) conflicts with $wgSharedDB / $...
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
File management (Other open bugs)
1.22.0
All All
: High normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-05-25 21:18 UTC by Liangent
Modified: 2013-08-22 21:47 UTC (History)
2 users (show)

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


Attachments

Description Liangent 2013-05-25 21:18:53 UTC
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
Comment 1 Gerrit Notification Bot 2013-05-26 06:58:15 UTC
Related URL: https://gerrit.wikimedia.org/r/65489 (Gerrit Change I45db6860d0a4b4480e0b93aa7e750f096424e40f)
Comment 2 Liangent 2013-05-27 05:21:24 UTC
Also in LoadBalancer::openForeignConnection()
Comment 3 Gerrit Notification Bot 2013-08-09 00:19:52 UTC
Change 65489 merged by jenkins-bot:
Never prefix table names with $wgSharedDB when used in foreign DB

https://gerrit.wikimedia.org/r/65489
Comment 4 Bawolff (Brian Wolff) 2013-08-22 21:47:44 UTC
Marking as resolved fix since patch merged.

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


Navigation
Links