[Wikidata-bugs] [Maniphest] T295229: Replication database don't have some information from production page_props

Reedy added a comment. In T295229#7488990 , @Kanzat wrote: > Now data for that page appeared. > > But you can see how the same script behaved today and 2 days ago: > https://quarry.wmcloud.org/query/59743 (2 days ago, 1 row) >

[Wikidata-bugs] [Maniphest] T295229: Replication database don't have some information from production page_props

Kanzat added a comment. Now data for that page appeared. But you can see how the same script behaved today and 2 days ago: https://quarry.wmcloud.org/query/59743 (2 days ago, 1 row) https://quarry.wmcloud.org/query/59788 (today, 2 rows) I can try to find another example, if there

[Wikidata-bugs] [Maniphest] T295229: Replication database don't have some information from production page_props

Marostegui added a comment. Nowadays with ROW based replication on clouddb* hosts it is very unlikely that we have unknown data drifts (of course this can still happen!) on big and very accessed tables. If we had any, replication would break because of data mismatch. TASK DETAIL

[Wikidata-bugs] [Maniphest] T295229: Replication database don't have some information from production page_props

Reedy added a comment. Done against a production mysql server MariaDB [ukwiki]> select page_id, page_title, pp_propname, pp_value -> from page -> join page_props on page_id = pp_page -> where page_title = 'Шипайло' and page_namespace=0;

[Wikidata-bugs] [Maniphest] T295229: Replication database don't have some information from production page_props

Kanzat added a comment. @Majavah I connected directly to ukwiki.analytics.db.svc.wikimedia.cloud, performed simple sql query by ppvalue and no results were returned. It has to be a replication lag or bug. TASK DETAIL https://phabricator.wikimedia.org/T295229 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T295229: Replication database don't have some information from production page_props

Majavah edited projects, added Wikidata; removed Data-Services. Majavah added a comment. This seems like a #Wikidata issue; as far as I can see the replicas are up to date and not doing any filtering on the page_props table. TASK DETAIL