{"id":33,"date":"2018-12-06T18:35:40","date_gmt":"2018-12-06T17:35:40","guid":{"rendered":"https:\/\/www.generazione2000.com\/lab\/?p=33"},"modified":"2022-01-09T09:44:05","modified_gmt":"2022-01-09T08:44:05","slug":"magento-2-reindex-bloccato-o-allowed-memory-size-of-134217728-bytes-exhausted","status":"publish","type":"post","link":"https:\/\/www.generazione2000.com\/lab\/2018\/12\/06\/magento-2-reindex-bloccato-o-allowed-memory-size-of-134217728-bytes-exhausted\/","title":{"rendered":"Magento 2 reindex bloccato o Allowed memory size of 134217728 bytes exhausted"},"content":{"rendered":"<div class=\"bbp-reply-content\">\n<p>Si \u00e8 verificato l\u2019errore di impossibilit\u00e0 di reindicizzazione che rimaneva appesa, questo da back-end di Magento 2<br \/>\nda linea di comando eseguendo il comando<br \/>\n<code>php bin\/magento indexer:reindex<\/code><br \/>\nsi riceve<\/p>\n<pre><code>Design Config Grid index has been rebuilt successfully in 00:00:00\r\nCustomer Grid index is locked by another reindex process. Skipping.\r\nCategory Products index has been rebuilt successfully in 00:00:01\r\nProduct Categories index has been rebuilt successfully in 00:00:00\r\nProduct Price index has been rebuilt successfully in 00:00:08\r\nProduct EAV index has been rebuilt successfully in 00:00:00\r\nStock index has been rebuilt successfully in 00:00:01\r\nCatalog Rule Product index has been rebuilt successfully in 00:00:00\r\nCatalog Product Rule index has been rebuilt successfully in 00:00:00\r\nCatalog Search index has been rebuilt successfully in 00:00:03<\/code><\/pre>\n<p>eseguendo<br \/>\n<code>php bin\/magento indexer:reset<\/code><br \/>\nsi riceve<\/p>\n<pre><code>Design Config Grid indexer has been invalidated.\r\nCustomer Grid indexer has been invalidated.\r\nCategory Products indexer has been invalidated.\r\nProduct Categories indexer has been invalidated.\r\nProduct Price indexer has been invalidated.\r\nProduct EAV indexer has been invalidated.\r\nStock indexer has been invalidated.\r\nCatalog Rule Product indexer has been invalidated.\r\nCatalog Product Rule indexer has been invalidated.\r\nCatalog Search indexer has been invalidated.<\/code><\/pre>\n<p>eseguendo<br \/>\n<code>php bin\/magento indexer:reindex<\/code><br \/>\nsi riceve<br \/>\n<code>Allowed memory size of 134217728 bytes exhausted (tried to<br \/>\nallocate 667648 bytes) in<br \/>\n\/var\/......\/httpdocs\/vendor\/magento\/zendframework1\/library\/Zend\/Db\/Statement\/Pdo.php<br \/>\n on line 228<\/code><\/p>\n<p>per risolvere il problema<br \/>\neseguire<br \/>\n<code>php bin\/magento indexer:reset<\/code><br \/>\nsi riceve<\/p>\n<pre><code>Design Config Grid indexer has been invalidated.\r\nCustomer Grid indexer has been invalidated.\r\nCategory Products indexer has been invalidated.\r\nProduct Categories indexer has been invalidated.\r\nProduct Price indexer has been invalidated.\r\nProduct EAV indexer has been invalidated.\r\nStock indexer has been invalidated.\r\nCatalog Rule Product indexer has been invalidated.\r\nCatalog Product Rule indexer has been invalidated.\r\nCatalog Search indexer has been invalidated.<\/code><\/pre>\n<p>e poi<br \/>\n<code>php -d memory_limit=-1 bin\/magento indexer:reindex<\/code><\/p>\n<p>dove memory_limit=-1 elimina il massimo della memoria eseguibile e dunque si riesce a portare a termine l\u2019esecuzione del comando.<\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p>c\u2019\u00e8 anche la possibilit\u00e0 di eseguire come root da ssh<br \/>\n<code>service psa restart<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Si \u00e8 verificato l\u2019errore di impossibilit\u00e0 di reindicizzazione che rimaneva appesa, questo da back-end di Magento 2 da linea di comando eseguendo il comando php bin\/magento indexer:reindex si riceve Design Config Grid index has been rebuilt successfully in 00:00:00 Customer Grid index is locked by another reindex process. Skipping. Category Products index has been rebuilt [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[24,25,18,23],"class_list":["post-33","post","type-post","status-publish","format-standard","hentry","category-magento","tag-allowed-memory-size","tag-exhausted","tag-magento","tag-reindex"],"_links":{"self":[{"href":"https:\/\/www.generazione2000.com\/lab\/wp-json\/wp\/v2\/posts\/33","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.generazione2000.com\/lab\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.generazione2000.com\/lab\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.generazione2000.com\/lab\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.generazione2000.com\/lab\/wp-json\/wp\/v2\/comments?post=33"}],"version-history":[{"count":1,"href":"https:\/\/www.generazione2000.com\/lab\/wp-json\/wp\/v2\/posts\/33\/revisions"}],"predecessor-version":[{"id":35,"href":"https:\/\/www.generazione2000.com\/lab\/wp-json\/wp\/v2\/posts\/33\/revisions\/35"}],"wp:attachment":[{"href":"https:\/\/www.generazione2000.com\/lab\/wp-json\/wp\/v2\/media?parent=33"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.generazione2000.com\/lab\/wp-json\/wp\/v2\/categories?post=33"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.generazione2000.com\/lab\/wp-json\/wp\/v2\/tags?post=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}