Re: Upgrading from Cassandra 1.2.14 to Cassandra 2.10

2015-01-29 Thread Carlos Rolo
Sorry, my bad. I misread as 1.2.4 for some reason! You should be able to do it with the 2-way upgrade then. Don't forget that once you upgrade to 2.0.x you need to perform a nodetool upgradesstables and this is where, in my point of view, things can get tricky. First make sure you have the space

Re: Database schema migration

2015-01-29 Thread Paulo Ricardo Motta Gomes
Hello José, There isn't yet an officially supported way to perform schema migrations afaik, but there are quite a few tools on github that perform migrations either from within the application, or external tools. We currently use this tool to perform migrations embedded in the application:

Re: Database schema migration

2015-01-29 Thread Paulo Ricardo Motta Gomes
This might be of interest (you probably have already found it): http://grokbase.com/t/cassandra/user/14bs9zvasf/cassandra-schema-migrator On Thu, Jan 29, 2015 at 9:16 AM, José Guilherme Vanz guilherme@gmail.com wrote: Hi, Ricardo Thank you for your quick reply. =] I'll take a look in

Re: error while bulk loading using copy command

2015-01-29 Thread Eric Stevens
As the error implies, you cannot insert into counters tables, you can only update them as increments or decrements (updating a counter that doesn't exist will create it with the initial delta as if it had started at zero). I would recommend this documentation which describes how to update

Re: Database schema migration

2015-01-29 Thread José Guilherme Vanz
Yeap, some of the tools I already found. Anyway, thank you for the link =] On Thu, Jan 29, 2015 at 9:29 AM, Paulo Ricardo Motta Gomes paulo.mo...@chaordicsystems.com wrote: This might be of interest (you probably have already found it):

Re: Performance difference between Regular Statement Vs PreparedStatement

2015-01-29 Thread Eric Stevens
That's not a particularly good setup for load testing, I would try hard not to draw any conclusions from it. Most likely your biggest bottleneck is I/O in your VM's, and any savings from using prepared statements dwarf in comparison to the price of virtualization. Point 2's effects are also

Re: Repairing OpsCenter rollups60 Results in Snapshot Errors

2015-01-29 Thread Reynald Bourtembourg
Hi Paul, There is a JIRA ticket about this issue: https://issues.apache.org/jira/browse/CASSANDRA-8696 I have seen these errors too the last time I ran nodetool repair. I would also be interested to know the answer to the questions you were asking: Are these errors problematic? Should I just

Re: Upgrading from Cassandra 1.2.14 to Cassandra 2.10

2015-01-29 Thread Sibbald, Charles
Hi Carlos, We are running 1.2.14 which is higher than 1.2.9 so I have an assumption that the network layer is compatible, or do you specifically mean that 2.10 is not compatible with 1.2.x ? Regards Charles From: Carlos Rolo r...@pythian.commailto:r...@pythian.com Reply-To:

Opscenter served reads / second

2015-01-29 Thread Batranut Bogdan
Hello, Is there a metric that will show how many reads per second C* serves? Read requests shows how many requests are issued to cassandra, but I want to know how many the cluster can actualy serve .

Re: Performance difference between Regular Statement Vs PreparedStatement

2015-01-29 Thread Eric Stevens
Prepared statements can take advantage of token aware routing which IIRC non-prepared statements cannot in the DS Java Driver, so as your cluster grows you reduce the overhead of statement coordination (assuming you use token aware routing). There should also be less data to transfer for shipping

Repairing OpsCenter rollups60 Results in Snapshot Errors

2015-01-29 Thread Paul Nickerson
I am running a 6 node cluster using Apache Cassandra 2.1.2 with DataStax OpsCenter 5.0.2 from the AWS EC2 AMI DataStax Auto-Clustering AMI 2.5.1-hvm (DataStax Community AMI). When I try to run a repair on the rollups60 column family in the OpsCenter keyspace, I get errors about failed snapshot

Re: Performance difference between Regular Statement Vs PreparedStatement

2015-01-29 Thread Ajay
Thanks Eric. I didn't know the point about the token aware routing. But with points 2 and 3 I didn't notice much improvement with prepared statement. I have 2 cassandra nodes running in virtual boxes in the same machine and test client running in the same machine. Thanks Ajay Prepared

Re: Upgrading from Cassandra 1.2.14 to Cassandra 2.10

2015-01-29 Thread Jonathan Haddad
Once they have fully joined the cluster I would like to decommission a single Cassandra 1.2.14 instance, and repeat. Do not do this. Upgrade your nodes in place. On Thu Jan 29 2015 at 6:17:26 AM Sibbald, Charles charles.sibb...@bskyb.com wrote: Hi All, I am looking into the possibility

Re: Performance difference between Regular Statement Vs PreparedStatement

2015-01-29 Thread Jonathan Haddad
+1 to everything Eric said. The penalty of not using token aware routing increases as you add nodes, load, and network overhead. This is kind of like batch statements. People use them in dev, with 1 node, and think they're great to help with performance. But when you put them in production...

Re: Upgrading from Cassandra 1.2.14 to Cassandra 2.10

2015-01-29 Thread Robert Coli
On Thu, Jan 29, 2015 at 6:15 AM, Sibbald, Charles charles.sibb...@bskyb.com wrote: I am looking into the possibility of upgrading from Cassandra 1.2.14 to Cassandra 2.1 in the following manor. https://engineering.eventbrite.com/what-version-of-cassandra-should-i-run/ I have a large

RE: Tombstone gc after gc grace seconds

2015-01-29 Thread Ravi Agrawal
Hi, I saw there are 2 more interesting parameters – a. tombstone_threshold - A ratio of garbage-collectable tombstones to all contained columns, which if exceeded by the SSTable triggers compaction (with no other SSTables) for the purpose of purging the tombstones. Default value – 0.2

RE: Retrieving all row keys of a CF

2015-01-29 Thread Ravi Agrawal
Select distinct keys from column family; hits a timeout exception. pk1, pk2,…pkn are 800K in total. From: Mohammed Guller [mailto:moham...@glassbeam.com] Sent: Friday, January 23, 2015 3:24 PM To: user@cassandra.apache.org Subject: RE: Retrieving all row keys of a CF No wonder, the client is

Re: Syntax for using JMX term to connect to Cassandra

2015-01-29 Thread Robert Coli
On Thu, Jan 29, 2015 at 5:04 PM, Jan cne...@yahoo.com wrote: Thanks Robert, your example got me going in the right direction. Right on, glad to hear it, that was my goal. :D =Rob

Syntax for using JMX term to connect to Cassandra

2015-01-29 Thread Jan
HI Folks;  I am trying to use JMXterm,  a command line based tool to script monitor C* cluster. Would anyone on this forum know the exact syntax to connect to Cassandra Domain using JMXterm  ?Please give me an example.  I do 'not'   intend to use OpsCenter or any other UI based tool. thanksJan 

Re: Syntax for using JMX term to connect to Cassandra

2015-01-29 Thread Jan
Thanks Rob;  here is what I am looking for :  java -jar  /home/user/jmxterm-1.0-alpha-4-uber.jar 10.30.41.52:7199 -O org.apache.cassandra.internal:type=FlushWriter -A CurrentlyBlockedTask It does Not work since there is something wrong with my syntax.  However once working, it would be scripted

RE: Tombstone gc after gc grace seconds

2015-01-29 Thread Mohammed Guller
Ravi – It may help. What version are you running? Do you know if minor compaction is getting triggered at all? One way to check would be see how many sstables the data directory has. Mohammed From: Ravi Agrawal [mailto:ragra...@clearpoolgroup.com] Sent: Thursday, January 29, 2015 1:29 PM To:

Re: Opscenter served reads / second

2015-01-29 Thread Jan
Mbean:    org.apache.cassandra.request  Attribute: org.apache.cassandra.request:type=ReadStage Hope this helpsJan/ On Thursday, January 29, 2015 9:13 AM, Batranut Bogdan batra...@yahoo.com wrote: Hello, Is there a metric that will show how many reads per second C* serves? Read

Re: Syntax for using JMX term to connect to Cassandra

2015-01-29 Thread Jan
Here is the answer :        Put the following into a shell script it would yield the results :  JMXTERM_CMD=get -b org.apache.cassandra.db:type=StorageService -s Loadecho $JMXTERM_CMD |  java -jar  /home/xyz/jmxterm-1.0-alpha-4-uber.jar  -l 10.32.22.45:7199 -v silent -n  Variables are : -b    

Re: error while bulk loading using copy command

2015-01-29 Thread Rahul Bhardwaj
Thanks Eric.. yes 18 lacs implies 1.8 million. On Thu, Jan 29, 2015 at 9:01 PM, Eric Stevens migh...@gmail.com wrote: As the error implies, you cannot insert into counters tables, you can only update them as increments or decrements (updating a counter that doesn't exist will create it with

Bootstrap stopped due to Corrupt (negative) value length in ColumnIterator.deserializeNext

2015-01-29 Thread PRANEESH KUMAR
Hi, We have Cassandra 1.2.16. While adding a new node, during bootstrap has encountered java.io.IOException: Corrupt (negative) value length in ColumnSortedMap. After this error streaming has been stopped and the node is still in joining mode. Has anyone came across a similar kind of error.

Re: Syntax for using JMX term to connect to Cassandra

2015-01-29 Thread Robert Coli
On Thu, Jan 29, 2015 at 3:27 PM, Jan cne...@yahoo.com wrote: I am trying to use JMXterm, a command line based tool to script monitor C* cluster. Would anyone on this forum know the exact syntax to connect to Cassandra Domain using JMXterm ? Here's an example from an old JIRA at my shop :