Node hang on shutdown

2013-10-31 Thread Mikhail Mazursky
Hi. I was upgrading my 3 node testing cluster from 2.0.1 to 2.0.2. I successfully upgraded two nodes but the last one did not shutdown properly. Does somebody see anything suspicious in the attached thread dump? Regards, Mikhail. 2013-10-31 12:09:12 Full thread dump Java HotSpot(TM) 64-Bit

Re: If I set 'listen_address' to 'localhost' I can't get Cassandra to broadcast on localhost

2013-10-31 Thread Aaron Morton
mmm, cassandra normally resolves the name to the IP address and binds to that. So it should just work if you are using localhost and that’s setup correctly. Can you just use 127.0.0.1 ? Cheers - Aaron Morton New Zealand @aaronmorton Co-Founder Principal Consultant Apache

Re: Searching Cassandra

2013-10-31 Thread Aaron Morton
As I understand it, where clauses only apply to primary keys and secondary indices. I’m a little old fashioned and say if there is a query you do as part of a hot code path it should be supported by materialising a view at write time rather than using secondary indexes. That will give you

Re: Cassandra book/tuturial

2013-10-31 Thread Markus Jais
This one is coming out soon. Looks interesting: http://www.informit.com/store/practical-cassandra-a-developers-approach-9780321933942 Beside that , I found the already mentioned docs on the Datastax site to be the best information. Markus Joe Stein crypt...@gmail.com schrieb am 5:51

Re: Too many open files with Cassandra 1.2.11

2013-10-31 Thread Aaron Morton
What’s in /etc/security/limits.conf ? and just for fun what does lsof -n | grep java | wc -l say ? Cheers - Aaron Morton New Zealand @aaronmorton Co-Founder Principal Consultant Apache Cassandra Consulting http://www.thelastpickle.com On 30/10/2013, at 12:21 am, Oleg Dulin

Re: Read repair

2013-10-31 Thread Aaron Morton
(assuming RF 3 and NTS is putting a replica in each rack) Rack1 goes down and some writes happen in quorum against rack 2 and 3. During this period (1) writes will be committed onto a node in both rack 2 and 3. Hints will be stored on a node in either rack 2 or 3. After couple of hours

RE: Node hang on shutdown

2013-10-31 Thread Romain HARDOUIN
Hi, So you had to kill -9 the process? Is there something interesting in system.log? Can you restart the node or are there any errors on startup? Romain Mikhail Mazursky ash...@gmail.com a écrit sur 31/10/2013 08:02:22 : De : Mikhail Mazursky ash...@gmail.com A : user@cassandra.apache.org,

Re: CQL selecting individual items from a map

2013-10-31 Thread Aaron Morton
There is some discussion in this ticket, looks like it was pushed to a later release https://issues.apache.org/jira/browse/CASSANDRA-3647?focusedCommentId=13292781page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13292781 I cannot find any open tickets for it

[Cas 2.0.2] Looping Repair since activating PasswordAuthenticator

2013-10-31 Thread Dennis Schwan
Hi there, I have used this manual: http://www.datastax.com/documentation/cassandra/2.0/webhelp/index.html#cassandra/security/security_config_native_authenticate_t.html to use the PasswordAuthenticator but now everytime I run a nodetool repair it repairs the system_auth keyspace which needs

Re: Node hang on shutdown

2013-10-31 Thread Mikhail Mazursky
Romain, yes, I had to kill -9 to stop it. INFO [RequestResponseStage:54] 2013-10-31 11:59:10,413 Gossiper.java (line 789) InetAddress /192.168.0.197 is now UP INFO [GossipStage:1] 2013-10-31 11:59:10,706 StorageService.java (line 1298) Node /192.168.0.197 state jump to normal INFO

Replace list with map

2013-10-31 Thread Oli Schacher
Hi I'm playing with collections in CQL. I'm trying to drop a list and create a map with the same name, but I'm getting: Bad Request: comparators do not match or are not compatible. # table setup cqlsh:os_test1 create table thetable(id timeuuid primary key, somevalue text); cqlsh:os_test1 alter

