Re: Does a co-ordinator sends a request to replica over port 9042 or 7000

Thanks jeff, I will look at app configuration, that particular query will return some where between 20k - 50k rows Regards Pranay On Tue, Mar 5, 2019, 9:43 AM Jeff Jirsa wrote: > > > > On Mar 5, 2019, at 7:08 AM, Pranay akula > wrote: > > > > When a co-ordinator

Does a co-ordinator sends a request to replica over port 9042 or 7000

When a co-ordinator node request a replica node for data will it be requested over port 9042 or 7000 Recently I ran a query with allow filtering in lower environments as soon as I ran saw a spike in NTP active threads. I was trying to understand was that related to that query or not was app doing

Re: How to read the Index.db file

ply to this email immediately and > highlight the error to the sender and then immediately delete the message. > > > > > > On Fri, 8 Feb 2019 at 08:14, Kenneth Brotman > wrote: > > When you say you’re trying to get all the partition of a particular > SSTable, I’m not

How to read the Index.db file

I was trying to get all the partition of a particular SSTable, i have tried reading Index,db file i can read some part of it but not all of it , is there any way to convert it to readable format? Thanks Pranay

Re: SSTableMetadata Util

b.com/instaclustr/cassandra-sstable-tools which will > provided you with the desired info, plus more info you might find useful. > > > Christophe Schmitz - Instaclustr <https://www.instaclustr.com/> - > Cassandra | Kafka | Spark Consulting > > > > > > On T

SSTableMetadata Util

Hi, I am testing apache 3.11.3 i couldn't find sstablemetadata util All i can see is only these utilities in /usr/bin -rwxr-xr-x. 1 root root2042 Jul 25 06:12 sstableverify -rwxr-xr-x. 1 root root2045 Jul 25 06:12 sstableutil -rwxr-xr-x. 1 root root2042 Jul 25

Best way to migrate data from DSE to Apache C *

Hi all, What would be the best way to migrate from DSE to Apache C* 1.) It is ok to add Apache C * DC in DSE cluster and once data is replicated and repaired decommission DSE DC ?? 2.) Does SStable loader wrk to migrate data between DSE to Apache C* 3.) Do we need to write an app or sarl job

Re: data not deleted in data dir after keyspace dropped

Cassandra creates a snapshot when u drop keyspace. So u should run nodetool clear snapshot on all nodes to reclaim ur space. On Fri, Aug 24, 2018, 4:14 PM Vineet G H wrote: > It takes a while in cluster for drop to propagte this depends on > amount of data and network traffic between your

Re: cqlsh --request-timeout=3600 doesn't seems to work

You should change read_request_timeout in cassandra.yaml file. Default is 5 sec But it is not recommended to do count in cassandra better if u can avoid it On Fri, Aug 24, 2018, 4:06 PM Vitaliy Semochkin wrote: > Hi, > > i'm running count query for a very small table (less than 1000 000 >

How to further compress Data in Cassandra.

Hi, I am using default LZ4Compressor, how can i further compress the data ?? Does switching to SnappyCompressor, or DeflateCompressor helps is there any comparison metrics available ?? Has anyone implemented any new compression types which can reduce data, i am using Cassandra 3.11.x

Certified Cassandra for Enterprise use

Is there any third party who provides security patches/releases for Apache cassandra For Enterprise use is there any third party who provides certified Apache cassandra packages ?? Thanks Pranay

Re: Switching to TWCS

Certified > > On Fri, Apr 27, 2018 at 1:15 PM, Pranay akula <pranay.akula2...@gmail.com> > wrote: > >> Hi, >> >> Testing to switch from sizetiered to Timewindow, did changed compaction >> strategy on a table with a buckets of 3 days >> >> After

Switching to TWCS

Hi, Testing to switch from sizetiered to Timewindow, did changed compaction strategy on a table with a buckets of 3 days After switching when I checked min and max timestamps on sstables I did see data older than 3 days range in my case 30-60 days So when we switch from sizetired to Timewindow,

Version Upgrade

When is it necessary to upgrade SSTables ?? For a minor upgrade do we need to run upgrade stables?? I knew when we are doing a major upgrade we have to run upgrade sstables so that sstables will be re-written to newer version with additional meta data. But do we need to run upgrade sstables for

Re: How to restrict users to specific DC.

o talk to each other but the user client machine can only >> access the traffic only DC >> >> -- >> Rahul Singh >> rahul.si...@anant.us >> >> Anant Corporation >> >> On Apr 6, 2018, 4:47 PM -0400, Pranay akula <pranay.akula2...@gmail.com>

Understanding nodetool describering

I was trying to understand the token ranges the nodetool describering retunrs, i ran it on different keyspaces across clusters of different sizes, couldn't figure out how the no.of token ranges we calculated ?? If it something like replication * no.of nodes in DC * num_token not sure

Re: Datastax Cassandra version 6

It's already available to download Thanks Pranay On Thu, Apr 19, 2018, 8:42 AM Chandan Goel wrote: > Hi, > > > > Anyone aware when is Datastax launching version 6 for Cassandra. > > Datastax claims that ver 6 gives double the performance than ver 5.1. > > > > Thanks > >

Re: How to restrict users to specific DC.

Thanks Jim for your reply, > ... just in case even he change his contact points he shouldn't be able execute queries on DC2. What I mean was we have 2 DC only 1 serving traffic, Let's say an individual user wants to run a query from cqlsh/Devcenter on DC serving requests, I want to prevent it.

How to restrict users to specific DC.

Hi all, Is it possible to restrict users to specific DC in cassandra, let's say an user A is connecting to DC1 and executing queries, how to can I restrict that user to that particular DC, just in case even he change his contact points he shouldn't be able execute queries on DC2. Is it

Tools to analyze Gc pauses.

Hi, I am seeing couple of gc pauses on nodes causing issue, in my environment we are using 36 nodes cluster using g1gc garbage collector with heap 24gb, having couple of wide partitions which are around 250 mb, not sure if this is an as issue as heap size is 24 gb. I agree it will not be

Re: Is it possible to delete system_auth keyspace.

/security.html#authentication Thanks Pranay. On Tue, Aug 1, 2017 at 12:50 PM, Jeff Jirsa <jji...@gmail.com> wrote: > It'll be created on startup if it doesn't exist (that doesn't mean it'll > be used, but it'll be created) > > -- > Jeff Jirsa > > > > On Aug

Is it possible to delete system_auth keyspace.

I am trying to enable authentication in different scenarios, trying to delete system_auth keyspace and disabled authentication removed keyspace from data directory and restart the cassandra service. Still when cassandra comes up i am seeing system_auth keyspace created again. Is there any way

Re: Starting cassandra Service with Binary Disabled.

Thanks Jeff On Jul 30, 2017 11:22 PM, "Jeff Jirsa" <jji...@gmail.com> wrote: > start_native_transport: false > > > -- > Jeff Jirsa > > > > On Jul 30, 2017, at 7:14 PM, Pranay akula <pranay.akula2...@gmail.com> > wrote: > > > > Hi, &

Starting cassandra Service with Binary Disabled.

Hi, It is possible to disable binary in configuration when re-starting cassandra service, instead of disabling it using nodetool once the node is up. Thanks Pranay.

Understanding Dynamic Snitch Scores

Hi, let's say i have 5 nodes a DC the dynamic snitch scores are A => '1.84106731901363' B => '1.1386762906094' C => '2.63620400428772', D => '3.06495631470972', E => '0', Badness_threshold is set to 1, Does this mean the node with higher value is considered as bad node right ?? If i have

Re: Moving from DSE to Cassandra.

re any keyspace with "EverywhereStrategy" strategies, change > them to "NetworkTopologyStrategy" first. > > particularly DSE system. Start in opensource mode and run sstable > upgrade if needed. > > Regards > > Hari > > > --

Moving from DSE to Cassandra.

Planning to move from DSE to open source cassandra. What will be better way to do it. 1) I am thinking of introducing new datacenter with apache cassandra and replicating to that DC and after data replication remove DSE cassandra DC 2) Upgrading from current DSE version to later version of

Re: READ Queries timing out.

m), you > may benefit from a much lower compression_chunk_size - the default is 64k, > but 4k or 16k is often much better if you do have to read from disk. probably i have to try decreasing chunk size as LCS will not suit as we are write heavy On Fri, Jul 7, 2017 at 7:13 PM, Jeff Jirsa &

Re: READ Queries timing out.

