Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Paginator returning less data than actually have #159

Open
caevv opened this issue Feb 9, 2024 · 4 comments
Open

Paginator returning less data than actually have #159

caevv opened this issue Feb 9, 2024 · 4 comments
Assignees
@dkropachev
Labels
triage

Comments

@caevv
Copy link

caevv commented Feb 9, 2024 •
edited
Loading

Please answer these questions before submitting your issue. Thanks!

What version of Scylla or Cassandra are you using?

Scylla 5.2.15

What version of Gocql are you using?

1.12.0

What version of Go are you using?

1.21

I am experiencing an issue with pagination. Despite there being more data to fetch using PageSize() will return a value smaller than what is set, iter.PageState() will have some data, but calling with the returned token on PageState will return empty data, but I know there are more rows in the table.

iter := r.db.Query(
		`SELECT a, b, c, d FROM table WHERE g = ? AND h = false ORDER BY x DESC, y ASC USING TIMEOUT 10s`,
	scripthash,
).
	WithContext(ctx).
	PageSize(int(pageSize)).
	PageState(token).
	Iter()
defer iter.Close()

scanner := iter.Scanner()

for scanner.Next() {
	//code
}

if err := scanner.Err(); err != nil {
	return nil, "", fmt.Errorf("failed to scan: %w", err)
}

nextPageToken := iter.PageState()
  • pageSize is set to 1000.
  • token variables are appropriately set.

Additional Observations:

  • Running the same query in ScyllaDB's terminal (cqlsh) shows all the data. However, it takes a long time (2-3 minutes) to return the remaining rows, indicating a potential performance issue.
  • is a materialized view
  • No errors are reported from the Iter() function.
  • The table size is approximately 4TB.

    • Attempted Solutions:

    • Experimented with different pageSize values.
    • Reviewed ScyllaDB configuration and logs for relevant settings or errors.

    Questions/Help Needed:

    • Is there a known issue with pagination in gocql with large datasets?
    • Any suggestions on configurations or approaches to handle such large-scale data pagination efficiently?

    Any insights or suggestions from the community would be greatly appreciated. Thank you!
@caevv caevv changed the title Empty PageState() in Golang with Large Dataset Pagination Empty PageState() iterator even when more data is available Feb 10, 2024
@caevv caevv changed the title Empty PageState() iterator even when more data is available Paginator returning less data than actually have Feb 10, 2024
@avikivity
Copy link
Member

ScyllaDB may return a smaller page than requested in order to avoid high memory usage. This can happen if

  • your rows are large
  • you selected a large page size
  • you have a lot of tombstones that need to be skipped

This is normal and shouldn't present a performance problem. It does add latency, but scans should be performed in parallel so the server has other queries to process while the data is in transit.

@caevv
Copy link
Author

caevv commented Feb 12, 2024

Thanks for the reply @avikivity.

  • I know the table has a very large qty of rows but they are just a few bytes of data in each row. Moreover, the filter = false in my query will decrease the total expected data to just a couple hundred rows.
  • I also tried to select a page size of 20 rows and keep running the next page token, but still missing the same data as always. At the very end I run with the new PageState and returns no rows.
  • Regarding tombstone:
nodetool tablestats 
$ nodetool tablestats | grep tombstones
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0

Adding more context for the table and view:

CREATE TABLE main_table (
    data_1 text,
    data_2 int,
    data_3 text,
    data_4 int,
    data_5 int,
    my_filter boolean,
    PRIMARY KEY ((data_3, data_4), data_1, data_4, data_5)
);

CREATE MATERIALIZED VIEW view_from_main_table AS
    SELECT data_1, data_3, data_4, data_5, my_filter, data_5 FROM main_table
WHERE <fields not null>
PRIMARY KEY ((data_1), my_filter, data_4, data_5, data_1, data_2)
WITH CLUSTERING ORDER BY (data_5 DESC, data_4 ASC);

I also tried to run with tracing, I'm supposed to have 207 rows in the following query, running with LIMIT 205 is fine, but running with LIMIT 206 will take a huge long time:

Running query with tracing 
cqlsh:keypace> SELECT data_3, data_4, data_5 FROM view_from_main_table WHERE data_1 = ? AND my_filter = false ORDER BY data_5 DESC, data_4 ASC LIMIT 206;

<100 rows returned>

---MORE---
<100 rows returned>

---MORE---
<5 rows returned>

---MORE---
---MORE---
---MORE---
---MORE---
---MORE---
---MORE---
---MORE---
---MORE---
---MORE---
---MORE---
---MORE---
---MORE---
---MORE---
---MORE---
---MORE---
<1 rows returned after around 30 minutes>
(206 rows)

Tracing session: b0723330-c98d-11ee-a3c6-9d5b08422bb1

