vb.org Archive - vbulletin session table FULL

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - vbulletin session table FULL (https://vborg.vbsupport.ru/showthread.php?t=323142)

chikuru

07-31-2016 11:27 AM

vbulletin session table FULL

What are the possible reason for the session table to be FULL easily?

The only thing i know is the cronjob image code isnt present in footer, and cronjob for daily cleanup process isnt working..

Recently applied a database query to substruct 4days to recent posts because the server time was incorrect. Did it affect the session table to be fully filled up easily?

Seven Skins

07-31-2016 01:09 PM

Quote:

Originally Posted by chikuru (Post 2574166)

The only thing i know is the cronjob image code isnt present in footer

Put the image back and corn jobs will start working again. Stick the code below somewhere in the footer.

Code:

{vb:raw cronimage}

I think you can empty the sessions table manually.

chikuru

07-31-2016 01:19 PM

Quote:

Originally Posted by Seven Skins (Post 2574167)

Put the image back and corn jobs will start working again. Stick the code below somewhere in the footer.

Code:

{vb:raw cronimage}

I think you can empty the sessions table manually.

this code is present in the footer.

Its weird that the session table gets full easily after i adjusted the server time and executed the database query to change the post date..

Lynne

07-31-2016 03:24 PM

Are any of your Schedules Tasks working? If you go to the Schedules Task Manager and look at the column that says Next Time, are those all dates in the very near future or past dates or what?

Paul M

07-31-2016 07:02 PM

Quote:

Originally Posted by chikuru (Post 2574168)

Its weird that the session table gets full easily after i adjusted the server time and executed the database query to change the post date..

There is no connection between the two.

chikuru

07-31-2016 10:27 PM

Quote:

Originally Posted by Lynne (Post 2574172)

Are any of your Schedules Tasks working? If you go to the Schedules Task Manager and look at the column that says Next Time, are those all dates in the very near future or past dates or what?

When the server time was incorrect, the next time for Scheduled Tasks were also incorrect (advanced 2 days). I just click edit button, then save (without changing anything from settings.) and the next running date are now correct :up:

Lynne

08-03-2016 12:26 AM

I'm glad you got it working again. :)

All times are GMT. The time now is 04:02 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00939 seconds Memory Usage 1,725KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: