WordPress.org

Resolved

(@taylorfoxxdev)

Hello! We have Jetpack installed on one of our client’s websites with WPEngine and we are seeing some crazy “Killed Query” issues that seems to be coming from the JetPack plugin. We currently use JetPack for WooCommerce and don’t want to uninstall the plugin, but would like to find the root of this to ensure it’s not causing another issue we are encountering. Here is the message we are seeing in the logs:

{
  "installName": "bluberry",
  "environment": "PROD",
  "type": "error",
  "date": "2024-05-29T22:30:44.959Z",
  "severity": null,
  "client": null,
  "message": "KILLED QUERY (20327 characters long generated in /nas/content/live/bluberry/wp-content/plugins/jetpack/jetpack_vendor/automattic/jetpack-sync/src/sync-queue/class-queue-storage-table.php:307): SELECT event_id AS id, event_payload AS value#012#011#011#011#011FROM wp_jetpack_sync_queue#012#011#011#011#011WHERE queue_id = 'sync' AND event_id IN ( 'jpsq_sync-1701929490.031248-761210-7498', 'jpsq_sync-1701929490.044547-761210-7499', 'jpsq_sync-1701929490.068702-761210-7500', 'jpsq_sync-1701929490.080738-761210-7501', 'jpsq_sync-1701929490.088247-761210-7502', 'jpsq_sync-1701929490.094437-761210-7503', 'jpsq_sync-1701929490.102475-761210-7504', 'jpsq_sync-1701929490.137315-761210-7505', 'jpsq_sync-1701929490.143049-761210-7506', 'jpsq_sync-1701929490.150875-761210-7507', 'jpsq_sync-1701929490.157253-761210-7508', 'jpsq_sync-1701929490.168064-761210-7509', 'jpsq_sync-1701929490.176361-761210-7510', 'jpsq_sync-1701929490.231731-761210-7511', 'jpsq_sync-1701929490.244490-761210-7512', 'jpsq_sync-1701929490.261129-761210-7513', 'jpsq_sync-1701929490.269582-761210-7514', 'jpsq_sync-1701929490.277612-761210-7515', 'jpsq_sync-1701929490.337787-761210-7516', 'jpsq_sync-1701929490.346087-761210-7517', 'jpsq_sync-1701929490.989135-761210-7518', 'jpsq_sync-1701929491.132512-761210-7519', 'jpsq_sync-1701929491.137030-761210-7520', 'jpsq_sync-1701929491.155761-761210-7521', 'jpsq_sync-1701929491.166400-761210-7522', 'jpsq_sync-1701929491.177015-761210-7523', 'jpsq_sync-1701929491.183906-761210-7524', 'jpsq_sync-1701929491.189801-761210-7525', 'jpsq_sync-1701929491.195739-761210-7526', 'jpsq_sync-1701929491.201661-761210-7527', 'jpsq_sync-1701929491.207644-761210-7528', 'jpsq_sync-1701929491.213596-761210-7529', 'jpsq_sync-1701929491.231971-761210-7530', 'jpsq_sync-1701929491.239202-761210-7531', 'jpsq_sync-1701929491.245274-761210-7532', 'jpsq_sync-1701929491.258215-761210-7533', 'jpsq_sync-1701929491.263378-761210-7534', 'jpsq_sync-1701929491.269870-761210-7535', 'jpsq_sync-1701929491.280477-761210-7536', 'jpsq_sync-1701929491.292090-761210-7537', 'jpsq_sync-1701929491.297763-761210-7538', 'jpsq_sync-1701929491.957225-761210-7539', 'jpsq_sync-1701929492.069361-761210-7540', 'jpsq_sync-1701929492.072648-761210-7541', 'jpsq_sync-1701929492.136002-761210-7542', 'jpsq_sync-1701929492.147651-761210-7543', 'jpsq_sync-1701929492.158088-761210-7544', 'jpsq_sync-1701929492.164702-761210-7545', 'jpsq_sync-1701929492.171182-761210-7546', 'jpsq_sync-1701929492.176814-761210-7547', 'jpsq_sync-1701929492.182781-761210-7548', 'jpsq_sync-1701929492.189448-761210-7549', 'jpsq_sync-1701929492.233309-761210-7550', 'jpsq_sync-1701929492.240497-761210-7551', 'jpsq_sync-1701929492.247218-761210-7552', 'jpsq_sync-1701929492.254736-761210-7553', 'jpsq_sync-1701929492.267403-761210-7554', 'jpsq_sync-1701929492.273251-761210-7555', 'jpsq_sync-1701929492.279383-761210-7556', 'jpsq_sync-1701929492.290521-761210-7557', 'jpsq_sync-1701929492.299607-761210-7558', 'jpsq_sync-1701929492.332655-761210-7559', 'jpsq_sync-1701929492.799164-761210-7560', 'jpsq_sync-1701929492.855859-761210-7561', 'jpsq_sync-1701929492.859766-761210-7562', 'jpsq_sync-1701929492.877215-761210-7563', 'jpsq_sync-1701929492.886175-761210-7564', 'jpsq_sync-1701929492.897336-761210-7565', 'jpsq_sync-1701929492.904624-761210-7566', 'jpsq_sync-1701929492.911199-761210-7567', 'jpsq_sync-1701929492.917817-761210-7568', 'jpsq_sync-1701929492.939063-761210-7569', 'jpsq_sync-1701929492.946117-761210-7570', 'jpsq_sync-1701929492.953138-761210-7571', 'jpsq_sync-1701929492.959127-761210-7572', 'jpsq_sync-1701929492.966702-761210-7573', 'jpsq_sync-1701929492.973365-761210-7574', 'jpsq_sync-1701929492.986171-761210-7575', 'jpsq_sync-1701929492.992307-761210-7576', 'jpsq_sync-1701929492.999087-761210-7577', 'jpsq_sync-1701929493.011575-761210-7578', 'jpsq_sync-1701929493.037502-761210-7579', 'jpsq_sync-1701929493.044194-761210-7580', 'jpsq_sync-1701929493.483197-761210-7581', 'jpsq_sync-1701929493.543244-761210-7582', 'jpsq_sync-1701929493.546168-761210-7583', 'jpsq_sync-1701929493.563565-761210-7584', 'jpsq_sync-1701929493.573075-761210-7585', 'jpsq_sync-1701929493.582429-761210-7586', 'jpsq_sync-1701929493.589345-761210-7587', 'jpsq_sync-1701929493.596047-761210-7588', 'jpsq_sync-1701929493.603169-761210-7589', 'jpsq_sync-1701929493.610625-761210-7590', 'jpsq_sync-1701929493.618718-761210-7591', 'jpsq_sync-1701929493.625451-761210-7592', 'jpsq_sync-1701929493.631542-761210-7593', 'jpsq_sync-1701929493.638864-761210-7594', 'jpsq_sync-1701929493.645075-761210-7595', 'jpsq_sync-1701929493.659372-761210-7596', 'jpsq_sync-1701929493.664986-761210-7597', 'jpsq_sync-1701929493.671056-761210-7598', 'jpsq_sync-1701929493.680403-761210-7599', 'jpsq_sync-1701929493.690296-761210-7600', 'jpsq_sync-1701929493.697588-761210-7601', 'jpsq_sync-1701929494.127165-761210-7602', 'jpsq_sync-1701929494.184215-761210-7603', 'jpsq_sync-1701929494.187477-761210-7604', 'jpsq_sync-1701929494.205136-761210-7605', 'jpsq_sync-1701929494.214533-761210-7606', 'jpsq_sync-1701929494.225145-761210-7607', 'jpsq_sync-1701929494.231049-761210-7608', 'jpsq_sync-1701929494.237439-761210-7609', 'jpsq_sync-1701929494.242942-761210-7610', 'jpsq_sync-1701929494.249020-761210-7611', 'jpsq_sync-1701929494.256498-761210-7612', 'jpsq_sync-1701929494.262222-761210-7613', 'jpsq_sync-1701929494.267987-761210-7614', 'jpsq_sync-1701929494.276073-761210-7615', 'jpsq_sync-1701929494.283240-761210-7616', 'jpsq_sync-1701929494.297048-761210-7617', 'jpsq_sync-1701929494.303272-761210-7618', 'jpsq_sync-1701929494.309618-761210-7619', 'jpsq_sync-1701929494.319673-761210-7620', 'jpsq_sync-1701929494.328705-761210-7621', 'jpsq_sync-1701929494.335269-761210-7622', 'jpsq_sync-1701929494.759269-761210-7623', 'jpsq_sync-1701929494.818155-761210-7624', 'jpsq_sync-1701929494.821015-761210-7625', 'jpsq_sync-1701929494.849232-761210-7626', 'jpsq_sync-1701929494.859643-761210-7627', 'jpsq_sync-1701929494.869502-761210-7628', 'jpsq_sync-1701929494.876218-761210-7629', 'jpsq_sync-1701929494.883929-761210-7630', 'jpsq_sync-1701929494.890625-761210-7631', 'jpsq_sync-1701929494.898103-761210-7632', 'jpsq_sync-1701929494.905025-761210-7633', 'jpsq_sync-1701929494.911773-761210-7634', 'jpsq_sync-1701929494.932386-761210-7635', 'jpsq_sync-1701929494.940229-761210-7636', 'jpsq_sync-1701929494.948210-761210-7637', 'jpsq_sync-1701929494.964023-761210-7638', 'jpsq_sync-1701929494.971197-761210-7639', 'jpsq_sync-1701929494.978466-761210-7640', 'jpsq_sync-1701929494.991162-761210-7641', 'jpsq_sync-1701929495.003290-761210-7642', 'jpsq_sync-1701929495.036073-761210-7643', 'jpsq_sync-1701929495.733446-761210-7644', 'jpsq_sync-1701929495.834595-761210-7645', 'jpsq_sync-1701929495.838931-761210-7646', 'jpsq_sync-1701929495.858184-761210-7647', 'jpsq_sync-1701929495.868297-761210-7648', 'jpsq_sync-1701929495.878070-761210-7649', 'jpsq_sync-1701929495.884824-761210-7650', 'jpsq_sync-1701929495.890787-761210-7651', 'jpsq_sync-1701929495.896568-761210-7652', 'jpsq_sync-1701929495.903297-761210-7653', 'jpsq_sync-1701929495.909896-761210-7654', 'jpsq_sync-1701929495.932124-761210-7655', 'jpsq_sync-1701929495.939813-761210-7656', 'jpsq_sync-1701929495.946892-761210-7657', 'jpsq_sync-1701929495.954273-761210-7658', 'jpsq_sync-1701929495.967703-761210-7659', 'jpsq_sync-1701929495.974243-761210-7660', 'jpsq_sync-1701929495.979755-761210-7661', 'jpsq_sync-1701929495.989726-761210-7662', 'jpsq_sync-1701929496.002777-761210-7663', 'jpsq_sync-1701929496.010093-761210-7664', 'jpsq_sync-1701929496.468471-761210-7665', 'jpsq_sync-1701929496.534619-761210-7666', 'jpsq_sync-1701929496.538493-761210-7667', 'jpsq_sync-1701929496.558521-761210-7668', 'jpsq_sync-1701929496.570279-761210-7669', 'jpsq_sync-1701929496.581008-761210-7670', 'jpsq_sync-1701929496.589927-761210-7671', 'jpsq_sync-1701929496.598497-761210-7672', 'jpsq_sync-1701929496.605001-761210-7673', 'jpsq_sync-1701929496.611360-761210-7674', 'jpsq_sync-1701929496.619438-761210-7675', 'jpsq_sync-1701929496.626598-761210-7676', 'jpsq_sync-",
  "uuid": "07376259-d8fa-4b17-a14a-d6c67e475b33"
}

Any help would be appreciated in solving this problem as we are having some weird PHP get injected on the site as well that may be related.

Thank you!!

Viewing 5 replies - 1 through 5 (of 5 total)

Plugin Contributor Foteini Giannaropoulou (a11n)
(@fgiannar)

2 months, 1 week ago

Hello there,

To check the exact issue, we need the site address.

Could you please post your site URL here so that we can have a look? If you want it to remain private, you can also contact us via this contact form.

If you choose to reach out directly, please include a link to this thread.

Thread Starter taylorfoxxdev
(@taylorfoxxdev)

2 months ago

Hey @fgiannar !

I totally understand. The URL to the site is http://juneberry.com/. Let me know if there is anything else you need on our end!! Thank you so much!
Plugin Support lastsplash (a11n)
(@lastsplash)

2 months ago
Hi @taylorfoxxdev –

Looking at your site, the issue is that your site’s Sucuri firewall is blocking Jetpack. When Jetpack tries to communicate with your site it does so via xmlrpc.php but that file is blocked by Sucuri on your site.

From the error message we see on our end:
```
HTTP/1.1 403 Forbidden
Server: Sucuri/Cloudproxy
Date: Sat, 01 Jun 2024 18:35:44 GMT
Content-Type: text/html
Transfer-Encoding: chunked
Connection: close
X-Sucuri-ID: 12034
X-XSS-Protection: 1; mode=block
X-Frame-Options: SAMEORIGIN
X-Content-Type-Options: nosniff
Content-Security-Policy: upgrade-insecure-requests;
X-Sucuri-Block: SQLi22

<!DOCTYPE html>
<html lang="en" xmlns="http://www.w3.org/1999/xhtml">
<head>
<link rel="stylesheet" href="https://cdn.sucuri.net/sucuri-firewall-block.css" />
<section class="center clearfix">
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>Sucuri WebSite Firewall - Access Denied</title>
<link href="https://fonts.googleapis.com/css?family=Open+Sans:400,300,600,700" rel="stylesheet" type="text/css">
</head>
<body>
<div id="main-container">
<header class="app-header clearfix">
<div class="wrap">
<a href="https://www.sucuri.net/?utm_source=firewall_block" class="logo"></a>
<span class="logo-neartext">Website Firewall</span>
<a href="https://sucuri.net/?utm_source=firewall_block" class="site-link">Back to sucuri.net</a>
</div>
</header>

<section class="app-content access-denied clearfix"><div class="box center width-max-940"><h1 class="brand-font font-size-xtra no-margin"><i class="icon-circle-red"></i>Access Denied - Sucuri Website Firewall</h1>
<p class="medium-text code-snippet">If you are the site owner (or you manage this site), please whitelist your IP or if you think this block is an error please <a href="https://support.sucuri.net/?utm_source=firewall_block" class="color-green underline">open a support ticket</a> and make sure to include the block details (displayed in the box below), so we can assist you in troubleshooting the issue. </p><h2>Block details:</h1>
<table class="property-table overflow-break-all line-height-16">
<tr>
<td>Your IP:</td>
<td><span>192.0.89.251</span></td>
</tr>
<tr><td>URL:</td>
<td><span>juneberry.com/?
```
As a next step here, you will want to configure Sucuri to allow Jetpack to access xmlrpc.php. We have instructions on that at:

https://jetpack.com/support/how-to-add-jetpack-ips-allowlist/#use-jetpack-with-cloudflare-additional-security-rules-and-sucuri

Let us know once you make that change and we can check the connection again.
Plugin Contributor Foteini Giannaropoulou (a11n)
(@fgiannar)

2 months ago

Hi @taylorfoxxdev ,

I’d like to confirm that on top of what my colleague shared above, the original reported “Killed Query” issue is now resolved on our end.

An important part of ensuring Jetpack and WooCommerce related features work as expected, involves syncing certain site data to Automattic’s servers.

At some point (unfortunately too long ago to find related logs) the queue of data we sync grew too large, which combined with WPEngine’s limitation in database queries of SELECT Statements resulted in the “Killed Query” error you reported.

We have now cleared the queue of data we sync at your site, therefore you shouldn’t be seeing those errors anymore.

That said, what @lastsplash shared above in terms of configuring Sucuri to allow Jetpack to access xmlrpc.php is still applicable and would be great to be addressed.

Plugin Support Joseph B. (a11n)
(@tamirat22)

1 month, 3 weeks ago

Hello @taylorfoxxdev,

It’s been one week since this topic was last updated. I’m going to mark this thread as solved. If you have any further questions or need more help, you’re welcome to open another thread here. Cheers!

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.