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

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 i...@newage.co.il wrote:

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

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

Re: decommissioning a node

Try this: nodetool decomission host-id-of-node-to-decomission UN means UP, NORMAL -- Colin +1 320 221 9531 On Sun, May 25, 2014 at 9:09 AM, Tim Dunphy bluethu...@gmail.com wrote: Also for information that may help diagnose this issue I am running cassandra 2.0.7 I am also using these

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

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

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

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

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 j...@basetechnology.com 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

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