Details
-
Bug
-
Resolution: Fixed
-
Critical
-
6.6.2
-
CBS-7.0.0-4732
-
Triaged
-
1
-
Unknown
Description
Running drop query for indexes which are in schedule state may or may not cause drop of Index.
Steps to reproduce:
- Create 1 node cluster with kv-n1ql-index service
- create a named collection and load around 10k docs to it.
- create around 10 indexes in parallel so that so goes to schedule state.
- Identify schedule indexes and run drop index query for them.
- Wait for all indexes to come online and validate only indexes which were not drop are available.
2021-03-24 18:19:50 | INFO | MainProcess | test_thread | [tuq_helper.run_cbq_query] RUN QUERY drop index idx_6 on default:test_bucket.test_scope_1.test_collection_1
|
2021-03-24 18:19:50 | INFO | MainProcess | test_thread | [rest_client.query_tool] query params : statement=drop+index+idx_6+on+default%3Atest_bucket.test_scope_1.test_collection_1
|
2021-03-24 18:19:51 | INFO | MainProcess | test_thread | [tuq_helper.run_cbq_query] TOTAL ELAPSED TIME: 1.667027292s
|
2021-03-24 18:19:53 | INFO | MainProcess | test_thread | [tuq_helper.run_cbq_query] RUN QUERY drop index idx_7 on default:test_bucket.test_scope_1.test_collection_1
|
2021-03-24 18:19:53 | INFO | MainProcess | test_thread | [rest_client.query_tool] query params : statement=drop+index+idx_7+on+default%3Atest_bucket.test_scope_1.test_collection_1
|
2021-03-24 18:19:53 | INFO | MainProcess | test_thread | [tuq_helper.run_cbq_query] TOTAL ELAPSED TIME: 411.474928ms
|
system:indexes
[{'indexes': {'bucket_id': 'test_bucket', 'datastore_id': 'http://127.0.0.1:8091', 'id': '1b0c1e9b7be08363', 'index_key': ['`title`'], 'keyspace_id': 'test_collection_1', 'name': 'idx_3', 'namespace_id': 'default', 'scope_id': 'test_scope_1', 'state': 'online', 'using': 'gsi'}}, {'indexes': {'bucket_id': 'test_bucket', 'datastore_id': 'http://127.0.0.1:8091', 'id': '9397a7efc919a145', 'index_key': ['`phone`'], 'keyspace_id': 'test_collection_1', 'name': 'idx_9', 'namespace_id': 'default', 'scope_id': 'test_scope_1', 'state': 'online', 'using': 'gsi'}}, {'indexes': {'bucket_id': 'test_bucket', 'datastore_id': 'http://127.0.0.1:8091', 'id': 'f15056f2643fb40d', 'index_key': ['`suffix`'], 'keyspace_id': 'test_collection_1', 'name': 'idx_7', 'namespace_id': 'default', 'scope_id': 'test_scope_1', 'state': 'online', 'using': 'gsi'}}, {'indexes': {'bucket_id': 'test_bucket', 'datastore_id': 'http://127.0.0.1:8091', 'id': 'ed30d6c637db2165', 'index_key': ['`age`'], 'keyspace_id': 'test_collection_1', 'name': 'idx_0', 'namespace_id': 'default', 'scope_id': 'test_scope_1', 'state': 'online', 'using': 'gsi'}}, {'indexes': {'bucket_id': 'test_bucket', 'datastore_id': 'http://127.0.0.1:8091', 'id': '990e69ef2b6dc353', 'index_key': ['`lastName`'], 'keyspace_id': 'test_collection_1', 'name': 'idx_5', 'namespace_id': 'default', 'scope_id': 'test_scope_1', 'state': 'online', 'using': 'gsi'}}, {'indexes': {'bucket_id': 'test_bucket', 'datastore_id': 'http://127.0.0.1:8091', 'id': '185eb55737a1aadf', 'index_key': ['`streetAddress`'], 'keyspace_id': 'test_collection_1', 'name': 'idx_6', 'namespace_id': 'default', 'scope_id': 'test_scope_1', 'state': 'online', 'using': 'gsi'}}]
|