Details
-
Bug
-
Resolution: Fixed
-
Blocker
-
4.0.0
-
Security Level: Public
-
None
-
4.0.0-2098
-
Untriaged
-
Centos 64-bit
-
-
No
Description
./testrunner -i temp.ini -t 2i.indexscans_2i.SecondaryIndexingScanTests.test_multi_create_query_explain_drop_index_scan_consistency_with_where_clause,groups=simple,dataset=default,doc-per-day=20,use_gsi_for_primary=True,index_quota_percent=60,skip_cleanup=True,nodes_init=4,services_init=n1ql:kv-kv:index-index-index,doc-per-day=20,sasl_buckets=3,standard_buckets=3,use_gsi_for_secondary=True
1. Create a 4 node cluster (1:n1ql+kv,2:kv+index,3:index,4:index) - Index RAM quota is set of 60% of data ram quota
2. Create 7 buckets
3. Create 40320 documents to 7 buckets
4. Create primary index using GSI
5. Create secondary index using GSI - 3 for each bucket
6. Wait for indexing to finish, it has been over an hour that I have waited for index to finish.
a) Check for indexing status, the indexer is stuck at indexing at these 6 buckets for over an hour.
Ritams-MacBook-Pro:testrunner rsharma$ curl -u Administrator:password 172.23.106.75:8093/query -d 'statement=select * from system:indexes where state="pending"'
{
"requestID": "d64b958b-38b4-4b28-8374-231bde330200",
"signature":
,
"results": [
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
}
],
"status": "success",
"metrics":
}
2) Few more indexing stats:
Ritams-MBP:testrunner rsharma$ curl -u Administrator:password http://172.23.106.77:9102/stats | json_pp | grep build_p
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 6870 0 6870 0 0 11070 0 -::- -::- -::- 11062
"standard_bucket2:#primary:build_progress" : 100,
"bucket1:#primary:build_progress" : 100,
"standard_bucket2:simple_index_2:build_progress" : 50,
"default:#primary:build_progress" : 100,
"bucket2:simple_index_2:build_progress" : 100,
"standard_bucket1:simple_index_2:build_progress" : 100,
"standard_bucket0:simple_index_2:build_progress" : 100,
"default:simple_index_2:build_progress" : 50,
"bucket0:simple_index_2:build_progress" : 100,
"bucket1:simple_index_2:build_progress" : 50,
Ritams-MBP:testrunner rsharma$ date
Wed May 13 16:57:56 IST 2015
Ritams-MBP:testrunner rsharma$ curl -u Administrator:password http://172.23.106.77:9102/stats | json_pp | grep build_p
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 6870 0 6870 0 0 9920 0 -::- -::- -::- 9913
"standard_bucket2:simple_index_2:build_progress" : 50,
"standard_bucket2:#primary:build_progress" : 100,
"default:simple_index_2:build_progress" : 50,
"default:#primary:build_progress" : 100,
"standard_bucket1:simple_index_2:build_progress" : 100,
"bucket1:#primary:build_progress" : 100,
"bucket0:simple_index_2:build_progress" : 100,
"bucket2:simple_index_2:build_progress" : 100,
"standard_bucket0:simple_index_2:build_progress" : 100,
"bucket1:simple_index_2:build_progress" : 50
Observe -
"default:simple_index_2:build_progress" : 50
"bucket1:simple_index_2:build_progress" : 50
- it is stuck at 50% for over 40 minutes.
Attachments
Issue Links
- relates to
-
MB-14834 Incorrect scan output from an index built after dropping other building indexes (TestDropMultipleBuildingDeferredIndexes)
- Closed