enwiki_p needs dumped and re-imported. select count(*) from imagelinks where img_to = 'Flag_of_Seattle.svg'; returns 69 when it should return 2
John
Hello, At Monday 29 April 2013 21:32:43 DaB. wrote:
enwiki_p needs dumped and re-imported.
yes and no. We have 2 servers for enwiki and only 1 of it is re-setuped yet (this one returns the correct value – I checked). There are 3 problems: * 1 server can not carry the load so during the downtime our enwp-replag would increase. * The replag of wikidata and commons on the "good" server is very high and does not really decrease at the moment * The discs of the "good" server are (most likely) too small to store enwp, commons, wikidata and the user-databases – so no user-databases would be available during the re-setup.
Another problem was that I had less time in the last weeks than before because my university started again. We will find a solution for all problems but it will take a while. So if you need accurate data for enwp, please query sql-s1- rr (you should always do this BTW).
Sincerely, DaB.
Yes, I checked and the correct value was returned:
mysql> select count(*) from imagelinks where il_to = 'Flag_of_Seattle.svg'; +----------+ | count(*) | +----------+ | 2 | +----------+ 1 row in set (0.01 sec)
Hazard-SJ
________________________________ From: DaB. WP@daniel.baur4.info To: Wikimedia Toolserver toolserver-l@lists.wikimedia.org Sent: Monday, April 29, 2013 2:42 PM Subject: Re: [Toolserver-l] enwiki_p corruption
Hello, At Monday 29 April 2013 21:32:43 DaB. wrote:
enwiki_p needs dumped and re-imported.
yes and no. We have 2 servers for enwiki and only 1 of it is re-setuped yet (this one returns the correct value – I checked). There are 3 problems: * 1 server can not carry the load so during the downtime our enwp-replag would increase. * The replag of wikidata and commons on the "good" server is very high and does not really decrease at the moment * The discs of the "good" server are (most likely) too small to store enwp, commons, wikidata and the user-databases – so no user-databases would be available during the re-setup.
Another problem was that I had less time in the last weeks than before because my university started again. We will find a solution for all problems but it will take a while. So if you need accurate data for enwp, please query sql-s1- rr (you should always do this BTW).
Sincerely, DaB.
toolserver-l@lists.wikimedia.org