Re: [RELEASE] Apache Cassandra 4.1-beta1 released

2022-10-12 Thread Mick Semb Wever
Correction… Downloads of source and binary distributions are listed in our download > section: > > http://cassandra.apache.org/download/ > The source and binary distributions are to be found here: https://downloads.apache.org/cassandra/4.1-beta1/ (4.1 won't appear on our downloads page until

RE: Upgrade

2022-10-12 Thread Marc Hoppins
Groovy. Thanks. From: Erick Ramirez Sent: Wednesday, October 12, 2022 4:08 PM To: user@cassandra.apache.org Subject: Re: Upgrade EXTERNAL That's correct. Cheers!

Re: Upgrade

2022-10-12 Thread Erick Ramirez
That's correct. Cheers!

RE: Upgrade

2022-10-12 Thread Marc Hoppins
On every node? From: Erick Ramirez Sent: Wednesday, October 12, 2022 3:20 PM To: user@cassandra.apache.org Subject: Re: Upgrade EXTERNAL It's just a minor patch upgrade so all you're really upgrading is the binaries. In any case, switching off replication is not the recommended approach. The

Re: Upgrade

2022-10-12 Thread Erick Ramirez
It's just a minor patch upgrade so all you're really upgrading is the binaries. In any case, switching off replication is not the recommended approach. The recommended pre-upgrade procedure is to take backups of the data on your nodes with nodetool snapshot. Cheers!

Upgrade

2022-10-12 Thread Marc Hoppins
Hi all, Looking at upgrading our install from 4.0.3 to 4.0.6. We have replication from one datacentre to a backup site. Other than modifying the replication config from dc1 to dc2, is there a simple method or command to stop replication for a period? The idea being that, should something go

Re: Fwd: Re: Problem on setup Cassandra v4.0.1 cluster

2022-10-08 Thread onmstester onmstester via user
I encountered the same problem again with same error logs(this time with Apache Cassandra 4.0.6 and a new cluster), but unlike the previous time, hostname config was fine. After days of try and fail, finally i've found the root cause: time in faulty server has a 2 minute difference and not in

[RELEASE] Apache Cassandra 4.1-beta1 released

2022-10-05 Thread Mick Semb Wever
The Cassandra team is pleased to announce the release of Apache Cassandra version 4.1-beta1. Apache Cassandra is a fully distributed database. It is the right choice when you need scalability and high availability without compromising performance. http://cassandra.apache.org/ Downloads of

RE: Log messages "MUTATION messages were dropped" in system.log

2022-10-04 Thread Michail Kotsiouros via user
Hello community, I came across the following post: https://lists.apache.org/thread/t94jjc4j8dfd9sg5of9283mqcy3y3bgq This gives me a good explanation of the log. I will try to check the storage of the problematic datacenters. I will coma back if I have any good findings. BR MK From: Michail

Re: Doubts on multiple filter design in cassandra

2022-10-03 Thread Regis Le Bretonnic
Hi... We do the same (even if a lot of people will say it's bad and that you shouldn't...) with a "allow filtering" BUT ALWAYS WITHIN A PARTITION AND WITH A LIMIT CLAUSE TO AVOID A FULL PARTITION SCAN. . So you need to know the organisation_id and the product_type... and paginate your result

Doubts on multiple filter design in cassandra

2022-10-03 Thread Karthik K
We have a table designed to retrieve products by name in ascending order. OrganisationID and ProductType will be the compound partition key, whereas the ProductName will be the clustering key. So, the primary key structure is ((organisation_id, product_type), product_name) with clustering order

Re: The return of Cassandra Summit in 2023

2022-10-02 Thread Avi Kivity via user
If it's run by Linux Foundation, we may be able to present. Even better (but very difficult), get one of our open-source users to present. On Sat, 2022-10-01 at 13:04 -0700, Patrick McFadin wrote: > I know a lot of people are excited to see the return of Cassandra > Summit and I'm one of them!

Re: The return of Cassandra Summit in 2023

2022-10-01 Thread Patrick McFadin
I know a lot of people are excited to see the return of Cassandra Summit and I'm one of them! This has always been a gathering of not only people that use and love Cassandra but people that push the edge of scale and data. I hope to see a lot more of that in 2023. This summit is being run by the

