Jump to content

Photo

The database crash and further action...


  • Please log in to reply
16 replies to this topic

#1 DevilMinder

DevilMinder

    Owner / Administrator

  • Admin
  • 9,013 posts

Posted 26 February 2013 - 09:16 AM

Yesterday the developers of the software were concerned about the stability of the website and asked me to run two queries. I ran them and the site not only didn't recover but crashed the posts table which is where all the forum posts are located. I got the server admin involved and he had to run the queries after restoring the database with a repair command. He stayed up late to get this to finish this morning. Thanks to Alphaomegahosting.com for the extra help!

 

 

 

I still have one more step, the software can no longer handle the searches on its own because of the large amount of posts and I need to install a third party software. Sphinx, which I am installing, is able to quickly index posts and return results. We had it briefly when it was in beta and it had good results but lagged the server, it is now much more efficient.

 

That will happen later on today but I don't expect any interruption of service.

 

 


  • 0

#2 Pepperkorn

Pepperkorn

    A Legend

  • Members
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 18,421 posts

Posted 26 February 2013 - 09:57 AM

Thanks for caring DM -- you really are an awesome host. Over a decade and you still have energy and concern for this.  It's not like the Devils don't know, is the thing.  Someone should request Lou write you a major thank you letter for giving fans an outlet and for giving his lameass marketing team ideas trying over the various years to compete rather than actually work with you. Especially because you ask for nothing.

 

Do you think you've ever gotten any donation from the organization or anyone connected with the team? Players sites, run by themselves and/or their relatives, their fans -- no one has been as committed to this kind of thing as you have.  You're always good-natured and relaxed about it all too. I wish I was that cool.


  • 0

I'm here for the party


#3 mrthemike

mrthemike

    Cursed_Man

  • Members
  • PipPipPipPipPipPip
  • 2,180 posts

Posted 26 February 2013 - 10:09 AM

Agree with PK. Thanks for putting in the hard work. Let us know when/if you need donations to keep the site going.


  • 0

Sole Posted Image of Emmy Rossum



#4 DevilMinder

DevilMinder

    Owner / Administrator

  • Admin
  • 9,013 posts

Posted 26 February 2013 - 10:48 AM

The only direct communications I have received are cease and desist letters. :)

 

Haha, oh well. I come here for the posts just like everyone else. Thanks PK and Mike 


  • 0

#5 redruM

redruM

    Hockey God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 6,447 posts

Posted 26 February 2013 - 10:59 AM

DM Huge Props, I was exhausted after about 2 years of the craziness, great job!


  • 0
Posted Image

2006 Pat Burns Award Winner(Most emotional Poster)
2006 JHL CHAMPION!!
2005 CHAMPION of the 1st Annual NJDevs Fantasy Wrestling League!!!
2005 Finalist 1st Annual NJDEVS Fantasy Baseball League
2005 Pat Burns Award Winner(Most emotional Poster)
2004 LockOut Trivia CHAMP!!!


Keeper of The original Welcome to Hell Forum, Jimmy Dowd, Brian Rolston, "Christmas Tree" Jersey's and the Original Trade Documents of the FREEZE man!!


BOM U11G Dynamite

Posted Image

#6 DevilMinder

DevilMinder

    Owner / Administrator

  • Admin
  • 9,013 posts

Posted 26 February 2013 - 12:18 PM

Thanks Red!

 

 

 

The new search is up and running. The results should be more accurate as well as allowing two letter searching.


  • 0

#7 mrthemike

mrthemike

    Cursed_Man

  • Members
  • PipPipPipPipPipPip
  • 2,180 posts

Posted 26 February 2013 - 12:30 PM

You've really gotten cease and desist letters? From posting articles?


  • 0

Sole Posted Image of Emmy Rossum



#8 aylbert

aylbert

    Hall of Famer

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 6,269 posts

Posted 26 February 2013 - 12:33 PM

I don't get it... I keep complaining to the Devils and news agency...  and they keep saying thanks, but won't tell me what actions they took.   Eventually I'll see some progress against the evil that is NJDevs...  until then; I'll keep on, keeping on.

 

Thanks for all of your hard work!


 


Edited by aylbert, 26 February 2013 - 12:33 PM.

  • 0

image-300x225.jpg
 

| 2012 Season | NJDevs FHL Champion | 2013 Season |
| 2014 Season | 


#9 DevilMinder

DevilMinder

    Owner / Administrator

  • Admin
  • 9,013 posts

Posted 26 February 2013 - 12:42 PM

