Warning: Error while sending QUERY packet.

  • Resolved andreirebe

    (@andreirebe)


    7 years, 4 months ago

    I have a setup of WordPress + WooCommerce with 1400 products and around 40000 variations. And a server with 4Gb RAM with dual core processor.

    What does this mean?

    Warning: Error while sending QUERY packet. PID=13691 in /home/110436-83689.cloudwaysapps.com/yyhfdrsjzt/public_html/wp-includes/wp-db.php on line 1942

    I get this error from time to time on different pages of the website. 

    
### WordPress Environment ###

Home URL: https://www.customt.ro
Site URL: https://www.customt.ro
WC Version: 3.2.1
Log Directory Writable: ?
WP Version: 4.8.3
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: ?
WP Cron: ?
Language: ro_RO

### Server Environment ###

Server Info: Apache/2.4.10 (Debian)
PHP Version: 7.0.25-1~dotdeb+8.1
PHP Post Max Size: 300 MB
PHP Time Limit: 600
PHP Max Input Vars: 2500
cURL Version: 7.38.0
OpenSSL/1.0.1t

SUHOSIN Installed: –
MySQL Version: 5.6.37
Max Upload Size: 300 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.2.1
WC Database Prefix: wp_
Total Database Size: 518.49MB
Database Data Size: 363.16MB
Database Index Size: 155.33MB
wp_woocommerce_sessions: Data: 0.08MB + Index: 0.02MB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB
wp_woocommerce_order_items: Data: 0.06MB + Index: 0.02MB
wp_woocommerce_order_itemmeta: Data: 0.23MB + Index: 0.22MB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB
courier_counties: Data: 0.00MB + Index: 0.00MB
courier_localities: Data: 0.39MB + Index: 0.48MB
courier_localities_urgentcargus: Data: 0.60MB + Index: 0.30MB
pma__bookmark: Data: 0.02MB + Index: 0.00MB
pma__central_columns: Data: 0.02MB + Index: 0.00MB
pma__column_info: Data: 0.02MB + Index: 0.02MB
pma__designer_settings: Data: 0.02MB + Index: 0.00MB
pma__export_templates: Data: 0.02MB + Index: 0.02MB
pma__favorite: Data: 0.02MB + Index: 0.00MB
pma__history: Data: 0.02MB + Index: 0.02MB
pma__navigationhiding: Data: 0.02MB + Index: 0.00MB
pma__pdf_pages: Data: 0.02MB + Index: 0.02MB
pma__recent: Data: 0.02MB + Index: 0.00MB
pma__relation: Data: 0.02MB + Index: 0.02MB
pma__savedsearches: Data: 0.02MB + Index: 0.02MB
pma__table_coords: Data: 0.02MB + Index: 0.00MB
pma__table_info: Data: 0.02MB + Index: 0.00MB
pma__table_uiprefs: Data: 0.02MB + Index: 0.00MB
pma__tracking: Data: 0.02MB + Index: 0.00MB
pma__userconfig: Data: 0.02MB + Index: 0.00MB
pma__usergroups: Data: 0.02MB + Index: 0.00MB
pma__users: Data: 0.02MB + Index: 0.00MB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB
wp_comments: Data: 0.06MB + Index: 0.09MB
wp_failed_jobs: Data: 0.36MB + Index: 0.00MB
wp_links: Data: 0.02MB + Index: 0.02MB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB
wp_options: Data: 182.55MB + Index: 15.09MB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB
wp_pmxi_imports: Data: 0.36MB + Index: 0.00MB
wp_pmxi_posts: Data: 3.52MB + Index: 0.00MB
wp_pmxi_templates: Data: 0.42MB + Index: 0.00MB
wp_postmeta: Data: 133.69MB + Index: 109.30MB
wp_posts: Data: 19.55MB + Index: 13.06MB
wp_queue: Data: 0.02MB + Index: 0.00MB
wp_redirection_404: Data: 8.52MB + Index: 7.48MB
wp_redirection_groups: Data: 0.02MB + Index: 0.03MB
wp_redirection_items: Data: 0.02MB + Index: 0.08MB
wp_redirection_logs: Data: 0.02MB + Index: 0.08MB
wp_termmeta: Data: 0.20MB + Index: 0.27MB
wp_terms: Data: 0.14MB + Index: 0.16MB
wp_term_relationships: Data: 9.52MB + Index: 7.52MB
wp_term_taxonomy: Data: 0.28MB + Index: 0.17MB
wp_usermeta: Data: 0.16MB + Index: 0.09MB
wp_users: Data: 0.02MB + Index: 0.05MB
wp_w3tc_cdn_queue: Data: 0.02MB + Index: 0.02MB
wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB
wp_yoast_seo_links: Data: 1.52MB + Index: 0.30MB
wp_yoast_seo_meta: Data: 0.11MB + Index: 0.00MB

