Re: Getting errors while starting DataStax Cassandra enterprise service

2015-01-23 Thread Andrew
. Andrew On January 23, 2015 at 7:30:15 PM, Jacob Rhoden (jacob.rho...@me.com) wrote: What does this show? ls $JAVA_HOME __ Sent from iPhone > On 24 Jan 2015, at 2:18 pm, anujacharya11 . > wrote: > > I had installed DataStax Enterprise Cas

Re: run cassandra on a small instance

2015-02-18 Thread Andrew
approach versions... Andrew On February 18, 2015 at 5:16:27 PM, Robert Coli (rc...@eventbrite.com) wrote: On Wed, Feb 18, 2015 at 5:09 PM, Tim Dunphy wrote: I'm attempting to run Cassandra 2.1.2 on a smallish 2.GB ram instance over at Digital Ocean. It's a CentOS 7 host. 2.1.2 is IMO

Re: Migrate from Hector(unmaintained) to Astyanax for Cassandra 2.0.7, (delaying thrift to CQL migration plan) ?

2014-05-28 Thread Andrew
Datastax Cassandra driver.  I’m not sure what the perceived benefits of Thrift over the binary interface are, other than people being familiar with one over another. Andrew On May 28, 2014 at 7:19:52 AM, user 01 (user...@gmail.com) wrote: Currently I am using Hector which is no longer maintained by

Re: Backup Cassandra to

2014-06-12 Thread Andrew
! Andrew On June 12, 2014 at 6:18:57 AM, Jack Krupansky (j...@basetechnology.com) wrote: The doc for backing up – and restoring – Cassandra is here: http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/ops_backup_restore_c.html   That doesn’t tell you how to move the “snapshot” to

Re: Size-tiered Compaction runs out of memory

2014-07-09 Thread Andrew
expired TTLs. Thanks, Andrew On Mon, Jul 7, 2014 at 3:45 PM, Robert Coli wrote: On Mon, Jul 7, 2014 at 9:52 AM, Redmumba wrote: Would adjusting the maximum sstables before a compaction is performed help this situation?  I am currently using the default values provided by

Re: All writes fail with ONE consistency level when adding second node to cluster?

2014-07-22 Thread Andrew
ONE means write to one replica (in addition to the original).  If you want to write to any of them, use ANY.  Is that the right understanding? http://www.datastax.com/docs/1.0/dml/data_consistency Andrew On July 22, 2014 at 7:43:43 PM, Kevin Burton (bur...@spinn3r.com) wrote: I'm

Re: All writes fail with ONE consistency level when adding second node to cluster?

2014-07-22 Thread Andrew
I looked into this; ONE means it must be written to one replica—i.e., a node the data is supposed to be written to.  ANY means a hinted handoff will “count”.  So as long as it writes to any node on the cluster—even one that it’s not supposed to be on—it will be a success.  Good to know. Andrew

Re: too many open files

2014-08-09 Thread Andrew
connection itself, maxing out at 128 local/remote.  I’m not sure if a Session results in a new file handle on the server side, but I saw the same issue (hundreds of thousands of sockets opened on the server). The cluster was also using hsha; most of the other settings were default in 2.0.7. Andrew

Re: too many open files

2014-08-09 Thread Andrew
logic; I had a restriction of about 128 connections per host, but the connections were in the 100s of thousands, like the OP mentioned.  Again, I’ll see about reproducing it on Monday, but just wanted the repro steps (overall) to live somewhere in case I can’t. :) Andrew On August 8, 2014 at 4

Re: too many open files

2014-08-09 Thread Andrew
significantly large number of connections until the Cassandra server ran out of connections.  Tyler was asking for a repro case and requesting that I file a possible bug, if this was something that SHOULD have been caught on the client side (via the max connections client configuration). Andrew On

unsubscribe

2010-10-26 Thread Andrew
unsubscribe

Is this SSTable restore merging scenario possible ?

