User talk:Σ/Archive/2025/March

"Edits by user" issue

Even though you aren't active anymore, this may be useful to talk page watchers. I was trying the "Edits by user" toolforge on myself for WP:ANI, and when I reloaded it twice in a few seconds it gave me this:

• Error URL

Text of the error:

Traceback (most recent call last):
File "/workspace/app.py", line 33, in inner
return func(*a, **kw)
^^^^^^^^^^^^^^
File "/workspace/app.py", line 80, in usersearch_py
tpl, store = UserSearch(params)()
^^^^^^^^^^^^^^^^^^^^
File "/workspace/usersearch.py", line 27, in __call__
loop.run_until_complete(self.do_query(store.server, store.query))
File "/layers/heroku_python/python/lib/python3.12/asyncio/base_events.py", line 684, in run_until_complete
return future.result()
^^^^^^^^^^^^^^^
File "/workspace/usersearch.py", line 113, in do_query
async with sql.connect(**connect_info(server)) as conn2:
File "/layers/heroku_python/dependencies/lib/python3.12/site-packages/aiomysql/utils.py", line 74, in __aenter__
self._obj = await self._coro
^^^^^^^^^^^^^^^^
File "/layers/heroku_python/dependencies/lib/python3.12/site-packages/aiomysql/connection.py", line 75, in _connect
await conn._connect()
File "/layers/heroku_python/dependencies/lib/python3.12/site-packages/aiomysql/connection.py", line 540, in _connect
await self._request_authentication()
File "/layers/heroku_python/dependencies/lib/python3.12/site-packages/aiomysql/connection.py", line 844, in _request_authentication
auth_packet = await self._read_packet()
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/layers/heroku_python/dependencies/lib/python3.12/site-packages/aiomysql/connection.py", line 652, in _read_packet
packet.raise_for_error()
File "/layers/heroku_python/dependencies/lib/python3.12/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/layers/heroku_python/dependencies/lib/python3.12/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1226, "User 's51469' has exceeded the 'max_user_connections' resource (current value: 10)")

The site told me to report it here, so here I am. — E_F⁵ 18:58, 25 February 2025 (UTC)

This is a known, and sporadic, issue caused by too many people using the tool at once. If this happens, try again in a few minutes. * Pppery * _{it has begun...} 04:37, 26 February 2025 (UTC)

Editor interaction tool broken if user has edited event namespace

Traceback (most recent call last):
  File "/workspace/app.py", line 33, in inner
    return func(*a, **kw)
           ^^^^^^^^^^^^^^
  File "/workspace/app.py", line 71, in editorinteract_py
    tpl, store = EditorInteract(params)()
                 ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/workspace/editorinteract.py", line 30, in __call__
    self.process_results(store)
  File "/workspace/editorinteract.py", line 166, in process_results
    if store.namespaces[edit[0]]:
       ~~~~~~~~~~~~~~~~^^^^^^^^^
KeyError: 1728

Can be seen by any attempt to analyze interactions with me. * Pppery * _{it has begun...} 04:36, 26 February 2025 (UTC)

I've added this to my todo list. 0xDeadbeef→∞ (talk to me) 11:01, 27 February 2025 (UTC)

Fixed. 0xDeadbeef→∞ (talk to me) 09:35, 4 March 2025 (UTC)

Editor interaction analyzer code

Looking for the code or an API version of the editor interaction analyzer (I need to pull the data into a Jupyter notebook). – Closed Limelike Curves (talk) 05:04, 6 March 2025 (UTC)

Interaction analyser -- Commons

Hello Sig- I got this error when trying to search Commons. I tried "Commons", "commons.wikimedia.org", and "Wikimedia Commons"; all got errors. Thanks in advance for any info. Eric ^talk 16:05, 11 March 2025 (UTC)

Hi @Eric: It should be "commonswiki". 0xDeadbeef→∞ (talk to me) 02:19, 16 March 2025 (UTC)

Thanks! Eric ^talk 02:52, 16 March 2025 (UTC)