Re: How does Local quorum consistency work ?? response from fastest node?

x27;re right the coordinator should have sent a digest request to > another node. > Did you executed this request with cql ? Are you sure you have correctly > set the consistency before executing the request ? > > -- > Nicolas > > > > Le jeu. 22 sept. 2016 à 11:52, Jose

Re: How does Local quorum consistency work ?? response from fastest node?

Hi, Below is a sample trace for a LOCAL_QUORUM query . I've changed the query table/col names and actual node IP addresses to IP.1 and IP.coord (for the co-ordinator node). RF=3 and we have 2 DCs. Don't we expect to see an "IP.2" since LOCAL_QUORUM requires the co-ordinator to receive at least 2 r

Re: Read timeouts on primary key queries

ead? Thanks, Joseph On Wed, Sep 7, 2016 at 5:26 PM, Joseph Tech wrote: > Thanks, Romain for the detailed explanation. We use log4j 2 and i have > added the driver logging for slow/error queries, will see if it helps to > provide any pattern once in Prod. > > I tried getendpoints a

Re: Read timeouts on primary key queries

reshold(1000).build(); >cluster.register(queryLogger); > > Then in your driver logback file: > > level="DEBUG" /> > > *3) *And/or: you mentioned that you use DSE so you can enable slow > queries logging in dse.yaml (cql_slow_log_options) >

Re: Read timeouts on primary key queries

equal to) 1109 >> cells. >> You can see these data of a given sstable with the tool sstablemetadata. >> >> Best, >> >> Romain >> >> >> >> Le Lundi 5 septembre 2016 15h17, Joseph Tech a >> écrit : >> >> >> Thanks, R

Re: Read timeouts on primary key queries

