Podrška » Problemi » 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:20G

    This 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.8GB

    Shop 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.

Pregledavate odgovor 1 (od ukupno 1)
  • Thread Starter dejandu

    (@dejandu)

    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 FROM wp_actionscheduler_logs WHERE action_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 FROM wp_actionscheduler_logs WHERE action_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 FROM wp_actionscheduler_logs WHERE action_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 FROM wp_actionscheduler_logs WHERE action_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 FROM wp_actionscheduler_logs WHERE action_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 FROM wp_actionscheduler_logs WHERE action_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 FROM wp_actionscheduler_logs WHERE action_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 FROM wp_actionscheduler_logs WHERE action_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 FROM wp_actionscheduler_logs WHERE action_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 FROM wp_actionscheduler_logs WHERE action_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 FROM wp_actionscheduler_logs WHERE action_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 FROM wp_actionscheduler_logs WHERE action_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

Pregledavate odgovor 1 (od ukupno 1)
  • Tema ‘WP-admin’ je zaključana zbog novih odgovora.