Repeatedly getting this for small posts....

For questions, special requests, or any complaints concerning the Descent BB.

Moderators: Richard Cranium, KoolBear, Krom, Lothar

Post Reply
User avatar
Isaac
DBB Artist
DBB Artist
Posts: 7127
Joined: Mon Aug 01, 2005 8:47 am
Location: Ơ̸̦͇̲̬̭̱̰͎̞͈̣͎͚̳ͬ͋̃̀̇͊͂͋͐ͦ̽ͣ̂ͥ͊̅̀̚͠ B̶͖̯͉̜̰̲̓̔͋̈́ͅ È̯ Y̪̤̼͉̠̙͝

Repeatedly getting this for small posts....

Post by Isaac » Mon Nov 29, 2010 1:12 pm

Image
User avatar
null0010
DBB Admiral
DBB Admiral
Posts: 1447
Joined: Wed Jul 14, 2010 10:29 am

Post by null0010 » Mon Nov 29, 2010 2:33 pm

considering this forum is running on software that has to be at least 5 years old i wouldnt expect a fix for that anytime soon. it happens to me often, too
Fear is the engine that destroys freedom.
User avatar
Foil
DBB Material Defender
DBB Material Defender
Posts: 4900
Joined: Tue Nov 23, 2004 3:31 pm
Location: Denver, Colorado, USA

Post by Foil » Mon Nov 29, 2010 3:23 pm

From all signs, this board has a huge search-index table which gets updated/queried for every post/edit. If it takes too long, the process times out.

We periodically have to get an admin to get things cleaned up, which apparently causes loss of some of the oldest posts.
User avatar
Alter-Fox
The Feline Menace
Posts: 2661
Joined: Thu May 24, 2007 12:49 pm
Location: the realms of theory
Contact:

Post by Alter-Fox » Mon Nov 29, 2010 4:08 pm

That explains why some of the posting problems here seem to happen in cycles.
User avatar
Isaac
DBB Artist
DBB Artist
Posts: 7127
Joined: Mon Aug 01, 2005 8:47 am
Location: Ơ̸̦͇̲̬̭̱̰͎̞͈̣͎͚̳ͬ͋̃̀̇͊͂͋͐ͦ̽ͣ̂ͥ͊̅̀̚͠ B̶͖̯͉̜̰̲̓̔͋̈́ͅ È̯ Y̪̤̼͉̠̙͝

Re:

Post by Isaac » Mon Nov 29, 2010 4:25 pm

Foil wrote:this board has a huge search-index table
You mean as in the "search" tool at the top of the page that hardly works right? So if we disabled the indexing, allowing users to use Advanced Google search instead, we wouldn't even have this problem?
User avatar
Foil
DBB Material Defender
DBB Material Defender
Posts: 4900
Joined: Tue Nov 23, 2004 3:31 pm
Location: Denver, Colorado, USA

Re:

Post by Foil » Mon Nov 29, 2010 4:54 pm

Isaac wrote:
Foil wrote:this board has a huge search-index table
You mean as in the "search" tool at the top of the page that hardly works right?
*I* think so.

Disclaimer: That's just my inference, based on what I'm seeing in the error message, and based on the cyclic (fixed, then gets worse, fixed again, gets worse again) nature of the problem.
User avatar
Jeff250
DBB Master
DBB Master
Posts: 6387
Joined: Sun Sep 05, 1999 2:01 am
Location: ☃☃☃

Post by Jeff250 » Tue Nov 30, 2010 10:19 pm

Do we know what would fix this and the other glitches more permanently? phpBB 3.x? A LAMP stack? Surely there are larger phpBB's than us out there that have gotten past this? The \"wait for the DBB admin to notice that it's broken again and apply his kludge\" approach becomes a bit more frustrating each time the DBB breaks.
User avatar
Isaac
DBB Artist
DBB Artist
Posts: 7127
Joined: Mon Aug 01, 2005 8:47 am
Location: Ơ̸̦͇̲̬̭̱̰͎̞͈̣͎͚̳ͬ͋̃̀̇͊͂͋͐ͦ̽ͣ̂ͥ͊̅̀̚͠ B̶͖̯͉̜̰̲̓̔͋̈́ͅ È̯ Y̪̤̼͉̠̙͝

Post by Isaac » Thu Dec 02, 2010 7:50 pm

No one get mad at me for not editing... I'm giving up at this point. I'll just add new posts right after my last one.
User avatar
null0010
DBB Admiral
DBB Admiral
Posts: 1447
Joined: Wed Jul 14, 2010 10:29 am

Post by null0010 » Thu Dec 02, 2010 8:06 pm

An upgrade to the latest version would fix it, but I wouldn't hold my breath.
Fear is the engine that destroys freedom.
User avatar
Krom
DBB Database Master
DBB Database Master
Posts: 15185
Joined: Sun Nov 29, 1998 3:01 am
Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
Contact:

Post by Krom » Thu Dec 02, 2010 8:55 pm

The only person with the ability to upgrade the forum software or correct the current issue (console level access) is currently M.I.A.
User avatar
null0010
DBB Admiral
DBB Admiral
Posts: 1447
Joined: Wed Jul 14, 2010 10:29 am

Re:

Post by null0010 » Thu Dec 02, 2010 9:01 pm

Krom wrote:The only person with the ability to upgrade the forum software or correct the current issue (console level access) is currently M.I.A.
epic
Fear is the engine that destroys freedom.
User avatar
Isaac
DBB Artist
DBB Artist
Posts: 7127
Joined: Mon Aug 01, 2005 8:47 am
Location: Ơ̸̦͇̲̬̭̱̰͎̞͈̣͎͚̳ͬ͋̃̀̇͊͂͋͐ͦ̽ͣ̂ͥ͊̅̀̚͠ B̶͖̯͉̜̰̲̓̔͋̈́ͅ È̯ Y̪̤̼͉̠̙͝

