CODEWITHSUNDEEP
cassandratransactionscql
Telavian
Telavian

Reputation: 3832

Cassandra light weight transactions are failing for a single node cluster

I have a single node Cassandra cluster for simple development activities. All usage works fine however if I attempt to perform a LWT then the query fails with a message indicating not enough hosts were available.

This makes sense if more hosts were configured however if all the hosts are available, which is 1, then it should succeed.

The error in CQLSH is NoHostAvailable. Using the C# driver from Datastax it appears regardless of the consistency level, I tried several, the error is:

Not enough replicas available for query at consistency Quorum (2 required but only 1 alive)

The interesting thing is if I simply remove the "IF NOT EXISTS" from the CQL then the query succeeds.

Should Paxos even be used if there is a single node in the cluster?

Cassandra version:

 [cqlsh 5.0.1 | Cassandra 3.0.11.1485 | CQL spec 3.4.0 | Native protocol v4]

Keyspace:

CREATE KEYSPACE "XYZ" WITH replication = {'class': 'NetworkTopologyStrategy', 'Cassandra': '1', 'Solr': '1'}  AND durable_writes = true;

Nodetool ring:

    administrator@cassandra-dev01:~$ nodetool ring

Datacenter: Cassandra
==========
Address       Rack        Status State   Load            Owns                Token

10.10.98.200  rack1       Up     Normal  106.92 GB       ?                   -8300708032273586829

Datacenter: SearchGraphAnalytics
==========
Address       Rack        Status State   Load            Owns                Token

10.10.98.201  rack1       Up     Normal  13.79 MB        ?                   4478178638510484591

Upvotes: 0

Views: 684

Answers (1)

Marko Švaljek
Marko Švaljek

Reputation: 2101

it looks like node in data center Solr is down or unreachable. When you say just Quorum and not local quorum it will actually go to the other node which is according to what you described.

Upvotes: 1

Related Questions