Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 17 Nov 2019, 18:31
postcd postcd is offline
 
Join Date: Feb 2012
Which cronjob empties the session mysql table?

Because it happens to me in vbulletin 4.2.5 that the session table is full and vbulletin reports mysql error via e-mail. So please which cron task does it and how to run that task manually and see exact output of it to verify it really empty the table?

footer template contains {vb:raw cronimage}

Last edited by postcd; 04 Dec 2019 at 15:27.
Reply With Quote
  #2  
Old 17 Nov 2019, 19:19
Seven Skins's Avatar
Seven Skins Seven Skins is offline
 
Join Date: Sep 2008
I think they are hourly cleanup and hourly cleanup2
Reply With Quote
  #3  
Old 23 Nov 2019, 14:18
postcd postcd is offline
 
Join Date: Feb 2012
those seems enabled.
session table was full again, but i think only temporarily and then vbulletin solved it possibly, 8107 lines in table.
Should i run any cronjob more frequently? how frequently and which? Or how to create new job that will empty just session table? Or how to increase its size?

Last edited by postcd; 23 Nov 2019 at 14:25.
Reply With Quote
  #4  
Old 23 Nov 2019, 20:03
Seven Skins's Avatar
Seven Skins Seven Skins is offline
 
Join Date: Sep 2008
cronjob will run when someone visits your site, no visits = no cronjob.
You may be able to add these cronjob to server/cpanel etc..

Last edited by Seven Skins; 23 Nov 2019 at 22:06.
Reply With Quote
  #5  
Old 23 Nov 2019, 21:37
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
If you get that error when the session table contains 8107 lines as you said then your host has extreme low limitations applied to your MySQL server. Generally this issue only happens when you have a significant number of visitors on your site (or HTTP flood/DDoS/DoS)
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #6  
Old 05 Dec 2019, 09:33
postcd postcd is offline
 
Join Date: Feb 2012
Thank you Dave, i contacted my provider and he told me "I've increased our MEMORY table limit (it was at default, nothing to do with us restricting)."
Also my session timeout (AdminCP > Settings > Options > "Cookies and HTTP header options") was set to 36 hours.. now i decreased it to 1800 seconds as suggested + emptied the session mysql table. Let's see what will happen.. If it will not work, i will be interested on how to run the table emptying sql query "truncate table session;" via cron..
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 01:31.

Layout Options | Width: Wide Color: