Database error

Jump to navigation Jump to search

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

[d6ca76291d02cbc648af48fe] /wiki/Special:RecentChangesLinked/2011-07-05:_CFP:_WikiViz_2011_-_Visualizing_the_impact_of_Wikipedia Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 1021: Disk full (/tmp/#sql-temptable-3667be-1b6230-81828.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Function: SpecialRecentChangesLinked::doMainQuery
Query: SELECT * FROM ((SELECT rc_id,rc_timestamp,rc_namespace,rc_title,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,rc_actor,recentchanges_actor.actor_user AS `rc_user`,recentchanges_actor.actor_name AS `rc_user_text`,comment_rc_comment.comment_text AS `rc_comment_text`,comment_rc_comment.comment_data AS `rc_comment_data`,comment_rc_comment.comment_id AS `rc_comment_cid`,page_latest,(SELECT GROUP_CONCAT(ctd_name SEPARATOR ',') FROM `change_tag` JOIN `change_tag_def` ON ((ct_tag_id=ctd_id)) WHERE ct_rc_id=rc_id ) AS `ts_tags` FROM `recentchanges` STRAIGHT_JOIN `actor` `recentchanges_actor` ON ((actor_id=rc_actor)) STRAIGHT_JOIN `comment` `comment_rc_comment` ON ((comment_rc_comment.comment_id = rc_comment_id)) LEFT JOIN `page` ON ((rc_cur_id=page_id)) JOIN `pagelinks` ON ((rc_namespace = pl_namespace) AND (rc_title = pl_title)) WHERE rc_bot = 0 AND (rc_timestamp >= '20240321102820') AND pl_from = 6169 ORDER BY rc_timestamp DESC LIMIT 50 ) UNION (SELECT rc_id,rc_timestamp,rc_namespace,rc_title,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,rc_actor,recentchanges_actor.actor_user AS `rc_user`,recentchanges_actor.actor_name AS `rc_user_text`,comment_rc_comment.comment_text AS `rc_comment_text`,comment_rc_comment.comment_data AS `rc_comment_data`,comment_rc_comment.comment_id AS `rc_comment_cid`,page_latest,(SELECT GROUP_CONCAT(ctd_name SEPARATOR ',') FROM `change_tag` JOIN `change_tag_def` ON ((ct_tag_id=ctd_id)) WHERE ct_rc_id=rc_id ) AS `ts_tags` FROM `recentchanges` STRAIGHT_JOIN `actor` `recentchanges_actor` ON ((actor_id=rc_actor)) STRAIGHT_JOIN `comment` `comment_rc_comment` ON ((comment_rc_comment.comment_id = rc_comment_id)) LEFT JOIN `page` ON ((rc_cur_id=page_id)) JOIN `linktarget` ON ((rc_namespace = lt_namespace) AND (rc_title = lt_title)) JOIN `templatelinks` ON ((tl_target_id=lt_id)) WHERE rc_bot = 0 AND (rc_timestamp >= '20240321102820') AND tl_from = 6169 ORDER BY rc_timestamp DESC LIMIT 50 ) UNION (SELECT rc_id,rc_timestamp,rc_namespace,rc_title,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,rc_actor,recentchanges_actor.actor_user AS `rc_user`,recentchanges_actor.actor_name AS `rc_user_text`,comment_rc_comment.comment_text AS `rc_comment_text`,comment_rc_comment.comment_data AS `rc_comment_data`,comment_rc_comment.comment_id AS `rc_comment_cid`,page_latest,(SELECT GROUP_CONCAT(ctd_name SEPARATOR ',') FROM `change_tag` JOIN `change_tag_def` ON ((ct_tag_id=ctd_id)) WHERE ct_rc_id=rc_id ) AS `ts_tags` FROM `recentchanges` STRAIGHT_JOIN `actor` `recentchanges_actor` ON ((actor_id=rc_actor)) STRAIGHT_JOIN `comment` `comment_rc_comment` ON ((comment_rc_comment.comment_id = rc_comment_id)) LEFT JOIN `page` ON ((rc_cur_id=page_id)) JOIN `imagelinks` ON ((rc_title = il_to)) WHERE rc_bot = 0 AND (rc_timestamp >= '20240321102820') AND il_from = 6169 AND rc_namespace = 6 ORDER BY rc_timestamp DESC LIMIT 50 )) `main` ORDER BY rc_timestamp DESC LIMIT 50

Backtrace:

from /home/infovis-wiki/infovis-wiki.net/w/includes/libs/rdbms/database/Database.php(1524)
#0 /home/infovis-wiki/infovis-wiki.net/w/includes/libs/rdbms/database/Database.php(1508): Wikimedia\Rdbms\Database->getQueryException()
#1 /home/infovis-wiki/infovis-wiki.net/w/includes/libs/rdbms/database/Database.php(1482): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
#2 /home/infovis-wiki/infovis-wiki.net/w/includes/libs/rdbms/database/Database.php(855): Wikimedia\Rdbms\Database->reportQueryError()
#3 /home/infovis-wiki/infovis-wiki.net/w/includes/libs/rdbms/database/Database.php(1629): Wikimedia\Rdbms\Database->query()
#4 /home/infovis-wiki/infovis-wiki.net/w/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->select()
#5 /home/infovis-wiki/infovis-wiki.net/w/includes/libs/rdbms/database/DBConnRef.php(344): Wikimedia\Rdbms\DBConnRef->__call()
#6 /home/infovis-wiki/infovis-wiki.net/w/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(652): Wikimedia\Rdbms\DBConnRef->select()
#7 /home/infovis-wiki/infovis-wiki.net/w/includes/specials/SpecialRecentChangesLinked.php(297): Wikimedia\Rdbms\SelectQueryBuilder->fetchResultSet()
#8 /home/infovis-wiki/infovis-wiki.net/w/includes/specialpage/ChangesListSpecialPage.php(940): SpecialRecentChangesLinked->doMainQuery()
#9 /home/infovis-wiki/infovis-wiki.net/w/includes/specialpage/ChangesListSpecialPage.php(638): ChangesListSpecialPage->getRows()
#10 /home/infovis-wiki/infovis-wiki.net/w/includes/specials/SpecialRecentChanges.php(208): ChangesListSpecialPage->execute()
#11 /home/infovis-wiki/infovis-wiki.net/w/includes/specialpage/SpecialPage.php(701): SpecialRecentChanges->execute()
#12 /home/infovis-wiki/infovis-wiki.net/w/includes/specialpage/SpecialPageFactory.php(1475): SpecialPage->run()
#13 /home/infovis-wiki/infovis-wiki.net/w/includes/MediaWiki.php(327): MediaWiki\SpecialPage\SpecialPageFactory->executePath()
#14 /home/infovis-wiki/infovis-wiki.net/w/includes/MediaWiki.php(923): MediaWiki->performRequest()
#15 /home/infovis-wiki/infovis-wiki.net/w/includes/MediaWiki.php(576): MediaWiki->main()
#16 /home/infovis-wiki/infovis-wiki.net/w/index.php(50): MediaWiki->run()
#17 /home/infovis-wiki/infovis-wiki.net/w/index.php(46): wfIndexMain()
#18 {main}