Re: sstablescrum fails with OOM

Try run nodetool refresh or restarting Cassandra after removing the corrupted file On 4 Nov. 2017 03:54, "Shashi Yachavaram" wrote: > When i tried to simulate this in the lab by moving files (mv > KS-CF-ka-10143-* /tmp/files). > > Ran repair but it fails during snapshot

Unexpected rows in MV after upgrading to 3.0.15

Hello, While testing 3.0.15, we noticed that some materialized views started showing rows that shouldn't exist, as multiple rows in the view map to a single row in the base table. I've pasted the table structure below, but essentially there's a base table "((pk1,pk2,pk3),ck1),col1" and MV

Re: Cassandra using a ton of native memory

8Gb of RAM being a recommended production setting for most of the workload out there. Having only 16Gb of RAM, and because Cassandra is relying a lot on system page cache, there should be no surprise that your 16Gb being eaten up. On Fri, Nov 3, 2017 at 5:40 PM, Austin Sharp

Re: sstablescrum fails with OOM

When i tried to simulate this in the lab by moving files (mv KS-CF-ka-10143-* /tmp/files). Ran repair but it fails during snapshot creation. Where does it get the list of files and how do we update this list so we can get rid of corrupted files, update list/index and move on with offline

RE: Cassandra using a ton of native memory

I've investigated further. It appears that the performance issues are because Cassandra's memory-mapped files (*.db files) fill up the physical memory and start being swapped to disk. Is this related to recommendations to disable swapping on a machine where Cassandra is installed? Should I

Re: system_auth permissions issue C* 2.0.14

Hi We are seeing this issue on some nodes where even if we are providing correct credentials we are seeing incorrect username/password exception & when we try again with same credentials we are able to login . [hostname ~ ]$ ./cqlsh -u -p Traceback (most recent call last): File

Re: What is OneMinuteRate in Write Latency?

Its from the metrics library Meter object which tracks the exponentially weighted moving average of

system_auth permissions issue C* 2.0.14

Hi, We are seeing system_auth related exceptions from application side on cassandra 2.0.14 . at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) [jersey-common-2.14.jar:na] at org.glassfish.jersey.internal.Errors.process(Errors.java:315) [jersey-common-2.14.jar:na] at

Questions about maintaining secondary indexes.

Hello, I have a few questions about secondary indexes. 1st Question: Quoting this FAQ: https://wiki.apache.org/cassandra/SecondaryIndexes Q: When you write a new row, when/how does the index get updated? What I > would like to know is the atomicity of the operation--is the "index write" >

Re: What is OneMinuteRate in Write Latency?

Hi, OneMinuteRate is the mean rate of write/s over a minute bucket of data AFAIK. You can find Latencies on every attributes whose name does not end with "Rate" On 2 November 2017 at 18:10, AI Rumman wrote: > Hi, > > I am trying to calculate the Read/second and

cassandra.yaml configuration for large machines (scale up vs. scale out)

Hello, I know that Cassandra is built for scale out on commodity hardware, but I wonder if anyone can share some experience when running Cassandra on rather capable machines. Let's say we have a 3 node cluster with 128G RAM, 32 physical cores (16 per CPU socket), Large Raid with Spinning

Re: Cassandra 3.10 - Hints & Dropped messages logs Vs Cass 2.x version

Okay .. Thanks,will check .. Anumod PA,USA Sent from my iPhone > On Nov 2, 2017, at 5:40 PM, kurt greaves wrote: > > Well, pretty sure they still are. at least the mutation one is. but you > should really use the dedicated metrics for this. > >> On 3 Nov. 2017 01:38,

Cassandra | MODIFY keyword

Hi, I would be appreciative if you could help with below questions. I have two question on Modify keyword with respect to Cassandra(No SQL database). 1) Whenever we grant MODIFY permissions to Cassandra users, for example: GRANT MODIFY ON table1 TO User1; Then all four: Insert, Update, Delete