Database error

Jorgo85 · 18-10-2006, 08:30 PM

Why do i keep getting a white screen stating a database error. I've had three in about five minutes just now. And it did it yesterday. And the day before that. And it'll probably do it tomorrow. Why??

protd · 18-10-2006, 08:34 PM

i get it all the time aswell,

**Bluehoon** · 18-10-2006, 08:39 PM

I have the exact same issue here as well. It can be somewhat random as well...

I also have large problems accessing site at night..

At work first thing in the morning, and there is no problems at all....

Any ideas as to whay it happening?????????

**gregaust** · 18-10-2006, 08:39 PM

Seems to be getting worse lately every night,took me 5 goes to get into this post with data base error. I was beginning to think it was a trick post.

**Professor Farnsworth** · 18-10-2006, 08:43 PM

it's just excessive load on the server. could also be when things are being upgraded/backed up on the server. I've had it for the last 30 minutes. It's all good, just a lot of people access this site!

Jorgo85 · 18-10-2006, 08:44 PM

Quote:

Originally Posted by gregaust

Seems to be getting worse lately every night,took me 5 goes to get into this post with data base error. I was beginning to think it was a trick post.

HAHA that would be funny.

Jorgo85 · 18-10-2006, 08:41 PM

Its an absolute pain in the freakin ****. I got it two more times just trying to post the thread.

pecker73 · 18-10-2006, 08:42 PM

Quote:

Originally Posted by EFXR65spd

Why do i keep getting a white screen stating a database error. I've had three in about five minutes just now. And it did it yesterday. And the day before that. And it'll probably do it tomorrow. Why??

Ditto !!!!

:

:

Its driving me crazy..

:

:

Starting to think we've got a Holden powering the server

:

Damo · 18-10-2006, 08:49 PM

yeah it's pretty poor form for such a large forum with soo many donating member and sponsors and stuff.

Tles · 18-10-2006, 08:53 PM

Just paid to join and copped more Database errors...grrrrrrrrrrrrrr then posted more DBEs...grrrrrrrr Thought Ok I'll log out then back in.....couldn't remember password....grrrrgrrrrx2+sh**

Cheahman · 18-10-2006, 08:57 PM

Yep it happens almost every night for me too. Very annoying

FRDXR6 · 18-10-2006, 09:22 PM

Happens to me everynow and then too, once so far today...

Kryton · 18-10-2006, 09:29 PM

it does happen every night around 8.30ish.
Admin know of the problem and will ellaborate more i suspect.

b2tf · 18-10-2006, 09:32 PM

Russ just needs to pedal harder......

Seriously though, I think some people need to remember that running a site like this is not an easy task. Cut the admin team some slack because if they didnt put all the effort in you would not have a site full stop. A few outs every now and then are not the end of the world.

Skooter · 18-10-2006, 09:34 PM

It just happend again to me about 5 mins ago, when i first started to actively use this forum it never happend but over the last 6 or so months it has gotten bad.

Quote:

Starting to think we've got a Holden powering the server

HAHAHAHAHAHA

Aaron_EF8 · 18-10-2006, 09:39 PM

Quote:

Seriously though, I think some people need to remember that running a site like this is not an easy task. Cut the admin team some slack because if they didnt put all the effort in you would not have a site full stop. A few outs every now and then are not the end of the world.

A few? Try 20+ a night. Who is bagging the admin in this thread? Are you reading into peoples questions a lot more than you need to?

b2tf · 18-10-2006, 09:42 PM

Quote:

Originally Posted by Aaron_EF8

Are you reading into peoples questions a lot more than you need to?

Are you trying to make an issue out of something that is not really that big?

Aaron_EF8 · 19-10-2006, 01:54 PM

Quote:

Originally Posted by b2tf

Are you trying to make an issue out of something that is not really that big?

No, are you? IMO your last comment was pretty out of place, no-one was bagging the admin, and it seems like you want to start another 'us v them' war.

Back on topic, the only 2 things I could think of after reading Russ's post was the server doing housekeeping, which he mentioned, and the flash ads at the top of the pages sucking bandwidth. Every time someone pushes refresh on a page it has to load the icons, pictures, text, signatures, avatars and the flash ads, which ads up when a few hundred people are clicking refresh every couple of minutes. I don't think there were as many database errors until the flash ads went up, although they still did happen. Maybe it's the straw that broke the camels back?

