Re: Re: Cassandra 0.7 beta 3 outOfMemory (OOM)

on inserts it's over. - Cassandra 0.7.0 beta 3 - Single Node - about 200 inserts/s ~500byte - 1 kb Is there no other possibility instead of slowing down inserts/s ? What could be an indicator to see if a node works stable with this amount of inserts? Thank you for your answer, Max

Re: Re: Re: Cassandra 0.7 beta 3 outOfMemory (OOM)

byte[] but i'm not sure how to interpret: http://oi53.tinypic.com/y2d1i.jpg Thank you! Max Aaron Morton wrote: Jake or anyone else got experience bulk loading into Lucandra ?  Or does anyone have experience with JRocket ?  Max, are you sending one document at a time into lucene. Can you

Re: Re: Re: Cassandra 0.7 beta 3 outOfMemory (OOM)

Thank you Jake, also Aaron & Peter for your help :-) It was the 1801 bug, solved in RC2 SVN Snapshot! Max Jake Luciani wrote: Max this was a bug fixed recently in 0.7 branch https://issues.apache.org/jira/browse/CASSANDRA-1801 fixed now in RC2 -Jake On Tue, Dec 7, 2010 at 8:11 AM,

Snapshot SSTable modified??

ckup_$HOSTNAME_$KEYSPACE_MMDD_HHMMSS.tgz schema.cql /var/lib/cassandra/data/$KEYSPACE/*/snapshots/$SNAPSHOT_NAME nodetool clearsnapshot -t $SNAPSHOT_NAME Thanks. - Max - To unsubscribe, e-mail: user-unsubscr...@cassandra.apach

Re: Snapshot SSTable modified??

SSTables wouldn't be written to after that. Our solution is to wait 5 minutes and retry the tar if an error occurs. This isn't ideal - but it's the best I could come up with. :-/ Thanks Jeff & others for your responses. - Max > On May 25, 2018, at 5:05pm, Elliott Sims

Re: Snapshot SSTable modified??

Oh, thanks Elliott for the explanation! I had no idea about that little tidbit concerning ctime. Now it all makes sense! - Max > On May 28, 2018, at 10:24 pm, Elliott Sims wrote: > > Unix timestamps are a bit odd. "mtime/Modify" is file changes, > "ctime/Chan

Recommended num_tokens setting for small cluster

t now pretty easily (our dataset is small but growing). Should we switch from 256 to 8? 32? Has anyone had num_tokens = 8 (or similarly small number) and experienced growing pains? What do you think the recommended setting should be? Thanks for the advice. :-) - Max

Re: Recommended num_tokens setting for small cluster

Jeff/Kurt/Alex — thanks so much for your feedback on this issue, and thanks for all of the help you guys have lent to people on this list over the years. :-) - Max > On Aug 29, 2018, at 11:38 pm, Oleksandr Shulgin <mailto:oleksandr.shul...@zalando.de>> wrote: > > On Thu,

Corrupt insert during ALTER TABLE add

I ran “alter table” today to add the “task_output_capture_state” column (see below), and we found a few rows inserted around the time of the ALTER TABLE did not contain the same values when selected as when they were inserted. When the row was selected, what we saw was: - test_id —> OK (same as

Re: Corrupt insert during ALTER TABLE add

Correction — we’re running C* 3.0.8. DataStax Python driver 3.4.1. > On Sep 13, 2018, at 1:11 pm, Max C. wrote: > > I ran “alter table” today to add the “task_output_capture_state” column (see > below), and we found a few rows inserted around the time of the ALTER TABLE > did

Re: Corrupt insert during ALTER TABLE add

Yep, that’s the problem! Thanks Jeff (and Alex Petrov for fixing it). - Max > On Sep 13, 2018, at 1:24 pm, Jeff Jirsa wrote: > > CASSANDA-13004 (fixed in recent 3.0 and 3.11 builds) - To unsubscribe, e-mail: user

Re: Connections info

this nodes native protocol server” As for where they’re coming from — I’m not sure how to get that from JMX. Maybe you’ll have to use “lsof” or something to get that. - Max > On Oct 4, 2018, at 8:57 pm, Abdul Patel wrote: > > Hi All, > > Can we get number of users connected

Upcoming Cassandra-related Conferences

r conference! :-) - Max

Re: Insert from Select - CQL

r CLI params, similar to mysqldump (-h for --host, -u for --username, -p for --password, etc) - Max > On Oct 25, 2018, at 5:07 am, Philip Ó Condúin > wrote: > > Hi Alain, > > That is exactly what I did yesterday in the end. I ran the selects and > output the resul

Re: nodetool status and node maintenance

tps://jolokia.org/> Jolokia is what made it possible for us to get out of nodetool parsing and into writing tools in our native language — Python. We’re big fans! - Max > On Oct 29, 2018, at 7:02 am, Horia Mocioi wrote: > > Hello, > > Instead of parsing the output from nodetool (runn

Re: Configurations for better performance

- Max > On Oct 16, 2019, at 12:09 pm, Ramnatthan Alagappan > wrote: > > Hello, > I am from a research group that's looking into automatic tuning of > configuration parameters of data-intensive systems. In particular, we are > interested in distributed data stores a

Re: Cassandra Repair question

Yes - agree with Sergio. For the majority of use cases, the best practice for repair is to use Cassandra Reaper. > On Oct 19, 2019, at 12:06 am, Sergio wrote: > > Use Cassandra reaper > > On Fri, Oct 18, 2019, 10:12 PM Krish Donald > wrote: > Thanks Manish, > >

NPE during schema upgrade from 2.2.6 -> 3.0.6

the same error; so I then went from 2.1.13 to 2.2.6, ran “nodetool upgradestables" (which succeeded without issue) and then to 3.0.6. Thanks for any assistance. :-) - Max INFO [main] 2016-05-27 16:02:01,169 ColumnFamilyStore.java:381 - Initializing system.peers INFO [main] 2016-05-27

Commercial Support Providers?

is DataStax, and we’re definitely talking to them. Are there any other providers which offer this sort of service? Maybe Instaclustr? Thanks. - Max

Re: quick questions

the replicas was up). - Max > On Dec 17, 2016, at 1:21 pm, Kant Kodali wrote: > > I keep hearing that the minimum number of Cassandra nodes required to achieve > Quorum consensus is 4 I wonder why not 3? In fact, many container deployments > by default seem to deploy 4 nodes. C

Strategies for avoiding corrupted duplicate data?

ct * from users where username=‘maxc’; begin batch # … apply changes ... apply batch; ## release external lock ## Or is there some other way to do this that I’m totally missing?? Materialized views in 3.x, I suppose. Other ideas? Thanks! - Max

Re: 1, 2, 3...

Looks like this guy (Brian Hess) wrote a script to split the token range and run count(*) on each subrange: https://github.com/brianmhess/cassandra-count <https://github.com/brianmhess/cassandra-count> - Max > On Apr 8, 2016, at 10:56 pm, Jeff Jirsa wrote: > > SELECT COUNT(*)

Re: Does "nodetool repair" need to be run on each node for a given table?

=1Sz_K8UID6E <https://www.youtube.com/watch?v=1Sz_K8UID6E> Alexander went a little too crazy on the auto-repeat animated GIFs, but the information is excellent — thanks Alexander if you’re out there - I really got a lot out of your talk. :-) - Max > On Mar 14, 2017, at 12:48 pm, Thakra

Re: Error of "You have to be logged in and not anonymous to perform this request"

est/operating/security.html#authentication> … or if you don’t want to use user authentication, then I wouldn’t worry about creating users / messing around with roles for the authentication system you don’t want to use. :-) - Max > On Mar 19, 2017, at 6:56 pm, Long Quanzheng wrote: >

Re: Is there a C* summit this year?

Cassandra Summit in 2017. We do plan to reschedule for early 2018 and working with the ASF to do so. Hope to see you then!" That's all I know — maybe someone from Datastax or ASF will chime in with more info. - Max > On May 19, 2017, at 10:35pm, Kant Kodali wrote: > > Hi

Re: Effect of frequent mutations / memtable

mance impact of having N mutations written to the SSTable — or will these mutations generally be constrained to the mem table? - Max > Hi, > > I am using a updates to a column with a ttl to represent a lock. The owning > process keeps updating the lock's TTL as long as

Lots of simultaneous connections?

oing an explicit disconnect during the waiting period of our application’s execution; so as to get the C* connection count down. Hopefully that will solve the timeout problem. Thanks for your help. - Max - To unsubscribe, e-mail: user-unsu

Re: Lots of simultaneous connections?

at’s too many connections — I’m sure that’s your problem.” or “We regularly make 12M connections per C* node — you’re screwed up in some other way — have you checked file descriptor limits? What’s your Java __whatever__ setting?” etc. thanks Kurt. :-) - Max > On Dec 14, 2017, at 6:

Re: [Discuss] num_tokens default in Cassandra 4.0

hared between node 1 & 4. Hope that helps. - Max > On Feb 3, 2020, at 8:39 pm, onmstester onmstester > wrote: > > Sorry if its trivial, but i do not understand how num_tokens affects > availability, with RF=3, CLW,CLR=quorum, the cluster could tolerate to lost > at most o

Re: Should we use Materialised Views or ditch them ?

that isn’t updated). If we were to do it over, we would not use them at all. - Max > On Feb 28, 2020, at 7:07 am, Tobias Eriksson > wrote: > > Hi > A debate has surfaced in my company, whether to keep or remove Materialized > Views > The Datastax FAQ says sure thing

Re: multiple clients making schema changes at once

commit to the same branch — i.e. at most one change can be outstanding at a time (across all tables, all key spaces)…otherwise you will run into trouble. Hope that helps. Best of luck. - Max Hello, I have a more general question about that, I cannot find clear answer. In my use case I have

Re: multiple clients making schema changes at once

We use ZooKeeper + kazoo’s lock implementation. Kazoo is a Python client library for ZooKeeper. - Max > Yes this is quite annoying. How did you implement that "external lock"? I > also thought of doing an external service that would be dedicated to that. > Cassandra cli

Re: multiple clients making schema changes at once

way to query the driver to see if your schema change has fully propagated. I haven’t looked into this. - Max > On Jun 3, 2021, at 8:23 am, Joe Obernberger > wrote: > > How does this work? I have a program that runs a series of alter table > statements, and then does inserts.

On-prem backup options ... Medusa?

e to avoid creating a DIY tool if at all possible; given all of the nuance (saving token ranges, schemas, etc). Maybe best option is to submit PRs to help smooth the Medusa "rough edges"??? :-) Thanks everyone. - Max

Re: New Servers - Cassandra 4

Have you considered a blade chassis? Then you can get most of the redundancy of having lots of small nodes in few(er) rack units. SuperMicro has a chassis that can accommodate 14 servers in 4U: https://www.supermicro.com/en/products/superblade/enclosure#4U - Max > On Aug 2, 2021, at 12:05

Re: The "Cassandra Corner" podcast

Hi Aaron, Do you have the RSS feed URL handy? I looked at the source of the page, and it shows this: https://anchor.fm/s/99c5e268/podcast/rss https://anchor.fm/s/99c5e268/podcast/rss>" /> … which leads to a 404. Thanks. - Max > On Jun 1, 2022, at 6:55 am, Aaron

Replacing node w/o bootstrapping (streaming)?

long it takes to stream 1.2 TB of data. Our cluster: v3.0.23 2 DC 3 nodes per DC RF=3 CL=LOCAL_QUORUM Thanks everyone. - Max

Re: Replacing node w/o bootstrapping (streaming)?

Awesome - thanks Jeff! - Max > On Feb 9, 2023, at 6:45 pm, Jeff Jirsa wrote: > > You don’t have to do anything else. Just use smart rsync flags (including > delete). > > It’ll work fine just the way you described. No special start args. No > replacement flag >

New DC / token distribution not balanced

s? Do I need to do something to clear out the gossip between attempts? Thanks everyone. - Max

Re: New DC / token distribution not balanced

added the nodes … voila! Problem solved! > On Mar 15, 2023, at 10:50 pm, Max Campos wrote: > > Hi All - > > I’m having a lot of trouble adding a new DC and getting a balanced ring (i.e. > every node has the same percentage of the token ring). > > My config: > &g

Re: New DC / token distribution not balanced

ion_factor" more useful than > "allocate_tokens_for_keyspace" when you are spinning up a new DC. > > On 16/03/2023 06:25, Max Campos wrote: >> Update: I figured out the problem! >> >> The “allocate_tokens_for_keyspace” value needs to be set for a keyspace t

Re: Survey about the parsing of the tooling's output

JSON output back when we were just starting out, though. These days we only run nodetool manually by humans from a shell; so changes to the output would not be an issue. - Max > On Jul 10, 2023, at 2:35 am, Miklosovic, Stefan > wrote: > > Hi Cassandra users, > > I am a C

Re: Cassandra JMX without RMI?

We use Jolokia. It runs inside of Cassandra and then gives you an HTTP REST interface to interact with JMX. Works great for us! https://jolokia.org/ <https://jolokia.org/> - Max > On Jul 18, 2023, at 8:11 pm, Angelo Polo wrote: > > Is it possible to connect to the Cassa