[Pywikipedia-bugs] [Maniphest] [Commented On] T303175: Error 1062 from Flow\Data\Storage\RevisionStorage::insert, {error} {sql1line} {db_server}

2022-05-30 Thread Tgr 
Tgr added a comment.


  Is this getting more frequent? Last 7 days, there have been 288 such errors.

TASK DETAIL
  https://phabricator.wikimedia.org/T303175

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Tgr
Cc: Tgr, Xqt, pywikibot-bugs-list, mewoph, Aklapper, kostajh, Susie413113, 
Lectrician1, caldera, Jyoo1011, IdtrA, JohnsonLee01, SHEKH, Dijkstra, 
NavinRizwi, ItamarWMDE, Khutuck, Zkhalido, darthmon_wmde, Rosalie_WMDE, Viztor, 
94rain, Wenyi, Jayprakash12345, Nattes, Tbscho, MayS, EnricoCNC, Mdupont, 
JJMC89, Dvorapa, Altostratus, Taiwania_Justo, Avicennasis, Wong128hk, Verdy_p, 
mys_721tx, geraki, Gryllida, jeblad, jayvdb, Catrope, Masti, Alchimista, 
Jdforrester-WMF, Jay8g
___
pywikibot-bugs mailing list -- pywikibot-bugs@lists.wikimedia.org
To unsubscribe send an email to pywikibot-bugs-le...@lists.wikimedia.org

[Pywikipedia-bugs] [Maniphest] [Commented On] T303175: Error 1062 from Flow\Data\Storage\RevisionStorage::insert, {error} {sql1line} {db_server}

2022-04-26 Thread kostajh 
kostajh added a comment.


  In T303175#7880519 , @Tgr 
wrote:
  
  > Are the board/topic names in the Pywikibot test randomised, or is this just 
a case of a single Flow board being corrupted in some way and the bot 
repeatedly trying to access it?
  
  The code is here 
https://github.com/wikimedia/pywikibot/blob/master/tests/flow_edit_tests.py . 
Looks like it's https://test.wikipedia.org/wiki/Talk:Pywikibot_test. But I am 
not sure if it is corrupted.

TASK DETAIL
  https://phabricator.wikimedia.org/T303175

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: kostajh
Cc: Tgr, Xqt, pywikibot-bugs-list, mewoph, Aklapper, kostajh, Susie413113, 
Lectrician1, caldera, Jyoo1011, IdtrA, JohnsonLee01, SHEKH, Dijkstra, 
NavinRizwi, ItamarWMDE, Khutuck, Zkhalido, darthmon_wmde, Rosalie_WMDE, Viztor, 
94rain, Wenyi, Jayprakash12345, Nattes, Tbscho, MayS, EnricoCNC, Mdupont, 
JJMC89, Dvorapa, Altostratus, Taiwania_Justo, Avicennasis, Wong128hk, Verdy_p, 
mys_721tx, geraki, Gryllida, jeblad, jayvdb, Catrope, Masti, Alchimista, 
Jdforrester-WMF, Jay8g
___
pywikibot-bugs mailing list -- pywikibot-bugs@lists.wikimedia.org
To unsubscribe send an email to pywikibot-bugs-le...@lists.wikimedia.org

[Pywikipedia-bugs] [Maniphest] [Commented On] T303175: Error 1062 from Flow\Data\Storage\RevisionStorage::insert, {error} {sql1line} {db_server}

2022-04-26 Thread Tgr 
Tgr added a comment.


  Are the board/topic names in the Pywikibot test randomised, or is this just a 
case of a single Flow board being corrupted in some way and the bot repeatedly 
trying to access it?

TASK DETAIL
  https://phabricator.wikimedia.org/T303175

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Tgr
Cc: Tgr, Xqt, pywikibot-bugs-list, mewoph, Aklapper, kostajh, Susie413113, 
Lectrician1, caldera, Jyoo1011, IdtrA, JohnsonLee01, SHEKH, Dijkstra, 
NavinRizwi, ItamarWMDE, Khutuck, Zkhalido, darthmon_wmde, Rosalie_WMDE, Viztor, 
94rain, Wenyi, Jayprakash12345, Nattes, Tbscho, MayS, EnricoCNC, Mdupont, 
JJMC89, Dvorapa, Altostratus, Taiwania_Justo, Avicennasis, Wong128hk, Verdy_p, 
mys_721tx, geraki, Gryllida, jeblad, jayvdb, Catrope, Masti, Alchimista, 
Jdforrester-WMF, Jay8g
___
pywikibot-bugs mailing list -- pywikibot-bugs@lists.wikimedia.org
To unsubscribe send an email to pywikibot-bugs-le...@lists.wikimedia.org

