Advertise on Bikeforums.net



User Tag List

Results 1 to 16 of 16

Thread: Forums

  1. #1
    Member
    Join Date
    Jul 2006
    Posts
    36
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Forums

    The forums are now back online and should be working correctly for the most part.

    There does appear to be some missing threads towards the end of the table which we are unable to recover due to the way it has repaired.

    Whilst repairing the table the database server kernel paniced which corrupted the thread and user tables. The temporary data files were so corrupt that they infact were reading 16tb in disk usage(incorrect), we have recovered these and the only things that appear to be missing is some newer threads, instead of restoring a backup from yesterday this seems the best course of action to sustain.

    However due to the consistant kernel panics the database server encounters we are deciding on what to do about it, we do however have the kernel panic and have repaired the main cause of that now.

    Apologises for the extended downtime however we could not have prevented it.

    -Scott

  2. #2
    Hey guyz? Guyz? Wait up!! Siu Blue Wind's Avatar
    Join Date
    Apr 2005
    Posts
    10,497
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Scott, I did not understand a word you just said but thank you to you and Joe anyway.
    Quote Originally Posted by Buddha
    We are what we think. All that we are arises with our thoughts. With our thoughts, we make the world.
    Quote Originally Posted by making View Post
    Please dont outsmart the censor. That is a very expensive censor and every time one of you guys outsmart it it makes someone at the home office feel bad. We dont wanna do that. So dont cleverly disguise bad words.

  3. #3
    Non Tribuo Anus Rodentum and off to the next adventure (RIP) Stacey's Avatar
    Join Date
    Dec 2002
    Posts
    9,163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    He said that the kernel (Colonel?) is prone to anexiety attacks and needs the help of a good psycartrist

  4. #4
    Senior Member DannoXYZ's Avatar
    Join Date
    Jul 2005
    Location
    Saratoga, CA
    Posts
    11,496
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Good job guys! I think we should line up an alternate supplier of chickens so that the Colonel doesn't panic when the supply gets low...

  5. #5
    370H-SSV-0773H linux_author's Avatar
    Join Date
    May 2005
    Location
    Penniless Park, Fla.
    My Bikes
    Merlin Fortius, Specialized Crossroads & Rockhopper, Serotta Fierte, Pedal Force RS2
    Posts
    2,760
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  6. #6
    Flatman RoadToad's Avatar
    Join Date
    Jun 2004
    Location
    Texas
    My Bikes
    Giant TCR2
    Posts
    923
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    huh?
    BRING THE HEAT

  7. #7
    Air
    Air is offline
    Destroyer of Wheels Air's Avatar
    Join Date
    May 2006
    Location
    Creating some FA-Qs
    My Bikes
    Nishiki Sport, Downtube IXNS, 1950's MMB3 Russian Folding Bike, MTB
    Posts
    3,564
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Someone feed that man a chicken!

    Great job guys, thannks!

  8. #8
    HEY! I'm talkin' to YOU! Fritz_S's Avatar
    Join Date
    Nov 2006
    Location
    Sunnyvale, CA (Silicon Valley)
    My Bikes
    Trek 7.5/FX 2006, 1980's Specialized Allez
    Posts
    45
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Any hope at all that more of the lost recent threads will be restored? I am a junior member, so 1/2 of my subscribed threads, and 3/4 of my postings are GONE! I may never forget how to ride a bike, but I might forget (for example) where that advice on fitting a saddle went. (whine, ..whinge, ..., whimper, ...) -- but THANKS to the heroic IT folks for all they could save!!
    2006 Trek 7.5 FX
    ~1992 vintage Specialized Allez

  9. #9
    Long Distance Cyclist Machka's Avatar
    Join Date
    Jan 2003
    Location
    I ride where the thylacine roamed!
    My Bikes
    Lots
    Posts
    37,716
    Mentioned
    18 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by HostGeekZ
    The forums are now back online and should be working correctly for the most part.

    There does appear to be some missing threads towards the end of the table which we are unable to recover due to the way it has repaired.

    we have recovered these and the only things that appear to be missing is some newer threads, instead of restoring a backup from yesterday this seems the best course of action to sustain.

    Newer threads .... like everything in the last MONTH or so? It was like some weird Twilight Zone flashback coming on here today!! Can any of it be restored?

  10. #10
    Non Tribuo Anus Rodentum and off to the next adventure (RIP) Stacey's Avatar
    Join Date
    Dec 2002
    Posts
    9,163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Fritz_S
    Any hope at all that more of the lost recent threads will be restored? I am a junior member, so 1/2 of my subscribed threads, and 3/4 of my postings are GONE! I may never forget how to ride a bike, but I might forget (for example) where that advice on fitting a saddle went. (whine, ..whinge, ..., whimper, ...) -- but THANKS to the heroic IT folks for all they could save!!

    Want some



    with that whine?


  11. #11
    Member
    Join Date
    Jul 2006
    Posts
    36
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hello,

    It does appear more than just a few threads from the bottom of the table are missing as originally thought. Due to the options available being leave it as it presently is, roll back to yesterday(loosing a full day of posting, which would also mean another 8 hours just to repair) it's best just to leave it like it is.

    Unfortunately all missing threads will not be returning and will have to be re-created, we are looking into possibly inserting specific data from those threads to newly created ones.

    This is essentially what happened, we were reparing the database(because it was not showing the post body, this is due to the table being corrupt), in the middle of repairing the threads table the kernel paniced which caused the server to halt in the middle of repairing the data files, when it was back online the thread table was reporting a 127 error(MySQL error code 127: Record-file is crashed), we recovered this as much as we could as the usual mysql repairing tools(myisamchk,mysqlcheck) are not designed to recover in such a way and all they done was loop over and over until the disk was full. After recovering everything we could from the TMD file we made this the new data file(hence some missing threads) and then began to repair the index to have the id's resort in order.

    What all of that means is, the database crashed while being repaired, that broke the threads completely, we recovered rather than restoring a backup(loosing a day worth of data), at first it appeared only a few threads were missing but there does appear to be more than the initial inspection however now it's not worth going back to well over 24 hours worth of data being missing and another 8 hours of downtime to repair this.

    All we can do is apologize for the inconvenience and we are looking into making sure this doesn't happen again, starting with a new database server to resolve the constant problems the present one has.

    -Scott

  12. #12
    Huachuca Rider webist's Avatar
    Join Date
    Jun 2002
    Location
    Charlotte, NC
    My Bikes
    Fuji CCR1, Specialized Roubaix
    Posts
    4,274
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by HostGeekZ
    All we can do is apologize for the inconvenience and we are looking into making sure this doesn't happen again, starting with a new database server to resolve the constant problems the present one has.

    -Scott
    Does Joe have enough cash reserves to accomplish this? Or, do we need to have a fundraiser?
    Just Peddlin' Around

  13. #13
    Portland Fred banerjek's Avatar
    Join Date
    Oct 2005
    My Bikes
    Custom Winter, Challenge Seiran SL, Fuji Team Pro, Cattrike Road/Velokit, РOS hybrid
    Posts
    10,390
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by HostGeekZ
    Unfortunately all missing threads will not be returning and will have to be re-created, we are looking into possibly inserting specific data from those threads to newly created ones.
    As good luck would have it, topics tend to be revisited frequently on BF anyway....

  14. #14
    Utility Cyclist
    Join Date
    Oct 2006
    Posts
    345
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    For them wot don't know what "kernal panic" means, it's a term from a particular computing subculture meaning that the central part of the software that runs the server got completely confused, stopped working (which is not unlike "stopped juggling the chainsaws"), and screamed for help.

    A public-service announcement from a retired nerd.

  15. #15
    Utility Cyclist
    Join Date
    Oct 2006
    Posts
    345
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I hope someone is still working hard on the forum software, btw. I've noticed that the paging is broken...you won't necessarily see all the posts in a thread unless you diddle around with the posts-per-page option.

  16. #16
    Senior Member Brian's Avatar
    Join Date
    Nov 2004
    Location
    Between the mountains and the lake.
    My Bikes
    8 bikes - one for each day of the week!
    Posts
    16,745
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Siu Blue Wind
    Scott, I did not understand a word you just said but thank you to you and Joe anyway.
    The server's farked. Carked it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •