Announcement

Collapse
No announcement yet.

Database Trouble Since Upgrade to 3

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

  • Database Trouble Since Upgrade to 3

    It seems like I am having all kinds of database connection errors since I upgraded. I have made sure that the $usepconnect =0; is correct as some have said here but still having trouble. I can not seem to keep the board up. What are some options to look at?

    Mike Julian
    http://www.4m.net

  • #2
    What are the errors you are getting?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Originally posted by Steve Machol
      What are the errors you are getting?
      1040 database connection error. It is like the database is not clearing inactive users and it builds up to the point that it will not allow new connections.

      Comment


      • #4
        did you remove $cronimage from the footer?
        Scott MacVicar

        My Blog | Twitter

        Comment


        • #5
          Originally posted by Scott MacVicar
          did you remove $cronimage from the footer?
          No.
          I have 1,036 records in the session table right now and I know there are only about 250 users on right now.

          Comment


          • #6
            whats your cookie timeout set at?
            Scott MacVicar

            My Blog | Twitter

            Comment


            • #7
              Originally posted by Scott MacVicar
              whats your cookie timeout set at?
              300

              Comment


              • #8
                SELECT * FROM session WHERE lastactivity < UNIX_TIMESTAMP() - 300;

                what does that return?
                Scott MacVicar

                My Blog | Twitter

                Comment


                • #9
                  Originally posted by Scott MacVicar
                  SELECT * FROM session WHERE lastactivity < UNIX_TIMESTAMP() - 300;

                  what does that return?
                  SELECT * FROM session WHERE lastactivity < UNIX_TIMESTAMP() - 300 LIMIT 0, 30

                  Comment


                  • #10
                    how many rows does it return?

                    PHP is responsible for closing all connections. It may in fact be another script running on your site / server that is causing the problems.
                    Scott MacVicar

                    My Blog | Twitter

                    Comment


                    • #11
                      Originally posted by Scott MacVicar
                      how many rows does it return?

                      PHP is responsible for closing all connections. It may in fact be another script running on your site / server that is causing the problems.

                      (844 total)
                      With a whole bunce of user ID 0

                      Comment


                      • #12
                        how many rows are there in total?

                        just do a SELECT COUNT(*) AS total FROM session
                        Scott MacVicar

                        My Blog | Twitter

                        Comment


                        • #13
                          Originally posted by Scott MacVicar
                          how many rows are there in total?

                          just do a SELECT COUNT(*) AS total FROM session
                          1144

                          Comment


                          • #14
                            whats the exact mysql error?

                            The onyl error you'd be getting is that the HEAP table size is being exceeded if it was sessions not being cleared out.

                            If its max connections then its most likely another script with pconnect on.
                            Scott MacVicar

                            My Blog | Twitter

                            Comment

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