Posting Troubles - Page 2 at DVinfo.net

Go Back   DV Info Net > The Tools of DV and HD Production > Open DV Discussion

Open DV Discussion
For topics which don't fit into any of the other categories.


Reply
 
Thread Tools Search this Thread
Old March 7th, 2002, 11:24 AM   #16
Wrangler
 
Join Date: Dec 2000
Location: Austin, TX
Posts: 390
Images: 1
I think it has something to do with database corruption on this forum in particular. I'm posting to the Gl1 forum and it's lickety split. I'm guessing that this older version of vBulletin has a database corruption issue. Unfortunately, these problems aren't exactly easy to diagnose, and they're rarely the same thing twice. (And with JSP you'll probably have more problems with memory bloat than database speed.)
Jeff Kramer is offline   Reply With Quote
Old March 7th, 2002, 11:46 AM   #17
Wrangler
 
Join Date: Dec 2000
Location: Austin, TX
Posts: 390
Images: 1
Dum de dum, fixing tables and breaking databases...
Jeff Kramer is offline   Reply With Quote
Old March 7th, 2002, 11:56 AM   #18
Obstreperous Rex
 
Join Date: Jan 2001
Location: San Marcos, TX
Posts: 26,900
Images: 513
Ladies and gentlemen, our servermeister, Jeff Kramer. Many thanks, Jeff...
__________________
CH

Search DV Info Net | DV Info Net Sponsors | A Decade (+5) of DVi | ...Tuesday is Soylent Green Day!
Chris Hurd is offline   Reply With Quote
Old March 7th, 2002, 12:01 PM   #19
Retired DV Info Net Almunus
 
Join Date: Sep 2001
Location: Austin, TX USA
Posts: 2,882
Ditto, Jeff. Thanks...and thanks for the head up on issues that I should pass on to our programmers.
__________________
John Locke
SursumFilms.com
John Locke is offline   Reply With Quote
Old March 7th, 2002, 12:19 PM   #20
Retired DV Info Net Almunus
 
Join Date: Dec 2001
Location: Chicago, IL
Posts: 6,943
Jeff,
You're closest to the situation so take my suggestions for whatever they may be worth, perhaps nothing.

Before spending too much time trying to diagnose you might want to do a server restart. I know that you reported that the system is largely idle. But I have a suspicion that the message database's indexes, not the tables, may be contributing to the problem. If the indexes are maintained using ISAM or a close cousin (as many such products' indexes are) chances are that they are mainly resident in memory. The posting delay we're seeing is a typical symptom of a system having difficulty adding entries to an index. Restarting the server will clear memory and restarting the bbs may enable the indexes to be rebuilt from the tables.

Again, just an idea from afar. Thanks for your efforts on our behalf and good luck!
__________________
Lady X Films: A lady with a boring wardrobe...and a global mission.

Hey, you don't have enough stuff!
Buy with confidence from our sponsors. Hand-picked as the best in the business...Really!

See some of my work one frame at a time: www.KenTanaka.com
Ken Tanaka is offline   Reply With Quote
Old March 7th, 2002, 12:28 PM   #21
Wrangler
 
Join Date: Dec 2000
Location: Austin, TX
Posts: 390
Images: 1
I already restarted MySQL several times and repaired the tables (and vBulletin seems to have some bugs there, too, the tables are a mess), to no avail. I'm hoping that the newer version of vBulletin has some fixes. I'm betting that they're trying to clean up the tables on every post, which is taking forever. Perhaps the new version either has a cleaner way of doing it, or doesn't do it at all. (But I haven't heard back from vBulletin yet.)

I did manage to dump all the tables to a backup, so if worst comes to worst I can just re-install from scratch.
Jeff Kramer is offline   Reply With Quote
Old March 7th, 2002, 01:43 PM   #22
Obstreperous Rex
 
Join Date: Jan 2001
Location: San Marcos, TX
Posts: 26,900
Images: 513
Seems to be working *much* better now... many thanks. This fix should hold until we're able to upgrade to the most recent version of the forum software (within the next week, hopefully).
__________________
CH

Search DV Info Net | DV Info Net Sponsors | A Decade (+5) of DVi | ...Tuesday is Soylent Green Day!
Chris Hurd is offline   Reply With Quote
Old March 7th, 2002, 01:51 PM   #23
Major Player
 
Join Date: Dec 2001
Location: Cheshire, England
Posts: 105
Much better!
Thanks Jeff, thanks Chris.
Dan C. is offline   Reply With Quote
Old March 7th, 2002, 02:09 PM   #24
Retired DV Info Net Almunus
 
Join Date: Dec 2001
Location: Chicago, IL
Posts: 6,943
Very nice. Thank you, Jeff!
__________________
Lady X Films: A lady with a boring wardrobe...and a global mission.

Hey, you don't have enough stuff!
Buy with confidence from our sponsors. Hand-picked as the best in the business...Really!

See some of my work one frame at a time: www.KenTanaka.com
Ken Tanaka is offline   Reply With Quote
Old March 7th, 2002, 06:54 PM   #25
Major Player
 
Join Date: Dec 2001
Location: Seattle, WA
Posts: 540
Hey, this isn't really a problem. I write my post, hit the Submit button, go to work, and when I come in the evening, it's posted! So.....is it not supposed to work that way? :)

Cheers
__________________
-- Vic Owen --
Vic Owen is offline   Reply With Quote
Old March 7th, 2002, 07:12 PM   #26
Trustee
 
Join Date: Oct 2001
Location: Chigasaki, Japan.
Posts: 1,660
Faster than an aussie to a free beer. Thanks guys
Adrian Douglas is offline   Reply
Reply

DV Info Net refers all where-to-buy and where-to-rent questions exclusively to these trusted full line dealers and rental houses...

Professional Video
(800) 833-4801
Portland, OR

B&H Photo Video
(866) 521-7381
New York, NY

Z.G.C.
(973) 335-4460
Mountain Lakes, NJ

Abel Cine Tech
(888) 700-4416
N.Y. NY & L.A. CA

Precision Camera
(800) 677-1023
Austin, TX

DV Info Net also encourages you to support local businesses and buy from an authorized dealer in your neighborhood.
  You are here: DV Info Net > The Tools of DV and HD Production > Open DV Discussion

Thread Tools Search this Thread
Search this Thread:

Advanced Search

 



Google
 

All times are GMT -6. The time now is 11:50 PM.


DV Info Net -- Real Names, Real People, Real Info!
1998-2017 The Digital Video Information Network