User talk:Σ/Archive/2024/July

500 error

Got this when filtering revisions by user on WP:SPI to try and find my own edits there. ⇒SWATJester ^{Shoot Blues, Tell VileRat!} 02:44, 16 June 2024 (UTC)
500
You shouldn't be seeing this page. Please report this to User:Σ on enwp. Include the current URL and the text below in your report. If you do not include this information, then there is nothing I can do to help.

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 112, in do_query
    async with sql.connect(**connect_info(server)) as conn1:
  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)")

— ⇒SWATJester ^{Shoot Blues, Tell VileRat!} 02:44, 16 June 2024 (UTC)

Second try gave me this. 500 You shouldn't be seeing this page. Please report this to User:Σ on enwp. Include the current URL and the text below in your report. If you do not include this information, then there is nothing I can do to help.

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 114, in do_query
    async with sql.connect(**connect_info(server)) as conn3:
  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)")

⇒SWATJester ^{Shoot Blues, Tell VileRat!} 02:45, 16 June 2024 (UTC)

It's probably the same cause as Wikipedia:Village_pump_(technical)#Is AFDStats down?. Legoktm (talk) 05:29, 16 June 2024 (UTC)

I'm getting something very similar, for the URL https://sigma.toolforge.org/summary.py?name=Redrose64&search=linked&server=enwiki&max=500&ns=Talk&enddate=20200101000000&startdate=20240101000000&nosect=on --Redrose64 🌹 (talk) 07:53, 16 June 2024 (UTC)

same error for https://sigma.toolforge.org/editorinteract.py?users=CommanderInDubio&users=DerWizzard&users=&startdate=&enddate=&ns=&server=enwiki (while the tool is working at dewiki https://sigma.toolforge.org/editorinteract.py?users=CommanderInDubio&users=DerWizzard&users=&startdate=&enddate=&ns=&server=dewiki)

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 28, 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/editorinteract.py", line 140, in do_query

async with sql.connect(**connect_info(server)) as conn:

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)")

--Johannnes89 (talk) 05:28, 18 June 2024 (UTC)

Edit interaction analyzer error 500

I finally got it to work after about ten tries, but I've been getting error 500. Graywalls (talk) 01:22, 18 June 2024 (UTC)

Happy First Edit Day!

Apollogetticax (talk) 03:38, 22 June 2024 (UTC)

Bot Inactivation

Hello, per WP:BOTINACTIVE your bot has not met the activity requirements and will be de-flagged unless we hear from you before 29 June 2024. If you wish to continue operating your bot please indicate so; the discussion is at Wikipedia:Bots/Noticeboard § Inactive bot (June 2024). Primefac (talk) 22:17, 22 June 2024 (UTC)

Lowercase sigmabot III not editing as many pages as it should

Hello, the subject line says it all ... this bot appears to have slowed down significantly. See this technical village pump discussion. Graham87 (talk) 01:26, 3 July 2024 (UTC)

And it seems the problem has resolved itself. Graham87 (talk) 01:53, 4 July 2024 (UTC)

Please control Lowercase sigmabot III

Though automatic archiving can be useful, it's not always appropriate. The bot is priming the pump for time-wasting edit warring in Talk:Italian phonology. TIA Barefoot through the chollas (talk) 15:41, 14 July 2024 (UTC)

@Barefoot through the chollas, the bot is doing exactly what it's told. See User:Lowercase sigmabot III/Archive HowTo for instructions on how to configure it. – bradv 15:48, 14 July 2024 (UTC)

Yes, obviously the bot is doing what it's ordered to do. That's the problem. I didn't set it up. Barefoot through the chollas (talk) 16:58, 14 July 2024 (UTC)

@Barefoot through the chollas (talk page watcher) Do not pester the bot owner. Instead ask the person who configured it on that talk page, or, with consensus, disable it there. 🇺🇦 Fiddle^Timtrent Faddle^Talk to me 🇺🇦 17:07, 14 July 2024 (UTC)

Barefoor through the chollas what exactly is the problem? The bot is archiving posts/threads on that talk page 1)that have no replies within the past (almost) year. The thread that the bot archived and that you restored hadn't had any replies since April 2023...

If you're trying to figure out how to change the archive parameters or with consensus disable the bot, Help:Archiving a talk page and User:Lowercase sigmabot III/Archive HowTo are both useful.

If you wish to ask the person who set up the archiving to modify its parameters, do a search in page history for some part of the bot-archiving code, to see when it was inserted and who inserted it. Good luck, Shearonink (talk) 17:41, 14 July 2024 (UTC)

@Shearonink Thanks for your response, setting a better tone. I was in the midst of trying to restrain myself from responding thusly to the previous:

Pester? Oh my. No doubt I'm incomprehending mysterious things Wikipedian, but in the normal world, ownership entails some level of responsibility, whether officially-legally or simple common-sensibly. ("Your wind chimes clang day and night!" "Hey, not the job of the owner of wind chimes to control them. It's your job to figure out how to engineer them into not chiming.")

The problem is as I described in my reversal of the automatic archiving of the discussion (my reversal then automatically reversed by the bot): automatic archiving of an unresolved issue regarding misinformation in the article, with material absolutely essential for identifying and correcting misinformation in the article thus archived out of view.

I've spent much too much time already on what shouldn't be an issue in the first place, that archiving of talk determined blindly by time unaddressed alone can be an obstacle to the (frequently gradual) establishment of trustworthy Wikipedia content. Barefoot through the chollas (talk) 18:32, 14 July 2024 (UTC)

Because it's not an actual issue. Many important pages, including practically all of Wikipedia's most active policy discussion boards, utilize this system. Archives are searchable; if the template to do so isn't already there, it's as simple as adding {{Archives}} to the top of the page and getting the searchbox and list of archive pages. But per our talk page guidelines, discussions are not intended to remain open forever -- they are to be resolved through agreement, not exhaustion. We archive closed or stale discussions in service of that principle as well as for page performance and relevancy issues. I hope you recognize that you're barking up the wrong tree by bringing up your issues with the specific implementation of automatic archiving on a specific page to the botmaker's talk page, when you've already admitted that the bot has general utility, and your concern is with the situational appropriateness of it in specific scenarios. And that you'd have better luck getting the results you'd prefer either by discussing it on the Talk:Italian phonology page or just removing the auto-archiving in the first place...as you've been advised here. Climbing the Reichstag over a trivially resolvable problem isn't going to help get you what you want. ⇒SWATJester ^{Shoot Blues, Tell VileRat!} 21:30, 14 July 2024 (UTC)