activity                                                                                                                                                                                                                        | timestamp                  | source        | source_elapsed | client
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                            Execute CQL3 query | 2024-02-12 10:01:28.291000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                Parsing a statement [shard 51] | 2024-02-12 10:01:28.291539 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                             Processing a statement [shard 51] | 2024-02-12 10:01:28.291643 | 172.28.94.200 |            103 | 127.0.0.1
                                                                                     Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 51] | 2024-02-12 10:01:28.291688 | 172.28.94.200 |            148 | 127.0.0.1
                                                                                                                                                                                        read_data: querying locally [shard 51] | 2024-02-12 10:01:28.291691 | 172.28.94.200 |            152 | 127.0.0.1
                    Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:01:28.291804 | 172.28.94.200 |              8 | 127.0.0.1
Querying cache for range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} and slice {{ckp{000100}}} [shard 2] | 2024-02-12 10:01:28.291827 | 172.28.94.200 |             31 | 127.0.0.1
                                                                                     Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 100 clustering row(s) (100 live, 0 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:01:28.292011 | 172.28.94.200 |            216 | 127.0.0.1
                                                                                                                                                       Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:01:28.292018 | 172.28.94.200 |            222 | 127.0.0.1
                                                                                                                                                                                                    Querying is done [shard 2] | 2024-02-12 10:01:28.292019 | 172.28.94.200 |            223 | 127.0.0.1
                                                                                                                                                                               Done processing - preparing a result [shard 51] | 2024-02-12 10:01:28.292048 | 172.28.94.200 |            509 | 127.0.0.1
                                                                                                                                                                                                              Request complete | 2024-02-12 10:01:28.291587 | 172.28.94.200 |            587 | 127.0.0.1



Tracing session: b0f5e220-c98d-11ee-810f-9d4308422bb1

activity                                                                                                                                                                                                                                                      | timestamp                  | source        | source_elapsed | client
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                          Execute CQL3 query | 2024-02-12 10:01:29.154000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                               Parsing a statement [shard 6] | 2024-02-12 10:01:29.154773 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                            Processing a statement [shard 6] | 2024-02-12 10:01:29.154860 | 172.28.94.200 |             87 | 127.0.0.1
                                                                                                                    Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 6] | 2024-02-12 10:01:29.154901 | 172.28.94.200 |            128 | 127.0.0.1
                                                                                                                                                                                                                       read_data: querying locally [shard 6] | 2024-02-12 10:01:29.154903 | 172.28.94.200 |            130 | 127.0.0.1
                                                  Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:01:29.155006 | 172.28.94.200 |              7 | 127.0.0.1
Found cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 and range(s) {{{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}}} [shard 2] | 2024-02-12 10:01:29.155013 | 172.28.94.200 |             14 | 127.0.0.1
                                                                                                                                                                                                                                   Reusing querier [shard 2] | 2024-02-12 10:01:29.155017 | 172.28.94.200 |             18 | 127.0.0.1
                                                                                                                   Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 100 clustering row(s) (100 live, 0 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:01:29.155154 | 172.28.94.200 |            155 | 127.0.0.1
                                                                                                                                                                                     Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:01:29.155157 | 172.28.94.200 |            158 | 127.0.0.1
                                                                                                                                                                                                                                  Querying is done [shard 2] | 2024-02-12 10:01:29.155159 | 172.28.94.200 |            160 | 127.0.0.1
                                                                                                                                                                                                              Done processing - preparing a result [shard 6] | 2024-02-12 10:01:29.155396 | 172.28.94.200 |            623 | 127.0.0.1
                                                                                                                                                                                                                                            Request complete | 2024-02-12 10:01:29.154689 | 172.28.94.200 |            689 | 127.0.0.1



Tracing session: b140cdd0-c98d-11ee-a60c-9d6c08422bb1

activity                                                                                                                                                                                                                                                      | timestamp                  | source        | source_elapsed | client
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                          Execute CQL3 query | 2024-02-12 10:01:29.645000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                              Parsing a statement [shard 36] | 2024-02-12 10:01:29.645661 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                           Processing a statement [shard 36] | 2024-02-12 10:01:29.645744 | 172.28.94.200 |             83 | 127.0.0.1
                                                                                                                   Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 36] | 2024-02-12 10:01:29.645783 | 172.28.94.200 |            122 | 127.0.0.1
                                                                                                                                                                                                                      read_data: querying locally [shard 36] | 2024-02-12 10:01:29.645785 | 172.28.94.200 |            124 | 127.0.0.1
                                                  Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:01:29.645902 | 172.28.94.200 |              6 | 127.0.0.1
