{"id":16118408,"date":"2022-10-20T12:44:27","date_gmt":"2022-10-20T12:44:27","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/errors-291\/"},"modified":"2022-10-20T13:46:51","modified_gmt":"2022-10-20T13:46:51","slug":"errors-291","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/errors-291\/","title":{"rendered":"Errors"},"content":{"rendered":"<p>Hello,<\/p>\n<p>The last few days i notices a lot of errors on my debug log and started investigating:<br \/>\n1) I have Pending (1311914)  Scheduled Actions<br \/>\n2) I get this error all the time and i dont know what to do  every 1-2 minutes:<\/p>\n<pre><code>[20-Oct-2022 12:38:10 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query UPDATE wp_actionscheduler_actions SET attempts = attempts+1, status=&#039;in-progress&#039;, last_attempt_gmt = &#039;2022-10-20 12:38:10&#039;, last_attempt_local = &#039;2022-10-20 15:38:10&#039; WHERE action_id = 1676943 made by do_action(&#039;wp_ajax_as_async_request_queue_runner&#039;), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, WP_Async_Request-&gt;maybe_handle, ActionScheduler_AsyncRequest_QueueRunner-&gt;handle, do_action(&#039;action_scheduler_run_queue&#039;), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, ActionScheduler_QueueRunner-&gt;run, ActionScheduler_QueueRunner-&gt;do_batch, ActionScheduler_Abstract_QueueRunner-&gt;process_action, ActionScheduler_HybridStore-&gt;log_execution, ActionScheduler_DBStore-&gt;log_execution\n<\/code><\/pre>\n<pre><code>\n[20-Oct-2022 12:36:21 UTC] PHP Fatal error:  Uncaught RuntimeException: Unable to claim actions. Database error. in \/home\/____\/public_html\/wp-content\/plugins\/woocommerce\/packages\/action-scheduler\/classes\/data-stores\/ActionScheduler_DBStore.php:683\nStack trace:\n#0 \/home\/____\/public_html\/wp-content\/plugins\/woocommerce\/packages\/action-scheduler\/classes\/data-stores\/ActionScheduler_DBStore.php(597): ActionScheduler_DBStore-&gt;claim_actions(1294617, 25, NULL, Array, &#039;&#039;)\n#1 \/home\/____\/public_html\/wp-content\/plugins\/woocommerce\/packages\/action-scheduler\/classes\/data-stores\/ActionScheduler_HybridStore.php(221): ActionScheduler_DBStore-&gt;stake_claim(25, NULL, Array, &#039;&#039;)\n#2 \/home\/____\/public_html\/wp-content\/plugins\/woocommerce\/packages\/action-scheduler\/classes\/ActionScheduler_QueueRunner.php(153): ActionScheduler_HybridStore-&gt;stake_claim(25)\n#3 \/home\/____\/public_html\/wp-content\/plugins\/woocommerce\/packages\/action-scheduler\/classes\/ActionScheduler_QueueRunner.php(132): ActionScheduler_QueueRunner-&gt;do_batch(25, &#039;Async Request&#039;)\n#4 \/home\/____\/public_ht in \/home\/____\/public_html\/wp-content\/plugins\/woocommerce\/packages\/action-scheduler\/classes\/data-stores\/ActionScheduler_DBStore.php on line 683<\/code><\/pre>\n<p>3) Almost every plug in is not working properly<\/p>\n<p>Below i have the system status:<\/p>\n<pre><code>WordPress environment\nWordPress address (URL):\t\thttps:\/\/____.com\nSite address (URL):\t\thttps:\/\/_____.com\nWooCommerce version:\t\t7.0.0\nWooCommerce REST API package:\t\t 7.0.0 \/home\/____\/public_html\/wp-content\/plugins\/woocommerce\/includes\nWooCommerce Blocks package:\t\t 8.5.1 \/home\/____\/public_html\/wp-content\/plugins\/woocommerce\/packages\/woocommerce-blocks\/\nAction Scheduler package:\t\t 3.4.0 \/home\/___\/public_html\/wp-content\/plugins\/woocommerce\/packages\/action-scheduler\nLog directory writable:\t\t \/home\/___\/public_html\/wp-content\/uploads\/wc-logs\/\nWordPress version:\t\t6.0.3\nWordPress multisite:\t\t\u2013\nWordPress memory limit:\t\t2 GB\nWordPress debug mode:\t\t\nWordPress cron:\t\t\nLanguage:\t\ten_US\nExternal object cache:\t\t\u2013\nServer environment\nServer info:\t\tApache\nPHP version:\t\t7.4.32\nPHP post max size:\t\t50 MB\nPHP time limit:\t\t180\nPHP max input vars:\t\t10000\ncURL version:\t\t7.85.0, OpenSSL\/1.1.1q\nSUHOSIN installed:\t\t\u2013\nMySQL version:\t\t5.5.5-10.3.36-MariaDB\nMax upload size:\t\t50 MB\nDefault timezone is UTC:\t\t\nfsockopen\/cURL:\t\t\nSoapClient:\t\t\nDOMDocument:\t\t\nGZip:\t\t\nMultibyte string:\t\t\nRemote post:\t\t\nRemote get:\t\t<\/code><\/pre>\n<p>I have no idea what is happening&#8230;<br \/>\nI disabled a few plugins and the Pending  Scheduled Actions have started to reduce.<br \/>\nBut the database errors keep coming<\/p>\n","protected":false},"template":"","class_list":["post-16118408","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16118408","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":2,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16118408\/revisions"}],"predecessor-version":[{"id":16118426,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16118408\/revisions\/16118426"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=16118408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}