vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Online visitors count gets restarted! (https://vborg.vbsupport.ru/showthread.php?t=182885)

quitsmoking 06-18-2008 08:22 PM
Online visitors count gets restarted!
 
I have a weird problem which is that between 22:00 and 01:00, the number of online visitors gets restarted like twice. It stays around 2000 but suddenly I get kicked out of the admin area and the online counter starts over from zero!

Any idea what the possible reasons could be? There are no mysql or apache error logs during this period at all.

Thank you.

ssslippy 06-19-2008 12:49 AM
Would you happen to have a repair or optimize tables running on cron?

geevest.com 06-19-2008 01:13 AM
quitsmoking ur problem like me :)
u can check my thread in general vbulletin discuss.

hope u can fixed ur issue.

quitsmoking 06-19-2008 05:35 AM
Quote:
Originally Posted by ssslippy (Post 1553138)
Would you happen to have a repair or optimize tables running on cron?
Yes I did. And this did not stop the problem.

@geevest.com: I am at liquidweb too :)

Dismounted 06-19-2008 06:45 AM
MySQL could have been restarted, which would have dumped the session database. Check the MySQL uptime.

quitsmoking 06-19-2008 07:03 AM
mysql was not restarted. The uptime shows the same uptime of the server!
Thank you.

--------------- Added [DATE]1213864283[/DATE] at [TIME]1213864283[/TIME] ---------------

I investigated for a while and I found that the type of these tables:
session
cpsession
is different from the other tables. They are HEAP (MEMORY) so that they run faster. What could be happening to them or their files? I need a mysql guru I guess.

Marco van Herwaarden 06-19-2008 08:31 AM
As stated before, HEAP (in memory tables) are emptied when MySQL is restarted.

quitsmoking 06-19-2008 09:12 AM
OK but since mysql uptime is not different from the server's, then mysql was not restarted. In fact, I investigated even more and I found that there is a reported bug that could be the same as my situation:
http://bugs.mysql.com/bug.php?id=19138

Therefore, I asked my server's company to upgrade mysql. I will see if it solves the problem and update you.


All times are GMT. The time now is 03:37 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01054 seconds
  • Memory Usage 1,720KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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