map refresh crashed

1
Hello

I tried repeatedly to make a refresh map for my service but it does not work

it crashes after 5%

412042020-02-03 11: 05Map Refresh193.70.81.39: 23015The process crashed.5.00%
411852020-02-03 02: 32Map Refresh193.70.81.39: 23015The process crashed.5.00%
411832020-02-03 02: 29Map Refresh193.70.81.39: 23015The process crashed.5.00%
411822020-02-03 02: 27Map Refresh193.70.81.39: 23015The process crashed.5.00%
411812020-02-03 02: 20Map Refresh193.70.81.39: 23015The process crashed.5.00%
411802020-02-03 02: 16Map Refresh193.70.81.39: 23015The process crashed.22.00%

you would tell me what's going on .....

thank you so much

Re: map refresh crashed

2
Hi,
the 5% is crashes are caused by the first crashed job. To resolve this, you need to run this query in your database:

Code: Select all

ALTER TABLE geo_patch DROP INDEX GeoIndex;

I don't know what exactly caused the first crash. Error message hints to high activity in the database that conflicted with the delete operations issued by the refresh script.
cron