[Cloud] [Cloud-announce] cloud-vps maintenance tomorrow, 2019-04-16

2020-04-15 Thread Andrew Bogott
We'll be upgrading the cloud services OpenStack install tomorrow, beginning at 15:00 UTC. There should be little to no interruption to VMs or Toolforge, but Horizon logins will be disabled for part of the window. Sorry for the short notice! - Andrew + the WMCS team

[Cloud-announce] cloud-vps maintenance tomorrow, 2019-04-16

2020-04-15 Thread Andrew Bogott
We'll be upgrading the cloud services OpenStack install tomorrow, beginning at 15:00 UTC. There should be little to no interruption to VMs or Toolforge, but Horizon logins will be disabled for part of the window. Sorry for the short notice! - Andrew + the WMCS team

Re: [Cloud] Logging query with actors and log type (user stats)

2020-04-15 Thread AntiCompositeNumber
Alright, now that I've unearthed the page I was looking for, a fuller answer. The wiki replicas have to do a lot of database magic to remove private/deleted data, which means that the normal tables can be slow. For your logging query, logging_logindex makes things faster because log_action is

Re: [Cloud] Logging query with actors and log type (user stats)

2020-04-15 Thread AntiCompositeNumber
You should use the un(der)-documented `logging_logindex` view instead of `logging`. On Wed, Apr 15, 2020 at 17:56 Maciej Jaros wrote: > Not sure if this is an appropriate place to discuss this but I'm not able > to run this query: > https://quarry.wmflabs.org/query/24267 > > Even a minor part

Re: [Cloud] Logging query with actors and log type (user stats)

2020-04-15 Thread Maciej Jaros
Also note that I have a similar query that kind of works but takes much longer to complete then it used to. https://quarry.wmflabs.org/query/41680 Executed in 46.22 seconds as of Wed Jan 29 2020. Resultset (1480 rows) Executed in 188.32 seconds as of Wed Apr 15 2020. Resultset (1480 rows) So

[Cloud] Logging query with actors and log type (user stats)

2020-04-15 Thread Maciej Jaros
Not sure if this is an appropriate place to discuss this but I'm not able to run this query: https://quarry.wmflabs.org/query/24267 Even a minor part of this query like below needs a significant time to complete.    SELECT count(*) as review_count, log_actor     FROM logging     WHERE

Re: [Cloud] [Cloud-announce] Changes to CloudVPS web proxy (XFF) on 2020-04-15

2020-04-15 Thread Zoran Dori
Hello, thanks for doing great job. Do you have plan to enable HTTPS per default for web proxy names? Best regards, Zoran Dori volunteer, Wikimedia Serbia s: zoranzoki21.github.io e: zorandori4...@gmail.com ___ Wikimedia Cloud Services mailing list

Re: [Cloud-announce] Changes to CloudVPS web proxy (XFF) on 2020-04-15

2020-04-15 Thread Arturo Borrero Gonzalez
On 4/1/20 2:16 PM, Arturo Borrero Gonzalez wrote: > Hi there! > > If you use a CloudVPS web proxy, this email is for you. Toolforge > developers/users can ignore this email. > > We are introducing a change to eliminate the 'X-Forwarded-For' HTTP header > that > the CloudVPS web proxy adds when

Re: [Cloud] Changes to CloudVPS web proxy (XFF) on 2020-04-15

2020-04-15 Thread Arturo Borrero Gonzalez
On 4/1/20 2:16 PM, Arturo Borrero Gonzalez wrote: > Hi there! > > If you use a CloudVPS web proxy, this email is for you. Toolforge > developers/users can ignore this email. > > We are introducing a change to eliminate the 'X-Forwarded-For' HTTP header > that > the CloudVPS web proxy adds when