[Pywikipedia-bugs] [Maniphest] [Commented On] T303175: Error 1062 from Flow\Data\Storage\RevisionStorage::insert, {error} {sql1line} {db_server}

2022-03-24 Thread Xqt 
Xqt added a comment.


  Here an acutal issue:
  
2022-03-24T13:08:42.7951226Z === FAILURES 
===
2022-03-24T13:08:42.7951615Z ___ 
TestFlowLockTopic.test_lock_unlock_topic ___
2022-03-24T13:08:42.7951845Z 
2022-03-24T13:08:42.7952072Z self = 

2022-03-24T13:08:42.7952331Z 
2022-03-24T13:08:42.7952463Z def test_lock_unlock_topic(self):
2022-03-24T13:08:42.7952771Z """Lock and unlock a test topic."""
2022-03-24T13:08:42.7953031Z # Setup
2022-03-24T13:08:42.7953631Z topic = Topic(self.site, 
'Topic:Sn12rdih4iducjsd')
2022-03-24T13:08:42.7953943Z if topic.is_locked:
2022-03-24T13:08:42.7954232Z >   topic.unlock(MODERATION_REASON)
2022-03-24T13:08:42.7954416Z 
2022-03-24T13:08:42.7954537Z tests/flow_edit_tests.py:174: 
2022-03-24T13:08:42.7954825Z _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
2022-03-24T13:08:42.7955123Z pywikibot/flow.py:263: in unlock
2022-03-24T13:08:42.7955434Z self.site.lock_topic(self, False, reason)
2022-03-24T13:08:42.7956176Z pywikibot/site/_decorators.py:92: in callee
2022-03-24T13:08:42.7956475Z return fn(self, *args, **kwargs)
2022-03-24T13:08:42.7956784Z pywikibot/site/_decorators.py:60: in callee
2022-03-24T13:08:42.7957086Z return fn(self, *args, **kwargs)
2022-03-24T13:08:42.7957404Z pywikibot/site/_extensions.py:528: in 
lock_topic
2022-03-24T13:08:42.7957683Z data = req.submit()
2022-03-24T13:08:42.7957959Z pywikibot/data/api.py:1822: in submit
2022-03-24T13:08:42.7958288Z if self._internal_api_error(code, error, 
result):
2022-03-24T13:08:42.7958629Z pywikibot/data/api.py:1673: in 
_internal_api_error
2022-03-24T13:08:42.7958899Z self.wait()
2022-03-24T13:08:42.7959171Z _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
2022-03-24T13:08:42.7959349Z 
2022-03-24T13:08:42.7960171Z self = 
pywikibot.data.api.Request'/w/api.php?action=flow=Topic:Sn12rdih4iducjsd=lock-topic=Pywikibot+test=unlock=5=json=0338df8e93639a5bc1ba6907ba15c7c0623c6794+\\'>
2022-03-24T13:08:42.7960785Z delay = None
2022-03-24T13:08:42.7960930Z 
2022-03-24T13:08:42.7961049Z def wait(self, delay=None):
2022-03-24T13:08:42.7961367Z """Determine how long to wait after a 
failed request."""
2022-03-24T13:08:42.7961688Z self.current_retries += 1
2022-03-24T13:08:42.7961997Z if self.current_retries > 
self.max_retries:
2022-03-24T13:08:42.7962486Z >   raise TimeoutError('Maximum 
retries attempted without success.')
2022-03-24T13:08:42.7962937Z E   pywikibot.exceptions.TimeoutError: 
Maximum retries attempted without success.
2022-03-24T13:08:42.7963215Z 
2022-03-24T13:08:42.7963356Z pywikibot/data/api.py:1899: TimeoutError
2022-03-24T13:08:42.7963859Z -- Captured log 
setup --
2022-03-24T13:08:42.7964332Z VERBOSE  pywiki:logging.py:106 Found 1 
wikipedia:test processes running, including this one.
2022-03-24T13:08:42.7964913Z - Captured stdout 
call -
2022-03-24T13:08:42.7965236Z  36.544s 
2022-03-24T13:08:42.7965673Z -- Captured log 
call ---
2022-03-24T13:08:42.7966556Z WARNING  pywiki:logging.py:106 API error 
internal_api_error_DBQueryError: [4fbb03d3-f508-4bf1-a78f-7d0c60376fca] 
Exception caught: A database query error has occurred. This may indicate a bug 
in the software.
2022-03-24T13:08:42.7967112Z VERBOSE  pywiki:logging.py:106
headers=
2022-03-24T13:08:42.7970991Z {'date': 'Thu, 24 Mar 2022 12:44:04 GMT', 
'server': 'mw1381.eqiad.wmnet', 'x-content-type-options': 'nosniff', 
'mediawiki-api-error': 'internal_api_error_DBQueryError', 'x-frame-options': 
'DENY', 'content-disposition': 'inline; filename=api-result.json', 
'cache-control': 'private, max-age=0, s-maxage=0', 'vary': 'Accept-Encoding', 
'set-cookie': 'cpPosIndex=2%401648125844%239ac33e8c493d80136e6f7f7ad3634ae1; 
expires=Thu, 24-Mar-2022 12:44:14 GMT; Max-Age=10; path=/; secure; HttpOnly, 
UseDC=master; expires=Thu, 24-Mar-2022 12:44:14 GMT; Max-Age=10; path=/; 
secure; HttpOnly, UseCDNCache=false; expires=Thu, 24-Mar-2022 12:44:14 GMT; 
Max-Age=10; path=/; secure; HttpOnly', 'content-type': 'application/json; 
charset=utf-8', 'content-encoding': 'gzip', 'age': '0', 'x-cache': 'cp1077 
miss, cp1081 pass', 'x-cache-status': 'pass', 'server-timing': 
'cache;desc="pass", host;desc="cp1081"', 'strict-transport-security': 
'max-age=106384710; includeSubDomains; preload', 'report-to': '{ "group": 
"wm_nel", "max_age": 86400, "endpoints": [{ "url":

[Pywikipedia-bugs] [Maniphest] [Commented On] T303175: Error 1062 from Flow\Data\Storage\RevisionStorage::insert, {error} {sql1line} {db_server}

2022-03-23 Thread kostajh 
kostajh added a comment.


  In T303175#7776647 , @Xqt 
wrote:
  
  >> perhaps the Pywikibot maintainers could see what is happening with the 
code path that is calling "restore-post" on testwiki?
  >
  > You can find the CI log here 
.
 Just search for `flow_edit_tests` or `restore`. The corresponding API error 
message is shown there.
  
  Sorry, just saw this and that link says the URI is expired. I'm looking at 
https://github.com/wikimedia/pywikibot/actions and am unfamiliar with logs on 
Github actions; if you could point me towards where to find the logs I'd 
appreciate it. Thanks!

TASK DETAIL
  https://phabricator.wikimedia.org/T303175

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: kostajh
Cc: Xqt, pywikibot-bugs-list, mewoph, Aklapper, kostajh, Susie413113, 
Lectrician1, caldera, Jyoo1011, IdtrA, JohnsonLee01, SHEKH, Dijkstra, 
NavinRizwi, ItamarWMDE, Khutuck, Zkhalido, darthmon_wmde, Rosalie_WMDE, Viztor, 
94rain, Wenyi, Jayprakash12345, Nattes, Tbscho, MayS, EnricoCNC, Mdupont, 
JJMC89, Dvorapa, Altostratus, Taiwania_Justo, Avicennasis, Wong128hk, Verdy_p, 
mys_721tx, geraki, Gryllida, jeblad, jayvdb, Catrope, Masti, Alchimista, 
Jdforrester-WMF, Jay8g
___
pywikibot-bugs mailing list -- pywikibot-bugs@lists.wikimedia.org
To unsubscribe send an email to pywikibot-bugs-le...@lists.wikimedia.org

[Pywikipedia-bugs] [Maniphest] [Commented On] T303175: Error 1062 from Flow\Data\Storage\RevisionStorage::insert, {error} {sql1line} {db_server}

2022-03-15 Thread Xqt 
Xqt added a comment.


  > perhaps the Pywikibot maintainers could see what is happening with the code 
path that is calling "restore-post" on testwiki?
  
  I've activated write tests in testwiki recently. Perhaps I can find some 
hints in our CI log.

TASK DETAIL
  https://phabricator.wikimedia.org/T303175

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Xqt
Cc: Xqt, pywikibot-bugs-list, mewoph, Aklapper, kostajh, Lectrician1, caldera, 
Jyoo1011, IdtrA, JohnsonLee01, SHEKH, Dijkstra, NavinRizwi, ItamarWMDE, 
Khutuck, Zkhalido, darthmon_wmde, Rosalie_WMDE, Viztor, 94rain, Wenyi, 
Jayprakash12345, Nattes, Tbscho, MayS, EnricoCNC, Mdupont, JJMC89, Dvorapa, 
Altostratus, Taiwania_Justo, Avicennasis, Wong128hk, Verdy_p, mys_721tx, 
geraki, Gryllida, jeblad, jayvdb, Catrope, Masti, Alchimista, Jdforrester-WMF, 
Jay8g
___
pywikibot-bugs mailing list -- pywikibot-bugs@lists.wikimedia.org
To unsubscribe send an email to pywikibot-bugs-le...@lists.wikimedia.org