Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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 [email protected] 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.


  • #2
    turn off pconnect in config.php

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

    Comment


    • #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


      • #4
        config.php?

        umm

        forum/admin/config.php

        Comment


        • #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


          • #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


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

              Comment


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

                Comment


                • #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


                  • #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


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

                      Comment

                      Loading...
                      Working...
                      X