Re: Performance drop of current Java drivers

2020-04-30 Thread Erick Ramirez
Matthias, I don't have an answer to your question but I just wanted to note that I don't believe the driver contributors actively watch this mailing list (I'm happy to be corrected 🙂 ) so I'd recommend you cross-post in the Java driver channels as well. Cheers!

Re: Nodetool clearsnapshot does not delete snapshot for dropped column_family

2020-04-30 Thread Sebastian Estevez
Perhaps you had a DDL collision and ended up with two data dirs for the table? In that case running drop table would only move the active table directory to snapshots and as Eric suggested would leave the data in the duplicate directory "orphaned". I haven't tried to reproduce this yet but I thin

Re: Nodetool clearsnapshot does not delete snapshot for dropped column_family

2020-04-30 Thread Sergio
The problem is that folder is not under snapshot but it is under the data path. I tried with the --all switch too Thanks, Sergio On Thu, Apr 30, 2020, 4:21 PM Nitan Kainth wrote: > I don't think it works like that. clearsnapshot --all would remove all > snapshots. Here is an example: > > $ ls -l

Re: Nodetool clearsnapshot does not delete snapshot for dropped column_family

2020-04-30 Thread Nitan Kainth
I don't think it works like that. clearsnapshot --all would remove all snapshots. Here is an example: $ ls -l /ss/xx/cassandra/data/ww/a-5bf825428b3811eabe0c6b7631a60bb0/snapshots/ total 8 drwxr-xr-x 2 cassandra cassandra 4096 Apr 30 23:17 dropped-1588288650821-a drwxr-xr-x 2 cassandra cassandr

Re: Nodetool clearsnapshot does not delete snapshot for dropped column_family

2020-04-30 Thread Erick Ramirez
Yes, you're right. It doesn't show up in listsnapshots nor does clearsnapshot remove the dropped snapshot because the table is no longer managed by C* (because it got dropped). So you will need to manually remove the dropped-* directories from the filesystem. Someone here will either correct me or

Nodetool clearsnapshot does not delete snapshot for dropped column_family

2020-04-30 Thread Sergio Bilello
Hi guys! I am running cassandra 3.11.4. I dropped a column_family but I am able to see the disk space occupied by that column_family in the disk. I understood that since I have the auto_snapshot flag = true this behavior is expected. However, I would like to avoid to write a dummy script that rem

Re: UDTs, UDFs und UDAs

2020-04-30 Thread Andreas R.
 Hello I am trying to extract sketches (e.g. bloom filter) from some given data. I came this far, questions below: |CREATE TYPE bloomfilter_udt(|| n_as_sample_size int, m_as_number_of_buckets int,|| p_as_next_prime_above_m bigint, hash_for_string_coefficient_a list ,|| hash_for_numbe

Performance drop of current Java drivers

2020-04-30 Thread Matthias Pfau
Hi there, I just did some testing with latest 3.x and 4.x version of the java driver. While async performance seems to be fine, sync performance degraded significantly with version 4.x. Reading 10.000 small columns from a local cassandra instance took: * around 5 seconds with the old driver * a

Re: Adding new DC results in clients failing to connect

2020-04-30 Thread Jorge Bay Gondra
Hi, You can enable logging at driver to see what's happening under the hood: https://docs.datastax.com/en/developer/csharp-driver/3.14/faq/#how-can-i-enable-logging-in-the-driver With logging information, it should be easy to track the issue down. Can you query system.local and system.peers on a s

Adding new DC results in clients failing to connect

2020-04-30 Thread Gediminas Blazys
Hello, We have run into a very interesting issue and maybe some of you have encountered it or just have an idea where to look. We are working towards adding new dcs into our cluster, here's the current topology: DC1 - 18 nodes DC2 - 18 nodes DC3 - 18 nodes DC4 - 18 nodes DC5 - 18 nodes Recentl