Pchelolo added a comment.
Looking at the requestId of one of these errors, the following log messages are found: https://logstash.wikimedia.org/goto/3e387a16e01ae0f02e72b413d6691539 The interesting one there is: Sub-optimal transaction on DB(s) [10.64.16.34 (frwiki) (TRX#7ad8fc)]: 0 3.366758 query-m: SELECT GET_LOCK('X', N) AS lockstatus [TRX#7ad8fc] 1 0.000420 query-m: SELECT RELEASE_LOCK('X') as lockstatus [TRX#7ad8fc] 2 0.000425 query-m: INSERT INTO `comment` (comment_hash,comment_text,comment_data) VALUES (N,'X',NULL) [TRX#7ad8fc] 3 0.000508 query-m: INSERT INTO `revision` (rev_page,rev_parent_id,rev_minor_edit,rev_timestamp,rev_deleted,rev_len,rev_sha1) VALUES (N,...,N,'X') [TRX#7ad8fc] 4 0.000354 query-m: INSERT INTO `revision_comment_temp` (revcomment_rev,revcomment_comment_id) VALUES (N,...,N) [TRX#7ad8fc] 5 0.000382 query-m: INSERT INTO `revision_actor_temp` (revactor_rev,revactor_actor,revactor_timestamp,revactor_page) VALUES (N,...,N,'X',revactor_page = N [TRX#7ad8fc] 6 0.005014 query-m: INSERT INTO `blobs_cluster2N` (blob_text) VALUES ('X') 7 0.000426 query-m: INSERT INTO `text` (old_id,old_text,old_flags) VALUES (NULL,'X') [TRX#7ad8fc] 8 0.000362 query-m: INSERT INTO `content` (content_size,content_sha1,content_model,content_address) VALUES (N,'X') [TRX#7ad8fc] 9 0.000423 query-m: INSERT INTO `slots` (slot_revision_id,slot_role_id,slot_content_id,slot_origin) VALUES (N,...,N) [TRX#7ad8fc] 10 0.000452 query-m: UPDATE `page` SET page_latest = N,page_touched = 'X' WHERE page_id = N [TRX#7ad8fc] The really long one seems to be `SELECT GET_LOCK('X', N) AS lockstatus` TASK DETAIL https://phabricator.wikimedia.org/T251457 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Pchelolo Cc: Pchelolo, daniel, DannyS712, Jdforrester-WMF, Krinkle, Marostegui, Liuxinyu970226, brennen, Bugreporter, LarsWirzenius, Hogue, Aklapper, Naike, Blissjay007, Oblanco79, Alter-paule, Beast1978, Un1tY, eprodromou, Hook696, Daryl-TTMG, RomaAmorRoma, E.S.A-Sheild, darthmon_wmde, Kent7301, Meekrab2012, joker88john, CucyNoiD, Nandana, NebulousIris, Banyek, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Rayssa-, Lahi, Gq86, Af420, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, WSH1906, Lewizho99, Maathavan, _jensen, rosalieper, Agabi10, Scott_WUaS, Jonas, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, Rxy, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
