Sorry I missed that. Both your nodetool status and keyspace replication settings say Cassandra and Analytics for the DC names. I'm not sure where you're seeing DC1, DC2, etc. and why you suspect that is the problem.
All the best, [image: datastax_logo.png] <http://www.datastax.com/> Sebastián Estévez Solutions Architect | 954 905 8615 | sebastian.este...@datastax.com [image: linkedin.png] <https://www.linkedin.com/company/datastax> [image: facebook.png] <https://www.facebook.com/datastax> [image: twitter.png] <https://twitter.com/datastax> [image: g+.png] <https://plus.google.com/+Datastax/about> <http://feeds.feedburner.com/datastax> <http://goog_410786983> <http://www.datastax.com/gartner-magic-quadrant-odbms> DataStax is the fastest, most scalable distributed database technology, delivering Apache Cassandra to the world’s most innovative enterprises. Datastax is built to be agile, always-on, and predictably scalable to any size. With more than 500 customers in 45 countries, DataStax is the database technology and transactional backbone of choice for the worlds most innovative companies such as Netflix, Adobe, Intuit, and eBay. On Fri, Jan 22, 2016 at 1:45 PM, Bhuvan Rawal <bhu1ra...@gmail.com> wrote: > Hi Sebastian, > > I had attached nodetool status output in previous mail, pasting it again : > > $ nodetool status Datacenter: Analytics ===================== > Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load > Tokens Owns Host ID Rack UN 10.41.55.17 428.5 KB 256 ? > 39d6d585-e641-4046-9d0b-797356597b5e rack1 UN 10.41.55.19 404.44 KB 256 ? > 69edf930-efd9-4d74-a798-f3d4ac02e516 rack1 UN 10.41.55.18 423.21 KB 256 ? > b74bab13-09b2-4760-bce9-c8ef05e50f6d rack1 UN 10.41.55.20 683.23 KB 256 ? > fb5c4fed-6e1e-4ea8-838d-358106906830 rack1 Datacenter: Cassandra > ===================== Status=Up/Down |/ > State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns Host ID > Rack UN 10.41.55.15 209.4 KB 256 ? ffc3b9a0-5d5c-4a3d-a99e-49d255731278 > rack1 UN 10.41.55.21 227.44 KB 256 ? c68deba4-b9a2-43fc-bb13-6af74c88c210 > rack1 UN 10.41.55.23 222.71 KB 256 ? 8229aa87-af00-48fa-ad6b-3066d3dc0e58 > rack1 UN 10.41.55.22 218.72 KB 256 ? c7ba84fd-7992-41de-8c88-11574a72db99 > rack1 > > Regards, > Bhuvan Rawal > > On Sat, Jan 23, 2016 at 12:11 AM, Sebastian Estevez < > sebastian.este...@datastax.com> wrote: > >> The output of `nodetool status` would help us diagnose. >> >> All the best, >> >> >> [image: datastax_logo.png] <http://www.datastax.com/> >> >> Sebastián Estévez >> >> Solutions Architect | 954 905 8615 | sebastian.este...@datastax.com >> >> [image: linkedin.png] <https://www.linkedin.com/company/datastax> [image: >> facebook.png] <https://www.facebook.com/datastax> [image: twitter.png] >> <https://twitter.com/datastax> [image: g+.png] >> <https://plus.google.com/+Datastax/about> >> <http://feeds.feedburner.com/datastax> >> <http://goog_410786983> >> >> >> <http://www.datastax.com/gartner-magic-quadrant-odbms> >> >> DataStax is the fastest, most scalable distributed database technology, >> delivering Apache Cassandra to the world’s most innovative enterprises. >> Datastax is built to be agile, always-on, and predictably scalable to any >> size. With more than 500 customers in 45 countries, DataStax is the >> database technology and transactional backbone of choice for the worlds >> most innovative companies such as Netflix, Adobe, Intuit, and eBay. >> >> On Fri, Jan 22, 2016 at 1:39 PM, Bhuvan Rawal <bhu1ra...@gmail.com> >> wrote: >> >>> Thanks for the response Alain, >>> >>> cqlsh> create keyspace mykeyspace WITH replication = >>> {'class':'NetworkTopologyStrategy', 'Analytics':2, 'Cassandra':3} >>> cqlsh> use mykeyspace; >>> cqlsh:mykeyspace>create table mytable (id int primary key, name text, >>> address text, phone text); >>> cqlsh:mykeyspace> insert into mytable (id, name, address, phone) values >>> (1, 'Kiyu','Texas', '555-1212'); # and other similar statement >>> I then issued the below command from every node and found consistent >>> results. >>> cqlsh:mykeyspace> select * from mytable; >>> >>> // Then i repeated the above steps for NetworkTopologyStrategy and found >>> same results >>> >>> I ran basic cassandra stress >>> seed1 - seed of datacenter 1 >>> $ cassandra-stress write n=50000 -rate threads=4 -node any_random_ip >>> $ cassandra-stress write n=50000 -rate threads=4 -node seed1 >>> $ cassandra-stress write n=50000 -rate threads=4 -node seed1,seed2 >>> $ cassandra-stress write n=50000 -rate threads=4 -node >>> all_8_ip_comma_seperated >>> $ cassandra-stress write n=1000000 cl=one -mode native cql3 -schema >>> keyspace="keyspace1" -pop seq=1..1000000 -node ip1,ip2,ip3,ip4 >>> >>> All of them threw the exception >>> *com.datastax.driver.core.exceptions.UnavailableException: Not enough >>> replica available for query at consistency LOCAL_ONE (1 required but only 0 >>> alive)* >>> >>> >>> I have a feeling that the issue is with datacenter name for some reason, >>> because in some config files I found DC name to be like DC1/DC2/DC3 in some >>> it is like Cassandra/Analytics (The ones I had specified while >>> installation). Im unsure which yaml/property file to look for correct >>> inconsistency. >>> >>> (C*heers :) - im so tempted to copy that) >>> >>> Regards, >>> Bhuvan >>> >>> On Fri, Jan 22, 2016 at 8:47 PM, Alain RODRIGUEZ <arodr...@gmail.com> >>> wrote: >>> >>>> Hi, >>>> >>>> The the exact command you ran (stress-tool with options) could be >>>> useful to help you on that. >>>> >>>> However, Im able to create keyspace, tables and insert data using cqlsh >>>>> and it is replicating fine to all the nodes. >>>> >>>> >>>> Having the schema might be useful too. >>>> >>>> Did you ran the cqlsh and the stress-tool from the same server ? If >>>> not, you might want to check the port you use (9042/9160/...) are open. >>>> Also, cqlsh uses local_one by default too. If both commands were run >>>> against the same DC, from the same machine they should behave the same way. >>>> Are they ? >>>> >>>> C*heers, >>>> >>>> ----------------- >>>> Alain >>>> >>>> The Last Pickle >>>> http://www.thelastpickle.com >>>> >>>> >>>> 2016-01-22 9:57 GMT+01:00 Bhuvan Rawal <bhu1ra...@gmail.com>: >>>> >>>>> Hi, >>>>> >>>>> i have created a POC cluster with 2 DC , each having 4 nodes with DSE >>>>> 4.8.1 installed. >>>>> >>>>> On issuing cassandra stress im getting an error and data is not being >>>>> inserted: >>>>> *com.datastax.driver.core.exceptions.UnavailableException: Not enough >>>>> replica available for query at consistency LOCAL_ONE (1 required but only >>>>> 0 >>>>> alive)* >>>>> >>>>> However, Im able to create keyspace, tables and insert data using >>>>> cqlsh and it is replicating fine to all the nodes. >>>>> >>>>> Details of the cluster can be found below (all the nodes seem to be >>>>> alive and kicking): >>>>> >>>>> $ nodetool status Datacenter: Analytics ===================== >>>>> Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load >>>>> Tokens Owns Host ID Rack UN 10.41.55.17 428.5 KB 256 ? >>>>> 39d6d585-e641-4046-9d0b-797356597b5e rack1 UN 10.41.55.19 404.44 KB 256 ? >>>>> 69edf930-efd9-4d74-a798-f3d4ac02e516 rack1 UN 10.41.55.18 423.21 KB 256 ? >>>>> b74bab13-09b2-4760-bce9-c8ef05e50f6d rack1 UN 10.41.55.20 683.23 KB 256 ? >>>>> fb5c4fed-6e1e-4ea8-838d-358106906830 rack1 Datacenter: Cassandra >>>>> ===================== Status=Up/Down |/ >>>>> State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns Host >>>>> ID Rack UN 10.41.55.15 209.4 KB 256 ? ffc3b9a0-5d5c-4a3d-a99e-49d255731278 >>>>> rack1 UN 10.41.55.21 227.44 KB 256 ? c68deba4-b9a2-43fc-bb13-6af74c88c210 >>>>> rack1 UN 10.41.55.23 222.71 KB 256 ? 8229aa87-af00-48fa-ad6b-3066d3dc0e58 >>>>> rack1 UN 10.41.55.22 218.72 KB 256 ? c7ba84fd-7992-41de-8c88-11574a72db99 >>>>> rack1 >>>>> >>>>> Regards, >>>>> Bhuvan Rawal >>>>> >>>>> >>>>> >>>> >>> >> >
