Re: Cassandra mad GC

2014-01-20 Thread Dimetrio
I think Read 1001 live and 1518 is not too many tombstones and its normal -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Cassandra-mad-GC-tp7592248p7592297.html Sent from the cassandra-u...@incubator.apache.org mailing list archive at

Re: Upgrading 1.0.9 to 2.0

2014-01-20 Thread Or Sher
Thanks. Can I use sstableloader to load SSTables from a RandomPartitioner cluster to a Murmuer3Partitioner cluster? On Thu, Jan 16, 2014 at 9:24 PM, Arya Goudarzi gouda...@gmail.com wrote: Read the upgrade best practices http://www.datastax.com/docs/1.1/install/upgrading#best-practices

Re: Cassandra mad GC

2014-01-20 Thread Dimetrio
no triggers, no custom comparators i have a data model that creates a lot of tombstones (users home timeline with many inserts and deletes). how can i reduce tombstones count it this case? Is this all from cassandra ? yes, with multithread compaction (for c3.4 - 6 threads),

Re: Cassandra mad GC

2014-01-20 Thread Dimetrio
btw, cassandra cluster is more stable with turned off multithread compaction. One node have more keys than other nodes normal node Keyspace: Social Read Count: 65530294 Read Latency: 2.010432367020969 ms. Write Count: 183948607 Write Latency: 0.04994240148825917 ms.

Re: upgrade from cassandra 1.2.3 - 1.2.13 + start using SSL

2014-01-20 Thread Cyril Scetbon
Hi made some tests which succeed -- Cyril SCETBON On 19 Jan 2014, at 01:14, Cyril Scetbon cyril.scet...@free.fr wrote: So 1.2.2 and 1.2.13 have different file versions (ib vs ic) We'll test if repairs are impacted by this change Thanks Cyril Scetbon Le 17 janv. 2014 à 05:07, Aaron

Re: upgrade from cassandra 1.2.3 - 1.2.13 + start using SSL

2014-01-20 Thread Cyril Scetbon
(Forget my last mail) Hi made some tests which succeed with all our operations (repair, add/remove nodes ...). The only thing I'm worrying about is that I met a situation where I had a lot of flushes on some nodes. You can find one of my system logs at http://pastebin.com/YZKUQLXz. I'm not

Re: Tracking word frequencies

2014-01-20 Thread David Tinker
I haven't actually tried to use that schema yet, it was just my first idea. If we use that solution our app would have to read the whole table once a day or so to find the top 5000'ish words. On Fri, Jan 17, 2014 at 2:49 PM, Jonathan Lacefield jlacefi...@datastax.com wrote: Hi David, How

Re: Tracking word frequencies

2014-01-20 Thread Colin
When updating, use table that uses rows of words and increment the count? -- Colin +1 320 221 9531 On Jan 20, 2014, at 6:58 AM, David Tinker david.tin...@gmail.com wrote: I haven't actually tried to use that schema yet, it was just my first idea. If we use that solution our app would

one or more nodes were unavailable.

