Ttdfjt

Why were the first airplanes "backwards"?

Handling a player (unintentionally) stealing the spotlight

Can an editor review manuscript without sending to reviewers?

How to describe POV characters?

Is it okay to fade a human face just to create some space to place important content over it?

Will a higher security deposit build credit faster with a secured card?

How hard is it to sell a home which is currently mortgaged?

Most elegant way to write a one shot IF

One folder having two different locations on Ubuntu 18.04

Does any Greek word have a geminate consonant after a long vowel?

How did Lefschetz do mathematics without hands?

Symbol for "not absolutely continuous" in Latex

What's the easiest way for a whole party to be able to communicate with a creature that doesn't know Common?

Security Patch SUPEE-11155 - Possible issues?

What's the safest way to inform a new user of their password on an invite-only website?

Integral from infinity to infinity

How do I tell the reader that my character is autistic in Fantasy?

Using a concentration spell on top of another spell from another spell list?

Can two or more lightbeams (from a laser for example) have visible interference when they cross in mid-air*?

Can Aziraphale and Crowley actually become native?

What are good ways to spray paint a QR code on a footpath?

How to answer "write something on the board"?

My colleague is constantly blaming me for his errors

Is there an equivalent of Parseval's theorem for wavelets?

Magento 2 Catalog Product Flat Data not reindexing

Reindexing error message in Product Flat DataCan't reindex product flat dataMagento 2 cron job not re-indexing products as expectedreindexing issue for catalog product flatproduct flat data no reindexing 1.9.1 magento errno: 121Table missing after index:resetMagneto2 CatalogSearchMagento Flat Category Table contains incorrect data (even after reindexing)Magento2: Indexes every time ProcessedM2: Impossible reindex

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

the indexing of magento product Flat data is staying on "index required".The mode is on "Scheme" and the cron is running. I tried several things like:

truncate catalog_product_flat_1, catalog_product_flat_2,
catalog_product_flat_3, catalog_product_flat_4

php bin/magento indexer:reindex
php bin/magento indexer:reset 
php bin/magento indexer:reindex
php bin/magento indexer:reset catalog_product_flat

Error :-

message in shell: State for the same indexer already exists.

update indexer_state set status = 'invalid' where status != 'valid';

Then reindex again

Can anybody help?
Thanks

magento2 reindex

share|improve this question

edited Jun 19 at 12:30

Rk Rathod

2,42333 silver badges1818 bronze badges

asked Jun 19 at 12:07

user1250934user1250934

2366 bronze badges

add a comment | 

0

the indexing of magento product Flat data is staying on "index required".The mode is on "Scheme" and the cron is running. I tried several things like:

truncate catalog_product_flat_1, catalog_product_flat_2,
catalog_product_flat_3, catalog_product_flat_4

php bin/magento indexer:reindex
php bin/magento indexer:reset 
php bin/magento indexer:reindex
php bin/magento indexer:reset catalog_product_flat

Error :-

message in shell: State for the same indexer already exists.

update indexer_state set status = 'invalid' where status != 'valid';

Then reindex again

Can anybody help?
Thanks

magento2 reindex

share|improve this question

edited Jun 19 at 12:30

Rk Rathod

2,42333 silver badges1818 bronze badges

asked Jun 19 at 12:07

user1250934user1250934

2366 bronze badges

add a comment | 

the indexing of magento product Flat data is staying on "index required".The mode is on "Scheme" and the cron is running. I tried several things like:

truncate catalog_product_flat_1, catalog_product_flat_2,
catalog_product_flat_3, catalog_product_flat_4

php bin/magento indexer:reindex
php bin/magento indexer:reset 
php bin/magento indexer:reindex
php bin/magento indexer:reset catalog_product_flat

Error :-

message in shell: State for the same indexer already exists.

update indexer_state set status = 'invalid' where status != 'valid';

Then reindex again

Can anybody help?
Thanks

magento2 reindex

share|improve this question

edited Jun 19 at 12:30

Rk Rathod

2,42333 silver badges1818 bronze badges

asked Jun 19 at 12:07

user1250934user1250934

2366 bronze badges

php bin/magento indexer:reindex
php bin/magento indexer:reset 
php bin/magento indexer:reindex
php bin/magento indexer:reset catalog_product_flat

share|improve this question

edited Jun 19 at 12:30

Rk Rathod

2,42333 silver badges1818 bronze badges

asked Jun 19 at 12:07

user1250934user1250934

2366 bronze badges

share|improve this question

edited Jun 19 at 12:30

Rk Rathod

2,42333 silver badges1818 bronze badges

asked Jun 19 at 12:07

user1250934user1250934

2366 bronze badges

edited Jun 19 at 12:30

Rk Rathod

2,42333 silver badges1818 bronze badges

edited Jun 19 at 12:30

Rk Rathod

2,42333 silver badges1818 bronze badges

asked Jun 19 at 12:07

user1250934user1250934

2366 bronze badges

asked Jun 19 at 12:07

user1250934user1250934

2366 bronze badges

2 Answers
2

active

oldest

votes

0

In your database, try running the below commnand

update indexer_state set status = 'invalid' where status != 'valid';

Then reindex again

share|improve this answer

answered Jun 19 at 12:10

surbhi agrsurbhi agr

