My session activity table is filling up

anon666

Active member
I have been getting a lot of errors for possible DDoS attack. I would like to know if it is possible to empty the session activity table, and if that helps to speed up the forum (in addition to taking extreme security measures from cloudflare).

Here is an example of these errors that the control panel shows in large numbers:


Server error log

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

Yesterday at 5:10 PM src/XF/Db/AbstractStatement.php:228


Server error log

XF\Db\Exception: MySQL query error [1114]: The table 'xf_session_activity' is full src/XF/Db/AbstractStatement.php:228

Generated by: Unknown account Apr 2, 2021 at 5: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(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()


Request state

array(4) {
["url"] => string(1) "/"
["referrer"] => bool(false)
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
 
Back
Top Bottom