Database error

From Apache OpenOffice Wiki
Jump to: navigation, search

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

  • Query:
    (SELECT rc_id,rc_timestamp,rc_user,rc_user_text,rc_namespace,rc_title,rc_comment,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type,rc_source,rc_patrolled,rc_ip,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,(SELECT GROUP_CONCAT(ct_tag SEPARATOR ',') FROM `change_tag` WHERE ct_rc_id=rc_id ) AS ts_tags FROM `recentchanges` INNER JOIN `pagelinks` ON ((rc_namespace = pl_namespace) AND (rc_title = pl_title)) WHERE rc_minor = '0' AND rc_bot = '1' AND (rc_timestamp >= '20240318000000') AND (( rc_log_type IS NULL OR ( rc_log_type != 'newusers' ) )) AND pl_from = '28833' ORDER BY rc_timestamp DESC LIMIT 250 ) UNION (SELECT rc_id,rc_timestamp,rc_user,rc_user_text,rc_namespace,rc_title,rc_comment,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type,rc_source,rc_patrolled,rc_ip,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,(SELECT GROUP_CONCAT(ct_tag SEPARATOR ',') FROM `change_tag` WHERE ct_rc_id=rc_id ) AS ts_tags FROM `recentchanges` INNER JOIN `templatelinks` ON ((rc_namespace = tl_namespace) AND (rc_title = tl_title)) WHERE rc_minor = '0' AND rc_bot = '1' AND (rc_timestamp >= '20240318000000') AND (( rc_log_type IS NULL OR ( rc_log_type != 'newusers' ) )) AND tl_from = '28833' ORDER BY rc_timestamp DESC LIMIT 250 ) UNION (SELECT rc_id,rc_timestamp,rc_user,rc_user_text,rc_namespace,rc_title,rc_comment,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type,rc_source,rc_patrolled,rc_ip,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,(SELECT GROUP_CONCAT(ct_tag SEPARATOR ',') FROM `change_tag` WHERE ct_rc_id=rc_id ) AS ts_tags FROM `recentchanges` INNER JOIN `imagelinks` ON ((rc_title = il_to)) WHERE rc_minor = '0' AND rc_bot = '1' AND (rc_timestamp >= '20240318000000') AND (( rc_log_type IS NULL OR ( rc_log_type != 'newusers' ) )) AND il_from = '28833' AND rc_namespace = '6' ORDER BY rc_timestamp DESC LIMIT 250 ) ORDER BY rc_timestamp DESC LIMIT 250
  • Function: SpecialRecentChangesLinked::doMainQuery
  • Error: 1213 Deadlock found when trying to get lock; try restarting transaction (127.0.0.1)

Backtrace:

#0 /x1/mediawiki-1.23.13/includes/db/Database.php(1123): DatabaseBase->reportQueryError()
#1 /x1/mediawiki-1.23.13/includes/specials/SpecialRecentchangeslinked.php(215): DatabaseBase->query()
#2 /x1/mediawiki-1.23.13/includes/specialpage/ChangesListSpecialPage.php(84): SpecialRecentChangesLinked->doMainQuery()
#3 /x1/mediawiki-1.23.13/includes/specialpage/ChangesListSpecialPage.php(52): ChangesListSpecialPage->getRows()
#4 /x1/mediawiki-1.23.13/includes/specials/SpecialRecentchanges.php(60): ChangesListSpecialPage->execute()
#5 /x1/mediawiki-1.23.13/includes/specialpage/SpecialPage.php(379): SpecialRecentChanges->execute()
#6 /x1/mediawiki-1.23.13/includes/specialpage/SpecialPageFactory.php(503): SpecialPage->run()
#7 /x1/mediawiki-1.23.13/includes/Wiki.php(279): SpecialPageFactory::executePath()
#8 /x1/mediawiki-1.23.13/includes/Wiki.php(647): MediaWiki->performRequest()
#9 /x1/mediawiki-1.23.13/includes/Wiki.php(506): MediaWiki->main()
#10 /x1/mediawiki-1.23.13/index.php(46): MediaWiki->run()
#11 {main}
Views
Personal tools