Unable to update database 6.6.1 -> 6.9.2
-
There’s a lot to unpack because I’ve been dealing with this issue for a few weeks. Just like @wpuser1234 at https://www.ads-software.com/support/topic/unable-to-update-database-6-6-1-6-7/ — I’ve tried all the various “solutions” like deleting the transients, expired transients, solving various other small issues with plugins, running the database update from the top notification, and from WooCommerce tools directly, etc.
Despite all that, here’s where I am now:
1) I have verified with the hosting company (LiquidWeb/Nexcess) that the WP-CRON is running correctly and accurately, every 5 minutes.
2) I have manually triggered the database update in WooCommerce Tools multiple times. The woocommerce_db_version option in wp_options, still says 6.6.1
3) Clicking on the “Update database” option, created 5 (sometimes 6) new “pending” items that never go away. I currently have 924 pending entries.
4) I’ve put in a ticket at Nexcess to get help (pretty much worthless as they keep referring me to WooCommerce) which I am including the content of below as I see no way to include the TXT file I put together for you.In the video I did for Nexcess (https://www.screencast.com/t/QYdZIZfix49J) I stated I didn’t believe the CRON jobs are running, and they’ve sent verified they are. I now suspect that CRON is failing, even though nothing is showing up in the logs about that failure.
ANY HELP you can provide would be great appreciated. Again, I can’t find where to insert my system report, but I stand ready to send that if you can tell me how.
THEIR “RESOLUTION” TO THE TICKET ENDED WITH:
This issue seems to be that Woocommerce is stuck updating the database, until that process completes or is successful.Cenay’
————[ Transcript of support with Nexcess including my videos showing the issue
Ticket: 11075368
CRON Jobs don’t appear to be running correctlyUntil the WooCommerce database update completes, it will keep on displaying them as pending. This is why they are showing as pending.
WooCommerce database update
WooCommerce is updating the database in the background. The database update process may take a little while, so please be patient. View progress →Reviewing your WordPress cron, we are showing jobs are being scheduled.
+————————————————-+———————+———————–+—————+
| hook | next_run_gmt | next_run_relative | recurrence |
+————————————————-+———————+———————–+—————+
| action_scheduler_run_queue | 2022-09-28 01:09:15 | now | 1 minute |
| learndash_woocommerce_cron | 2022-09-28 01:09:25 | now | 1 minute |
| gravityforms_cron | 2022-09-28 01:10:03 | 29 seconds | 1 day |
| nfsecupdates | 2022-09-28 01:15:21 | 5 minutes 47 seconds | 30 minutes |
| rediscache_discard_metrics | 2022-09-28 01:43:16 | 33 minutes 42 seconds | 1 hour |
| nfwgccron | 2022-09-28 01:45:06 | 35 minutes 32 seconds | 1 hour |
| cache_enabler_clear_expired_cache | 2022-09-28 01:45:48 | 36 minutes 14 seconds | 1 hour |
| wc_admin_process_orders_milestone | 2022-09-28 01:52:16 | 42 minutes 42 seconds | 1 hour |
| ip2location_country_blocker_hourly_event | 2022-09-28 01:59:42 | 50 minutes 8 seconds | 1 hour |
| wp_privacy_delete_old_export_files | 2022-09-28 02:01:00 | 51 minutes 26 seconds | 1 hour |
| wc_admin_unsnooze_admin_notes | 2022-09-28 02:03:09 | 53 minutes 35 seconds | 1 hour |
| backupbuddy_cron | 2022-09-28 03:19:00 | 2 hours 9 minutes | 1 day |
| backupbuddy_cron | 2022-09-28 03:29:00 | 2 hours 19 minutes | 1 day |
| learndash_notifications_cron | 2022-09-28 04:00:24 | 2 hours 50 minutes | 12 hours |
| cptch_call_twicedaily_action_hook | 2022-09-28 04:02:14 | 2 hours 52 minutes | 12 hours |
| wp_update_user_counts | 2022-09-28 04:20:36 | 3 hours 11 minutes | 12 hours |
| antispam_bee_daily_cronjob | 2022-09-28 05:33:23 | 4 hours 23 minutes | 1 day |
| updraft_backup | 2022-09-28 05:55:00 | 4 hours 45 minutes | 12 hours |
| updraft_backup_database | 2022-09-28 05:55:00 | 4 hours 45 minutes | 12 hours |
| fs_data_sync_erropix-hydrogen-pack | 2022-09-28 06:44:19 | 5 hours 34 minutes | 1 day |
| wp_version_check | 2022-09-28 06:54:10 | 5 hours 44 minutes | 12 hours |
| wp_update_plugins | 2022-09-28 06:54:10 | 5 hours 44 minutes | 12 hours |
| wp_update_themes | 2022-09-28 06:54:10 | 5 hours 44 minutes | 12 hours |
| woocommerce_scheduled_sales | 2022-09-28 07:00:00 | 5 hours 50 minutes | 1 day |
| nfdailyreport | 2022-09-28 07:00:05 | 5 hours 50 minutes | 1 day |
| check_plugin_updates-woo-product-bundle-premium | 2022-09-28 08:10:43 | 7 hours 1 minute | 12 hours |
| wp_https_detection | 2022-09-28 08:16:40 | 7 hours 7 minutes | 12 hours |
| pm_request_lighthouse_reports | 2022-09-28 08:27:18 | 7 hours 17 minutes | 1 day |
| sync_all_fb_products_using_feed | 2022-09-28 08:37:00 | 7 hours 27 minutes | 1 day |
| woocommerce_cleanup_sessions | 2022-09-28 11:09:14 | 9 hours 59 minutes | 12 hours |
| backwpup_check_cleanup | 2022-09-28 11:14:54 | 10 hours 5 minutes | 12 hours |
| gform_userregistration_cron | 2022-09-28 12:11:22 | 11 hours 1 minute | 12 hours |
| puc_cron_check_updates-wpcodebox | 2022-09-28 12:49:44 | 11 hours 40 minutes | 12 hours |
| wp_mainwp_stream_auto_purge | 2022-09-28 12:53:04 | 11 hours 43 minutes | 12 hours |
| recovery_mode_clean_expired_keys | 2022-09-28 15:26:33 | 14 hours 16 minutes | 1 day |
| woocommerce_cleanup_personal_data | 2022-09-28 17:09:24 | 15 hours 59 minutes | 1 day |
| woocommerce_tracker_send_event | 2022-09-28 17:09:24 | 15 hours 59 minutes | 1 day |
| wordfence_daily_cron | 2022-09-28 17:46:22 | 16 hours 36 minutes | 1 day |
| check_plugin_updates-updraftplus | 2022-09-28 18:06:39 | 16 hours 57 minutes | 1 day |
| nexcess_mapps_daily_maintenance | 2022-09-28 18:09:48 | 17 hours | 1 day |
| wpseo-reindex-links | 2022-09-28 18:16:38 | 17 hours 7 minutes | 1 day |
| wp_scheduled_delete | 2022-09-28 18:54:22 | 17 hours 44 minutes | 1 day |
| fs_data_sync_erropix-hydrogen-pack | 2022-09-28 18:54:57 | 17 hours 45 minutes | 1 day |
| backupbuddy_cron | 2022-09-28 19:01:19 | 17 hours 51 minutes | 1 day |
| backupbuddy_cron | 2022-09-28 19:01:44 | 17 hours 52 minutes | 1 day |
| wp_scheduled_auto_draft_delete | 2022-09-28 19:39:01 | 18 hours 29 minutes | 1 day |
| woocommerce_cleanup_logs | 2022-09-28 20:09:14 | 18 hours 59 minutes | 1 day |
| woocommerce_cleanup_rate_limits | 2022-09-28 20:09:14 | 18 hours 59 minutes | 1 day |
| delete_expired_transients | 2022-09-28 20:35:20 | 19 hours 25 minutes | 1 day |
| wc_admin_daily | 2022-09-28 20:35:23 | 19 hours 25 minutes | 1 day |
| akismet_scheduled_delete | 2022-09-28 20:41:08 | 19 hours 31 minutes | 1 day |
| tribe_common_log_cleanup | 2022-09-28 21:29:49 | 20 hours 20 minutes | 1 day |
| wpseo_permalink_structure_check | 2022-09-28 21:35:28 | 20 hours 25 minutes | 1 day |
| wpseo-premium-prominent-words-recalculate | 2022-09-28 21:42:02 | 20 hours 32 minutes | 1 day |
| wpseo-reindex | 2022-09-28 21:43:08 | 20 hours 33 minutes | 1 day |
| backupbuddy_cron | 2022-09-28 22:27:00 | 21 hours 17 minutes | 1 day |
| analytify_cleanup_logs | 2022-09-28 23:34:19 | 22 hours 24 minutes | 1 day |
| nexcess_mapps_usage_tracking | 2022-09-28 23:41:48 | 22 hours 32 minutes | 1 day |
| cc_woo_check_expired_carts | 2022-09-29 00:00:00 | 22 hours 50 minutes | 1 day |
| wp_site_health_scheduled_check | 2022-09-29 16:55:02 | 1 day 15 hours | 1 week |
| nexcess_mapps_weekly_maintenance | 2022-10-03 18:34:48 | 5 days 17 hours | 1 week |
| woo_product_slider_pro_weekly_scheduled_events | 2022-10-03 20:04:11 | 5 days 18 hours | 1 week |
| wcdn_ts_tracker_send_event | 2022-10-04 02:57:50 | 6 days 1 hour | 1 week |
| woocommerce_geoip_updater | 2022-10-06 17:10:14 | 1 week 1 day | 2 weeks 1 day |
| backwpup_cron | 2022-10-20 10:00:00 | 3 weeks 1 day | Non-repeating |
| 1441563194 | | now | Non-repeating |
| 1441563196 | | now | Non-repeating |
| 1441563197 | | now | Non-repeating |
| 1441563207 | | now | Non-repeating |
| 1441563209 | | now | Non-repeating |
| 1441563211 | | now | Non-repeating |
| 1441563271 | | now | Non-repeating |
+————————————————-+———————+———————–+—————+This issue seems to be that Woocommerce is stuck updating the database, until that process completes or is successful. You will continue to see jobs that need to be manually updated.
Thank you.
—————————–
Matthew McGehrin
Sep 27, 2022 5:36 PM
Hello.We are looking into this issue and I will provide an update once we have finished.
Thank you.
Matthew
ref:_00D30pmDy._5003a1Hi8Q3:ref——————————-
Eric Brotman – [email protected]
Sep 27, 2022 12:40 PM
FYI, still no email delivered to me to let me know there was an update.Recorded what the results were, and the fact that the “jobs” still are not running. See this video for my ongoing issues: https://www.screencast.com/t/UI2Di2Z93L
Adding myself as a watcher AGAIN, please cc [email protected]
——————————-
Alex Freeman
Sep 24, 2022 1:17 AM
Hello,Reviewing it appears that the email address [email protected] was not CC to this ticket, however we have ensured that the email address was added to this support ticket case.
Reviewing the server cron logs we can see that the cron is triggering every five minutes and the cron appears to be configured correctly:
2022-09-24T07:10:01.484952+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[22781]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)
2022-09-24T07:15:01.630361+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[29371]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)
2022-09-24T07:20:01.423963+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[28059]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)
2022-09-24T07:25:02.271604+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[1487]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)
2022-09-24T07:30:01.724413+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[32616]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)
2022-09-24T07:35:02.240556+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[10117]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)
2022-09-24T07:40:01.766612+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[12471]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)
2022-09-24T07:45:01.326645+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[18135]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)
2022-09-24T07:50:01.625984+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[16765]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)
2022-09-24T07:55:01.910499+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[22617]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)
2022-09-24T08:00:02.216320+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[21741]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)
2022-09-24T08:05:01.544080+00:00 cloudhost-4388380.us-midwest-2.nxcli.net CROND[31076]: (a663432f) CMD (/usr/sbin/relax php -f /chroot/home/a663432f/0c9b26f528.nxcli.net/html/wp-cron.php)
Has the mentioned 8 old cron jobs have not ran and where is this being seen ( Admin Panel )?
Since the cron was previously updated are the cron jobs now running normally?
Please let us know if we can be of any further assistance.
——————————-
Eric Brotman – [email protected]
Sep 22, 2022 2:03 PM
Thanks for checking. Just FYI, even though I requested notifications to my email address ([email protected]) not a single email has been received. Yes, checked SPAM. I have special filters that allow support tickets from designated providers through.Having said that, I checked and I still have 8 jobs more than 24 hours old that haven’t run yet.
——————————-
Arunlal Ravindran
Sep 22, 2022 11:39 AM
Hello,We have updated the cron job now. Could you please check the same? and let us know the result.
Regards,
Arunlal Ravindran
——————————-
Arunlal Ravindran
Sep 22, 2022 11:15 AM
Hello,Thank you for contacting support.
My name is Arunlal, and I have taken over your case. Please allow me some time to look into your request and I will have an update for you as soon as possible.
Regards,
Arunlal Ravindran
——————————-
Sep 21, 2022 12:09 PM
Cenay here, with another question (webmaster for Eric Brotman)I don’t believe the WordPress CRON jobs are running correctly since the migration from LiquidWeb to Nexcess. Please see this video for my issues and concerns.
Thanks in advance for any help you can provide. Please ensure you include me on the email chain so I get a notification of the reply.`
The page I need help with: [log in to see the link]
- The topic ‘Unable to update database 6.6.1 -> 6.9.2’ is closed to new replies.