XF 2.2 The table 'xf_session_activity' is full

[DJA]

I keep having issues, while the xf_session_activity table is 0 bytes.

[LIST]
[*]XF\Db\Exception: MySQL query error [1114]: The table 'xf_session_activity' is full
[*]src/XF/Db/AbstractStatement.php:228
[*]Generated by: Unknown account
[*]Mar 19, 2022 at 7:52 AM
[/LIST]
[HEADING=2]Stack trace[/HEADING]
            -- 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(94): 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(82): XF\Repository\SessionActivity->updateSessionActivity(0, '207.46.13.43', 'XF\\Pub\\Controll...', 'View', Array, 'valid', 'bing')
#5 src/XF/Pub/Controller/AbstractController.php(42): XF\Pub\Controller\AbstractController->updateSessionActivity('View', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#6 src/XF/Mvc/Controller.php(287): XF\Pub\Controller\AbstractController->postDispatchType('View', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#7 src/XF/Mvc/Dispatcher.php(383): XF\Mvc\Controller->postDispatch('View', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#8 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF\\Pub\\Controll...', 'View', Object(XF\Mvc\RouteMatch), Object(DBTech\UserTagging\XF\Pub\Controller\Member), Object(XF\Mvc\Reply\Reroute))
#9 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(DBTech\UserTagging\XF\Pub\Controller\Member), Object(XF\Mvc\Reply\Reroute))
#10 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(2326): XF\Mvc\Dispatcher->run()
#12 src/XF.php(488): XF\App->run()
#13 index.php(20): XF::runApp('XF\\Pub\\App')
#14 {main}
[HEADING=2]Request state[/HEADING]
array(4) {
  ["url"] => string(34) "/index.php?members/danishdog.3856/"
  ["referrer"] => bool(false)
  ["_GET"] => array(1) {
    ["members/danishdog_3856/"] => string(0) ""
  }
  ["_POST"] => array(0) {
  }
}

 

[briansol]

if you have a super busy forum, you may have run out of id's in the schema allowed.

truncate it.
add more heap memory in mysql.cnf

see also:

XF 2.1 - `xf_session_activity` table is point of failure on large sites

xf_session_activity is a MyISAM MEMORY table which, unlike InnoDB, locks during a select. Post entities are usually pulled full and, when the postbit 'user is online' badge is enabled, this means every xf_post select is also an xf_session_activity select. LEFT JOIN `xf_session_activity`...

xenforo.com

 

[DJA]

I see, thanks !