Details
-
Bug
-
Resolution: Unresolved
-
Major
-
7.6.0
-
Untriaged
-
0
-
Unknown
Description
build - 7.1.6-3955 to 7.6.0-1945
index node - 172.23.107.212, 172.23.106.49
zstd compression - zstd10
Steps to repro
- Cluster - kv:n1ql-index-index
- Load some data and create buckets and indexes
- Assume the two index nodes to be node A and node B
- Create indexes on node A (should be using snappy compression)
- Upgrade node B to 7.6 via offline upgrade
- Create indexes on node B (should be using zstd compression)
- Upgrade node A (should continue to using snappy compression)
- Compare the compression ratio of the indexes in node A and node B. Ideally indexes on node A should have lesser compression ratio compared to node B
Compression ratio comparison between indexes on node A and node B
Node A : #primary_RKFHHGQZCW:4.30828 Node B : #primary_1DTBU5MYMO:9.78099 |
Node A : idx_Q65JY7CKCR_batch_1_array_index_checkin:3.11629 Node B : idx_IV41BUHLWC_batch_1_array_index_checkin:2.99535 |
Node A : idx_Q65JY7CKCR_batch_1_array_index_overall:8.22024 Node B : idx_IV41BUHLWC_batch_1_array_index_overall:8.69605 |
Node A : idx_Q65JY7CKCR_batch_1_array_index_rooms:8.23001 Node B : idx_IV41BUHLWC_batch_1_array_index_rooms:8.07018 |
Node A : idx_Q65JY7CKCR_batch_1_flatten_keys:3.19025 Node B : idx_IV41BUHLWC_batch_1_flatten_keys:3.26026 |
Node A : idx_Q65JY7CKCR_batch_1_free_breakfast_array_count:4.51143 Node B : idx_IV41BUHLWC_batch_1_free_breakfast_array_count:4.45579 |
Node A : idx_Q65JY7CKCR_batch_1_free_breakfast_avg_rating:11.90594 Node B : idx_IV41BUHLWC_batch_1_free_breakfast_avg_rating:11.4727 |
Node A : idx_Q65JY7CKCR_batch_1_missing_keys:3.57286 Node B : idx_IV41BUHLWC_batch_1_missing_keys:3.56991 |
Node A : idx_Q65JY7CKCR_batch_1_partitioned_index:3.46814 Node B : idx_IV41BUHLWC_batch_1_partitioned_index:3.54154 |
Node A : idx_Q65JY7CKCR_batch_1_price:8.58649 Node B : idx_IV41BUHLWC_batch_1_price:8.47492 |
Logs:
https://cb-engineering.s3.amazonaws.com/yash-test-rebalnce/collectinfo-2023-12-21T124055-ns_1%40172.23.106.49.zip
https://cb-engineering.s3.amazonaws.com/yash-test-rebalnce/collectinfo-2023-12-21T124055-ns_1%40172.23.107.212.zip
https://cb-engineering.s3.amazonaws.com/yash-test-rebalnce/collectinfo-2023-12-21T124055-ns_1%40172.23.109.26.zip