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 <[email protected]> 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 <[email protected]> wrote: > >> On 3/7/24 00:48, Francesco Negri wrote: > >>> On Thu, Jun 13, 2024 at 4:59 PM Francesco Negri <[email protected]> > >>> 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 -- [email protected] > >> List information: > >> https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/ > > > > > _______________________________________________ > Cloud mailing list -- [email protected] > List information: > https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/ -- Francesco Negri (he/him) -- IRC: dhinus Site Reliability Engineer, Cloud Services team Wikimedia Foundation _______________________________________________ Cloud mailing list -- [email protected] List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/
