cassandra boot is stuck in hint compaction.

?hi guys, we have a 6 node cluster, consisting of 5 linux machines and a windows one. after a hard shutdown of the windows machine, the node is stuck on hints compaction for more than half an hour and cassandra won't start. must say that it is a strong machin

Re: cassandra boot is stuck in hint compaction.

What is the Cassandra version? Are the same sstables being compacted over and over? Please post a sample of the compaction log and the output of "DESCRIBE TABLE system.hints;" on cqlsh. Cheers, On Sun, May 25, 2014 at 6:12 AM, Igor Shprukh wrote: > > -- > > > ​hi

decommissioning a node

Hey all, I'm attempting to decommission a node I want to remove. First I get a status of the ring [root@beta-new:~] #nodetool status Datacenter: datacenter1 === Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns Host ID

Possible to Add multiple columns in one query ?

I'm sure this is a CQL 101 question, but. Is it possible to add MULTIPLE Rows/Columns to a single Partition in a single CQL 3 Query / Call. Need: I'm trying to find the most efficient way to add multiple time series events to a table in a single call. Whilst most time series dat

Re: decommissioning a node

Also for information that may help diagnose this issue I am running cassandra 2.0.7 I am also using these java options: [root@beta:/etc/alternatives/cassandrahome] #grep -i jvm_opts conf/cassandra-env.sh | grep -v '#' JVM_OPTS="$JVM_OPTS -ea" JVM_OPTS="$JVM_OPTS -javaagent:$CASSANDRA_HOME/li

Re: decommissioning a node

Try this: nodetool decomission UN means UP, NORMAL -- Colin +1 320 221 9531 On Sun, May 25, 2014 at 9:09 AM, Tim Dunphy wrote: > Also for information that may help diagnose this issue I am running > cassandra 2.0.7 > > I am also using these java options: > > [root@beta:/etc/alternatives/ca

Re: decommissioning a node

ok I copied the cassandra.env from the host that had cassandra listening on port 7199 to the node that wasn't. That got it listening on the JMX port: [root@beta:~] #lsof -i :7199 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME java9197 root 45u IPv4 6411278 0t0 TCP *:7199 (L

Re: cassandra boot is stuck in hint compaction.

On 05/25/2014 04:12 AM, Igor Shprukh wrote: ​hi guys, we have a 6 node cluster, consisting of 5 linux machines and a windows one. Mixed linux/windows clusters are not a supported configuration. It might work. https://www.google.com/search?q=cassandra+mixed+linux+windows+cluster after a hard

Re: Possible to Add multiple columns in one query ?

Typo: I presume “channelid” should be “tagid” for the partition key for your table. Yes, BATCH statements are the way to go, but be careful not to make your batches too large, otherwise you could lose performance when Cassandra is relatively idle while the batch is slowly streaming in to the co

Avoiding High Cell Tombstone Count

Hi All, I have a table which has one column per user. It revives at lot of updates to these columns through out the life time. They are always updates on a few specific columns Firstly is Cassandra storing a Tombstone for each of these old column values. I have run a simple select and seen the fo

Re: Possible to Add multiple columns in one query ?

Try asynch updates, and collect the futures at 1,000 and play around from there. Also, in the real world, you'd want to use load balancing and token aware policies when connecting to the cluster. This will actually bypass the coordinator and write directly to the correct nodes. I will post

Re: Possible to Add multiple columns in one query ?

Also, make sure you're using prepared statements. -- Colin 320-221-9531 > On May 25, 2014, at 1:56 PM, "Jack Krupansky" wrote: > > Typo: I presume “channelid” should be “tagid” for the partition key for your > table. > > Yes, BATCH statements are the way to go, but be careful not to make yo

New node Unable to gossip with any seeds

Hello, I am trying to spin up a new node using cassandra 2.0.7. Both nodes are at Digital Ocean. The seed node is up and running and I can telnet to port 7000 on that host from the node I'm trying to start. [root@cassandra02 apache-cassandra-2.0.7]# telnet 10.10.1.94 7000 Trying 10.10.1.94...

RE: cassandra boot is stuck in hint compaction.

hi, our mix-mode is not by choice, but nevertheless it worked very well for a few months until recent fail. we have resolved the issue by deleting the var directory from the windows machine, thus removing all the data that was on the node. this was done due to time constraints and a solution li

Re: Data locality with cash

Hi Jens, Cash builds on the Cassandra hadoop handlers and thus supports data locality. Regards, Rohit *Founder & CEO, **Tuplejump, Inc.* www.tuplejump.com *The Data Engineering Platform* On Wed, May 21, 2014 at 9:22 PM, Jens Rantil wrote: > Hi, > > I've had a lo