Database Errors - Restoring Avalon

Anchor · 06-29-2009, 11:00 PM

The database is not overloaded - there are only 150k posts on this board.

The problem is with the ISP. Getting technical support going is like squeezing blood out of a stone. There are plans to deal with this longer term, but right now things are not very good with the performance between vbulletin and the underlying database.

I am sorry about these problems which have gone on for a long time - much longer than they should - we are not going to give up on this.

It will probably take some time to get everything sorted out.

A..

metaw3 · 06-30-2009, 04:44 PM

Here's what I do when there are many database errors:

1. I go to the new posts link in the top menu:
http://projectavalon.net/forum/search.php?do=getnew

2. I open each thread I wanna read in a new window. There is always one that is going to load.

3. I refresh the others with database errors and read the ones that loaded.

It's a cross-reading process that requires more concentration but at least I don't hang too long in front of blank pages.

07-04-2009, 04:04 AM

Quote:

Originally Posted by Anchor

The database is not overloaded - there are only 150k posts on this board.

The problem is with the ISP. Getting technical support going is like squeezing blood out of a stone. There are plans to deal with this longer term, but right now things are not very good with the performance between vbulletin and the underlying database.

I am sorry about these problems which have gone on for a long time - much longer than they should - we are not going to give up on this.

It will probably take some time to get everything sorted out.

A..

It sounds like you're dealing with the same ISP company I have been. It only took 4 1/2 months to resume my high speed connection.

metaw3 · 07-04-2009, 03:12 PM

Good work! Great to have the forums back.

Quote:

Originally Posted by sleepingnomore

It sounds like you're dealing with the same ISP company I have been. It only took 4 1/2 months to resume my high speed connection.

WiNaDeYo · 07-06-2009, 10:11 AM

I'm finally back on...could log in, and my nick appeared in the logged-in list, but I couldn't post...

finally got in today clicking the Avalon link on Camelot...how weird.

My wholehearted thanks to the crew for getting the site back up after the fall!

And, yes I was having all kinds of database errors pop up earlier, too.

Peace and Good Will!

J_rod7 · 07-12-2009, 10:55 PM

*******
***
*

Good job, switching to another host, getting it all back up.

Anchor, you mentioned 'preparedness' Keep at it, please.

I used to be in charge of a SCADA (Supervisory Control and Data Acquisition) Computer system - 10-years in a 180-Million Cu-Ft per-day Gas Processing plant. The System had two computers running at all times, one in control, and the other updating itself from the other. Once a week I would switch the Primary to Secondary and vice-versa. But if the running Primary ever went down, the Secondary would pick up the load running the plant plus a production field spanning 40-miles of wells and pipelines.

These days, such tasks are done in a similar way with multiple drives in an array.

Does the new Host run with back-up arrays?

*
***
*******

Tango · 07-21-2009, 05:34 AM

Now if we could just get rid of the ' agents ' working the site...

You know the one's I mean... They go to a thread, thro out a distracting
statement... Complain, abt statments made on a thread, or the subject
of the thread. complain about other members on a thread.

Anything to disssrupt a thread... They are being paid to disrupt a Site....

They're trying to get a reaction... If you see a post that makes NO sense
for the thread... "That's how they show their butt." Just watch, you'll spot
them. Right off. like they came out of No where, calls the members names.

Trooly,

Tango

Tango · 07-04-2009, 04:56 AM

Whew..... Wasn't that a ride.... PAY NO ATTENTION TO THE
MAN BEHIND THE CURTAIN....

Quote:

Originally Posted by Anchor

The database is not overloaded - there are only 150k posts on this board.

The problem is with the ISP. Getting technical support going is like squeezing blood out of a stone. There are plans to deal with this longer term, but right now things are not very good with the performance between vbulletin and the underlying database.

I am sorry about these problems which have gone on for a long time - much longer than they should - we are not going to give up on this.

It will probably take some time to get everything sorted out.

A..

Anchor · 07-04-2009, 05:02 AM

@Tango: If there is a man behind the curtain tell him from me to get f*ck*d, because I have had enough of it.

Personally I don't think this was anything to do with TPTB (or TPTW) , but I must acknowledge that your instincts were good on this one - database load was a factor (it should not have been, but was).

There is no longer any way in which I can get evidence of any artificially generated load because we are now on a different host and all access to the old one is turned off - so we will never know.

A..

Tango · 07-04-2009, 05:25 AM

Wouldn't the Man behind the ' curtain ' be the " HOST "....

You've changed your host; so whats to worry abt...

' being like this ' for forty yrs... Not really my choice....

I really do think I need to just watch, for a while, Not say
Anything... Respond... Just let it go...

You DO know the Host was just giving you a line of sfit, Right...

Don't answer that.... Please.... You guys just move forward...

I won't say anything abt circles, or triangles, squares, or other.....[wink]

Quote:

Originally Posted by Anchor

@Tango: If there is a man behind the curtain tell him from me to get f*ck*d, because I have had enough of it.

Personally I don't think this was anything to do with TPTB (or TPTW) , but I must acknowledge that your instincts were good on this one - database load was a factor (it should not have been, but was).

There is no longer any way in which I can get evidence of any artificially generated load because we are now on a different host and all access to the old one is turned off - so we will never know.

A..

07-04-2009, 05:32 AM

I think it's time for some grounding and centering.

BROOK · 07-04-2009, 05:47 AM

I want to say thank you for your diligence and hard work to get Avalon back up and running.

Big hugs and love

JoyAnna · 07-04-2009, 05:55 AM

back!!!! Thank you to all who worked to bring us all back together. I didn't realize how much I could miss this place until the door slammed shut.
JoyAnna