query (if using filter). > > > > *From: *"ZAIDI, ASAD A" <az1...@att.com> > *Date: *Friday, July 7, 2017 at 9:45 AM > *To: *"user@cassandra.apache.org" <user@cassandra.apache.org> > *Subject: *RE: READ Queries timing out. > > > > >> I analysed

Re: Move Production data to Development Cluster

Hello *Jonathan,* As both clusters size is same. Do I copy the snapshots from all the nodes? yes this will work, just make sure that ur copying data to nodes with assiociated tokens. Thanks Pranay. On Fri, Jul 7, 2017 at 10:48 AM, Jonathan Baynes < jonathan.bay...@tradeweb.com> wrote: >

Re: READ Queries timing out.

az1...@att.com> wrote: > >> I analysed the GC logs not having any issues with major GC's > > If you don’t have issues on GC , than why do you want to > [tune] GC parameters ? > > Instead focus on why select queries are taking time.. may be take a look > on their

READ Queries timing out.

Lately i am seeing some select queries timing out, data modelling to blame for but not in a situation to redo it. Does increasing heap will help ?? currently using 1GB new_heap, I analysed the GC logs not having any issues with major GC's . Using G1GC , does increasing new_heap will help ??

Re: Guaranteed order for syncing Records

Hello suraj, Nope there will no out sync between same tables in different Datacenters, so Record A in Table A in Datacenter 1 will also be in Table A in Datacenter 2, just make sure there is no communication issues between Datacenters. Thanks Pranay. On Thu, Jul 6, 2017 at 2:01 AM, suraj

Does select queries objects will be allocated in new_heap ??

Hai, I have a small doubt i am not much familiar with java, so when a select or insert query is executed against a node does the output of that query will be stored in heap ?? For insert query the output will stored in Memtables will is part on new_heap right ?? does select and other queries

Re: Is it possible to repair a single partition.

tition so that the query times out. You can run a manual > compaction on that table. That helped me several times. > > + I hope you are not trying to read that parition at once. Please use > paging to query large partitions. > > 2017-06-27 21:25 GMT+02:00 Pranay akula <pranay

Re: Is it possible to repair a single partition.

. On Tue, Jun 27, 2017 at 3:13 PM, Jonathan Haddad <j...@jonhaddad.com> wrote: > Query it at consistency ALL and let read repair do its thing. > On Tue, Jun 27, 2017 at 11:48 AM Pranay akula <pranay.akula2...@gmail.com> > wrote: > >> I have a CF with composite partiti

Is it possible to repair a single partition.

I have a CF with composite partition key, partition key consists of blob and text data types. The select query against this particular partition is timing out so to debug it further i ran nodetool getendpoints i am getting error like below error: Non-hex characters in

Re: what is MemtableReclaimMemory mean ??

> Alain Rodriguez - @arodream - al...@thelastpickle.com > France > > The Last Pickle - Apache Cassandra Consulting > http://www.thelastpickle.com > > > > 2017-04-16 16:04 GMT+02:00 Pranay akula <pranay.akula2...@gmail.com>: > >> Hi, >> >>

what is MemtableReclaimMemory mean ??

Hi, what is *MemtableReclaimMemory* mean in nodetooltpstats ?? does this mean trying to flushing memtable from memory to SStables. I can see sometimes increase in pending tasks of MemtableReclaimMemory in nodetool tpstats, at that time i can see increase in load on those nodes. Does decreasing

Re: Node Gossiping Information.

gossip state is only in memory > > You shouldn't ever manually need to disable/re-enable gossip unless you > want the rest of the ring to believe a node went offline/online. > > What version are you using? > > > On Tue, Apr 4, 2017 at 7:46 AM, Pranay akula <pranay.akula2..

Re: Node Gossiping Information.

any role to play for Hinted Hand-off's ?? Is there any setting in Yaml file i can change get through this situation. Thanks Pranay. On Tue, Apr 4, 2017 at 12:19 AM, Jeff Jirsa <jji...@apache.org> wrote: > > > On 2017-04-02 11:27 (-0700), Pranay akula <pranay.akula2...@gmail.com&g

Node Gossiping Information.

where can we check gossip information of a node ?? I couldn't find anything in System keyspace. Is it possible to update or refresh Gossiping information on a node without restarting. Does enabling and disabling Gossip will help to refresh Gossip information on that node. Thanks Prany.