Found cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 and range(s) {{{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}}} [shard 2] | 2024-02-12 10:01:29.645909 | 172.28.94.200 |             12 | 127.0.0.1
                                                                                                                                                                                                                                   Reusing querier [shard 2] | 2024-02-12 10:01:29.645913 | 172.28.94.200 |             16 | 127.0.0.1
                                                                                                               Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10005 clustering row(s) (5 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:01:29.653716 | 172.28.94.200 |           7820 | 127.0.0.1
                                                                                                                                                                                     Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:01:29.653744 | 172.28.94.200 |           7847 | 127.0.0.1
                                                                                                                                                                                                                                  Querying is done [shard 2] | 2024-02-12 10:01:29.653745 | 172.28.94.200 |           7849 | 127.0.0.1
                                                                                                                                                                                                             Done processing - preparing a result [shard 36] | 2024-02-12 10:01:29.653972 | 172.28.94.200 |           8311 | 127.0.0.1
                                                                                                                                                                                                                                            Request complete | 2024-02-12 10:01:29.653330 | 172.28.94.200 |           8330 | 127.0.0.1



Tracing session: b1b7f9a0-c98d-11ee-8ce3-9d7008422bb1

activity                                                                                                                                                                                                                                                      | timestamp                  | source        | source_elapsed | client
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                          Execute CQL3 query | 2024-02-12 10:01:30.426000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                              Parsing a statement [shard 59] | 2024-02-12 10:01:30.426438 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                           Processing a statement [shard 59] | 2024-02-12 10:01:30.426631 | 172.28.94.200 |            193 | 127.0.0.1
                                                                                                                   Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 59] | 2024-02-12 10:01:30.426739 | 172.28.94.200 |            301 | 127.0.0.1
                                                                                                                                                                                                                      read_data: querying locally [shard 59] | 2024-02-12 10:01:30.426742 | 172.28.94.200 |            304 | 127.0.0.1
                                                  Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:01:30.426843 | 172.28.94.200 |              6 | 127.0.0.1
Found cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 and range(s) {{{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}}} [shard 2] | 2024-02-12 10:01:30.426849 | 172.28.94.200 |             12 | 127.0.0.1
                                                                                                                                                                                                                                   Reusing querier [shard 2] | 2024-02-12 10:01:30.426853 | 172.28.94.200 |             16 | 127.0.0.1
                                                                                                               Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10000 clustering row(s) (0 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:01:30.435604 | 172.28.94.200 |           8766 | 127.0.0.1
                                                                                                                                                                                     Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:01:30.435627 | 172.28.94.200 |           8789 | 127.0.0.1
                                                                                                                                                                                                                                  Querying is done [shard 2] | 2024-02-12 10:01:30.435628 | 172.28.94.200 |           8791 | 127.0.0.1
                                                                                                                                                                                                             Done processing - preparing a result [shard 59] | 2024-02-12 10:01:30.435893 | 172.28.94.200 |           9456 | 127.0.0.1
                                                                                                                                                                                                                                            Request complete | 2024-02-12 10:01:30.435466 | 172.28.94.200 |           9466 | 127.0.0.1



Tracing session: eebb7b60-c98d-11ee-97cf-9d5408422bb1

activity                                                                                                                                                                                                                                                                                                                                                                                                                            | timestamp                  | source        | source_elapsed | client
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                                                                                                                                                                                                Execute CQL3 query | 2024-02-12 10:03:12.790000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                    Parsing a statement [shard 31] | 2024-02-12 10:03:12.790231 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                 Processing a statement [shard 31] | 2024-02-12 10:03:12.790340 | 172.28.94.200 |            110 | 127.0.0.1
                                                                                                                                                                                                                                                                                         Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 31] | 2024-02-12 10:03:12.790392 | 172.28.94.200 |            161 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                            read_data: querying locally [shard 31] | 2024-02-12 10:03:12.790395 | 172.28.94.200 |            165 | 127.0.0.1
                                                                                                                                                                                                                        Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:03:12.790521 | 172.28.94.200 |              8 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                    Found no cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:03:12.790527 | 172.28.94.200 |             13 | 127.0.0.1
Querying cache for range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} and slice {{ckp{000100}}, (ckp{0001000004000ca861000400000225004062393531666365646437633032616239323662643435313838393864353731633536313734666432623565666364343034356635343462303464646338323439000400000002}, ckp{000100}]} [shard 2] | 2024-02-12 10:03:12.790549 | 172.28.94.200 |             36 | 127.0.0.1
                                                                                                                                                                                                                                                                                     Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10000 clustering row(s) (0 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:03:12.799119 | 172.28.94.200 |           8606 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                           Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:03:12.799150 | 172.28.94.200 |           8636 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                        Querying is done [shard 2] | 2024-02-12 10:03:12.799152 | 172.28.94.200 |           8639 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                   Done processing - preparing a result [shard 31] | 2024-02-12 10:03:12.799291 | 172.28.94.200 |           9061 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                                  Request complete | 2024-02-12 10:03:12.799072 | 172.28.94.200 |           9072 | 127.0.0.1



Tracing session: 57eccda0-c98e-11ee-a1ef-9d5608422bb1

activity                                                                                                                                                                                                                                                                                                                                                                                                                            | timestamp                  | source        | source_elapsed | client
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                                                                                                                                                                                                Execute CQL3 query | 2024-02-12 10:06:09.274000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                    Parsing a statement [shard 33] | 2024-02-12 10:06:09.274364 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                 Processing a statement [shard 33] | 2024-02-12 10:06:09.274463 | 172.28.94.200 |             98 | 127.0.0.1
                                                                                                                                                                                                                                                                                         Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 33] | 2024-02-12 10:06:09.274508 | 172.28.94.200 |            143 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                            read_data: querying locally [shard 33] | 2024-02-12 10:06:09.274510 | 172.28.94.200 |            145 | 127.0.0.1
                                                                                                                                                                                                                        Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:06:09.274615 | 172.28.94.200 |              7 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                    Found no cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:06:09.274621 | 172.28.94.200 |             13 | 127.0.0.1
