{"id":19021264,"date":"2026-09-16T07:13:03","date_gmt":"2026-09-16T07:13:03","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/deadlock-issue\/"},"modified":"2026-09-16T07:13:30","modified_gmt":"2026-09-16T07:13:30","slug":"deadlock-issue","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/deadlock-issue\/","title":{"rendered":"Deadlock issue"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hi after latest update to 4.9.0 I observe regular issues with deadlocks:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM XXX_postmeta WHERE post_id = 1 AND meta_key = 'wpdesk_migration_XXXXXXXXXXXXXXXXXXX' AND CAST(CASE WHEN LOCATE('|', meta_value) &gt; 0 THEN SUBSTRING_INDEX(meta_value, '|', -1) ELSE SUBSTRING_INDEX(meta_value, '_', -1) END AS UNSIGNED) &lt; UNIX_TIMESTAMP() made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, WPDesk\\ShopMagic\\Plugin-&gt;WPDesk\\ShopMagic\\{closure}, do_action('shopmagic\/core\/initialized\/v2'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, WPDesk\\ShopMagicCart\\Plugin-&gt;WPDesk\\ShopMagicCart\\{closure}, ShopMagicVendor\\WPDesk\\Migrations\\WpdbMigrator-&gt;migrate, ShopMagicVendor\\WPDesk\\Mutex\\WordpressPostLease-&gt;acquireLock, ShopMagicVendor\\WPDesk\\Mutex\\WordpressPostLease-&gt;deleteExpiredLocks<br \/><br \/><br \/>PHP Fatal error:  Uncaught ShopMagicVendor\\WPDesk\\Mutex\\MutexException: Unable to clean expired post leases. Deadlock found when trying to get lock; try restarting transaction in \/XXX\/public_html\/wp-content\/plugins\/shopmagic-for-woocommerce\/vendor_prefixed\/wpdesk\/wp-mutex\/src\/WPDesk\/Mutex\/WordpressPostLease.php:158<\/code><\/pre>\n","protected":false},"template":"","class_list":["post-19021264","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/19021264","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/19021264\/revisions"}],"predecessor-version":[{"id":19021265,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/19021264\/revisions\/19021265"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=19021264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}