Ttdfjt

Generate a Graeco-Latin square

Using "subway" as name for London Underground?

Overlapping String-Blocks

Can the poison from Kingsmen be concocted?

Does Disney no longer produce hand-drawn cartoon films?

Confusion around using "des" in sentences

Frame failure sudden death?

1980s live-action movie where individually-coloured nations on clouds fight

Grover algorithm for a database search: where is the quantum advantage?

How come the nude protesters were not arrested?

When conversion from Integer to Single may lose precision

PhD - Well known professor or well known school?

Source that a married woman seduced by a “messianic figure” is still permitted to her husband

What is the highest possible permanent AC at character creation?

How can I tell the difference between unmarked sugar and stevia?

Compiling c files on ubuntu and using the executable on Windows

Second (easy access) account in case my bank screws up

Why doesn't Adrian Toomes give up Spider-Man's identity?

Were Alexander the Great and Hephaestion lovers?

Should I avoid hard-packed crusher dust trails with my hybrid?

How is water heavier than petrol, even though its molecular weight is less than petrol?

How can I get an unreasonable manager to approve time off?

What is the actual quality of machine translations?

Why did the Tesseract "burn" a hole through Red Skull's plane but not Nick Fury's desk?

M2: Impossible reindex

Can't reindex product flat dataReindex programatically using recursionMagento2 reindex from backendSearch catalog with less than 3 charactersMagento Reindex Isn't AutomaticMagento 2 Reindex failed on customer gridMagento 2.1.8 Reindex TimeoutDROP TABLE customer_grid_flat hangs - deadlock during customer grid indexing?Magento2: Indexes every time ProcessedM2: Impossible finish reindex

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

0

Impossible reindex magento 2.1.11

In terminal I run:

php bin/magento indexer:reindex

The first 3 indexes reindex in a few seconds. Reindex stops on the 4th index and this is the end. I waited all night and stood still.

Reindex stops at:

Indexed category / product associations

• I try reset all indexex


• also I try fix issue with deadlock:

https://www.tigren.com/fix-deadlock-error-reindexing-magento-2/

any other solution?

@update
I found one solution:

• Reset indexes: bin/magento indexer:reset
  


• Make sure that no database processes regarding indexing is running


• Open your database administration client like PHPMyAdmin


• Run query: SHOW PROCESSLIST;


• Run query: KILL QUERY xxxxx (where xxxxx is the ID
  of processes you want to kill)


• bin/magento setup:upgrade Clear cache


• 
  bin/magento setup:static-content:deploy -j 1


• 
  bin/magento indexer:reindex


• Disable maintenance mode bin/magento maintenance:disable
  

But can anyone confirm that I need kill this both process?

https://prnt.sc/nvbr2e

magento2 reindex

share|improve this question

edited May 30 at 9:37

Sylvester

asked May 30 at 6:57

SylvesterSylvester

801318

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Have you checked the logs to see if something is going wrong?
  
  – SantiBM
  May 30 at 7:23
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Unfortunately, there is no information in the logs that could indicate some error.
  
  – Sylvester
  May 30 at 7:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  do you see actual indexer php process id running?
  
  – MagenX
  May 30 at 8:45
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Where can I check it? Can you explain to me more what you mean?
  
  – Sylvester
  May 30 at 8:48
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  type this command in ps aux | grep indexer
  
  – MagenX
  May 30 at 8:50
  

  
  
  
  

 | 
show 1 more comment

0

Impossible reindex magento 2.1.11

In terminal I run:

php bin/magento indexer:reindex

The first 3 indexes reindex in a few seconds. Reindex stops on the 4th index and this is the end. I waited all night and stood still.

Reindex stops at:

Indexed category / product associations

• I try reset all indexex


• also I try fix issue with deadlock:

https://www.tigren.com/fix-deadlock-error-reindexing-magento-2/

any other solution?

@update
I found one solution:

• Reset indexes: bin/magento indexer:reset
  


• Make sure that no database processes regarding indexing is running


• Open your database administration client like PHPMyAdmin


• Run query: SHOW PROCESSLIST;


• Run query: KILL QUERY xxxxx (where xxxxx is the ID
  of processes you want to kill)


• bin/magento setup:upgrade Clear cache


• 
  bin/magento setup:static-content:deploy -j 1


• 
  bin/magento indexer:reindex


• Disable maintenance mode bin/magento maintenance:disable
  

But can anyone confirm that I need kill this both process?

https://prnt.sc/nvbr2e

magento2 reindex

share|improve this question

edited May 30 at 9:37

Sylvester

asked May 30 at 6:57

SylvesterSylvester

801318

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Have you checked the logs to see if something is going wrong?
  
  – SantiBM
  May 30 at 7:23
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Unfortunately, there is no information in the logs that could indicate some error.
  
  – Sylvester
  May 30 at 7:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  do you see actual indexer php process id running?
  
  – MagenX
  May 30 at 8:45
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Where can I check it? Can you explain to me more what you mean?
  
  – Sylvester
  May 30 at 8:48
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  type this command in ps aux | grep indexer
  
  – MagenX
  May 30 at 8:50
  

  
  
  
  

 | 
show 1 more comment

Impossible reindex magento 2.1.11

In terminal I run:

