[D H]

Hi – Yes, I would be happy to test the beta version on a test site.

[D H]

Updated to 5.5.3 and the problem still exists..

| cron_csv_import | 2020-04-21 00:22:35 | 11 hours 57 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:22:37 | 11 hours 57 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:22:39 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:22:41 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:22:44 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:22:46 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:22:49 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:22:51 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:22:53 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:22:56 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:22:58 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:00 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:03 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:05 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:08 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:10 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:12 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:15 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:17 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:19 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:22 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:24 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:27 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:29 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:31 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:33 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:36 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:38 | 11 hours 58 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:41 | 11 hours 59 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:43 | 11 hours 59 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:46 | 11 hours 59 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:48 | 11 hours 59 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:50 | 11 hours 59 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:52 | 11 hours 59 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:55 | 11 hours 59 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:57 | 11 hours 59 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:23:59 | 11 hours 59 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:24:02 | 11 hours 59 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:24:05 | 11 hours 59 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:24:07 | 11 hours 59 minutes | 12 hours |
| cron_csv_import | 2020-04-21 00:24:10 | 11 hours 59 minutes | 12 hours |
| wp_site_health_scheduled_check | 2020-04-21 16:44:51 | 1 day 4 hours | 1 week |
+---------------------------------------------------+---------------------+-----------------------+---------------+
~$ wp cron event list | grep -c "cron_csv_import"
122

[D H]

No other cron managers running.  The production site is running on WPEngine. The issue is happening there and in two other test setups on different environments. Furthermore, all the other cron jobs are running fine.

I included the add_message() debug info because every time the cron job fires, that message fills the log and it is marked Fatal then one is Critical.. Both of these would stop the script right? If so, perhaps the cron task cleanup never gets done. So each time the thing start up it spawns a new one..  Maybe?

Either way both these errors are Failures and should be important as they prevent Store Locator Power from doing one of its most important tasks.

We are still getting the multiple cron_csv_import jobs. It got over 100 and I had to delete them all.

 

[D H]

Any progress on this?

 

[D H]

Attached is the csv file..

Using the field “identifier” with our unique ID just as the instruction snippet says. It is not a timestamp; Just an ID number.

Contact Fields is enabled.

Using the field “year_established” (varchar 250)  to store dates.

Attachments:

You must be logged in to view attached files.

[D H]

This is what happens when manually run the scheduled hook..

% wp cron event run cron_csv_import
Notice: Undefined index: added in /slp-power/include/module/locations/SLP_Power_Locations_Import.php on line 806
Notice: Undefined index: record in /slp-power/include/module/locations/SLP_Power_Locations_Import.php on line 645
Fatal error: Uncaught Error: Call to undefined method SLP_Power_Cron::add_message() in /slp-power/include/module/cron/SLP_Power_Cron.php:35
Stack trace:
#0 /slp-power/include/module/cron/SLP_Power_Cron.php(108): SLP_Power_Cron->import_csv('immediate')
#1 wp-includes/class-wp-hook.php(288): SLP_Power_Cron->old_import_locations('import_csv', Array)
#2 wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters('', Array)
#3 wp-includes/plugin.php(544): WP_Hook->do_action(Array)
#4 phar:///usr/local/bin/wp/vendor/wp-cli/cron-command/src/Cron_Event_Command.php(293): do_action_ref_array('cron_csv_import', Array)
#5 phar:///usr/local/bin/wp/vendor/wp-cli/cron-command/src/Cron_Event_Command.php(262): Cron_Event_Command::run_ in /slp-power/include/module/cron/SLP_Power_Cron.php on line 35
Error: There has been a critical error on your website.Learn more about debugging in WordPress. There has been a critical error on your website.
<div class="updated fade">Starting CSV import - duplicates update .</div>
<div class="updated fade">1 data lines read from the CSV file.</div>
<div class="updated fade">1 new locations added.</div>

[Author]

Posts