SNAPSHOT and CURRENT browser query returns different results when query limit is enabled.

SNAPSHOT and CURRENT browser query returns different results when query limit is enabled.

book

Article ID: KB0094200

calendar_today

Updated On:

Products Versions
TIBCO ActiveSpaces -
Not Applicable -

Description

Resolution:
SNAPSHOT and CURRENT Browser query returns a different number of tuples when query limit is enabled and filter matches more tuples as specified in the query limit.

as-admin commands:
show space "List" entries filter "id1='10K'" query_limit 10000 timescope "CURRENT"  -> returns 10000
show space "List" entries filter "id1='10K'" query_limit 10000 timescope "SNAPSHOT" -> returns 9979

The query_limit only works for CURRENT timescope and it is not an accurate value, which means if you want to return 10K it might return a number around 10K. Also, if there are only 10k matching entries in the cluster, then it is possible that the number of tuples returned would be less than 10k due to the distribution of the tuples in the cluster. With a query limit of 10k, each seeder is sent the query limit of 10k of seeders. There would be a deviation in the number of entries per seeder.

Issue/Introduction

SNAPSHOT and CURRENT browser query returns different results when query limit is enabled.

Environment

Product: TIBCO ActiveSpaces Version: All versions OS: All Supported Operating Systems --------------------