What happened?

A bug happened!

After ingesting ~50,000 request records in to ClickHouse, the Requests page shows a total count of 807 pages, which does not reflect the actual number of records.

Changing the “Rows per page” setting (e.g. 25, 100, 500) does not update the total count.

Navigating to the “Last” page results in a “Data not found” state when using larger page sizes, even though data exists.

Smaller page sizes sometimes work, but pagination becomes inconsistent as page size increases.

This is default initial rows

This is after updating rows to 500 yet same number of pages

This is how last page looks like with 500 rows per page (i.e) 807th page

Relevant log output

c9caae17b4ce :) SELECT count(*)
FROM request_response_rmt
WHERE organization_id = '2d7d913e-2c36-492c-8ad5-9323fc3f79c1';


SELECT count(*)
FROM request_response_rmt
WHERE organization_id = '2d7d913e-2c36-492c-8ad5-9323fc3f79c1'

Query id: 7417362d-2dce-47b0-a2fd-f08f1ed7e890

   ┌─count()─┐
1. │   50001 │
   └─────────┘

1 row in set. Elapsed: 0.007 sec. Processed 50.00 thousand rows, 800.02 KB (7.17 million rows/s., 114.74 MB/s.)
Peak memory usage: 97.06 KiB.

Twitter / LinkedIn details

@LoRamCh , www.linkedin.com/in/lokeshramchand