Database error

Jorgo85 · 18-10-2006, 09: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, 09:34 PM

i get it all the time aswell,

**Bluehoon** · 18-10-2006, 09: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, 09: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.

Jorgo85 · 18-10-2006, 09: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, 09: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

:

**Professor Farnsworth** · 18-10-2006, 09: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, 09: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.

Damo · 18-10-2006, 09: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, 09: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, 09:57 PM

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

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

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

Kryton · 18-10-2006, 10: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, 10: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, 10: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, 10: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, 10: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?

**russellw** · 18-10-2006, 10: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

Smoke Pursuit · 18-10-2006, 10: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, 10: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, 11: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?

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

I was starting to think my computer had a virus lol

Glad to see it's not just me

XA-Coupe · 18-10-2006, 11:24 PM

We get it too don't forget.
The server is fine and the hosting company has enough bandwidth to go around, if it was easy it would have been sorted ages ago.

**Bluehoon** · 18-10-2006, 11:29 PM

at the back end, what is the database?

is it page file based?

is it one single file? whats the go.

I am thinking along the lines of an indexing problem.....
This would be why nothing else points here, server etc etc....

Just a thought...

FPV8U · 18-10-2006, 11:32 PM

I also have this problem, so it looks like it's quite a few of us then.

LUXO_8 · 19-10-2006, 12:29 AM

Quote:

Originally Posted by FPV8U

I also have this problem, so it looks like it's quite a few of us then.

when it happens to you, its happened to EVERYONE.......

Work Horse · 19-10-2006, 09: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, 12:40 PM

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

:

Aaron_EF8 · 19-10-2006, 02: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?

4.9 EF Futura · 19-10-2006, 03: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?