phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anupama agarwal <anu1...@gmail.com>
Subject Global Index stuck in BUILDING state
Date Tue, 10 May 2016 01:56:41 GMT
Hi All,

I have a query, I created global index on table of 10,000,000 records. My
global index's state is stuck at "BUILDING". I have tried running this
query :

*alter index accrual_client_ref_id_type_idx on apl_accrual_service.accruals
USABLE; *
which says the same.

The  global index has 10k rows less than main table.  What are my options
to fix this? Do I have to rebuild the index to fix this?

Mime
View raw message