Re: Prevent queries from OOM nodes

2012-10-02 Thread Sylvain Lebresne
> Could you create one ? > https://issues.apache.org/jira/browse/CASSANDRA There's one already. See https://issues.apache.org/jira/browse/CASSANDRA-3702 that redirect to https://issues.apache.org/jira/browse/CASSANDRA-4415. -- Sylvain

Re: Prevent queries from OOM nodes

2012-10-01 Thread aaron morton
> It's not about columns, it's about rows, see example statement. My bad, misread the CQL. My jira search fu is poor, but I could not find an open ticket for paging row counts. Could you create one ? https://issues.apache.org/jira/browse/CASSANDRA Cheers - Aaron Morton Freela

Re: Prevent queries from OOM nodes

2012-10-01 Thread Віталій Тимчишин
It's not about columns, it's about rows, see example statement. In QueryProcessor#processStatement it reads rows into list, then does list.size() 2012/10/1 aaron morton > CQL will read everything into List to make latter a count. > > > From 1.0 onwards count paginated reading the columns. What v

Re: Prevent queries from OOM nodes

2012-09-30 Thread aaron morton
> CQL will read everything into List to make latter a count. From 1.0 onwards count paginated reading the columns. What version are you on ? https://issues.apache.org/jira/browse/CASSANDRA-2894 Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.co

Re: Prevent queries from OOM nodes

2012-09-26 Thread Віталій Тимчишин
Actually an easy way to put cassandra down is select count(*) from A limit 1000 CQL will read everything into List to make latter a count. 2012/9/26 aaron morton > Can you provide some information on the queries and the size of the data > they traversed ? > > The default maximum size for a s

Re: Prevent queries from OOM nodes

2012-09-25 Thread aaron morton
Can you provide some information on the queries and the size of the data they traversed ? The default maximum size for a single thrift message is 16MB, was it larger than that ? https://github.com/apache/cassandra/blob/trunk/conf/cassandra.yaml#L375 Cheers - Aaron Morton Free

Prevent queries from OOM nodes

2012-09-24 Thread Bryce Godfrey
Is there anything I can do on the configuration side to prevent nodes from going OOM due to queries that will read large amounts of data and exceed the heap available? For the past few days of we had some nodes consistently freezing/crashing with OOM. We got a heap dump into MAT and figured ou