SQL error and board being extremely slow

Got an idea, or did we do something that you really find disturbing? Come here and tell us about it and we'll respond.

SQL error and board being extremely slow

Postby heliona » Fri Dec 21, 2012 1:29 pm

I'm sure other people occasionally experience the new board being ridiculously slow sometimes. Just now I (or rather my computer) spent 20 minutes attempting to submit a post and eventually I got an SQL error:

General Error

SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.


I've never had an SQL error, but I will say that almost every day there are times when it takes a really long time for a page to load, and then suddenly everything's super-fast again. :?
Image<-- Sir Gwaine representing the letter "G" in the TVM!

Life is short; break the rules, forgive quickly; kiss slowly; love truly; laugh uncontrollably; and never regret anything that made you smile. Twenty years from now you will be more disappointed by the things you didn't do than by the ones you did. So throw off the bowlines, sail away from the safe harbour. Catch the trade winds in your sails. Explore. Dream. Discover.

Grab a chance and you won't be sorry for the might-have-beens. - Arthur Ransome

Just because I have the vocabulary of a well-educated sailor doesn't mean I'm not a lady.

In Memoriam EDW - March 14th 2009
In Memoriam rowanberry - March 1st 2014 (~In Memoriam AHH - Alfred Lord Tennyson~)

Photos: My Flickr Photo Collections & Wee Nell - the furry ball of mischief!


(I occasionally post as White Shadow - you've been warned!)

New posters, there's a Welcome and Comprehensive Guide to the Messageboard to answer your questions.
User avatar
heliona
The Sexy One ~ Hellaciously Huggable

 
Posts: 10469
Joined: Wed Feb 02, 2000 11:14 am
Location: Atop a sunny hill
Top

Re: SQL error and board being extremely slow

Postby FrodoTook » Fri Dec 21, 2012 2:01 pm

I have not seen that particular error message but will agree that
almost every day there are times when it takes a really long time for a page to load, and then suddenly everything's super-fast again.


Quite frustrating at times. Just a few minutes ago I pasted a message of mine to my PC Word Pad just so I could save it to post later.
Image

Smaug the Golden.
User avatar
FrodoTook
Efff Teee

 
Posts: 6774
Joined: Thu Jul 19, 2001 6:47 am
Location: South Carolina
Top

Re: SQL error and board being extremely slow

Postby Jonathan » Fri Dec 21, 2012 2:29 pm

Yes I've noticed it. There is one query that happens when some specific profiles are accessed that seems to be causing the prob. I believe it has to do with showing the post activity on the the profile page.

I may just need to remove those items for now.
Hi! I created this site in 1999. I was 23, unmarried, and didn't have kids. That's all changed. I'm working on getting this back to normal again... Welcome. :)

And if you want to help out with the site in any way, EMAIL ME or get a hold of me on FACEBOOK
User avatar
Jonathan
Servant of the Secret Fire

 
Posts: 2352
Joined: Sun Apr 04, 1999 1:01 am
Location: A Far Green Country Under a Swift Sunrise
Top

Re: SQL error and board being extremely slow

Postby heliona » Fri Dec 21, 2012 4:29 pm

It is very odd, because it flips and flops between being fast one minute and then molasses-slow the next. :) I thought it'd be something to do with the new board, but once I got the error message, I thought I should flag it up. :)
Image<-- Sir Gwaine representing the letter "G" in the TVM!

Life is short; break the rules, forgive quickly; kiss slowly; love truly; laugh uncontrollably; and never regret anything that made you smile. Twenty years from now you will be more disappointed by the things you didn't do than by the ones you did. So throw off the bowlines, sail away from the safe harbour. Catch the trade winds in your sails. Explore. Dream. Discover.

Grab a chance and you won't be sorry for the might-have-beens. - Arthur Ransome

Just because I have the vocabulary of a well-educated sailor doesn't mean I'm not a lady.

In Memoriam EDW - March 14th 2009
In Memoriam rowanberry - March 1st 2014 (~In Memoriam AHH - Alfred Lord Tennyson~)

Photos: My Flickr Photo Collections & Wee Nell - the furry ball of mischief!


