Database Errors

Discussion in 'Forum Announcements & FAQ' started by Amanda, May 13, 2009.

  1. Amanda

    Amanda Administrator Staff Member

    Joined:
    Feb 28, 2001
    Messages:
    3,231
    Likes Received:
    79

    May 13, 2009

    I just wanted to let you all know I am aware of the errors that have been occurring and am working toward a resolution. Our dedicated server host has been having some issues that may be related.
     
  2.  
  3. TeacherGroupie

    TeacherGroupie Moderator

    Joined:
    May 13, 2005
    Messages:
    29,682
    Likes Received:
    1,109

    May 13, 2009

    Hugs, Amanda, and thanks for letting us know.
     
  4. BioAngel

    BioAngel Science Teacher - Grades 3-6

    Joined:
    Oct 11, 2007
    Messages:
    3,642
    Likes Received:
    108

    May 13, 2009

    Thanks for letting us know--- hopefully they'll be fixed soon :)
     
  5. Jem

    Jem Aficionado

    Joined:
    May 7, 2008
    Messages:
    3,544
    Likes Received:
    0

    May 13, 2009

    Thanks for working on it! I guess it's an addiction when you see the 'database error' message and start going into meltdown mode...
     
  6. smalltowngal

    smalltowngal Multitudinous

    Joined:
    Jan 2, 2007
    Messages:
    17,362
    Likes Received:
    46

    May 13, 2009

    :lol: Jem....same here!
     
  7. Amanda

    Amanda Administrator Staff Member

    Joined:
    Feb 28, 2001
    Messages:
    3,231
    Likes Received:
    79

    May 13, 2009

    It was apparently due to the outages at the company that hosts the database server, so hopefully we are out of the woods now.
     
  8. leighbball

    leighbball Virtuoso

    Joined:
    Jul 6, 2005
    Messages:
    7,507
    Likes Received:
    1

    May 13, 2009

    Same here jem and stg :D :lol:
     
  9. Amanda

    Amanda Administrator Staff Member

    Joined:
    Feb 28, 2001
    Messages:
    3,231
    Likes Received:
    79

    May 14, 2009

    We still seem to be having problems off and on. :sorry:
     
  10. Amanda

    Amanda Administrator Staff Member

    Joined:
    Feb 28, 2001
    Messages:
    3,231
    Likes Received:
    79

    May 19, 2009

    Well, every time I make a change and I think I've fixed it, I find out I haven't! Next step is to upgrade at least one of our servers to a "monster". I'm getting some quotes together now. :D With all the new features planned we will need some extra server resources anyway.
     
  11. smalltowngal

    smalltowngal Multitudinous

    Joined:
    Jan 2, 2007
    Messages:
    17,362
    Likes Received:
    46

    May 19, 2009

    Thanks, Amanda!! I've noticed that the site has been slow today. Is it just my computer or does it have something to do with the database errors?
     
  12. Amanda

    Amanda Administrator Staff Member

    Joined:
    Feb 28, 2001
    Messages:
    3,231
    Likes Received:
    79

    May 19, 2009

    No, it's not you. It's because at least one of the servers needs to be upgraded... not enough memory or processor speed.
     
  13. smalltowngal

    smalltowngal Multitudinous

    Joined:
    Jan 2, 2007
    Messages:
    17,362
    Likes Received:
    46

    May 19, 2009

    Thanks!
     
  14. Amanda

    Amanda Administrator Staff Member

    Joined:
    Feb 28, 2001
    Messages:
    3,231
    Likes Received:
    79

    May 19, 2009

    The new server has been ordered. I am waiting for my order to be filled. This could take anywhere from a few hours to a few days. Hopefully it will be a few hours so I can transfer the site tonight.
     
  15. Amanda

    Amanda Administrator Staff Member

    Joined:
    Feb 28, 2001
    Messages:
    3,231
    Likes Received:
    79

    May 19, 2009

    WOOT! I just got the notification that the server is already ready! I will have to do some initial set up and hopefully I can have it ready to transfer tonight.
     
  16. smalltowngal

    smalltowngal Multitudinous

    Joined:
    Jan 2, 2007
    Messages:
    17,362
    Likes Received:
    46

    May 19, 2009

    Yay, Amanda!
     
  17. TeacherGroupie

    TeacherGroupie Moderator

    Joined:
    May 13, 2005
    Messages:
    29,682
    Likes Received:
    1,109

    May 19, 2009

    I have said before and will say again: You're amazing, Amanda.
     
  18. MrsC

    MrsC Multitudinous

    Joined:
    Aug 8, 2005
    Messages:
    13,855
    Likes Received:
    1,695

    May 19, 2009

    That's something that really can't be said often enough, can it?
     
  19. smalltowngal

    smalltowngal Multitudinous

    Joined:
    Jan 2, 2007
    Messages:
    17,362
    Likes Received:
    46

    May 19, 2009

    You're amazing, Amanda!!!! :thumb:
     
  20. Amanda

    Amanda Administrator Staff Member

    Joined:
    Feb 28, 2001
    Messages:
    3,231
    Likes Received:
    79

    May 19, 2009

    Thanks... :blush:

    Okay, I have atoz transferred. Depending on when your ISP notes the change, you will start browsing the forums from the new server. You shouldn't notice anything but the server responding much more quickly. (At least I hope it stays that way... it's lightning fast for me but I'm the only one on it right now.)
     
  21. smalltowngal

    smalltowngal Multitudinous

    Joined:
    Jan 2, 2007
    Messages:
    17,362
    Likes Received:
    46

    May 19, 2009

    I've noticed that's a lot faster than it was this afternoon...of course that was when it was taking almost a minute to load a new page/post.
     
  22. Amanda

    Amanda Administrator Staff Member

    Joined:
    Feb 28, 2001
    Messages:
    3,231
    Likes Received:
    79

    May 19, 2009

    According to the server logs, the old server has virtually no traffic on it so everyone should be viewing us from the new one now. If we start getting database errors after this I am going to pull out my hair. :lol:
     
  23. smalltowngal

    smalltowngal Multitudinous

    Joined:
    Jan 2, 2007
    Messages:
    17,362
    Likes Received:
    46

    May 19, 2009

    So far so good Amanda!
     
  24. Kangaroo22

    Kangaroo22 Virtuoso

    Joined:
    Jan 13, 2008
    Messages:
    6,216
    Likes Received:
    0

    May 19, 2009

    It's working a lot better! Thanks, Amanda!
     
  25. INteacher

    INteacher Aficionado

    Joined:
    Aug 3, 2007
    Messages:
    3,765
    Likes Received:
    1

    May 19, 2009

    Thanks Amanda - now when I refresh posts, the new posts are the current time. For me up until tonight, when I refreshed the time was still about 15 - 20 minutes off
     
  26. Amanda

    Amanda Administrator Staff Member

    Joined:
    Feb 28, 2001
    Messages:
    3,231
    Likes Received:
    79

    May 19, 2009

    Thanks INteacher... it sounds like the new server's time is off. I'll fix that.

    Edit: Wait, I read that wrong. It sounds like it was the OLD server that was off. The new one is right on. :thumb:
     
  27. INteacher

    INteacher Aficionado

    Joined:
    Aug 3, 2007
    Messages:
    3,765
    Likes Received:
    1

    May 19, 2009

    Oh no - what I was trying to say is that the time is right NOW and hasn't been right until tonight - Sorry :(
     
  28. swansong1

    swansong1 Virtuoso

    Joined:
    May 19, 2007
    Messages:
    6,505
    Likes Received:
    1,417

    May 20, 2009

    The server is working great, Amanda! It hasn't fixed the problem I PM'd you about yesterday so I'll write you again later today and see if we can get it worked out.
     
  29. Jem

    Jem Aficionado

    Joined:
    May 7, 2008
    Messages:
    3,544
    Likes Received:
    0

    May 22, 2009

    Heads up-I just got hit with about 5 minutes of database errors.
     
  30. Amanda

    Amanda Administrator Staff Member

    Joined:
    Feb 28, 2001
    Messages:
    3,231
    Likes Received:
    79

    May 22, 2009

    Thanks, Jem... I saw that. The other server is maxed out (two servers run the atoz forums) and I need to upgrade it too. I was running a backup on it and it must have been the straw that broke the camel's back! I'll probably upgrade the other server next week and be careful about backups in the mean time.
     

Share This Page

Members Online Now

Total: 141 (members: 0, guests: 121, robots: 20)
test