magento 2: get verbose output from indexerindexer from shell not workingMagento 2 Indexer Allowed memory size of xxxx bytes exhoustedMagento 2.0 with upgraded to php 7.0 Indexer Stuck at processingMagento 2 module not registering and causing CLI to failUninstalling a moduleFatal error after upgrade from 2.1.8 to 2.2.0Rogue “enterprise_refresh_index” causing excessive Merchandising failuresReflectionException: Class does not existCatalog Search indexer process unknown errorMagento 2 - InstallData script doesn´t add column to my 'customer_entitiy'
Email address etiquette - Which address should I use to contact professors?
What ability do tools use?
Can the ground attached to neutral fool a receptacle tester?
What is the status of the F-1B engine development?
What gave Harry Potter the idea of writing in Tom Riddle's diary?
These were just lying around
Why are Gatwick's runways too close together?
80's/90's superhero cartoon with a man on fire and a man who made ice runways like Frozone
How far did Gandalf and the Balrog drop from the bridge in Moria?
PhD advisor lost funding, need advice
Does the Fireball spell damage objects?
How to reduce Sinas Chinam
Is God unknowable?
Does fossil fuels use since 1990 account for half of all the fossil fuels used in history?
A continuous water "planet" ring around a star
Boss wants me to ignore a software license
Why command hierarchy, if the chain of command is standing next to each other?
Redis Cache Shared Session Configuration
On the Rømer experiments and the speed of light
Are differences between uniformly distributed numbers uniformly distributed?
Generate Brainfuck for the numbers 1–255
Is this n-speak?
If a digital camera can be "hacked" in the ransomware sense, how best to protect it?
Why are Tucker and Malcolm not dead?
magento 2: get verbose output from indexer
indexer from shell not workingMagento 2 Indexer Allowed memory size of xxxx bytes exhoustedMagento 2.0 with upgraded to php 7.0 Indexer Stuck at processingMagento 2 module not registering and causing CLI to failUninstalling a moduleFatal error after upgrade from 2.1.8 to 2.2.0Rogue “enterprise_refresh_index” causing excessive Merchandising failuresReflectionException: Class does not existCatalog Search indexer process unknown errorMagento 2 - InstallData script doesn´t add column to my 'customer_entitiy'
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I am having an issue with the customer_grid indexerphp bin/magento index:reindex customer_grid
After running this command, the cli will wait indefinitely for the process to finish. I use update indexer_state set status='invalid' where status ='working' to reset the customer_grid index but then same thing happens after running the command again.
Is there a way to have a more verbose output or debug log for this command that I can refer to figure out what is causing the indexer to fail.
magento2 indexing customer-grid
asked Dec 5 '16 at 21:58
Xenocide8998Xenocide8998
1,0241 gold badge9 silver badges25 bronze badges
add a comment |
I am having an issue with the customer_grid indexerphp bin/magento index:reindex customer_grid
After running this command, the cli will wait indefinitely for the process to finish. I use update indexer_state set status='invalid' where status ='working' to reset the customer_grid index but then same thing happens after running the command again.
Is there a way to have a more verbose output or debug log for this command that I can refer to figure out what is causing the indexer to fail.
magento2 indexing customer-grid
asked Dec 5 '16 at 21:58
Xenocide8998Xenocide8998
1,0241 gold badge9 silver badges25 bronze badges
Please run query in orderSET SQL_SAFE_UPDATES = 0;,update indexer_state set status = 'invalid' where status != 'valid';,php bin/magento indexer:reindex customer_grid
– Ankit Shah
Dec 6 '16 at 2:01
Applied the change, but did not solve the issue. Do we know what files manage the customer_grid index?
– Xenocide8998
Dec 6 '16 at 17:20
See what error you have in var/log/exceptions.lo.g Something fails in customer grid and it must be a SQL query. If you have many customers than maybe you need to increase ini_set('memory_limit', '4096M'). You can add it in app/bootstrap.php (which is included by both index.php and bin/magento), directly in bin/magento or in a server configuration.
– obscure
Dec 6 '16 at 20:05
I ended up running the indexer as a background taskphp bin/magento index:reindex customer_grid &and ran app like top to prevent ssh timeout. It took ~45min but the indexer completed. It would be nice if the indexer had an output like static-content that prevented ssh from timing out.
– Xenocide8998
Jan 9 '17 at 21:11
add a comment |
I am having an issue with the customer_grid indexerphp bin/magento index:reindex customer_grid
After running this command, the cli will wait indefinitely for the process to finish. I use update indexer_state set status='invalid' where status ='working' to reset the customer_grid index but then same thing happens after running the command again.
Is there a way to have a more verbose output or debug log for this command that I can refer to figure out what is causing the indexer to fail.
magento2 indexing customer-grid
asked Dec 5 '16 at 21:58
Xenocide8998Xenocide8998
1,0241 gold badge9 silver badges25 bronze badges
I am having an issue with the customer_grid indexerphp bin/magento index:reindex customer_grid
After running this command, the cli will wait indefinitely for the process to finish. I use update indexer_state set status='invalid' where status ='working' to reset the customer_grid index but then same thing happens after running the command again.
Is there a way to have a more verbose output or debug log for this command that I can refer to figure out what is causing the indexer to fail.
magento2 indexing customer-grid
magento2 indexing customer-grid
asked Dec 5 '16 at 21:58
Xenocide8998Xenocide8998
1,0241 gold badge9 silver badges25 bronze badges
asked Dec 5 '16 at 21:58
Xenocide8998Xenocide8998
1,0241 gold badge9 silver badges25 bronze badges
asked Dec 5 '16 at 21:58
Xenocide8998Xenocide8998
1,0241 gold badge9 silver badges25 bronze badges
asked Dec 5 '16 at 21:58
Xenocide8998Xenocide8998
1,0241 gold badge9 silver badges25 bronze badges
asked Dec 5 '16 at 21:58
Xenocide8998Xenocide8998
1,0241 gold badge9 silver badges25 bronze badges
1,0241 gold badge9 silver badges25 bronze badges
Please run query in orderSET SQL_SAFE_UPDATES = 0;,update indexer_state set status = 'invalid' where status != 'valid';,php bin/magento indexer:reindex customer_grid
– Ankit Shah
Dec 6 '16 at 2:01
Applied the change, but did not solve the issue. Do we know what files manage the customer_grid index?
– Xenocide8998
Dec 6 '16 at 17:20
See what error you have in var/log/exceptions.lo.g Something fails in customer grid and it must be a SQL query. If you have many customers than maybe you need to increase ini_set('memory_limit', '4096M'). You can add it in app/bootstrap.php (which is included by both index.php and bin/magento), directly in bin/magento or in a server configuration.
– obscure
Dec 6 '16 at 20:05
I ended up running the indexer as a background taskphp bin/magento index:reindex customer_grid &and ran app like top to prevent ssh timeout. It took ~45min but the indexer completed. It would be nice if the indexer had an output like static-content that prevented ssh from timing out.
– Xenocide8998
Jan 9 '17 at 21:11
add a comment |
Please run query in orderSET SQL_SAFE_UPDATES = 0;,update indexer_state set status = 'invalid' where status != 'valid';,php bin/magento indexer:reindex customer_grid
– Ankit Shah
Dec 6 '16 at 2:01
Applied the change, but did not solve the issue. Do we know what files manage the customer_grid index?
– Xenocide8998
Dec 6 '16 at 17:20
See what error you have in var/log/exceptions.lo.g Something fails in customer grid and it must be a SQL query. If you have many customers than maybe you need to increase ini_set('memory_limit', '4096M'). You can add it in app/bootstrap.php (which is included by both index.php and bin/magento), directly in bin/magento or in a server configuration.
– obscure
Dec 6 '16 at 20:05
I ended up running the indexer as a background taskphp bin/magento index:reindex customer_grid &and ran app like top to prevent ssh timeout. It took ~45min but the indexer completed. It would be nice if the indexer had an output like static-content that prevented ssh from timing out.
– Xenocide8998
Jan 9 '17 at 21:11
Please run query in order
SET SQL_SAFE_UPDATES = 0; , update indexer_state set status = 'invalid' where status != 'valid';, php bin/magento indexer:reindex customer_grid– Ankit Shah
Dec 6 '16 at 2:01
Please run query in order
SET SQL_SAFE_UPDATES = 0; , update indexer_state set status = 'invalid' where status != 'valid';, php bin/magento indexer:reindex customer_grid– Ankit Shah
Dec 6 '16 at 2:01
Applied the change, but did not solve the issue. Do we know what files manage the customer_grid index?
– Xenocide8998
Dec 6 '16 at 17:20
Applied the change, but did not solve the issue. Do we know what files manage the customer_grid index?
– Xenocide8998
Dec 6 '16 at 17:20
See what error you have in var/log/exceptions.lo.g Something fails in customer grid and it must be a SQL query. If you have many customers than maybe you need to increase ini_set('memory_limit', '4096M'). You can add it in app/bootstrap.php (which is included by both index.php and bin/magento), directly in bin/magento or in a server configuration.
– obscure
Dec 6 '16 at 20:05
See what error you have in var/log/exceptions.lo.g Something fails in customer grid and it must be a SQL query. If you have many customers than maybe you need to increase ini_set('memory_limit', '4096M'). You can add it in app/bootstrap.php (which is included by both index.php and bin/magento), directly in bin/magento or in a server configuration.
– obscure
Dec 6 '16 at 20:05
I ended up running the indexer as a background task
php bin/magento index:reindex customer_grid & and ran app like top to prevent ssh timeout. It took ~45min but the indexer completed. It would be nice if the indexer had an output like static-content that prevented ssh from timing out.– Xenocide8998
Jan 9 '17 at 21:11
I ended up running the indexer as a background task
php bin/magento index:reindex customer_grid & and ran app like top to prevent ssh timeout. It took ~45min but the indexer completed. It would be nice if the indexer had an output like static-content that prevented ssh from timing out.– Xenocide8998
Jan 9 '17 at 21:11
add a comment |
1 Answer
1
active
oldest
votes
Use verbose option of magento command php bin/magento index:reindex -vv customer_grid
answered Dec 6 '16 at 19:53
KAndyKAndy
16.7k2 gold badges36 silver badges47 bronze badges
-v -vv -vvv does not output anything for the customer_grid
– Xenocide8998
Dec 21 '16 at 1:39
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
);
);
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f148939%2fmagento-2-get-verbose-output-from-indexer%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Use verbose option of magento command php bin/magento index:reindex -vv customer_grid
answered Dec 6 '16 at 19:53
KAndyKAndy
16.7k2 gold badges36 silver badges47 bronze badges
-v -vv -vvv does not output anything for the customer_grid
– Xenocide8998
Dec 21 '16 at 1:39
add a comment |
Use verbose option of magento command php bin/magento index:reindex -vv customer_grid
answered Dec 6 '16 at 19:53
KAndyKAndy
16.7k2 gold badges36 silver badges47 bronze badges
-v -vv -vvv does not output anything for the customer_grid
– Xenocide8998
Dec 21 '16 at 1:39
add a comment |
Use verbose option of magento command php bin/magento index:reindex -vv customer_grid
answered Dec 6 '16 at 19:53
KAndyKAndy
16.7k2 gold badges36 silver badges47 bronze badges
Use verbose option of magento command php bin/magento index:reindex -vv customer_grid
answered Dec 6 '16 at 19:53
KAndyKAndy
16.7k2 gold badges36 silver badges47 bronze badges
answered Dec 6 '16 at 19:53
KAndyKAndy
16.7k2 gold badges36 silver badges47 bronze badges
answered Dec 6 '16 at 19:53
KAndyKAndy
16.7k2 gold badges36 silver badges47 bronze badges
answered Dec 6 '16 at 19:53
KAndyKAndy
16.7k2 gold badges36 silver badges47 bronze badges
16.7k2 gold badges36 silver badges47 bronze badges
-v -vv -vvv does not output anything for the customer_grid
– Xenocide8998
Dec 21 '16 at 1:39
add a comment |
-v -vv -vvv does not output anything for the customer_grid
– Xenocide8998
Dec 21 '16 at 1:39
-v -vv -vvv does not output anything for the customer_grid
– Xenocide8998
Dec 21 '16 at 1:39
-v -vv -vvv does not output anything for the customer_grid
– Xenocide8998
Dec 21 '16 at 1:39
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f148939%2fmagento-2-get-verbose-output-from-indexer%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Please run query in order
SET SQL_SAFE_UPDATES = 0;,update indexer_state set status = 'invalid' where status != 'valid';,php bin/magento indexer:reindex customer_grid– Ankit Shah
Dec 6 '16 at 2:01
Applied the change, but did not solve the issue. Do we know what files manage the customer_grid index?
– Xenocide8998
Dec 6 '16 at 17:20
See what error you have in var/log/exceptions.lo.g Something fails in customer grid and it must be a SQL query. If you have many customers than maybe you need to increase ini_set('memory_limit', '4096M'). You can add it in app/bootstrap.php (which is included by both index.php and bin/magento), directly in bin/magento or in a server configuration.
– obscure
Dec 6 '16 at 20:05
I ended up running the indexer as a background task
php bin/magento index:reindex customer_grid &and ran app like top to prevent ssh timeout. It took ~45min but the indexer completed. It would be nice if the indexer had an output like static-content that prevented ssh from timing out.– Xenocide8998
Jan 9 '17 at 21:11