We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
  • Okay, so recently my error log started writing this message 5-6 times every 2 minutes or so:

    [2013-06-25 12:06:04] (ERROR @ /index.php) Error HY000 executing query: SELECT `modSnippet`.`id` AS `modSnippet_id`, `modSnippet`.`source` AS `modSnippet_source`, `modSnippet`.`property_preprocess` AS `modSnippet_property_preprocess`, `modSnippet`.`name` AS `modSnippet_name`, `modSnippet`.`description` AS `modSnippet_description`, `modSnippet`.`editor_type` AS `modSnippet_editor_type`, `modSnippet`.`category` AS `modSnippet_category`, `modSnippet`.`cache_type` AS `modSnippet_cache_type`, `modSnippet`.`snippet` AS `modSnippet_snippet`, `modSnippet`.`locked` AS `modSnippet_locked`, `modSnippet`.`properties` AS `modSnippet_properties`, `modSnippet`.`moduleguid` AS `modSnippet_moduleguid`, `modSnippet`.`static` AS `modSnippet_static`, `modSnippet`.`static_file` AS `modSnippet_static_file`, `Source`.`id` AS `Source_id`, `Source`.`name` AS `Source_name`, `Source`.`description` AS `Source_description`, `Source`.`class_key` AS `Source_class_key`, `Source`.`properties` AS `Source_properties`, `Source`.`is_stream` AS `Source_is_stream` FROM `modx_site_snippets` AS `modSnippet` LEFT JOIN `modx_media_sources` `Source` ON `modSnippet`.`source` = `Source`.`id` WHERE `modSnippet`.`name` = ? ORDER BY `modSnippet`.`id` ASC  - Array
    (
        [0] => HY000
        [1] => 2006
        [2] => MySQL server has gone away
    )



    Does anyone have a clue why I get this error?

    running Revo 2.2.8-pl
    php 5.3
    • Sounds like a badly overloaded shared server. Either that, or the server is configured to throttle server access. How busy is your site? How is it hosted?
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
      • It is a private server, only running our live and development sites, they run on separate databases.
        There is approx. 25-30.000 visitors every day on the live site.
        the problem occurs on the development site where we are currently building the site in Revo to replace the live site which is (until thursday) running Evo.
        • it is not only modSnippet that fails, the same error is logged for Users and chunks as well:

          [2013-06-25 12:25:02] (ERROR @ /index.php) Error HY000 executing query: SELECT `modUser`.`id` AS `modUser_id`, `modUser`.`username` AS `modUser_username`, `modUser`.`password` AS `modUser_password`, `modUser`.`cachepwd` AS `modUser_cachepwd`, `modUser`.`class_key` AS `modUser_class_key`, `modUser`.`active` AS `modUser_active`, `modUser`.`remote_key` AS `modUser_remote_key`, `modUser`.`remote_data` AS `modUser_remote_data`, `modUser`.`hash_class` AS `modUser_hash_class`, `modUser`.`salt` AS `modUser_salt`, `modUser`.`primary_group` AS `modUser_primary_group`, `modUser`.`session_stale` AS `modUser_session_stale`, `modUser`.`sudo` AS `modUser_sudo`, `Profile`.`id` AS `Profile_id`, `Profile`.`internalKey` AS `Profile_internalKey`, `Profile`.`fullname` AS `Profile_fullname`, `Profile`.`email` AS `Profile_email`, `Profile`.`phone` AS `Profile_phone`, `Profile`.`mobilephone` AS `Profile_mobilephone`, `Profile`.`blocked` AS `Profile_blocked`, `Profile`.`blockeduntil` AS `Profile_blockeduntil`, `Profile`.`blockedafter` AS `Profile_blockedafter`, `Profile`.`logincount` AS `Profile_logincount`, `Profile`.`lastlogin` AS `Profile_lastlogin`, `Profile`.`thislogin` AS `Profile_thislogin`, `Profile`.`failedlogincount` AS `Profile_failedlogincount`, `Profile`.`sessionid` AS `Profile_sessionid`, `Profile`.`dob` AS `Profile_dob`, `Profile`.`gender` AS `Profile_gender`, `Profile`.`address` AS `Profile_address`, `Profile`.`country` AS `Profile_country`, `Profile`.`city` AS `Profile_city`, `Profile`.`state` AS `Profile_state`, `Profile`.`zip` AS `Profile_zip`, `Profile`.`fax` AS `Profile_fax`, `Profile`.`photo` AS `Profile_photo`, `Profile`.`comment` AS `Profile_comment`, `Profile`.`website` AS `Profile_website`, `Profile`.`extended` AS `Profile_extended` FROM `modx_users` AS `modUser` LEFT JOIN `modx_user_attributes` `Profile` ON `modUser`.`id` = `Profile`.`internalKey` WHERE `modUser`.`id` = ? ORDER BY `modUser`.`id` ASC  - Array
          (
              [0] => HY000
              [1] => 2006
              [2] => MySQL server has gone away
          )
          



          [2013-06-25 12:29:46] (ERROR @ /index.php) Error HY000 executing query: SELECT `modChunk`.`id` AS `modChunk_id`, `modChunk`.`source` AS `modChunk_source`, `modChunk`.`property_preprocess` AS `modChunk_property_preprocess`, `modChunk`.`name` AS `modChunk_name`, `modChunk`.`description` AS `modChunk_description`, `modChunk`.`editor_type` AS `modChunk_editor_type`, `modChunk`.`category` AS `modChunk_category`, `modChunk`.`cache_type` AS `modChunk_cache_type`, `modChunk`.`snippet` AS `modChunk_snippet`, `modChunk`.`locked` AS `modChunk_locked`, `modChunk`.`properties` AS `modChunk_properties`, `modChunk`.`static` AS `modChunk_static`, `modChunk`.`static_file` AS `modChunk_static_file`, `Source`.`id` AS `Source_id`, `Source`.`name` AS `Source_name`, `Source`.`description` AS `Source_description`, `Source`.`class_key` AS `Source_class_key`, `Source`.`properties` AS `Source_properties`, `Source`.`is_stream` AS `Source_is_stream` FROM `modx_site_htmlsnippets` AS `modChunk` LEFT JOIN `modx_media_sources` `Source` ON `modChunk`.`source` = `Source`.`id` WHERE `modChunk`.`name` = ? ORDER BY `modChunk`.`id` ASC  - Array
          (
              [0] => HY000
              [1] => 2006
              [2] => MySQL server has gone away
          )
          • I'm with Susan on this one, it sounds like the server is being overloaded. The problem is it's unable to connect to the database (timeout or refused), so we need to look into it's configuration.

            Can you tell us more about the server?
              Patrick | Server Wrangler
              About Me: Website | TweetsMODX Hosting
            • You need to get your IT people to look at their MySQL server configuration. Sounds like it needs more threads, or listeners (Oracle), or whatever MySQL calls it. Revo is heavy on the database when compared to Evo.
                Studying MODX in the desert - http://sottwell.com
                Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
                Join the Slack Community - http://modx.org
              • Quote from: AMDbuilder at Jun 25, 2013, 07:20 PM
                I'm with Susan on this one, it sounds like the server is being overloaded. The problem is it's unable to connect to the database (timeout or refused), so we need to look into it's configuration.

                Can you tell us more about the server?

                Is there any particular part of the server info you would like to know about?
                • The more information you can provide the better.

                  A few example questions:
                  Shared/VPS/Cloud/Dedicated?
                  Total Ram/Burstable Ram?
                  Total Disk Space?
                  Root Access?
                  Control Panel?
                  Apache/PHP Configuration?
                  Etc.
                    Patrick | Server Wrangler
                    About Me: Website | TweetsMODX Hosting
                  • It is a private server, only running our live and development sites, they run on separate databases.

                    Yes, but if it's on the same server they'll be using the same MySQL engine. It can only handle as many concurrent queries as it's configured to handle.

                      Studying MODX in the desert - http://sottwell.com
                      Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
                      Join the Slack Community - http://modx.org