(I occasionally post as White Shadow - you've been warned!)

New posters, there's a Welcome and Comprehensive Guide to the Messageboard to answer your questions.
User avatar
heliona
The Sexy One ~ Hellaciously Huggable

 
Posts: 10469
Joined: Wed Feb 02, 2000 11:14 am
Location: Atop a sunny hill
Top

Re: SQL error and board being extremely slow

Postby Jonathan » Fri Dec 21, 2012 4:56 pm

Removed the code that seemed to be the offending super-slow query (the "Most Active Forum" display on a user profile page)... let's see if that fixes things up.
Hi! I created this site in 1999. I was 23, unmarried, and didn't have kids. That's all changed. I'm working on getting this back to normal again... Welcome. :)

And if you want to help out with the site in any way, EMAIL ME or get a hold of me on FACEBOOK
User avatar
Jonathan
Servant of the Secret Fire

 
Posts: 2352
Joined: Sun Apr 04, 1999 1:01 am
Location: A Far Green Country Under a Swift Sunrise
Top

Re: SQL error and board being extremely slow

Postby heliona » Fri Dec 21, 2012 5:07 pm

Thanks, Jonathan. :)
Image<-- Sir Gwaine representing the letter "G" in the TVM!

Life is short; break the rules, forgive quickly; kiss slowly; love truly; laugh uncontrollably; and never regret anything that made you smile. Twenty years from now you will be more disappointed by the things you didn't do than by the ones you did. So throw off the bowlines, sail away from the safe harbour. Catch the trade winds in your sails. Explore. Dream. Discover.

Grab a chance and you won't be sorry for the might-have-beens. - Arthur Ransome

Just because I have the vocabulary of a well-educated sailor doesn't mean I'm not a lady.

In Memoriam EDW - March 14th 2009
In Memoriam rowanberry - March 1st 2014 (~In Memoriam AHH - Alfred Lord Tennyson~)

Photos: My Flickr Photo Collections & Wee Nell - the furry ball of mischief!


