XF 2.0 The table 'xf_session_activity' is full

[Recep Baltaş]

Every once in a while this table gets full somehow and I get page render errors on the forum.

I want to solve it once and for all.

The frequency of the problem increased after upgrading to MariaDB.

• 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('
            -- XFDB=noF...', Array)
#4 src/XF/Pub/Controller/AbstractController.php(66): XF\Repository\SessionActivity->updateSessionActivity(0, '66.249.65.134', 'XF\\Pub\\Controll...', 'Index', Array, 'valid', 'google')
#5 src/XF/Pub/Controller/AbstractController.php(41): XF\Pub\Controller\AbstractController->updateSessionActivity('Index', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#6 src/XF/Mvc/Controller.php(278): XF\Pub\Controller\AbstractController->postDispatchType('Index', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#7 src/XF/Mvc/Dispatcher.php(271): XF\Mvc\Controller->postDispatch('Index', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#8 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', 'html', Object(XF\Mvc\ParameterBag), 'forums', Object(Andy\Calendar\XF\Pub\Controller\Thread), NULL)
#9 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(1934): XF\Mvc\Dispatcher->run()
#11 src/XF.php(333): XF\App->run()
#12 index.php(13): XF::runApp('XF\\Pub\\App')
#13 {main}

 

[Kirby]

This usally happens when your board gets too much love from dumb bots/vulnerbilitie scanners, check your access logs.

If this is the case, put some filters (iptables/ipset, etc.) in place and enjoy the silence

 

[Recep Baltaş]

Is there a setting in the ACP for that?

 

[Mike]

You may want to increase the max_heap_table_size size in your MySQL config. (Note that you would need to restart the server after changing it.)

 

[hibiskus]

You may want to increase the max_heap_table_size size in your MySQL config. (Note that you would need to restart the server after changing it.)

Wouldn't that just only buy more time until it gets fool again?
or did I missed out on something?