User talk:Σ/Archive/2020/March

MfD nomination of Wikipedia talk:Notability (sports)/Archive 18
Wikipedia talk:Notability (sports)/Archive 18, a page which you created or substantially contributed to, has been nominated for deletion. Your opinions on the matter are welcome; you may participate in the discussion by adding your comments at Wikipedia:Miscellany for deletion/Wikipedia talk:Notability (sports)/Archive 18 and please be sure to sign your comments with four tildes ( ~ ). You are free to edit the content of Wikipedia talk:Notability (sports)/Archive 18 during the discussion but should not remove the miscellany for deletion template from the top of the page; such a removal will not end the deletion discussion. Thank you. Rogermx (talk) 21:07, 21 February 2020 (UTC)

Autoarchive error message misformatted and truncated
At :

There is a lot of escape-quoting of special characters that is not necessary in this context, which makes it hard to read. And the actual blocked link, something I'd want to fix to resolve this problem, is actually not "shown below" because the string overflows some field-size limit. Is there a more complete log of these failures somewhere? DMacks (talk) 07:31, 25 February 2020 (UTC)

Lowercase sigmabot III archiving WP:BLPN threads quickly
I understand that you operate User:Lowercase sigmabot III. On 25 February 2020 it archived 5 WP:BLPN threads. Several signed posts in those threads have newest timestamps between 22 February 2020 and 25 February 2020, in fact the last one is timestamped 03:36, 25 February 2020 -- six minutes before Lowercase sigmabot III acted. WP:BLPN's Mizabot configuration includes the line: "algo               = old(7d)" So, please, can you say why it did not wait 7 days? Not urgent. Peter Gulutzan (talk) 16:43, 28 February 2020 (UTC)
 * In the diff that you gave, five threads were archived. For each of those, the most recent timestamp is as follows:
 * Category:Climate change deniers: Again - 03:29, 18 February 2020 (UTC)
 * Jared Kushner – father made $2.5M donation just before Harvard admission - 16:21, 17 February 2020 (UTC)
 * Joseph Michelli - 02:24, 18 February 2020 (UTC)
 * Heston Blumenthal - 01:00, 18 February 2020 (UTC)
 * Somali Outlaws - 21:40, 17 February 2020 (UTC)
 * All of these are more than seven days earlier than the timestamp of the edit, 03:42, 25 February 2020 (UTC). If there is a problem, I fail to see it. -- Red rose64 &#x1f339; (talk) 17:56, 28 February 2020 (UTC)
 * Redrose64 You are right, I made two mistakes: (1) I thought of my own edit of 21:49 22 February 2020. But I see now that no timestamp was added, probably I unknowingly used WP:3TILDES. (2) The more recent edits that I saw were actually outside the threads. I am sorry and I thank you for tolerating a time-wasting query. Peter Gulutzan (talk) 18:51, 28 February 2020 (UTC)

Editor interaction analyser slow?
Hey Σ, I've noticed that the Editor Interaction Analyser is running slow. This search took 80.098 seconds. It's really the 0.098 that bothers me. Anyhow, thought I should report it to ya. Thanks, Cyphoidbomb (talk) 16:48, 6 March 2020 (UTC)
 * Got an error today:

Traceback (most recent call last): File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/aiomysql/connection.py", line 598, in _read_bytes data = await self._reader.readexactly(num_bytes) File "/usr/lib/python3.5/asyncio/streams.py", line 666, in readexactly raise IncompleteReadError(incomplete, n) asyncio.streams.IncompleteReadError: 14 bytes read on a total of 33 expected bytes
 * https://tools.wmflabs.org/sigma/editorinteract.py?users=B.Bhargava+Teja&users=124.123.50.117&users=&startdate=&enddate=&ns=&server=enwiki

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "./app.py", line 33, in inner return func(*a, **kw) File "./app.py", line 71, in editorinteract_py tpl, store = EditorInteract(params) File "./editorinteract.py", line 28, in __call__ loop.run_until_complete(self.do_query(store.server, store.query)) File "/usr/lib/python3.5/asyncio/base_events.py", line 466, in run_until_complete return future.result File "/usr/lib/python3.5/asyncio/futures.py", line 293, in result raise self._exception File "/usr/lib/python3.5/asyncio/tasks.py", line 241, in _step result = coro.throw(exc) File "./editorinteract.py", line 158, in do_query user_edits = dict(zip(query.users, await asyncio.gather(*[get_user_edits(u) for u in query.users]))) File "/usr/lib/python3.5/asyncio/futures.py", line 380, in __iter__ yield self # This tells Task to wait for completion. File "/usr/lib/python3.5/asyncio/tasks.py", line 304, in _wakeup future.result File "/usr/lib/python3.5/asyncio/futures.py", line 293, in result raise self._exception File "/usr/lib/python3.5/asyncio/tasks.py", line 239, in _step result = coro.send(None) File "./editorinteract.py", line 156, in get_user_edits await cur.execute(query.str, (user,) + query.args) File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/aiomysql/cursors.py", line 239, in execute await self._query(query) File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/aiomysql/cursors.py", line 457, in _query await conn.query(q) File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/aiomysql/connection.py", line 428, in query await self._read_query_result(unbuffered=unbuffered) File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/aiomysql/connection.py", line 622, in _read_query_result await result.read File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/aiomysql/connection.py", line 1113, in read await self._read_result_packet(first_packet) File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/aiomysql/connection.py", line 1173, in _read_result_packet await self._read_rowdata_packet File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/aiomysql/connection.py", line 1208, in _read_rowdata_packet packet = await self.connection._read_packet File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/aiomysql/connection.py", line 580, in _read_packet recv_data = await self._read_bytes(bytes_to_read) File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/aiomysql/connection.py", line 601, in _read_bytes raise OperationalError(2013, msg) from e pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query')


 * Regards, Cyphoidbomb (talk) 22:29, 7 March 2020 (UTC)


 * The speed is out of my hands, I'm afraid; the folks who run Toolforge have set up database access differently than Toolserver, the old tool-hosting system, did. A couple of the slowdowns have already been brought up to them.
 * It's something somewhat related to https://phabricator.wikimedia.org/T131266 which is one specific instance of this general problem. → Σ σ  ς . (Sigma) 07:53, 8 March 2020 (UTC)


 * Also, I'm not very active on this site anymore, so if there's been any progress made then I'm not aware of it because nobody told me and I haven't had a chance to look for it. might know a thing or two about how to revise the SQL queries I'm using. → Σ  σ  ς . (Sigma) 07:55, 8 March 2020 (UTC)

Question re Talk:Bird
Hi- The bot did not generate archive links in this edit to the Bird talkpage. Is it meant to generate those automatically? I added them manually just now:. Eric talk 23:19, 23 March 2020 (UTC)
 * This is always a manual job. -- Red rose64 &#x1f339; (talk) 00:20, 24 March 2020 (UTC)
 * Thanks, RR! The training continues... Good to hear from you. Eric talk 01:25, 24 March 2020 (UTC)