Page MenuHomePhabricator

Received error: internal_api_error_DBQueryError with CropTool
Closed, DuplicatePublic

Description

Hi, I get

Upload failed! [api] Received error: internal_api_error_DBQueryError : [WzPnvApAMEIAAIMLcrIAAABE] Database query error.

when using CropTool on this file https://commons.wikimedia.org/wiki/File:Marcelle_Lender,_par_Jean_Reutlinger,_btv1b85969082-p013.jpg
I get this both saving as an external file, and overloading.
I am trying to create 2 separate files, as the persons on the top and bottom are different.

Event Timeline

Yann created this task.Jun 27 2018, 7:42 PM
Restricted Application added subscribers: Danmichaelo, Aklapper. · View Herald TranscriptJun 27 2018, 7:42 PM

I can't look up the error ID in Logstash for some reason, but I'll make a guess that this is the same issue as T198350: Rising lock wait timeout SQL errors upon 1.32.0-wmf.10 group1 deployment.

DC added a subscriber: DC.Jun 27 2018, 7:55 PM
Addshore added a subscriber: Addshore.EditedJun 28 2018, 9:32 AM

Not sure why I couldnt find it on logstash, but found it in the raw log:

addshore@mwlog1001:/srv/mw-log/archive$ cat exception.log-20180628 |grep -A 20 WzPnvApAMEIAAIMLcrIAAABE
2018-06-27 19:38:52 [WzPnvApAMEIAAIMLcrIAAABE] mw1231 commonswiki 1.32.0-wmf.10 exception ERROR: [WzPnvApAMEIAAIMLcrIAAABE] [no req]   Wikimedia\Rdbms\DBQueryError from line 1443 of /srv/mediawiki/php-1.32.0-wmf.10/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: INSERT  INTO `revision_comment_temp` (revcomment_rev,revcomment_comment_id) VALUES ('XXX','XXX')
Function: CommentStore::insertInternal
Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.48.23)
 {"exception_id":"WzPnvApAMEIAAIMLcrIAAABE","exception_url":"[no req]","caught_by":"mwe_handler"}
[Exception Wikimedia\Rdbms\DBQueryError] (/srv/mediawiki/php-1.32.0-wmf.10/includes/libs/rdbms/database/Database.php:1443) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: INSERT  INTO `revision_comment_temp` (revcomment_rev,revcomment_comment_id) VALUES ('XXX','XXX')
Function: CommentStore::insertInternal
Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.48.23)