Erreur de la base de données
(SELECT `mw_recentchanges`.*,ts_tags FROM `mw_recentchanges` LEFT JOIN `mw_tag_summary` ON ((ts_rc_id=rc_id)) INNER JOIN `mw_pagelinks` ON ((rc_namespace = pl_namespace AND rc_title = pl_title)) WHERE (rc_timestamp >= '20240719000000') AND rc_bot = '0' AND (rc_user = 0) AND (rc_user_text != '18.117.183.99') AND pl_from = '1063' ORDER BY rc_timestamp DESC LIMIT 50 ) UNION (SELECT `mw_recentchanges`.*,ts_tags FROM `mw_recentchanges` LEFT JOIN `mw_tag_summary` ON ((ts_rc_id=rc_id)) INNER JOIN `mw_templatelinks` ON ((rc_namespace = tl_namespace AND rc_title = tl_title)) WHERE (rc_timestamp >= '20240719000000') AND rc_bot = '0' AND (rc_user = 0) AND (rc_user_text != '18.117.183.99') AND tl_from = '1063' ORDER BY rc_timestamp DESC LIMIT 50 ) UNION (SELECT `mw_recentchanges`.*,ts_tags FROM `mw_recentchanges` LEFT JOIN `mw_tag_summary` ON ((ts_rc_id=rc_id)) INNER JOIN `mw_imagelinks` ON ((rc_title = il_to)) WHERE (rc_timestamp >= '20240719000000') AND rc_bot = '0' AND (rc_user = 0) AND (rc_user_text != '18.117.183.99') AND il_from = '1063' AND rc_namespace = '6' ORDER BY rc_timestamp DESC LIMIT 50 ) ORDER BY rc_timestamp DESC LIMIT 50depuis la fonction « SpecialRecentchangeslinked::doMainQuery ». La base de données a renvoyé l’erreur « 1213 : Deadlock found when trying to get lock; try restarting transaction (formationnmercur.mysql.db) ».
Backtrace:
#0 /home/formationn/www/mercurewiki/includes/db/Database.php(751): DatabaseBase->reportQueryError('Deadlock found ...', 1213, '(SELECT `mw_re...', 'SpecialRecentch...', false)
#1 /home/formationn/www/mercurewiki/includes/specials/SpecialRecentchangeslinked.php(200): DatabaseBase->query('(SELECT `mw_re...', 'SpecialRecentch...')
#2 /home/formationn/www/mercurewiki/includes/specials/SpecialRecentchanges.php(136): SpecialRecentchangeslinked->doMainQuery(Array, Object(FormOptions))
#3 /home/formationn/www/mercurewiki/includes/SpecialPage.php(578): SpecialRecentChanges->execute(NULL)
#4 /home/formationn/www/mercurewiki/includes/Wiki.php(262): SpecialPage::executePath(Object(Title))
#5 /home/formationn/www/mercurewiki/includes/Wiki.php(63): MediaWiki->handleSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest))
#6 /home/formationn/www/mercurewiki/index.php(114): MediaWiki->performRequestForTitle(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest))
#7 /home/formationn/www/mercurewiki/index.php5(1): require('/home/formation...')
#8 {main}