(I occasionally post as White Shadow - you've been warned!)

New posters, there's a Welcome and Comprehensive Guide to the Messageboard to answer your questions.
User avatar
heliona
The Sexy One ~ Hellaciously Huggable

 
Posts: 10469
Joined: Wed Feb 02, 2000 11:14 am
Location: Atop a sunny hill
Top

Re: SQL error and board being extremely slow

Postby heliona » Sat Dec 22, 2012 5:37 am

Jonathan, I'm sorry to tell you that sometimes TORC is still slow sometimes and Wilko just got the same General error that I posted above. :cry2:
Image<-- Sir Gwaine representing the letter "G" in the TVM!

Life is short; break the rules, forgive quickly; kiss slowly; love truly; laugh uncontrollably; and never regret anything that made you smile. Twenty years from now you will be more disappointed by the things you didn't do than by the ones you did. So throw off the bowlines, sail away from the safe harbour. Catch the trade winds in your sails. Explore. Dream. Discover.

Grab a chance and you won't be sorry for the might-have-beens. - Arthur Ransome

Just because I have the vocabulary of a well-educated sailor doesn't mean I'm not a lady.

In Memoriam EDW - March 14th 2009
In Memoriam rowanberry - March 1st 2014 (~In Memoriam AHH - Alfred Lord Tennyson~)

Photos: My Flickr Photo Collections & Wee Nell - the furry ball of mischief!


(I occasionally post as White Shadow - you've been warned!)

New posters, there's a Welcome and Comprehensive Guide to the Messageboard to answer your questions.
User avatar
heliona
The Sexy One ~ Hellaciously Huggable

 
Posts: 10469
Joined: Wed Feb 02, 2000 11:14 am
Location: Atop a sunny hill
Top

Re: SQL error and board being extremely slow

Postby Ashke Verasca » Sat Dec 22, 2012 7:01 am

Yes, it happens all the time, especially when I edit the post. Once I had to wait 30 minutes.
User avatar
Ashke Verasca
Shield Bearer
 
Posts: 259
Joined: Fri Dec 07, 2012 12:42 pm
Location: Umbar
Top

Re: SQL error and board being extremely slow

Postby Calma » Sat Dec 22, 2012 8:32 am

Oh good... I thought it was just me.

There are times when the site doesn't even load for me.
I usually wait about 10 minutes then it comes right up.

Thanks Jonathan!
I know you're doing all you can.
Just keep plugging away at it.

ps.. I don't get the error message.
It just doesn't load fast at times
Also, when I can get on the boards,
I sometimes have a hard time trying to post a reply.
Last edited by Calma on Thu Dec 27, 2012 7:39 am, edited 3 times in total.
Image

My Favorite Star Wars Character....

Mr. Cool Himself. :D


May Is Star Wars Month in the TVM!!!




Join the funWith The TVM

CAT LOVERS GUILD Image :cry: :cry: :cry: :cry:



:yippie: MARINERS!!!!!

WINS: 15 :D

LOSSES: 17 :P




SOUNDERS!!!


Toni...Dannie…Ray-Ray…William...Waneta...Damon...David...Guy… rowan Image

Always looking for new posters for the TORC 365 PROJECT

Image ROCK ON!!!
User avatar
Calma
Crazy Cat Lady

 
Posts: 24009
Joined: Tue Feb 13, 2001 4:36 pm
Location: Up the road, across the street, down the lane, and around the bend
Top

Re: SQL error and board being extremely slow

Postby Jonathan » Sat Dec 22, 2012 1:31 pm

Tonight, then, I'll shut the boards down and run some maintenance scripts on the tables in the database... Since there are over 3,000,000 posts, it'll take a few hours to finish. I haven't cleaned up that table in a few years, and I'm betting that ones the ultimate culprit.
Hi! I created this site in 1999. I was 23, unmarried, and didn't have kids. That's all changed. I'm working on getting this back to normal again... Welcome. :)

And if you want to help out with the site in any way, EMAIL ME or get a hold of me on FACEBOOK
User avatar
Jonathan
Servant of the Secret Fire

 
Posts: 2352
Joined: Sun Apr 04, 1999 1:01 am
Location: A Far Green Country Under a Swift Sunrise
Top

Re: SQL error and board being extremely slow

Postby FrodoTook » Sat Dec 22, 2012 1:45 pm

Thank you Jon for your continued care of TORC.

It is appreciated...very much by very many.
Image

Smaug the Golden.
User avatar
FrodoTook
Efff Teee

 
Posts: 6774
Joined: Thu Jul 19, 2001 6:47 am
Location: South Carolina
Top

Re: SQL error and board being extremely slow

Postby Calma » Sat Dec 22, 2012 2:20 pm

Jonathan wrote:Tonight, then, I'll shut the boards down and run some maintenance scripts on the tables in the database... Since there are over 3,000,000 posts, it'll take a few hours to finish. I haven't cleaned up that table in a few years, and I'm betting that ones the ultimate culprit.



Tonight, eh?
Ok, I'll put in a movie or something...

Thank you Jon!


ETA...12/27...6:40am PST...

Ok, I can finally get into the post a reply slot.
I was getting that error message for about 30 minutes this morning.
All day yesterday, I had no problem at all getting onto and posting on TORC.
Just thought you'd like to know is all.
I wouldn't want you to be messing up family holiday time to get 'round to this.

Now I just hope it'll post.

Thanks.
Image

My Favorite Star Wars Character....

Mr. Cool Himself. :D


May Is Star Wars Month in the TVM!!!




Join the funWith The TVM

CAT LOVERS GUILD Image :cry: :cry: :cry: :cry:



:yippie: MARINERS!!!!!

WINS: 15 :D

LOSSES: 17 :P




SOUNDERS!!!


Toni...Dannie…Ray-Ray…William...Waneta...Damon...David...Guy… rowan Image

Always looking for new posters for the TORC 365 PROJECT

Image ROCK ON!!!
User avatar
Calma
Crazy Cat Lady

 
Posts: 24009
Joined: Tue Feb 13, 2001 4:36 pm
Location: Up the road, across the street, down the lane, and around the bend
Top


Return to The One Ring

Who is online

Users browsing this forum: No registered users and 1 guest