Querying cache for range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} and slice {{ckp{000100}}, (ckp{0001000004000ca5ab0004000001bf004032383062373262353935633066353936633434346135336336663162303531356366316538323439323634666535373837363439373838626636313162343563000400000002}, ckp{000100}]} [shard 2] | 2024-02-12 10:06:09.274642 | 172.28.94.200 |             35 | 127.0.0.1
                                                                                                                                                                                                                                                                                     Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10000 clustering row(s) (0 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:06:09.283340 | 172.28.94.200 |           8732 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                           Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:06:09.283368 | 172.28.94.200 |           8761 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                        Querying is done [shard 2] | 2024-02-12 10:06:09.283371 | 172.28.94.200 |           8763 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                   Done processing - preparing a result [shard 33] | 2024-02-12 10:06:09.283523 | 172.28.94.200 |           9159 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                                  Request complete | 2024-02-12 10:06:09.283171 | 172.28.94.200 |           9171 | 127.0.0.1



Tracing session: b108b160-c98e-11ee-8a59-9d3908422bb1

activity                                                                                                                                                                                                                                                                                                                                                                                                                            | timestamp                  | source        | source_elapsed | client
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                                                                                                                                                                                                Execute CQL3 query | 2024-02-12 10:08:38.774000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                    Parsing a statement [shard 18] | 2024-02-12 10:08:38.774888 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                 Processing a statement [shard 18] | 2024-02-12 10:08:38.774994 | 172.28.94.200 |            107 | 127.0.0.1
                                                                                                                                                                                                                                                                                         Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 18] | 2024-02-12 10:08:38.775042 | 172.28.94.200 |            154 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                            read_data: querying locally [shard 18] | 2024-02-12 10:08:38.775045 | 172.28.94.200 |            157 | 127.0.0.1
                                                                                                                                                                                                                        Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:08:38.775177 | 172.28.94.200 |              8 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                    Found no cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:08:38.775183 | 172.28.94.200 |             14 | 127.0.0.1
Querying cache for range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} and slice {{ckp{000100}}, (ckp{0001000004000ca3a7000400000054004061313838326364663063373236626431373965666131303939366337323936646231616437333933373732323766333635363661396161633833336463343336000400000002}, ckp{000100}]} [shard 2] | 2024-02-12 10:08:38.775205 | 172.28.94.200 |             35 | 127.0.0.1
                                                                                                                                                                                                                                                                                     Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10000 clustering row(s) (0 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:08:38.783852 | 172.28.94.200 |           8683 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                           Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:08:38.783882 | 172.28.94.200 |           8713 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                        Querying is done [shard 2] | 2024-02-12 10:08:38.783884 | 172.28.94.200 |           8715 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                   Done processing - preparing a result [shard 18] | 2024-02-12 10:08:38.784061 | 172.28.94.200 |           9174 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                                  Request complete | 2024-02-12 10:08:38.783201 | 172.28.94.200 |           9201 | 127.0.0.1



Tracing session: c590bc40-c98e-11ee-9279-9d6308422bb1

activity                                                                                                                                                                                                                                                                                                                                                                                                                            | timestamp                  | source        | source_elapsed | client
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                                                                                                                                                                                                Execute CQL3 query | 2024-02-12 10:09:13.220000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                    Parsing a statement [shard 53] | 2024-02-12 10:09:13.220316 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                 Processing a statement [shard 53] | 2024-02-12 10:09:13.220426 | 172.28.94.200 |            110 | 127.0.0.1
                                                                                                                                                                                                                                                                                         Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 53] | 2024-02-12 10:09:13.220479 | 172.28.94.200 |            163 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                            read_data: querying locally [shard 53] | 2024-02-12 10:09:13.220482 | 172.28.94.200 |            166 | 127.0.0.1
                                                                                                                                                                                                                        Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:09:13.220616 | 172.28.94.200 |              8 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                    Found no cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:09:13.220623 | 172.28.94.200 |             15 | 127.0.0.1
Querying cache for range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} and slice {{ckp{000100}}, (ckp{0001000004000ca1360004000002c3004035366131636563373538303036313833656661656233656237373132653038333066313664316236366635313835316466663061333438326332346462363063000400000002}, ckp{000100}]} [shard 2] | 2024-02-12 10:09:13.220647 | 172.28.94.200 |             39 | 127.0.0.1
                                                                                                                                                                                                                                                                                     Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10000 clustering row(s) (0 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:09:13.229337 | 172.28.94.200 |           8729 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                           Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:09:13.229367 | 172.28.94.200 |           8758 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                        Querying is done [shard 2] | 2024-02-12 10:09:13.229369 | 172.28.94.200 |           8761 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                   Done processing - preparing a result [shard 53] | 2024-02-12 10:09:13.229513 | 172.28.94.200 |           9197 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                                  Request complete | 2024-02-12 10:09:13.229210 | 172.28.94.200 |           9210 | 127.0.0.1



Tracing session: 0351c1a0-c98f-11ee-83ff-9d6008422bb1

activity                                                                                                                                                                                                                                                                                                                                                                                                                            | timestamp                  | source        | source_elapsed | client
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                                                                                                                                                                                                Execute CQL3 query | 2024-02-12 10:10:56.826000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                    Parsing a statement [shard 49] | 2024-02-12 10:10:56.826262 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                 Processing a statement [shard 49] | 2024-02-12 10:10:56.826364 | 172.28.94.200 |            102 | 127.0.0.1
                                                                                                                                                                                                                                                                                         Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 49] | 2024-02-12 10:10:56.826409 | 172.28.94.200 |            147 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                            read_data: querying locally [shard 49] | 2024-02-12 10:10:56.826411 | 172.28.94.200 |            149 | 127.0.0.1
                                                                                                                                                                                                                        Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:10:56.826543 | 172.28.94.200 |              7 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                    Found no cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:10:56.826549 | 172.28.94.200 |             13 | 127.0.0.1