2018-03-21 Thread Andrew Voumard
Hi All, I am using Cassandra 3.10 I would like to know if the following SSTable row level merging scenario is possible: 1. On a Production Cluster - Take a full snapshot on every node 2. On a new, empty Secondary Cluster with the same topology - Create a matching schema (keyspaces + tables as

Re: GUI clients for Cassandra

2018-04-22 Thread Andrew Baker
https://zeppelin.apache.org/ is pretty nice, not a fully fledge Cassandra GUI, but worth a look. Plus it can be used for all sorts of other things. On Sun, Apr 22, 2018 at 8:59 AM Hannu Kröger wrote: > Hello everyone! > > I have been asked many times that what is a good GUI client for Cassandra

Re:

2018-09-05 Thread Andrew Baker
videos too as I recall. -Andrew On Wed, Sep 5, 2018 at 6:19 AM sha p wrote: > Hi all , > Me new to Cassandra , i was asked to migrate data from Oracle to Cassandra. > Please help me giving your valuable guidance. > 1) Can it be done using open source Cassandra. > 2) Where should I s

Re: How to define blob column in Java?

2016-09-11 Thread Andrew Tolbert
Hi Alexandr, I am assuming you are referring to the @Table annotation in the mapping module in the Datastax Java Driver for Apache Cassandra (please correct me if I am wrong). You can achieve this with any of these three types using a custom codec

Re: Re : Generic keystore when enabling SSL

2016-09-20 Thread Andrew Tolbert
e're using 3rd party signed certificates, and want to avoid > the hassle of managing 100's of certificates. > > thanks > Sai > -- [image: DataStaxLogo copy3.png] <http://www.datastax.com/> Andrew Tolbert Software Engineer in Test | (612)-222-6271 | andrew.tolb...@datast

Re: Running Cassandra in Integration Tests

2016-10-06 Thread Andrew Tolbert
Hi Ali, cassandra-unit might be what you are looking for. It allows you to run an embedded cassandra instance along side your tests and has some nice integration with JUnit. Thanks, Andy On Thu, Oct 6, 2016 at 7:13 PM Ali Akhtar wrote: > Ok, but t

Re: NamingStrategy for the Java Driver for camelCase / snake_case conversion?

2016-10-10 Thread Andrew Tolbert
Hi Ali, As far as I know this hasn't changed. Either the field name on the class has to match the name of the column or you have to use the @Column with the name attribute to set the column name being mapped by that field. Thanks, Andy On Mon, Oct 10, 2016 at 8:03 PM Ali Akhtar wrote: > In wo

Re: NamingStrategy for the Java Driver for camelCase / snake_case conversion?

2016-10-10 Thread Andrew Tolbert
2016 at 10:30 PM Ali Akhtar wrote: > Please fix this. > > > > On Tue, Oct 11, 2016 at 8:28 AM, Andrew Tolbert < > andrew.tolb...@datastax.com> wrote: > > Hi Ali, > > As far as I know this hasn't changed. Either the field name on the class > has to matc

Re: Being asked to use frozen for UDT in 3.9

2016-10-10 Thread Andrew Tolbert
Is the column you are using that has the UDT type is the or is part of the primary key? If that is the case it still needs to be frozen (the same goes for list, set, tuple as part of primary key). This is the error I get when I try that: InvalidRequest: Error from server: code=2200 [Invalid quer

Re: Being asked to use frozen for UDT in 3.9

2016-10-10 Thread Andrew Tolbert
(not primary or > cluster key) as being of that type, but it doesn't let me do that unless i > set it as frozen. Docs indicate otherwise though > > On Tue, Oct 11, 2016 at 9:09 AM, Andrew Tolbert < > andrew.tolb...@datastax.com> wrote: > > Is the column you are using tha

Re: NamingStrategy for the Java Driver for camelCase / snake_case conversion?

2016-10-10 Thread Andrew Tolbert
create a pojo for the UDT, and use > @Column on the fields, and it will work if I define a field in the table > mapping class as being of that pojo type? > > On Tue, Oct 11, 2016 at 8:57 AM, Andrew Tolbert < > andrew.tolb...@datastax.com> wrote: > > I agree this would be

Re: Being asked to use frozen for UDT in 3.9

2016-10-10 Thread Andrew Tolbert
test, > PRIMARY KEY (id) > ); > > On Tue, Oct 11, 2016 at 9:23 AM, Andrew Tolbert < > andrew.tolb...@datastax.com> wrote: > > Can you please share an example where it doesn't work? > > Thanks, > Andy > > On Mon, Oct 10, 2016 at 11:21 PM Ali Akhtar wrote: >

Re: Being asked to use frozen for UDT in 3.9

2016-10-10 Thread Andrew Tolbert
t; CREATE TABLE test.test_table ( > id text PRIMARY KEY, > this_doesnt_work test > ) WITH bloom_filter_fp_chance = 0.01 > > > On Mon, Oct 10, 2016 at 9:25 PM Ali Akhtar wrote: > >> CREATE TYPE test ( >> foo text, >> bar text >> ); >>

