Host is stating that script in my VB is leaving open connections

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Richy T.
    Member
    • Jun 2002
    • 91

    Host is stating that script in my VB is leaving open connections

    I am continuing to receive these messages when I am in my forum or others are in. I know it states that I have max user connections but there are minimal people on the forum. I have been trying to call my host as it happens and this morning I finally got it.

    They are stating that the script in my VB are not closing connections correctly therefore overloading their mysql database all over the board. It's not just hitting my site but also the other sites that are utilizing that mysql also. They also stated that if I don't fix this problem, they will disable my forum.

    Can anybody help me figure out what is going on with my script? What do you need to know from me so I can help with this also.

    Warning: mysql_pconnect() [function.mysql-pconnect]: User us3s@localhost has already more than 'max_user_connections' active connections in /home/www/us3s/freeforum/admin/db_mysql.php on line 38
    P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}


    There seems to have been a slight problem with the database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.

  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    turn off pconnect in config.php

    $pconnect=1; shuld be what its set to now, change this to 0

    Comment

    • Richy T.
      Member
      • Jun 2002
      • 91

      #3
      Originally posted by Faranth
      turn off pconnect in config.php

      $pconnect=1; shuld be what its set to now, change this to 0
      where do i find that at?

      Comment

      • Zachery
        Former vBulletin Support
        • Jul 2002
        • 59097

        #4
        config.php?

        umm

        forum/admin/config.php

        Comment

        • Richy T.
          Member
          • Jun 2002
          • 91

          #5
          Originally posted by Faranth
          config.php?

          umm

          forum/admin/config.php
          i still can't find it. i go to forum admin but then where? i checked in modify template but find nothing with that line.

          Comment

          • Zachery
            Former vBulletin Support
            • Jul 2002
            • 59097

            #6
            OPEN YOUR FTP

            BROWSE TO FORUMS
            THEN YOUR ADMIN FOLDER
            THEN TO THE FILE CONFIG.PHP

            EDIT IT
            FIND $pconnect=1;
            CHANGE IT TO
            $pconnect=0;

            Comment

            • Richy T.
              Member
              • Jun 2002
              • 91

              #7
              thanks, i'll try that when i get home

              Comment

              • Richy T.
                Member
                • Jun 2002
                • 91

                #8
                Thanks. I figured it out and it worked.

                Comment

                • Xube
                  Senior Member
                  • Oct 2001
                  • 359

                  #9
                  Originally posted by Richy T.
                  Thanks. I figured it out and it worked.


                  1). Richy T, has this fix been long term successful on your forums (meaning that since you implemented the suggested change you haven't had the max_user_connections errors occur ever again)? I'm just wondering because since the max_user_connections errors seem to come and go almost randomly I wanted to confirm that this truly has fixed your problem vs the max users thing just had stopped happening on its own (as it has a tendency to do sometimes).


                  2). Can we get some official input from vBulletin moderators and/or developers on this suggested change? What exactly does the $pconnect variable set to a default value of 1 accomplish and what are we losing by changing its value to zero?
                  :p -=Xube ®
                  ...it's just technology

                  Comment

                  • Xube
                    Senior Member
                    • Oct 2001
                    • 359

                    #10
                    Edit for above post:
                    Just found general sticky regarding this subject at:

                    Scott's Link-ID == false, connect failed or 'Too many connections" post


                    Sorry, it hadn't come up when I did a search for "max_user_connections" before posting my question in the post above this one....

                    But my question now is....

                    What is the difference between the variables $usepconnect (suggested in Scott's post) and $pconnect (suggested in this thread).


                    Do both of these variables need to be set to zero?
                    :p -=Xube ®
                    ...it's just technology

                    Comment

                    • Zachery
                      Former vBulletin Support
                      • Jul 2002
                      • 59097

                      #11
                      There the same thing, i hadnt seen vB2's config in a while

                      Comment

                      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                      Working...