* FAQ    * Search  * Register * Login 
Active topics
Unanswered topics

All times are UTC-06:00



Post new topic  Reply to topic  [ 23 posts ] 
Author Message
 Post subject: Repeatedly getting this for small posts....
PostPosted: Mon Nov 29, 2010 1:12 pm 
Offline
DBB Artist
DBB Artist
User avatar

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


Top
   
 Post subject:
PostPosted: Mon Nov 29, 2010 2:33 pm 
Offline
DBB Admiral
DBB Admiral
User avatar

Joined: Wed Jul 14, 2010 10:29 am
Posts: 1447
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.


Top
   
 Post subject:
PostPosted: Mon Nov 29, 2010 3:23 pm 
Offline
DBB Material Defender
DBB Material Defender
User avatar

Joined: Tue Nov 23, 2004 3:31 pm
Posts: 4900
Location: Denver, Colorado, USA
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.


Top
   
 Post subject:
PostPosted: Mon Nov 29, 2010 4:08 pm 
Offline
The Feline Menace
User avatar

Joined: Thu May 24, 2007 12:49 pm
Posts: 2625
Website: http://vertigofox.bandcamp.com
Location: the realms of theory
That explains why some of the posting problems here seem to happen in cycles.


Top
   
 Post subject: Re:
PostPosted: Mon Nov 29, 2010 4:25 pm 
Offline
DBB Artist
DBB Artist
User avatar

Joined: Mon Aug 01, 2005 8:47 am
Posts: 7124
Location: Ơ̸̦͇̲̬̭̱̰͎̞͈̣͎͚̳ͬ͋̃̀̇͊͂͋͐ͦ̽ͣ̂ͥ͊̅̀̚͠ B̶͖̯͉̜̰̲̓̔͋̈́ͅ È̯ Y̪̤̼͉̠̙͝
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?


Top
   
 Post subject: Re:
PostPosted: Mon Nov 29, 2010 4:54 pm 
Offline
DBB Material Defender
DBB Material Defender
User avatar

Joined: Tue Nov 23, 2004 3:31 pm
Posts: 4900
Location: Denver, Colorado, USA
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.


Top
   
 Post subject:
PostPosted: Tue Nov 30, 2010 10:19 pm 
Offline
DBB Master
DBB Master
User avatar

Joined: Sun Sep 05, 1999 2:01 am
Posts: 6377
Location: ☃☃☃
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.


Top
   
 Post subject:
PostPosted: Thu Dec 02, 2010 7:50 pm 
Offline
DBB Artist
DBB Artist
User avatar

Joined: Mon Aug 01, 2005 8:47 am
Posts: 7124
Location: Ơ̸̦͇̲̬̭̱̰͎̞͈̣͎͚̳ͬ͋̃̀̇͊͂͋͐ͦ̽ͣ̂ͥ͊̅̀̚͠ B̶͖̯͉̜̰̲̓̔͋̈́ͅ È̯ Y̪̤̼͉̠̙͝
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.


Top
   
 Post subject:
PostPosted: Thu Dec 02, 2010 8:06 pm 
Offline
DBB Admiral
DBB Admiral
User avatar

Joined: Wed Jul 14, 2010 10:29 am
Posts: 1447
An upgrade to the latest version would fix it, but I wouldn't hold my breath.

_________________
Fear is the engine that destroys freedom.


Top
   
 Post subject:
PostPosted: Thu Dec 02, 2010 8:55 pm 
Offline
DBB Database Master
DBB Database Master
User avatar

Joined: Sun Nov 29, 1998 3:01 am
Posts: 15146
ICQ: 46028958
Website: http://krom.d3k.org
AOL: dutenhnj
Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
The only person with the ability to upgrade the forum software or correct the current issue (console level access) is currently M.I.A.


Top
   
 Post subject: Re:
PostPosted: Thu Dec 02, 2010 9:01 pm 
Offline
DBB Admiral
DBB Admiral
User avatar

Joined: Wed Jul 14, 2010 10:29 am
Posts: 1447
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.


Top
   
 Post subject:
PostPosted: Thu Dec 02, 2010 9:12 pm 
Offline
DBB Artist
DBB Artist
User avatar

Joined: Mon Aug 01, 2005 8:47 am
Posts: 7124
Location: Ơ̸̦͇̲̬̭̱̰͎̞͈̣͎͚̳ͬ͋̃̀̇͊͂͋͐ͦ̽ͣ̂ͥ͊̅̀̚͠ B̶͖̯͉̜̰̲̓̔͋̈́ͅ È̯ Y̪̤̼͉̠̙͝
Mike still kinda hovers around us, I think.


Top
   
 Post subject:
PostPosted: Fri Dec 03, 2010 12:53 am 
Offline
DBB Master
DBB Master
User avatar

Joined: Sun Sep 05, 1999 2:01 am
Posts: 6377
Location: ☃☃☃
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.


Top
   
 Post subject:
PostPosted: Fri Dec 03, 2010 1:06 pm 
Offline
DBB Admiral
DBB Admiral
User avatar

Joined: Wed Jul 14, 2010 10:29 am
Posts: 1447
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.


Top
   
 Post subject:
PostPosted: Fri Dec 03, 2010 1:07 pm 
Offline
DBB Captain
DBB Captain
User avatar

Joined: Mon Mar 08, 2004 6:03 am
Posts: 765
This doesn't happen to me much. Sounds like the server computer is racist against your client computer. :P


Top
   
 Post subject:
PostPosted: Fri Dec 03, 2010 1:28 pm 
Offline
DBB_Master
DBB_Master
User avatar

Joined: Thu Nov 05, 1998 12:01 pm
Posts: 9485
Location: Capital Of Canada
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.


Top
   
 Post subject:
PostPosted: Fri Dec 03, 2010 1:34 pm 
Offline
DBB Admiral
DBB Admiral
User avatar

Joined: Wed Jul 14, 2010 10:29 am
Posts: 1447
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.


Top
   
 Post subject:
PostPosted: Fri Dec 03, 2010 1:54 pm 
Offline
DBB Database Master
DBB Database Master
User avatar

Joined: Sun Nov 29, 1998 3:01 am
Posts: 15146
ICQ: 46028958
Website: http://krom.d3k.org
AOL: dutenhnj
Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
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.


Top
   
 Post subject: Re:
PostPosted: Fri Dec 03, 2010 2:23 pm 
Offline
DBB Admiral
DBB Admiral
User avatar

Joined: Wed Jul 14, 2010 10:29 am
Posts: 1447
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.


Top
   
 Post subject:
PostPosted: Fri Dec 03, 2010 2:38 pm 
Offline
DBB Master
DBB Master
User avatar

Joined: Sun Sep 05, 1999 2:01 am
Posts: 6377
Location: ☃☃☃
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. ;)


Top
   
 Post subject: Re:
PostPosted: Fri Dec 03, 2010 3:10 pm 
Offline
DBB Material Defender
DBB Material Defender
User avatar

Joined: Tue Nov 23, 2004 3:31 pm
Posts: 4900
Location: Denver, Colorado, USA
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.


Top
   
 Post subject: Re:
PostPosted: Fri Dec 03, 2010 3:24 pm 
Offline
DBB Database Master
DBB Database Master
User avatar

Joined: Sun Nov 29, 1998 3:01 am
Posts: 15146
ICQ: 46028958
Website: http://krom.d3k.org
AOL: dutenhnj
Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
Jeff250 wrote:
WIMP (Windows/IIS/MSSQL/PHP) stack


Correct: http://www.descentbb.net/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.


Top
   
 Post subject: Re:
PostPosted: Fri Dec 03, 2010 4:19 pm 
Offline
DBB Master
DBB Master
User avatar

Joined: Sun Sep 05, 1999 2:01 am
Posts: 6377
Location: ☃☃☃
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.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 23 posts ] 

All times are UTC-06:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  



Descent'rs have piloted these pages
 
The layout and contents contained within this site are © DescentBB.net 1997-2006.
Descent, Descent II are © Parallax Software Corporation.
Descent III is Outrage Entertainment.
Descent is a Trademark of Interplay Productions.

Miner Wars™ is trademark of Keen Software House s. r. o.
.


Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group