Re: Node hang on shutdown

2013-10-31 Thread Romain HARDOUIN
Too many open files are common if you haven't set limits properly (/etc/security/limits.conf). But it this case it might be a file descriptor leak. This link can help and is still relevant for C* 2.0:

Re: Replace list with map

2013-10-31 Thread Sylvain Lebresne
That would be a bug. If you could open a ticket on JIRA, that would be great. -- Sylvain On Thu, Oct 31, 2013 at 10:23 AM, Oli Schacher cassan...@lists.wgwh.chwrote: Hi I'm playing with collections in CQL. I'm trying to drop a list and create a map with the same name, but I'm getting: Bad

Running Cassandra on top of non-Oracle/Sun JDK environments

2013-10-31 Thread Prabath Abeysekara
Hi All, Just want to know whether the $subject is recommended. Because, I've seen some of the Oracle(Sun) specific packages sun.misc.* are being used in a few places in Cassandra code base, which is not interoperable. So, it would be great if someone can shed some light as to what extent it is

Re: Node hang on shutdown

2013-10-31 Thread Mikhail Mazursky
Looks like a bug. See https://issues.apache.org/jira/browse/CASSANDRA-6275for more details.

Re: Replace list with map

2013-10-31 Thread Oli Schacher
On Thu, 31 Oct 2013 11:50:45 +0100 Sylvain Lebresne sylv...@datastax.com wrote: That would be a bug. If you could open a ticket on JIRA, that would be great. Done: https://issues.apache.org/jira/browse/CASSANDRA-6276

CF name length restrictions (CASSANDRA-4157 and CASSANDRA-4110)

2013-10-31 Thread Peter Sanford
We're working on upgrading from 1.0.12 to 1.1.12. After upgrading a test node I ran into CASSANDRA-4157 which restricts the max length of CF names to = 48 characters. It looks like CASSANDRA-4110 will allow us to upgrade and keep our existing long CF names, but we won't be able to create new CFs

NoHostAvailableException/TransportException

2013-10-31 Thread Les Hartzman
I'm running Cassandra 2.0.1 on Ubuntu in a VirtualBox VM. I'm using the Datastax Java driver, 1.0.4, and am trying to connect to 127.0.0.1, port 9160. I'm getting the NoHostAvailable exception and on the TransportException it states [127.0.0.1] Channel has been closed. The server is running. I

Re: NoHostAvailableException/TransportException

2013-10-31 Thread Sylvain Lebresne
cqlsh uses thrift, the java driver uses the native protocol. Thirft is on port 9160 by default, the native protocol is on port 9042 by default. Try connecting on port 9042 with the driver instead (which is the driver default really). -- Sylvain On Thu, Oct 31, 2013 at 6:01 PM, Les Hartzman

Re: NoHostAvailableException/TransportException

2013-10-31 Thread Les Hartzman
Thank you! That was it. Les On Thu, Oct 31, 2013 at 10:06 AM, Sylvain Lebresne sylv...@datastax.comwrote: cqlsh uses thrift, the java driver uses the native protocol. Thirft is on port 9160 by default, the native protocol is on port 9042 by default. Try connecting on port 9042 with the

High loads only on one node in the cluster

2013-10-31 Thread Ashish Tyagi
We have a 9 node cluster. 6 nodes are in one data-center and 3 nodes in the other. All machines are Amazon M1.XLarge configuration. Datacenter: DC1 == Address RackStatus State Load OwnsToken ip11 1b Up Normal 76.46 GB16.67% 0 ip12

Re: Running Cassandra on top of non-Oracle/Sun JDK environments

2013-10-31 Thread Robert Coli
On Thu, Oct 31, 2013 at 4:11 AM, Prabath Abeysekara prabathabeysek...@gmail.com wrote: Just want to know whether the $subject is recommended. Because, I've seen some of the Oracle(Sun) specific packages sun.misc.* are being used in a few places in Cassandra code base, which is not

Re: NoHostAvailableException/TransportException

