Re: Begginer with cassandra Apache - Gossip

2015-03-15 Thread Akhil Mehra
Hi Jean, I have written three article that might be of help to you: http://abiasforaction.net/an-introduction-to-apache-cassandra/ http://abiasforaction.net/an-introduction-to-apache-cassandra/ http://abiasforaction.net/cassandra-architecture/ http://abiasforaction.net/cassandra-architecture/

Re: Begginer with cassandra Apache - Gossip

2015-03-15 Thread Akhil Mehra
Akhil Mehra akhilme...@gmail.com mailto:akhilme...@gmail.com: Hi Jean, I have written three article that might be of help to you: http://abiasforaction.net/an-introduction-to-apache-cassandra/ http://abiasforaction.net/an-introduction-to-apache-cassandra/ http://abiasforaction.net

Re: Begginer with cassandra Apache - Gossip

2015-03-16 Thread Akhil Mehra
/tree/trunk/src/java/org/apache/cassandra/gms ? that's it ? Thank you so much for help. i'd like to know how to start please :) Best regards. 2015-03-15 23:44 GMT+01:00 Akhil Mehra akhilme...@gmail.com mailto:akhilme...@gmail.com: Hi Jean, Check our the following urls

What are the best ways to learn Apache Cassandra

2015-12-19 Thread Akhil Mehra
Apache Cassandra. What were the main pain points when trying to get to grips with Cassandra. Essentially I am looking for all tips that will help shorten the learning curve. Thanks Regards, Akhil Mehra

Re: MUTATION messages were dropped in last 5000 ms for cross node timeout

2017-08-04 Thread Akhil Mehra
tition size , some are ranging Partition-key size around > ~6.6GB.. we’re now working to reduce the partition size of the tables. I am > hoping corrected data model will help reduce coordinator wait time (get back > to default number!) again. > > Thank again/Asad > > Fro

Re: MemtablePostFlush pending

2017-08-13 Thread Akhil Mehra
HI Asad, The post flush task frees up allocated commit log segments. Apart for commit log segment allocation the post flush task "synchronises custom secondary indexes and provides ordering guarantees for futures on switchMemtable/flush etc, which expect to be able to wait until the flush (and

Re: MUTATION messages were dropped in last 5000 ms for cross node timeout

2017-07-21 Thread Akhil Mehra
cpu queue length never goes beyond > medium depth. I wonder if there is some internal limit that I’m still not > aware of. > > Thanks/Asad > > > From: Akhil Mehra [mailto:akhilme...@gmail.com] > Sent: Thursday, July 20, 2017 3:47 PM > To: user@cassandra.apache.or

Re: MUTATION messages were dropped in last 5000 ms for cross node timeout

2017-07-20 Thread Akhil Mehra
Hi Asad, http://cassandra.apache.org/doc/latest/faq/index.html#why-message-dropped As mentioned in the link above this is a load shedding mechanism used by Cassandra. Is you cluster under heavy load? Regards, Akhil

Re: nodetool repair failure

2017-06-29 Thread Akhil Mehra
tification( ClientNotifForwarder.java:583) > at com.sun.jmx.remote.internal. ClientNotifForwarder$ > NotifFetcher.doRun( ClientNotifForwarder.java:533) > at com.sun.jmx.remote.internal. ClientNotifForwarder$ NotifFetcher.run( > ClientNotifForwarder.java:452) >

Re: timeoutexceptions with UDF causing cassandra forceful exits

2017-06-29 Thread Akhil Mehra
valid, if enable_user_defined_functions_threads==true) */ public UserFunctionTimeoutPolicy user_function_timeout_policy = UserFunctionTimeoutPolicy.die; To answer your question. Yes it is normal for Cassandra to shut down due to a rogue UDF. Warm Regards, Akhil Mehra > On 30/06/2

Re: nodetool repair failure

2017-06-28 Thread Akhil Mehra
nodetool repair has a trace option nodetool repair -tr yourkeyspacename see if that provides you with additional information. Regards, Akhil > On 28/06/2017, at 2:25 AM, Balaji Venkatesan > wrote: > > > We use Apache Cassandra 3.10-13 > > On Jun 26, 2017

Re: C* 3 node issue -Urgent

2017-08-23 Thread Akhil Mehra
The cqlsh image say bad credentials. Just confirming that you have the correct username/password when logging on. By turing on authentication I am assuming you mean using the PasswordAuthenticator instead of the AllowAllAuthenticator in the yaml. Cheers, Akhil > On 23/08/2017, at 8:59 PM,

Re: C* 3 node issue -Urgent

2017-08-23 Thread Akhil Mehra
to change this? Or better, how do I get the other 2 nodes back up? > > From: Akhil Mehra [mailto:akhilme...@gmail.com <mailto:akhilme...@gmail.com>] > Sent: 23 August 2017 10:05 > To: user@cassandra.apache.org <mailto:user@cassandra.apache.org> > Subject: Re: C* 3

Re: C* 3 node issue -Urgent

