0

I'm on Magento 2.2.4 with php7. I have a cron job already set that reindexes it all twice a day.

I usually also reindex manually and when i see a suspended index I reset it. But, when I do reindex:status I notice that the "Product Categories" index has always the Schedule status "suspended", even when i reset it and reindex it succefully it never changes. enter image description here

Any idea why, please?

system log shows this:

[2018-10-04 17:25:56] main.WARNING: Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. Please update innodb_buffer_pool_size or decrease batch size value (which decreases memory usages for the temporary table). Current batch size: 1000; Allocated memory size: 50000000 bytes; InnoDB buffer pool size: 134217728 bytes. [] []

debug log shows this:

[2018-10-04 17:27:50] main.DEBUG: cache_invalidate:  {"method":"GET","url":"https://www.example.com/en-ca/catalogsearch/result/index/?cat=23&material_color=114&q=custom&rs_width=150","invalidateInfo":{"tags":["interception","CONFIG"],"mode":"matchingTag"}} []
  • This status appeared because of process terminated due to process killed or any fetal error. you need to see your logs for this why this process terminated without catching any exception. Error logs will help you to debug it. – Hassan Ali Shahzad Oct 4 '18 at 14:54
  • i updated my post... I don't think i can see much in the logs... – Mer Gh Oct 4 '18 at 17:30
0

Reindexing the indexers individually solved my problem; in my case i run: php bin/magento indexer:reindex catalog_product_category

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.