RPM f36

2022-09-30 Thread Slava
Hello Everyone, I need some hint how to overcome strip problem during RPM build + /usr/lib/rpm/brp-strip /usr/bin/strip /usr/bin/strip: Unable to recognise the format of the input file

The return of Cassandra Summit in 2023

2022-09-29 Thread Melissa Logan
The Cassandra Summit is back! Event website: http://cassandrasummit.org/ It's time for us to gather again. The community has great momentum, having moved to an annual release cycle in the past year with many new features being added/requested. Cassandra Summit will be held in San Jose, Calif.,

RE: Questions on the count and multiple index behaviour in cassandra

2022-09-29 Thread Durity, Sean R via user
Aggregate queries (like count(*) ) are fine *within* a reasonably sized partition (under 100 MB in size). However, Cassandra is not the right tool if you want to do aggregate queries *across* partitions (unless you break up the work with something like Spark). Choosing the right partition key

Creating .lock files in /tmp folder during backup

2022-09-29 Thread Alexander Nikolaev via user
Hello, folks! I use "cassandra medusa" backup tool and I noticed some issues on some nodes during creating backup. Maybe somebody can help with it?During the backup in the /tmp folder creating a lot of files: -rw-r--r-- 1 rootroot 0 Sep 28 02:11

Re: TWCS recommendation on number of windows

2022-09-28 Thread Grzegorz Pietrusza
Hi Jeff Thanks a lot for all these details, they are really helpful. My understanding is that the number of windows is a tradeoff between the amount of data waiting for expiration and the number of sstables required to satisfy a read request. In my case the data model does have a timestamp

Re: Table with 'compact storage' is not shown in "describe table" output in cqlsh

2022-09-28 Thread manish khandelwal
Hi All Could this be due to how "DESC" functionality changed via https://issues.apache.org/jira/browse/CASSANDRA-14825? Earlier client drivers were creating schema so in the 3.11.x version, we were able to see the schema of COMPACT tables but now in Cassandra 4.0.x we are seeing the warning.

Re: Do you know about DBA Stack Exchange?

2022-09-28 Thread Stéphane Alleaume
Thank you very much Have a nice day Kind regards Stéphane Le mer. 28 sept. 2022, 20:46, Patrick McFadin a écrit : > Hi everyone, > > I wanted to make sure you know about a great community resource. DBA Stack > Exchange is a related site to Stack Overflow but strictly for DB operations >

Re: Do you know about DBA Stack Exchange?

2022-09-28 Thread Boyong N. Lambert
Thank you Patrick On Wed, Sep 28, 2022 at 7:46 PM Patrick McFadin wrote: > Hi everyone, > > I wanted to make sure you know about a great community resource. DBA Stack > Exchange is a related site to Stack Overflow but strictly for DB operations > people. There is a dedicated tag for

Do you know about DBA Stack Exchange?

2022-09-28 Thread Patrick McFadin
Hi everyone, I wanted to make sure you know about a great community resource. DBA Stack Exchange is a related site to Stack Overflow but strictly for DB operations people. There is a dedicated tag for Cassandra operations: https://dba.stackexchange.com/questions/tagged/cassandra I'm mentioning

Re: TWCS recommendation on number of windows

2022-09-28 Thread Jeff Jirsa
So when I wrote TWCS, I wrote it for a use case that had 24h TTLs and 30 days of retention. In that application, we had tested 12h windows, 24h windows, and 7 day windows, and eventually settled on 24h windows because that balanced factors like sstable size, sstables-per-read, and expired data

TWCS recommendation on number of windows

2022-09-28 Thread Grzegorz Pietrusza
Hi All! According to TWCS documentation ( https://cassandra.apache.org/doc/latest/cassandra/operating/compaction/twcs.html) the operator should choose compaction window parameters to select a compaction_window_unit and compaction_window_size pair that produces approximately 20-30 windows. I'm

Re: Questions on the count and multiple index behaviour in cassandra

2022-09-28 Thread Bowen Song via user
It sounds like you are misusing/abusing Cassandra. I've noticed the following Cassandra anti-patterns in your post: 1. Large or uneven partitions All rows in a table in a single partition is definitely an anti-pattern unless you only have a very small number of rows. 2. "SELECT COUNT(*)

Re: Questions on the count and multiple index behaviour in cassandra

2022-09-28 Thread Stéphane Alleaume
Hi 1) how much size in Mo is your partition ? Should be less than 100 Mo (but less in fact) 2) could you plug an Elasticsearch or Solr search in front ? Kind regards Stephane Le mer. 28 sept. 2022, 13:46, Karthik K a écrit : > Hi, > > We have two doubts on cassandra 3.11 features: > >

