Re: Automatic pagination does not get all results

2015-10-23 Thread Sid Tantia
; here are some questions to help us help you: > > What version? > What results are you seeing? > What’s the “right” result? > What CL did you use to write the data? > What CL did you use to read the data? > Have you run repair since writing the data? > > > From: Sid Tantia &g

Automatic pagination does not get all results

2015-10-22 Thread Sid Tantia
Hello, Has anyone had a problem with automatic pagination returning different results everytime (this is for a table with ~180,000 rows)? I'm going through each page and inserting the results into an array and each time I go through all the pages, the resultant array has a different size. This ha

Re: "SELECT *..." query times out on a particular table

2015-08-03 Thread Sid Tantia
Right, thanks for pointing that out. I am running Cassandra v2.1.4 On Mon, Aug 3, 2015 at 2:51 PM, Jim Witschey wrote: > You might want to send another email to the list specifying the Cassandra > version. > On Mon, Aug 3, 2015 at 5:48 PM Sid Tantia > wrote: >> Hello, >&

"SELECT *..." query times out on a particular table

2015-08-03 Thread Sid Tantia
Hello, Any select all or select count query on a particular table is timing out with "Cassandra::Errors::TimeoutError: Timed out" A “SELECT * FROM WHERE = ‘’ on the table works, but a “SELECT * FROM LIMIT 1; does not work. All other tables and queries work.  Any ideas as to why this migh

Re: Is there a way to remove a node with Opscenter?

2015-07-28 Thread Sid Tantia
I know this is an old thread but just FYI for others having the same problem (OpsCenter trying to connect to node that is already removed)...the solution is to ssh into the OpsCenter node and run `sudo service opscenterd restart` On Thu, Jul 9, 2015 at 3:52 PM, Sid Tantia wrote: > Found

Re: Is there a way to remove a node with Opscenter?

2015-07-09 Thread Sid Tantia
rver which has cassandra > daemon running. > Cheers > Jean > On 08 Jul 2015, at 01:39 , Sid Tantia > mailto:sid.tan...@baseboxsoftware.com>> wrote: > I tried both `nodetool remove node ` and `nodetool decommission` and > they both give the error: > nodetool: Fa

Re: Is there a way to remove a node with Opscenter?

2015-07-07 Thread Sid Tantia
Remove the node from the “seed list” within the configuration > cassandra.yaml. > On 7 July 2015 at 12:56, Sid Tantia wrote: >> Thanks for the response. I’m trying to remove a node that’s already down >> for some reason so its not allowing me to decommission it, is there some >>

Re: Is there a way to remove a node with Opscenter?

2015-07-07 Thread Sid Tantia
by > clicking on the node and decommission. > Best Regards, > Kiran.M.K. > On Jul 8, 2015 1:00 AM, "Sid Tantia" wrote: >> I know you can use `nodetool removenode` from the command line but is >> there a way to remove a node from a cluster using OpsCenter? >> >>

Is there a way to remove a node with Opscenter?

2015-07-07 Thread Sid Tantia
I know you can use `nodetool removenode` from the command line but is there a way to remove a node from a cluster using OpsCenter?

Re: Is it okay to use a small t2.micro instance for OpsCenter and use m3.medium instances for the actual Cassandra nodes?

2015-06-29 Thread Sid Tantia
26, 2015 at 1:20 PM, Sid Tantia > wrote: >> For instance, on AWS can I have 3 m3.medium nodes for Cassandra and 1 >> t2.micro node for OpsCenter? >> > m3.medium is below the minimum size I would use for Cassandra doing > anything meaningful, for the record. > =Rob

Is it okay to use a small t2.micro instance for OpsCenter and use m3.medium instances for the actual Cassandra nodes?

2015-06-26 Thread Sid Tantia
Hello, I haven’t been able to find any documentation for best practices on this…is it okay to set up opscenter as a smaller node than the rest of the cluster.  For instance, on AWS can I have 3 m3.medium nodes for Cassandra and 1 t2.micro node for OpsCenter?