Questions tagged [cassandra-2.2]

Casandra is a NoSQL database sponsored by Apache. Use this tag for a question specifically for version 2.2.

46 questions
30
votes
3 answers

What is the batch limit in Cassandra?

I have a Java client that pushes (INSERT) records in batch to Cassandra cluster. The elements in the batch all have the same row key, so they all will be placed in the same node. Also I don't need the transaction to be atomic so I've been using…
m.hashemian
  • 1,786
  • 2
  • 15
  • 31
15
votes
1 answer

Upgrading Cassandra from 2.2 to 3.0 in RHEL

I have a RHEL 7.0 server running Cassandra 2.2.3 which I tried to upgrade to 3.0. When I run yum update it showed me there is a new version of Cassandra for update, and upgraded the server to 2.2.4-1, but not 3.0. Now if I search yum for dsc30 I can…
m.hashemian
  • 1,786
  • 2
  • 15
  • 31
6
votes
0 answers

Cassandra Leveled Compaction Strategy requires 50% disk space overhead

We have a 24 node AWS cluster (i2.xlarge) running Cassandra 2.2.5. We have one large table and a few smaller ones. The large table consumes most of the disk space. Disk usage is unexpectedly increasing. We are using LCS and have noticed that the…
user6575408
5
votes
1 answer

High Native-Transport-Requests All time Blocked

After running tpstats on all nodes. I see a lot of nodes having high number of ALL TIME BLOCKED NTR. We have a 4 node cluster and the values for NTR ALL TIME BLOCKED are : NODE 1: 23953 NODE 2: 2935 NODE 3: 15229 NODE 4: 5951 I know ALL TIME BLOCKED…
johri21
  • 153
  • 1
  • 9
5
votes
2 answers

Cassandra version upgrade from 2.0.9 to 2.2

We are planning to upgrade our cluster which currently runs on 2.0.9 to 2.2.6. According to the documentation and some blogs people upgrade cassandra inplace ie remove a node from ring upgrade it and add it back again. We are skeptical of following…
johri21
  • 153
  • 1
  • 9
4
votes
1 answer

Unexpected exception during request

I'm using apache cassandra 2.2.4. I have a 4 (four) node cluster with Replication Factor 3 in DC1 and Replication Factor 1 in DC2, where DC1 contains 3 (three) nodes and DC2 contains 1 (one) node. There were some more nodes before in this cluster,…
Anower Perves
  • 754
  • 8
  • 15
4
votes
2 answers

Cassandra: select only latest rows

I work with following table: CREATE TABLE IF NOT EXISTS lp_registry.domain ( ownerid text, name1st text, name2nd text, name3rd text, registrar text, registered timestamp, expiration timestamp, updated timestamp, …
Michal
  • 1,955
  • 5
  • 33
  • 56
3
votes
2 answers

Is it safe to run sstableverify against live sstables?

Is it safe to run sstableverify against live sstables while Cassandra is running? After and while running sstableverify in a lab, I cannot find anything in any logs that would indicate a problem.
kalaolani
  • 323
  • 1
  • 16
2
votes
2 answers

Cassandra database import issue for timeuuid

I have installed Cassandra 2.2.12 on my window machine locally. I have exported database from live server in a '.sql' file using 'razorsql' GUI tool. I don't have server access for live, only have database access. When i am trying ti import '.sql'…
M.Bains
  • 395
  • 1
  • 2
  • 14
2
votes
2 answers

launching cassandra cqlsh python not found

I am trying to install cassandra version 2.2.0 and I found the compatible python version for it is 2.7.10 then I installed it. when I type in terminal python2.7 --version Python 2.7.10 but when I launch cassandra server and want to start cassandra…
Eman
  • 111
  • 1
  • 4
  • 14
2
votes
0 answers

Cassandra PHP: "All connections on all I/O threads are busy" after adding node

I am facing a strange problem with cassandra connection, after I added new cassandra node. Situation before adding node: 1 cassandra node on server 1 in data center 1 Fully operational java applications distributed over many machines PHP nginx web…
Michal
  • 1,955
  • 5
  • 33
  • 56
2
votes
3 answers

Cassandra restart issues while restoring to a new cluster

I am restoring to a fresh new Cassandra 2.2.5 cluster consisting of 3 nodes. Initial cluster health of the NEW cluster: -- Address Load Tokens Owns Host ID Rack UN 10.40.1.1 259.31 KB 256 …
prat0318
  • 571
  • 1
  • 8
  • 19
2
votes
1 answer

Cassandra 3 nodes cluster throwing NoHostAvailableException as soon as one node is down

We have a 3 nodes cluster with a RF 3. As soon as we drain one node from the cluster we see many: All host(s) tried for query failed (no host was tried) com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed…
Etienne
  • 226
  • 1
  • 12
2
votes
0 answers

Distributed pagination in Cassandra

I was searching for pagination in cassandra and found this perfect topic here: Results pagination in Cassandra (CQL) , with this answer accepted by majority of people. But I want to do same thing on multiple computers. I'll provide an example... The…
Michal
  • 1,955
  • 5
  • 33
  • 56
2
votes
1 answer

Cassandra CQL: Batch select

Hi I have following table in Cassandra: * --------------------------------------------------------------------------- * Note: * 'curr_pos' is always fixed, so we can put it into cluster key and order * In each crawler iteration 'prev_pos',…
Michal
  • 1,955
  • 5
  • 33
  • 56
1
2 3 4