Announcement

Collapse
No announcement yet.

894 VB DataBase Error Emails

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

  • [Forum] 894 VB DataBase Error Emails

    My forum was updated to 4.1.5 yesterday. In the nine hours after the update I received 894 emails like the one below. I'm not aware of any downtime. Why am I receiving these?

    Thanks

    Database error in vBulletin 4.1.5:

    Invalid SQL:


    UPDATE session
    SET lastactivity = 1311896019, badlocation = 0, useragent = 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB7.1; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C)'
    WHERE sessionhash = '79197203f38f3d7d33a51b1e894f4264';


    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Thursday, July 28th 2011 @ 07:33:39 PM
    Error Date : Thursday, July 28th 2011 @ 07:39:31 PM
    Script : http://www.businessadviceforum.com/n...treply&t=21284
    Referrer : http://www.businessadviceforum.com/s...online-service
    IP Address : [Removed]
    Username : [Removed]
    Classname : vB_Database
    MySQL Version :


    __________ Information from ESET Smart Security, version of virus signature database 6333 (20110728) __________


    The message was checked by ESET Smart Security.


    http://www.eset.com

    Fergal Crawley
    Business Advice Forum

    Forum Promotion

  • #2
    The explanation is here:

    MySQL Error : MySQL server has gone away
    That means the forum cannot access the database. If you are on shared hosting, in most cases this is because there are too many connections to the MySQL server and it may not even be from your account; it may well be someone else on the same server.

    If you are on a VPS or dedicated hosting, it likely means the database has crashed.

    In either case, you need to contact tech support for your hosting.

    One thing, though: Check the IP addresses blocked in your example. If they are all the same, it might be something a little more sinister. I have seen attempted SQL injections flooding MySQL due to the very high rate of hits via Guest postings. The remedy in that case is to block the IP range at the server level, if possible.
    Psychlinks Web Services Affordable Web Design & Site Management
    Specializing in Small Businesses and vBulletin/Xenforo Forums

    Comment


    • #3
      It doesn't mean it's crashed it means that mysql hasn't responded in the time set in wait_timeout in your my.cnf. You can increase that figure or you can try trace why.

      I'd think about emptying the sessions table.
      Code:
      DELETE FROM session;

      Comment


      • #4
        Thanks for your help djbaxter & punchbowl.

        Originally posted by djbaxter View Post
        ...One thing, though: Check the IP addresses blocked in your example. If they are all the same, it might be something a little more sinister. I have seen attempted SQL injections flooding MySQL due to the very high rate of hits via Guest postings. The remedy in that case is to block the IP range at the server level, if possible.
        I don't believe the forum was down while this was happening, because I was using it myself at the time and none of our members reported anything. I've looked through lots of the emails and the vast majority of the IPs are the same. They are the IP address of a new member who joined just after this happened and who has made one good quality post on the forum.

        Is there any reasonable reason why that could have happened?

        Do I need to take any action on this / do you believe this member was attacking the site in some way?


        Originally posted by punchbowl View Post
        It doesn't mean it's crashed it means that mysql hasn't responded in the time set in wait_timeout in your my.cnf. You can increase that figure or you can try trace why.

        I'd think about emptying the sessions table.
        Code:
        DELETE FROM session;
        Thanks punchbowl but I'm afraid I don't understand all of that, perhaps it is something I should contact my host about?
        Fergal Crawley
        Business Advice Forum

        Forum Promotion

        Comment


        • #5
          Originally posted by Fergal View Post
          I don't believe the forum was down while this was happening, because I was using it myself at the time and none of our members reported anything. I've looked through lots of the emails and the vast majority of the IPs are the same. They are the IP address of a new member who joined just after this happened and who has made one good quality post on the forum.

          Is there any reasonable reason why that could have happened?

          Do I need to take any action on this / do you believe this member was attacking the site in some way?
          No. It probably means that like many new members the individual was browsing your forum responding to intereesting lokking threads. Likely just a coincidence.
          Psychlinks Web Services Affordable Web Design & Site Management
          Specializing in Small Businesses and vBulletin/Xenforo Forums

          Comment


          • #6
            Thanks djbaxter.
            Originally posted by djbaxter View Post
            No. It probably means that like many new members the individual was browsing your forum responding to intereesting lokking threads. Likely just a coincidence.
            How would that result in me getting all those emails?
            Fergal Crawley
            Business Advice Forum

            Forum Promotion

            Comment


            • #7
              Did you manage to resolve this as im also getting the same mysql errors..

              Comment


              • #8
                It filled up the space allotted to tracking visitors. You need to delete this in the database so it is free to track visitors again. If not, you'll continue getting error messages.
                My law forum, lawyers and legal help site

                Comment


                • #9
                  Cheers Slinky, How would i do that?

                  Comment


                  • #10
                    Actually, if the session table was full slinkly the error message would be different.

                    The MySQL server going away means that mysql closed the connection during the update, for a number of reasons. Are you on a shared webhost, or a dedicated webhost?

                    Comment


                    • #11
                      Originally posted by punchbowl View Post
                      It doesn't mean it's crashed it means that mysql hasn't responded in the time set in wait_timeout in your my.cnf. You can increase that figure or you can try trace why.

                      I'd think about emptying the sessions table.
                      Code:
                      DELETE FROM session;





                      Thanks punchbowl but I'm afraid I don't understand all of that, perhaps it is something I should contact my host about?
                      can you access phpadmin? if so click on the query window (sql icon) and then enter the command that punchbowl gave you
                      Code:
                      DELETE FROM session;
                      and you should be done

                      Comment


                      • #12
                        Hi Zachery, Im on a dedicated server, thats running one live site vB site and one site thats in development (running a stable script), both have there own db.

                        Comment


                        • #13
                          can you post the contents of your my.cnf?

                          Comment


                          • #14
                            Originally posted by Zachery View Post
                            can you post the contents of your my.cnf?
                            Is there a way to copy and past from nano to save typeing out the contents of a cnf file?

                            Here's my my.cnf contents

                            Code:
                            [mysqld]
                            # from syslint.com
                            local-infile=0
                            skip-locking
                            key_buffer = 384M
                            max_allowed_packet = 1M
                            max_connections = 500
                            wait_timeout=40
                            connect_timeout=10
                            table_cache = 512
                            sort_buffer_size = 256k
                            read_buffer_size = 2M
                            read_rnd_buffer_size = 8M
                            thread_cache_size = 8M
                            myisam_sort_buffer_size = 64M
                            thread_cache_size = 8M
                            query_cache_size = 32M
                            thread+concurrncy = 8M
                            server-id       = 1
                            [mysqldump]
                            quick
                            max_allowed_packet = 16m
                            [mysql]
                            no-auto-rehash
                            [myisamchk]
                            key_buffer = 256M
                            sort_buffer_size = 256M
                            read_buffer = 2M
                            write_buffer =2M
                            [mysqlhotcopy]
                            interactive-timeout
                            Cheers Zachery

                            Comment


                            • #15
                              How big are your forums? Your buffers are HUGE.

                              Otherwise, try increasing your max_packet_size to 8mb, and increase the wait_timeout to 80

                              Comment

                              Related Topics

                              Collapse

                              Working...
                              X