Cassandra startup failed due to InstanceAlreadyExistsException of some indexes

Hi,I have 2 nodes with RF of 2. I've added a secondary index (starttimeindex) recently to one of my column families (alerts) and executed the scrub command, but after restarting both of my nodes I got InstanceAlreadyExistsException for that index column family. it seems that cassandra made the inde

RE Restore snapshot

No it's not possible "Desimpel, Ignace" a écrit sur 01/08/2012 14:58:49 : > Hi, > > Is it possible to restore a snapshot of a keyspace on a live > cassandra cluster (I mean without restarting)? >

Re: RE Restore snapshot

Actually that's wrong, it is perfectly possible to restore a snapshot on a live cassandra cluster. There is even basically 2 solutions: 1) use the sstableloader (http://www.datastax.com/dev/blog/bulk-loading) 2) copy the snapshot sstable in the right place and call the JMX method loadNewSSTables()

RE: RE Restore snapshot

Great! I will use the hardlinks to 'restore' the data files on each node (super fast)! I have some related questions : 1) I assume that I have to call the loadNewSSTables() on each node? 2) To be on the save side, I guess I better drop the existing keyspace and then recreate using the definitio

Re: RE Restore snapshot

1) I assume that I have to call the loadNewSSTables() on each node? this is same as "nodetool refresh?"

Is large number of columns per row a problem?

We want to store a large number of columns in a single row (up to about 100,000,000), where each value is roughly 10 bytes. We also need to be able to get slices of columns from any point in the row. We haven't found a problem with smaller amounts of data so far, but can anyone think of any rea

Re: RE Restore snapshot

Then http://www.datastax.com/docs/1.1/operations/backup_restore should mention it :-) Sylvain Lebresne a écrit sur 02/08/2012 11:45:46 : > Actually that's wrong, it is perfectly possible to restore a snapshot > on a live cassandra cluster. > There is even basically 2 solutions: > 1) use the ss

Re: Is large number of columns per row a problem?

Hi, On Thursday, 2 August 2012 at 11:47, Owen Davies wrote: > We want to store a large number of columns in a single row (up to about > 100,000,000), where each value is roughly 10 bytes. > > We also need to be able to get slices of columns from any point in the row. > > We haven't found a p

composite table with cassandra without using cql3?

I've been using the cql3 to create a composite table. Can I use the thrift interface to accomplish the same thing? In other words, do I have to use cql 3 to get a composite table type? (The same behavior as multiple PRIMARY key columns). Thanks, ---greg

Re: composite table with cassandra without using cql3?

For how to do it with astyanax, you can see here... Lines 310 and 335 https://github.com/deanhiller/nosqlORM/blob/indexing/input/javasrc/com/alva zan/orm/layer3/spi/db/cassandra/CassandraSession.java For how to do with thrift, you could look at astyanax. I use it on that project for indexing f

Joining DR nodes in new data center

What is the process for joining a new data center to an existing cluster as DR? We have a 5 node cluster in our primary DC, and want to bring up 5 more in our 2nd data center purely for DR. How should these new nodes be joined to the cluster and be seen as the 2nd data center? Do the new nodes

Re: Mixed cluster node with version 1.1.2 and 1.0.6 gives errors

Hey, It is explained here: https://issues.apache.org/jira/browse/CASSANDRA-4195 -- Omid On Wed, Aug 1, 2012 at 2:39 AM, Roshan wrote: > Hi > > I have 3 node development cluster and all running 1.0.6 version without any > issue. As the part of the upgrade to 1.1.2, I just upgrade one node to >

Re: Mixed cluster node with version 1.1.2 and 1.0.6 gives errors

Thanks to point me the solution. So that means, I want to upgrade 1.0.6 cluster to 1.0.11 first, then upgrade to 1.1.2 version. Is I am right? Thanks /Roshan -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Mixed-cluster-node-with-version-1-1-2

Re: DROP keyspace doesn't delete the files

bump On Jul 29, 2012, at 11:03 PM, Drew Kutcharian wrote: > Hi, > > What's the correct procedure to drop a keyspace? When I drop a keyspace, the > files of that keyspace don't get deleted. There is a JIRA on this: > > https://issues.apache.org/jira/browse/CASSANDRA-4075 > > Is this a bug or I

Got exception running Sqoop: org.apache.cassandra.db.marshal.MarshalException: 97 is not recognized as a valid type, while importing data from mysql to cassandra using sqoop

Hi Everyone, I am trying to import data into cassandra column family from mysql and i am getting the following error. ERROR sqoop.Sqoop: Got exception running Sqoop: org.apache.cassandra.db.marshal.MarshalException: 97 is not recognized as a valid type org.apache.cassandra.db.marshal.MarshalE