Customer Grid is showing empty or blank in magento 2

Customer Grid is showing empty or blank in magento 2:

Some times customer grid will show empty or blank in magento2 admin section

when you redirect to customer grid. This is because of re-indexing. By 

default magento customer grid is coming under the re-indexing module. When 

you do the re-indexing using terminal we may come to know the customer grid

re-indexing .This option is not in magento1.x. In case if your re-indexing 

is not properly complete then we may get this issue. 


Other re-index will work perfect but only customer grid get stopped or not 

re-indexing fully)Your data will be available in DB but your customer data 

won't be available on Customer Grid table (empty) in that scenario grid    

will show empty.


Resolve:
 1. Using below mysql query we come to know customer record is available on

DB main tables or not. (If here its empty then you loose your customer     

records) select * from customer_entity limit 10;

2. Using below query we come to know customer record is available on 

customer grid table or not. If empty with table then your customer grid 

will blank or empty. select * from customer_grid_flat limit 10;

3. Using below query check to your reindexing table status.

select * from indexer_state;

4.Update your re-index status (Check in case if customer admin grid 

re-index status is working or valid

update indexer_state set status='invalid' where status ='working'

5. Run once again re-indexing.

php bin/magento indexer:reindex

6. Now you will get admin customer grid

Some times when you do re-index you may get memory issue.

Then use below command and change memory size (based on your server) & run

php -d memory_limit=1024M bin/magento indexer:reindex

 (or)

php -d memory_limit=2084M bin/magento indexer:reindex

CORNER OF BLOG:

“SAVE Agriculture !!! No Food without SOIL.“