Woocommerce error with huge DB and error Log file
-
Hey,
Quite some time, I am facing with huge problem after I had crash with my site, while updating WooCommerce. It came a lot of problems which we were able to fix, but one additional remained and no one has proposition or solution, since we try everything that could cross our mind.
Our database in table wp_actionscheduler_logs is growing every second, and in 24 hours it’s around 15-20 millions logs of WP Cron Jobs errors, with size of 1.7-2.0GB each day. Beside that, in /home/domain/logs there is file domain_com.php.error.log which is exponentionaly growing around 3-4GB every 24 hours…
Anyone facesd similar issue?
Thanks in advance.
The page I need help with: [log in to see the link]
-
Hi,
I’ve gone through the Test for Conflicts, when WooCommerce is active, the problem is present, as soon as WooCommerce is deactivated, there is no problem.
Edit:
I’ve found that W3 Total Cache is causing the problem with host/logs error file, by keeping it deactivated, there is no more problems with growth of that file, it did created only 5 rows as below. The database is growing action_scheduler_log while WooCommerce is active.text/plain ferro-pack_com.php.error.log ( ASCII text, with very long lines ) [29-Dec-2021 15:46:30 UTC] WordPress database error Can't DROP INDEX <code>PRIMARY</code>; check that it exists for query ALTER TABLE <code>wp_woocommerce_sessions</code> DROP PRIMARY KEY, DROP KEY <code>session_id</code>, ADD PRIMARY KEY(<code>session_id</code>), ADD UNIQUE KEY(<code>session_key</code>) made by activate_plugin, do_action('activate_woocommerce/woocommerce.php'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_tables [29-Dec-2021 15:46:30 UTC] WordPress database error Incorrect table definition; there can be only one auto column and it must be defined as a key for query ALTER TABLE wp_woocommerce_sessions CHANGE COLUMN <code>session_id</code> session_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT made by activate_plugin, do_action('activate_woocommerce/woocommerce.php'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_tables, dbDelta [29-Dec-2021 15:46:30 UTC] WordPress database error Duplicate entry '0' for key 'PRIMARY' for query ALTER TABLE wp_woocommerce_sessions ADD PRIMARY KEY (<code>session_id</code>) made by activate_plugin, do_action('activate_woocommerce/woocommerce.php'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_tables, dbDelta [29-Dec-2021 15:46:31 UTC] WordPress database error Duplicate entry '0' for key 'PRIMARY' for query INSERT INTO <code>wp_actionscheduler_groups</code> (<code>slug</code>) VALUES ('action-scheduler-migration') made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_schedule_single_action, ActionScheduler_ActionFactory->single, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->get_group_id, ActionScheduler_DBStore->create_group [29-Dec-2021 15:47:34 UTC] WordPress database error Duplicate entry '0' for key 'PRIMARY' for query INSERT INTO <code>wp_actionscheduler_groups</code> (<code>slug</code>) VALUES ('action-scheduler-migration') made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_schedule_single_action, ActionScheduler_ActionFactory->single, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->get_group_id, ActionScheduler_DBStore->create_group
- The topic ‘Woocommerce error with huge DB and error Log file’ is closed to new replies.
