[01:54:06] ori-l: Any chance I could get you to pastebin "show tables;" on enwiki? [01:56:14] Elsie, I'm guessing you want it from production not labs' enwiki_p? [01:56:23] Yeah. :-) [01:59:29] will it get me into trouble? [01:59:34] why do you need it? [01:59:50] I did user prefs clean out bugs today. [01:59:57] I was going to do table clean out bugs tomorrow. [02:00:07] I doubt it'll get you into trouble. [02:00:11] alright, give me a moment [02:02:00] lol ori-l, I doubt any table names are sensitive [02:02:29] There's apparently a hashs table. [02:02:36] No idea why or how. [02:02:46] Krenair: they're case-sensitive! [02:03:00] sbm [02:06:07] Elsie: https://dpaste.de/vIaGX/raw/ [02:07:02] ori-l: Thanks! [02:09:44] I think some of these tables should be dropped. [02:09:51] But I'm not sure it's my place to say so. [02:13:41] the cost of keeping them around is often close to nil if they are small, and in general unnecessary maintenance on production databases is to be avoid, but it's probably good to have a devil's advocate agitate for periodic housecleaning [02:14:12] i don't know that that's a winning argument, but you could ask [02:14:15] * avoided [02:14:29] Well, some of them are also clearly old and broken. [02:14:35] Because they're named _old or broken_. [02:14:43] I'm not sure what the point of keeping them around forever is. [02:14:57] Like, user_old is from around 2005, I think. [02:15:02] Based on the number of rows. [02:15:24] * ori-l shrugs [02:16:23] I'm not sure I'd call the cost negligible. [02:16:32] Given that we have to replicate these tables. [02:16:41] And probably back them up. [02:16:54] And store them, though storage _is_ cheap. [02:17:00] I dunno. [02:17:04] I'll file the bugs. [02:17:10] file all the bugs [02:17:11] They're valid bugs, I just don't expect anyone to act on them. [02:17:15] closing bugs is cheap [02:17:28] Rarely. [02:17:42] only when your involved they aren't [02:17:58] There are also core tables that are like... [02:18:07] For example, hitcounter. [02:18:28] no one talks about that stepchild of a table >.> [03:01:37] https://meta.wikimedia.org/wiki/Requests_for_comment/Petition_of_HTTPS_default [08:46:30] Is there an API endpoint for Wikipedia that can give back a generator for all articles that have a main coordinate? [14:37:05] is anyone aware of cache problems (of something what looks ike that)? [14:38:52] Can you be any more vague? [14:40:17] in the past days we experience somethig what seems to be caching problems, on particular one page on nl-wiki were many times an earlier version of that page is shown instead of the current version [14:40:56] this page is in use to request admin tools [14:41:09] https://nl.wikipedia.org/wiki/Wikipedia:Aanmelding_moderatoren [14:41:27] I just opened that page again and again an earlier evrsion is shown [14:41:56] even while I have seen a more recent version yesterday [14:42:02] a lot of users complain about this [14:42:12] Reedy: is this concrete enough? [14:42:56] Romaine: I get the most recent revision. I assume you are logged in? [14:43:02] yes [14:43:20] what is the top section of that page? [14:43:27] top bar [14:43:29] Actueel: [14:43:30] 0 peilingen | 0 stemmingen | 1 moderatoraanmelding | 4 etalageaanmeldingen [14:43:48] yes, that is the right version [14:43:54] and «zaheer·12a»'s vote is shown [14:44:06] (#85 voor dqfn13) [14:44:16] but the strange thing is that on verious moments I do not get the most recent version [14:44:40] of the page or of the template? [14:44:51] page [14:45:00] so also newer votes do not show up? [14:45:04] see the history [14:45:24] yes, some votes are missing when reading a page [14:45:47] but when editing those are back or aren't back [14:46:09] so you even sometimes get an old version in the editor? That's very strange. [14:46:15] twice already someone deleted a lot of votes as he got an older version on his screen and edited that one [14:46:30] it is not me only, several users have [14:46:36] see also the history of the page [14:47:08] * there are moments people get the most recent page [14:47:33] * there are moments people get an older version, but with clicking edit they edit the current page [14:48:01] * there are moments people get an older version, and click edit and also edit in an older version (with loss of votes) [15:09:41] Reedy / valhallasw: any idea what this causes and/or how this can be solved? [15:14:27] Reedy / valhallasw: Help! I just reopened that page again and again I got the older version of it, instead of the current version [15:15:40] I also noticed that templates that are inserted in the time between the older version shown and the current version aren't always listed in https://nl.wikipedia.org/wiki/Speciaal:VerwijzingenNaarHier/Wikipedia:Mededelingen/Actueel [15:25:12] Reedy / valhallasw:I created a bug for it: https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 [15:34:56] Romaine: kan je daar nog bij posten welke server je pagina heeft gerenderd? right-click, view source, dan onderaan iets als '' [15:35:11] zal ik doen [15:35:46] [15:36:05] ^^ with showing date on the page itself: 10 aug 2013 om 19:30 [15:36:11] (as last version) [15:38:06] ah! [15:38:12] it seems to be http/https related [15:38:29] or at least: I get a new version over https, an old one over http [15:38:47] I get also old versions with https [15:39:15] oh, you're right. It changes on a refresh [15:40:30] it keeps showing or the current version or one particular older version: 10 aug 2013 om 19:30 [15:41:17] hm. [15:42:38] I refreshed the page 20 times, 8 out of 20 I got the version of 10 Aug [15:42:49] 12 out of 20 the most recent revision [15:42:54] randomly [15:48:21] valhallasw: I added some