Querying cache for range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} and slice {{ckp{000100}}, (ckp{0001000004000c9f11000400000274004033363134363338333064383863366332353738666434633838303562383731653130373134346630636537303833663039393666386336653336653036633236000400000000}, ckp{000100}]} [shard 2] | 2024-02-12 10:10:56.826569 | 172.28.94.200 |             32 | 127.0.0.1
                                                                                                                                                                                                                                                                                     Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10000 clustering row(s) (0 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:10:56.835197 | 172.28.94.200 |           8660 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                           Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:10:56.835224 | 172.28.94.200 |           8687 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                        Querying is done [shard 2] | 2024-02-12 10:10:56.835225 | 172.28.94.200 |           8689 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                   Done processing - preparing a result [shard 49] | 2024-02-12 10:10:56.835361 | 172.28.94.200 |           9099 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                                  Request complete | 2024-02-12 10:10:56.835111 | 172.28.94.200 |           9111 | 127.0.0.1



Tracing session: 276220c0-c990-11ee-9136-9d5d08422bb1

activity                                                                                                                                                                                                                                                                                                                                                                                                                            | timestamp                  | source        | source_elapsed | client
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                                                                                                                                                                                                Execute CQL3 query | 2024-02-12 10:19:06.828000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                    Parsing a statement [shard 43] | 2024-02-12 10:19:06.828645 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                 Processing a statement [shard 43] | 2024-02-12 10:19:06.828745 | 172.28.94.200 |            100 | 127.0.0.1
                                                                                                                                                                                                                                                                                         Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 43] | 2024-02-12 10:19:06.828791 | 172.28.94.200 |            146 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                            read_data: querying locally [shard 43] | 2024-02-12 10:19:06.828793 | 172.28.94.200 |            149 | 127.0.0.1
                                                                                                                                                                                                                        Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:19:06.828893 | 172.28.94.200 |              9 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                    Found no cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:19:06.828900 | 172.28.94.200 |             15 | 127.0.0.1
Querying cache for range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} and slice {{ckp{000100}}, (ckp{0001000004000c9d0f000400001f9a004037393632313161356564326132346562396666303862643065303737353061363230613732316565346465303530616335373235383635356661306635396363000400000002}, ckp{000100}]} [shard 2] | 2024-02-12 10:19:06.828922 | 172.28.94.200 |             37 | 127.0.0.1
                                                                                                                                                                                                                                                                                     Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10000 clustering row(s) (0 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:19:06.837500 | 172.28.94.200 |           8616 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                           Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:19:06.837530 | 172.28.94.200 |           8645 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                        Querying is done [shard 2] | 2024-02-12 10:19:06.837532 | 172.28.94.200 |           8647 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                   Done processing - preparing a result [shard 43] | 2024-02-12 10:19:06.837668 | 172.28.94.200 |           9023 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                                  Request complete | 2024-02-12 10:19:06.837034 | 172.28.94.200 |           9034 | 127.0.0.1



Tracing session: 2777cba0-c990-11ee-a3c6-9d5b08422bb1

activity                                                                                                                                                                                                                                                      | timestamp                  | source        | source_elapsed | client
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                          Execute CQL3 query | 2024-02-12 10:19:06.970000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                              Parsing a statement [shard 51] | 2024-02-12 10:19:06.970341 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                           Processing a statement [shard 51] | 2024-02-12 10:19:06.970408 | 172.28.94.200 |             67 | 127.0.0.1
                                                                                                                   Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 51] | 2024-02-12 10:19:06.970442 | 172.28.94.200 |            101 | 127.0.0.1
                                                                                                                                                                                                                      read_data: querying locally [shard 51] | 2024-02-12 10:19:06.970444 | 172.28.94.200 |            103 | 127.0.0.1
                                                  Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:19:06.970548 | 172.28.94.200 |              6 | 127.0.0.1