Questions on the count and multiple index behaviour in cassandra

2022-09-28 Thread Karthik K
Hi, We have two doubts on cassandra 3.11 features: 1) Need to get counts of row from a cassandra table. We have 3 node clusters with Apache Cassandra 3.11 version. We loaded a table in cassandra with 9lakh records. We have around 91 columns in this table. Most of the records have text as

Log messages "MUTATION messages were dropped" in system.log

2022-09-27 Thread Michail Kotsiouros via user
Hello Cassandra community, I see the following log lines in the Cassandra nodes of 2 datacenters that participate in a cluster of 6 datacenters. INFO [ScheduledTasks:1] 2022-09-12 17:19:44,422 MessagingService.java:1236 - MUTATION messages were dropped in last 5000 ms: 0 internal and 2 cross

Table with 'compact storage' is not shown in "describe table" output in cqlsh

2022-09-27 Thread manish khandelwal
Hi All As I understand there was a plan to drop *Compact Storage* support with *Cassandra 4* but later few issues were identified which resulted in continued support for Compact Storage in Cassandra 4. My cluster with a few old "compact storage" tables was able to come up with Cassandra 4.0.5.

Re: node decommission

2022-09-26 Thread Bowen Song via user
No, decommission does not decrease the load, as it only streams the data to other nodes, but doesn't remove them locally. However, decommission also shouldn't increase the load either. I can't offer an explanation for the load increase in your case. On 26/09/2022 15:03, Marc Hoppins wrote:

node decommission

2022-09-26 Thread Marc Hoppins
Hulloa all, I started a decommission. Node load was 1.08TiB. After 6 or so hours the load is at 1.12TiB. Shouldn't it be DECREASING?

Re: Cassandra data sync time

2022-09-26 Thread Bowen Song via user
It looks like you have replication factor of 3 and total data size of 1.43 GB per node. That's very small amount of data. Assuming the bottleneck is the network, not CPU or disk, and your 50 Mbps bandwidth is between each pair of servers across the two DCs (i.e. not the total bandwidth

Re: Cassandra java > 15

2022-09-26 Thread Erick Ramirez
Correction -- It has been brought to my attention that there are no plans for 5.0 yet so Java 17 support might be added sooner in the next 4.x release if it's ready. Cheers! > There is no support for Java 17 yet. The plan is to add it in Cassandra > 5.0 [1]. > > [1]

Re: Cassandra data sync time

2022-09-26 Thread Kaushal Shriyan
On Fri, Sep 23, 2022 at 8:39 PM Bowen Song via user < user@cassandra.apache.org> wrote: > What's your definition of "sync"? Streaming all the existing data to the > new DC? or the time lag between a write request is completed in one DC and > the other DC? > > The former can be estimated based on

Re: Cassandra java > 15

2022-09-26 Thread Erick Ramirez
There is no support for Java 17 yet. The plan is to add it in Cassandra 5.0 [1]. By default, builds are done with Java 8. You can build with Java 11 by setting the flags documented on the site [2]. Cheers! [1] https://issues.apache.org/jira/browse/CASSANDRA-16895 [2]

Cassandra java > 15

2022-09-25 Thread Slava
Hello Everyone, I am trying build RPM for fedora 36 with Java version 17 ( system ) and running into error Buildfile: /builddir/build/BUILD/apache-cassandra-4.0.6-src/build.xml Java 15 has removed Nashorn, you must provide an engine for running JavaScript yourself. GraalVM JavaScript

Re: Cassandra data sync time

2022-09-23 Thread Bowen Song via user
What's your definition of "sync"? Streaming all the existing data to the new DC? or the time lag between a write request is completed in one DC and the other DC? The former can be estimated based on a few facts about your setup (number of nodes, data size, etc.) and some measured data

Cassandra data sync time

