Page MenuHomePhabricator

Database error when trying to edit a file page on Commons
Closed, DuplicatePublic

Description

https://commons.wikimedia.org/w/index.php?title=File:Verhalentafel.jpg&action=submit

Database error
Jump to navigationJump to search
A database query error has occurred. This may indicate a bug in the software.

[WzPjdwpAADsAAG3VnbIAAAAB] 2018-06-27 19:20:39: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

I just tried to updated a link and license. Nothing interesting.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 27 2018, 7:23 PM

Just uploaded a screenshot, cropped it a bit, tried to upload a new version over it, guess what?

Database error
A database query error has occurred. This may indicate a bug in the software.

[WzPlqwpAIDAAAENRhT8AAADP] 2018-06-27 19:30:05: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

Looked up the error in Logstash:

[WzPjdwpAADsAAG3VnbIAAAAB] /w/index.php?title=File:Verhalentafel.jpg&action=submit   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 ('308334420','4')
Function: CommentStore::insertInternal
Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.48.23)
[WzPlqwpAIDAAAENRhT8AAADP] /wiki/Special:Upload   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 ('308335000','18060084')
Function: CommentStore::insertInternal
Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.48.23)

(For future reference, you can also upload screenshots to Phabricator – use the icon on the toolbar, or https://phabricator.wikimedia.org/file/upload/. Thank you for reporting bugs :) )