Magento 2: Admin Customer Listing Not Displaying Record

I have an entry of 54K users in Customers. In Database customer_entity table it's showing count.

It's working an hour before. Suddenly it's not displaying in Admin Customer Listing. Trying to search as well. Still not displaying record.

I have cleared cache as well. No errors in Log

What's the reason behind this issue or why it occurs? Because Magento behaves strangely.

edited Oct 21 '16 at 7:16

asked Oct 21 '16 at 6:15

Ankit Shah

4,755864141

Is there any customer from customer_grid_flat table?

– Khoa TruongDinh
Oct 21 '16 at 6:16

customer_grid_flat table is Blank :( No records. It's 0

– Ankit Shah
Oct 21 '16 at 6:18

Tried to reindex database?

– Khoa TruongDinh
Oct 21 '16 at 6:18

Let me do that static:content-deploy is not going to affect right?

– Ankit Shah
Oct 21 '16 at 6:19

php bin/magento indexer:reindex

– Khoa TruongDinh
Oct 21 '16 at 6:20

|
show 2 more comments

I have an entry of 54K users in Customers. In Database customer_entity table it's showing count.

It's working an hour before. Suddenly it's not displaying in Admin Customer Listing. Trying to search as well. Still not displaying record.

I have cleared cache as well. No errors in Log

What's the reason behind this issue or why it occurs? Because Magento behaves strangely.

edited Oct 21 '16 at 7:16

asked Oct 21 '16 at 6:15

Ankit Shah

4,755864141

Is there any customer from customer_grid_flat table?

– Khoa TruongDinh
Oct 21 '16 at 6:16

customer_grid_flat table is Blank :( No records. It's 0

– Ankit Shah
Oct 21 '16 at 6:18

Tried to reindex database?

– Khoa TruongDinh
Oct 21 '16 at 6:18

Let me do that static:content-deploy is not going to affect right?

– Ankit Shah
Oct 21 '16 at 6:19

php bin/magento indexer:reindex

– Khoa TruongDinh
Oct 21 '16 at 6:20

|
show 2 more comments

I have an entry of 54K users in Customers. In Database customer_entity table it's showing count.

It's working an hour before. Suddenly it's not displaying in Admin Customer Listing. Trying to search as well. Still not displaying record.

I have cleared cache as well. No errors in Log

What's the reason behind this issue or why it occurs? Because Magento behaves strangely.

edited Oct 21 '16 at 7:16

asked Oct 21 '16 at 6:15

Ankit Shah

4,755864141

I have an entry of 54K users in Customers. In Database customer_entity table it's showing count.

It's working an hour before. Suddenly it's not displaying in Admin Customer Listing. Trying to search as well. Still not displaying record.

I have cleared cache as well. No errors in Log

What's the reason behind this issue or why it occurs? Because Magento behaves strangely.

magento2 admin customer

edited Oct 21 '16 at 7:16

asked Oct 21 '16 at 6:15

Ankit Shah

4,755864141

edited Oct 21 '16 at 7:16

asked Oct 21 '16 at 6:15

Ankit Shah

4,755864141

edited Oct 21 '16 at 7:16

asked Oct 21 '16 at 6:15

Ankit Shah

4,755864141

asked Oct 21 '16 at 6:15

Ankit Shah

4,755864141

asked Oct 21 '16 at 6:15

Ankit Shah

4,755864141

Is there any customer from customer_grid_flat table?

– Khoa TruongDinh
Oct 21 '16 at 6:16

customer_grid_flat table is Blank :( No records. It's 0

– Ankit Shah
Oct 21 '16 at 6:18

Tried to reindex database?

– Khoa TruongDinh
Oct 21 '16 at 6:18

Let me do that static:content-deploy is not going to affect right?

– Ankit Shah
Oct 21 '16 at 6:19

php bin/magento indexer:reindex

– Khoa TruongDinh
Oct 21 '16 at 6:20

|
show 2 more comments

Is there any customer from customer_grid_flat table?

– Khoa TruongDinh
Oct 21 '16 at 6:16

customer_grid_flat table is Blank :( No records. It's 0

– Ankit Shah
Oct 21 '16 at 6:18

Tried to reindex database?

– Khoa TruongDinh
Oct 21 '16 at 6:18

Let me do that static:content-deploy is not going to affect right?

– Ankit Shah
Oct 21 '16 at 6:19

php bin/magento indexer:reindex

– Khoa TruongDinh
Oct 21 '16 at 6:20

Is there any customer from customer_grid_flat table?

– Khoa TruongDinh
Oct 21 '16 at 6:16

customer_grid_flat table is Blank :( No records. It's 0

– Ankit Shah
Oct 21 '16 at 6:18

Tried to reindex database?

– Khoa TruongDinh
Oct 21 '16 at 6:18

Let me do that static:content-deploy is not going to affect right?

– Ankit Shah
Oct 21 '16 at 6:19

php bin/magento indexer:reindex

– Khoa TruongDinh
Oct 21 '16 at 6:20

|
show 2 more comments

2 Answers
2

active

oldest

votes

Reset your databse: Magento 2: Not showing customers in backend grid

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

[EDIT]:

We should use

php bin/magento indexer:rest customer_grid

Possible errors:

--Disable safe mode

update magento.indexer_state set status = 'invalid' where status !=
'valid' Error Code: 1175. You are using safe update mode and you tried
to update a table without a WHERE that uses a KEY column To disable
safe mode, toggle the option in Preferences -> SQL Editor and
reconnect. 0.000 sec

Reference here: https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench

--Not able to run `php bin/magento indexer:reindex customer_grid`

Customer Grid index is locked by another reindex process. Skipping.

show processlist; 

kill "id number";

Or, we can restart mysql server.

--A large number of database - php -dmemory_limit=512M

If you have a large number of database, run the command with

php -dmemory_limit=512M bin/magento indexer:reindex customer_grid

Or should increase the memory_limit ~ 512M in php.ini

edited Dec 6 '18 at 14:41

answered Oct 21 '16 at 8:12

Khoa TruongDinh

21.4k64086

add a comment |

I will NOT recommend to mess with Magento database directly.

Try this:

php bin/magento indexer:reset customer_grid

php bin/magento indexer:reindex customer_grid

answered Jun 28 '17 at 16:14

Alta Works

9111

Thanks @alta-works, your solution is much easy and straight forward.

– Mohit Kumar Arora
Sep 6 '17 at 7:12

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');

var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);

});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f141964%2fmagento-2-admin-customer-listing-not-displaying-record%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

Reset your databse: Magento 2: Not showing customers in backend grid

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

[EDIT]:

We should use

php bin/magento indexer:rest customer_grid

Possible errors:

--Disable safe mode

update magento.indexer_state set status = 'invalid' where status !=
'valid' Error Code: 1175. You are using safe update mode and you tried
to update a table without a WHERE that uses a KEY column To disable
safe mode, toggle the option in Preferences -> SQL Editor and
reconnect. 0.000 sec

Reference here: https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench

--Not able to run `php bin/magento indexer:reindex customer_grid`

Customer Grid index is locked by another reindex process. Skipping.

show processlist; 

kill "id number";

Or, we can restart mysql server.

--A large number of database - php -dmemory_limit=512M

If you have a large number of database, run the command with

php -dmemory_limit=512M bin/magento indexer:reindex customer_grid

Or should increase the memory_limit ~ 512M in php.ini

edited Dec 6 '18 at 14:41

answered Oct 21 '16 at 8:12

Khoa TruongDinh

21.4k64086

add a comment |

Reset your databse: Magento 2: Not showing customers in backend grid

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

[EDIT]:

We should use

php bin/magento indexer:rest customer_grid

Possible errors:

--Disable safe mode

update magento.indexer_state set status = 'invalid' where status !=
'valid' Error Code: 1175. You are using safe update mode and you tried
to update a table without a WHERE that uses a KEY column To disable
safe mode, toggle the option in Preferences -> SQL Editor and
reconnect. 0.000 sec

Reference here: https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench

--Not able to run `php bin/magento indexer:reindex customer_grid`

Customer Grid index is locked by another reindex process. Skipping.

show processlist; 

kill "id number";

Or, we can restart mysql server.

--A large number of database - php -dmemory_limit=512M

If you have a large number of database, run the command with

php -dmemory_limit=512M bin/magento indexer:reindex customer_grid

Or should increase the memory_limit ~ 512M in php.ini

edited Dec 6 '18 at 14:41

answered Oct 21 '16 at 8:12

Khoa TruongDinh

21.4k64086

add a comment |

Reset your databse: Magento 2: Not showing customers in backend grid

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

[EDIT]:

We should use

php bin/magento indexer:rest customer_grid

Possible errors:

--Disable safe mode

update magento.indexer_state set status = 'invalid' where status !=
'valid' Error Code: 1175. You are using safe update mode and you tried
to update a table without a WHERE that uses a KEY column To disable
safe mode, toggle the option in Preferences -> SQL Editor and
reconnect. 0.000 sec

Reference here: https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench

--Not able to run `php bin/magento indexer:reindex customer_grid`

Customer Grid index is locked by another reindex process. Skipping.

show processlist; 

kill "id number";

Or, we can restart mysql server.

--A large number of database - php -dmemory_limit=512M

If you have a large number of database, run the command with

php -dmemory_limit=512M bin/magento indexer:reindex customer_grid

Or should increase the memory_limit ~ 512M in php.ini

edited Dec 6 '18 at 14:41

answered Oct 21 '16 at 8:12

Khoa TruongDinh

21.4k64086

Reset your databse: Magento 2: Not showing customers in backend grid

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

[EDIT]:

We should use

php bin/magento indexer:rest customer_grid

Possible errors:

--Disable safe mode

update magento.indexer_state set status = 'invalid' where status !=
'valid' Error Code: 1175. You are using safe update mode and you tried
to update a table without a WHERE that uses a KEY column To disable
safe mode, toggle the option in Preferences -> SQL Editor and
reconnect. 0.000 sec

Reference here: https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench

--Not able to run `php bin/magento indexer:reindex customer_grid`

Customer Grid index is locked by another reindex process. Skipping.

show processlist; 

kill "id number";

Or, we can restart mysql server.

--A large number of database - php -dmemory_limit=512M

If you have a large number of database, run the command with

php -dmemory_limit=512M bin/magento indexer:reindex customer_grid

Or should increase the memory_limit ~ 512M in php.ini

edited Dec 6 '18 at 14:41

answered Oct 21 '16 at 8:12

Khoa TruongDinh

21.4k64086

edited Dec 6 '18 at 14:41

answered Oct 21 '16 at 8:12

Khoa TruongDinh

21.4k64086

answered Oct 21 '16 at 8:12

Khoa TruongDinh

21.4k64086

answered Oct 21 '16 at 8:12

Khoa TruongDinh

21.4k64086

add a comment |

I will NOT recommend to mess with Magento database directly.

Try this:

php bin/magento indexer:reset customer_grid

php bin/magento indexer:reindex customer_grid

answered Jun 28 '17 at 16:14

Alta Works

9111

Thanks @alta-works, your solution is much easy and straight forward.

– Mohit Kumar Arora
Sep 6 '17 at 7:12

add a comment |

I will NOT recommend to mess with Magento database directly.

Try this:

php bin/magento indexer:reset customer_grid

php bin/magento indexer:reindex customer_grid

answered Jun 28 '17 at 16:14

Alta Works

9111

Thanks @alta-works, your solution is much easy and straight forward.

– Mohit Kumar Arora
Sep 6 '17 at 7:12

add a comment |

I will NOT recommend to mess with Magento database directly.

Try this:

php bin/magento indexer:reset customer_grid

php bin/magento indexer:reindex customer_grid

answered Jun 28 '17 at 16:14

Alta Works

9111

I will NOT recommend to mess with Magento database directly.

Try this:

php bin/magento indexer:reset customer_grid

php bin/magento indexer:reindex customer_grid

answered Jun 28 '17 at 16:14

Alta Works

9111

answered Jun 28 '17 at 16:14

Alta Works

9111

answered Jun 28 '17 at 16:14

Alta Works

9111

answered Jun 28 '17 at 16:14

Alta Works

9111

Thanks @alta-works, your solution is much easy and straight forward.

– Mohit Kumar Arora
Sep 6 '17 at 7:12

add a comment |

Thanks @alta-works, your solution is much easy and straight forward.

– Mohit Kumar Arora
Sep 6 '17 at 7:12

Thanks @alta-works, your solution is much easy and straight forward.

– Mohit Kumar Arora
Sep 6 '17 at 7:12

add a comment |

draft saved

draft discarded

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.

draft saved

draft discarded

Sign up or log in

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

Post as a guest

Name

Required, but never shown

Sign up or log in

Post as a guest

Name

Required, but never shown

Sign up or log in

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Orsdxy