Post by Isaac » Thu Dec 02, 2010 9:12 pm

Mike still kinda hovers around us, I think.
User avatar
Jeff250
DBB Master
DBB Master
Posts: 6387
Joined: Sun Sep 05, 1999 2:01 am
Location: ☃☃☃

Post by Jeff250 » Fri Dec 03, 2010 12:53 am

Have we considered giving a second person the reigns? The DBB is surely full of enough qualified and trustworthy people with the adequate free time.
User avatar
null0010
DBB Admiral
DBB Admiral
Posts: 1447
Joined: Wed Jul 14, 2010 10:29 am

Post by null0010 » Fri Dec 03, 2010 1:06 pm

i showed the forum to a tech-savvy friend of mine who knows phpbb and he indicated that the problem was not the old software as much as it is the software being improperly configured
Fear is the engine that destroys freedom.
User avatar
Neo
DBB Captain
DBB Captain
Posts: 765
Joined: Mon Mar 08, 2004 6:03 am

Post by Neo » Fri Dec 03, 2010 1:07 pm

This doesn't happen to me much. Sounds like the server computer is racist against your client computer. :P
User avatar
CDN_Merlin
DBB_Master
DBB_Master
Posts: 9486
Joined: Thu Nov 05, 1998 12:01 pm
Location: Capital Of Canada

Post by CDN_Merlin » Fri Dec 03, 2010 1:28 pm

I think the reason we haven't upgraded is because there are to many \"hacks' in this version that would take forever to get working on a new version. I say, forget the old and bring in the new.

edit(I received some weird error when I posted this the first time).

Time for upgrade.
User avatar
null0010
DBB Admiral
DBB Admiral
Posts: 1447
Joined: Wed Jul 14, 2010 10:29 am

Post by null0010 » Fri Dec 03, 2010 1:34 pm

Yeah, like the custom theme and the litle bit at the bottom where it says \"Material Defenders\" instead of \"members.\"
Fear is the engine that destroys freedom.
User avatar
Krom
DBB Database Master
DBB Database Master
Posts: 15185
Joined: Sun Nov 29, 1998 3:01 am
Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
Contact:

Post by Krom » Fri Dec 03, 2010 1:54 pm

Those modifications are simple and microscopic edits to the boards language files which are largely independent of the core functionality. This forum can be upgraded. The most difficult part of the process would probably be working the server configuration, IIRC at present the DBB has a separate database server and two load balanced / redundant front end servers.
User avatar
null0010
DBB Admiral
DBB Admiral
Posts: 1447
Joined: Wed Jul 14, 2010 10:29 am

Re:

Post by null0010 » Fri Dec 03, 2010 2:23 pm

Krom wrote:Those modifications are simple and microscopic edits to the boards language files which are largely independent of the core functionality. This forum can be upgraded. The most difficult part of the process would probably be working the server configuration, IIRC at present the DBB has a separate database server and two load balanced / redundant front end servers.
Oh, I know. I just imagine they are "reasons" for not upgrading.
Fear is the engine that destroys freedom.
User avatar
Jeff250
DBB Master
DBB Master
Posts: 6387
Joined: Sun Sep 05, 1999 2:01 am
Location: ☃☃☃

Post by Jeff250 » Fri Dec 03, 2010 2:38 pm

Krom, those things seem like premature optimizations. The DBB doesn't get *that* much traffic. The glitchy software is the performance bottleneck at this point. Why not leave load balancing the servers as the icing on the cake?
null0010 wrote:i showed the forum to a tech-savvy friend of mine who knows phpbb and he indicated that the problem was not the old software as much as it is the software being improperly configured
IIRC, this is also being hosted on a WIMP (Windows/IIS/MSSQL/PHP) stack, which used to be a second-class platform for php. I'm not sure if this is still the case, as I have no personal interest in that particular stack. ;)
User avatar
Foil
DBB Material Defender
DBB Material Defender
Posts: 4900
Joined: Tue Nov 23, 2004 3:31 pm
Location: Denver, Colorado, USA

Re:

Post by Foil » Fri Dec 03, 2010 3:10 pm

Jeff250 wrote:The glitchy software is the performance bottleneck at this point.
Hm, I think the problem is more that over the years, the database has overgrown. Thus the periodic slowdowns when the index table (referenced in the error) grows too large.
User avatar
Krom
DBB Database Master
DBB Database Master
Posts: 15185
Joined: Sun Nov 29, 1998 3:01 am
Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
Contact:

Re:

Post by Krom » Fri Dec 03, 2010 3:24 pm

Jeff250 wrote:WIMP (Windows/IIS/MSSQL/PHP) stack
Correct: 404.html

Yes it is overkill, the DBB could probably run smoothly on a Pentium II CPU system given the right stack.

AFAIK the slowdown is a problem with how phpbb 2.x handles searches and either some compatibility or corruption problem with the stack or more likely the database. It wouldn't be an issue in an upgrade because phpbb3.x can use SQL native search and doesn't use or maintain a search table like 2.x does. All the other mods and hacks are mostly cosmetic.
User avatar
Jeff250
DBB Master
DBB Master
Posts: 6387
Joined: Sun Sep 05, 1999 2:01 am
Location: ☃☃☃

Re:

Post by Jeff250 » Fri Dec 03, 2010 4:19 pm

Foil wrote:Hm, I think the problem is more that over the years, the database has overgrown. Thus the periodic slowdowns when the index table (referenced in the error) grows too large.
Somewhere, someone is doing something wrong. Databases when used right scale very well.
Post Reply