Springle added a comment. No smoking gun yet.
As discussed a few times on labs-l in order fight abuse and replag we kill things explicitly when: 1. A query runs for more that 28800 seconds 2. One or more queries are about to collectively cause an OOM (rare) 3. A client holds a connection open and **idle** for more than 60 seconds 4. The CATSCAN stuff runs slow writes for more than 300 seconds I wonder if #3 is the culprit here. 60s was chosen because some users leave transactions open for long periods and/or consume many concurrent connections for no good reason. If this is the problem, we can either bump up the time limit or encourage apps to auto-reconnect, use keep-alive, or just close them. TASK DETAIL https://phabricator.wikimedia.org/T76699 REPLY HANDLER ACTIONS Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign <username>. EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Springle Cc: Aklapper, Magnus, Husky, coren, Lokal_Profil, Steinsplitter, Danilo, Springle, Wikidata-bugs, aude, jayvdb, scfc _______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
