Database Errors - Restoring Avalon

[Seashore]

I see no moderators are online right now and Gareth is not online right now.

Perhaps nothing is being done?

Anyone have any ideas?

[Stargazer1965]

I have feeling when the site migrated over to the backup site that there is an inconsistency in the database....In other words....IT'S JACKED.....or JILLed

[Unified Serenity]

I've gotten a dozen errors already today! It does appear to be a major problem, and I find it hard to imagine that the housing server can't handle the visitor load. I hope we find out what is going wrong soon, and if nothing comes from the site handling Avalon's forum then I hope they move it to a site that will give proper service and performance. Yes, I know that is a very big headache.

[Tango]

To me the Dbase is overwelled... We can all help by removing private messages and un needed messages and Pictures use Huge amounts of searchable storage. We could also visit each others profile pages and remove OLD messages... I visited RMN and Rense; they are running normally...

I've beeen deleting all private messages... Send N' Recieves

There is som Really important stuff in here. That is/are important...
Need to find away to protect that. The hard disc should not have to go
acrosss all those messages doing a search.

Well, that's what I see... I remember the OLD MLS [Real Estate] system
had the same problem. Again, that was years ago.

That's just My opinion; I could be wrong... But, U know what they say abt
opinions... They're like Butts, everyone's got one.

I'm just saying I've seen this before on older systems.

Tango

Originally Posted by seashore

I see no moderators are online right now and Gareth is not online right now.

Perhaps nothing is being done?

Anyone have any ideas?

[Avid]

Originally Posted by Unified Serenity

I've gotten a dozen errors already today! It does appear to be a major problem, and I find it hard to imagine that the housing server can't handle the visitor load. I hope we find out what is going wrong soon, and if nothing comes from the site handling Avalon's forum then I hope they move it to a site that will give proper service and performance. Yes, I know that is a very big headache.

WoW! I managed to get online here after ages trying:
1. To read any posts
2. To answer any posts
Hopefully it's just a 'glitch'...

[day]

Originally Posted by orthodoxymoron

It's nothing to worry about. It's just the new NSA spyware. There is a fundamental incompatability between the NSA Cray Supercomputers, the Grey Supercomputers on the Dark Side of the Moon, and the World Wide Web. Reptilian technicians are working overtime to harmonize the discontinuities arising from the utilization of the computer binary code...and the instability of the reptilian entities which possess each and every personal computer. There's a reason why they call it 'the web'.

Ohhhhh so THATS what it is...maybe they want us to do this
and that....
and this...
and feel like that....

but maybe we instead will do this...
and feel like that.... ....

[Seashore]

[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..

[metaw3]

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.

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.

[Tango]

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

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]

@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]

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]

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..

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

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

[BROOK]

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

Big hugs and love

[JoyAnna]

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]

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

[Lorien]

Holt Cr*p! The forum is back up? Am I dreaming? Is this for real? >>pinches arm<< Ouch! Yeah, this is real!

Hope we didn't lose too many people because of this.

They will return!

Thank you to the Avalon volunteers. Moving hosts is a complicated job, especially with a big site. It's appreciated.

May the ship journey well... Project Phoenix, good one!

Gracias

[metaw3]

Good work! Great to have the forums back.

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]

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]

*******
***
*

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]

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