{"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":[{"url":"https://api.github.com/repos/magento/magento2/labels/bug%20report","name":"bug report","color":"d93f0b"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":34,"created_at":"2016-07-27T12:50:01Z","updated_at":"2016-10-20T13:42: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.\r\n\r\n<!--- Provide a general summary of the issue in the Title above -->\r\n<!--- Before adding new issues, please, check this article https://github.com/magento/magento2/wiki/Issue-reporting-guidelines-->\r\n\r\n### Preconditions\r\n<!--- Provide a more detailed information of environment you use -->\r\n<!--- Magento version, tag, HEAD, etc., PHP & MySQL version, etc.. -->\r\n1. Magento 2.1 CE\r\n2. CentOS6\r\n3. PHP 5.6.24\r\n4. MySQL 5.6\r\n5. Shared hosting with Plesk control panel\r\n6. Using flat categories and products\r\n\r\n### Steps to reproduce\r\n<!--- Provide a set of unambiguous steps to reproduce this bug include code, if relevant  -->\r\n1. Make a change to a categories description or add a static content block\r\n2. Save changes\r\n3. Go to category on frontend to see result\r\n\r\n### Expected result\r\n<!--- Tell us what should happen -->\r\n1. Category should be updated with new content\r\n\r\n### Actual result\r\n<!--- Tell us what happens instead -->\r\n1. Category is not updated with new content\r\n\r\nI have noticed that the debug.log has been filling up quite fast with lines like the following:\r\n\r\n```\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\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} []\r\n```\r\n\r\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:\r\n\r\n```\r\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\r\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\r\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\r\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\r\n```\r\n\r\n<!--- (This may be platform independent comment) -->\r\n"},"comment":{"url":"https://api.github.com/repos/magento/magento2/issues/comments/255109043","html_url":"https://github.com/magento/magento2/issues/5836#issuecomment-255109043","issue_url":"https://api.github.com/repos/magento/magento2/issues/5836","id":255109043,"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},"created_at":"2016-10-20T13:42:12Z","updated_at":"2016-10-20T13:42:12Z","body":"It appears that the following indexes are not getting invalidated/reindexed when creating/adding a new product:\r\n```\r\ncatalog_category_flat - Category Flat Data\r\ncatalog_category_product - Category Products\r\n```\r\n\r\nI am able to get the new products to show by going to Products -> Categories and clicking Save on the default category(making no changes to the default category)."}}
{"actor":{"display_login":"crtsl"}}