Found cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 and range(s) {{{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}}} [shard 2] | 2024-02-12 10:19:06.970555 | 172.28.94.200 |             12 | 127.0.0.1
                                                                                                                                                                                                                                   Reusing querier [shard 2] | 2024-02-12 10:19:06.970559 | 172.28.94.200 |             16 | 127.0.0.1
                                                                                                               Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10000 clustering row(s) (0 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:19:06.979210 | 172.28.94.200 |           8668 | 127.0.0.1
                                                                                                                                                                                     Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:19:06.979232 | 172.28.94.200 |           8689 | 127.0.0.1
                                                                                                                                                                                                                                  Querying is done [shard 2] | 2024-02-12 10:19:06.979233 | 172.28.94.200 |           8690 | 127.0.0.1
                                                                                                                                                                                                             Done processing - preparing a result [shard 51] | 2024-02-12 10:19:06.979460 | 172.28.94.200 |           9119 | 127.0.0.1
                                                                                                                                                                                                                                            Request complete | 2024-02-12 10:19:06.979129 | 172.28.94.200 |           9129 | 127.0.0.1



Tracing session: 484921d0-c990-11ee-810f-9d4308422bb1

activity                                                                                                                                                                                                                                                                                                                                                                                                                            | timestamp                  | source        | source_elapsed | client
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                                                                                                                                                                                                Execute CQL3 query | 2024-02-12 10:20:02.029000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                     Parsing a statement [shard 6] | 2024-02-12 10:20:02.029188 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                  Processing a statement [shard 6] | 2024-02-12 10:20:02.029287 | 172.28.94.200 |             99 | 127.0.0.1
                                                                                                                                                                                                                                                                                          Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 6] | 2024-02-12 10:20:02.029332 | 172.28.94.200 |            144 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                             read_data: querying locally [shard 6] | 2024-02-12 10:20:02.029334 | 172.28.94.200 |            146 | 127.0.0.1
                                                                                                                                                                                                                        Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:20:02.029438 | 172.28.94.200 |              7 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                    Found no cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:20:02.029444 | 172.28.94.200 |             13 | 127.0.0.1
Querying cache for range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} and slice {{ckp{000100}}, (ckp{0001000004000c992a00040000000c004066643137353335323037376536373338663730303634653736343164353530616161633162643462646431653639326639393466333962303637333639393039000400000002}, ckp{000100}]} [shard 2] | 2024-02-12 10:20:02.029466 | 172.28.94.200 |             35 | 127.0.0.1
                                                                                                                                                                                                                                                                                     Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10000 clustering row(s) (0 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:20:02.038214 | 172.28.94.200 |           8783 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                           Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:20:02.038244 | 172.28.94.200 |           8813 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                        Querying is done [shard 2] | 2024-02-12 10:20:02.038246 | 172.28.94.200 |           8815 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                    Done processing - preparing a result [shard 6] | 2024-02-12 10:20:02.038383 | 172.28.94.200 |           9194 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                                  Request complete | 2024-02-12 10:20:02.038205 | 172.28.94.200 |           9205 | 127.0.0.1



Tracing session: b7b6d3f0-c990-11ee-8800-9d5e08422bb1

activity                                                                                                                                                                                                                                                                                                                                                                                                                            | timestamp                  | source        | source_elapsed | client
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                                                                                                                                                                                                Execute CQL3 query | 2024-02-12 10:23:08.975000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                    Parsing a statement [shard 55] | 2024-02-12 10:23:08.975352 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                 Processing a statement [shard 55] | 2024-02-12 10:23:08.975450 | 172.28.94.200 |             98 | 127.0.0.1
                                                                                                                                                                                                                                                                                         Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 55] | 2024-02-12 10:23:08.975492 | 172.28.94.200 |            140 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                            read_data: querying locally [shard 55] | 2024-02-12 10:23:08.975494 | 172.28.94.200 |            142 | 127.0.0.1
                                                                                                                                                                                                                        Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:23:08.975535 | 172.28.94.200 |              8 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                    Found no cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:23:08.975540 | 172.28.94.200 |             14 | 127.0.0.1
Querying cache for range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} and slice {{ckp{000100}}, (ckp{0001000004000c97ad0004000007b7004066663133356231376539633661333036663735353135636164626430316630346430316538363566323162626131383266333835303839356565363262363664000400000002}, ckp{000100}]} [shard 2] | 2024-02-12 10:23:08.975562 | 172.28.94.200 |             36 | 127.0.0.1
                                                                                                                                                                                                                                                                                     Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10000 clustering row(s) (0 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:23:08.984557 | 172.28.94.200 |           9031 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                           Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:23:08.984584 | 172.28.94.200 |           9057 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                        Querying is done [shard 2] | 2024-02-12 10:23:08.984586 | 172.28.94.200 |           9059 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                   Done processing - preparing a result [shard 55] | 2024-02-12 10:23:08.984745 | 172.28.94.200 |           9393 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                                  Request complete | 2024-02-12 10:23:08.984404 | 172.28.94.200 |           9404 | 127.0.0.1



Tracing session: e4cf2b80-c990-11ee-baf7-9d4f08422bb1

activity                                                                                                                                                                                                                                                                                                                                                                                                                            | timestamp                  | source        | source_elapsed | client
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                                                                                                                                                                                                Execute CQL3 query | 2024-02-12 10:24:24.632000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                    Parsing a statement [shard 28] | 2024-02-12 10:24:24.632653 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                 Processing a statement [shard 28] | 2024-02-12 10:24:24.632764 | 172.28.94.200 |            111 | 127.0.0.1
                                                                                                                                                                                                                                                                                         Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 28] | 2024-02-12 10:24:24.632821 | 172.28.94.200 |            168 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                            read_data: querying locally [shard 28] | 2024-02-12 10:24:24.632824 | 172.28.94.200 |            171 | 127.0.0.1
                                                                                                                                                                                                                        Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:24:24.632987 | 172.28.94.200 |              8 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                    Found no cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:24:24.632993 | 172.28.94.200 |             14 | 127.0.0.1
