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 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 record into it(via cq

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
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 wrote: > Single node and default consistency. Running via cqsh > > > On Tue, Jan 21, 2014 at 1:47 AM, sankalp kohli wrote: > Also do you ha

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 wrote: > 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

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 jav

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, Dharsan

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

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 t

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

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 wrote: > There are 3 other nodes that have a mild case. This is one node is w

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
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 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 amount of hint

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 wrote: > What consistency level are you using? > > > On Mon, Jan 20, 2014 at 7:16 AM, Vivek Mishra wrote: > >> Hi, >>

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 dow

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 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( > fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1') if no

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: 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 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 have to read the who

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 wrote: > Hi David, > > How do you know that you a

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 sure

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 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 Morton a écrit

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: 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), compaction_through

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 wrote: > Read the upgrade best practices > > http://www.datastax.com/docs/1.1/install/upgrading#best-practices > > You cannot cha

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 Nabb