Details
-
Bug
-
Resolution: Fixed
-
Critical
-
7.1.0
-
CBS-7.1.0-2506
-
Untriaged
-
Centos 64-bit
-
1
-
Yes
Description
When building index on 5% KV RR, indexes are getting errored out.
Steps to reproduce:
- Create a single node cluster with KV:N1QL:INDEX services
- Create a collection and load data to have 5% RR on MAGMA Bucket
- Create 5 equivalent indexes with defer build
2022-03-22 23:40:22 | INFO | MainProcess | test_thread | [tuq_helper.run_cbq_query] RUN QUERY CREATE INDEX `idx_0` ON default:test_bucket.test_scope_1.test_collection_1(age) USING GSI WITH {'defer_build': True}
2022-03-22 23:40:22 | INFO | MainProcess | test_thread | [rest_client.query_tool] query params : statement=CREATE+INDEX+%60idx_0%60+ON+default%3Atest_bucket.test_scope_1.test_collection_1%28age%29+USING+GSI++WITH+%7B%27defer_build%27%3A+True%7D
2022-03-22 23:40:24 | INFO | MainProcess | test_thread | [tuq_helper.run_cbq_query] TOTAL ELAPSED TIME: 1.731203413s
2022-03-22 23:40:24 | INFO | MainProcess | test_thread | [tuq_helper.run_cbq_query] RUN QUERY CREATE INDEX `idx_1` ON default:test_bucket.test_scope_1.test_collection_1(age) USING GSI WITH {'defer_build': True}
2022-03-22 23:40:24 | INFO | MainProcess | test_thread | [rest_client.query_tool] query params : statement=CREATE+INDEX+%60idx_1%60+ON+default%3Atest_bucket.test_scope_1.test_collection_1%28age%29+USING+GSI++WITH+%7B%27defer_build%27%3A+True%7D
2022-03-22 23:40:25 | INFO | MainProcess | test_thread | [tuq_helper.run_cbq_query] TOTAL ELAPSED TIME: 1.815875677s
2022-03-22 23:40:25 | INFO | MainProcess | test_thread | [tuq_helper.run_cbq_query] RUN QUERY CREATE INDEX `idx_2` ON default:test_bucket.test_scope_1.test_collection_1(age) USING GSI WITH {'defer_build': True}
2022-03-22 23:40:25 | INFO | MainProcess | test_thread | [rest_client.query_tool] query params : statement=CREATE+INDEX+%60idx_2%60+ON+default%3Atest_bucket.test_scope_1.test_collection_1%28age%29+USING+GSI++WITH+%7B%27defer_build%27%3A+True%7D
2022-03-22 23:40:27 | INFO | MainProcess | test_thread | [tuq_helper.run_cbq_query] TOTAL ELAPSED TIME: 1.958516768s
2022-03-22 23:40:27 | INFO | MainProcess | test_thread | [tuq_helper.run_cbq_query] RUN QUERY CREATE INDEX `idx_3` ON default:test_bucket.test_scope_1.test_collection_1(age) USING GSI WITH {'defer_build': True}
2022-03-22 23:40:27 | INFO | MainProcess | test_thread | [rest_client.query_tool] query params : statement=CREATE+INDEX+%60idx_3%60+ON+default%3Atest_bucket.test_scope_1.test_collection_1%28age%29+USING+GSI++WITH+%7B%27defer_build%27%3A+True%7D
2022-03-22 23:40:29 | INFO | MainProcess | test_thread | [tuq_helper.run_cbq_query] TOTAL ELAPSED TIME: 1.202450683s
2022-03-22 23:40:29 | INFO | MainProcess | test_thread | [tuq_helper.run_cbq_query] RUN QUERY CREATE INDEX `idx_4` ON default:test_bucket.test_scope_1.test_collection_1(age) USING GSI WITH {'defer_build': True}
- Run Build indexes query for 2 out of 5 indexes and then run build index query for all indexes
- Check in the UI, Build for 3 indexes are errored out while initial build for 2 indexes continue to make progress.
Logs are available at - s3://cb-customers-secure/magma_index_error/2022-03-23/collectinfo-2022-03-23t070108-ns_1@172.23.100.38.zip
Attachments
Issue Links
- relates to
-
MB-51573 [CLONE] [MAGMA] Need StorageBackend Info in terseBucket endpoint
- Closed