Intermittent unavailability

[Orionblamblam]

The past day or so I've been getting this a lot. Anyone else? Is it just me, or is there something screwy with the system? When it happens it happens across multiple browsers and devices...

 

[overscan (PaulMM)]

There's an issue with the database table that holds session data getting full - this would affect some people's login sessions but not all. Investigating.

 

[Orionblamblam]

this would affect some people's login sessions but not all.

Ah. So it's a conspiracy.

 

[overscan (PaulMM)]

Okay, investigation completed.

The error was [ERROR] mysqld: The table 'xf_session_activity' is full

xf_session_activity' is a MEMORY table used to keep track of activity within active user sessions. Old data is pruned out every hour. Its size is limited by server free memory, and if too many users are online it might run out.

I will see if the issue occurs again, if it does I'll change it to a disk based table so it can get larger if needed. Disk is SSD, so it shouldn't slow things down appreciably.

 

[lancer21]

I had the same issue at random times yesterday and this morning. Thanks for sorting it out.

 

[Halcyon66]

Same here, and still having some issues.

Regards,

 

[aim9xray]

Same here. But intermittent.

 

[overscan (PaulMM)]

Yep, its happened again. Investigating.

 

[overscan (PaulMM)]

I think I've made it bigger. Will see.

If anything, the site seems a bit faster?

 

[aim9xray]

Yes, does seem a little - snappier. Now while you're at it, can you fix the Aviation Leak site?
It loads slower than molasses stored in liquid Helium.