[Wikidata-bugs] [Maniphest] [Commented On] T202764: Wikidata produces a lot of failed requests for recentchanges API

[Marostegui]

Marostegui added a comment.

eqiad db API hosts return the query in less than a second as they have the correct schema:

root@db1104.eqiad.wmnet[wikidatawiki]> select @@hostname;
+------------+
| @@hostname |
+------------+
| db1104     |
+------------+
1 row in set (0.00 sec)

root@db1104.eqiad.wmnet[wikidatawiki]> SELECT  rc_id,rc_timestamp,rc_namespace,rc_title,rc_cur_id,rc_type,rc_deleted,rc_this_oldid,rc_last_oldid  FROM `recentchanges`    WHERE (rc_timestamp>='20180914110000') AND rc_namespace IN ('0','120')  AND rc_type IN ('0','1','3','6')   ORDER BY rc_timestamp ASC,rc_id ASC LIMIT 101  ;
+-----------+----------------+--------------+-----------+-----------+---------+------------+---------------+---------------+
| rc_id     | rc_timestamp   | rc_namespace | rc_title  | rc_cur_id | rc_type | rc_deleted | rc_this_oldid | rc_last_oldid |
+-----------+----------------+--------------+-----------+-----------+---------+------------+---------------+---------------+
| 781488474 | 20180914110000 |            0 | Q11614745 |  12755105 |       0 |          0 |     745861888 |     745695128 |
| 781488475 | 20180914110000 |            0 | Q49559730 |  50562117 |       0 |          0 |     745861890 |     708599303 |
| 781488476 | 20180914110000 |            0 | Q49909619 |  50909548 |       0 |          0 |     745861889 |     745861887 |
| 781488477 | 20180914110000 |            0 | Q34205543 |  35645575 |       0 |          0 |     745861891 |     743199425 |
<snip>
101 rows in set (0.00 sec)





root@db1092.eqiad.wmnet[wikidatawiki]> select @@hostname;
+------------+
| @@hostname |
+------------+
| db1092     |
+------------+
1 row in set (0.00 sec)

root@db1092.eqiad.wmnet[wikidatawiki]> SELECT  rc_id,rc_timestamp,rc_namespace,rc_title,rc_cur_id,rc_type,rc_deleted,rc_this_oldid,rc_last_oldid  FROM `recentchanges`    WHERE (rc_timestamp>='20180914110000') AND rc_namespace IN ('0','120')  AND rc_type IN ('0','1','3','6')   ORDER BY rc_timestamp ASC,rc_id ASC LIMIT 101  ;
+-----------+----------------+--------------+-----------+-----------+---------+------------+---------------+---------------+
| rc_id     | rc_timestamp   | rc_namespace | rc_title  | rc_cur_id | rc_type | rc_deleted | rc_this_oldid | rc_last_oldid |
+-----------+----------------+--------------+-----------+-----------+---------+------------+---------------+---------------+
| 781488474 | 20180914110000 |            0 | Q11614745 |  12755105 |       0 |          0 |     745861888 |     745695128 |
| 781488475 | 20180914110000 |            0 | Q49559730 |  50562117 |       0 |          0 |     745861890 |     708599303 |
| 781488476 | 20180914110000 |            0 | Q49909619 |  50909548 |       0 |          0 |     745861889 |     745861887 |
| 781488477 | 20180914110000 |            0 | Q34205543 |  35645575 |       0 |          0 |     745861891 |     743199425 |
| 781488478 | 20180914110000 |            0 | Q49909619 |  50909548 |       0 |          0 |     745861892 |     745861889 |
<snip>

101 rows in set (0.01 sec)

TASK DETAIL

https://phabricator.wikimedia.org/T202764

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Smalyshev, Marostegui
Cc: Stashbot, Marostegui, Banyek, Reedy, gerritbot, Krinkle, Addshore, Yurik, jcrespo, Imarlier, Ladsgroup, Lydia_Pintscher, WMDE-leszek, Aklapper, Gehel, Smalyshev, Nandana, thifranc, AndyTan, Davinaclare77, Qtn1293, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, Th3d3v1ls, Hfbn0, QZanden, EBjune, merbst, LawExplorer, Zppix, Jonas, Xmlizer, Wong128hk, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, faidon, Mbch331, Jay8g, fgiunchedi

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs