XF 2.2 The table ‘xf_session_activity’ is full

[bburton]

What might cause the xf_session_activity table to become repeatedly full resulting in the contents of forum pages not loading and an error message displaying instead?

The 'hourly clean up' cron job is running, so that's not the reason. This is occurring between those hourly clean ups - about every 20 minutes or so. Running the 'hourly clean up' manually temporarily 'fixes' the problem, then 20 minutes or so later the xf_session_activity table fills up again and this error occurs repeatedly:

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

There is not an unusual number of logged in users. Nothing appears unusual with the number of logged in registered users.

Thanks,

 

[ekool]

Never had that error... even on large sites. Very strange.

I see it's happened to other people before though: https://xenforo.com/community/threads/xf_session_activity-is-full.172623/

 

[bburton]

I found several threads on this same issue, but no explanations

Question: Can unregistered guest activity fill up this xf_session_activity table?

 

[Jja]

What might cause the xf_session_activity table to become repeatedly full resulting in the contents of forum pages not loading and an error message displaying instead?

Not properly configured (tuned) server for given application/traffic.

I would rather ask "how full is full?"
Whats the setup of actual mysql config + available resources ?

Question: Can unregistered guest activity fill up this xf_session_activity table?

Thats exactly what this table contains.

 

[bburton]

XenForo has been running just fine for months (years) with no issues. Nothing recently has been done to change the configuration

I thought xf_session_activity table just kept track of logged in registered users (?)

 

[Jja]

Doesnt change the fact.
Guests, bots also uses sessions and are stored in the table as well.

 

[bburton]

Then its very easy to disable a XenForo forum simply by filling up this little table, no?

 

[Jja]

Its not the Xenforo problem itself but server configuration.

 

[bburton]

Here's an entry from the server error log:

Server error log

• XF\Db\Exception: MySQL query error [1114]: The table 'xf_session_activity' is full
• src/XF/Db/AbstractStatement.php:230
• Generated by: Unknown account
• Jan 9, 2025 at 11:08 PM

Stack trace​

-- XFDB=noForceAllWrite
INSERT IGNORE INTO xf_session_activity (
ip,
controller_name,
controller_action,
view_state,
params,
view_date,
robot_key,
user_id,
unique_key
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

------------