XF 2.0 The table 'xf_session_activity' is full (after upgrade to xenforo 2 from 1)

Kelso

Member
I have been dorment for a while. Decided to upgrade to xenforo 2.0.4 and am now getting this message. Any idea how to fix it? Googling around I found some generic advise, but this is odd as the table has 6 entries, but does show some overhead in phpMyAdmin.
  • XF\Db\Exception: MySQL query error [1114]: The table 'xf_session_activity' is full
  • src/XF/Db/AbstractStatement.php:212
-- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)

------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1114, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1114, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Repository/SessionActivity.php(158): XF\Db\AbstractAdapter->query('\r\n\t\t\t-- XFDB=no...', Array)
#4 src/XF/Pub/Controller/AbstractController.php(65): XF\Repository\SessionActivity->updateSessionActivity(1, '73.217.108.231', 'XF\\Pub\\Controll...', 'List', Array, 'valid', '')
#5 src/XF/Pub/Controller/AbstractController.php(40): XF\Pub\Controller\AbstractController->updateSessionActivity('List', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#6 src/XF/Mvc/Controller.php(270): XF\Pub\Controller\AbstractController->postDispatchType('List', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#7 src/XF/Mvc/Dispatcher.php(271): XF\Mvc\Controller->postDispatch('List', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#8 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF\\Pub\\Controll...', 'List', 'html', Object(XF\Mvc\ParameterBag), 'forums', Object(XF\Pub\Controller\Forum), Object(XF\Mvc\Reply\Reroute))
#9 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(1891): XF\Mvc\Dispatcher->run()
#11 src/XF.php(328): XF\App->run()
#12 index.php(13): XF::runApp('XF\\Pub\\App')
#13 {main}
 
Code:
XF\Db\Exception: MySQL query error [1114]: The table 'xf_session_activity' is full src/XF/Db/AbstractStatement.php:230
Generated by: Unknown account Apr 8, 2022 at 6:10 PM
Stack trace
            -- XFDB=noForceAllWrite
            INSERT INTO xf_session_activity
                (`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
            VALUES
                (?, ?, ?, ?, ?, ?, ?, ?, ?)
            ON DUPLICATE KEY UPDATE ip = VALUES(ip),
                controller_name = VALUES(controller_name),
                controller_action = VALUES(controller_action),
                view_state = VALUES(view_state),
                params = VALUES(params),
                view_date = VALUES(view_date),
                robot_key = VALUES(robot_key)
        
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1114, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1114, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Repository/SessionActivity.php(158): XF\Db\AbstractAdapter->query('
            -- XFDB=noF...', Array)
#4 src/XF/Pub/Controller/AbstractController.php(84): XF\Repository\SessionActivity->updateSessionActivity(0, '2001:470:998a:a...', 'XF\\Pub\\Controll...', 'Index', Array, 'valid', '')
#5 src/XF/Pub/Controller/AbstractController.php(44): XF\Pub\Controller\AbstractController->updateSessionActivity('Index', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#6 src/XF/Mvc/Controller.php(289): XF\Pub\Controller\AbstractController->postDispatchType('Index', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#7 src/XF/Mvc/Dispatcher.php(385): XF\Mvc\Controller->postDispatch('Index', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#8 src/XF/Mvc/Dispatcher.php(263): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', Object(XF\Mvc\RouteMatch), Object(EMD\FT\XF\Pub\Controller\Thread), NULL)
#9 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(EMD\FT\XF\Pub\Controller\Thread), NULL)
#10 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(2345): XF\Mvc\Dispatcher->run()
#12 src/XF.php(512): XF\App->run()
#13 index.php(20): XF::runApp('XF\\Pub\\App')
#14 {main}

Exactly the same thing just started happening to me. Haven't changed anything in my setup for months.

What's the problem?
 
MySQL MEMORY tables have a (smallish) size limit by default (can't be larger than 16MB by default):


Probably, you just need to raise the limit in your MySQL config.
Thanks for the input Shawn. I'll look into it.

I'm a huge fan of yours btw. Right from the ebay cookies time. Hope your cats are doing great.

Find it pretty amazing that you still spend time helping random guys out ;) Really appreciate it.
 
Top Bottom