scfc added a comment.
Oh, if I had only known that me summarizing the comments in this task and
thinking about the different implications of different approaches could be
shortened to just declining, I would have indeed just declined.
TASK DETAIL
https://phabricator.wikimedia.org/T76699
Aklapper added a comment.
So how to proceed here (asking as this has Priority Unbreak now, if that
urgency is realistic)?
TASK DETAIL
https://phabricator.wikimedia.org/T76699
REPLY HANDLER ACTIONS
Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign
username.
coren added a comment.
It's pretty clear that any tool that aims for reliability necessarily //must//
have the ability to reconnect if the connection is dropped between
transactions. It's not clear that values much over 60s are useful (any limit
will end up being a problem if the code doesn't
Springle added a comment.
Unsure if your #1 and #2 are both on labsdb replicas, or if #2 is some other db
like tools-db or a custom instance.
If #1 and #2 are both connections to the labsdb production replicas, then yes,
either connection going idle for 60s will result in its disconnection.
Multichill added a subscriber: Multichill.
Multichill added a comment.
I noticed quite a few of my bots stopped working somewhere start of December
last year. All crashed with MySQL server has gone away. I'm pretty sure it's
the 60 seconds idle limit.
The bot uses two connections:
1. With the
Magnus added a comment.
#4 is moot, as I changed CatScat to not use temporary tables anymore.
If you still see this happening, it's probably this copy:
http://tools.wmflabs.org/catscan3/catscan2.php
which was done by someone else, and has no maintainer...
TASK DETAIL
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
Steinsplitter added a comment.
```
MariaDB [commonswiki_p] SELECT * FROM user_daily_contribs LIMIT 3;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:1943900
Current database: commonswiki_p
+-++--+
| user_id | day