I don't get it... I keep complaining to the Devils and news agency...  and they keep saying thanks, but won't tell me what actions they took.   Eventually I'll see some progress against the evil that is NJDevs...  until then; I'll keep on, keeping on.

 

Thanks for all of your hard work!


 

 

Sweet, now I know who to send the Stark and Stark legal council bill too!


  • 0

#10 aylbert

aylbert

    Hall of Famer

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 6,269 posts

Posted 26 February 2013 - 12:52 PM

Sweet, now I know who to send the Stark and Stark legal council bill too!

 

I guess... but I think you know as well as I, it will just be another bill NJCroMag is going to ignore.  

He still hasn't paid up for the girl scout cookies I resold him in '09.


  • 0

image-300x225.jpg
 

| 2012 Season | NJDevs FHL Champion | 2013 Season |
| 2014 Season | 


#11 newarkdev01

newarkdev01

    Senior Devil

  • Members
  • PipPipPipPip
  • 897 posts

Posted 26 February 2013 - 01:35 PM

Thanks for the care and concern and sorry the devils do such a piss poor job of supporting their fans...


  • 0

#12 StarDew

StarDew

    General Manager

  • Members
  • PipPipPipPipPipPipPipPip
  • 4,700 posts

Posted 26 February 2013 - 05:12 PM

You are a saint DM. You have come a long way baby!  Thank you for taking care of us. :)


  • 0
Dew
So long and thanks for all the fish.
TIMEX RULES!!

"When we were struggling at the beginning of the year we were wondering what was wrong and trying to find reasons. At the end of the day, all we had to do was look in the mirror and the answers were right there." -- Sergei Brylin 12/2/2007

#13 ATLL765

ATLL765

    Assistant Coach

  • Members
  • PipPipPipPipPipPip
  • 2,182 posts

Posted 27 February 2013 - 02:31 PM

Could the formatting of posts had been messed up at all? I noticed while I was making post earlier, that when I attempted to realign a portion of my post to be center aligned, it would align parts of the post that I had NOT highlighted.

Secondly, I was making a post with a video link and once I did so, as I tried to type above it, there was nothing I could do to rid the font of the underline or color it black again. I could change colors to any other color but the automatic color of black.

Maybe it's just me and I can't figure it out, but I figured if the site was having issues, better to say something than not.


  • 0

#14 DevilMinder

DevilMinder

    Owner / Administrator

  • Admin
  • 9,013 posts

Posted 27 February 2013 - 05:03 PM

I was able to do both of those without issues. Do you have javascript disabled?


  • 0

#15 DevilMinder

DevilMinder

    Owner / Administrator

  • Admin
  • 9,013 posts

Posted 27 February 2013 - 07:19 PM

The new search engine seems to stuck in yesterday's index and not showing current results. I am working on it.


  • 0

#16 mrthemike

mrthemike

    Cursed_Man

  • Members
  • PipPipPipPipPipPip
  • 2,180 posts

Posted 27 February 2013 - 11:35 PM

Could the formatting of posts had been messed up at all? I noticed while I was making post earlier, that when I attempted to realign a portion of my post to be center aligned, it would align parts of the post that I had NOT highlighted.

Secondly, I was making a post with a video link and once I did so, as I tried to type above it, there was nothing I could do to rid the font of the underline or color it black again. I could change colors to any other color but the automatic color of black.

Maybe it's just me and I can't figure it out, but I figured if the site was having issues, better to say something than not.

 

I had a similar issue where I tried to type a post and it wrote it in times new roman and then when i tried to post just said something along the lines of not being able to submit an empty post. I cleared my cookies / cache, restarted browser and it worked again. Haven't seen the issue since. Weird.


  • 0

Sole Posted Image of Emmy Rossum



#17 ATLL765

ATLL765

    Assistant Coach

  • Members
  • PipPipPipPipPipPip
  • 2,182 posts

Posted 01 March 2013 - 10:47 AM

I had a similar issue where I tried to type a post and it wrote it in times new roman and then when i tried to post just said something along the lines of not being able to submit an empty post. I cleared my cookies / cache, restarted browser and it worked again. Haven't seen the issue since. Weird.

I actually just tried to do what I was doing before and it worked fine, so maybe it was something weird with the cookies/cache. I did have javascript enabled.

The only other thing I've had an issue with is sometimes the site doesn't remember that I read a thread. In particular, right now, I viewed the last post in the opinion poll for the div playoffs multiple times now and it still bolds the title as if I haven't.


  • 0




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users