Results 1 to 8 of 8

Thread: Too many database connections

  1. #1
    User
    Join Date
    06-20-09.
    Posts
    63

    Default Too many database connections

    I'm currently entering data in a catalog with several links to the taxonomy and pages tables.
    Every 10 records or so, TL crashes with the following message:
    Fatal error: Uncaught exception Exception with message Could not connect to database (Too many connections) thrown in /homez.110/marienoe/www/system/libraries/Database.php on line 76
    Anything can be done to fix this problem?

  2. #2
    Experienced user
    Join Date
    06-10-09.
    Location
    Cape Town, South Africa
    Posts
    1,387

    Default Re: Too many database connections

    Contact your hosting provided to increase the amount of DB connections on your plan.

  3. #3
    User
    Join Date
    06-20-09.
    Posts
    63

    Default Re: Too many database connections

    As it seems to be related to a certain number of inserts/updates I can do each time, I thought it could be some DB connection that is opened for each operation and not closed afterwards.

  4. #4
    User
    Join Date
    06-20-09.
    Posts
    63

    Default Re: Too many database connections

    In fact, the problem arises when I use the "Save and close" and "New item" in sequence for more than 10 or 12 times.
    But the "Save and new" can be used repeatedly without crashing the system.

  5. #5
    User MacKP's Avatar
    Join Date
    06-19-09.
    Location
    Duisburg (Germany)
    Posts
    211

    Default Re: Too many database connections

    Hi, that sounds like an persistent connection to the DB.
    You can change that in the localconfig.php.

    regards
    Mediendepot Ruhr
    For real-time chat the (inofficial) Chatroom in IRC:
    -> irc.freenode.net #contao | irc.freenode.net #contao.de

  6. #6
    User
    Join Date
    06-20-09.
    Posts
    63

    Default Re: Too many database connections

    This parameter?
    Code:
    $GLOBALS['TL_CONFIG']['dbPconnect'] = false;
    But its value is already 'false' :?

  7. #7
    User MacKP's Avatar
    Join Date
    06-19-09.
    Location
    Duisburg (Germany)
    Posts
    211

    Default Re: Too many database connections

    Than you had to contact your hosting provider as thyon said. I think there is something not so nice configured.

    regards
    Mediendepot Ruhr
    For real-time chat the (inofficial) Chatroom in IRC:
    -> irc.freenode.net #contao | irc.freenode.net #contao.de

  8. #8
    New user andypillip's Avatar
    Join Date
    08-26-11.
    Location
    Munich, Germany
    Posts
    7

    Default Re: Too many database connections

    Help!

    I got the same problem, but coupled with the effect that Contao is unbelievable slow!

    Can somebody help?

    I also got catalog installed, but the effect occurs even when no interaction with the catalog is done.

    Contao is getting slow like four times a day, and then suddenly it's really fast again.

    My provider also is 1&1. But all the other sites on the account are as fast as ever.

    Please, some hints on where to check?

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •