Topic on Extension talk:WhosOnline/Archive 3

table 'fwonline' is full

3
Krabina (talkcontribs)

After quite some time of running, the wiki throws the following error

[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.

Krabina (talkcontribs)
Silkwood (talkcontribs)

Same horror here but the table is now:

Error 1114: The table 'online' is full (localhost)

Select count(*) from online=16

Product Version
MediaWiki 1.40.1
PHP 7.4.3-4ubuntu2.19 (apache2handler)
ICU 66.1
MariaDB 10.3.38-MariaDB-0ubuntu0.20.04.1
Pygments 2.11.2
Lua 5.1.5
LilyPond 2.20.0
Elasticsearch 7.10.2
Reply to "table 'fwonline' is full"