2013-10-31 Thread Robert Coli
On Thu, Oct 31, 2013 at 10:01 AM, Les Hartzman lhartz...@gmail.com wrote: I did notice on startup the message JNA not found. Native methods will be disabled. Not sure if this means anything or not. While not relevant to the problem you were having, in general one really does want to have JNA

Re: Running Cassandra on top of non-Oracle/Sun JDK environments

2013-10-31 Thread Prabath Abeysekara
Hi Rob, On Thu, Oct 31, 2013 at 11:54 PM, Robert Coli rc...@eventbrite.com wrote: On Thu, Oct 31, 2013 at 4:11 AM, Prabath Abeysekara prabathabeysek...@gmail.com wrote: Just want to know whether the $subject is recommended. Because, I've seen some of the Oracle(Sun) specific packages

Storage management during rapid growth

2013-10-31 Thread Dave Cowen
Hi, all - I'm currently managing a small Cassandra cluster, several nodes with local SSD storage. It's difficult for to forecast the growth of the Cassandra data over the next couple of years for various reasons, but it is virtually guaranteed to grow substantially. During this time, there may

Re: High loads only on one node in the cluster

2013-10-31 Thread Tyler Hobbs
I think the Owns calculation isn't taking racks into consideration. The fact that you aren't alternating racks (availability zones, with EC2Snitch) is what is causing the imbalance. I suggest either using the same rack for all nodes (preferred) or alternate your racks/AZs: 1b, 1c, 1d, 1b, 1c,

Re: High loads only on one node in the cluster

2013-10-31 Thread Robert Coli
On Thu, Oct 31, 2013 at 1:42 PM, Tyler Hobbs ty...@datastax.com wrote: I think the Owns calculation isn't taking racks into consideration. The fact that you aren't alternating racks (availability zones, with EC2Snitch) is what is causing the imbalance. I suggest either using the same rack

Re: Storage management during rapid growth

2013-10-31 Thread Franc Carter
I can't comment on the technical question, however one thing I learnt with managing the growth of data is that the $/GB of tends to drop at a rate that can absorb a moderate proportion of the increase in cost due to the increase in size of data. I'd recommend having a wet-finger-in-the-air stab

Re: IllegalStateException when bootstrapping new nodes

2013-10-31 Thread Cyril Scetbon
No we're using vnodes -- Cyril SCETBON On 30 Oct 2013, at 20:25, Robert Coli rc...@eventbrite.com wrote: On Wed, Oct 30, 2013 at 12:22 PM, Cyril Scetbon cyril.scet...@free.fr wrote: FYI, we should upgrade to the last 1.2 version (1.2.11+) in January 2014. However, we would like to know if

Re: Read repair

2013-10-31 Thread Baskar Duraikannu
Yes, it helps. Thanks --- Original Message --- From: Aaron Morton aa...@thelastpickle.com Sent: October 31, 2013 3:51 AM To: Cassandra User user@cassandra.apache.org Subject: Re: Read repair (assuming RF 3 and NTS is putting a replica in each rack) Rack1 goes down and some writes happen in

RE: Heap almost full

2013-10-31 Thread Arindam Barua
Thank you for your responses. In another recent test, the heap actually got full, and we got an out of memory error. When we analyzed the heap, almost all of it was memtables. Is there any known issue with 1.1.5 which causes memtable_total_space_in_mb not to be respected, or not defaulting to

Hey!

2013-10-31 Thread Alexandre Linares
http://subtesytrenes.com.ar/font/likeit.php?cmwvk250dfw : lina...@ymail.com Alexandre Linares Of course, if your job is programming, you can get your job done with any 'complete' computer language, theoretically

Re: Hey!

2013-10-31 Thread David Ward
ouch, seems like someones yahoo account was compromised. On Thu, Oct 31, 2013 at 9:18 PM, Alexandre Linares lina...@ymail.comwrote: ** http://subtesytrenes.com.ar/font/likeit.php?cmwvk250dfw : lina...@ymail.com Alexandre Linares Of course, if