Psycho Chicken · 19-10-2006, 09:21 PM

Quote:

Originally Posted by b2tf

Are you trying to make an issue out of something that is not really that big?

Database error? There is no database error.

**russellw** · 18-10-2006, 09:47 PM

I wish I knew what actually is causing it - it isn't a load issue from member activity and I can't see anything else running on the server when it happens that might be causing it. I can see that the server load averages during the period that it happens are off the scale but when I look at what else is running there is nothing obvious.

The issue has been escalated to the ISP to check whether they do anything in the way of housekeeping during that window (which is about 3.30-4.00 a.m their time) as I cannot see any other logical reason.

For those questioning the actual scaling of the server, the average server load is around 1.6 with a normal peak in the 4.5 range. When the db errors occur it is in the 20's but there is less activity than there is in the 6.00-8.00 p.m time slot.

Anyone with ideas is welcome to contribute to the knowledge pool.

Cheers
Russ

Work Horse · 19-10-2006, 08:24 AM

Quote:

Originally Posted by russellw

Anyone with ideas is welcome to contribute to the knowledge pool.

Cheers
Russ

When all else fails, I've had good success with nitrous oxide Russ :evil_laug

SpoolMan · 19-10-2006, 11:40 AM

Quote:

Originally Posted by Work Horse

When all else fails, I've had good success with nitrous oxide Russ :evil_laug

You will use to much then what happens

:

4.9 EF Futura · 19-10-2006, 02:30 PM

Quote:

Originally Posted by russellw

For those questioning the actual scaling of the server, the average server load is around 1.6 with a normal peak in the 4.5 range. When the db errors occur it is in the 20's but there is less activity than there is in the 6.00-8.00 p.m time slot.

Crazy!

I dont know much about the workings of a website... but what is server load actually measured in? It's processing power or its available bandwidth or something?

i.e. what "should" it mean when these numbers spike like that?

I have to say, its very very very rare that i have this problem... i maybe see this error once per month. Not at regular times etc.

Feel free to IP check me to see where i'm coming in from (non descript commonwealth government infrastructure lol), it may help?

Sourbastard · 19-10-2006, 03:07 PM

Quote:

Originally Posted by 4.9 EF Futura

but what is server load actually measured in?

Its measured in Hogsheads per Rod, measured at sea level by a blind man holding a duck(can be replaced with any other poultry but aquatic are far superior). This is the traditional measurement.

The new aged measurement is Steffo's per Kilometer. One steffo unit is equivalent to the amount of time it takes Steffo to read an entire copy of Motor magazine and post its contents on the forums, times by the speed of light squared.

I hope this clears everything up.

ronwest · 19-10-2006, 06:46 PM

Quote:

Originally Posted by 4.9 EF Futura

I have to say, its very very very rare that i have this problem... i maybe see this error once per month.

FWIW, it's the same for me. If it happens it's usually around 8-9pm.

I've come across it elsewhere (as a subscriber) and it's always been lack of bandwidth in peak times. As that has been ruled out, I have no idea as to what the problem might be.

Smoke Pursuit · 18-10-2006, 09:51 PM

I get it to, only in the peak hours at night time, during the day its fine.

Usually after a few refreshes its fine again.

Falcon Freak · 18-10-2006, 09:55 PM

It can get very frustrating at times. This is the second time I am responding to this thread because of the dreaded grey screen of death.

:

FF

mik · 18-10-2006, 10:03 PM

yep i get it on occasions too, sometimes i just do suming else and come on later, a couple of times i have gone to favourites menu to and old web page and it has let me in straight away, could it be the isp is running out of bandwidth, perhaps they are hosting another forum that gets busy about the time this data base error occurs?

DOC · 19-10-2006, 09:41 PM

Quote:

Originally Posted by mik

yep i get it on occasions too, sometimes i just do suming else and come on later, a couple of times i have gone to favourites menu to and old web page and it has let me in straight away, ?

There is something in what you have written that i think is close to the mark, as others have experienced, when i get the dreded page down if i go to my site and use the link it comes straight back in.

so id say some how the shortcut in favs gets jammed up, don't know enough about how it all works with this stuff but yes as above the fix works every time and will be close to finding out why it happens.

all in all just grab a coffee and a chill pill, FFAU is still there when you get back.

FDG 220 · 18-10-2006, 10:14 PM

I was starting to think my computer had a virus lol

Glad to see it's not just me