WP-admin
-
Saving variable products in woocommerce takes up 30 seconds. In this test the only thing I changed was changing quantity of product of 1 variation.
Here is example: https://drive.google.com/…/1FcOg72zRVYLKFbci7ooGvQ8cP…/view…
So far we have tried:
– Upgrade all plugins
– Upgrade woocommerce and wordpress
– Disable all plugins (one by one) and theme
– Optimize/Repair SQL database
– edit SQL max conncurent connections
– change innodb_temp_data_file_path = ibtmp1:64M:autoextend:max:20GThis problem disappeared only when we Turn on maintenance mode in wordpress. . Then saving variable products works fast.
Server specifications:
php 7.3
MariaDB 10.3
Database size: 2.8GBShop info:
The shop holds about 2000 different products and 110 000 orders in base. Everything works perfectly (frontend+backend) except when it needs to be saved variable products.
-
Debug log.
`[19-Jul-2020 20:30:06 UTC] Greška u bazi WordPressa Server shutdown in progress za upit SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (295338,295339,307971,307973) ORDER BY meta_id ASC koji je postavio/la require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/woocommerce/templates/taxonomy-product_cat.php’), wc_get_template, include(‘/themes/vayne/woocommerce/archive-product.php’), wc_get_template_part, load_template, require(‘/themes/vayne/woocommerce/content-product.php’), do_action(‘woocommerce_after_shop_loop_item_title’), WP_Hook->do_action, WP_Hook->apply_filters, woocommerce_template_loop_price, wc_get_template, include(‘/plugins/woocommerce/templates/loop/price.php’), WC_Product_Variable->get_price_html, apply_filters(‘woocommerce_get_price_html’), WP_Hook->apply_filters, Tiwc_Prices->get_price_html, WC_Product_Variable->get_available_variations, _prime_post_caches, update_post_caches, update_postmeta_cache, update_meta_cache
[19-Jul-2020 20:30:06 UTC] PHP Warning: Error while sending QUERY packet. PID=19571 in /home/tivana5/public_html/wp-includes/wp-db.php on line 2024
[19-Jul-2020 20:30:07 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:07 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:07 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:07 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:07 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:07 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:07 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:07 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:07 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:07 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:07 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:07 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:08 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:08 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:08 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:08 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:08 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:08 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:08 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:08 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:08 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:09 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:09 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:09 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:09 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:09 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:09 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:09 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:30:09 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/tivana5/public_html/wp-includes/wp-db.php on line 1626
[19-Jul-2020 20:31:52 UTC] Greška u bazi WordPressa Index wp_actionscheduler_logs is corrupted za upit DELETE FROMwp_actionscheduler_logs
WHEREaction_id
= 302898 koji je postavio/la do_action(‘wp_ajax_as_async_request_queue_runner’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_DBStore->delete_action, do_action(‘action_scheduler_deleted_action’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_DBLogger->clear_deleted_action_logs
[19-Jul-2020 20:31:52 UTC] Greška u bazi WordPressa Index wp_actionscheduler_logs is corrupted za upit DELETE FROMwp_actionscheduler_logs
WHEREaction_id
= 302895 koji je postavio/la do_action(‘wp_ajax_as_async_request_queue_runner’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_DBStore->delete_action, do_action(‘action_scheduler_deleted_action’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_DBLogger->clear_deleted_action_logs
[19-Jul-2020 20:33:40 UTC] PHP Notice: Undefined property: WP_Error::$term_id in /home/tivana5/public_html/wp-content/plugins/facebook-for-woocommerce/includes/AJAX.php on line 114
[19-Jul-2020 20:35:23 UTC] PHP Notice: Undefined property: WP_Error::$term_id in /home/tivana5/public_html/wp-content/plugins/facebook-for-woocommerce/includes/AJAX.php on line 114
[19-Jul-2020 20:36:25 UTC] PHP Notice: Undefined variable: errorState in /home/tivana5/public_html/wp-content/plugins/woo-blocker-lite-prevent-fake-orders-and-blacklist-fraud-customers/public/class-woocommerce-blocker-prevent-fake-orders-and-blacklist-fraud-customers-public.php on line 161
[19-Jul-2020 20:37:40 UTC] Greška u bazi WordPressa Index wp_actionscheduler_logs is corrupted za upit DELETE FROMwp_actionscheduler_logs
WHEREaction_id
= 302900 koji je postavio/la do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_HybridStore->delete_action, ActionScheduler_DBStore->delete_action, do_action(‘action_scheduler_deleted_action’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_DBLogger->clear_deleted_action_logs
[19-Jul-2020 20:40:30 UTC] Greška u bazi WordPressa Index wp_actionscheduler_logs is corrupted za upit DELETE FROMwp_actionscheduler_logs
WHEREaction_id
= 302901 koji je postavio/la do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_DBStore->delete_action, do_action(‘action_scheduler_deleted_action’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_DBLogger->clear_deleted_action_logs
[19-Jul-2020 20:42:30 UTC] Greška u bazi WordPressa Index wp_actionscheduler_logs is corrupted za upit DELETE FROMwp_actionscheduler_logs
WHEREaction_id
= 302902 koji je postavio/la do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_DBStore->delete_action, do_action(‘action_scheduler_deleted_action’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_DBLogger->clear_deleted_action_logs
[19-Jul-2020 20:42:30 UTC] Greška u bazi WordPressa Index wp_actionscheduler_logs is corrupted za upit DELETE FROMwp_actionscheduler_logs
WHEREaction_id
= 302897 koji je postavio/la do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_DBStore->delete_action, do_action(‘action_scheduler_deleted_action’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_DBLogger->clear_deleted_action_logs
[19-Jul-2020 20:47:01 UTC] Greška u bazi WordPressa Index wp_actionscheduler_logs is corrupted za upit DELETE FROMwp_actionscheduler_logs
WHEREaction_id
= 302899 koji je postavio/la do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_DBStore->delete_action, do_action(‘action_scheduler_deleted_action’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_DBLogger->clear_deleted_action_logs
[19-Jul-2020 20:47:30 UTC] Greška u bazi WordPressa Index wp_actionscheduler_logs is corrupted za upit DELETE FROMwp_actionscheduler_logs
WHEREaction_id
= 302904 koji je postavio/la do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_DBStore->delete_action, do_action(‘action_scheduler_deleted_action’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_DBLogger->clear_deleted_action_logs
[19-Jul-2020 20:47:30 UTC] Greška u bazi WordPressa Index wp_actionscheduler_logs is corrupted za upit DELETE FROMwp_actionscheduler_logs
WHEREaction_id
= 302905 koji je postavio/la do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_DBStore->delete_action, do_action(‘action_scheduler_deleted_action’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_DBLogger->clear_deleted_action_logs
[19-Jul-2020 20:49:26 UTC] Greška u bazi WordPressa Index wp_actionscheduler_logs is corrupted za upit DELETE FROMwp_actionscheduler_logs
WHEREaction_id
= 302907 koji je postavio/la do_action(‘wp_ajax_as_async_request_queue_runner’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_DBStore->delete_action, do_action(‘action_scheduler_deleted_action’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_DBLogger->clear_deleted_action_logs
[19-Jul-2020 20:49:26 UTC] Greška u bazi WordPressa Index wp_actionscheduler_logs is corrupted za upit DELETE FROMwp_actionscheduler_logs
WHEREaction_id
= 302908 koji je postavio/la do_action(‘wp_ajax_as_async_request_queue_runner’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_DBStore->delete_action, do_action(‘action_scheduler_deleted_action’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_DBLogger->clear_deleted_action_logs
[19-Jul-2020 20:52:30 UTC] Greška u bazi WordPressa Index wp_actionscheduler_logs is corrupted za upit DELETE FROMwp_actionscheduler_logs
WHEREaction_id
= 302909 koji je postavio/la do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_DBStore->delete_action, do_action(‘action_scheduler_deleted_action’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_DBLogger->clear_deleted_action_logs
- Tema ‘WP-admin’ je zaključana zbog novih odgovora.