cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Kumar Maheshwari <Abhishek.Maheshw...@timesinternet.in>
Subject RE: Getting Error while Writing in Multi DC mode when Remote Dc is Down.
Date Mon, 23 Jan 2017 11:47:25 GMT
Hi Benjamin,

I find the issue. while I was making query, I was overriding LOCAL_QUORUM to QUORUM.

Also, one more Question,

I was able insert data in DRPOCcluster. But when I bring up dc_india DC, data doesn’t seem
in dc_india keyspace and column family (I wait near about 30 min)?




Thanks & Regards,
Abhishek Kumar Maheshwari
+91- 9999805591 (Mobile)
Times Internet Ltd. | A Times of India Group Company
FC - 6, Sector 16A, Film City,  Noida,  U.P. 201301 | INDIA
P Please do not print this email unless it is absolutely necessary. Spread environmental awareness.

From: Benjamin Roth [mailto:benjamin.roth@jaumo.com]
Sent: Monday, January 23, 2017 5:05 PM
To: user@cassandra.apache.org
Subject: Re: Getting Error while Writing in Multi DC mode when Remote Dc is Down.

The query has QUORUM not LOCAL_QUORUM. So 3 of 5 nodes are required. Maybe 1 node in DRPOCcluster
also was temporarily unavailable during that query?

2017-01-23 12:16 GMT+01:00 Abhishek Kumar Maheshwari <Abhishek.Maheshwari@timesinternet.in<mailto:Abhishek.Maheshwari@timesinternet.in>>:
Hi All,

I have Cassandra stack with 2 Dc

Datacenter: DRPOCcluster
========================
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
--  Address        Load       Tokens       Owns    Host ID                               Rack
UN  172.29.xx.xxx  88.88 GB   256          ?       b6b8cbb9-1fed-471f-aea9-6a657e7ac80a  01
UN  172.29.xx.xxx  73.95 GB   256          ?       604abbf5-8639-4104-8f60-fd6573fb2e17  03
UN  172.29. xx.xxx  66.42 GB   256          ?       32fa79ee-93c6-4e5b-a910-f27a1e9d66c1 
02
Datacenter: dc_india
====================
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
--  Address        Load       Tokens       Owns    Host ID                               Rack
DN  172.26. .xx.xxx  78.97 GB   256          ?       3e8133ed-98b5-418d-96b5-690a1450cd30
 RACK1
DN  172.26. .xx.xxx  79.18 GB   256          ?       7d3f5b25-88f9-4be7-b0f5-746619153543
 RACK2


I am using below code to connect with java driver:

cluster = Cluster.builder().addContactPoints(hostAddresses).withRetryPolicy(DefaultRetryPolicy.INSTANCE)
                           .withReconnectionPolicy(new ConstantReconnectionPolicy(30000L))
                           .withLoadBalancingPolicy(new TokenAwarePolicy(new DCAwareRoundRobinPolicy.Builder().withLocalDc("DRPOCcluster").withUsedHostsPerRemoteDc(2).build())).build();
cluster.getConfiguration().getQueryOptions().setConsistencyLevel(ConsistencyLevel.LOCAL_QUORUM);

hostAddresses is 172.29.xx.xxx  . when Dc with IP 172.26. .xx.xxx   is down, we are getting
below exception :


Exception in thread "main" com.datastax.driver.core.exceptions.UnavailableException: Not enough
replicas available for query at consistency QUORUM (3 required but only 2 alive)
       at com.datastax.driver.core.exceptions.UnavailableException.copy(UnavailableException.java:109)
       at com.datastax.driver.core.exceptions.UnavailableException.copy(UnavailableException.java:27)
       at com.datastax.driver.core.DriverThrowables.propagateCause(DriverThrowables.java:37)
       at com.datastax.driver.core.DefaultResultSetFuture.getUninterruptibly(DefaultResultSetFuture.java:245)

Cassandra version : 3.0.9
Datastax Java Driver Version:

<dependency>
                                <groupId>com.datastax.cassandra</groupId>
                                <artifactId>cassandra-driver-core</artifactId>
                                <version>3.1.2</version>
                </dependency>


Thanks & Regards,
Abhishek Kumar Maheshwari
+91- 9999805591<tel:+91%2099998%2005591> (Mobile)
Times Internet Ltd. | A Times of India Group Company
FC - 6, Sector 16A, Film City,  Noida,  U.P. 201301 | INDIA
P Please do not print this email unless it is absolutely necessary. Spread environmental awareness.

We the soldiers of our new economy, pledge to stop doubting and start spending, to enable
others to go digital, to use less cash. We pledge to #RemonetiseIndia. Join the Times Network
‘Remonetise India’ movement today. To pledge for growth, give a missed call on +91 9223515515<tel:+91%2092235%2015515>.
Visit www.remonetiseindia.com<http://www.remonetiseindia.com>



--
Benjamin Roth
Prokurist

Jaumo GmbH · www.jaumo.com<http://www.jaumo.com>
Wehrstraße 46 · 73035 Göppingen · Germany
Phone +49 7161 304880-6 · Fax +49 7161 304880-1
AG Ulm · HRB 731058 · Managing Director: Jens Kammerer
Mime
View raw message