6231616 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi, did but still same error: State for the same indexer already exists.
  
  – user1250934
  Jun 19 at 12:11
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  try running command with sudo
  
  – surbhi agr
  Jun 19 at 12:13
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What's the right commando with sudo?
  
  – user1250934
  Jun 19 at 12:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  sudo php bin/magento indexer:reindex
  
  – surbhi agr
  Jun 19 at 12:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  same error still showing
  
  – user1250934
  Jun 19 at 12:14
  

  
  
  
  

 | 
show 4 more comments

0

In Database Run This Query

update indexer_state set status = 'invalid' where indexer_id = 'catalog_product_flat';

And After This run indexer:reindex command

share|improve this answer

answered Jun 19 at 12:12

Rk RathodRk Rathod

2,42333 silver badges1818 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  did this, but i see still the same error.
  
  – user1250934
  Jun 19 at 12:18
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  bin/magento indexer:status and check catalog_product_flat status
  
  – Rk Rathod
  Jun 19 at 12:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  result: Product Flat Data: Reindex required
  
  – user1250934
  Jun 19 at 12:34
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  try to indexer:reindex
  
  – Rk Rathod
  Jun 19 at 12:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I already did multiple times, without a result
  
  – user1250934
  Jun 19 at 12:39
  

  
  
  
  

 | 
show 2 more comments

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f278873%2fmagento-2-catalog-product-flat-data-not-reindexing%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

In your database, try running the below commnand

update indexer_state set status = 'invalid' where status != 'valid';

Then reindex again

share|improve this answer

answered Jun 19 at 12:10

surbhi agrsurbhi agr

6231616 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi, did but still same error: State for the same indexer already exists.
  
  – user1250934
  Jun 19 at 12:11
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  try running command with sudo
  
  – surbhi agr
  Jun 19 at 12:13
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What's the right commando with sudo?
  
  – user1250934
  Jun 19 at 12:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  sudo php bin/magento indexer:reindex
  
  – surbhi agr
  Jun 19 at 12:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  same error still showing
  
  – user1250934
  Jun 19 at 12:14
  

  
  
  
  

 | 
show 4 more comments

0

In your database, try running the below commnand

update indexer_state set status = 'invalid' where status != 'valid';

Then reindex again

share|improve this answer

answered Jun 19 at 12:10

surbhi agrsurbhi agr

6231616 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi, did but still same error: State for the same indexer already exists.
  
  – user1250934
  Jun 19 at 12:11
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  try running command with sudo
  
  – surbhi agr
  Jun 19 at 12:13
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What's the right commando with sudo?
  
  – user1250934
  Jun 19 at 12:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  sudo php bin/magento indexer:reindex
  
  – surbhi agr
  Jun 19 at 12:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  same error still showing
  
  – user1250934
  Jun 19 at 12:14
  

  
  
  
  

 | 
show 4 more comments

In your database, try running the below commnand

update indexer_state set status = 'invalid' where status != 'valid';

Then reindex again

share|improve this answer

answered Jun 19 at 12:10

surbhi agrsurbhi agr

6231616 bronze badges

share|improve this answer

answered Jun 19 at 12:10

surbhi agrsurbhi agr

6231616 bronze badges

answered Jun 19 at 12:10

surbhi agrsurbhi agr

6231616 bronze badges

answered Jun 19 at 12:10

surbhi agrsurbhi agr

6231616 bronze badges

0

In Database Run This Query

update indexer_state set status = 'invalid' where indexer_id = 'catalog_product_flat';

And After This run indexer:reindex command

share|improve this answer

answered Jun 19 at 12:12

Rk RathodRk Rathod

2,42333 silver badges1818 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  did this, but i see still the same error.
  
  – user1250934
  Jun 19 at 12:18
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  bin/magento indexer:status and check catalog_product_flat status
  
  – Rk Rathod
  Jun 19 at 12:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  result: Product Flat Data: Reindex required
  
  – user1250934
  Jun 19 at 12:34
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  try to indexer:reindex
  
  – Rk Rathod
  Jun 19 at 12:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I already did multiple times, without a result
  
  – user1250934
  Jun 19 at 12:39
  

  
  
  
  

 | 
show 2 more comments

0

In Database Run This Query

update indexer_state set status = 'invalid' where indexer_id = 'catalog_product_flat';

And After This run indexer:reindex command

share|improve this answer

answered Jun 19 at 12:12

Rk RathodRk Rathod

2,42333 silver badges1818 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  did this, but i see still the same error.
  
  – user1250934
  Jun 19 at 12:18
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  bin/magento indexer:status and check catalog_product_flat status
  
  – Rk Rathod
  Jun 19 at 12:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  result: Product Flat Data: Reindex required
  
  – user1250934
  Jun 19 at 12:34
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  try to indexer:reindex
  
  – Rk Rathod
  Jun 19 at 12:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I already did multiple times, without a result
  
  – user1250934
  Jun 19 at 12:39
  

  
  
  
  

 | 
show 2 more comments

In Database Run This Query

update indexer_state set status = 'invalid' where indexer_id = 'catalog_product_flat';

And After This run indexer:reindex command

share|improve this answer

answered Jun 19 at 12:12

Rk RathodRk Rathod

2,42333 silver badges1818 bronze badges

update indexer_state set status = 'invalid' where indexer_id = 'catalog_product_flat';

share|improve this answer

answered Jun 19 at 12:12

Rk RathodRk Rathod

2,42333 silver badges1818 bronze badges

answered Jun 19 at 12:12

Rk RathodRk Rathod

2,42333 silver badges1818 bronze badges

answered Jun 19 at 12:12

Rk RathodRk Rathod

2,42333 silver badges1818 bronze badges