question

376752150_179413 avatar image
376752150_179413 asked 376752150_179413 answered

Why does the query "select ... WHERE TOKEN(uid)>-8474455431603971223 LIMIT 80;" time out?

SELECT TOKEN(uid),other columns,uid FROM uid2jtis WHERE TOKEN(uid)>-8474455431603971223 LIMIT 80;

returns timeout error below:

ReadTimeout: Error from server: code=1200 [Coordinator node timed out waiting for replica nodes' responses] message="Operation timed out - received only 0 responses." info={'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'}


However,

SELECT TOKEN(uid),other columns,uid FROM uid2jtis WHERE TOKEN(uid)>-8474455431603971223 LIMIT 79;

succeed.

Any insights would be much appreciated!

token
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

376752150_179413 avatar image
376752150_179413 answered

Thanks @Lewisr650's reply.

The reason is the data file is corrupted....

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Lewisr650 avatar image
Lewisr650 answered

This is a function of the fact that you are performing a range query across a large number of Tokens and it can't complete the scan in less than 10 seconds. What is the timing when you do this for 79?

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.