2022-09-23 Thread Kaushal Shriyan
Hi, Is there a way to measure cassandra nodes data sync time between DC1 and DC2? Currently DC1 is the prod datacenter. I am adding DC2 to the new data center by referring to https://docs.apigee.com/private-cloud/v4.51.00/adding-data-center?hl=en.

Re: Restart Cassandra

2022-09-23 Thread Bowen Song via user
Even when a node has been stopped, it will still show up in the "nodetool status" output from other running nodes. While a node is starting, the status output from this node itself is pointless, because it may yet to receive the status from other nodes. You should ignore that until it's fully

RE: Restart Cassandra

2022-09-23 Thread Marc Hoppins
I restarted 48 nodes and every one came up fine. I was just wondering why the status run on the restarted node has no ID until it has finished dealing with whatever it does when starting up but it shows up immediately when status is run on any other node. I guess it prompts the question: how

Re: Restart Cassandra

2022-09-23 Thread Bowen Song via user
Did the node finish starting when you checked the "nodetool status" output? Try "nodetool netstats" on the starting node, the output will show "Mode: NORMAL" if it has finished starting. It's also worth checking the "nodetool info" output, and make sure "Gossip active" and "Native Transport

Restart Cassandra

2022-09-23 Thread Marc Hoppins
Hi all, Restarting the service on a node. Checking status from a remote node, I see: (prod) marc.hoppins.ipa@ba-cassandra01:~ $ /opt/cassandra/bin/nodetool status -r|grep 03 UN ba-cassandra09 779.03 GiB 16 ? 1fc8061d-2dd4-4b2c-97fa-e492063da495 SSW09 UN ba-cassandra20 796.94

Re: Local read request going across DC

2022-09-21 Thread manish khandelwal
Thanks a lot Erick for your help and support. Regards Manish On Wed, Sep 21, 2022, 19:12 Erick Ramirez wrote: > Just to circle back here, I've reviewed the trace output and it shows > multiple requests fired off for lookups on the `roles` table which > indicated to me that the default

Re: Local read request going across DC

2022-09-21 Thread Erick Ramirez
Just to circle back here, I've reviewed the trace output and it shows multiple requests fired off for lookups on the `roles` table which indicated to me that the default `cassandra` superuser is being used. To be clear, the original read request is being executed at the configured consistency BUT

Re: Local read request going across DC

2022-09-21 Thread Raphael Mazelier
I lost the beginning of the thread but I raised what seems the same issue recently in this list. I have a worldwide c* cluster with 3dcs (eu, us, ap 8nodes each). For whatever reason I have read with consistency set to local_quorum which trigger reads on other dc(s). I would say it's 1% of

Re: Local read request going across DC

2022-09-21 Thread Erick Ramirez
Would you be open to temporarily posting the full CQL command + full trace output to gist.github.com? I'd like to see what it shows. Cheers! >

Re: Local read request going across DC

2022-09-21 Thread manish khandelwal
Thanks Erick for the response. read_repair_chance is 0. Can speculative_retry cause this? We have that set at 99 percentile. Regards Manish On Wed, Sep 21, 2022 at 11:17 AM Erick Ramirez wrote: > It sounds like read-repair chance is enabled on the table. Check the table > schema for a

Re: Local read request going across DC

2022-09-20 Thread Erick Ramirez
It sounds like read-repair chance is enabled on the table. Check the table schema for a non-zero read_repair_chance. Cheers! >

Local read request going across DC

2022-09-20 Thread manish khandelwal
Hi All In one of our cluster, read request with consistency "LOCAL_QUORUM" is going across DC. When we run query setting CONSISTECY to LOCAL_QUORUM in cqlsh, with tracing on, we see READ and digest request sent across to nodes on other DC. I have checked gossipinfo, peers table, nodetool status.

Re: Cassandra GC tuning

2022-09-20 Thread Patrick McFadin
Amy's Guide. Still getting it done after all these years. Legendary. On Tue, Sep 20, 2022 at 6:05 AM Jeff Jirsa wrote: > Beyond this there are two decent tuning sets, but relatively dated at this > point > > Cassandra-8150 proposed a number of changes to defaults based on how it > had been

Re: Cassandra GC tuning