Anchor · 07-04-2009, 06:10 AM

There is a lesson here somewhere - something to do with preparedness

07-04-2009, 05:45 AM

Quote:

Originally Posted by Tango

Whew..... Wasn't that a ride.... PAY NO ATTENTION TO THE
MAN BEHIND THE CURTAIN....

Yes, it was!

peace and goodwill

PS - Does this mean anything? It appeared to the top of my screen in the preview post function.

Warning: include(/hermes/web03/b451/pow.projectavalon/htdocs/forum/amecache/findonly.php) [function.include]: failed to open stream: No such file or directory in [path]/includes/ame_bbcode.php on line 74

Warning: include() [function.include]: Failed opening '/hermes/web03/b451/pow.projectavalon/htdocs/forum/amecache/findonly.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in [path]/includes/ame_bbcode.php on line 74

06-29-2009, 11:00 PM	#1
Anchor Avalon Senior Member Join Date: Sep 2008 Location: Sydney, NSW, Australia Posts: 2,280	Re: Database Errors The database is not overloaded - there are only 150k posts on this board. The problem is with the ISP. Getting technical support going is like squeezing blood out of a stone. There are plans to deal with this longer term, but right now things are not very good with the performance between vbulletin and the underlying database. I am sorry about these problems which have gone on for a long time - much longer than they should - we are not going to give up on this. It will probably take some time to get everything sorted out. A.. Last edited by Anchor; 06-29-2009 at 11:05 PM.

06-30-2009, 04:44 PM	#2
metaw3 Avalon Senior Member Join Date: Oct 2008 Location: Canada Posts: 431	Re: Database Errors Here's what I do when there are many database errors: 1. I go to the new posts link in the top menu: http://projectavalon.net/forum/search.php?do=getnew 2. I open each thread I wanna read in a new window. There is always one that is going to load. 3. I refresh the others with database errors and read the ones that loaded. It's a cross-reading process that requires more concentration but at least I don't hang too long in front of blank pages.

07-06-2009, 10:11 AM	#5
WiNaDeYo Avalon Senior Member Join Date: Sep 2008 Location: Lombardy, Italy Posts: 222	Re: Database Errors - Restoring Avalon I'm finally back on...could log in, and my nick appeared in the logged-in list, but I couldn't post... finally got in today clicking the Avalon link on Camelot...how weird. My wholehearted thanks to the crew for getting the site back up after the fall! And, yes I was having all kinds of database errors pop up earlier, too. Peace and Good Will!

07-12-2009, 10:55 PM	#6
J_rod7 Avalon Senior Member Join Date: Sep 2008 Location: Florida, USA Posts: 301	Re: Database Errors - Restoring Avalon ***** * * Good job, switching to another host, getting it all back up. Anchor, you mentioned 'preparedness' Keep at it, please. I used to be in charge of a SCADA (Supervisory Control and Data Acquisition) Computer system - 10-years in a 180-Million Cu-Ft per-day Gas Processing plant. The System had two computers running at all times, one in control, and the other updating itself from the other. Once a week I would switch the Primary to Secondary and vice-versa. But if the running Primary ever went down, the Secondary would pick up the load running the plant plus a production field spanning 40-miles of wells and pipelines. These days, such tasks are done in a similar way with multiple drives in an array. Does the new Host run with back-up arrays? * * *****

07-21-2009, 05:34 AM	#7
Tango Avalon Senior Member Join Date: Sep 2008 Location: eating dessert in the desert of Arizona Posts: 1,554	Re: Database Errors - Restoring Avalon Now if we could just get rid of the ' agents ' working the site... You know the one's I mean... They go to a thread, thro out a distracting statement... Complain, abt statments made on a thread, or the subject of the thread. complain about other members on a thread. Anything to disssrupt a thread... They are being paid to disrupt a Site.... They're trying to get a reaction... If you see a post that makes NO sense for the thread... "That's how they show their butt." Just watch, you'll spot them. Right off. like they came out of No where, calls the members names. Trooly, Tango

07-04-2009, 05:02 AM	#9
Anchor Avalon Senior Member Join Date: Sep 2008 Location: Sydney, NSW, Australia Posts: 2,280	Re: Database Errors @Tango: If there is a man behind the curtain tell him from me to get fckd, because I have had enough of it. Personally I don't think this was anything to do with TPTB (or TPTW) , but I must acknowledge that your instincts were good on this one - database load was a factor (it should not have been, but was). There is no longer any way in which I can get evidence of any artificially generated load because we are now on a different host and all access to the old one is turned off - so we will never know. A..

07-04-2009, 05:32 AM	#11
sleepingnomore Guest Posts: n/a	Re: Database Errors - Restoring Avalon I think it's time for some grounding and centering.

07-04-2009, 05:47 AM	#12
BROOK Avalon Senior Member Join Date: Oct 2008 Posts: 3,117	Re: Database Errors - Restoring Avalon I want to say thank you for your diligence and hard work to get Avalon back up and running. Big hugs and love

07-04-2009, 05:55 AM	#13
JoyAnna Avalon Senior Member Join Date: Sep 2008 Location: Maple Falls, WA, USA Posts: 51	Re: Database Errors - Restoring Avalon back!!!! Thank you to all who worked to bring us all back together. I didn't realize how much I could miss this place until the door slammed shut. JoyAnna

07-04-2009, 06:10 AM	#14
Anchor Avalon Senior Member Join Date: Sep 2008 Location: Sydney, NSW, Australia Posts: 2,280	Re: Database Errors - Restoring Avalon There is a lesson here somewhere - something to do with preparedness