1

I am importing Customer Main file details, I imported 30,000 records and about to reindexing ended up with reindexing issue.

On the first reindexing I got the following error:

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 291

So i increased memory limit in my php.ini file from 512M to 2024M.

I also fee up the space in my disk but nothing works.

Any help would be appreciated.

Improve this question
4
  • are you re indexing from CLI ?
    – Pawan
    Commented Feb 3, 2019 at 8:12
  • Yes, I am indexing from CLI.
    – Amy
    Commented Feb 4, 2019 at 5:54
  • Try php dmemory_limit=5g bin/magento indexer:reindex your indexer name
    – Pawan
    Commented Feb 4, 2019 at 11:41
  • have you tried command I shared ?
    – Pawan
    Commented Feb 7, 2019 at 4:25

1 Answer 1

Reset to default
2

Please try Get indexes info

php bin/magento indexer:info

Check the indexes status

php bin/magento indexer:status

Reset all indexes and reindex again

php bin/magento indexer:reset
php bin/magento indexer:reindex

Or reset just customer grid and reindex again

php bin/magento indexer:reset customer_grid
php bin/magento indexer:reindex customer_grid
Improve this answer
2
  • I have tried this, Its not working. Now I have increased the disk space and also the info.php shows 2024M. Is there any other thing I need to check.
    – Amy
    Commented Feb 5, 2019 at 10:14
  • maybe is another php version used for the cli. Please try php -d memory_limit=2G bin/magento indexer:reindex
    – Nikolas
    Commented Feb 5, 2019 at 10:29

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.