1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

An unexpected database error occurred. Please try again later.

Discussion in 'Troubleshooting and Problems' started by cdub, Apr 11, 2013.

  1. cdub

    cdub Well-Known Member

    I'm getting this error on my server:

    An unexpected database error occurred. Please try again later.

    <!-- Too many connections -->

    When I view source I get the above? Know what's causing this?

    http://www.studentfilms.com/index.php

    I'm going to contact my host to see if they can restart a service for me.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Are you on shared hosting?
    There are probably limits in place.
     
  3. cdub

    cdub Well-Known Member

    And it's back online. Strange.
     
  4. cdub

    cdub Well-Known Member

    I submitted a ticket to hostgator - yes I'm on shared hosting.
     
  5. Brogan

    Brogan XenForo Moderator Staff Member

    Most likely a surge in visitors caused you to breach the limits imposed by the host.
     
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  7. cdub

    cdub Well-Known Member

    Hmmm... I'll have to check on how often it's happening to see if and when I need to upgrade servers. Thanks for all your help guys. XenForo support rocks!
     
  8. PeteUK

    PeteUK Member

    We've had this happen twice and the forum is still in pre-release testing with only 100 members. So if it's a real issue then goodness knows what will happen when we go live.

    Is it possible that connections could 'leak' rather like memory did under Windows XP, ie they aren't being closed down when they should be? Or do they eventually time-out and close themselves down?

    The only add-on we're currently using is Post Ratings - taking likes to the next level. I use Navicat to run queries. We're on a shared server (Fasthosts), so no hope of changing the settings.

    Any thoughts?
     
  9. Brogan

    Brogan XenForo Moderator Staff Member

    This is a typical problem with shared hosting.

    You will need to upgrade to a better package/server, be that shared, VPS or dedicated.

    Or try a different host.
     
  10. PeteUK

    PeteUK Member

    Thanks - how do I know how many MySQL connections will be sufficient? When we go live we could easily have 50 times as many people on the site at any one time as we do at the moment - does that mean that if we currently have 100 connections we will need 5000?

    A trial-and-error solution could be costly, time-consuming, and damaging for the reputation of the forum.
     
  11. Brogan

    Brogan XenForo Moderator Staff Member

  12. PeteUK

    PeteUK Member

  13. Brogan

    Brogan XenForo Moderator Staff Member

    With shared hosting, you will be pushing the limits at 100+ active members, never mind 50 times that.
     
    Tracy Perry likes this.
  14. My site is currently on HostGator Shared Hosting (until Friday when I dump them) and we're hitting a hard limit (25) on running processes which is what is giving us our current performance issues. Just in case that helps you (you can see the processes count on the HG cPanel down the left-hand column).
     
  15. cdub

    cdub Well-Known Member

    Yeah - I just checked - I'm certainly not at that point yet. Have you thought to switching to their VPS?
     
  16. No, their VPS seems a little costly for my tastes - I'm moving to Dreamhost (where I have other sites) and using their VPS offering if I need to (DH limit their shared hosting by memory used, and not processes).
     

Share This Page