Announcement

Collapse
No announcement yet.

Error 2013 but server up for 6 days

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #31
    How can I figure out my wait_timeout setting without asking the host?

    Comment


    • #32
      Possible?

      Comment


      • #33
        I have the same problem; with a wait timeout on 300 seconds, which I could raise of course.

        But I would like to understand WHY this happens; why is a mysql thread connection timing out like this at the end of a page?

        Note that for me this only happens at queries being executed by the PHP shutdown functions - like the one above; update last activity time

        Comment


        • #34
          Ditto here.

          I'm receiving 1-5 errors a day, and my board is brand new with only about 75 members and maybe 6-10 posts a day.

          Version 3.0.6
          MySQL Persistant is set to 0

          Here is the error code received:

          Database error in vBulletin 3.0.6:

          Invalid SQL:
          UPDATE vb3_datastore
          SET data = data - 1,
          data = IF( data < 0, 0, data )
          WHERE title = 'mailqueue'

          Note: this part never is the same... the only part of the errors that are similar is the following 2 lines:

          mysql error: Lost connection to MySQL server during query
          mysql error number: 2013

          Date: Friday 28th of January 2005 12:07:08 AM
          Script:
          http://www.simtechonline.com/forums/forumdisplay.php?f=10
          Referer: http://www.simtechonline.com/forums/
          Username: Unregistered (this part changes - usually has different usernames here... I've even seen mine at times!)
          IP Address: 66.245.124.51 (different IP addresses as well)


          I can't see where I can read my wait_timeout but in 'view PHP info' on the admin page my:
          mysql.connect_timeout is set to -1
          default_socket_timeout = 60

          and I cannot access my /etc/my.cnf area... not on this server.

          I did contact my hosting company and this is what I was told:
          Thank you for contacting customer support. At this time, you would need to install and configure the forum through the database. Unfortunately, we would be unable to assist you with the configuration of the forum.


          I have written back to them and pasted the vBulletin page explaining about wait_timeouts... is there any other routes that I can go? It seems there's several of us which are experience the exact same problems.

          Thanks-

          Comment


          • #35
            Your host's response shows a glaring lack of knowledge about running a server.

            mysql error: Lost connection to MySQL server during query

            This is a server issue. You need to contact your host about this. See this post for the possible causes of a lost connection error:

            http://www.vbulletin.com/forum/showt...265#post310265
            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


            • #36
              Steve,

              Thanks for all the information.

              I am a bit confused of why this would suddenly happen though. My forums has been running along fine and then overnight I start getting errors. No increase in traffic or request. The only addition I run is the Vbadvance CMS. No other modifications. Nothing upgraded or changed on the host end either.

              The problem started a few weeks back, went away and was running fine, and now again this morning is giving me errors again. The parameters are fine for my host looking at the list you provided.

              I'm novice in this area so I am trying to understand what questions I need to be asking my host or what other areas I should be looking at that might be causing problems. I know at one point someone speculated that there was a PHP or MYSQL bug going around, but I have not been able to find any information to support it.

              >>>>Whoop!

              I was just reading again and noticed a post about persistant connections and turning that off. I will have to try that, but what does that do and how does it effect the operation of the forum?

              Thanks!

              Chael

              Okay, and PS - I was reading through the MYSQL Status report and had a few questions about that. Where would be a good place to ask those questions? Again, thanks.

              Comment


              • #37
                There are an untold numbers of reason this could have started suddenly - all of them server related.

                For questions aboutMYSQL Status reports, try the Serveer Configuration forum.
                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

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