2014-01-20 Thread Vivek Mishra
Hi, Trying CAS feature of cassandra 2.x and somehow getting given below error: cqlsh:sample insert into User(user_id,first_name) values( fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1') if not exists; Unable to complete request: one or more nodes were unavailable. cqlsh:training cqlsh:sample

Re: one or more nodes were unavailable.

2014-01-20 Thread sankalp kohli
What consistency level are you using? On Mon, Jan 20, 2014 at 7:16 AM, Vivek Mishra mishra.v...@gmail.com wrote: Hi, Trying CAS feature of cassandra 2.x and somehow getting given below error: cqlsh:sample insert into User(user_id,first_name) values(

Re: one or more nodes were unavailable.

2014-01-20 Thread sankalp kohli
Also do you have any nodes down...because it is possible to reach write consistency and not do CAS because some machines are down. On Mon, Jan 20, 2014 at 12:16 PM, sankalp kohli kohlisank...@gmail.comwrote: What consistency level are you using? On Mon, Jan 20, 2014 at 7:16 AM, Vivek Mishra

HintedHandoff Exception and node holding hints to random tokens

2014-01-20 Thread Allan C
Hi , I’m hitting a very odd issue with HintedHandoff on 1 node in my 12 node cluster running 1.2.13. Somehow it’s holding a large amount of hints for tokens that have never been part of the cluster. Pretty sure this is causing a bunch of memory pressure somehow that’s causing the node to go

Re: HintedHandoff Exception and node holding hints to random tokens

2014-01-20 Thread sankalp kohli
Is this happening in one node or all. Did you try to delete the hints via JMX in other nodes? On Mon, Jan 20, 2014 at 12:18 PM, Allan C alla...@gmail.com wrote: Hi , I’m hitting a very odd issue with HintedHandoff on 1 node in my 12 node cluster running 1.2.13. Somehow it’s holding a large

Re: HintedHandoff Exception and node holding hints to random tokens

2014-01-20 Thread Allan C
There are 3 other nodes that have a mild case. This is one node is worse by an order of magnitude. deleteHintsForEndpoint fails with the same error  on any of the affected nodes. -Allan On January 20, 2014 at 12:24:33 PM, sankalp kohli (kohlisank...@gmail.com) wrote: Is this happening in one

Re: HintedHandoff Exception and node holding hints to random tokens

2014-01-20 Thread sankalp kohli
Yes as per code you cannot delete hints for endpoints which are not part of the ring. if (!StorageService.instance.getTokenMetadata().isMember(endpoint)) return; On Mon, Jan 20, 2014 at 12:34 PM, Allan C alla...@gmail.com wrote: There are 3 other nodes that have a mild case. This

Re: HintedHandoff Exception and node holding hints to random tokens

2014-01-20 Thread Allan C
 Certainly makes sense to not allow it. Any idea why the node would be holding hints for tokens that don’t exist? -Allan On January 20, 2014 at 1:09:51 PM, sankalp kohli (kohlisank...@gmail.com) wrote: Yes as per code you cannot delete hints for endpoints which are not part of the ring.   if

Data modeling users table with CQL

2014-01-20 Thread Drew Kutcharian
Hey Guys, I’m new to CQL (but have been using C* for a while now). What would be the best way to model a users table using CQL/Cassandra 2.0 Lightweight Transactions where we would like to have: - A unique TimeUUID as the primary key of the user - A unique email address used for logging in In

Question about node tool repair

2014-01-20 Thread Logendran, Dharsan (Dharsan)
Hi, We have a two node cluster with the replication factor of 2. The db has more than 2500 column families(tables). The nodetool -pr repair on an empty database(one or table has a litter data) takes about 30 hours to complete. We are using Cassandra Version 2.0.4. Is there any way for

Re: Question about node tool repair

2014-01-20 Thread sankalp kohli
Can you give the logs of both the machines. Logs will tell why it is taken so long. On a side note, you are using 2500 Cfs. I think you need to redesign this schema. Also 2 node cluster with RF=2, you might want to add a machine if it is prod. On Mon, Jan 20, 2014 at 2:47 PM, Logendran,

Exception in thread main java.lang.NoClassDefFoundError

2014-01-20 Thread Le Xu
Hello! I got this error while trying out Cassandra 1.2.13. The error message looks like: Exception in thread main java.lang. NoClassDefFoundError: org/apache/cassandra/service/CassandraDaemon Caused by: java.lang.ClassNotFoundException: org.apache.cassandra.service.CassandraDaemon at

Re: one or more nodes were unavailable.

2014-01-20 Thread Vivek Mishra
Single node and default consistency. Running via cqsh On Tue, Jan 21, 2014 at 1:47 AM, sankalp kohli kohlisank...@gmail.comwrote: Also do you have any nodes down...because it is possible to reach write consistency and not do CAS because some machines are down. On Mon, Jan 20, 2014 at 12:16

Re: one or more nodes were unavailable.

2014-01-20 Thread Drew Kutcharian
If you are trying this out on a single node, make sure you set the replication_factor of the keyspace to one. On Jan 20, 2014, at 7:41 PM, Vivek Mishra mishra.v...@gmail.com wrote: Single node and default consistency. Running via cqsh On Tue, Jan 21, 2014 at 1:47 AM, sankalp kohli

Re: one or more nodes were unavailable.

2014-01-20 Thread Vivek Mishra
1 have downloaded cassandra 2.x and set up on single machine. Started Cassandra server and connecting via cqlsh. Created a column family and inserting a single record into it(via cqlsh). Wondering why it gives No node available Even though simple insert queries(without CAS) works! -Vivek On

Re: one or more nodes were unavailable.

2014-01-20 Thread Drew Kutcharian
What do you see when you run desc keyspace;” in cqlsh? On Jan 20, 2014, at 10:10 PM, Vivek Mishra mishra.v...@gmail.com wrote: 1 have downloaded cassandra 2.x and set up on single machine. Started Cassandra server and connecting via cqlsh. Created a column family and inserting a single