Re: Inserting list data

2016-10-13 Thread Andrew Baker
I saw evidence of this behavior, but when we created a test to try to make it happen it never did, we assumed it was UDT related and lost interest, since it didn't have a big impact. I will try to carve some time to look into this some more and let you know if I find anything. On Wed, Oct 12, 2016

metrics not resetting after running proxyhistograms or cfhistograms

2016-10-25 Thread Andrew Bialecki
We're running 3.6. Running "nodetool proxyhistograms" twice, we're seeing the same data returned each time, but expecting the second run to be reset. We're seeing the same behavior with "nodetool cfhistograms." I believe resetting after each call used to be the behavior, did that change in recent

Re: Deadlock in callbacks to async operations (Java)

2016-11-12 Thread Andrew Tolbert
> > Will the above example work if instead of session.execute, it was doing > session.executeAsync()? > It will work as executeAsync will not block waiting on behavior in a I/O thread (that may also happen to be the calling thread), so it is not susceptible to deadlock. To be extra safe, you coul

Re: Consistency when adding data to collections concurrently?

2016-11-12 Thread Andrew Tolbert
You can do it in a SimpleStatement assuming you provide the CQL exactly as you provided, but in a PreparedStatement it will not work because cql prohibits provide bind values in collection literals. For it to work you could provide a List of UDT values in a bound prepared statement, i.e.: Use

Re: Consistency when adding data to collections concurrently?

