User talk:Σ/Archive/2020/March

Latest comment: 4 years ago by Eric in topic Question re Talk:Bird


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 [1]:

Archive failure: ceterach.exceptions.EditError: 'spamblacklist': CeterachError('Your edit was not saved because it contains a new external link to a site registered on Wikipedia\'s blacklist. * \'\'\'To save your changes now\'\'\', you must go back and \'\'remove the blocked link\'\' (shown below), and then save. **Note that if you used a redirection link or URL shortener (like e.g. \'\'\'goo.gl\'\'\', \'\'\'t.co\'\'\', \'\'\'youtu.be\'\'\', \'\...

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)

(talk page watcher) @Peter Gulutzan: 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. --Redrose64 🌹 (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:
Extended content

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

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)


@Cyphoidbomb: 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. @Legoktm: 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: [2]. Eric talk 23:19, 23 March 2020 (UTC)

(talk page watcher) This is always a manual job. --Redrose64 🌹 (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)