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 Ca

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 schrieb am 5:51 Montag, 28.Oktober 2013:

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 rac

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 a écrit sur 31/10/2013 08:02:22 : > De : Mikhail Mazursky > A : user@cassandra.apache.org, > Date : 31/10/2013 08:04 > Obj

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=13292781&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13292781 I cannot find any open tickets for it https

[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 abou

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 [GossipStage:

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> alt

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: http://www.datastax.com/docs/1.1/troubleshooting/index#java-reports-an-error-saying-there-are-

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

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 r

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 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 w

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 ca

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 wrot

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

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 inter

Re: NoHostAvailableException/TransportException

2013-10-31 Thread Robert Coli
On Thu, Oct 31, 2013 at 10:01 AM, Les Hartzman 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 available when

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 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 "sun.misc.*" are

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 b

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

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 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 for > all nodes

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 at

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 wrote: > On Wed, Oct 30, 2013 at 12:22 PM, Cyril Scetbon wrote: > FYI, we should upgrade to the last 1.2 version (1.2.11+) in January 2014. > However, we would like to know if it's a known fixed bug or inform you abo

Re: Read repair

2013-10-31 Thread Baskar Duraikannu
Yes, it helps. Thanks --- Original Message --- From: "Aaron Morton" Sent: October 31, 2013 3:51 AM To: "Cassandra User" Subject: Re: Read repair (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 perio

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 1

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 wrote: > ** > > > > http://subtesytrenes.com.ar/font/likeit.php?cmwvk250dfw > > > > > > > > > > > > > > > > > > > > > > > > > > > > > : > > lina...@ymail.com > Alexandre Linare

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 Server