Querying cache for range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} and slice {{ckp{000100}}, (ckp{0001000004000c95d90004000013ea004032623737306362343263373566643939346663373063663236303361346539633262373435373336346639313266626231343462393461633137383434383562000400000002}, ckp{000100}]} [shard 2] | 2024-02-12 10:24:24.633017 | 172.28.94.200 |             38 | 127.0.0.1
                                                                                                                                                                                                                                                                                     Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10000 clustering row(s) (0 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:24:24.641954 | 172.28.94.200 |           8975 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                           Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:24:24.641992 | 172.28.94.200 |           9013 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                        Querying is done [shard 2] | 2024-02-12 10:24:24.641996 | 172.28.94.200 |           9016 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                   Done processing - preparing a result [shard 28] | 2024-02-12 10:24:24.642134 | 172.28.94.200 |           9482 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                                  Request complete | 2024-02-12 10:24:24.641495 | 172.28.94.200 |           9495 | 127.0.0.1



Tracing session: 4a7da320-c992-11ee-810f-9d4308422bb1

activity                                                                                                                                                                                                                                                                                                                                                                                                                            | timestamp                  | source        | source_elapsed | client
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                                                                                                                                                                                                Execute CQL3 query | 2024-02-12 10:34:24.722000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                     Parsing a statement [shard 6] | 2024-02-12 10:34:24.722954 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                  Processing a statement [shard 6] | 2024-02-12 10:34:24.723056 | 172.28.94.200 |            102 | 127.0.0.1
                                                                                                                                                                                                                                                                                          Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 6] | 2024-02-12 10:34:24.723105 | 172.28.94.200 |            151 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                             read_data: querying locally [shard 6] | 2024-02-12 10:34:24.723108 | 172.28.94.200 |            154 | 127.0.0.1
                                                                                                                                                                                                                        Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:34:24.723261 | 172.28.94.200 |              8 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                    Found no cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:34:24.723268 | 172.28.94.200 |             14 | 127.0.0.1
Querying cache for range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} and slice {{ckp{000100}}, (ckp{0001000004000c947c000400000104004031633932653036353230646533666265663463343537353663623663313039343936396361623931326638363030353065333964633866646262653163653634000400000000}, ckp{000100}]} [shard 2] | 2024-02-12 10:34:24.723291 | 172.28.94.200 |             38 | 127.0.0.1
                                                                                                                                                                                                                                                                                     Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10000 clustering row(s) (0 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:34:24.731976 | 172.28.94.200 |           8722 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                           Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:34:24.732005 | 172.28.94.200 |           8752 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                        Querying is done [shard 2] | 2024-02-12 10:34:24.732008 | 172.28.94.200 |           8754 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                    Done processing - preparing a result [shard 6] | 2024-02-12 10:34:24.732150 | 172.28.94.200 |           9196 | 127.0.0.1
                                                                                                                                                                                                                                                                                                                                                                                                                  Request complete | 2024-02-12 10:34:24.731208 | 172.28.94.200 |           9208 | 127.0.0.1



Tracing session: e6002a10-c993-11ee-86dc-9d4008422bb1

activity                                                                                                                                  | timestamp                  | source        | source_elapsed | client
-------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                      Execute CQL3 query | 2024-02-12 10:45:55.121000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                          Parsing a statement [shard 23] | 2024-02-12 10:45:55.121270 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                       Processing a statement [shard 23] | 2024-02-12 10:45:55.121375 | 172.28.94.200 |            105 | 127.0.0.1
Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 23] | 2024-02-12 10:45:55.121416 | 172.28.94.200 |            145 | 127.0.0.1
                                                                                                  read_data: querying locally [shard 23] | 2024-02-12 10:45:55.121418 | 172.28.94.200 |            147 | 127.0.0.1
                                                                                         Done processing - preparing a result [shard 23] | 2024-02-12 10:45:55.130334 | 172.28.94.200 |           9063 | 127.0.0.1
                                                                                                                        Request complete | 2024-02-12 10:45:55.130074 | 172.28.94.200 |           9074 | 127.0.0.1



Tracing session: e6195760-c993-11ee-97cf-9d5408422bb1

activity                                                                                                                                                                                                                                                      | timestamp                  | source        | source_elapsed | client
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                          Execute CQL3 query | 2024-02-12 10:45:55.286000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                              Parsing a statement [shard 31] | 2024-02-12 10:45:55.286792 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                           Processing a statement [shard 31] | 2024-02-12 10:45:55.286868 | 172.28.94.200 |             76 | 127.0.0.1
                                                                                                                   Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 31] | 2024-02-12 10:45:55.286902 | 172.28.94.200 |            110 | 127.0.0.1
                                                                                                                                                                                                                      read_data: querying locally [shard 31] | 2024-02-12 10:45:55.286904 | 172.28.94.200 |            112 | 127.0.0.1
                                                  Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:45:55.287005 | 172.28.94.200 |              6 | 127.0.0.1