me, value, timestamp) > > Also, I see that you have set sstable_size_in_mb at 50 MB. What is the > rational behind this? (Yes I'm curious :-) ). Anyway your "SSTables per > read" are good. > > Best, > > Romain > > Le Lundi 5 septembre 2016 13h32, Joseph Tec

Re: Read timeouts on primary key queries

gt; > Regard, > > Ryan Svihla > > _ > From: Joseph Tech > Sent: Wednesday, August 31, 2016 11:16 PM > Subject: Re: Read timeouts on primary key queries > To: > > > > Patrick, > > The desc table is below (only col names changed) : > > CREATE TABLE db.tbl

Re: Read timeouts on primary key queries

r ledge where you go from single digit ms to 4 or > 5 digit ms times. > > The other place to look is your data model for that table if you want to > post the output from a desc table. > > Patrick > > > > On Tue, Aug 30, 2016 at 11:07 AM, Joseph Tech > wrote: >

Re: Read timeouts on primary key queries

+91 124-415-6069 *EXT*: 12369 > Plot # 362, ASF Centre - Tower A, Udyog Vihar, > Phase -4, Sector 18, Gurgaon, Haryana 122016, INDIA > > On Tue, Aug 30, 2016 at 5:10 PM, Joseph Tech > wrote: > >> Hi Patrick, >> >> The nodetool status shows all nodes up and nor

Re: Read timeouts on primary key queries

o a datacenter mis-match > on node count + RF. > > What does your nodetool status look like? > > Patrick > > On Mon, Aug 29, 2016 at 10:14 AM, Joseph Tech > wrote: > >> Hi, >> >> We recently started getting intermittent timeouts on prima

Read timeouts on primary key queries

Hi, We recently started getting intermittent timeouts on primary key queries (select * from table where key=) The error is : com.datastax.driver.core.exceptions.ReadTimeoutException: Cassandra timeout during read query at consistency LOCAL_QUORUM (2 responses were required but only 1 replica a re

Re: DSE Search : NPE when executing Solr CQL queries using solr_query

- try removing this FOT and see if the NPE > still occurs. For example, maybe the FOT is setting an output column value > to NULL. > > Also, see if there is a "Caused By" entry elsewhere in the Java stack > trace. > > -- Jack Krupansky > > On Tue, Apr 12, 2016 at

Re: Read data from specific node in cassandra

Please check if nodetool getendpoints be used, if you know the key (going by your problem description) On 6 May 2016 22:04, "Siddharth Verma" wrote: @Joseph, An incident we saw in production, and have a speculation as to how it might have occured. *A detailed description of use case* *Incident

Re: Read data from specific node in cassandra

@Siddharth , is there any specific user case where this is required ; What if the mainHost goes down? On Fri, May 6, 2016 at 12:50 PM, Siddharth Verma < verma.siddha...@snapdeal.com> wrote: > Hi, > Whitelist worked perfectly. > Thanks for the help. > > In case, someone wants to use the same, the

Re: LeveledCompaction sstable counts

Thanks, Eric. Just curious, at what point does the old sstables get deleted from disk? On Fri, May 6, 2016 at 8:41 PM, Eric Evans wrote: > On Fri, May 6, 2016 at 8:15 AM, Joseph Tech wrote: > > Please let me know how to interpret the below output from cfstats, > > especially th

LeveledCompaction sstable counts

Hi, Please let me know how to interpret the below output from cfstats, especially the entry in bold. SSTable count: 947 SSTables in each level: [1, 10, *104/100*, 832, 0, 0, 0, 0, 0] We are using C* 2.0.14.459 (DSE version 4.6.7). and the table has been created with : compaction={'sstable_size_

on-disk size vs partition-size in cfhistograms

Hi, I am trying to get some baselines for capacity planning. The approach i took was to insert increasing number of rows into a replica of the table to sized, watch the size of the "data" directory (after doing nodetool flush and compact), and calculate the average size per row (total directory s

DSE Search : NPE when executing Solr CQL queries using solr_query

hi, I am facing an issue where Solr queries executed from cqlsh using the solr_query field is throwing an NPE in system.log, while cqlsh shows the following error: Unable to complete request: one or more nodes were unavailable. These queries work fine thru the Solr admin console UI. Below is th

Re: Single node Solr FTs not working

adable, and seems it got silently ignored. There is no mention about this in the documentation. If it requires a hardcoded name, i suggest it shouldn't be exposed as an attribute itself. //wont work //works Thanks, Joseph On Fri, Mar 18, 2016 at 9:33 PM, Joseph Tech wrote: > I had verifi

Single node Solr FTs not working

Hi, I had setup a single-node DSE 4.8.x to start in Search mode to explore some aspects of Solr search with field transformers (FT). Even though the configuration seems fine and Solr admin shows the indexed data, and searches on the actual fields (stored=true) work fine, but the FTs are not being

Re: Single node Solr FTs not working

e > will help highlight what the difference is that causes the problem. > > Doc: > > http://docs.datastax.com/en/latest-dse/datastax_enterprise/srch/srchTrnsFrm.html > > -- Jack Krupansky > > On Fri, Mar 18, 2016 at 4:30 AM, Joseph Tech > wrote: > >> Hi, >&

On-disk size comparison test steps

Hi, I'm trying to compare the on-disk storage required for a column storing the same content but with two data types (text and blob) for key and value. These are defined in separate tables and same data is inserted to both. The table with blob has STCS and SnappyCompressor, while the one with text

Re: Cassandra DSE Solr - search JSON content in column

h leaf value of the nested > tree. > > -- Jack Krupansky > > On Wed, Jan 13, 2016 at 11:40 PM, Joseph Tech > wrote: > >> Thanks, Field Transformers is exactly what i was looking for. Mine is a >> somewhat nested object, so will need to see how complex the transformer

Re: Cassandra DSE Solr - search JSON content in column

e storing in JSON format, searching data inside a JSON > is equivalent to a wildcard seach *xxx* and it is quite expensive, even for > full text search engines like Solr > > On Wed, Jan 13, 2016 at 2:50 PM, Joseph Tech > wrote: > >> Hi, >> >> Is it possible i

Cassandra DSE Solr - search JSON content in column

Hi, Is it possible in DSE Cassandra Solr to search for JSON content within a column? We store a complex JSON in a column of type "text", very simplified version below. { "userId": "user100", "addressList": [{ "addressId": "100", "address": "100 ABC Street" }], "userName": "user11" } In this, can