Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19
  1. #11
    Join Date
    Jun 2007
    Location
    Phoenix, AZ
    Posts
    69
    Plugin Contributions
    0

    Default Re: 2013 Lost connection to MySQL server during query

    Is your hosting provider GoDaddy? We are having a similar issue and had to disable the USPS module. I spent an hour on the phone with them yesterday and am told the issue has been escalated to the network administration staff.

    If you're using another provider, then never mind. :)

    In any case, what appears to be happening on my site is that the proxy server is taking too long to respond. Thus the USPS module takes a *long* time to retrieve the quotes. Meanwhile, the MySQL server timeout is set for 20 seconds. So, by the time the USPS module completes or times out, the MySQL connection has been closed by the server and the error message is generated.

    To confirm/replicate the issue try running a script that only fetches a URL with cURL. Does it take an extraordinarily long time to complete?

  2. #12
    Join Date
    Nov 2004
    Posts
    5
    Plugin Contributions
    0

    Default Re: 2013 Lost connection to MySQL server during query

    We are in the middle of switching to GoDaddy... because our current provider's servers were not stable enough and are now having your same problem with GoDaddy.

    I wish now that I had made a different choice of where to switch to.

    We also have the problem when searching in the admin/toolbox.

  3. #13
    Join Date
    Nov 2004
    Posts
    5
    Plugin Contributions
    0

    Default Re: 2013 Lost connection to MySQL server during query

    I replied again and questioned the timeout - again.... We'll see what happens.



    GoDaddy's Reply:

    Thank you for contacting Online Support. This appears to be an issue with the number of connections you are making to our MySQL server. We allow up to 50 simultaneous connections per MySQL user. Any connections made after reaching 50 connections will timeout and not be processed. If you are not having this number of people connecting simultaneously to our server, then it is likely the connections are not properly disconnecting from the server in the coding.

    Unfortunately, we are unable to offer assistance for custom coding, scripting, or programming issues beyond what is available in our Help Center. We recommend using your search engine of preference for assistance in resolving this issue. We apologize for any inconvenience.

    Please let us know if we can assist you in any other way.

    Regards,

    Heather P.
    Online Support

    Customer Inquiry


    ****************

    My E-Mail to GoDaddy:

    Transfer speed seems just fine, it seems to be SQL itself. Perhaps, it's
    timeout is set too low?

    Anyway, the error occurs in a couple of locations. While checking your
    shopping cart, with a few items in it, you get this error:

    ***
    2013 Lost connection to MySQL server during query
    in:
    [select products_id, products_price, products_tax_class_id, products_weight,
    products_priced_by_attribute, product_is_always_free_shipping,
    products_discount_type, products_discount_type_from, products_virtual,
    products_model from products where products_id = '639']

    2006 MySQL server has gone away
    in:
    [select count(*) as total from sessions where sesskey =
    '269e7ecd7f71e74fb4f858d129ca013f']


    Warning: Unknown(): A session is active. You cannot change the session
    module's ini settings at this time. in Unknown on line 0
    ***

    I can eliminate the error by turning off part of the query (checking for
    estimated USPS postage). At first, I thought that there might be an error
    in that particular code, but during a standard query on the admin page, we
    get this:

    ***
    2013 Lost connection to MySQL server during query
    in:
    [SELECT project_version_major, project_version_minor FROM project_version
    WHERE project_version_key = 'Zen-Cart Database']
    If you were entering information, press the BACK button in your browser and
    re-check the information you had entered to be sure you left no blank
    fields.

    2006 MySQL server has gone away
    in:
    [select count(*) as total from sessions where sesskey =
    'ebbb7103722c202d67f854d549e53f08']
    If you were entering information, press the BACK button in your browser and
    re-check the information you had entered to be sure you left no blank
    fields.


    Warning: Unknown(): A session is active. You cannot change the session
    module's ini settings at this time. in Unknown on line 0
    ***

  4. #14
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: 2013 Lost connection to MySQL server during query

    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #15
    Join Date
    Nov 2004
    Posts
    5
    Plugin Contributions
    0

    Default Re: 2013 Lost connection to MySQL server during query

    I think DrByte has the idea...

    This is GoDaddy's Final:

    Dear Sir/Madam,

    Thank you for contacting Online Support.

    By default, our shared hosting servers will timeout socket connections after 60 seconds. I would suggest reviewing your sites code and to optimize your database tables to ensure that the connection does not take longer than 60 seconds.

    Please let us know if we can help any other way.

    Regards,
    Dennis R.
    Online Support Technician

  6. #16
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: 2013 Lost connection to MySQL server during query

    For the last 2 weeks GoDaddy users have been reporting problems with timeouts when talking to external servers such as USPS and UPS and so on. They seem to be in denial about it. Just one more reason to stay away from them IMO. They're not focused on eCommerce businesses -- they just want hosting accounts regardless of the service they provide.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  7. #17
    Join Date
    Jun 2007
    Location
    Phoenix, AZ
    Posts
    69
    Plugin Contributions
    0

    Default Re: 2013 Lost connection to MySQL server during query

    Just an FYI... This has been fixed for our site. That seems to have been the case since Sunday.

    Also, "Dennis R." is incorrect. While the connect timeout on the server may be 60 seconds, you are not waiting to connect. You were already connected (hence the message "MySQL server has gone away.")

    The wait timeout on the DB server I connect to is 20 seconds, which is why my DB connection was dropping while trying to contact USPS.

    First tier support at GoDaddy is clueless. It took me 45 minutes to get the first guy to acknowledge that it was an issue on their end. A day later I received an email requesting that I call them back and all the second guy did was try to sell me their proprietary cart solution. -- Yeah, that's what I want: more dependence on GoDaddy. :)

  8. #18
    Join Date
    Nov 2004
    Posts
    5
    Plugin Contributions
    0

    Default Re: 2013 Lost connection to MySQL server during query

    GoDaddy was uncooperative at the wrong time. We were switching providers anyway, so we continued the switch.

    We stopped briefly at GoDaddy to test, which was not successful, so we kept moving to Blue Host.

    They, so far, seem a whole lot easier to deal with and are a whole lot more familiar with our situation.

    I don't have ANY time to waste explaining to a provider, that should know more than I do, what needs to happen, only to have them explain that there isn't much that they can do.

    I think that picking a provider that is already familiar with ZenCart, possible problems etc., is a smart idea.

  9. #19
    Join Date
    Jun 2003
    Posts
    33,715
    Plugin Contributions
    0

    Default Re: 2013 Lost connection to MySQL server during query

    I think that picking a provider that is already familiar with ZenCart, possible problems etc., is a smart idea.
    Exactly!
    Please do not PM for support issues: a private solution doesn't benefit the community.

    Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. 2013 Lost connection to MySQL server during query
    By rgriffith98 in forum General Questions
    Replies: 8
    Last Post: 24 Nov 2008, 08:53 PM
  2. Replies: 2
    Last Post: 7 Nov 2008, 08:52 PM
  3. Replies: 0
    Last Post: 20 Aug 2008, 10:30 AM
  4. 2013 Lost connection to MySQL server during query error
    By asic28 in forum General Questions
    Replies: 0
    Last Post: 19 Nov 2006, 05:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR