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.

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

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
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
    Feb 5 '19 at 10:14
  • maybe is another php version used for the cli. Please try php -d memory_limit=2G bin/magento indexer:reindex
    – Nikolas
    Feb 5 '19 at 10:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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