### Post Type Counts ###

acf: 1
attachment: 23615
nav_menu_item: 59
page: 27
post: 8
product: 1459
product_variation: 34659
revision: 155
shop_coupon: 1
shop_order: 85
vc4_templates: 3
wpcf7_contact_form: 3

### Security ###

Secure connection (HTTPS): ?Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
Hide errors from visitors: ?Error messages should not be shown to visitors.

### Active Plugins (29) ###

404page - your smart custom 404 error page: by Peter Raschendorfer – 3.2
Campuri Personalizate Avansate: by Elliot Condon – 4.4.12
Bootstrap for Contact Form 7: by Felix Arntz – 1.4.5
Contact Form 7: by Takayuki Miyoshi – 4.9.1
D3C Latest Viewed Products: by D3Colors – 0.0.1
ElasticPress: by Taylor Lovett
Matt Gross
Aaron Holbrook
10up – 2.4

Enhanced Media Library PRO: by wpUXsolutions – 2.4.5
Fast Velocity Minify: by Raul Peixoto – 2.2.2
WPBakery Page Builder: by Michael M - WPBakery.com – 5.4.3
Loco Translate: by Tim Whitlock – 2.0.16
MailChimp for WooCommerce: by MailChimp – 2.1.1 – Not tested with the active version of WooCommerce
mobilPay Card Gateway for WooCommerce: by Santiago Interactive – 1.0.1 – Not tested with the active version of WooCommerce
Plugins Garbage Collector: by Vladimir Garagulya – 0.10.3
WooCommerce Product Filter: by Mihajlovic Nenad – 6.4.5 – Not tested with the active version of WooCommerce
ShiftNav - Responsive Mobile Menu: by Chris Mavricos
SevenSpark – 1.6.1.2

Super Socializer: by Team Heateor – 7.9.5
TinyMCE Advanced: by Andrew Ozz – 4.6.3
WooCommerce Custom Product Designer: by tshirtecommerce.com – 4.2.1 – Not tested with the active version of WooCommerce
UberMenu 3 - The Ultimate WordPress Mega Menu: by Chris Mavricos
SevenSpark – 3.2.7

Safe Alternative - Urgent Cargus Printing AWB: by Safe Alternative – 1.7.4 – Not tested with the active version of WooCommerce
Safe Alternative - Urgent Cargus Shipping Calculate: by Safe Alternative – 1.7.2 – Not tested with the active version of WooCommerce
W3 Total Cache: by Frederick Townes – 0.9.5.4
WC City Select: by 8manos – 1.0.3 – Not tested with the active version of WooCommerce
WooCommerce Permalink Manager: by premmerce – 1.1
WooSwatches - Woocommerce Color or Image Variation Swatches: by parbat chaudhari – 2.3.6 – Not tested with the active version of WooCommerce
WooCommerce: by Automattic – 3.2.1 – 3.2.3 is available
Yoast SEO: by Team Yoast – 5.8
WP Delete User Accounts: by Ren Ventura – 1.0
WP-Optimize: by David Anderson
Ruhani Rabin
Team Updraft – 2.1.1

### Settings ###

API Enabled: ?
Force SSL: ?
Currency: RON (lei)
Currency Position: right_space
Thousand Separator: .
Decimal Separator: ,
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

### WC Pages ###

Shop base: ? Page ID is set
but the page does not exist

