RE: Retrieving all row keys of a CF

I had the same issue and overcame it by querying for primary keys over all subset s of the token range/ring. ——— Jens Rantil Backend Engineer Tink AB Email: jens.ran...@tink.se Phone: +46 708 84 18 32 Web: www.tink.se Facebook Linkedin Twitter On Thu, Jan 29, 2015 at 10:32 PM, Ravi Agrawal

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

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. Any

Re: error while bulk loading using copy command

Thanks Eric.. yes 18 lacs implies 1.8 million. On Thu, Jan 29, 2015 at 9:01 PM, Eric Stevens 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 the initial del

Re: Syntax for using JMX term to connect to Cassandra

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

Re: Syntax for using JMX term to connect to Cassandra

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 Load"echo $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: Tombstone gc after gc grace seconds

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

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 wrote: Hello, Is there a metric that will show how many reads per second C* serves? Read requests shows ho

Re: Syntax for using JMX term to connect to Cassandra

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: Syntax for using JMX term to connect to Cassandra

On Thu, Jan 29, 2015 at 3:27 PM, Jan 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 : 1. Downlo

Syntax for using JMX term to connect to Cassandra

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: Retrieving all row keys of a CF

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 timi

RE: Tombstone gc after gc grace seconds

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 b.

Re: Upgrading from Cassandra 1.2.14 to Cassandra 2.10

> 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 wrote: > Hi All, > > I am looking into the possibility of upgrading from Cassa

Re: Upgrading from Cassandra 1.2.14 to Cassandra 2.10

On Thu, Jan 29, 2015 at 6:15 AM, Sibbald, Charles 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 Cassandra cluster with doze

Re: Performance difference between Regular Statement Vs PreparedStatement

+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... n

Re: Performance difference between Regular Statement Vs PreparedStatement

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 minim

Re: Upgrading from Cassandra 1.2.14 to Cassandra 2.10

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: Performance difference between Regular Statement Vs PreparedStatement

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 statements

Opscenter served reads / second

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: Repairing OpsCenter rollups60 Results in Snapshot Errors

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 ju

Repairing OpsCenter rollups60 Results in Snapshot Errors

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 cr

Re: Upgrading from Cassandra 1.2.14 to Cassandra 2.10

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 mailto:r...@pythian.com>> Reply-To: "user@cassandra.apache.org

Re: Performance difference between Regular Statement Vs PreparedStatement

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

Re: error while bulk loading using copy command

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 counters

Re: Upgrading from Cassandra 1.2.14 to Cassandra 2.10

Hello Charles, I think you have to do a 2-time upgrade given SSTables and Network incompatibilities between versions. You have to upgrade to 2.0 and then to 2.1. Acording to this http://www.datastax.com/documentation/upgrade/doc/upgrade/cassandra/upgradeC_c.html you should even do a upgrade to 1.

Upgrading from Cassandra 1.2.14 to Cassandra 2.10

Hi All, I am looking into the possibility of upgrading from Cassandra 1.2.14 to Cassandra 2.1 in the following manor. I have a large Cassandra cluster with dozens of nodes, and would like to build new instances at version 2.1 to join the cluster and once they have successfully joined the rink

Re: Database schema migration

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): > http://grokbase.com/t/cassandra/user/14bs9zvasf/cassa

Re: Database schema migration

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

Re: Database schema migration

Hi, Ricardo Thank you for your quick reply. =] I'll take a look in the mutagen-cassandra and others I find in the archives All the best On Thu, Jan 29, 2015 at 8:38 AM, Paulo Ricardo Motta Gomes < paulo.mo...@chaordicsystems.com> wrote: > Hello José, > > There isn't yet an officially supported

Re: Database schema migration

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: https:/

Database schema migration

Hello I am studying Cassandra for while and to practice the libraries and concepts I will implement a simple Cassandra client. During my research I faced a doubt about schema migrations. What the common/best practice in production clusters? I mean, who actually make the schema migration? The appli