We are experiencing weird behavior in our single-node 4.5.5 CrateDB deployment.
Problem description: the first time we execute a SQL query CrateDB returns a subset of selected data, while the second time, executing the exact same query, returns the entire dataset.
Here is a query example, but I think you will find it quite normal:
SELECT * FROM mtairqualityraw.etairqualityobservedraw WHERE time_index BETWEEN '2023-05-23 10:45:00+00:00' AND '2023-05-23 11:00:00+00:00' ORDER BY time_index ASC, entity_id ASC 23 May 2023-11:00:24.512 - [root] → First fetchall 9 lines: 23 May 2023-11:00:24.521 - [root] → Second fetchall 22 lines:
I would like to provide more information but the problem is difficult to catch.
One more thing, the problem has arisen recently, but the machine where Crate is running doesn’t seem too stressed to point to that as the problem.
Do you have any ideas or suggestions on how to proceed? We are already considering upgrading the node to the last 4.x version, but we would like to know whether this is something documented or at least identified.
As always, thanks in advance