1. live2write
    Offline

    live2write Contributing Member

    Joined:
    Feb 7, 2012
    Messages:
    523
    Likes Received:
    53

    Database Error?!

    Discussion in 'Support & Feedback' started by live2write, Jan 14, 2013.

    This started happening recently and I do not know if it is on my end or if it is the internet but I have getting error messages when replying to a post or creating a new post.

    The browser would lock up and ask me if I want to stay or leave page. Either button I press sends me to a database error. I tried different browsers, clearing cache, trying different computers and my Iphone without wifi. It might be just on my end but just to address if it is something I should know.

    This also happens when I am at work viewing the page while not logged in.
     
  2. Daniel
    Offline

    Daniel I'm sure you've heard the rumors. Founder Staff Contributor

    Joined:
    May 14, 2006
    Messages:
    2,571
    Likes Received:
    402
    Location:
    Peoria, Illinois
    I experienced one myself today. I'm looking into it.

    If anyone else is experiencing this, it would help to not the exact time you see the error, that way I can look it up in the logs. Also, the type of error would help. Is it a "MySQL server has gone away" error?
     
  3. Selbbin
    Online

    Selbbin I hate you Contributor

    Joined:
    Oct 16, 2012
    Messages:
    3,238
    Likes Received:
    1,806
    Location:
    Australia
    I saw it twice. Once at about 40 minutes before this post, and another about half an hour before that. It just said database connection error.
     
  4. Cogito
    Offline

    Cogito Former Mod, Retired Supporter Contributor

    Joined:
    May 19, 2007
    Messages:
    35,935
    Likes Received:
    2,043
    Location:
    Massachusetts, USA
    The message displayed to members is very generic. No error codes, just a general "try again later" kind of message. I'd think the server would log database errors, but I have never worked with the vBulletin software. Check the MySQL logs in case the error is something the database engine can diagnose rather than a consistency error at the application level.
     
  5. PeterC
    Offline

    PeterC Active Member

    Joined:
    Jul 8, 2011
    Messages:
    191
    Likes Received:
    24
    Location:
    Vermont, USA
    It just happened to me... 8:44pm EST. The message was: The database has encountered a problem.

    I had to try several times to get here where I can make this post. Hopefully it will go through.
     
  6. Daniel
    Offline

    Daniel I'm sure you've heard the rumors. Founder Staff Contributor

    Joined:
    May 14, 2006
    Messages:
    2,571
    Likes Received:
    402
    Location:
    Peoria, Illinois
    Thanks guys. Peter, that exact time should help when going through the logs.

    I'm currently talking with my hosting company and I'm confident they can help solve this issue. I'll update you guys once it's solved.
     
  7. Pheonix
    Offline

    Pheonix A Singer of Space Operas and The Fourth Mod of RP Staff Contributor

    Joined:
    Jul 24, 2012
    Messages:
    5,716
    Likes Received:
    401
    Location:
    The Windy City
    I've seen it a lot since I joined the site in the summer. I just kind of wrote it off as normal though...

    It happened about 10 minutes ago, I didn't note the exact time though. Next time it happens I'll post the time here tho!
     
  8. Daniel
    Offline

    Daniel I'm sure you've heard the rumors. Founder Staff Contributor

    Joined:
    May 14, 2006
    Messages:
    2,571
    Likes Received:
    402
    Location:
    Peoria, Illinois
    This error occasionally is unavoidable, but it should be very rare. Like 1 out of every or 50,000 pageviews, specifically when the site is the most active. The past few days it's apparently been occurring more often, plus the server load time has gone up. Regardless, I'm determined to get to the bottom of the issue. :D
     
  9. Daniel
    Offline

    Daniel I'm sure you've heard the rumors. Founder Staff Contributor

    Joined:
    May 14, 2006
    Messages:
    2,571
    Likes Received:
    402
    Location:
    Peoria, Illinois
    How often is "a lot"?
     
  10. Pheonix
    Offline

    Pheonix A Singer of Space Operas and The Fourth Mod of RP Staff Contributor

    Joined:
    Jul 24, 2012
    Messages:
    5,716
    Likes Received:
    401
    Location:
    The Windy City
    I'd say about once every two or three days usually. Then It'll go a week without happening, then it'll do it every day for a little while. It usually doesn't last long, maybe a minute or two at the most. It usually isn't an issue cuz, like I said, I only lasts a minute or two then goes away. I've noticed it usually happens around 11:30 at night pretty regularly for like a minute.

    Other than that, I've never had any problems with the site, and I just wrote that off as a minor inconvenience since this is a smaller site. I think that considering you're one guy, and not a professional programmer, everything runs really well in comparison to some other sites I've been on run by pros! Keep up the good work man! :D
     
  11. Cogito
    Offline

    Cogito Former Mod, Retired Supporter Contributor

    Joined:
    May 19, 2007
    Messages:
    35,935
    Likes Received:
    2,043
    Location:
    Massachusetts, USA
    I ran into it three times tonight. In each case, it followed an absurdly long page load.
     
  12. thirdwind
    Offline

    thirdwind Contributing Member Contest Administrator Reviewer Contributor

    Joined:
    Jul 17, 2008
    Messages:
    7,351
    Likes Received:
    2,891
    Location:
    Boston
    I just got the error. It was at 8:10 PST.
     
  13. Pheonix
    Offline

    Pheonix A Singer of Space Operas and The Fourth Mod of RP Staff Contributor

    Joined:
    Jul 24, 2012
    Messages:
    5,716
    Likes Received:
    401
    Location:
    The Windy City
    I got it at 10:01, and 10:32 Central Time
     
  14. Thumpalumpacus
    Offline

    Thumpalumpacus Contributing Member

    Joined:
    Jun 28, 2012
    Messages:
    566
    Likes Received:
    106
    Location:
    Texas
    Yep, just now.
     
  15. Darkkin
    Offline

    Darkkin Reflection of a nobody Contributor

    Joined:
    Jun 21, 2012
    Messages:
    1,758
    Likes Received:
    515
    Location:
    Following the footprints in the sand...
    Ran into it at 10:15 AM, 12:45 PM, and 7:52 PM all Central Standard Time...:confused:
     
  16. Daniel
    Offline

    Daniel I'm sure you've heard the rumors. Founder Staff Contributor

    Joined:
    May 14, 2006
    Messages:
    2,571
    Likes Received:
    402
    Location:
    Peoria, Illinois
    Thanks guys. We made some changes that will hopefully clear this up. If you still see it let me know.
     
  17. Exzalia
    Offline

    Exzalia Contributing Member Contributor

    Joined:
    Jul 27, 2012
    Messages:
    9,926
    Likes Received:
    346
    happened 10:16 am to me today
     
  18. Cogito
    Offline

    Cogito Former Mod, Retired Supporter Contributor

    Joined:
    May 19, 2007
    Messages:
    35,935
    Likes Received:
    2,043
    Location:
    Massachusetts, USA
    By the way, folks, when you provide the time of an incident, don't forget to give your time zone!
     
  19. Drusy
    Offline

    Drusy Senior Member

    Joined:
    Jan 8, 2013
    Messages:
    119
    Likes Received:
    5
    CST
    "Error. Database has encountered a problem."

    1012, 1014 - trying to refresh the new posts section. Closed my browser and re-opened.

    1016 - typed in the address and got the same error twice.
     
  20. Drusy
    Offline

    Drusy Senior Member

    Joined:
    Jan 8, 2013
    Messages:
    119
    Likes Received:
    5
    Seeing a pattern in the thread around the ten o'clock hour CST. :)
     
  21. SuperVenom
    Offline

    SuperVenom Contributing Member

    Joined:
    Nov 11, 2010
    Messages:
    478
    Likes Received:
    72
    Location:
    South Wales
    5.01pm uk
     
  22. Exzalia
    Offline

    Exzalia Contributing Member Contributor

    Joined:
    Jul 27, 2012
    Messages:
    9,926
    Likes Received:
    346
    just happened to me around 11:53 perhaps?
    I live in the east cost of Canada in Ontario, close to Toronto. Not sure which time zone that is.
     
  23. Drusy
    Offline

    Drusy Senior Member

    Joined:
    Jan 8, 2013
    Messages:
    119
    Likes Received:
    5
    It's N. American Eastern =) ... according to Google anyways.
     
  24. Exzalia
    Offline

    Exzalia Contributing Member Contributor

    Joined:
    Jul 27, 2012
    Messages:
    9,926
    Likes Received:
    346
    thankyou :)
     
  25. mammamaia
    Offline

    mammamaia nit-picker-in-chief Contributor

    Joined:
    Nov 21, 2006
    Messages:
    19,316
    Likes Received:
    1,014
    Location:
    Coquille, Oregon
    me, too... about an hour ago... 9-ish pst...
     

Share This Page