2016-11-12 Thread Andrew Tolbert
Ali Akhtar wrote: > > Andrew, > > I was thinking about setting up an accessor with that query and a bound > variable ? which binds to the instance being added, e.g: > > @Query("UPDATE my_table SET labels = labels + ? WHERE id = ?") > void addLabel(Label label, String i

cassandra python driver routing requests to one node?

2016-11-13 Thread Andrew Bialecki
We have an odd situation where all of a sudden of our cluster started seeing a disproportionate number of writes go to one node. We're using the Python driver version 3.7.1. I'm not sure if this is a driver issue or possibly a network issue causing requests to get routed in an odd way. It's not abs

Re: cassandra python driver routing requests to one node?

2016-11-13 Thread Andrew Bialecki
ight logging set to debug. On Mon, Nov 14, 2016 at 12:39 AM, Ben Slater wrote: > What load balancing policies are you using in your client code ( > https://datastax.github.io/python-driver/api/cassandra/policies.html)? > > Cheers > Ben > > On Mon, 14 Nov 2016 at 16:22 Andr

Re: cassandra python driver routing requests to one node?

2016-11-14 Thread Andrew Bialecki
at 6:26 PM, Alex Popescu wrote: > I'm wondering if what you are seeing is https://datastax-oss. > atlassian.net/browse/PYTHON-643 (that could still be a sign of a > potential data hotspot) > > On Sun, Nov 13, 2016 at 10:57 PM, Andrew Bialecki < > andrew.biale...@klaviyo.com&g

Cluster nodes not catching up on total hints

2016-11-22 Thread Andrew Kenney
We’re seeing a strange issue on our Cassandra cluster wherein 3 nodes out of 21 appear to have a significant amount of hints piling up. We’re not seeing a lot in the system log showing that the node is having issues with hints and nodetool status is not showing any issues with the other nodes in

Row and column level tombstones

2016-11-23 Thread Andrew Cooper
taken into consideration on the read path and all columns with timestamp less than key tombstone are ignored in the response. I have not dug into the codebase yet. If anyone can shed light on this question from their own experiences that would be helpful. Thanks, -Andrew

Re: Inserting list data

2016-11-30 Thread Andrew Baker
o the test and let you know. -Andrew On Fri, Oct 14, 2016 at 11:00 PM Russell Spitzer wrote: > Are you sure you aren't using batches? These will assign the same > timestamp to your inserts which can lead to unexpected behaviors. > > On Fri, Oct 14, 2016 at 9:45 PM Vladimir Yud

Re: Authentication with Java driver

2017-02-07 Thread Andrew Tolbert
Hello, The API seems kind of not correct because credentials should be > usually set with a session but actually they are set with a cluster. > With the datastax driver, Session is what manages connection pools to each node. Cluster manages configuration and a separate connection ('control conne

Non-zero nodes are marked as down after restarting cassandra process

2017-03-01 Thread Andrew Jorgensen
before and is there anything I can do to fix/reduce the impact of running a restart on a cassandra node? Thanks, Andrew Jorgensen @ajorgensen

Re: Does Java driver v3.1.x degrade cluster connect/close performance?

2017-03-06 Thread Andrew Tolbert
Hi Satoshi, This question would be better for the 'DataStax Java Driver for Apache Cassandra mailing list ', but I do have a few thoughts about what you are observing: Between java-driver 2.1 and 3.0 the driver updat

Re: Does Java driver v3.1.x degrade cluster connect/close performance?

2017-03-06 Thread Andrew Tolbert
99.9% <= 8.03 milliseconds Similary when using a local C* node, initialization times are pretty similar. I'd be interested to see if running the same test <https://gist.github.com/tolbertam/e6ac8b71a7703a6fc4561356767a1501> in your environment creates different results. T

Re: Does Java driver v3.1.x degrade cluster connect/close performance?

2017-03-07 Thread Andrew Tolbert
hange made for JAVA-914 <https://datastax-oss.atlassian.net/browse/JAVA-914> which was introduced in 2.1.9 and 3.0.x, not the netty 3.9 to 4.0 version change which I was incorrect about as that change was made earlier (at driver 2.1.6). Thanks, Andy On Mon, Mar 6, 2017 at 11:11 PM, Satoshi Hikida wro

Re: Maximum Row Limit

2015-08-24 Thread Andrew Tolbert
Hello Mangeet, According to CassandraLimitations the maximum cells per Partition key is 2 billion: > >- The maximum number of cells (rows x columns) in a single partition >is 2 billion. > > Therefore the maximum number of rows per

Guava version check in 3.0

2016-02-11 Thread Andrew Jorgensen
older versions of Guava or would it be possible to turn off the sanity check? Thanks, -- Andrew Jorgensen @ajorgensen

Re: Guava version check in 3.0

2016-02-11 Thread Andrew Jorgensen
${main.class} -- Andrew Jorgensen @ajorgensen On Thu, Feb 11, 2016, at 03:40 PM, Andrew Jorgensen wrote: > He

unsubscribe

2012-07-30 Thread Andrew Knox
unsubscribe

Simulating a failed node

2012-10-27 Thread Andrew Bialecki
writes failing even after a retry? It might be the stress client doesn't pool connections (I took a quick look, but might've not looked deeply enough), however I also tried only specifying the first two server nodes and then downing the third with the same failure. Thanks in advance. Andrew

Re: Simulating a failed node

2012-10-27 Thread Andrew Bialecki
RF and CL are you using? > > > On 2012/10/28, at 13:13, Andrew Bialecki > wrote: > > Hey everyone, > > I'm trying to simulate what happens when a node goes down to make sure my > cluster can gracefully handle node failures. For my setup I have a 3 node > cluster runni

Re: Simulating a failed node

2012-10-29 Thread Andrew Bialecki
Thanks, extremely helpful. The key bit was I wasn't flushing the old Keyspace before re-running the stress test, so I was stuck at RF = 1 from a previous run despite passing RF = 2 to the stress tool. On Sun, Oct 28, 2012 at 2:49 AM, Peter Schuller wrote: > > Operation [158320] retried 10 times

Running Cassandra 1.1, how can I see the efficiency of the key cache?

2012-12-22 Thread Andrew Bialecki
nged the defaults there, so the key cache setting in cassandra.yaml is still blank. Thanks for any help and happy holidays, Andrew

Need to run nodetool repair on a cluster running 1.1.6 if no deletes

2012-12-22 Thread Andrew Bialecki
letes? Anything drawbacks to not running it? Thanks, Andrew

Re: Running Cassandra 1.1, how can I see the efficiency of the key cache?

2012-12-22 Thread Andrew Bialecki
Thanks, I'll take a look at that too. I also found that "nodetool info" gives some information as well. For instance, here's what one node reads: Key Cache: size 104857584 (bytes), capacity 104857584 (bytes), 15085408 hits, 17336031 requests, 0.870 recent hit rate, 14400 save period in seconds.

Cassandra as a service on Windows

2013-02-14 Thread Andrew Cobley
Hi all,\ According to http://www.datastax.com/dev/blog/whats-new-in-cassandra-1-0-windows-service-new-cql-clients-and-more running cassandra.bat install should make cassandra run on a service on a windows box. However I'm getting the following when I try: C:\apache-cassandra-1.2.1\bin>cassandr

Re: Non-zero nodes are marked as down after restarting cassandra process

2017-05-16 Thread Andrew Jorgensen
actful fix was from the usage side. As far as I can tell there are no dropped messages, there are some pending Compactions and a few Native-Transport_Request in the all time blocked column. Thanks! Andrew Jorgensen @ajorgensen On Wed, Mar 1, 2017 at 12:58 PM, benjamin roth wrote: > You

InternalResponseStage low on some nodes

2017-05-23 Thread Andrew Jorgensen
numbers seems reasonable for a idle cluster? Thanks! Andrew Jorgensen @ajorgensen

Hinted handoff throttled even after "nodetool sethintedhandoffthrottlekb 0"

2017-10-26 Thread Andrew Bialecki
throughput? Or other reasons why hinted handoff runs so slowly? -- Andrew Bialecki

Re: Hinted handoff throttled even after "nodetool sethintedhandoffthrottlekb 0"

2017-10-27 Thread Andrew Bialecki
oad or something related to a timeout setting? On Fri, Oct 27, 2017 at 1:49 AM, Andrew Bialecki < andrew.biale...@klaviyo.com> wrote: > We have a 96 node cluster running 3.11 with 256 vnodes each. We're running > a rolling restart. As we restart nodes, we notice that each node t

CDC usability and future development

2018-01-30 Thread Andrew Prudhomme
Hi all, We are currently designing a system that allows our Cassandra clusters to produce a stream of data updates. Naturally, we have been evaluating if CDC can aid in this endeavor. We have found several challenges in using CDC for this purpose. CDC provides only the mutation as opposed to the

DevCenter and Cassandra 2.1

2014-09-26 Thread Andrew Cobley
Hi all, I notice that descanter 1.1.1doesn’t support User defined types (as far as I can see). Is it just a matter of importing a template or will we need to wait for full 2.1 support in descanter ? Andy The University of Dundee is a registered Scottish Charity, No: SC015096

DSE install interfering with apache Cassandra 2.1.0

2014-09-29 Thread Andrew Cobley
Hi All, Just come across this one, I’m at a bit of a loss on how to fix it. A user here did the following steps On a MAC Install Datastax Enterprise (DSE) using the dmg file test he can connect using the DSE cqlsh window Unistall DSE (full uninstall which stops the services) download apache cas

Re: DSE install interfering with apache Cassandra 2.1.0

2014-09-29 Thread Andrew Cobley
...@gmail.com>> wrote: Please run jps to check which Java services are still running and to make sure if c* is running. Then please check if 9160 port is in use. netstat -nltp | grep 9160 This will confirm what is happening in your case. Sent from my iPhone On 29-Sep-2014, at 7:15 pm, Andrew

Re: using dynamic cell names in CQL 3

2014-09-29 Thread Andrew Cobley
Isn’t the correct way to do this in CQL3 to use sets and user defined types (in C* 2.1) ?: create type sensorreading( date timestamp, name text, value int); CREATE TABLE sensordata ( name text, data set>, PRIMARY KEY (name) ); insert into keyspace2.sensordata (name, data) values ('1234', {{date:

Re: Saving file content to ByteBuffer and to column does not retrieve the same size of data

2014-09-30 Thread Andrew Cobley
I too have saved images in blobs (in development environment admittedly) . Sample code can be seen here: https://github.com/acobley/instagrim/blob/master/src/main/java/uk/ac/dundee/computing/aec/instagrim/models/PicModel.java Note this code uses the org.imgscalr.Scalr to resize and process ima

Re: DSE install interfering with apache Cassandra 2.1.0

2014-09-30 Thread Andrew Cobley
2014 01:25, Andrew Cobley mailto:a.e.cob...@dundee.ac.uk>> wrote: Without the apache cassandra running I ran jps -l on this machine ,the only result was 338 sun.tool.jps.Jps The Mac didn’t like the netstat command so I ran netstat -atp tcp | grep 9160 no result Also for the native port:

Cross-datacenter requests taking a very long time.

2015-03-31 Thread Andrew Vant
irely sure what direction to look in to find the problem. -- Andrew

Re: COMMERCIAL:Re: Cross-datacenter requests taking a very long time.

2015-04-02 Thread Andrew Vant
c. I'll try that. I should add that one of the other teams here has a similar setup (3 nodes in 3 DCs) that is working correctly. We're going to go through the config files and see if we can figure out what's different. -- Andrew

Large system.Migration CF after upgrade to 1.1

2013-11-22 Thread Andrew Cooper
e any advice and I can provide more details if needed. -Andrew Andrew Cooper National Information Solutions Cooperative® 3201 Nygren Drive NW Mandan, ND 58554 * e-mail: andrew.coo...@nisc.coop<mailto:andrew.coo...@nisc.coop> * phone: 866.999.6472 ext 6824 * direct: 701-667-6824

Re: Large system.Migration CF after upgrade to 1.1

2013-11-27 Thread Andrew Cooper
dy running at 1.2, but this is our largest and most problematic cluster :) -Andrew Hope that helps. - Aaron Morton New Zealand @aaronmorton Co-Founder & Principal Consultant Apache Cassandra Consulting http://www.thelastpickle.com<http://www.thelastpickle.com/> On

Migrate data to new cluster using datacenters?

2013-12-12 Thread Andrew Cooper
I am aware of other tools available including sstableloader, etc, but this seemed like a more elegant solution, leveraging cassandra's active-active features. Thanks, -Andrew NISC

nodetool removenode hangs - for everyone?

2014-01-24 Thread Andrew Losey
The problem described in ticket 6542, https://issues.apache.org/jira/browse/CASSANDRA-6542, has been observed in my environment. This isn't a new problem, as it's been seen across several differently sized, vnode enabled, clusters for much longer than the age of the ticket. The problem has defi

CQL list command

2014-02-06 Thread Andrew Cobley
TL;DR Is there a CQL equivalent of the CLI List command ? yes or No? Long version I often use the CLI command LIST for debugging or when teaching students showing them what’s going on under the hood of CQL. I see that CLI swill be removed in Cassandra 3 and we will lose this ability. It wou

CQL get unique row keys ?

2014-02-15 Thread Andrew Cobley
I may be missing something here, but is there a way in cql to get all unique row keys in a column family(table) ? I’ve created a table like this: CREATE TABLE totp ( artist varchar, track varchar, appearance_type varchar, PRIMARY KEY ((artist),track) ) WITH CLUSTERING ORDER BY (track asc); an

RE: CQL get unique row keys ?

2014-02-15 Thread Andrew Cobley
: SELECT DISTINCT pk FROM More info on the feature here: https://issues.apache.org/jira/browse/CASSANDRA-4536 This query is quite efficient because the key cache is used most of the time. Regards Duy Hai DOAN On Sat, Feb 15, 2014 at 6:05 PM, Andrew Cobley mailto:a.e.cob...@dundee.ac.uk

CQLException ?

2014-02-24 Thread Andrew Cobley
I’m just converting some code from SQL to CQL. The code can throw a SQLException. however I note that there is no equivalent in CQL, I’m just wondering whys this is the case ? Regards Andy The University of Dundee is a registered Scottish Charity, No: SC015096

Issue retrieving blobs with CQL

2014-03-19 Thread Andrew Cobley
Cassandra 2.0.4 I’m using blobs to save and retrieve images in cassanda. However the blob I get back is not the blob I saved ! I’m saving to CQL like this: byte[] b= {(byte)10,(byte)20,(byte)30}; int length=b.length; ByteBuffer buffer =ByteBuffer.wrap(b); Session session = cluster.connect("k

Re: Issue retrieving blobs with CQL

2014-03-19 Thread Andrew Cobley
Apologies, this seems to be addressed in the thread : https://groups.google.com/a/lists.datastax.com/forum/#!searchin/java-driver-user/blob$20ByteBuffer/java-driver-user/4_KegVX0teo/2OOZ8YOwtBcJ Andy On 19 Mar 2014, at 11:55, Andrew Cobley mailto:a.e.cob...@dundee.ac.uk>> wrote: Cas

Primary index component is missing for sstable

2014-03-27 Thread Andrew Bruno
ead.java:744) INFO SSTableBatchOpen:3<https://synetek.atlassian.net/wiki/display/SSTableBatchOpen/3> 2014-03-23 14:26:38,314 SSTableReader.java (line 192) Opening e:\data\cassandra\reports\fr\le-financial_reports.storeCustomField28Id_idx-e-9120 (2202 bytes) Cheers Andrew

InvalidRequestException(why:Duplicate index

2014-03-27 Thread Andrew Bruno
org.apache.cassandra.thrift.Cassandra$Client.system_update_column_family(Cassandra.java:1325) at me.prettyprint.cassandra.service.ThriftCluster$5.execute(ThriftCluster.java:130) ... 14 more Regards Andrew

Can a column index be renamed in Cassandra 1.2.13

2014-04-06 Thread Andrew Bruno
(617265614d616e616765724964) Validation Class: org.apache.cassandra.db.marshal.BytesType Index Name: areaManagerId_idx Index Type: KEYS Does anyone know if there is a way around this? How can I rename the "areaManagerId_idx" index for a particular column family? Regards Andrew

Stalled streams during repairs

2014-04-16 Thread Andrew Cooper
39393765 Responses n/a 0 21929307 I would appreciate any feedback or advice on this. thanks, -Andrew andrew.coo...@nisc.coop<mailto:andrew.coo...@nisc.coop>

RE: Stalled streams during repairs

2014-04-16 Thread Andrew Cooper
etcassandra.org/blog/post/bulk-loading-options-for-cassandra/ -Andrew

Re: Nodetool drain automatically shutting down node?

2013-03-08 Thread Andrew Bialecki
forceFlush requested but everything is clean in Standard1 INFO [RMI TCP Connection(2)-10.116.111.143] 2013-03-09 03:54:33,510 StorageService.java (line 774) DRAINED On Fri, Mar 8, 2013 at 10:36 PM, Andrew Bialecki wrote: > Hey all, > > We're getting ready to upgrade our cluster to 1.

Re: How to configure linux service for Cassandra

2013-03-19 Thread Andrew Cobley
Does this help you ? https://github.com/acobley/CassandraStartup it was built for Raspbian, but might help you. Andy On 19 Mar 2013, at 11:10, Roshan mailto:codeva...@gmail.com>> wrote: Hi I want to start the cassandra as a service. At the moment it is starting as a background task. Cassand

Bootstrapping a node in 1.2.2

2013-03-19 Thread Andrew Bialecki
I've got a 3 node cluster in 1.2.2 and just bootstrapped a new node into it. For each of the existing nodes, I had num tokens set to 256 and for the new node I also had it set to 256, however after bootstrapping into the cluster, "nodetool status " for my main keyspace which has RF=2 now reports:

Observation on shuffling vs adding/removing nodes

2013-03-23 Thread Andrew Bialecki
ng and shutting down nodes extremely easy. Cheers, Andrew

Re: Observation on shuffling vs adding/removing nodes

2013-03-24 Thread Andrew Bialecki
- > Aaron Morton > Freelance Cassandra Consultant > New Zealand > > @aaronmorton > http://www.thelastpickle.com > > On 24/03/2013, at 9:41 AM, Andrew Bialecki > wrote: > > Just curious if anyone has any thoughts on something we've observed in a

Does replicate_on_write=true imply that CL.QUORUM for reads is unnecessary?

2013-05-29 Thread Andrew Bialecki
Quick question about counter columns. In looking at the replicate_on_write setting, assuming you go with the default of "true", my understanding is it writes the increment to all replicas on any increment. If that's the case, doesn't that mean there's no point in using CL.QUORUM for reads because

Re: Does replicate_on_write=true imply that CL.QUORUM for reads is unnecessary?

2013-05-29 Thread Andrew Bialecki
ess of what you actually set it to (and for good reason). On Wed, May 29, 2013 at 9:47 AM, Andrew Bialecki wrote: > Quick question about counter columns. In looking at the replicate_on_write > setting, assuming you go with the default of "true", my understanding is it > writes th

Re: Does replicate_on_write=true imply that CL.QUORUM for reads is unnecessary?

2013-06-02 Thread Andrew Bialecki
e on write should normally always be turned on, or the change >> will only be recorded on one node. Replicate on write is asynchronous >> with respect to the request and doesn't affect consistency level at >> all. >> >> >> On Wed, May 29, 2013 at 7:32 P

Updated sstable size for LCS, ran upgradesstables, file sizes didn't change

2013-06-21 Thread Andrew Bialecki
ance with varying sstable sizes. Thanks in advance! Andrew

Re: Counter value becomes incorrect after several dozen reads & writes

2013-06-25 Thread Andrew Bialecki
f the behavior can be duplicated. Andrew On Tue, Jun 25, 2013 at 2:18 PM, Robert Coli wrote: > On Mon, Jun 24, 2013 at 6:42 PM, Josh Dzielak wrote: > > There is only 1 thread running this sequence, and consistency levels are > set > > to ALL. The behavior is fairly repeatable - the

Re: How to do a CAS UPDATE on single column CF?

2013-07-01 Thread Andrew Cobley
According to Jonathan Ellis talk at Cassandra 13 it does use Paxos: http://www.youtube.com/watch?v=PcUpPR4nSr4&list=PLqcm6qE9lgKJzVvwHprow9h7KMpb5hcUU http://www.slideshare.net/jbellis/cassandra-summit-2013-keynote Andy On 1 Jul 2013, at 19:40, Francisco Andrades Grassi mailto:bigjoc...@gmail.

Lots of replicate on write tasks pending, want to investigate

2013-07-03 Thread Andrew Bialecki
2. I'm assuming in our case the cause is incrementing counters because disk reads are part of the write path for counters and are not for appending columns to a row. Does that logic make sense? Thanks in advance, Andrew

Re: Lots of replicate on write tasks pending, want to investigate

2013-07-03 Thread Andrew Bialecki
(not replicate on write) for counters involves a read, so that explains the high disk I/O, but for that I'd expect to see many write requests pending (which we see a bit), but not replicate on writes backing up. What am I missing? Andrew On Wed, Jul 3, 2013 at 1:03 PM, Robert Coli wrote:

Re: node tool ring displays 33.33% owns on 3 node cluster with replication

2013-07-12 Thread Andrew Bialecki
nclude the keyspace as part of your query, you'll get it weighted by the RF of that keyspace. I believe the same logic applies for nodetool status. Andrew On Thu, Jul 11, 2013 at 12:58 PM, Jason Tyler wrote: > Thanks Rob! I was able to confirm with getendpoints. > > Cheers

Re: Deletion use more space.

2013-07-16 Thread Andrew Bialecki
I don't think setting gc_grace_seconds to an hour is going to do what you'd expect. After gc_grace_seconds, if you haven't run a repair within that hour, the data you deleted will seem to have been undeleted. Someone correct me if I'm wrong, but in order to order to completely delete data and rega

Re: V2 Beta 1 bootstrap behaviour ?

2013-07-16 Thread Andrew Cobley
Righto ! Will do a JIRA report.. Many thanks Andy On 16 Jul 2013, at 18:50, Robert Coli mailto:rc...@eventbrite.com>> wrote: On Tue, Jul 16, 2013 at 1:16 AM, Andrew Cobley mailto:a.e.cob...@dundee.ac.uk>> wrote: I'm setting up a new test cluster using 2.0.0-beta1

Cassandra 2 vs Java 1.6

2013-07-22 Thread Andrew Cobley
I know it was decided to drop the requirement for Java 1.6 for cassandra some time ago, but my question is should 2.0.0-beta1 run under java 1.6 at all ? I tried and got the following error: ma

RE: Cassandra 2 vs Java 1.6

2013-07-22 Thread Andrew Cobley
Cassandra 2 vs Java 1.6 I believe it won't run on 1.6. Java 1.7 is required to compile C* 2.0+ and once it's done, you cannot run it using Java 1.6 (this is what "Unsupported major.minor version" error tells you about; java version 50 is 1.6 and 51 is 1.7). M. W dniu 22.07.2

Strange cassandra-stress results with 2.0.0 beta1

2013-07-22 Thread Andrew Cobley
I've been noticing some strange casandra-stress results with 2.0.0 beta 1. I've set up a single node on a Mac (4 gig ram, 2.8Ghz core 2 duo) and installed 2.0.0 beta1. When I run ./cassandra-stress -d 134.36.36.218 I'm seeing the interval-op-rate drop from a peek of 11562 at the start to 0 -2

Re: sstable size change

2013-07-22 Thread Andrew Bialecki
My understanding is deleting the .json metadata file is the only way currently. If you search the user list archives, there are folks who are building tools to force compaction and rebuild sstables with the new size. I believe there's been a bit of talk of potentially including those tools as a pat

Re: Cassandra 2.0 : Ant build issue

2013-07-22 Thread Andrew Cobley
Are you using JDK 1.6. If so you'll need to get the 1.7 jdk (Java SE 7u25) from oracle to do the compile. See my message thread earlier today subject "Cassandra 2 vs Java 1.6 for a few more details. Andy On 22 Jul 2013, at 20:16, Soumava Ghosh mailto:soum...@cs.utexas.edu>> wrote: Hi, I'm

  1   2   >