php bin/magento indexer:reindex

The first 3 indexes reindex in a few seconds. Reindex stops on the 4th index and this is the end. I waited all night and stood still.

Reindex stops at:

Indexed category / product associations

• I try reset all indexex


• also I try fix issue with deadlock:

https://www.tigren.com/fix-deadlock-error-reindexing-magento-2/

any other solution?

@update
I found one solution:

• Reset indexes: bin/magento indexer:reset
  


• Make sure that no database processes regarding indexing is running


• Open your database administration client like PHPMyAdmin


• Run query: SHOW PROCESSLIST;


• Run query: KILL QUERY xxxxx (where xxxxx is the ID
  of processes you want to kill)


• bin/magento setup:upgrade Clear cache


• 
  bin/magento setup:static-content:deploy -j 1


• 
  bin/magento indexer:reindex


• Disable maintenance mode bin/magento maintenance:disable
  

But can anyone confirm that I need kill this both process?

https://prnt.sc/nvbr2e

magento2 reindex

share|improve this question

edited May 30 at 9:37

Sylvester

asked May 30 at 6:57

SylvesterSylvester

801318

share|improve this question

edited May 30 at 9:37

Sylvester

asked May 30 at 6:57

SylvesterSylvester

801318

share|improve this question

edited May 30 at 9:37

Sylvester

asked May 30 at 6:57

SylvesterSylvester

801318

asked May 30 at 6:57

SylvesterSylvester

801318

asked May 30 at 6:57

SylvesterSylvester

801318

1 Answer
1

active

oldest

votes

1

change magento to developer mode

make sure your debug/developer logs enabled. also check php error logs.

you have to check your database for errors:

mysqlcheck MAGENTO_DB --silent

then open second ssh session and read your magento logs:

tail -f var/log/system.log & tail -f var/log/exception.log

open third ssh session and read your strace file:

tail -f indexer_strace 

start your indexer with strace, either as root or magento files user:

strace -s 99999 bin/magento indexer:reindex 1>indexer_strace 2>&1

this will be a little start to your debug.

share|improve this answer

answered May 30 at 9:28

MagenXMagenX

2,2071027

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  MagenX, before this, can you please check my topic update?
  
  – Sylvester
  May 30 at 9:37
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  the steps you listed is to hide or jump over the issue you have, it will not fix it.
  
  – MagenX
  May 31 at 8:55
  
  

  
  
  
  

add a comment | 

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%2f276679%2fm2-impossible-reindex%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

change magento to developer mode

make sure your debug/developer logs enabled. also check php error logs.

you have to check your database for errors:

mysqlcheck MAGENTO_DB --silent

then open second ssh session and read your magento logs:

tail -f var/log/system.log & tail -f var/log/exception.log

open third ssh session and read your strace file:

tail -f indexer_strace 

start your indexer with strace, either as root or magento files user:

strace -s 99999 bin/magento indexer:reindex 1>indexer_strace 2>&1

this will be a little start to your debug.

share|improve this answer

answered May 30 at 9:28

MagenXMagenX

2,2071027

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  MagenX, before this, can you please check my topic update?
  
  – Sylvester
  May 30 at 9:37
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  the steps you listed is to hide or jump over the issue you have, it will not fix it.
  
  – MagenX
  May 31 at 8:55
  
  

  
  
  
  

add a comment | 

1

change magento to developer mode

make sure your debug/developer logs enabled. also check php error logs.

you have to check your database for errors:

mysqlcheck MAGENTO_DB --silent

then open second ssh session and read your magento logs:

tail -f var/log/system.log & tail -f var/log/exception.log

open third ssh session and read your strace file:

tail -f indexer_strace 

start your indexer with strace, either as root or magento files user:

strace -s 99999 bin/magento indexer:reindex 1>indexer_strace 2>&1

this will be a little start to your debug.

share|improve this answer

answered May 30 at 9:28

MagenXMagenX

2,2071027

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  MagenX, before this, can you please check my topic update?
  
  – Sylvester
  May 30 at 9:37
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  the steps you listed is to hide or jump over the issue you have, it will not fix it.
  
  – MagenX
  May 31 at 8:55
  
  

  
  
  
  

add a comment | 

change magento to developer mode

make sure your debug/developer logs enabled. also check php error logs.

you have to check your database for errors:

mysqlcheck MAGENTO_DB --silent

then open second ssh session and read your magento logs:

tail -f var/log/system.log & tail -f var/log/exception.log

open third ssh session and read your strace file:

tail -f indexer_strace 

start your indexer with strace, either as root or magento files user:

strace -s 99999 bin/magento indexer:reindex 1>indexer_strace 2>&1

this will be a little start to your debug.

share|improve this answer

answered May 30 at 9:28

MagenXMagenX

2,2071027

mysqlcheck MAGENTO_DB --silent

tail -f var/log/system.log & tail -f var/log/exception.log

tail -f indexer_strace 

strace -s 99999 bin/magento indexer:reindex 1>indexer_strace 2>&1

share|improve this answer

answered May 30 at 9:28

MagenXMagenX

2,2071027

answered May 30 at 9:28

MagenXMagenX

2,2071027

answered May 30 at 9:28

MagenXMagenX

2,2071027