KILLED QUERY in logs over and over again

  • Resolved darrenseuk

    (@darrenseuk)


    9 months, 2 weeks ago

    Hi, I am reviewing our error logs on our web host for our website and we have multiple of these over and over again:

    {
    “installName”: “marineindustr”,
    “environment”: “PROD”,
    “type”: “error”,
    “date”: “2024-06-18T08:14:09.148Z”,
    “severity”: null,
    “client”: null,
    “message”: “KILLED QUERY (16455 characters long generated in /nas/content/live/marineindustr/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-1718124240.605553-620457-1’, ‘jpsq_sync-1718124240.622290-620457-2’, ‘jpsq_sync-1718124240.664102-620457-3’, ‘jpsq_sync-1718124267.533721-825892-1’, ‘jpsq_sync-1718124285.812780-519569-1’, ‘jpsq_sync-1718124292.101591-829754-1’, ‘jpsq_sync-1718124292.111288-829754-2’, ‘jpsq_sync-1718124298.201386-650836-1’, ‘jpsq_sync-1718124309.912613-522555-1’, ‘jpsq_sync-1718124326.755831-522555-2’, ‘jpsq_sync-1718124338.443438-371114-1’, ‘jpsq_sync-1718124338.471658-371114-2’, ‘jpsq_sync-1718124338.475239-371114-3’, ‘jpsq_sync-1718124341.139218-706254-1’, ‘jpsq_sync-1718124380.793308-949962-1’, ‘jpsq_sync-1718124380.804004-949962-2’, ‘jpsq_sync-1718124380.883617-949962-3’, ‘jpsq_sync-1718124406.231710-335979-1’, ‘jpsq_sync-1718124406.499913-335979-2’, ‘jpsq_sync-1718124406.553915-335979-3’, ‘jpsq_sync-1718124406.567714-335979-4’, ‘jpsq_sync-1718124406.699623-335979-5’, ‘jpsq_sync-1718124406.965432-335979-6’, ‘jpsq_sync-1718124406.981142-335979-7’, ‘jpsq_sync-1718124407.089746-335979-8’, ‘jpsq_sync-1718124407.173801-335979-9’, ‘jpsq_sync-1718124407.184659-335979-10’, ‘jpsq_sync-1718124407.188706-335979-11’, ‘jpsq_sync-1718124407.467492-335979-12’, ‘jpsq_sync-1718124407.487033-335979-13’, ‘jpsq_sync-1718124407.497395-335979-14’, ‘jpsq_sync-1718124407.560095-335979-15’, ‘jpsq_sync-1718124407.592239-335979-16’, ‘jpsq_sync-1718124407.904985-335979-17’, ‘jpsq_sync-1718124407.962935-335979-18’, ‘jpsq_sync-1718124407.972219-335979-19’, ‘jpsq_sync-1718124408.197048-335979-20’, ‘jpsq_sync-1718124408.219677-335979-21’, ‘jpsq_sync-1718124408.255856-335979-22’, ‘jpsq_sync-1718124408.288597-335979-23’, ‘jpsq_sync-1718124408.367416-335979-24’, ‘jpsq_sync-1718124408.383083-335979-25’, ‘jpsq_sync-1718124408.437070-335979-26’, ‘jpsq_sync-1718124408.455771-335979-27’, ‘jpsq_sync-1718124408.463123-335979-28’, ‘jpsq_sync-1718124408.467255-335979-29’, ‘jpsq_sync-1718124408.675377-335979-30’, ‘jpsq_sync-1718124408.694920-335979-31’, ‘jpsq_sync-1718124408.704646-335979-32’, ‘jpsq_sync-1718124408.755977-335979-33’, ‘jpsq_sync-1718124409.040696-335979-34’, ‘jpsq_sync-1718124409.063237-335979-35’, ‘jpsq_sync-1718124409.234621-335979-36’, ‘jpsq_sync-1718124409.260656-335979-37’, ‘jpsq_sync-1718124409.268211-335979-38’, ‘jpsq_sync-1718124409.515402-335979-39’, ‘jpsq_sync-1718124409.554347-335979-40’, ‘jpsq_sync-1718124409.565408-335979-41’, ‘jpsq_sync-1718124409.682320-335979-42’, ‘jpsq_sync-1718124410.114075-335979-43’, ‘jpsq_sync-1718124410.160743-335979-44’, ‘jpsq_sync-1718124410.577276-335979-45’, ‘jpsq_sync-1718124410.920789-335979-46’, ‘jpsq_sync-1718124411.436615-335979-47’, ‘jpsq_sync-1718124411.456228-335979-48’, ‘jpsq_sync-1718124411.471135-335979-49’, ‘jpsq_sync-1718124411.709386-335979-50’, ‘jpsq_sync-1718124411.734273-335979-51’, ‘jpsq_sync-1718124411.743458-335979-52’, ‘jpsq_sync-1718124411.863856-335979-53’, ‘jpsq_sync-1718124411.929960-335979-54’, ‘jpsq_sync-1718124412.658108-335979-55’, ‘jpsq_sync-1718124412.735287-335979-56’, ‘jpsq_sync-1718124412.756683-335979-57’, ‘jpsq_sync-1718124412.966122-335979-58’, ‘jpsq_sync-1718124412.989329-335979-59’, ‘jpsq_sync-1718124413.000250-335979-60’, ‘jpsq_sync-1718124413.089977-335979-61’, ‘jpsq_sync-1718124414.215304-335979-62’, ‘jpsq_sync-1718124414.243934-335979-63’, ‘jpsq_sync-1718124414.774143-335979-64’, ‘jpsq_sync-1718124414.817612-335979-65’, ‘jpsq_sync-1718124414.824493-335979-66’, ‘jpsq_sync-1718124414.828532-335979-67’, ‘jpsq_sync-1718124415.001088-335979-68’, ‘jpsq_sync-1718124415.023602-335979-69’, ‘jpsq_sync-1718124415.056765-335979-70’, ‘jpsq_sync-1718124415.109039-335979-71’, ‘jpsq_sync-1718124415.141192-335979-72’, ‘jpsq_sync-1718124415.355463-335979-73’, ‘jpsq_sync-1718124415.392458-335979-74’, ‘jpsq_sync-1718124415.400130-335979-75’, ‘jpsq_sync-1718124415.403940-335979-76’, ‘jpsq_sync-1718124415.580471-335979-77’, ‘jpsq_sync-1718124415.600310-335979-78’, ‘jpsq_sync-1718124415.610649-335979-79’, ‘jpsq_sync-1718124415.672162-335979-80’, ‘jpsq_sync-1718124415.706040-335979-81’, ‘jpsq_sync-1718124415.756115-335979-82’, ‘jpsq_sync-1718124415.764740-335979-83’, ‘jpsq_sync-1718124415.769325-335979-84’, ‘jpsq_sync-1718124415.956435-335979-85’, ‘jpsq_sync-1718124415.980924-335979-86’, ‘jpsq_sync-1718124415.992020-335979-87’, ‘jpsq_sync-1718124416.053543-335979-88’, ‘jpsq_sync-1718124416.074133-335979-89’, ‘jpsq_sync-1718124416.095050-335979-90’, ‘jpsq_sync-1718124416.101648-335979-91’, ‘jpsq_sync-1718124416.308610-335979-92’, ‘jpsq_sync-1718124416.362423-335979-93’, ‘jpsq_sync-1718124416.373822-335979-94’, ‘jpsq_sync-1718124416.453661-335979-95’, ‘jpsq_sync-1718124416.566326-335979-96’, ‘jpsq_sync-1718124416.586232-335979-97’, ‘jpsq_sync-1718124416.658075-335979-98’, ‘jpsq_sync-1718124416.848552-335979-99’, ‘jpsq_sync-1718124417.173834-335979-100’, ‘jpsq_sync-1718124417.200621-335979-101’, ‘jpsq_sync-1718124417.209533-335979-102’, ‘jpsq_sync-1718124451.280075-335979-103’, ‘jpsq_sync-1718124451.285186-335979-104’, ‘jpsq_sync-1718124451.297475-335979-105’, ‘jpsq_sync-1718124453.211530-335979-106’, ‘jpsq_sync-1718124470.657774-508352-1’, ‘jpsq_sync-1718124520.756503-235987-1’, ‘jpsq_sync-1718124520.761434-235987-2’, ‘jpsq_sync-1718124520.782945-235987-3’, ‘jpsq_sync-1718124543.935703-579046-1’, ‘jpsq_sync-1718124544.031678-579046-2’, ‘jpsq_sync-1718124544.687264-579046-3’, ‘jpsq_sync-1718124544.714519-579046-4’, ‘jpsq_sync-1718124544.911899-579046-5’, ‘jpsq_sync-1718124545.041085-579046-6’, ‘jpsq_sync-1718124545.045807-579046-7’, ‘jpsq_sync-1718124545.052700-579046-8’, ‘jpsq_sync-1718124545.096551-579046-9’, ‘jpsq_sync-1718124545.120361-579046-10’, ‘jpsq_sync-1718124545.195159-579046-11’, ‘jpsq_sync-1718124545.199927-579046-12’, ‘jpsq_sync-1718124545.206173-579046-13’, ‘jpsq_sync-1718124545.210400-579046-14’, ‘jpsq_sync-1718124545.256044-579046-15’, ‘jpsq_sync-1718124545.335609-579046-16’, ‘jpsq_sync-1718124545.339616-579046-17’, ‘jpsq_sync-1718124545.346641-579046-18’, ‘jpsq_sync-1718124545.389144-579046-19’, ‘jpsq_sync-1718124545.395141-579046-20’, ‘jpsq_sync-1718124545.474837-579046-21’, ‘jpsq_sync-1718124545.479341-579046-22’, ‘jpsq_sync-1718124545.487080-579046-23’, ‘jpsq_sync-1718124545.493538-579046-24’, ‘jpsq_sync-1718124545.537644-579046-25’, ‘jpsq_sync-1718124545.612047-579046-26’, ‘jpsq_sync-1718124545.616354-579046-27’, ‘jpsq_sync-1718124545.623224-579046-28’, ‘jpsq_sync-1718124545.660913-579046-29’, ‘jpsq_sync-1718124545.675351-579046-30’, ‘jpsq_sync-1718124545.771319-579046-31’, ‘jpsq_sync-1718124545.778017-579046-32’, ‘jpsq_sync-1718124545.784860-579046-33’, ‘jpsq_sync-1718124545.829749-579046-34’, ‘jpsq_sync-1718124545.834154-579046-35’, ‘jpsq_sync-1718124545.928797-579046-36’, ‘jpsq_sync-1718124545.972583-579046-37’, ‘jpsq_sync-1718124545.979045-579046-38’, ‘jpsq_sync-1718124546.076914-579046-39’, ‘jpsq_sync-1718124546.081340-579046-40’, ‘jpsq_sync-1718124546.088128-579046-41’, ‘jpsq_sync-1718124546.124004-579046-42’, ‘jpsq_sync-1718124546.210043-579046-43’, ‘jpsq_sync-1718124546.214130-579046-44’, ‘jpsq_sync-1718124546.220561-579046-45’, ‘jpsq_sync-1718124546.267691-579046-46’, ‘jpsq_sync-1718124546.340721-579046-47’, ‘jpsq_sync-1718124546.345154-579046-48’, ‘jpsq_sync-1718124546.351721-579046-49’, ‘jpsq_sync-1718124546.356075-579046-50’, ‘jpsq_sync-1718124546.480722-579046-51’, ‘jpsq_sync-1718124546.485757-579046-52’, ‘jpsq_sync-1718124546.494115-579046-53’, ‘jpsq_sync-1718124546.535466-579046-54’, ‘jpsq_sync-1718124546.539513-579046-55’, ‘jpsq_sync-1718124546.637764-579046-56’, ‘jpsq_sync-1718124547.307663-579046-57’, ‘jpsq_sync-1718124547.403127-579046-58’, ‘jpsq_sync-1718124547.443852-579046-59’, ‘jpsq_sync-1718124547.496455-579046-60’, ‘jpsq_sync-1718124547.506570-579046-61’, ‘jpsq_sync-1718124547.57”,
    “uuid”: “60dc55bf-9b67-4db3-b975-a3462caa599d”
    }

    we are on WordPress 6.5.3 and everything else is fully up to date. is this something I can turn off in settings to resolve for now? our news site has over 11,000 news items and growing daily.

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

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

  • Hi @darrenseuk

    Thanks for attaching that! I can see that there’s a query being killed (stopped) as it contained a lot of data to sync the items you are adding to the site, with Jetpack.

    I have found that you have disconnected two hours ago, did you do that to resolve the error? I’d suggest reinstalling and reaching out to your hosting provider, to have them resolve the issue with your XML-RPC endpoint (which is needs to be accessible and working, just as the example here).

    Let us know how this goes.

    Thread Starter darrenseuk

    (@darrenseuk)

    Hi Mehdi

    Thank you for coming back to me regarding this.

    Yes, we have been tracking an issue that happens around lunchtime with timeouts and as this error was appearing in the logs, we were going through our plugins and testing them to see if turning them off would resolve the issue.

    I had turned off the plugin today to test if this would resolve the issue but the problem continued. I have now re-activate the Jetpack plugin and reconnected. I did see that your user connection process is impacted by the WPO365 plugin we have installed, turning that off while we connect resolved the issue. You may know a fix for that issue but it is not urgent.

    I will leave the website as it is for tonight and check tomorrow on progress. Could restarting the plugin have resolved this issue?

    Any help you can offer, would be greatly appreciated.

    Kind regards

    Darren

    Thread Starter darrenseuk

    (@darrenseuk)

    I think restarting and reconnecting may have fixed the issue, we would usually get a minimum of 5 an hour and there have been none since turning the plugin back on.

    Can you confirm that everything is connected correctly from your side?

    Plugin Contributor Stef (a11n)

    (@erania-pinnera)

    Hi there, @darrenseuk,

    Thanks for the multiple follow-ups to keep us posted on your testing.

    I checked the Jetpack connection, and it seems to be connecting okay. However, I found out two issues:

    • There is still some cache discrepancies that might affect the way the data are handled between your site and our servers: I launched a new sync job which hopefully will fix that in 24 hours time
    • I noticed that API Output still returns a 403 error: that could be caused by another block on the server’s end. Can you double-check for me that our IPs range is fully allow listed?Also, check for any security/caching plugins you may have enabled, and try temporarily disabling them to see if it fixes the problem. You may also want to search for any firewall on your server-side that might be blocking the communication with the Jetpack – your host should be able to help you with that.

    While you work on the above, please keep a close eye on the query logs in case you spot any other errors or issues. Let’s see how it goes, and we’ll take it from there if necessary. Thanks for sorting this out with us!

    Plugin Contributor Stef (a11n)

    (@erania-pinnera)

    Hi there,?@darrenseuk,

    Do you have updates about that? We usually close inactive threads after one week of no movement, but we want to make sure we’re all set before marking it as solved. Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘KILLED QUERY in logs over and over again’ is closed to new replies.