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:
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) {
}
}