2022-09-20 Thread Jeff Jirsa
Beyond this there are two decent tuning sets, but relatively dated at this pointCassandra-8150 proposed a number of changes to defaults based on how it had been tuned at a specific large (competent) user:ASF JIRAissues.apache.orgAny Tobey wrote this guide around the 2.0/2.1 era, so it assumes

RE: Cassandra GC tuning

2022-09-20 Thread Michail Kotsiouros via user
Hello community, BTW I am using Cassandra 3.11.4. From your comments, I understand that a CPU spike and maybe a long GC may be expected at the snapshot creation under specific circumstances. I will monitor the resources during snapshot creation. I will come back with more news. Thanks a lot

Re: Change the compression algorithm on a production table at runtime

2022-09-20 Thread C. Scott Andreas
Thanks for reaching out. Changing the compressor for a table is both safe and common. Future flushes / compactions will use the new codec as SSTables are written, and SSTables currently present on disk will remain readable with the previous codec. You may also want to take a look at the

Change the compression algorithm on a production table at runtime

2022-09-20 Thread Eunsu Kim
Hi all According to https://docs.datastax.com/en/cql-oss/3.3/cql/cql_reference/cqlAlterTable.html , it can be very problematic to modify the Compaction strategy on a table running in production. Similarly, is it

Re: Cassandra GC tuning

2022-09-19 Thread Jeff Jirsa
https://issues.apache.org/jira/browse/CASSANDRA-13019 is in 4.0, you may find that tuning those thresholds On Mon, Sep 19, 2022 at 9:50 AM Jeff Jirsa wrote: > Snapshots are probably actually caused by a spike in disk IO and disk > latency, not GC (you'll see longer STW pauses as you get to a

Re: Cassandra GC tuning

2022-09-19 Thread Jeff Jirsa
Snapshots are probably actually caused by a spike in disk IO and disk latency, not GC (you'll see longer STW pauses as you get to a safepoint if that disk is hanging). This is especially problematic on SATA SSDs, or nVME SSDs with poor IO scheduler tuning. There's a patch somewhere to throttle

Re: Cassandra GC tuning

2022-09-19 Thread Patrick McFadin
GC tuning may seem like it's the best move, but more than likely, that is just the smoke from the real fire. Can you go more into your configuration? Memory. CPU. DIsk. Many times, GC is what shows up when running out of disk bandwidth or some other process eating up resources. Patrick On Mon,

Cassandra GC tuning

2022-09-19 Thread Michail Kotsiouros via user
Hello community, I observe some GC pauses while trying to create snapshots of a keyspace. The GC pauses as such are not long, even though they are reported in logs. The problem is the CPU utilization which affects other applications deployed in my server. Do you have any articles or

Re: Codec not found for list

2022-09-19 Thread Sébastien Rebecchi
Please ignore that message, I found my mistake, it was clear in the error message, I forgot to collect the Java stream as List... :) Sorry for the disturbance Le lun. 19 sept. 2022 à 11:08, Sébastien Rebecchi < sebastien.rebec...@gmail.com> a écrit : > Hello, > > I have a table where I store

Codec not found for list

2022-09-19 Thread Sébastien Rebecchi
Hello, I have a table where I store data in a column of type list I get that error when inserting data com.datastax.oss.driver.api.core.type.codec.CodecNotFoundException: Codec not found for requested operation: [List(BLOB, not frozen) <-> java.util.stream.ReferencePipeline$3] Do you know how I

Re: Local reads metric

2022-09-18 Thread Jeff Jirsa
Yes > On Sep 17, 2022, at 10:46 PM, Gil Ganz wrote: > >  > Hey > Do reads that come from a read repair are somehow counted as part of the > local read metric? > i.e > org.apache.cassandra.metrics.Table... : > ReadLatency.1m_rate > > Version is 4.0.4 > > Gil

Local reads metric

2022-09-17 Thread Gil Ganz
Hey Do reads that come from a read repair are somehow counted as part of the local read metric? i.e org.apache.cassandra.metrics.Table... : ReadLatency.1m_rate Version is 4.0.4 Gil

Re: Ldap/AD Authentication

2022-09-15 Thread Slater, Ben
Hi Our LDAP Authenticator for Cassandra is open source, Apache 2.0 licenced and free to use: https://github.com/instaclustr/cassandra-ldap We do offer support for it as part of our Cassandra support contracts but you don’t need to buy support to use it. Cheers Ben -- Ben Slater Chief

Re: TimeWindowCompactionStrategy Operational Concerns

2022-09-15 Thread Jeff Jirsa
If you were able to generate old data offline, using something like the CQLSSTableWriter class, you can add that to the cluster (either via streaming or nodetool import), that would maintain the TWCS invariant. That said, with https://issues.apache.org/jira/browse/CASSANDRA-13418 , IF you're

TimeWindowCompactionStrategy Operational Concerns

2022-09-15 Thread Michel Barret
Hi, I want to use TWCS on a cassandra table. Documentation explain 2 concerns about it: In case we mix old and new data "in the traditional write path". => How can I create another write path to ensure that my old data aren't in same sstable than new? If I query old data and that

Ldap/AD Authentication

2022-09-15 Thread Abdul Patel
Hi All, Do we have any open source ldap/AD pkgs/software for caasandra? I see instacluster has some but seems thats paid one.

Re: Hints not being sent from 3.0/3.11 to 4.0?

2022-09-14 Thread Morten A. Iversen via user
Hi, I have finally had time to test this a bit. And the issue seems to be there with Cassandra 3.11.13 as well as 3.0.27. Hinted handoff from these versions to version 4.0.6 does not seem to work. The way I tested this was by setting up a 2 node cluster, 1 node in each of dc1 and dc2. Install

Cassandra Community - October Meetups - London and Amsterdam

2022-09-13 Thread Stefano Lottini
Hello, Cassandra community! We are glad to announce that we've added two more cities to our Cassandra Day in-person events! We’re hosting Cassandra Day in London (October 11th) and Amsterdam (October 13th). Each will be a free one-day event and 100% focused on open-source Apache

Re: Using zstd compression on Cassandra 3.x

2022-09-13 Thread onmstester onmstester via user
I patched this on 3.11.2 easily: 1. build jar file from src and put in cassandra/lib directory 2. restart cassandra service 3. alter table using compression zstd and rebuild sstables But it was in a time when 4.0 was not available yet and after that i upgraded to 4.0 immidiately. Sent

Re: Using zstd compression on Cassandra 3.x

2022-09-12 Thread Eunsu Kim
Thank you for your response. I'll consider upgrading to 4.x. > 2022. 9. 13. 오후 2:41, Dinesh Joshi 작성: > > Is there something preventing you from upgrading to 4.0? It is backward > compatible with 3.0 so clients don’t need to change. > > If you don’t want to absolutely upgrade you can

Re: Using zstd compression on Cassandra 3.x

2022-09-12 Thread Dinesh Joshi
Is there something preventing you from upgrading to 4.0? It is backward compatible with 3.0 so clients don’t need to change. If you don’t want to absolutely upgrade you can extract the implementation from 4.0 and use it. I would advise against this path though as zstd implementation is

Using zstd compression on Cassandra 3.x

2022-09-12 Thread Eunsu Kim
Hi all, Since zstd compression is a very good compression algorithm, it is available in Cassandra 4.0. Because the overall performance and ratio are excellent There is open source available for Cassandra 3.x. https://github.com/MatejTymes/cassandra-zstd Do you have any experience applying this

Re: Bootstrap data streaming order

2022-09-12 Thread Jeff Jirsa
Sorry, I think the comment below is right, but there's some ambiguity, so adding more words. Each sending host will send each set of tables/keyspaces serially. So the number of concurrent streams is capped by the number of hosts in the cluster (not hosts * RF or hosts * tokens * RF, it's just one

Re: Bootstrap data streaming order

2022-09-12 Thread Jeff Jirsa
A new node joining will receive (replication factor) streams for each token it has. If you use single token and RF=3, three hosts will send data at the same time (the data sent is the “losing” replica of the data based on the next/new topology that will exist after the node finishes

Re: Bootstrap data streaming order

2022-09-12 Thread Gil Ganz
I see. I personally don't know the order, I would suggest you check the source code, try to understand from that. Regarding seed order, I don't know of any significance to the order of the seeds in the yaml, I don't think you should expect to see them appearing elsewhere by that order. As for

RE: Bootstrap data streaming order

2022-09-12 Thread Marc Hoppins
It doesn’t. However, I like to know things. Thus, I wanted to know what determines which nodes send their data in the order they do. Similarly, when the cluster was created, I added the seeds nodes in numerically ascending order and then the other nodes in a similar fashion. So why doesn’t

Re: Bootstrap data streaming order

2022-09-12 Thread Gil Ganz
I can understand why the number of nodes sending at once might be interesting somehow, but why would the order of the nodes matter? On Fri, Sep 9, 2022 at 10:27 AM Marc Hoppins wrote: > Curiosity as to which data/node starts first, what determines the delivery > sequence, how many nodes send

RE: Bootstrap data streaming order

2022-09-09 Thread Marc Hoppins
Curiosity as to which data/node starts first, what determines the delivery sequence, how many nodes send data at once and what determines that limit? The usual kind of questions. -Original Message- From: Dinesh Joshi Sent: Friday, September 9, 2022 9:14 AM To:

Re: Bootstrap data streaming order

2022-09-09 Thread Dinesh Joshi
The data is requested asynchronously from peers. There is some logic to select the peers however there isn’t a set order for data delivery. Why do you ask? > > On Sep 8, 2022, at 11:35 PM, Marc Hoppins wrote: > > Hulloa all, > > Can anyone shed light on the order which nodes will deliver

Bootstrap data streaming order

2022-09-09 Thread Marc Hoppins
Hulloa all, Can anyone shed light on the order which nodes will deliver data to a new node? Or point me toward a suitable chart/document? Does the new node accept data from each node in turn or simultaneously from multiple nodes? Thanks Marc

Re: Compaction task priority

2022-09-06 Thread onmstester onmstester via user
Using nodetool stop -id COMPACTION_UUID(reported in compactionstats), also you could figure it out with nodetool help stop Sent using https://www.zoho.com/mail/ On Mon, 05 Sep 2022 10:18:52 +0430 Gil Ganz wrote --- onmstester  - How can you stop a specific compaction task?

Re: Compaction task priority

2022-09-04 Thread Gil Ganz
onmstester - How can you stop a specific compaction task? stop command stops all compactions of a given type (would be nice to be able to stop specific one). Jim - in my case the solution was actually to limit concurrent compactors, not increase it. Too many tasks caused the server to slow down

Re: Compaction task priority

2022-09-02 Thread Jim Shaw
if capacity allowed, increase compaction_throughput_mb_per_sec as 1st tuning, and if still behind, increase concurrent_compactors as 2nd tuning. Regards, Jim On Fri, Sep 2, 2022 at 3:05 AM onmstester onmstester via user < user@cassandra.apache.org> wrote: > Another thing that comes to my

Re: Compaction task priority

2022-09-02 Thread onmstester onmstester via user
Another thing that comes to my mind: increase minimum sstable count to compact from 4 to 32 for the big table that won't be read that much, although you should watch out for too many sstables count. Sent using https://www.zoho.com/mail/ On Fri, 02 Sep 2022 11:29:59 +0430

Re: Compaction task priority

2022-09-02 Thread onmstester onmstester via user
I was there too! and found nothing to work around it except stopping big/unnecessary compactions manually (using nodetool stop) whenever they appears by some shell scrips (using crontab) Sent using https://www.zoho.com/mail/ On Fri, 02 Sep 2022 10:59:22 +0430 Gil Ganz wrote ---

Compaction task priority

2022-09-02 Thread Gil Ganz
Hey When deciding which sstables to compact together, how is the priority determined between tasks, and can I do something about it? In some cases (mostly after removing a node), it takes a while for compactions to keep up with the new data the came from removed nodes, and I see it is busy on

Re: netty connection reset by peer errors in logs

2022-09-01 Thread Gil Ganz
Reason I would like to suppress it is I think this is due to network disconnects we know are happening, and looks like it's not going to change. Since it doesn't happen that often, and not causing a real issue , I would like to have cleaner logs if possible. On Thu, Sep 1, 2022 at 9:55 AM Erick

Re: netty connection reset by peer errors in logs

2022-09-01 Thread Erick Ramirez
That error message indicates that 2 nodes are unable to communicate with each other over the internode (gossip) port. It makes no sense to suppress it since it's an indication that there's a problem that you need to address. Cheers!

netty connection reset by peer errors in logs

2022-09-01 Thread Gil Ganz
Hey We have an issue in few of our 4.0.4 clusters, these are on-prem, multiple datacenters around the world clusters, and our logs have many errors like this : ERROR [Messaging-EventLoop-3-26] 2022-09-01 05:57:28,142 InboundMessageHandler.java:300 -

[ANNOUNCE] Debian and RedHat package repositories are moving!

2022-08-26 Thread Mick Semb Wever
Your Debian `cassandra.sources.list` and RedHat `cassandra.repo` files must be updated to the new repository URLs. The Debian file is typically at `/etc/apt/sources.list.d/cassandra.sources.list`. The RedHat file is typically at `/etc/yum.repos.d/cassandra.repo`. For Debian the repository is now

New open-source CQL driver for Rust released - 0.5.0

2022-08-25 Thread Piotr Sarna via user
I'm pleased to announce ScyllaDB Rust Driver 0.5.0, an asynchronous CQL driver for Rust, fully compatible with Apache Cassandra™! Cool, ever growing open-source stats:  * over 38k downloads on crates;  * over 300 GitHub stars! === Notable changes ===  * Client-side timeouts are here! Request

Invitation to take the 2022 ASF Community Survey

2022-08-25 Thread Paulo Motta
Hello everyone, The 2022 ASF Community Survey is looking to gather scientific data that allows us to understand our community better, both in its demographic composition, and also in collaboration styles and preferences. We want to find areas where we can continue to do great work, and others

[RELEASE] Apache Cassandra 4.0.6 released

2022-08-25 Thread Mick Semb Wever
The Cassandra team is pleased to announce the release of Apache Cassandra version 4.0.6. Apache Cassandra is a fully distributed database. It is the right choice when you need scalability and high availability without compromising performance. http://cassandra.apache.org/ Downloads of source

RE: Erroneous node. - node is not a member of the

2022-08-24 Thread Marc Hoppins
Update again: The dc1-cass14 node stopped accepting/bootstrapping/streaming early on and now there is just a bunch of WARN [OptionalTasks:1] 2022-08-24 13:10:16,761 CassandraRoleManager.java:344 - CassandraRoleManager skipped default role setup: some nodes were not ready INFO

RE: Erroneous node. - node is not a member of the

2022-08-24 Thread Marc Hoppins
Update: I shut the server down and the node finally disappeared from the status. I then restarted the server on the similarly named node (dc1-cass14) and it came up...however, it is UJ. Was this due to the amount of time spent unavailable? M -Original Message- From: Marc Hoppins

RE: Erroneous node. - node is not a member of the

2022-08-24 Thread Marc Hoppins
Also, I just had some changes made to the cass.yml config so thought that is I rolling restart the nodes it might help the problem. Now I have a startup problem with an existing node...with a similar name Original problem node = dc2-cass14 Existing node = dc1-cass14 and am getting: ERROR

Erroneous node. - node is not a member of the

2022-08-24 Thread Marc Hoppins
Hi all, I added a node but forgot to specify the correct rack so I stopped the join and removed it. When I tried adding it again it was taking a LONG time to join. I tried draining before stopping the service but that failed. I killed the process and cleared the directories but the cluster

Re: Hints not being sent from 3.0 to 4.0?

2022-08-23 Thread Jim Shaw
Is it over max hint window ? if over, better to do a full repair. check table system.hints, do you see rows ? As I remember, during upgrade, transactions will store in hints until other cluster have done upgrade, so for safety, change default 3 hours hint window to long time just before

Hints not being sent from 3.0 to 4.0?

2022-08-23 Thread Morten A. Iversen via user
Hi, We are currently in the process of upgrading our environment from 3.0.27 to 4.0.4. However I see some issues with hints not being sent from v3 nodes to v4 nodes. We have a test environment with 2DCs, we are currently writing to DC1 and DC2 have been upgraded from version 3.0.27 -> 4.0.4

Cassandra Day Berlin, September 20th

2022-08-23 Thread Stefano Lottini
Hello, Cassandra community! The next Cassandra Day event will be an in-person, one-day event which will take place in the German capital on Tuesday, 20 September 2022, hosted and organized by DataStax. Cassandra Days focus on the open source Apache Cassandra project and the community that

<    4   5   6   7   8   9   10   11   12   13   >