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