Results 1 to 12 of 12

Thread: Problems posting Thursday night

  1. #1
    Join Date
    Aug 2007
    Posts
    35,504

    Default Problems posting Thursday night

    I had put this notice up overnight, but am now taking it down now so people don't have to see it every time they login. Here's what I had posted last night about the database errors that were occurring when trying to create a new post.

    Sometime Thursday the BroncosForums vBulletin database became corrupt. We are attempting to repair the table, but so far we have had no success.

    A further complication is that the database backup performed at 11:15pm Thursday, also appears to be corrupt, so if we are unable to repair the database, we will have to revert back to the backup from 11:15 am Thursday morning.

    I will get this resolved as soon as possible. Tned

    Update 12:45 AM EDT: it appears the table that was corrupt is a search table. It's what is checked when we search for posts on BF. While multiple repairs have failed, it now says the table is repaired. However, this happened earlier and then it became corrupt again. I may need to delete that table and have vBulletin rebuild the index which will take many hours.

    For now, it is ok to post. In fact, it is a good thing, since every new post writes to that table and it will help determine if it is fixed.

    Update 1:45 AM EDT: While the errors seemed to go away, the search index did not appear correct. I did some test searches and the results didn't seem right. Therefore, I deleted and recreated the table that was corrupt (to try and insure there is no residual problem), and then deleted all search indexes and started a search index rebuild.

    This search rebuild can take a while on 1.5 million posts. It's moving along at a pretty good clip, so if it doesn't slow down, it should finish in 2-3 hours. Until it finishes, most searches will return no threads, or only the ones that it has indexed so far.

    Please note that "New Posts" IS a search, so until this reindexing of the search data completes, the new post button (and today's posts) will not be reliable. Please go directly to the forums (Broncos Talk, Other NFL, Lounge, etc.) to check for new posts/threads.

    You can remove this notice by clicking the x to the upper right of this notice box.
    The rebuilding of the indexes worked successfully, and the best I can tell, everything is back to normal with no data/posts lost. I'm not sure exactly how long the problem was happening yesterday evening. I know while testing it I had some posts go through, while others would give me a DB error.

    I think we are in the clear now. To be safe, in addition to the full backups that take place overnight, I am adding one more backup of the forum database during the day. So in addition to the forum backup at 10am and 10pm central time, I have now added a backup at 4:00 Central time. While these database backups are going on, you could have the forum "hang" for 30-60 seconds or so, where your page won't load, because it needs to get a clean backup, so it pauses database requests.

    Sorry for any headaches this caused last night.

  2. The Following 2 Users High Fived Tned For This Post:


  3. #2
    Join Date
    Dec 2007
    Location
    5,280
    Posts
    18,433

    Default

    When do you sleep?

  4. #3
    Join Date
    Aug 2007
    Posts
    35,504

    Default

    Quote Originally Posted by BroncoJoe View Post
    When do you sleep?
    If things go well, right after I take a shower in 5 minutes. I only got three hours sleep Wed night, doing last minute packing and other stuff for this trip i'm on, and then ban, I get back to my hotel last night and see this DB error happened and I got less than three sleep last night. I was sucking down coffee all day today trying to stay awake in meetings. Looking forward to 7-8 hours sleep tonight!!!

  5. #4
    Join Date
    Dec 2007
    Adopted Bronco:
    MO
    Posts
    29,576

    Default

    Having trouble posting (quick reply), editing posts, replying with quote, etc.

    Pretty seamless transition
    Quote Originally Posted by Day1BroncoFan View Post
    I'm happier than tom brady in a gay bar....
    Quote Originally Posted by Buff View Post
    I am dense and slow...

  6. #5
    Join Date
    Jun 2008
    Posts
    13,221

    Default

    Quote Originally Posted by slim View Post
    Having trouble posting (quick reply), editing posts, replying with quote, etc.

    Pretty seamless transition
    I couldn't use the "quick reply" option on this thread. The irony amuses me.
    This space available for lease.

  7. #6
    Join Date
    Dec 2007
    Adopted Bronco:
    MO
    Posts
    29,576

    Default

    Quote Originally Posted by gnomeflinger View Post
    I couldn't use the "quick reply" option on this thread. The irony amuses me.
    My PM box is empty.
    Quote Originally Posted by Day1BroncoFan View Post
    I'm happier than tom brady in a gay bar....
    Quote Originally Posted by Buff View Post
    I am dense and slow...

  8. #7
    Join Date
    Aug 2007
    Posts
    35,504

    Default

    Yea, I'm checking on that. I'm not sure why the quick reply has stopped working.

    What browsers are you guys using?

  9. #8
    Join Date
    Dec 2007
    Adopted Bronco:
    MO
    Posts
    29,576

    Default

    IE8

    It seems to be working now.
    Quote Originally Posted by Day1BroncoFan View Post
    I'm happier than tom brady in a gay bar....
    Quote Originally Posted by Buff View Post
    I am dense and slow...

  10. #9
    Join Date
    Aug 2007
    Posts
    35,504

    Default

    Quote Originally Posted by slim View Post
    IE8

    It seems to be working now.
    It seems intermittment to me. I did just change a vB setting regarding IE compatibility. Let's see if that fixes it. I've also posted on vBulletin.com. Others are complaining about the problem, but I have yet to read a solution.

  11. The Following User High Fived Tned For This Post:


  12. #10
    Join Date
    Jun 2008
    Posts
    13,221

    Default

    It's working now. I thought it was just some random blip in the system. I use Firefox.
    This space available for lease.

  13. #11
    Join Date
    Dec 2007
    Adopted Bronco:
    MO
    Posts
    29,576

    Default

    Dent is right, it is intermittent.

    Not working again.
    Quote Originally Posted by Day1BroncoFan View Post
    I'm happier than tom brady in a gay bar....
    Quote Originally Posted by Buff View Post
    I am dense and slow...

  14. #12
    Join Date
    Aug 2007
    Posts
    35,504

    Default

    Yep. I'll keep checking wtih vBulletin and see if I can find a solution. Also, sometime in the next week or so, I'm going to upgrade to a much faster/more powerful server. As the server is rebuilt from scratch, if there is a server issue, hopefully it will be addressed with the move/rebuild.

Go
Shop AFC Champions and Super Bowl gear at the official online Pro Shop of the Denver Broncos!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Server crashed last night -- anyone having problems today?
    By Tned in forum Town Hall Discussion
    Replies: 17
    Last Post: 12-19-2010, 03:01 AM
  2. Moreno could play for Broncos Thursday night
    By Magnificent Seven in forum Broncos Talk
    Replies: 16
    Last Post: 09-03-2009, 09:35 AM
  3. Problems posting....
    By LordTrychon in forum Town Hall Discussion
    Replies: 4
    Last Post: 12-12-2008, 08:57 PM
  4. Broncos vs. Browns on Thursday Night. (Nov.6th)
    By Magnificent Seven in forum Broncos Talk
    Replies: 2
    Last Post: 10-14-2008, 08:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
status.broncosforums.com - BroncosForums status updates
dedicated servers
Partner with the USA Today Sports Media Group