![]() ![]() Java.base/.invoke(DelegatingMethodAccessorImpl. Deadlock found when trying to get lock try restarting transaction za upit UPDATE wpposts as pt JOIN ( SELECT ID, (rownumber:rownumber 1) AS rank FROM wpposts WHERE posttype ‘post’ AND poststatus IN ( ‘publish’, ‘pending’, ‘draft’, ‘private’, ‘future’ ) ORDER BY menuorder ASC ) as pt2 ON pt.id pt2. That is unlikely to be the cause of the deadlock, but it is certainly making it harder to pin down and find potential fields that can cause locks or more generally know what is being used.ERROR (default task-7) Unrelated, but I do note that it is suspicious to have a wildcard SELECT query in production code. #18 /srv/mediawiki/w/api.php(3): require(string) #15 /srv/mediawiki/php-1.39.0-wmf.26/includes/api/ApiMain.php(846): ApiMain->executeActionWithErrorHandling() #13 /srv/mediawiki/php-1.39.0-wmf.26/includes/api/ApiMain.php(1900): ContentTranslation\ActionApi\ApiContentTranslationSave->execute() The other SQL statements that are running in the MySQL database. #12 /srv/mediawiki/php-1.39.0-wmf.26/extensions/ContentTranslation/includes/ActionApi/ApiContentTranslationSave.php(116): ContentTranslation\ActionApi\ApiContentTranslationSave->saveTranslationUnits(array, ContentTranslation\Translation) Trying To Debug 'Deadlock found when trying to get lock try restarting transaction' Errors In Lucee CFML 5.2.9.40 The SQL statement that raised the error (if it exists). #11 /srv/mediawiki/php-1.39.0-wmf.26/extensions/ContentTranslation/includes/ActionApi/ApiContentTranslationSave.php(188): ContentTranslation\Store\TranslationCorporaStore->save(ContentTranslation\TranslationUnit, boolean) #10 /srv/mediawiki/php-1.39.0-wmf.26/extensions/ContentTranslation/includes/Store/TranslationCorporaStore.php(171): Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure) #9 /srv/mediawiki/php-1.39.0-wmf.26/includes/libs/rdbms/database/DBConnRef.php(663): Wikimedia\Rdbms\DBConnRef->_call(string, array) #8 /srv/mediawiki/php-1.39.0-wmf.26/includes/libs/rdbms/database/DBConnRef.php(103): Wikimedia\Rdbms\Database->doAtomicSection(string, Closure) Closed rmst opened this issue 6 comments Closed Deadlock found when trying to. #6 /srv/mediawiki/php-1.35.0-wmf.37/includes/libs/rdbms/database/Database.php(4264): ContentTranslation\TranslationStorageManager::ContentTranslation\(Wikimedia\Rdbms\DatabaseMysqli, string) Deadlock found when trying to get lock try restarting transaction 280. #5 /srv/mediawiki/php-1.35.0-wmf.37/extensions/ContentTranslation/includes/TranslationStorageManager.php(145): ContentTranslation\TranslationStorageManager::doFind(Wikimedia\Rdbms\DatabaseMysqli, array, array, string) #4 /srv/mediawiki/php-1.35.0-wmf.37/extensions/ContentTranslation/includes/TranslationStorageManager.php(160): Wikimedia\Rdbms\Database->selectRow(string, string, array, string, array) #3 /srv/mediawiki/php-1.35.0-wmf.37/includes/libs/rdbms/database/Database.php(1975): Wikimedia\Rdbms\Database->select(string, string, array, string, array, array) #2 /srv/mediawiki/php-1.35.0-wmf.37/includes/libs/rdbms/database/Database.php(1879): Wikimedia\Rdbms\Database->query(string, string, integer) ![]() #1 /srv/mediawiki/php-1.35.0-wmf.37/includes/libs/rdbms/database/Database.php(1215): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean) #0 /srv/mediawiki/php-1.35.0-wmf.37/includes/libs/rdbms/database/Database.php(1640): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |