Re: ssl certificate hot reloading test - cassandra 4.1

trust store change Cassandra could simply adjust the connection lifetimes and they will be disconnected immediately or drained over a time period like Josh proposed. Thanks, Andy

Re: ssl certificate hot reloading test - cassandra 4.1

to inflight queries (if your client is configured for retries it will probably be fine). Semantically to your applications it should look a lot like a rolling cluster bounce. Thanks, Andy On Mon, Apr 15, 2024 at 11:39 AM pabbireddy avinash wrote: > > Thanks Andy for your reply . We wil

Re: ssl certificate hot reloading test - cassandra 4.1

l out a keystore/truststore change as a way of enforcing the existing connections to reestablish. Thanks, Andy On Mon, Apr 15, 2024 at 11:11 AM pabbireddy avinash wrote: > > Dear Community, > > I hope this email finds you well. I am currently testing SSL certificate hot > reloading

Re: Failed disks - correct procedure

of compactions = slower reads) and you may be seeing some inconsistency if repairs weren't regularly running beforehand. How much data was on the drive that failed? How much data do you usually have per node? Thanks, Andy On Mon, Jan 16, 2023 at 10:59 AM Joe Obernberger wrote: > > Thank you

Re: Failed disks - correct procedure

've done recently, so I'm not as confident on executing that procedure. Thanks, Andy On Mon, Jan 16, 2023 at 9:28 AM Joe Obernberger wrote: > > Hi all - what is the correct procedure when handling a failed disk? > Have a node in a 15 node cluster. This node has 16 drives and

Re: Wrong Consistency level seems to be used

r versions of C* the errors may be more specific or a warning may come along with it depending on what is failing. Thanks, Andy

Re: Enabling SSL on a live cluster

ore changes, so whenever you update the certificates in your keystores (e.g. to avoid your certificates expiring) you would need to bounce your cassandra instances. See: https://cassandra.apache.org/doc/4.0/cassandra/operating/security.html#ssl-certificate-hot-reloading for explanation on how t

Re: Unexpected error while refreshing token map, keeping previous version (IllegalArgumentException: Multiple entries with same key ?

ake sure I'm not ignoring a possible bug ;) Thanks, Andy On Thu, Jun 20, 2019 at 10:20 AM Andy Tolbert wrote: > One thing that strikes me is that the endpoint reported is '127.0.0.1'. > Is it possible that you have rpc_address set to 127.0.0.1 on each of your > three n

Re: Unexpected error while refreshing token map, keeping previous version (IllegalArgumentException: Multiple entries with same key ?

. Can you verify this by executing 'select peer, rpc_address from system.peers' to see what is being reported as the rpc_address and let me know? In any case, the driver should probably handle this better, I'll create a driver ticket. Thanks, Andy On Thu, Jun 20, 2019 at 1

Re: Deployment

ld have to ... > The coordinator utilizes a dynamic snitch <http://cassandra.apache.org/doc/latest/operating/snitch.html> to determine where to route read queries. Thanks, Andy On Sat, Jan 12, 2019 at 9:14 AM amit sehas wrote: > Thanks for your response, this leads to some further questions: > >

Re: Nodejs connector high latency

trivial work, that can delay subsequent requests from being processed, which may give impression that some queries are slow. Thanks, Andy On Sun, Nov 4, 2018 at 8:59 AM Tarun Chabarwal wrote: > Hi > > I used cassandra driver provided by datastax (3.5.0) library in nodejs. > I've

Re: Java 10 for Cassandra 3.11.3

Hi Jeronimo, Until Cassandra 4.0, JDK 8 is required. See CASSANDRA-9608 <https://jira.apache.org/jira/browse/CASSANDRA-9608> for more details. Thanks, Andy On Mon, Sep 3, 2018 at 8:45 AM Jeronimo de A. Barros < jeronimo.bar...@gmail.com> wrote: > Hi guys, > > I'

Re: why returned achievedConsistencyLevel is null

onsistency level you have configured was met for your operations. Thanks, Andy On Fri, Aug 24, 2018 at 4:14 PM Vitaliy Semochkin wrote: > > HI, > > While using DataStax driver > session.execute("some insert > query")getExecutionInfo().getAchievedConsistencyLevel()

Re: which driver to use with cassandra 3

(see here <https://github.com/datastax/java-driver/tree/4.x/upgrade_guide>) so we intend to continue maintaining the 3.x line for quite a while. Thanks, Andy On Fri, Jul 20, 2018 at 9:54 AM, Vitaliy Semochkin wrote: > Thank you very much Duy Hai Doan! > I have relatively simple dem

Re: Client ID logging

gt; to see what active TCP connections there are to the host servers running your C* cluster to capture the IP addresses of the clients connected to your cluster. Thanks, Andy On Mon, May 21, 2018 at 1:42 PM, Hannu Kröger wrote: > Hmm, I think that by default not but you can create a hoo

Re: Cassandra client drivers

safe ;). Thanks, Andy On Mon, May 7, 2018 at 5:47 PM, Abdul Patel wrote: > Hi > > I am.planning for upgrade from 3.1.0 to 3.11.2 , just wanted to confirm if > cleint drivers need to upgraded? Or it will work with 3.1.0 drivers? > > >

Re: Cassandra Driver Pagination

driver has requested. If you have a really wide partition or a lot of tombstones in the partition, you may find your query performance being slow in general when reading rows from that partition. Thanks, Andy On Wed, Apr 25, 2018 at 3:08 AM, Ahmed Eljami wrote: > Hi Andy, > > Thanks.

Re: Cassandra Driver Pagination

ing the next set of rows. When you continue iterating over the result set in the java driver and hit the end of the current page, it will send another request to C* using that paging state to get the next set of rows. Thanks, Andy On Tue, Apr 24, 2018 at 9:49 AM, Ahmed Eljami wrote: > Hel

Re: How to get page id without transmitting data to client

r particular use case. Thanks, Andy On Thu, Dec 28, 2017 at 9:11 PM, Eunsu Kim wrote: > Hello everybody, > > I am using the datastax Java driver (3.3.0). > > When query large amounts of data, we set the fetch size (1) and > transmit the data to the browser on a page-by-page

Re: DataStax Java driver QueryBuilder: CREATE table?

va-driver/blob/3.3.x/driver-core/src/test/java/com/datastax/driver/core/schemabuilder/CreateTest.java> . Thanks, Andy On Thu, Dec 14, 2017 at 5:16 PM Oliver Ruebenacker wrote: > > Hello, > > I'm using the DataStax Java Driver, which has a QueryBuilder class to > con

Re: code snippet for cqlsh COPY from

small even with single partition batches depending on your dataset. In my particular case I was working with relatively small data (100-byte rows). There is diminishing returns in terms of throughput as your increase your batch size, but that will vary based on your data and environment. Thanks

Re: Migrating a Limit/Offset Pagination and Sorting to Cassandra

state> that explains this. Thanks, Andy On Wed, Oct 4, 2017 at 1:36 AM Greg Saylor wrote: > Without knowing other details, of course, have you considered using > something like Elassandra? That is a pretty tightly integrated Cassandra + > Elastic Search solution. You’d insert d

Re: Async queries

Future (java 8 futures), although we'll probably provide a guava extension as well for those who still want to use ListenableFuture. Thanks, Andy On Mon, Oct 2, 2017 at 6:44 PM Charulata Sharma (charshar) < chars...@cisco.com> wrote: > Hi , > > > > > > We are ob

Re: Cassandra compatibility matrix

Hi Dmitry, We are currently working on updating our matrices for the drivers, but any version of driver 3.0+ will work with cassandra 3.X. Thanks, Andy On Tue, Sep 12, 2017 at 12:30 PM Dmitry Buzolin wrote: > Thank you Jon. > > Is there way to find what Datastax driver is compat

Re: Limit on number of connections to Cassandra

per host in local data center, although you can tweak this using PoolingOptions <http://docs.datastax.com/en/developer/java-driver/3.3/manual/pooling/#configuring-the-connection-pool> . Thanks, Andy On Fri, Sep 8, 2017 at 1:27 PM techpyaasa . wrote: > Hi > > Is there any limit on

Re: Usage volume of older versions of Cassandra

015 at 10:52 AM Robert Coli wrote: > >> On Tue, Dec 15, 2015 at 6:28 AM, Andy Kruth wrote: >> >>> We are trying to decide how to proceed with development and support of >>> YCSB bindings for older versions of Cassandra, namely Cassandra 7, 8, and >>> 10. &

Usage volume of older versions of Cassandra

We are trying to decide how to proceed with development and support of YCSB bindings for older versions of Cassandra, namely Cassandra 7, 8, and 10. We would like to continue dev and support on these if the use of those versions of Cassandra is still prevalent. If not, then a deprecation cycle may

Partial row read

We're getting strange results when reading from Cassandra 2.0 in php using this driver: http://code.google.com/a/apache-extras.org/p/cassandra-pdo/ Here's the schema: CREATE TABLE events ( day text, last_event text, event_text text, mdn text, PRIMARY KEY ((day), last_event) ) WITH CLU

Re: Restart joining node

You'll want to remove any contents from your data and shared directories and attempt the join from scratch. Though it never completed the bootstrap, make sure your other nodes agree that the node that failed to join is not present in the output of nodetool status. Once started, the node should s

Timeuuid inserted with now(), how to get the value back in Java client?

value Cassandra just generated. Thanks, Andy

CQL and reserved keywords

d as a table/column identifier" or even just "'desc' is a reserved keyword" ? TIA -- Andy

Re: Warning about copying and pasting from datastax configuration page: weird characters in config

I think the issue you're running into is the same reason not to compose a script or config file in notepad. Without using a true text editor (vi), or relying on copy and past, you're very likely to introduce non visible formatting characters, as you see with you paragraph symbols. Trusting code

ClientOptions wiki page update : DataNucleus client

Cassandra. Perhaps someone could update the Wiki with this info. Thanks. Regards -- Andy

Re: Counters question - is there a better way to count

How many distinct uid,someid pairs will you have? On Dec 5, 2013 3:44 PM, "Christopher Wirt" wrote: > I want to build a really simple column family which counts the occurrence > of a single event X. > > > > Once we reach Y occurrences of X the counter resets to 0 > > > > The obvious way to do thi

Cassandra nodetool repair question

g the processes we should look out for? Thanks, -- Andy L

Re: Is there update-in-place on maps?

Counters can be atomically incremented ( http://wiki.apache.org/cassandra/Counters). Pick a UUID for the counter, and use that: c=map.get(k); c.incr() On 6 August 2013 11:01, Jan Algermissen wrote: > > On 06.08.2013, at 11:36, Andy Twigg wrote: > > > Store pointers to counter

Re: Is there update-in-place on maps?

Store pointers to counters as map values?

RE: cassandra 1.2.5- virtual nodes (num_token) pros/cons?

Disadvantage, hadoop support is based on the token range, so maps may equals numtokens per node * nodes number. Best Regards,Andy Hu（胡 珊） Date: Thu, 25 Jul 2013 17:25:11 -0400 Subject: cassandra 1.2.5- virtual nodes (num_token) pros/cons? From: rashmi.aros...@gmail.com To: user

Re: random thoughts for MUCH faster key lookup in cassandra

ill end up with 80% of their data in one CF and 20% > in all the other CF's…isn't pareto's principal a natural tendency and if it > is, maybe the above feature should be considered? > > Later, > Dean > -- Dr Andy Twigg Junior Research Fellow, St Johns College, Oxfo

Secondary Indexes

We need to provide search capability based on a field that is a bitmap combination of 18 possible values. We want to use secondary indexes to improve performance. One possible solution is to create a named column for each value and have a secondary index for each of the 18 columns. Questions we hav

System.log

Cassandra rotates system.log when it reaches 20MB. We see that old logs are kept for over a month. Is Cassandra going to delete or compress these logs when a certain threshold is reached or are we supposed to do it ourselves?

Re: subscribe request

i was hoping for a rick roll. On 14 February 2013 16:55, Eric Evans wrote: > This is new. > > On Thu, Feb 14, 2013 at 9:24 AM, Muntasir Raihan Rahman > wrote: >> >> >> -- >> Best Regards >> Muntasir Raihan Rahman >> Email: muntasir.rai...@gmail.com >> Phone: 1-217-979-9307 >> Department of Compu

Re: JDBC : CreateresultSet fails with null column in CqlResultSet

Aaron, Ticket is at http://code.google.com/a/apache-extras.org/p/cassandra-jdbc/issues/detail?id=61 Andy On 1 Feb 2013, at 18:01, aaron morton wrote: > I think > http://code.google.com/a/apache-extras.org/p/cassandra-jdbc/issues/list is > the place to raise the issue. > >

JDBC : CreateresultSet fails with null column in CqlResultSet

driver so it doesn't create a TypedColumn if the result set produces a null column) Andy The University of Dundee is a Scottish Registered Charity, No. SC015096.

Re: JDBC, Select * Cql2 vs Cql3 problem ?

Hi Edward, I've used Hector for years now myself and know how good it is. I think I've tracked this to a problem in the JDBC driver, I'll post a message and raise a ticket over there. (there is still a possibility that Cassandra 1.2 is sending an incorrect CQLresult set) An

Re: JDBC, Select * Cql2 vs Cql3 problem ?

Well this is getting stranger, for me with this simple table definition, select key,gender from users is also failing with a null pointer exception Andy On 29 Jan 2013, at 13:50, Andy Cobley wrote: > When connecting to Cassandra 1.2.0 from CQLSH the table was created with: > &g

Re: JDBC, Select * Cql2 vs Cql3 problem ?

ncurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:680) Hope that helps ! Andy On 29 Jan 2013, at 07:17, aaron morton wrote:

JDBC, Select * Cql2 vs Cql3 problem ?

blem with my code or something else ? Andy C School of Computing University of Dundee. The University of Dundee is a Scottish Registered Charity, No. SC015096.

Re: CQL3 jdbc and Tomcat resource

Apologies, I was missing a few cassandra jar libs in the tomcat library. Andy On 28 Jan 2013, at 11:31, Andy Cobley wrote: > I tried to add a CQL3 jdbc resource to tomcat 7 in a context.xml file (in a > Eclipse project) as follows: > > name="jdbc/CF1"

CQL3 jdbc and Tomcat resource

to start correctly. Andy Errors are: Jan 28, 2013 11:26:27 AM org.apache.catalina.core.AprLifecycleListener init INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: .:/Library/Java/Extensions:/System

Fwd: British Conference on Databases 2013 - Big Data special.

LNCS series: http://www.springer.com/computer/lncs?SGWID=0-164-6-793341-0 -- Dr Andy Twigg Junior Research Fellow, St Johns College, Oxford Room 351, Department of Computer Science http://www.cs.ox.ac.uk/people/andy.twigg/ andy.tw...@cs.ox.ac.uk | +447799647538 -- Dr Andy Twigg Junior Research

JDBC, Pools and clusters ?

e an equivalent to Hector's getKnownPoolHosts for JDBC ? Many Thanks Andy C The University of Dundee is a Scottish Registered Charity, No. SC015096.

Cassandra vs Couchbase benchmarks

? (for instance is the use of Amazon EC2 sensible for Cassandra deployment) ? Andy The University of Dundee is a Scottish Registered Charity, No. SC015096.

DunDDD NoSQL and Big Data

e've had anyone from the Cassandra community join us and give a talk.If your interested, drop me a line and let me know what your proposing. I should point out, as this is a free conference, we can't pay speakers and unless we get a big sponsor, it's doubtful we can manage much

Re: What is the ideal server-side technology stack to use with Cassandra?

consider adopting the alternative, and that's all I'm trying to get to the bottom of. Believe me, I'd prefer not to learn yet-another-software stack if I can help it! Finally, I do hope that despite my stupidity, Aaron will forgive me and contribute to this discussion. Andy

What is the ideal server-side technology stack to use with Cassandra?

opment and and deployment. What worked for you, and why? What didn't work for you? Thanks, Andy -- Andy Ballingall Senior Software Engineer The Foundry 6th Floor, The Communications Building, 48, Leicester Square, London, WC2H 7LT, UK Tel: +44 (0)20 7968 6828 - Fax:

CQL3: Do boolean values need quoting in inserts?

instigator | started_at | alliance_involvement | energy_used | ships_destroyed +–+———-+-+—– Jayne Cobb | 7943-07-23 00:00:00+ | False | 4.6 | 2 I was using cqlsh -3 ( cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0) Is this a bug, or must we quote boolea

Re: How to create a COLUMNFAMILY with Leveled Compaction?

clared as follows: CREATE KEYSPACE testkeyspace WITH strategy_class = 'NetworkTopologyStrategy' AND strategy_options:dc1=3; I'd definitely like to use this new compaction type. Help! Andy > > > -Z > > On Tue, Jul 31, 2012 at 11:17 AM, Data Craftsman 木匠 > wrote: >

Re: SnappyCompressor and Cassandra 1.1.1

Yes, I've a number of (badly written I admit) blog posts at: http://ac31004.blogspot.co.uk/ Andy From: aaron morton Reply-To: Date: Wednesday, 4 July 2012 10:03 To: Subject: Re: SnappyCompressor and Cassandra 1.1.1 Andy, >>> I'm running Cassandra on Raspberry

Re: SnappyCompressor and Cassandra 1.1.1

I've tested this and added a not to issue 4400. Hopefully that¹s the correct thing to do. Andy On 02/07/2012 08:13, "Sylvain Lebresne" wrote: >Yeah, we tried to catch when Snappy couldn't load (and deactivate it >when that happens) but apparently we've missed a

Re: SnappyCompressor and Cassandra 1.1.1

Thanks , Will give it a go now. Andy On 02/07/2012 08:13, "Sylvain Lebresne" wrote: >Yeah, we tried to catch when Snappy couldn't load (and deactivate it >when that happens) but apparently we've missed a few of the exceptions >that can be thrown in t

SnappyCompressor and Cassandra 1.1.1

tered during startup: [FAILED_TO_LOAD_NATIVE_LIBRARY] null Andy The University of Dundee is a Scottish Registered Charity, No. SC015096.

Re: BulkLoading SSTables and compression

My (limited) experience of moving form 0.8 to 1.0 is that you do have to use rebuildsstables. I'm guessing BlukLoading is bypassing the compression ? Andy On 28 Jun 2012, at 10:53, jmodha wrote: > Hi, > > We are migrating our Cassandra cluster from v1.0.3 to v1.1.1, the data

Re: Runtime exception

Hi Jonathan, We're using thrift interface with C++. Andy On Tue, Oct 25, 2011 at 12:47 PM, Jonathan Ellis wrote: > Are you using the StorageProxy API directly? > > On Tue, Oct 25, 2011 at 12:39 PM, Andy Stec wrote: > > We're using version 1.0. The following excepti

Re: frequent client exceptions on 0.7.0

ecause IO on these machines is fairly limited in performance. Does this sound like the node is overloaded? Andy

Re: frequent client exceptions on 0.7.0

r, so while not the most solid of network environments, at least pretty common these days. System is not going down, and cassandra process is not dying. Andy

frequent client exceptions on 0.7.0

/transport/TTransport.py", line 276, in readFrame buff = self.__trans.readAll(4) File "/usr/local/lib/python2.6/dist-packages/Thrift-0.5.0-py2.6-linux-i686.egg/thrift/transport/TTransport.py", line 58, in readAll chunk = self.read(sz-have) File "/usr/local/lib/python2.6/dist-packages/Thrift-0.5.0-py2.6-linux-i686.egg/thrift/transport/TSocket.py", line 94, in read buff = self.handle.recv(sz) error: [Errno 104] Connection reset by peer Thanks in advance for any insight, Andy

Re: Schema Question

do mean specifically column families and not column family keys, then I don't even understand how you would go about creating those on-the-fly anyway. Don't they have to be pre-configured in storage-conf.xml? Thanks, Andy. On 25/01/11 00:39, Aaron Morton wr

Re: Question re: the use of multiple ColumnFamilies

riter (the maximum queue size turns out to be equal to the number of DataFileDirectories). I haven't done so yet, but I intend to patch locally to allow direct configuration of the queue size rather than relying on this side effect. Regards, Andy. On 22/01/11 00:29, Peter Schuller wrote: &q

Re: Time-to-live on SuperColumns

compacted (SSTABLE-CLEANUP-TIMER thread)? These could potentially take up a lot of disk space, and are surely no longer being used. What triggers Cassandra to perform these deletions, and can I do it manually? Thanks, Andy. On 19/01/11 11:36, Andy Burgess wro

Time-to-live on SuperColumns

rned, it only appears to reduce sstable size by about three quarters. This is in the case where I know that the sstable contains only my test inserts, which I have completely deleted. Why doesn't the sstable reduce in size to (almost) nothing? Thanks, Andy. -- Andy Burgess Principal Deve

Re: Question re: the use of multiple ColumnFamilies

oblems when you do non-rate-limited writes to the cluster, results are probably negative. I'll file a bug about this to (1) elicit feedback if I'm wrong, and (2) to fix it. -- Andy Burgess Principal Development Engineer Application Delivery WorldPay Ltd. 270-289 Science Park, Milto

Question re: the use of multiple ColumnFamilies

t accept new inserts until this has happened, which leads to time-outs for both reads and writes. Can anyone confirm whether or not this behaviour is expected, and suggest anything that I could do about it? This is on 0.6.6, by the way. Patched with time-to-live code, if that makes a diffe

Re: Clustering in .7 beta 2

Juts in case in (This got me upgrading). What are: thrift_framed_transport_size_in_mb: 15 thrift_max_message_length_in_mb: 16 Set to ? I've seen thrift_framed_transport_size_in_mb set to 0 after an upgrade which will cause faults. Andy On 12 Oct 2010, at 16:40, Brayton Thompson

Moving from 0.7.0-beta1 to nightly build

onfig 6: Change RackUnawareStrategy to SimpleStrategy in cassandra.yaml 7: start Cassandra However I am still getting RackUnawareStrategy exceptions (output below). Any ideas on the proper procedure ? Ta Andy Using adaptive heap size: 1002M INFO 09:12:15,962 JNA not found. Native methods w

Re: Bootstrapper assertion failure

On Fri, Jul 2, 2010 at 1:22 PM, Rob Coli wrote: > On 7/2/10 1:05 PM, Andy Skalet wrote: >> >> Interestingly, if I run with no initialtoken specified, I get a "No >> other nodes seen!" exception from the BootStrapper.  Full debug log >> (minus rowmutati

Re: Bootstrapper assertion failure

Interestingly, if I run with no initialtoken specified, I get a "No other nodes seen!" exception from the BootStrapper. Full debug log (minus rowmutations) here: https://gist.github.com/df122c109bb9332cd85c Thanks, Andy On Fri, Jul 2, 2010 at 1:23 AM, Andy Skalet wrote: > Hello,

Bootstrapper assertion failure

oken. I have no idea why this isn't happening in my case, however. Thanks in advance for any ideas, Andy Skalet