Michael added a comment.
This seems to be related to the ratelimit. As for https://integration.wikimedia.org/ci/job/quibble-vendor-mysql-hhvm-docker/53930/consoleFull the first error exactly matches the timestamp of the first rate-limit error message: `2019-06-14 10:33:33 1b09f406778b wikidb: User '127.0.0.1' (IP 127.0.0.1) tripped mediawiki:limiter:edit:ip:127.0.0.1 at 8 (limit 8 in 60s)` See: https://integration.wikimedia.org/ci/job/quibble-vendor-mysql-hhvm-docker/53930/artifact/log/mw-ratelimit.log But also there are quite some errors in the `mw-dberror.log`: Fri Jun 14 10:24:36 UTC 2019 1b09f406778b wikidb-unittest_ BrokenRedirectsPage::reallyDoQuery /workspace/db/quibble-mysql-h6p0v4cu/socket 1137 Can't reopen table: 'p1' (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT p1.page_namespace AS `namespace`,p1.page_title AS `title`,p1.page_title AS `value`,rd_namespace,rd_title,rd_fragment FROM `unittest_redirect` JOIN `unittest_page` `p1` ON ((rd_from=p1.page_id)) LEFT JOIN `unittest_page` `p2` ON ((rd_namespace=p2.page_namespace) AND (rd_title=p2.page_title)) WHERE (rd_namespace >= 0) AND (rd_interwiki IS NULL OR rd_interwiki = '') AND (p2.page_namespace IS NULL) ORDER BY rd_namespace,rd_title,rd_from LIMIT 51 Fri Jun 14 10:24:36 UTC 2019 1b09f406778b wikidb-unittest_ DoubleRedirectsPage::reallyDoQuery /workspace/db/quibble-mysql-h6p0v4cu/socket 1137 Can't reopen table: 'ra' (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT pa.page_namespace AS `namespace`,pa.page_title AS `title`,pa.page_title AS `value`,pb.page_namespace AS `b_namespace`,pb.page_title AS `b_title`,rb.rd_namespace AS `c_namespace`,rb.rd_title AS `c_title`,rb.rd_fragment AS `c_fragment`,rb.rd_interwiki AS `c_interwiki` FROM `unittest_redirect` `ra`,`unittest_redirect` `rb`,`unittest_page` `pa`,`unittest_page` `pb` WHERE (ra.rd_from = pa.page_id) AND (ra.rd_interwiki IS NULL OR ra.rd_interwiki = '') AND (pb.page_namespace = ra.rd_namespace) AND (pb.page_title = ra.rd_title) AND (rb.rd_from = pb.page_id) ORDER BY ra.rd_namespace,ra.rd_title LIMIT 51 Fri Jun 14 10:24:36 UTC 2019 1b09f406778b wikidb-unittest_ WantedFilesPage::reallyDoQuery /workspace/db/quibble-mysql-h6p0v4cu/socket 1137 Can't reopen table: 'img1' (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT 6 AS `namespace`,il_to AS `title`,COUNT(*) AS `value` FROM `unittest_imagelinks` LEFT JOIN `unittest_page` ON ((il_to = page_title) AND page_namespace = '6') LEFT JOIN `unittest_redirect` ON ((page_id = rd_from) AND rd_namespace = '6' AND rd_interwiki = '') LEFT JOIN `unittest_image` `img1` ON ((il_to = img1.img_name)) LEFT JOIN `unittest_image` `img2` ON ((rd_title = img2.img_name)) WHERE img1.img_name IS NULL AND img2.img_name IS NULL GROUP BY il_to ORDER BY value DESC,namespace,title LIMIT 51 Fri Jun 14 10:24:36 UTC 2019 1b09f406778b wikidb-unittest_ WantedPagesPage::reallyDoQuery /workspace/db/quibble-mysql-h6p0v4cu/socket 1137 Can't reopen table: 'pg1' (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT pl_namespace AS `namespace`,pl_title AS `title`,COUNT(*) AS `value` FROM `unittest_pagelinks` LEFT JOIN `unittest_page` `pg1` ON ((pg1.page_namespace = pl_namespace) AND (pg1.page_title = pl_title)) LEFT JOIN `unittest_page` `pg2` ON ((pg2.page_id = pl_from)) WHERE (pg1.page_namespace IS NULL) AND (pl_namespace NOT IN ('2','3')) AND (pg2.page_namespace != '8') GROUP BY pl_namespace,pl_title HAVING (COUNT(*) > '0') AND (COUNT(*) > SUM(pg2.page_is_redirect)) ORDER BY value DESC,namespace,title LIMIT 51 Fri Jun 14 10:24:36 UTC 2019 1b09f406778b wikidb-unittest_ ListredirectsPage::reallyDoQuery /workspace/db/quibble-mysql-h6p0v4cu/socket 1137 Can't reopen table: 'p1' (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT p1.page_namespace AS `namespace`,p1.page_title AS `title`,p1.page_title AS `value`,rd_namespace,rd_title,rd_fragment,rd_interwiki,p2.page_id AS `redirid` FROM `unittest_page` `p1` LEFT JOIN `unittest_redirect` ON ((rd_from=p1.page_id)) LEFT JOIN `unittest_page` `p2` ON ((p2.page_namespace=rd_namespace) AND (p2.page_title=rd_title)) WHERE p1.page_is_redirect = '1' ORDER BY p1.page_namespace,p1.page_title LIMIT 51 Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' Fri Jun 14 10:25:33 UTC 2019 1b09f406778b wikidb-unittest_ SqlBagOStuff::fetchBlobMulti /workspace/db/quibble-mysql-h6p0v4cu/socket 1146 Table 'wikidb.unittest_objectcache' doesn't exist (/workspace/db/quibble-mysql-h6p0v4cu/socket) SELECT keyname,value,exptime FROM `unittest_objectcache` WHERE keyname = 'wikidb-unittest_:mf:mobileview:9::19700101000000:0::wikidb-unittest_%3Apcache%3Aidhash%3A0-0!dateformat=default!wb=3' See https://integration.wikimedia.org/ci/job/quibble-vendor-mysql-hhvm-docker/53930/artifact/log/mw-dberror.log TASK DETAIL https://phabricator.wikimedia.org/T225796 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Michael Cc: Lucas_Werkmeister_WMDE, Aklapper, Michael, darthmon_wmde, alaa_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
