Last modified: 2014-09-23 02:24:35 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 T55975, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 53975 - foundationwiki making requests to "Unknown MySQL server host 'db1008.eqiad.wmnet'"
foundationwiki making requests to "Unknown MySQL server host 'db1008.eqiad.wm...
Status: RESOLVED FIXED
Product: Wikimedia
Classification: Unclassified
Fundraising (Other open bugs)
wmf-deployment
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
: easy
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-09-10 00:56 UTC by Sam Reed (reedy)
Modified: 2014-09-23 02:24 UTC (History)
7 users (show)

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


Attachments

Description Sam Reed (reedy) 2013-09-10 00:56:17 UTC
Mon Sep 9 8:35:10 UTC 2013      mw1053  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 9:53:17 UTC 2013      mw1077  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 9:53:24 UTC 2013      mw1184  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 9:53:26 UTC 2013      mw1083  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 9:53:32 UTC 2013      mw1183  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 11:18:22 UTC 2013     mw1064  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 11:25:48 UTC 2013     mw1096  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 11:49:12 UTC 2013     mw1076  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 11:59:05 UTC 2013     mw1053  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 15:43:22 UTC 2013     mw1098  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 17:01:12 UTC 2013     mw1077  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 17:27:36 UTC 2013     mw1093  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 18:00:52 UTC 2013     mw1064  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 20:09:57 UTC 2013     mw1209  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 20:17:59 UTC 2013     mw1068  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 20:21:48 UTC 2013     mw1043  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 21:41:36 UTC 2013     mw1101  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 22:20:06 UTC 2013     mw1080  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Mon Sep 9 22:35:56 UTC 2013     mw1032  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Tue Sep 10 0:00:41 UTC 2013     mw1099  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Tue Sep 10 0:31:25 UTC 2013     mw1092  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Tue Sep 10 0:32:40 UTC 2013     mw1217  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)
Tue Sep 10 0:32:44 UTC 2013     mw1163  foundationwiki  Error connecting to db1008.eqiad.wmnet: Unknown MySQL server host 'db1008.eqiad.wmnet' (0)


db1008 is in frack so isn't generally accessible, but as it's used by ContributionReporting/ContributionTracking it must be accessible somehow.

The errors do seem to be something that shouldn't be happening..
Comment 1 Jeff Green 2013-09-10 17:06:14 UTC
from the FR-Tech team:

"+1, let's abandon that extension :)"

"Yeah, I think we're moving pretty solidly toward abandoning FundraiserStatistics, as it hasn't worked in months. ...which means we need more pretty graphs on frdata. :)"

Short term it could be hacked to read off of db78, which will work only until pmtpa goes dark later this year. But my vote is just to remove the extension altogether.
Comment 2 Sam Reed (reedy) 2013-09-10 17:26:08 UTC
Both ContributionReporting and ContributionTracking?
Comment 3 Gerrit Notification Bot 2013-09-10 17:27:45 UTC
Change 83664 had a related patch set uploaded by Reedy:
Initial disable of ContributionReporting/Contributiontracking

https://gerrit.wikimedia.org/r/83664
Comment 4 Gerrit Notification Bot 2013-09-10 17:48:25 UTC
Change 83668 had a related patch set uploaded by Reedy:
Remove ContributionReporting and ContributionTracking

https://gerrit.wikimedia.org/r/83668
Comment 5 Matt Walker 2013-09-10 18:37:39 UTC
Not ContributionTracking; that's still highly useful.

For the moment; because we do not have a good replacement for ContributionReporting and it is the best source of historical data -- can we just remove the cron jobs that are launching the scripts that hit db1008?

I'm not entirely sure where those are launching off from though.
The script is PopulateFundraisingStatistics.php
Comment 6 Gerrit Notification Bot 2013-09-10 18:42:35 UTC
Change 83664 merged by jenkins-bot:
Initial disable of ContributionReporting

https://gerrit.wikimedia.org/r/83664
Comment 7 Jeff Green 2013-09-10 18:44:18 UTC
I don't think it's just cron jobs--there are also direct hits to the db by webservers at content generation time.
Comment 8 Gerrit Notification Bot 2013-09-10 18:47:11 UTC
Change 83668 abandoned by Reedy:
Remove ContributionReporting and ContributionTracking

https://gerrit.wikimedia.org/r/83668
Comment 9 Matt Walker 2013-09-10 19:06:46 UTC
(In reply to comment #7)
> I don't think it's just cron jobs--there are also direct hits to the db by
> webservers at content generation time.
Grrr; you're correct. I hate this extension. I guess nuke it -- it's no longer live. How can we place a redirect to https://frdata.wikimedia.org on https://wikimediafoundation.org/wiki/Special:FundraiserStatistics
Comment 10 Sam Reed (reedy) 2013-09-10 19:16:07 UTC
Apache rule something like the below?
    RewriteCond %{HTTP_HOST} ^frdata\.wikimedia\.org$
    RewriteRule ^(.*)$ https://wikimediafoundation.org/wiki/Special:FundraiserStatistics [R=301,L,NE]
Comment 11 Matt Walker 2013-09-10 21:49:17 UTC
That would work if that's an accepted solution for this type of problem.

Can you implement that Reedy?
Comment 12 Matt Walker 2013-09-10 21:49:46 UTC
(In reply to comment #11)
> Can you implement that Reedy?
* Correction -- deploy that; you already wrote it :p
Comment 13 Sam Reed (reedy) 2013-09-10 21:59:37 UTC
It's on samarium.wikimedia.org, which I'm guessing is a frack host.

So it either needs to be done on that host (not sure where the apache config is for this - puppet). Or we can put it in the general redirects.conf in operations/apache-config,git, and then point it at the wikimedia loadbalancer

Not sure what else (if anything) that host is actually doing
Comment 14 Jeff Green 2013-09-10 22:05:21 UTC
Samarium is indeed a frack host and is on frack's puppet instance, but we don't need to make any changes there, since we're just redirecting to its existing top page.
Comment 15 Sam Reed (reedy) 2013-09-10 22:20:13 UTC
(In reply to comment #14)
> Samarium is indeed a frack host and is on frack's puppet instance, but we
> don't
> need to make any changes there, since we're just redirecting to its existing
> top page.

I'm confused. If frdata.wikimedia.org is on samarium, unless we point the subdomain back to the main load balancers, there needs to be a redirect in the current apache config on samarium to point it to foundationwiki
Comment 16 Kevin Israel (PleaseStand) 2013-09-10 22:23:59 UTC
(In reply to comment #15)
> I'm confused. If frdata.wikimedia.org is on samarium, unless we point the
> subdomain back to the main load balancers, there needs to be a redirect in
> the
> current apache config on samarium to point it to foundationwiki

(In reply to comment #9)
> [...] How can we place a redirect to https://frdata.wikimedia.org on
> https://wikimediafoundation.org/wiki/Special:FundraiserStatistics

Doesn't that mean from <https://wikimediafoundation.org/wiki/Special:FundraiserStatistics> to <https://frdata.wikimedia.org>, not the other way around?
Comment 17 Jeff Green 2013-09-10 22:28:17 UTC
Yes (Comment #16) exactly.
Comment 18 Jeff Green 2013-09-10 22:34:16 UTC
i.e. redirects.conf would get something along these lines:

RewriteCond %{HTTP_HOST} (^|\.)wikimediafoundation\.(org|com|net|info)$
RewriteRule ^/wiki/Special:FundraiserStatistics$ https://frdata.wikimedia.org/ [R=301,L]
Comment 19 Sam Reed (reedy) 2013-09-10 22:37:54 UTC
Oh. Need to pay more attention.

Seems alright...

Can do it in MediaWiki and make a placeholder special page with something like:

$response = RequestContext::getMain()->getRequest()->response();
$response->header( "HTTP/1.1 301 " . HttpStatus::getMessage( 301 ) );
Comment 20 Matt Walker 2013-09-18 17:29:22 UTC
Yes we could; but that would mean perpetually having a stub special page/stub extension which sounds horrible.
Comment 21 Milan 2013-12-17 09:42:30 UTC
In fact - I don't know if this is something to solve but:

When I come to this address:

http://wikimediafoundation.org/wiki/Support_Wikipedia/cs

And try to "donate", result is this:

Cannot contact the database server: Unknown MySQL server host 'db1008.eqiad.wmnet' (0) (db1008.eqiad.wmnet)

I googled the original address - I didn't come to it via any link in wikipedia, but for ex on French lang mutation it is solved nicely. It should be done for all mutations, shouldn't be?

http://wikimediafoundation.org/wiki/Support_Wikipedia/fr

Bye
Comment 22 Peter Coombe 2013-12-18 19:27:57 UTC
That was an old out of date page. I've now redirected it (and all the other Support Wikipedia subpages) to our current page on donate.wikimedia.org.

(In reply to comment #21)
> In fact - I don't know if this is something to solve but:
> 
> When I come to this address:
> 
> http://wikimediafoundation.org/wiki/Support_Wikipedia/cs
> 
> And try to "donate", result is this:
> 
> Cannot contact the database server: Unknown MySQL server host
> 'db1008.eqiad.wmnet' (0) (db1008.eqiad.wmnet)
> 
> I googled the original address - I didn't come to it via any link in
> wikipedia,
> but for ex on French lang mutation it is solved nicely. It should be done for
> all mutations, shouldn't be?
> 
> http://wikimediafoundation.org/wiki/Support_Wikipedia/fr
> 
> Bye
Comment 23 MZMcBride 2014-01-20 21:17:48 UTC
(In reply to comment #18)
> i.e. redirects.conf would get something along these lines:
> 
> RewriteCond %{HTTP_HOST} (^|\.)wikimediafoundation\.(org|com|net|info)$
> RewriteRule ^/wiki/Special:FundraiserStatistics$ https://frdata.wikimedia.org/ [R=301,L]

Submitting a patch to do this should be pretty simple. The relevant repo is here: <https://git.wikimedia.org/tree/operations%2Fapache-config.git>.
Comment 24 Jeff Green 2014-09-23 02:24:35 UTC
as far as I can tell, this has been fixed

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


Navigation
Links