How can I do this problem as the title?

enter image description here

When I finish all of the settings of google feed setup by Amasty Feed and try to generate it but it turns as above picture. I went to Index Management and check all of the statuses are ready. Someone also told me to let the Amasty Feed update on save but it still didn't work. Is there anyone who has the same problem and solved it?

Hope to get the answer. Regards, Tess

  • Did you figure it out?
    – Sondre
    Feb 24, 2020 at 9:55

1 Answer 1


Found out a few things: It seems during product indexing the amasty_feed_valid_products gets cleaned up. This causes the error we see in the backend because each iteration queries the table like this:

select * from amasty_feed_valid_products where feed_id=75 limit 2000,500

If the result is empty, because the indexer is just in progress of updating the table, the error will be thrown.

However, the Amasty Feed module supports a lock for the indexer. But that doesn't seem to be effective as the AJAX request will release the lock and the small time between the response and then new request from the browser seem to be enough to cause an error.

The cronjob shouldn't be effected by that. But the locking provider in env.php is maybe not effective. Maybe try to use database as locking provider:

  array (
    'provider' => 'db',
    'config' =>
    array (
      'prefix' => null

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.