We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 16861 ☆ A M B ☆
    • 86 Posts
    I have the following error that shows one site:

    [2012-08-02 07:31:47] (ERROR @ /index.php) Error HY000 executing statement: 
    Array
    (
        [0] => HY000
        [1] => 2006
        [2] => MySQL server has gone away
    )


    On another site, I get the following errors:

    2012-08-01 10:22:51] (ERROR in xPDOConnection::connect @ /************httpdocs/core/xpdo/xpdo.class.php : 2997) SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    [2012-08-01 10:22:51] (ERROR in xPDOConnection::connect @ /************/httpdocs/core/xpdo/xpdo.class.php : 2997) SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    [2012-08-01 10:22:51] (ERROR @ /index.php) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ?  - 
    [2012-08-01 10:22:51] (ERROR in xPDOConnection::connect @ /************/httpdocs/core/xpdo/xpdo.class.php : 2997) SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    [2012-08-01 10:22:51] (ERROR in xPDOConnection::connect @ /************/httpdocs/core/xpdo/xpdo.class.php : 2997) SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    [2012-08-01 10:22:51] (ERROR @ /index.php) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ?  - 
    [2012-08-01 10:22:51] (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
    
    AND
    
    [2012-08-02 10:50:37] (ERROR @ /connectors/system/log.php) Could not load class: unknown from mysql.unknown.
    [2012-08-02 10:50:37] (ERROR @ /connectors/system/log.php) unknown::load() is not a valid static method. 


    Can someone tell me why I am getting these? I have noticed that my server memory usage is spiking and I wonder if this is contributing. thanks [ed. note: LeeB last edited this post 14 years, 2 months ago.]
      Lee Brinckley
      Manassas, VA (Washington DC)
      Twitter - @leebrinckley
      http://www.leebrinckley.com
      • 33983 ☆ A M B ☆
      • 181 Posts
      I would check if your MySQL is running properly. Is this a dedicated host or shared? Is there a limited number of concurrent users set in MySQL and are you hitting that number?
        • 16861 ☆ A M B ☆
        • 86 Posts
        This is a cloud server. How would I check that using Plesk?

        Thanks
          Lee Brinckley
          Manassas, VA (Washington DC)
          Twitter - @leebrinckley
          http://www.leebrinckley.com
          • 42681
          • 64 Posts
          Hi Lee,
          did you meanwhile find out the reason for the error 'server has gone away'?
            • 3749
            • 24,544 Posts
            If it's shared hosting, it could be that the database server is overloaded and is timing out periodically.
              Did I help you? Buy me a beer
              Get my Book: MODX:The Official Guide
              MODX info for everyone: http://bobsguides.com/modx.html
              My MODX Extras
              Bob's Guides is now hosted at A2 MODX Hosting