Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 22 Aug 2017, 21:51
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
Server Errors

Hey,

Today one of my sites has had much more traffic than usual and I have had a couple crashes. I believe one was caused by redis caching with dbtech vboptimizer. I do not believe the issue is dbtech but rather redis service. I'm sorry but I do not have the log entry for that one as the outage was for only 2 minutes.

If anyone is familiar with redis let me know please. I installed it but I do not believe it is configured correctly. When ever we get a ton of traffic I have issues.

The other issue is current. I see this in the server log.

GET /clientscript/vbulletin_css/style00039l/forumbits.css,forumhome.css,widgets.css,sidebar.css,options.css,tagcloud.css

It is a 408 error.

I have turned off style theme file caching and tagging for the moment. I have many of these errors.

I know this forum is dead now but I could use some insight.

Thanks
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #2  
Old 26 Aug 2017, 13:35
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
As we cant see your server setup or the config of redis, really hard to say with out you posting the details of redis & what you've done so far.

Run redis on numerous servers, everything from vb to wp.
Reply With Quote
  #3  
Old 26 Aug 2017, 14:57
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
Can you give me any tips on running it? I only have issues under high traffic situations.

Server is the latest Centos..

Thanks
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #4  
Old 26 Aug 2017, 15:10
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
There is really no tips, its a basic config file for setup, other than tweaking those settings, there is nothing special for "tips".

What errors did you get if any before the crash or have you checked logs?
Reply With Quote
  #5  
Old 09 Sep 2017, 15:46
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
How about this?

Database error in vBulletin 4.2.5 Beta 4:

Invalid SQL:

SELECT *
FROM style
WHERE (styleid = 55)
OR styleid = 39
ORDER BY styleid DESC
LIMIT 1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday, September 9th 2017 @ 04:09:57 AM
Error Date : Saturday, September 9th 2017 @ 04:11:10 AM
Script :/showthread.php?t=236920&page=19
Referrer : /showthread.php?t=236920&page=17
IP Address : ##########
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
Server : ############
User Agent :


Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 1403
#1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 505
#2 vB_Database->query_first() called in [path]/includes/class_core.php on line 536
#3 vB_Database->query_first_slave() called in [path]/includes/class_bootstrap.php on line 1008
#4 vB_Bootstrap->fetch_style_record() called in [path]/includes/class_bootstrap.php on line 201
#5 vB_Bootstrap->load_style() called in [path]/global.php on line 31
#6 require_once([path]/global.php) called in [path]/showthread.php on line 107
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #6  
Old 09 Sep 2017, 16:59
blind-eddie's Avatar
blind-eddie blind-eddie is offline
 
Join Date: Apr 2006
Real name: Tim
Hey Richie, The database server crashed, as your host why it is crashing. I used to get it alot.
__________________
LONG LIVE 3.8 SERIES
National Arcade Competition Club- NACC All arcade edits will work on vb4.
Check out my heavily modified ibproarcade with over 50,000 games for you, free of charge!
Exclusive arcade addons, edits and skins were made by stangger5 owner of Next Level Arcade
Reply With Quote
  #7  
Old 09 Sep 2017, 21:06
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
I have a dedicated server.

I believe it is this error causing the issue and it doesn't seem like a crash because the database is not actually going down.

Thanks bro
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #8  
Old 10 Sep 2017, 02:12
blind-eddie's Avatar
blind-eddie blind-eddie is offline
 
Join Date: Apr 2006
Real name: Tim
MySQL Error : MySQL server has gone away is a hiccup on the SQL server.
Dedicated servers host their own SQL also?
__________________
LONG LIVE 3.8 SERIES
National Arcade Competition Club- NACC All arcade edits will work on vb4.
Check out my heavily modified ibproarcade with over 50,000 games for you, free of charge!
Exclusive arcade addons, edits and skins were made by stangger5 owner of Next Level Arcade
Reply With Quote
  #9  
Old 10 Sep 2017, 18:16
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
server going away can be caused by a few things including sql's own settings, i doubt that is redis causing the issue, but wont be able to do much from the outside looking in.

did you raise ur timeouts in my.cnf or do a live view of sql & watch the queries?
Reply With Quote
  #10  
Old 11 Sep 2017, 01:27
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
I used to get something similar to that and it was due to bots crawling my site and people doing to many searches at once ... it was a bunch of kids flooding my site ... had to block their ips and even ip ranges ...
Reply With Quote
  #11  
Old 12 Sep 2017, 18:43
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
Ok Guys, thanks..

I know about the database going away and various things can cause it such as resource overload, time out, etc..

In this case though the errors I get are always basically the same:

Invalid SQL:

SELECT *
FROM style
WHERE (styleid = 39 AND userselect = 1)
OR styleid = 39
ORDER BY styleid ASC
LIMIT 1;

I believe there is something causing the issue that is making the database server go away related to this query. In other words, I do not believe it is the database going away that is causing this error. Hope this makes sense. lol

It only happens a couple times a day usually and I have tried to rearrange some cron tasks, back ups to make sure it is not a resource situation. It could be but I am not seeing any indication.

--------------- Added 12 Sep 2017 at 18:43 ---------------

Originally Posted by snakes1100 View Post
server going away can be caused by a few things including sql's own settings, i doubt that is redis causing the issue, but wont be able to do much from the outside looking in.

did you raise ur timeouts in my.cnf or do a live view of sql & watch the queries?
No, this is not related to the redis issue I was posting about before. I have stopped using dbtech optimizer and am no longer using redis.
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

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 02:06.

Layout Options | Width: Wide Color: