Re: Reaper 1.2 released

[Akash Gangil]

Hi,

I see that when I try to access /snapshot/{clusterName} API endpoint, I get
a 404 while all the other endpoints /cluster, /repair_run and
/repair_scheduler work for me. I am using version 1.2.1
It appears as if the /snapshot endpoint is not there

API doc that I am referring http://cassandra-reaper.io/docs/api/

I double checked docs and this just seems to be a weird error



On Wed, Jul 25, 2018 at 3:09 PM, Mick Semb Wever  wrote:

>
> Feel free to file issues at https://github.com/thelastpick
> le/cassandra-reaper/issues
> or chat with us at https://gitter.im/thelastpickle/cassandra-reaper
>
> regards,
> Mick
>
>
>
> On Thu, 26 Jul 2018, at 06:18, Abdul Patel wrote:
> > Was abke start it but unable to start any repair manually it says
> > POST/repair_run
> > Unit conflits with exiting in clustername
> >
> > On Wednesday, July 25, 2018, Abdul Patel  wrote:
> >
> > > Ignore , alter and create permission were missing ..will msg if i
> actually
> > > see an showstopper
> > >
> > > On Wednesday, July 25, 2018, Abdul Patel  wrote:
> > >
> > >> I am trying to uograde to 1.2.2 version of reaper the instance isnt
> > >> starting and giving error that unable to create table snapshot ..do
> we need
> > >> to create it under reaper-db?
> > >>
> > >> On Wednesday, July 25, 2018, Steinmaurer, Thomas <
> > >> thomas.steinmau...@dynatrace.com> wrote:
> > >>
> > >>> Jon,
> > >>>
> > >>>
> > >>>
> > >>> eager trying it out.  Just FYI. Followed the installation
> > >>> instructions on http://cassandra-reaper.io/docs/download/install/
> > >>> Debian-based.
> > >>>
> > >>>
> > >>>
> > >>> 1) Importing the key results in:
> > >>>
> > >>>
> > >>>
> > >>> XXX:~$ sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys
> > >>> 2895100917357435
> > >>>
> > >>> Executing: /tmp/tmp.tP0KAKG6iT/gpg.1.sh --keyserver
> > >>>
> > >>> keyserver.ubuntu.com
> > >>>
> > >>> --recv-keys
> > >>>
> > >>> 2895100917357435
> > >>>
> > >>> gpg: requesting key 17357435 from hkp server keyserver.ubuntu.com
> > >>>
> > >>> ?: [fd 4]: read error: Connection reset by peer
> > >>>
> > >>> gpgkeys: HTTP fetch error 7: couldn't connect: eof
> > >>>
> > >>> gpg: no valid OpenPGP data found.
> > >>>
> > >>> gpg: Total number processed: 0
> > >>>
> > >>> gpg: keyserver communications error: keyserver unreachable
> > >>>
> > >>> gpg: keyserver communications error: public key not found
> > >>>
> > >>> gpg: keyserver receive failed: public key not found
> > >>>
> > >>>
> > >>>
> > >>> I had to change the keyserver URL then the import worked:
> > >>>
> > >>>
> > >>>
> > >>> XXX:~$ sudo apt-key adv --keyserver *hkp://keyserver.ubuntu.com:80
> > >>> * --recv-keys 2895100917357435
> > >>>
> > >>> Executing: /tmp/tmp.JwPNeUkm6x/gpg.1.sh --keyserver
> > >>>
> > >>> hkp://keyserver.ubuntu.com:80
> > >>>
> > >>> --recv-keys
> > >>>
> > >>> 2895100917357435
> > >>>
> > >>> gpg: requesting key 17357435 from hkp server keyserver.ubuntu.com
> > >>>
> > >>> gpg: key 17357435: public key "TLP Reaper packages <
> > >>> rea...@thelastpickle.com>" imported
> > >>>
> > >>> gpg: Total number processed: 1
> > >>>
> > >>> gpg:   imported: 1  (RSA: 1)
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>> 2) Running apt-get update fails with:
> > >>>
> > >>>
> > >>>
> > >>> XXX:~$ sudo apt-get update
> > >>>
> > >>> Ign:1 https://dl.bintray.com/thelastpickle/reaper-deb wheezy
> InRelease
> > >>>
> > >>> Ign:2 https://dl.bintray.com/thelastpickle/reaper-deb wheezy Release
> > >>>
> > >>> Ign:3 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> amd64
> > >>> Packages
> > >>>
> > >>> Ign:4 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> i386
> > >>> Packages
> > >>>
> > >>> Ign:5 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> all
> > >>> Packages
> > >>>
> > >>> Ign:6 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> > >>> Translation-en_US
> > >>>
> > >>> Ign:7 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> > >>> Translation-en
> > >>>
> > >>> Ign:3 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> amd64
> > >>> Packages
> > >>>
> > >>> Ign:4 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> i386
> > >>> Packages
> > >>>
> > >>> Ign:5 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> all
> > >>> Packages
> > >>>
> > >>> Ign:6 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> > >>> Translation-en_US
> > >>>
> > >>> Ign:7 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> > >>> Translation-en
> > >>>
> > >>> Ign:3 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> amd64
> > >>> Packages
> > >>>
> > >>> Ign:4 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> i386
> > >>> Packages
> > >>>
> > >>> Ign:5 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> all
> > >>> Packages
> > >>>
> > >>> Ign:6 https://dl.bintray.com/thelastpickle/reaper-deb wheezy/main
> > >>> Translation-en_US
> 

JOB | Permanent Java Development Manager (Montreal, Canada)

[James Tobin]

Hello, I'm working with an employer that is looking to hire (for their
Montreal office) a permanent development manager that has extensive
hands-on Java coding experience.  Consequently I had hoped that some
members of this mailing list may like to discuss with me further;
off-list.  I can be reached using "JamesBTobin (at) Gmail (dot) Com".
Kind regards, James

-
To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
For additional commands, e-mail: user-h...@cassandra.apache.org

Re: Re: [EXTERNAL] full text search on some text columns

[Ben Slater]

We (Instaclustr) will be submitting a PR for 3.11.3 support for
cassandra-lucene-index once 3.11.3 is officially released as we offer it as
part of our service and have customers using it.

Cheers
Ben

On Wed, 1 Aug 2018 at 14:06 onmstester onmstester 
wrote:

> It seems to be an interesting project but sort of abandoned. No update in
> last 8 Months and not supporting Cassandra 3.11.2  (the version i currently
> use)
>
> Sent using Zoho Mail 
>
>
>  Forwarded message 
> From : Andrzej Śliwiński 
> To : 
> Date : Wed, 01 Aug 2018 08:16:06 +0430
> Subject : Re: [EXTERNAL] full text search on some text columns
>  Forwarded message 
>
> Maybe this plugin could do the job:
> https://github.com/Stratio/cassandra-lucene-index
>
> On Tue, 31 Jul 2018 at 22:37, onmstester onmstester 
> wrote:
>
>
> --


*Ben Slater*

*Chief Product Officer *

   


Read our latest technical blog posts here
.

This email has been sent on behalf of Instaclustr Pty. Limited (Australia)
and Instaclustr Inc (USA).

This email and any attachments may contain confidential and legally
privileged information.  If you are not the intended recipient, do not copy
or disclose its content, but please reply to this email immediately and
highlight the error to the sender and then immediately delete the message.

Fwd: Re: [EXTERNAL] full text search on some text columns

[onmstester onmstester]

It seems to be an interesting project but sort of abandoned. No update in last 
8 Months and not supporting Cassandra 3.11.2  (the version i currently use) 
Sent using Zoho Mail  Forwarded message  From : Andrzej 
Śliwiński  To :  Date : 
Wed, 01 Aug 2018 08:16:06 +0430 Subject : Re: [EXTERNAL] full text search on 
some text columns  Forwarded message  Maybe this plugin 
could do the job: https://github.com/Stratio/cassandra-lucene-index On Tue, 31 
Jul 2018 at 22:37, onmstester onmstester  wrote:

Re: [EXTERNAL] full text search on some text columns

[Andrzej Śliwiński]

Maybe this plugin could do the job:
https://github.com/Stratio/cassandra-lucene-index

On Tue, 31 Jul 2018 at 22:37, onmstester onmstester 
wrote:

> Actually we can't afford buying DataStax Search
>
> Sent using Zoho Mail 
>
>
>  On Tue, 31 Jul 2018 19:38:28 +0430 *Durity, Sean R
> >* wrote 
>
> That sounds like a problem tailor-made for the DataStax Search (embedded
> SOLR) solution. I think that would be the fastest path to success.
>
>
>
>
>
> Sean Durity
>
>
>
> *From:* onmstester onmstester 
> *Sent:* Tuesday, July 31, 2018 10:46 AM
> *To:* user 
> *Subject:* [EXTERNAL] full text search on some text columns
>
>
>
> I need to do a full text search (like) on one of my clustering keys and
> one of partition keys (it use text as data type). The input rate is high so
> only Cassandra could handle it, Is there any open source version project
> which help using cassandra+ solr or cassandra + elastic?
>
> Any Recommendation on doing this with home-made solutions would be
> appreciated?
>
>
>
> Sent using Zoho Mail
> 
>
>
>
>
>
> --
>
> The information in this Internet Email is confidential and may be legally
> privileged. It is intended solely for the addressee. Access to this Email
> by anyone else is unauthorized. If you are not the intended recipient, any
> disclosure, copying, distribution or any action taken or omitted to be
> taken in reliance on it, is prohibited and may be unlawful. When addressed
> to our clients any opinions or advice contained in this Email are subject
> to the terms and conditions expressed in any applicable governing The Home
> Depot terms of business or client engagement letter. The Home Depot
> disclaims all responsibility and liability for the accuracy and content of
> this attachment and for any damages or losses arising from any
> inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other
> items of a destructive nature, which may be contained in this attachment
> and shall not be liable for direct, indirect, consequential or special
> damages in connection with this e-mail message or its attachment.
>
>
>
>

RE: [EXTERNAL] full text search on some text columns

[onmstester onmstester]

Actually we can't afford buying DataStax Search Sent using Zoho Mail  On 
Tue, 31 Jul 2018 19:38:28 +0430 Durity, Sean R  
wrote  That sounds like a problem tailor-made for the DataStax Search 
(embedded SOLR) solution. I think that would be the fastest path to success.    
 Sean Durity   From: onmstester onmstester  Sent: Tuesday, 
July 31, 2018 10:46 AM To: user  Subject: [EXTERNAL] 
full text search on some text columns   I need to do a full text search (like) 
on one of my clustering keys and one of partition keys (it use text as data 
type). The input rate is high so only Cassandra could handle it, Is there any 
open source version project which help using cassandra+ solr or cassandra + 
elastic? Any Recommendation on doing this with home-made solutions would be 
appreciated?   Sent using Zoho Mail     The information in this Internet Email 
is confidential and may be legally privileged. It is intended solely for the 
addressee. Access to this Email by anyone else is unauthorized. If you are not 
the intended recipient, any disclosure, copying, distribution or any action 
taken or omitted to be taken in reliance on it, is prohibited and may be 
unlawful. When addressed to our clients any opinions or advice contained in 
this Email are subject to the terms and conditions expressed in any applicable 
governing The Home Depot terms of business or client engagement letter. The 
Home Depot disclaims all responsibility and liability for the accuracy and 
content of this attachment and for any damages or losses arising from any 
inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other items 
of a destructive nature, which may be contained in this attachment and shall 
not be liable for direct, indirect, consequential or special damages in 
connection with this e-mail message or its attachment.

Re: full text search on some text columns

[onmstester onmstester]

Thanks Jordan, There would be millions of rows per day, is SASI capable of 
standing such a rate? Sent using Zoho Mail  On Tue, 31 Jul 2018 19:47:55 
+0430 Jordan West  wrote  On Tue, Jul 31, 2018 at 7:45 
AM, onmstester onmstester  wrote: I need to do a full text 
search (like) on one of my clustering keys and one of partition keys (it use 
text as data type). For simple LIKE queries on existing columns you could give 
SASI (https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/useSASIIndex.html) 
a try without having to stand up a separate piece of software. Its relatively 
new and isn’t as battle tested as other parts of Cassandra but it has been used 
in production. There are some performance issues with wider-CQL partitions if 
you have those (https://issues.apache.org/jira/browse/CASSANDRA-11990). I hope 
to address that for 4.0, time permitted.  Full disclosure, I was one of the 
original SASI authors.   The input rate is high so only Cassandra could handle 
it, Is there any open source version project which help using cassandra+ solr 
or cassandra + elastic? Any Recommendation on doing this with home-made 
solutions would be appreciated? Sent using Zoho Mail  

Re: full text search on some text columns

[DuyHai Doan]

I had SASI in mind before stopping myself from replying to this thread.
Actually the OP needs to index clustering column and partition key, and as
far as I remember, I've myself opened a JIRA and pushed a patch for SASI to
support indexing composite partition key but there are some issues so far
preventing this to be merged into trunk

https://issues.apache.org/jira/browse/CASSANDRA-11734

https://issues.apache.org/jira/browse/CASSANDRA-13228

On Tue, Jul 31, 2018 at 5:17 PM, Jordan West  wrote:

>
>
> On Tue, Jul 31, 2018 at 7:45 AM, onmstester onmstester <
> onmstes...@zoho.com> wrote:
>
>> I need to do a full text search (like) on one of my clustering keys and
>> one of partition keys (it use text as data type).
>>
>
> For simple LIKE queries on existing columns you could give SASI (
> https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/useSASIIndex.html)
> a try without having to stand up a separate piece of software. Its
> relatively new and isn’t as battle tested as other parts of Cassandra but
> it has been used in production. There are some performance issues with
> wider-CQL partitions if you have those (https://issues.apache.org/
> jira/browse/CASSANDRA-11990). I hope to address that for 4.0, time
> permitted.
>
> Full disclosure, I was one of the original SASI authors.
>
>
>> The input rate is high so only Cassandra could handle it, Is there any
>> open source version project which help using cassandra+ solr or cassandra +
>> elastic?
>> Any Recommendation on doing this with home-made solutions would be
>> appreciated?
>>
>> Sent using Zoho Mail 
>>
>>
>
>
>

Secure data

[Rahul Reddy]

Hello,

I'm trying to find a good document on to enable encryption for Apache
Cassandra  (not on dse) tables and commilogs and store the keystore in kms
or vault. If any of you already configured please direct me to
documentation for it.

Re: full text search on some text columns

[Jordan West]

On Tue, Jul 31, 2018 at 7:45 AM, onmstester onmstester 
wrote:

> I need to do a full text search (like) on one of my clustering keys and
> one of partition keys (it use text as data type).
>

For simple LIKE queries on existing columns you could give SASI (
https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/useSASIIndex.html) a
try without having to stand up a separate piece of software. Its relatively
new and isn’t as battle tested as other parts of Cassandra but it has been
used in production. There are some performance issues with wider-CQL
partitions if you have those (
https://issues.apache.org/jira/browse/CASSANDRA-11990). I hope to address
that for 4.0, time permitted.

Full disclosure, I was one of the original SASI authors.


> The input rate is high so only Cassandra could handle it, Is there any
> open source version project which help using cassandra+ solr or cassandra +
> elastic?
> Any Recommendation on doing this with home-made solutions would be
> appreciated?
>
> Sent using Zoho Mail 
>
>

RE: [EXTERNAL] full text search on some text columns

[Durity, Sean R]

That sounds like a problem tailor-made for the DataStax Search (embedded SOLR) 
solution. I think that would be the fastest path to success.


Sean Durity

From: onmstester onmstester 
Sent: Tuesday, July 31, 2018 10:46 AM
To: user 
Subject: [EXTERNAL] full text search on some text columns

I need to do a full text search (like) on one of my clustering keys and one of 
partition keys (it use text as data type). The input rate is high so only 
Cassandra could handle it, Is there any open source version project which help 
using cassandra+ solr or cassandra + elastic?
Any Recommendation on doing this with home-made solutions would be appreciated?


Sent using Zoho 
Mail





The information in this Internet Email is confidential and may be legally 
privileged. It is intended solely for the addressee. Access to this Email by 
anyone else is unauthorized. If you are not the intended recipient, any 
disclosure, copying, distribution or any action taken or omitted to be taken in 
reliance on it, is prohibited and may be unlawful. When addressed to our 
clients any opinions or advice contained in this Email are subject to the terms 
and conditions expressed in any applicable governing The Home Depot terms of 
business or client engagement letter. The Home Depot disclaims all 
responsibility and liability for the accuracy and content of this attachment 
and for any damages or losses arising from any inaccuracies, errors, viruses, 
e.g., worms, trojan horses, etc., or other items of a destructive nature, which 
may be contained in this attachment and shall not be liable for direct, 
indirect, consequential or special damages in connection with this e-mail 
message or its attachment.

Re: Cassandra 3.11 and subrange repairs

[Martin Mačura]

I am using this tool with 3.11, had to modify it to make it usable:

https://github.com/BrianGallew/cassandra_range_repair/pull/60

Martin

On Tue, Jul 31, 2018 at 3:44 PM Jean Carlo  wrote:
>
> Hello everyone,
>
> I am just wondering if someone is using this tool to make repairs in 
> cassandra 3.11
>
> https://github.com/BrianGallew/cassandra_range_repair
>
> Or everybody is using cassandra-reaper ? :)
>
> I am willing to use cassandra-reaper soon but meanwhile I will just need to 
> cron the repairs in cluster.
>
>
> Actually, I want to know if cassandra_range_repair works properly in 3.11 
> because its repository is not active so far
>
>
>
> Best greetings
>
> Jean Carlo
>
> "The best way to predict the future is to invent it" Alan Kay

-
To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
For additional commands, e-mail: user-h...@cassandra.apache.org

full text search on some text columns

[onmstester onmstester]

I need to do a full text search (like) on one of my clustering keys and one of 
partition keys (it use text as data type). The input rate is high so only 
Cassandra could handle it, Is there any open source version project which help 
using cassandra+ solr or cassandra + elastic? Any Recommendation on doing this 
with home-made solutions would be appreciated? Sent using Zoho Mail

Cassandra 3.11 and subrange repairs

[Jean Carlo]

Hello everyone,

I am just wondering if someone is using this tool to make repairs in
cassandra 3.11

https://github.com/BrianGallew/cassandra_range_repair

Or everybody is using cassandra-reaper ? :)

I am willing to use cassandra-reaper soon but meanwhile I will just need to
cron the repairs in cluster.


Actually, I want to know if cassandra_range_repair works properly in 3.11
because its repository is not active so far



Best greetings

Jean Carlo

"The best way to predict the future is to invent it" Alan Kay

Re: optimization to cassandra-env.sh

[R1 J1]

Thank  you Sean and Rahul for the consult

On Sun, Jul 29, 2018 at 6:52 PM, Rahul Singh 
wrote:

> Depends on which GC you are using but you can definitely manage GC - but
> you will always be stuck to the upper limit of memory.
>
> I found the Hubspot gc visualizer and the associated blog post very
> helpful in the past.
>
> *https://github.com/HubSpot/gc_log_visualizer/blob/master/README.md*
> 
>
>
>
> *https://product.hubspot.com/blog/g1gc-fundamentals-lessons-from-taming-garbage-collection*
> 
>
> Rahul
> On Jul 26, 2018, 1:27 PM -0400, R1 J1 , wrote:
>
> Any one has tried to optimize or change cassandra-env.sh in an server
> installation to make it use more heap size for garbage collection ?
> Any ideas ? We are having some oom issues and thinking if we have options
> other than increasing RAM for that node.
>
> Regards
>
>

Re: Alter table

[James Shaw]

in a heavy transaction PROD env, it is risk, considering c* has a lot of
bugs.
the DDL has to be replicated to all nodes,  use nodetool describecluster to
check schema version same on all nodes, if not,  you may restart that node
which DDL not replicated.
in new version, DDL is none or all,  you may not get it success.

It is similar to rdbms,  alter table in a heavy transaction PROD env, may
get resource busy error.

in non-prod, we always apply new DDL without stop applications, never had
issue.

Thanks,

James


On Tue, Jul 31, 2018 at 1:37 AM, Jeff Jirsa  wrote:

> This is safe (and normal, and good) in all versions except those impacted
> by https://issues.apache.org/jira/browse/CASSANDRA-13004
>
> So if you're on 2.1, 2.2, or 3.11 you're fine
>
> If you're on 3.0 between 3.0.0 and 3.0.13, you should upgrade first (to
> newest 3.0, probably 3.0.17)
> If you're on a version between 3.1 and 3.10, you should upgrade first (to
> newest 3.11, probably 3.11.3)
>
> - Jeff
>
>
> On Mon, Jul 30, 2018 at 10:16 PM, Visa  wrote:
>
>> Hi all,
>>
>> I have one question about altering schema. If we only add columns, is it
>> ok to alter the schema while the writes to the table are happening at the
>> same time? We can control that the writes will not touch the new columns
>> until the schema change is done. Or better to stop the writes to that table
>> first.
>>
>> Thanks!
>>
>> Li
>> -
>> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
>> For additional commands, e-mail: user-h...@cassandra.apache.org
>>
>>
>