Hi Sam, an update on this: the replica is still delayed, and based on my estimation it will take two more days to catch up. [1] This is a recurring problem that we're trying to improve, but it usually happens once a month or less, and most of the time you should be able to see up-to-date information in Quarry.
Apologies for the inconvenience, Francesco
[1] https://phabricator.wikimedia.org/T370760 [2] https://phabricator.wikimedia.org/T357624
On Wed, Jul 24, 2024 at 1:59 AM Sam Wilson sam@samwilson.id.au wrote:
Yep, it was created yesterday.
Thanks, good to know it's just a matter of waiting.
On 23/7/24 22:14, Francesco Negri wrote:
Hi Sam, was that database created today?
Quarry is connecting to the replica host, which currently has a replication lag of 13 hours. It should catch up in a day or two.
The lag issue is tracked at https://phabricator.wikimedia.org/T370760 and the parent task https://phabricator.wikimedia.org/T357624
Hope this helps, Francesco
On Tue, Jul 23, 2024 at 3:23 PM Sam Wilson sam@samwilson.id.au wrote:
On 3/7/24 00:48, Francesco Negri wrote:
On Thu, Jun 13, 2024 at 4:59 PM Francesco Negri fnegri@wikimedia.org wrote:
== This change is planned to go live on Monday, July 1st. ==
This change is now live, and ToolsDB's "public" databases (the ones with a name ending with "_p") can be queried from Quarry.
In Superset, databases must unfortunately be added individually, so if you are interested in querying one of those databases from Superset please leave a comment in https://phabricator.wikimedia.org/T367393
The last request in the parent task (T151158) was to be able to query Quarry's own database. This is not implemented yet and is tracked in https://phabricator.wikimedia.org/T367415
I will also document all the above in Wikitech.
Does anything need to be done to have a tool database be visible to Quarry? Should it be possible to query s55926__wishlist_p for example (which was only created yesterday; it's for the Community Wishlist wishes). Example query: https://quarry.wmcloud.org/query/11263
Cloud mailing list -- cloud@lists.wikimedia.org List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/
Cloud mailing list -- cloud@lists.wikimedia.org List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/