Page MenuHomePhabricator

Error: table 'fwonline' is full
Open, Needs TriagePublic

Description

After quite some time of running, the wiki throws the following error on trying to log in our out:

[05cd51e470bba66049647684] /w/index.php?title=Special:UserLogout&returnto=Correspondence+Collections Wikimedia\Rdbms\DBQueryError from line 1713 of /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?


Error 1114: The table 'fwonline' is full (localhost)
Function: WhosOnlineHooks::onBeforePageDisplay
Query: INSERT INTO `fwonline` (userid,username,timestamp) VALUES (0,'194.166.117.58','20231202161633') ON DUPLICATE KEY UPDATE timestamp = '20231202161633'

Backtrace:

#0 /includes/libs/rdbms/database/Database.php(1697): Wikimedia\Rdbms\Database->getQueryException()
#1 /includes/libs/rdbms/database/Database.php(1672): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
#2 /includes/libs/rdbms/database/Database.php(1241): Wikimedia\Rdbms\Database->reportQueryError()
#3 /includes/libs/rdbms/database/DatabaseMysqlBase.php(1358): Wikimedia\Rdbms\Database->query()
#4 /includes/libs/rdbms/database/Database.php(3363): Wikimedia\Rdbms\DatabaseMysqlBase->doUpsert()
#5 /includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->upsert()
#6 /includes/libs/rdbms/database/DBConnRef.php(504): Wikimedia\Rdbms\DBConnRef->__call()
#7 /var/vps-wiki-config/extensions/ext-KM-A/WhosOnline/includes/WhosOnlineHooks.php(39): Wikimedia\Rdbms\DBConnRef->upsert()
#8 [internal function]: WhosOnlineHooks::{closure}()
#9 /includes/libs/rdbms/database/Database.php(4118): call_user_func()
#10 /includes/libs/rdbms/database/Database.php(3920): Wikimedia\Rdbms\Database->runOnTransactionIdleCallbacks()
#11 /includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->onTransactionCommitOrIdle()
#12 /includes/libs/rdbms/database/DBConnRef.php(600): Wikimedia\Rdbms\DBConnRef->__call()
#13 /var/vps-wiki-config/extensions/ext-KM-A/WhosOnline/includes/WhosOnlineHooks.php(45): Wikimedia\Rdbms\DBConnRef->onTransactionCommitOrIdle()
#14 /includes/HookContainer/HookContainer.php(329): WhosOnlineHooks::onBeforePageDisplay()
#15 /includes/HookContainer/HookContainer.php(132): MediaWiki\HookContainer\HookContainer->callLegacyHook()
#16 /includes/HookContainer/HookRunner.php(991): MediaWiki\HookContainer\HookContainer->run()
#17 /includes/OutputPage.php(2617): MediaWiki\HookContainer\HookRunner->onBeforePageDisplay()
#18 /includes/MediaWiki.php(954): OutputPage->output()
#19 /includes/MediaWiki.php(967): MediaWiki->{closure}()
#20 /includes/MediaWiki.php(547): MediaWiki->main()
#21 /index.php(53): MediaWiki->run()
#22 /index.php(46): wfIndexMain()
#23 {main}

Is there some kind of maintenance requested? Running update.php did not help. Had to deactivate the extension to being able to log in again.

MediaWiki 1.35.8
PHP 7.4.3-4ubuntu2.19 (fpm-fcgi)
MariaDB 10.3.38-MariaDB-0ubuntu0.20.04.
Who's Online 1.7.0