| Author |
Message |
|
Groucho
Extraordinary
Joined: Thu Oct 21, 2004 9:30 pm
Posts: 12096
Location: Stroudsburg, PA
|
 OK, so what happened?! Tried to sign on last night and got error messages at every turn. Then I received an email telling me to go to Filmgasm where I applied but have not been approved. Everyone was blaming everyone else and rumors about KJ being taken down and other stuff was posted everywhere.
So what's the truth?
_________________Buy my books! http://michaelaventrella.com
|
| Fri Aug 28, 2009 1:56 pm |
 
|
|
|
Chippy
KJ's Leading Pundit
Joined: Tue Oct 12, 2004 4:45 pm
Posts: 63026
Location: Tonight... YOU!
|
Re: OK, so what happened?! Eagle wrote: Heh, I'll try and explain better for anyone interested ... basically ... each post has a unique number:
Post 1, Post 2, Post 3, etc. When someone makes a post, the database will automatically give that post the next unique number. Unfortunatly, something happened in the middle of an insert, meaning a record was entered into the database as Post 4, but the database got amnesia and doesn't remember inserting it. Well, the next time someone tried to post, the database again tried to insert the new post as Post 4 and was like "Hey, who the hell are you! There's not supposed to be a Post 4 here!"
That's the basic issue, and fixing that issue isn't as simple as you'd expect. Each time a post is made, the posts table is LOCKED temporarily, and UNLOCKED when the insert completes. Well, since it never finished inserting correctly, the table remained LOCKED, which causes all kinds of headaches. All attempts to unlock the table resulted in the fail whale.
The only way to fix these two problems is a series of repairs on the database, but because the table is so huge (~1.5 million records), attempts to repair it were causing the HTTP service to crash. To get around that, I had to run the repair via command line, but part of the repair process is to build a temporary index file which was too big for the directory it builds in. Meaning it ran out of space and couldn't fully rebuild the database. To give the specific partition more space, I'd have to reformat the entire server, and I didn't want to do that. So I then decided to rebuild the index in memory, which was very SLOW, but seemed to be working. Unfortunatly, when that process finished, it threw an error saying the database was still marked as crashed, and rebuilding the index wasn't sufficient to repair it. Yeesh!!!
So I had to rebuild not only the table indexes, but also the file holding all the data of the database. I kicked that process off before bed, it finished early this morning. Ta Da!
Bet you wish you hadn't asked, heh. _________________trixster wrote: shut the fuck up zwackerm, you're out of your fucking element trixster wrote: chippy is correct
|
| Fri Aug 28, 2009 1:57 pm |
|
|
|
Korrgan
problem?
Joined: Tue Oct 19, 2004 6:52 am
Posts: 15515
Location: Bait Shop
|
Re: OK, so what happened?! _________________
|
| Fri Aug 28, 2009 3:30 pm |
|
|
|
trixster
loyalfromlondon
Joined: Wed Oct 13, 2004 6:31 pm
Posts: 19697
Location: ville-marie
|
Re: OK, so what happened?! I can't believe you guys went to FILMGASM instead of just waiting a day or two. Even torrino.net would have been preferable.
_________________Magic Mike wrote: zwackerm wrote: If John Wick 2 even makes 30 million I will eat 1,000 shoes. Same. Algren wrote: I don't think. I predict. 
|
| Sat Aug 29, 2009 5:20 am |
|
|
|
zingy
College Boy Z
Joined: Mon Oct 11, 2004 8:40 pm
Posts: 36662
|
Re: OK, so what happened?! The look of the filmgasm board really bothered me, so I didn't stay and register
|
| Sat Aug 29, 2009 11:17 am |
|
|
|
Shack
Devil's Advocate
Joined: Sun Jul 31, 2005 2:30 am
Posts: 40494
|
Re: OK, so what happened?! trixster wrote: I can't believe you guys went to FILMGASM instead of just waiting a day or two. Even torrino.net would have been preferable. On the other hand, torrino.net was infested by snack spam... _________________Shack’s top 50 tv shows - viewtopic.php?f=8&t=90227
|
| Sat Aug 29, 2009 3:36 pm |
|
|
|
harry713
Future Love
Joined: Mon Feb 18, 2008 9:05 pm
Posts: 4519
Location: The Fame Ball 2009
|
Re: OK, so what happened?! trixster wrote: I can't believe you guys went to FILMGASM instead of just waiting a day or two. Even torrino.net would have been preferable. I am part owner of Filmgasm, therefore your statement is entirely incorrect. But I forgive you. Cheers. _________________
|
| Sun Aug 30, 2009 12:02 pm |
|
|
|
harry713
Future Love
Joined: Mon Feb 18, 2008 9:05 pm
Posts: 4519
Location: The Fame Ball 2009
|
Re: OK, so what happened?! zingy wrote: The look of the filmgasm board really bothered me, so I didn't stay and register There are 8 different board styles. _________________
|
| Sun Aug 30, 2009 12:05 pm |
|
|
|
Gulli
Jordan Mugen-Honda
Joined: Mon May 01, 2006 9:53 am
Posts: 13403
|
Re: OK, so what happened?! Nothing wrong with Filmgasm lads tis a friendly place.
_________________
Rosberg was reminded of the fuel regulations by his wheel's ceasing to turn. The hollow noise from the fuel tank and needle reading zero had failed to convay this message
|
| Fri Sep 04, 2009 3:33 pm |
|
|
|
Christian
Team Kris
Joined: Thu Oct 28, 2004 5:02 pm
Posts: 27584
Location: The Damage Control Table
|
Re: OK, so what happened?! Will people in Filmgasm like me?
_________________A hot man once wrote: Urgh, I have to throw out half my underwear because it's too tight.
|
| Fri Sep 04, 2009 4:40 pm |
|
|
|
Johnny Dollar
The Lubitsch Touch
Joined: Thu Jul 21, 2005 5:48 pm
Posts: 11019
|
Re: OK, so what happened?! Shack wrote: trixster wrote: I can't believe you guys went to FILMGASM instead of just waiting a day or two. Even torrino.net would have been preferable. On the other hand, torrino.net was infested by snack spam... Many prefer the occasionally bitter yet complex taste of snack spam to the overwhelmingly vanilla taste of shack spam.
_________________
k
|
| Fri Sep 04, 2009 5:10 pm |
|
|
|
Dr. Lecter
You must have big rats
Joined: Sat Oct 16, 2004 4:28 pm
Posts: 92093
Location: Bonn, Germany
|
Re: OK, so what happened?! yoshue wrote: Shack wrote: trixster wrote: I can't believe you guys went to FILMGASM instead of just waiting a day or two. Even torrino.net would have been preferable. On the other hand, torrino.net was infested by snack spam... Many prefer the occasionally bitter yet complex taste of snack spam to the overwhelmingly vanilla taste of shack spam. Oh my just change a few letters here...  _________________The greatest thing on earth is to love and to be loved in return!
|
| Fri Sep 04, 2009 10:29 pm |
|
|
|
Michael A
Joined: Sat Dec 27, 2008 4:48 am
Posts: 6245
|
Re: OK, so what happened?! Christian wrote: Will people in Filmgasm like me? I assume this is a joke or a rhetorical question everyone will always like you christian. _________________Mr. R wrote: Malcolm wrote: You seem to think threatening violence against people is perfectly okay because you feel offended by their words, so that's kind of telling in itself. Exactly. If they don't know how to behave, and feel OK offending others, they get their ass kicked, so they'll think next time before opening their rotten mouths.
|
| Sat Sep 05, 2009 1:57 am |
|
|
|
Chippy
KJ's Leading Pundit
Joined: Tue Oct 12, 2004 4:45 pm
Posts: 63026
Location: Tonight... YOU!
|
Re: OK, so what happened?! By 'like' he means 'have sex with'.
_________________trixster wrote: shut the fuck up zwackerm, you're out of your fucking element trixster wrote: chippy is correct
|
| Sat Sep 05, 2009 2:18 am |
|
|