Found cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 and range(s) {{{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}}} [shard 2] | 2024-02-12 10:45:55.287012 | 172.28.94.200 |             12 | 127.0.0.1
                                                                                                                                                                                                                                   Reusing querier [shard 2] | 2024-02-12 10:45:55.287016 | 172.28.94.200 |             16 | 127.0.0.1
                                                                                                               Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 10000 clustering row(s) (0 live, 10000 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:45:55.295602 | 172.28.94.200 |           8602 | 127.0.0.1
                                                                                                                                                                                     Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:45:55.295622 | 172.28.94.200 |           8623 | 127.0.0.1
                                                                                                                                                                                                                                  Querying is done [shard 2] | 2024-02-12 10:45:55.295624 | 172.28.94.200 |           8624 | 127.0.0.1
                                                                                                                                                                                                             Done processing - preparing a result [shard 31] | 2024-02-12 10:45:55.295855 | 172.28.94.200 |           9063 | 127.0.0.1
                                                                                                                                                                                                                                            Request complete | 2024-02-12 10:45:55.295073 | 172.28.94.200 |           9073 | 127.0.0.1



Tracing session: e630aff0-c993-11ee-ac4c-9d5f08422bb1

activity                                                                                                                                                                                                                                                      | timestamp                  | source        | source_elapsed | client
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------+-----------
                                                                                                                                                                                                                                          Execute CQL3 query | 2024-02-12 10:45:55.439000 | 172.28.94.200 |              0 | 127.0.0.1
                                                                                                                                                                                                                              Parsing a statement [shard 54] | 2024-02-12 10:45:55.439835 | 172.28.94.200 |             -- | 127.0.0.1
                                                                                                                                                                                                                           Processing a statement [shard 54] | 2024-02-12 10:45:55.439898 | 172.28.94.200 |             62 | 127.0.0.1
                                                                                                                   Creating read executor for token -6376940396830892697 with all: {172.28.94.200} targets: {172.28.94.200} repair decision: NONE [shard 54] | 2024-02-12 10:45:55.439930 | 172.28.94.200 |             94 | 127.0.0.1
                                                                                                                                                                                                                      read_data: querying locally [shard 54] | 2024-02-12 10:45:55.439931 | 172.28.94.200 |             96 | 127.0.0.1
                                                  Start querying singular range {{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}} [shard 2] | 2024-02-12 10:45:55.440089 | 172.28.94.200 |             20 | 127.0.0.1
Found cached querier for key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 and range(s) {{{-6376940396830892697, pk{004033623839336332356562333839333233383333656439666539303933376132613431366132613537373862643536336534633937363935383838393864343863}}}} [shard 2] | 2024-02-12 10:45:55.440094 | 172.28.94.200 |             26 | 127.0.0.1
                                                                                                                                                                                                                                   Reusing querier [shard 2] | 2024-02-12 10:45:55.440097 | 172.28.94.200 |             29 | 127.0.0.1
                                                                                                                 Page stats: 1 partition(s), 0 static row(s) (0 live, 0 dead), 6080 clustering row(s) (1 live, 6079 dead) and 0 range tombstone(s) [shard 2] | 2024-02-12 10:45:55.445008 | 172.28.94.200 |           4940 | 127.0.0.1
                                                                                                                                                                                     Caching querier with key 45a7213e-dc53-4a1a-9da9-40d01dbc2fe4 [shard 2] | 2024-02-12 10:45:55.445028 | 172.28.94.200 |           4960 | 127.0.0.1
                                                                                                                                                                                                                                  Querying is done [shard 2] | 2024-02-12 10:45:55.445029 | 172.28.94.200 |           4961 | 127.0.0.1
                                                                                                                                                                                                             Done processing - preparing a result [shard 54] | 2024-02-12 10:45:55.445172 | 172.28.94.200 |           5337 | 127.0.0.1
                                                                                                                                                                                                                                            Request complete | 2024-02-12 10:45:55.444345 | 172.28.94.200 |           5345 | 127.0.0.1

@caevv
Copy link
Author

caevv commented Feb 21, 2024

gc_grace_seconds has passed and if I run the same query with COUNT(1) I now get 187 qty and I ran nodetool compact.
Running from cqlsh the data is surely returning much faster, only a few seconds now. If I run the query with LIMIT 187, 100 rows comes then I get --MORE-- and then another 85 come, and then another --MORE-- and then the 2 come after less than a second.

But the go code still won’t bring these two rows, if I put limit 200 only 185 rows will come back, with iter.PageState() having some value, then I query with that token and iter.NumRows is 0.

@dkropachev dkropachev self-assigned this Aug 12, 2024
@dkropachev
Copy link
Collaborator

@caevv , can you please show the code on how do you iterate over iter.PageState() ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@dkropachev dkropachev

Labels
triage
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@avikivity @caevv @roydahan @dkropachev