Not a bug MySQL query error [1114]: The table 'xf_session_activity' is full

[Recep Baltaş]

Affected version

2.0.9

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('\n\t\t\t-- XFDB=noF...', Array)
#4 src/XF/Pub/Controller/AbstractController.php(66): XF\Repository\SessionActivity->updateSessionActivity(6152, '195.214.190.30', 'XF\\Pub\\Controll...', 'View', Array, 'valid', '')
#5 src/XF/Pub/Controller/AbstractController.php(41): XF\Pub\Controller\AbstractController->updateSessionActivity('View', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#6 src/XF/Mvc/Controller.php(278): XF\Pub\Controller\AbstractController->postDispatchType('View', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#7 src/XF/Mvc/Dispatcher.php(271): XF\Mvc\Controller->postDispatch('View', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#8 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF\\Pub\\Controll...', 'View', 'html', Object(XF\Mvc\ParameterBag), 'conversations', Object(XF\Pub\Controller\Conversation), 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(1931): XF\Mvc\Dispatcher->run()
#11 src/XF.php(328): XF\App->run()
#12 index.php(13): XF::runApp('XF\\Pub\\App')
#13 {main}

Request page:

array(4) {
  ["url"] => string(30) "/sosyal/konusma/anakart.93418/"
  ["referrer"] => string(33) "https://www.technopat.net/sosyal/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

 

[S Thomas]

https://xenforo.com/community/threa...ull-after-upgrade-to-xenforo-2-from-1.146129/


Just truncate it again. Or follow this: https://dev.mysql.com/doc/refman/8.0/en/full-table.html (untested though)

 

[Recep Baltaş]

Truncated about 3 days ago and happened again...

I'll wait for the official reply.

 

[Jake B.]

You probably just need to increase max_heap_table_size in your mysql config. I believe XenForo automatically cleans up this table after a certain amount of time

 

[Paul B]

It's not a bug.

As above, you may need to tune MySQL.

 

[Ozzy47]

I'll wait for the official reply.

If you are looking for “official” replies to your questions, you would be better off opening a support ticket rather than posting a thread and ignoring everyone’s suggestions, that way they can help other people that look to community support,