2017-08-23 Thread Akhil Mehra
is correct. But how do I sign into > CQLSH to change this? Or better, how do I get the other 2 nodes back up? > > From: Akhil Mehra [mailto:akhilme...@gmail.com <mailto:akhilme...@gmail.com>] > Sent: 23 August 2017 10:05 > To: user@cassandra.apache.org <mailto:user@cassan

Re: memtable_allocation_type on Cassandra 2.1.x

2017-05-22 Thread Akhil Mehra
of using off-heap storage. Regards, Akhil Mehra On Tue, May 23, 2017 at 12:32 AM, varun saluja <saluj...@gmail.com> wrote: > Hi Experts, > > I have some concerns regarding memtable parameters for my current version. > 2.1.8. > > As per documentation , its mentioned to

Re: memtable_allocation_type on Cassandra 2.1.x

2017-05-24 Thread Akhil Mehra
will memtable still use jvm heap space. > > Can anyone suggest below parameters. > > memtable_flush_writers: > memtable_cleanup_threshold: > > > PS : We have high write intensive workload . 5Node cluster (12 Core , 62GB > RAM and flash disk per node) > > > R

Re: [Cassandra] Ignoring interval time

2017-05-30 Thread Akhil Mehra
The debug output is from the failure detector in the gossip module. Code can be found here https://github.com/apache/cassandra/blob/8b3a60b9a7dbefeecc06bace617279612ec7092d/src/java/org/apache/cassandra/gms/FailureDetector.java#L450-L474 . The debug logging above is reporting around an

Re: How to avoid flush if the data can fit into memtable

2017-05-29 Thread Akhil Mehra
if this helps get the desired size. I have written up a blog post explaining memtable flushing ( http://abiasforaction.net/apache-cassandra-memtable-flush/) Let me know if you have any other question. I hope this helps. Regards, Akhil Mehra On Fri, May 26, 2017 at 6:58 AM, preetika tyagi <preetik

Re: org.apache.cassandra.service.DigestMismatchException: Mismatch for key DecoratedKey

2017-05-30 Thread Akhil Mehra
This blog post (http://thelastpickle.com/blog/2011/05/15/Deletes-and-Tombstones.html ) provides good explenation on the exception in your debug log. Regards, Akhil > On 30/05/2017, at 9:29 PM, Abhishek Kumar Maheshwari >

Re: Convert single node C* to cluster (rebalancing problem)

2017-05-31 Thread Akhil Mehra
Hi Junaid, I noticed in the log files that data is being streamed from/to 10.128.1.2 but the address of your original node is 10.128.0.7. Are there any other Cassandra nodes on your local network the same cluster name. Regards, Akhil > 10.128.1.2 > On 31/05/2017, at 10:15 PM, Junaid Nasir

Re: Convert single node C* to cluster (rebalancing problem)

2017-06-02 Thread Akhil Mehra
So now the data is evenly balanced in both nodes? Refer to the following documentation to get a better understanding of the roc_address and the broadcast_rpc_address https://www.instaclustr.com/demystifying-cassandras-broadcast_address/

Re: Convert single node C* to cluster (rebalancing problem)

2017-06-01 Thread Akhil Mehra
location, it's on > another disk. if that helps > > On Thu, Jun 1, 2017 at 4:49 AM, Akhil Mehra <akhilme...@gmail.com > <mailto:akhilme...@gmail.com>> wrote: > Hi Junaid, > > I noticed in the log files that data is being streamed from/to 10.128.1.2 but > the a

Re: How to avoid flush if the data can fit into memtable

2017-06-01 Thread Akhil Mehra
value i.e. 33 percent of the total > memtable heap and off heap memory." > > Could you clarify this? > > Thanks > Stefan > > > 2017-05-30 2:43 GMT+02:00 Akhil Mehra <akhilme...@gmail.com>: > Hi Preetika, > > After thinking about your scenario I

Re: Convert single node C* to cluster (rebalancing problem)

2017-06-12 Thread Akhil Mehra
t default value) > > On Fri, Jun 9, 2017 at 3:18 AM, ZAIDI, ASAD A <az1...@att.com> wrote: > >> Did you make sure auto_bootstrap property is indeed set to [true] when >> you added the node? >> >> >> >> *From:* Junaid Nasir [mailto:jna...@an10.io] &

Re: Data in multi disks is not evenly distributed

2017-06-13 Thread Akhil Mehra
Hi, I came across the following method ( https://github.com/apache/cassandra/blob/afd68abe60742c6deb6357ba4605268dfb3d06ea/src/java/org/apache/cassandra/service/StorageService.java#L5006-L5021). It seems data is evenly split across disks according to local token ranges. It might be that data

Re: Convert single node C* to cluster (rebalancing problem)

2017-06-15 Thread Akhil Mehra
that is the problem. initial 270gb data might not by modeled >>> correctly. I have run a lot of tests on 270gb data including downsizing it >>> to 5gb, they all resulted in same uneven distribution. I also tested a >>> dummy dataset of 2gb which was balanced even

Re: Convert single node C* to cluster (rebalancing problem)

2017-06-16 Thread Akhil Mehra
; ranges it does not own. Ain't this is bug in Cassandra? > > Yes, on disk data will be present but it should be reflected in nodetool > status. > > On Thu, Jun 15, 2017 at 6:17 PM, Akhil Mehra <akhilme...@gmail.com> wrote: > >> Hi, >> >> I put togethe

Re: Don't print Ping caused error logs

2017-06-19 Thread Akhil Mehra
Just in case you are not aware using a load balancer is an anti patter. Please refer to (http://docs.datastax.com/en/landing_page/doc/landing_page/planning/planningAntiPatterns.html#planningAntiPatterns__AntiPatLoadBal

Re: Cleaning up related issue

2017-06-19 Thread Akhil Mehra
Is the node with the large volume a new node or an existing node. If it is an existing node is this the one where the node tool cleanup failed. Cheers, Akhil > On 19/06/2017, at 6:40 PM, wxn...@zjqunshuo.com wrote: > > Hi, > After adding a new node, I started cleaning up task to remove the old

Re: Cleaning up related issue

2017-06-19 Thread Akhil Mehra
other nodes. > > From: Akhil Mehra > Date: 2017-06-19 14:56 > To: wxn002 > CC: user > Subject: Re: Cleaning up related issue > Is the node with the large volume a new node or an existing node. If it is an > existing node is this the one where the node tool cleanup failed. >

Re: Cleaning up related issue

2017-06-19 Thread Akhil Mehra
me with "tmp-" prefix > in the data directory which indicate the cleaning up task was not complete. > > Cheers, > -Simon > > From: Akhil Mehra <mailto:akhilme...@gmail.com> > Date: 2017-06-19 15:17 > To: wxn...@zjqunshuo.com <mailto:wxn...@zjqunshuo.co

Re: Convert single node C* to cluster (rebalancing problem)

2017-06-12 Thread Akhil Mehra
AD A <az1...@att.com> wrote: >>> >>>> Did you make sure auto_bootstrap property is indeed set to [true] when >>>> you added the node? >>>> >>>> >>>> >>>> *From:* Junaid Nasir [mailto:jna...@an10.io] >>>&

Re: UnauthorizedException: user has no select permissions when quering Cassandra

2017-08-29 Thread Akhil Mehra
I could be that authorisation is added to a node without increasing the replication factor for the system_auth keyspace (https://docs.datastax.com/en/cassandra/3.0/cassandra/configuration/secureConfigInternalAuth.html

Re: Conection refuse

2017-08-28 Thread Akhil Mehra
by default connects to localhost. You can set the rpc_address to 0.0.0.0 for allowing anyone to connect. Possible option to eliminate Cassandra rejecting connection. Note this is a security hole for production deployments. Cheers, Warm Regards, Akhil Mehra http://abiasforaction.net > On 29/08/2

Re: configure pooling options to avoid BusyPoolException

2017-08-23 Thread Akhil Mehra
Since queries are asynchronously executed, you will need some mechanism in your code to queue your request. Try setting your setMaxQueueSize to meet your need. By default its 256

Re: Measuring Read Repairs

2017-08-25 Thread Akhil Mehra
You can run nodetool tpstats on your nodes and check the output for the ReadRepairStage. Cheers, Akhil > On 26/08/2017, at 6:54 AM, Chuck Reynolds wrote: > > I’m running queries based on the token ranges to initiate read repairs across > datacenter. > > Example

Re: Conection refuse

2017-08-29 Thread Akhil Mehra
rtant, because it was a > dev environment that I am setting up. But I have to be able to make this node > running and talking to the new node. Neither CQLSH nor nodetool works at this > time. > > Best, > Amirali > > > On Tue, Aug 29, 2017 at 2:49 PM, Akhil Mehra <ak

Re: Conection refuse

2017-08-29 Thread Akhil Mehra
t; Thanks in Advance, > Amir > > On Tue, Aug 29, 2017 at 6:53 PM, Akhil Mehra <akhilme...@gmail.com > <mailto:akhilme...@gmail.com>> wrote: > > If the data is not important then stop all nodes. On each node empty your > commitlog, data, hints and saved_cache directo

Re: Conection refuse

2017-08-29 Thread Akhil Mehra
bs.net> wrote: > > Yes both of the nodes are down. > > On Aug 29, 2017 2:30 PM, "Akhil Mehra" <akhilme...@gmail.com > <mailto:akhilme...@gmail.com>> wrote: > Cassandra is doing a health check when it is starting up and failing due to > being

Re: UnauthorizedException: user has no select permissions when quering Cassandra

2017-08-29 Thread Akhil Mehra
ght now I can’t even run select * from system_auth.users without it timeing > out. > > From: Akhil Mehra <akhilme...@gmail.com <mailto:akhilme...@gmail.com>> > Reply-To: "user@cassandra.apache.org <mailto:user@cassandra.apache.org>" > <user@ca

Re: Conection refuse

2017-08-29 Thread Akhil Mehra
Cassandra is doing a health check when it is starting up and failing due to being unable to ready files in the system key space. Here is the comment in the segment of the code that threw the exception.