Understanding DynamicSnitch Scores.

Hi, I am seeing the DynamicSnitch scores on my node one with 3.44775023338358 and other with 0.884715810185486 so my current node will send full request to node with Value 3.44 and digest request to node with value 0.88 So the higher the value >1 means the node responding the fastest ?? node

Scrubbing corrupted SStable.

I am trying to scrub a Column family using nodetool scrub, is it going to create snapshots for sstables which are corrupted or for all the sstables it is going to scrub ?? and to remove snapshots created does running nodetool clearsnapshot is enough or do i need to manually delete pre-scrub data

JMX metric collection for cassandra.

We are collecting JMX metrics through Jolokia. I am trying to find out active connections to the host, but i couldn't find in Jolokia. i am running jolokia list couldn't find it either. */usr/local/bin/jmx4perl http://localhost:6809/mon/jolokia list*

Does Too many GC pauses can cause cassandra service DOWN.

On couple of servers when cassandra service is down all i see only GC pauses and load on these servers is not high when pauses happend, i haven't found any thing else is that can be the reason or do i need to look at something else ?? We are using G1GC any reference on how to adjust G1GC

Re: JVM state determined to be unstable. Exiting forcefully. what is Java Stability Inspector ?? why it is stopping DSE?

l (I believe you can do this > using Eclipse Memory Analyzer - MAT). > > C*heers, > --- > Alain Rodriguez - @arodream - al...@thelastpickle.com > France > > The Last Pickle - Apache Cassandra Consulting > http://www.thelastpickle.com > > 2017-01-19 14:00

JVM state determined to be unstable. Exiting forcefully. what is Java Stability Inspector ?? why it is stopping DSE?

>From last few days i am seeing on some of the nodes in cassandra cluster DSE is getting shutdown due to the error below and i need to kill Java process and restart DSE service. I have cross checked reads and writes and compactions nothing looks suspicious, but i am seeing full Gc pause on these

how to get the size of the particular partition key belonging to an sstable ??

how can i get the size of a particular partition key belonging to an sstable ?? can we find it using index or summary or Statistics.db files ?? does reading the hexdump of these files help ?? Thanks Pranay.

Re: WARN [SharedPool-Worker-3] AbstractTracingAwareExecutorService.java

Thanks Doan, will try to enable slow query for app side and will let you know if it helps or not. Thanks James. On Wed, Oct 19, 2016 at 2:59 AM, DuyHai Doan wrote: > "which appilcation is trying to write large writes and to which keyspace > and table it is trying to

Re: High load on few nodes in a DC.

> > Best, > > Romain > Le Mardi 20 septembre 2016 15h47, Pranay akula <pranay.akula2...@gmail.com> > a écrit : > > > I was a able to find the hotspots causing the load,but the size of these > partitions are in KB and no tombstones and no.of sstables is only 2 wha

Re: High load on few nodes in a DC.

which node is serving as a coordinator for un logged batches?? we are using token-aware policy. thanks On Mon, Sep 19, 2016 at 12:29 PM, Pranay akula <pranay.akula2...@gmail.com> wrote: > I was able to see most used partitions but the nodes with less load are > serving more read and wr

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

i always have this doubt when a cassandra node got a read request for local quorum consistency does coordinator node asks all nodes with replicas in that DC for response or just the fastest responding nodes to it who's count satisfy the local quorum. In this case RF is 3 Cassandra timeout during

Re: High load on few nodes in a DC.

the token range for these particular partitions and which node is the primary for these partition ?? Thanks On Mon, Sep 19, 2016 at 11:04 AM, Pranay akula <pranay.akula2...@gmail.com> wrote: > Hai Jeff, > > Thank, we are using RF 3 and cassandra version 2.1.8. > > Thanks > Pr

Re: High load on few nodes in a DC.

elp you identify frequently > written/read partitions – perhaps you can use that to identify a hotspot > due to some external behavior (some partition being read thousands of > times, over and over could certainly drive up load). > > > > - Jeff > > >

High load on few nodes in a DC.

when our cluster was under load i am seeing 1 or 2 nodes are on more load consistently when compared to others in dc i am not seeing any GC pauses or wide partitions is this can be those nodes are continuously serving as coordinators ?? how can i find what is the reason for high load on those