Cart: #5 - /cart/
Checkout: #6 - /cart/checkout/
My account: #7 - /contul-meu/
Terms and conditions: #117 - /termeni-si-conditii/

### Theme ###

Name: TIPARO Child
Version: 1.0.0
Author URL: 
Child Theme: ?
Parent Theme Name: Storefront
Parent Theme Version: 2.2.5
Parent Theme Author URL: https://woocommerce.com/
WooCommerce Support: ?

### Templates ###

Overrides: tiparo-child/woocommerce/archive-product.php
tiparo-child/woocommerce/cart/cart-empty.php
tiparo-child/woocommerce/cart/cart-item-data.php
tiparo-child/woocommerce/cart/cart-totals.php
tiparo-child/woocommerce/cart/cart.php
tiparo-child/woocommerce/cart/mini-cart.php
tiparo-child/woocommerce/cart/proceed-to-checkout-button.php
tiparo-child/woocommerce/checkout/form-billing.php
tiparo-child/woocommerce/checkout/form-checkout.php
tiparo-child/woocommerce/checkout/form-pay.php
tiparo-child/woocommerce/checkout/form-shipping.php
tiparo-child/woocommerce/checkout/payment.php
tiparo-child/woocommerce/checkout/review-order.php
tiparo-child/woocommerce/checkout/terms.php
tiparo-child/woocommerce/content-product.php
tiparo-child/woocommerce/content-single-product.php
tiparo-child/woocommerce/global/quantity-input.php
tiparo-child/woocommerce/loop/add-to-cart.php
tiparo-child/woocommerce/loop/loop-end.php
tiparo-child/woocommerce/loop/loop-start.php
tiparo-child/woocommerce/loop/no-products-found.php
tiparo-child/woocommerce/loop/orderby.php
tiparo-child/woocommerce/loop/pagination.php
tiparo-child/woocommerce/loop/price.php
tiparo-child/woocommerce/loop/result-count.php
tiparo-child/woocommerce/loop/sale-flash.php
tiparo-child/woocommerce/myaccount/dashboard.php
tiparo-child/woocommerce/myaccount/form-edit-account.php
tiparo-child/woocommerce/myaccount/form-edit-address.php
tiparo-child/woocommerce/myaccount/form-login.php
tiparo-child/woocommerce/myaccount/form-lost-password.php
tiparo-child/woocommerce/myaccount/form-reset-password.php
tiparo-child/woocommerce/myaccount/lost-password-confirmation.php
tiparo-child/woocommerce/myaccount/my-account.php
tiparo-child/woocommerce/myaccount/my-address.php
tiparo-child/woocommerce/myaccount/navigation.php
tiparo-child/woocommerce/myaccount/orders.php
tiparo-child/woocommerce/myaccount/view-order.php
tiparo-child/woocommerce/notices/error.php
tiparo-child/woocommerce/notices/notice.php
tiparo-child/woocommerce/notices/success.php
tiparo-child/woocommerce/order/order-again.php
tiparo-child/woocommerce/order/order-details-customer.php
tiparo-child/woocommerce/order/order-details-item.php
tiparo-child/woocommerce/order/order-details.php
tiparo-child/woocommerce/product-searchform.php
tiparo-child/woocommerce/single-product/add-to-cart/simple.php
tiparo-child/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
tiparo-child/woocommerce/single-product/product-image.php
tiparo-child/woocommerce/single-product/sale-flash.php
tiparo-child/woocommerce/single-product/tabs/description.php
tiparo-child/woocommerce/single-product/tabs/tabs.php
tiparo-child/woocommerce/single-product/up-sells.php
tiparo-child/woocommerce/single-product.php

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Nico

    (@nicolamustone)

    Automattic Happiness Engineer

    Hi,
    According to all the results I found on Google, this is an issue with the server configuration.

    You can find more detailed info here: https://stackoverflow.com/questions/30753674/error-while-sending-query-packet

    I would suggest you to contact your host and report them the issue. They should be able to fix it by tweaking the DB configuration, or tell you what to do to fix.

    Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Warning: Error while sending QUERY packet.’ is closed to new replies.