search

citusdata / citus

Distributed PostgreSQL as an extension
https://www.citusdata.com
GNU Affero General Public License v3.0
10.17k stars 651 forks source link

Unable to query data on a distributed table after a limit #7428

Open niknikhil025 opened 6 months ago

niknikhil025 commented 6 months ago

I have a table where I am trying to query data I am able to query upto a certain limit. example i am able to query upto limit 641 but if i query with limit 642 the console gets stuck and i don't get anything and this number keeps decreasing. earlier it was upto 1100 morning it was 700 and now it is 640. I can query with limit 640 and get the data but now with 641.

This is happening for a specific table (it is a distributed table). The cluster has 5 nodes.

Is there a way to recover from this problem as it gets stuck for some of the rows in the table if i try to update them.

I already tried removing and re adding nodes from the cluster.

JelteF commented 6 months ago

That seems very strange. Are there any errors in the logs of the machines in your cluster?