{"action":"created","issue":{"url":"https://api.github.com/repos/magento/magento2/issues/5836","repository_url":"https://api.github.com/repos/magento/magento2","labels_url":"https://api.github.com/repos/magento/magento2/issues/5836/labels{/name}","comments_url":"https://api.github.com/repos/magento/magento2/issues/5836/comments","events_url":"https://api.github.com/repos/magento/magento2/issues/5836/events","html_url":"https://github.com/magento/magento2/issues/5836","id":167845531,"number":5836,"title":"Cron not Reindexing Index","user":{"login":"crtsl","id":19348887,"avatar_url":"https://avatars.githubusercontent.com/u/19348887?v=3","gravatar_id":"","url":"https://api.github.com/users/crtsl","html_url":"https://github.com/crtsl","followers_url":"https://api.github.com/users/crtsl/followers","following_url":"https://api.github.com/users/crtsl/following{/other_user}","gists_url":"https://api.github.com/users/crtsl/gists{/gist_id}","starred_url":"https://api.github.com/users/crtsl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crtsl/subscriptions","organizations_url":"https://api.github.com/users/crtsl/orgs","repos_url":"https://api.github.com/users/crtsl/repos","events_url":"https://api.github.com/users/crtsl/events{/privacy}","received_events_url":"https://api.github.com/users/crtsl/received_events","type":"User","site_admin":false},"labels":[{"id":147131376,"url":"https://api.github.com/repos/magento/magento2/labels/bug%20report","name":"bug report","color":"d93f0b","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":37,"created_at":"2016-07-27T12:50:01Z","updated_at":"2016-10-31T11:52:12Z","closed_at":null,"body":"The indexes are not being reindexed with the standard cron:run cron job. This is particularly noticeable when making a change to a category and it not being updated on the front end. I can add a static block or description to a category and save it in the backend and the updates will not appear on the frontend until the indexers have been manually reindexed. This could possibly be related to #2855.\n\n<!--- Provide a general summary of the issue in the Title above -->\n\n<!--- Before adding new issues, please, check this article https://github.com/magento/magento2/wiki/Issue-reporting-guidelines-->\n### Preconditions\n\n<!--- Provide a more detailed information of environment you use -->\n\n<!--- Magento version, tag, HEAD, etc., PHP & MySQL version, etc.. -->\n1. Magento 2.1 CE\n2. CentOS6\n3. PHP 5.6.24\n4. MySQL 5.6\n5. Shared hosting with Plesk control panel\n6. Using flat categories and products\n### Steps to reproduce\n\n<!--- Provide a set of unambiguous steps to reproduce this bug include code, if relevant  -->\n1. Make a change to a categories description or add a static content block\n2. Save changes\n3. Go to category on frontend to see result\n### Expected result\n\n<!--- Tell us what should happen -->\n1. Category should be updated with new content\n### Actual result\n\n<!--- Tell us what happens instead -->\n1. Category is not updated with new content\n\nI have noticed that the debug.log has been filling up quite fast with lines like the following:\n\n```\n[2016-07-27 11:33:01] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_design_config_grid_flat_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:01] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_design_config_grid_flat_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:01] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_design_config_grid_flat_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:01] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_design_config_grid_flat_4\"},\"is_exception\":false} []\n[2016-07-27 11:33:01] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_design_config_grid_flat_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:01] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_design_config_grid_flat_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:01] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_design_config_grid_flat_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:01] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_design_config_grid_flat_4\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_customer_grid_flat_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_customer_grid_flat_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_customer_grid_flat_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_customer_grid_flat_4\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_customer_grid_flat_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_customer_grid_flat_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_customer_grid_flat_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_customer_grid_flat_4\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_tmp_indexer_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_tmp_indexer_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_tmp_indexer_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_tmp_indexer_4\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_decimal_tmp_indexer_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_decimal_tmp_indexer_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_decimal_tmp_indexer_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_decimal_tmp_indexer_4\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_text_tmp_indexer_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_text_tmp_indexer_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_text_tmp_indexer_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_text_tmp_indexer_4\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_varchar_tmp_indexer_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_varchar_tmp_indexer_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_varchar_tmp_indexer_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_varchar_tmp_indexer_4\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_int_tmp_indexer_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_int_tmp_indexer_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_int_tmp_indexer_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_int_tmp_indexer_4\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_int_tmp_indexer_value_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_int_tmp_indexer_value_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_int_tmp_indexer_value_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_int_tmp_indexer_value_4\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_datetime_tmp_indexer_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_datetime_tmp_indexer_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_datetime_tmp_indexer_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_entity_datetime_tmp_indexer_4\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_flat_1_tmp_indexer_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_flat_1_tmp_indexer_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_flat_1_tmp_indexer_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_flat_1_tmp_indexer_4\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_flat_1_tmp_indexer_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_flat_1_tmp_indexer_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_flat_1_tmp_indexer_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_flat_1_tmp_indexer_4\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_flat_1_drop_indexer_1\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_flat_1_drop_indexer_2\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_flat_1_drop_indexer_3\"},\"is_exception\":false} []\n[2016-07-27 11:33:02] main.DEBUG: cache_invalidate:  {\"method\":\"GET\",\"url\":\"http:/\",\"invalidateInfo\":{\"identifier\":\"DB_PDO_MYSQL_DDL_catalog_product_flat_1_drop_indexer_4\"},\"is_exception\":false} []\n```\n\nI have setup a cron job just for reindexing as a work around for now and it seems to be working. My cron jobs are setup as follows:\n\n```\n* * * * * /opt/plesk/php/5.6/bin/php -d memory_limit=1G -c /opt/plesk/php/5.6/etc/php.ini /magento2/bin/magento cron:run >> /magento2/var/log/magento.cron.log\n* * * * * /opt/plesk/php/5.6/bin/php -d memory_limit=1G -c /opt/plesk/php/5.6/etc/php.ini /magento2/update/cron.php >> /magento2/var/log/update.cron.log\n* * * * * /opt/plesk/php/5.6/bin/php -d memory_limit=1G -c /opt/plesk/php/5.6/etc/php.ini /magento2/bin/magento setup:cron:run >> /magento2/var/log/setup.cron.log\n* * * * * /opt/plesk/php/5.6/bin/php -d memory_limit=1G -c /opt/plesk/php/5.6/etc/php.ini /magento2/bin/magento indexer:reindex\n```\n\n<!--- (This may be platform independent comment) -->\n"},"comment":{"url":"https://api.github.com/repos/magento/magento2/issues/comments/257274874","html_url":"https://github.com/magento/magento2/issues/5836#issuecomment-257274874","issue_url":"https://api.github.com/repos/magento/magento2/issues/5836","id":257274874,"user":{"login":"sysradium","id":16747951,"avatar_url":"https://avatars.githubusercontent.com/u/16747951?v=3","gravatar_id":"","url":"https://api.github.com/users/sysradium","html_url":"https://github.com/sysradium","followers_url":"https://api.github.com/users/sysradium/followers","following_url":"https://api.github.com/users/sysradium/following{/other_user}","gists_url":"https://api.github.com/users/sysradium/gists{/gist_id}","starred_url":"https://api.github.com/users/sysradium/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sysradium/subscriptions","organizations_url":"https://api.github.com/users/sysradium/orgs","repos_url":"https://api.github.com/users/sysradium/repos","events_url":"https://api.github.com/users/sysradium/events{/privacy}","received_events_url":"https://api.github.com/users/sysradium/received_events","type":"User","site_admin":false},"created_at":"2016-10-31T11:52:12Z","updated_at":"2016-10-31T11:52:12Z","body":"Any news regarding that issue? After installation Magento says that indexes need to be reindexed even after running a cron job.\r\n\r\nI could only change that manually running index:reindex job. I could add it as a cron job but it seems to be kind of weird and maybe expensive."}}
{"actor":{"display_login":"sysradium"}}