unable to create a user on version 2.2.4

2016-01-02 Thread david
we are running cassandra version 2.2.4 on Debian jessie (latest stable) . when i attempt to create user, it doesn't work when i type the following 'create user alice with password 'bob' superuser;' cqlsh returns fine without any error however 'list users' does not show the newly created user w

Re: unable to create a user on version 2.2.4

2016-01-02 Thread david
Sam Tunnicliffe beobal.com> writes: > > > If you've upgraded to 2.2.4, the full instructions necessary for auth-enabled clusters were unfortunately missing from NEWS.txt. See CASSANDRA-10904 for details. > On 2 Jan 2016 10:05, "david" gmail.com> wrote:

Re: cassandra as session store

2011-02-01 Thread David
you though. When you say you use memcached for session, do you mean you use it as your cache layer, or are you using it exclusively ? thanks, David

Cassandra for live statistics aggregation ?

2010-05-10 Thread David
e queries over key containing timestamps (thus requiring the ordered partitioner). thanks, David

Incremental Backup Hardlinks

2018-07-19 Thread David Payne
Hello Cassandra Experts and Committers, Hopefully this is just a dumb question, but without the skill set to read the source code, I must ask. Consider incremental backups are enabled on 2.x or 3.x. As memtables flush to sstables on disk, hardlinks are created in backups for the column family.

FailureDetector.java:456 - Ignoring interval time

2018-07-27 Thread David Payne
-L474 MAX_INTERVAL_IN_NANO seems to be how this is controlled. Where does the result of getMaxInterval() which sets MAX_INTERVAL_IN_NANO come from? Thanks, David Payne | ̄ ̄| _☆☆☆_ ( ´_⊃`) c. 303-717-0548 dav...@cqg.com<mailto:dav...@cqg.com>

Cassandra 2.2.7 Compaction after Truncate issue

2018-08-14 Thread David Payne
compaction for the truncated table for node 2 and 3, but not node 1. This appears to be a defect that was fixed in 2.1.0. https://issues.apache.org/jira/browse/CASSANDRA-7803 Any ideas? Thanks, David Payne | ̄ ̄| _☆☆☆_ ( ´_⊃`) c. 303-717-0548 dav...@cqg.com<mailto:dav...@cqg.com>

data not beening syncd in different nodes

2018-08-31 Thread David Ni
Hi Experts, I am using 3.9 cassandra in production environment,we have 6 nodes,the RF of keyspace is 3, I have a table which below definition: CREATE TABLE nev_prod_tsp.heartbeat ( vin text PRIMARY KEY, create_time timestamp, pkg_sn text, prot_ver text, trace_time timestam

Re:RE: data not beening syncd in different nodes

2018-08-31 Thread David Ni
As you use TimeWindowCompactionStrategy, do you insert data with TTL? These buckets seem to be too small for me: 'compaction_window_size': '2', 'compaction_window_unit': 'MINUTES'. Do you have such a huge amount of writes so that such bucket size makes sense? Regards, Kyri

Re:RE: Re:RE: data not beening syncd in different nodes

2018-09-02 Thread David Ni
quickly so that results may differ even for 2 consecutive queries. How about this theory? CL in your driver – depends on which CL is default for your particular driver. Regards, Kyrill From: David Ni Sent: Friday, August 31, 2018 12:53 PM To:user@cassandra.apache.org Subject: Re:RE: data n

RE: Cassandra 2.2.7 Compaction after Truncate issue

2018-09-13 Thread David Payne
ncate action is frequently failed on some remote nodes in a heavy transactions env. Thanks, James On Thu, Aug 23, 2018 at 8:54 PM, Rahul Singh mailto:rahul.xavier.si...@gmail.com>> wrote: David , What CL do you set when running this command? Rahul Singh Chief Executive Officer m 202.905.

RE: Cassandra 2.2.7 Compaction after Truncate issue

2018-09-13 Thread David Payne
The truncation was performed via OpsCenter, which I believe is ALL by default. From: Rahul Singh Sent: Thursday, August 23, 2018 6:55 PM To: user@cassandra.apache.org Subject: Re: Cassandra 2.2.7 Compaction after Truncate issue David , What CL do you set when running this command? Rahul Singh

sstable corruption and schema migration issues

2018-10-24 Thread David Payne
which versions of cassandra 2.x and 3.x are best for avoiding sstable corruption and schema migration slowness? is this a "cassandra is not a set it and forget it system" concept?

New user on Ubuntu 18.04 laptop, nodetest status throws NullPointerException

2019-04-03 Thread David Taylor
I am running a System87 Oryx Pro laptop with Ubuntu 18.04 I had only Oracle Java 11 installed for Hadoop, so I also installed OpenJDK8 with: $ sudo apt-get install openjdk-8-jre and switched to it with $ sudo update-java-alternatives --set path/shown/with/"update-java-alternatives --list" $ java

Re: New user on Ubuntu 18.04 laptop, nodetest status throws NullPointerException

2019-04-03 Thread David Taylor
at 11:34 AM Paul Chandler wrote: > David, > > When you start cassandra all the logs go to system.log normally in the > /var/log/cassandra directory, so you should look there once it has started, > to check everything is ok. > > I assume you mean you ran nodetool status

Re: New user on Ubuntu 18.04 laptop, nodetest status throws NullPointerException

2019-04-03 Thread David Taylor
e /usr/bin/nodetool executable? It's currently -rwxr-xr-x which looks right to me On Wed, Apr 3, 2019 at 12:16 PM Oleksandr Shulgin < oleksandr.shul...@zalando.de> wrote: > On Wed, Apr 3, 2019 at 4:23 PM David Taylor > wrote: > >> >> $ nodet

Re: New user on Ubuntu 18.04 laptop, nodetest status throws NullPointerException

2019-04-03 Thread David Taylor
ou could try the 3rd answer here and see if this helps: > https://stackoverflow.com/questions/48193965/cassandra-nodetool-java-lang-nullpointerexception > > > > On 3 Apr 2019, at 16:55, David Taylor wrote: > > Hi Paul thanks for responding. > > I created a ~/.cassandra

1000 Cassandra Nodes running on Kubernetes 1.3

2016-07-13 Thread David Aronchick
Just thought I'd share this big milestone for all Cassandra users! https://news.ycombinator.com/item?id=12089272

Re: Cassandra discussion channel on Slack!

2016-07-16 Thread David King
Just as a heads-up, #cassandra in freenode IRC is pretty active. You might have more luck there > On 15 Jul 2016, at 08:11, denish patel wrote: > > Hello, > > I have started Slack channel to discuss Cassandra. > The purpose of this channel to use existing slack platform to get connected >

Re: Cassandra and Kubernetes and scaling

2016-09-11 Thread David Aronchick
Please let me know if I can help at all! On Sun, Sep 11, 2016 at 2:55 PM, Jens Rantil wrote: > Hi Aiman, > > I noticed you never got any reply. This might be of interest: http://blog. > kubernetes.io/2016/07/thousand-instances-of-cassandra-using-kubernetes- > pet-set.html > > Cheers, > Jens > >

Rationale for using Hazelcast in front of Cassandra?

2016-10-06 Thread KARR, DAVID
I've seen use cases that briefly describe using Hazelcast as a "front-end" for Cassandra, perhaps as a cache. This seems counterintuitive to me. Can someone describe to me when this kind of architecture might make sense?

RE: Rationale for using Hazelcast in front of Cassandra?

2016-10-06 Thread KARR, DAVID
? Example: why does facebook use memcache ? They certainly have things distributed on thousands of servers. On Thu, Oct 6, 2016 at 11:40 PM, KARR, DAVID mailto:dk0...@att.com>> wrote: I've seen use cases that briefly describe using Hazelcast as a "front-end" for Cassandra, perh

RE: Rationale for using Hazelcast in front of Cassandra?

2016-10-07 Thread KARR, DAVID
is pretty fast in rdbms too and they also have caches. By "close to" you mean in latency ? Have you thought why people don't use cassandra as a cache ? While it doesn't have LRU, it has TTL,replicatio,sharding. On Fri, Oct 7, 2016 at 12:00 AM, KARR, DAVID mailto:dk0...@att.

RE: Logs appear to contradict themselves during bootstrap steps

2017-01-06 Thread David Berry
I’ve encountered this previously where after removing a node, gossip info is retained for 72 hours which doesn’t allow the IP to be reused during that period. You can check how long gossip will retain this information using “nodetool gossipinfo” where the epoch time will be shown with status

Fwd: Issue when node goes away?

2015-06-25 Thread David Aronchick
-- Forwarded message -- From: David Aronchick Date: Thu, Jun 25, 2015 at 10:33 AM Subject: Issue when node goes away? To: cassandra-u...@cassandra.apache.org I posted this to StackOverflow with no response: http://stackoverflow.com/questions/30744486/how-to-handle-failures-in

Stream failure while adding a new node

2015-06-29 Thread David CHARBONNIER
nk you for your help. Best regards, [cid:image001.png@01D0B276.9AED4370] David CHARBONNIER Sysadmin T : +33 411 934 200 david.charbonn...@rgsystem.com<mailto:david.charbonn...@rgsystem.com> ZAC Aéroport 125 Impasse Adam Smith 34470 Pérols - France www.rgsystem.com<http://www.rgsyst

Re: Issue when node goes away?

2015-06-29 Thread David Aronchick
Ping--- any thoughts here? -- I posted this to StackOverflow with no response: http://stackoverflow.com/questions/30744486/how-to-handle-failures-in-cassandra-when-node-goes-away Basically, I'm trying to run Cassandra in a Kubernetes cluster, and trying out what ha

Re: Issue when node goes away?

2015-06-30 Thread David Aronchick
I appreciate the thoughts! My issue is that it seems to work perfectly, until the node goes away. Would it matter that I'm mixing cassandra versions? (2.1.4 and 2.1.5)? On Tue, Jun 30, 2015 at 5:23 AM, Alain RODRIGUEZ wrote: > Hi David ? > > What does a "nodetool describec

Re: Issue when node goes away?

2015-06-30 Thread David Aronchick
ng upgrades, the nodes on different versions show a schema > disagreement*." > > I think this is a good lead. > > C*heers, > > Alain > > 2015-06-30 20:22 GMT+02:00 David Aronchick : > >> I appreciate the thoughts! My issue is that it seems to work perfectly, &

RE: Stream failure while adding a new node

2015-07-01 Thread David CHARBONNIER
your help. Best regards, [cid:image001.png@01D0B41D.54B89AA0] David CHARBONNIER Sysadmin T : +33 411 934 200 david.charbonn...@rgsystem.com<mailto:david.charbonn...@rgsystem.com> ZAC Aéroport 125 Impasse Adam Smith 34470 Pérols - France www.rgsystem.com<http://www.rgs

Re: Issue when node goes away?

2015-07-01 Thread David Aronchick
end fast, so I would run it always as a best practice, just > in case). > > C*heers, > > Alain > > 2015-07-01 2:16 GMT+02:00 David Aronchick : > >> That is a GREAT lead! So it looks like I can't add a few nodes to the >> cluster of the new version, have it settle

Re: Issue when node goes away?

2015-07-01 Thread David Aronchick
11:37 AM David Aronchick > wrote: > >> This helps - so let me understand: >> >> Starting point: >> - 4 nodes running 2.1.4 >> - System is healthy >> >> Decide to upgrade: >> - Add 2 nodes running 2.1.5 >> - Run nodetool upgradestabl

Re: Issue when node goes away?

2015-07-01 Thread David Aronchick
trouble, as others > have said. I don't know if this particular version bump would expect any > issues, but why risk it? If you want to upgrade, do it to the nodes in > place. Don't bootstrap new nodes, don't run repair, don't remove nodes. > My 2 cents. > >

Bulk loading performance

2015-07-13 Thread David Haguenauer
ch as possible. I can of course post more information about our setup and requirements if this helps answering. -- Thanks, David Haguenauer

Re: Bulk loading performance

2015-07-14 Thread David Haguenauer
ad code is a few years old). If you don't mind me asking, what approach does your fast-loading code use, if it's anything special? I'm mostly concerned about not interfering with concurrent reads too much, but all experience reports are welcome. -- David Haguenauer

RE: OpsCenter datastax-agent 300% CPU

2015-07-20 Thread David Comer
May I please be discontinued from this email? May I unsubscribe? From: John Wong [mailto:gokoproj...@gmail.com] Sent: Monday, July 20, 2015 8:37 AM To: user@cassandra.apache.org Subject: Re: OpsCenter datastax-agent 300% CPU Hi all & Sebastain We recently encountered similar issu

sstablescrub for unreadable sstables?

2015-08-18 Thread David Paulsen
Two questions really: 1) Is there a way to search the archives https://mail-archives.apache.org/mod_mbox/cassandra-user/ or another better approach to searching for Cassandra answers such as #2? 2) I have the following error in /var/log/cassandra/cassandra.log - cassandra dies after "service cass

Re: Is it possible to achieve "sticky" request routing?

2016-04-05 Thread David King
Many C* versions back I did this by writing a custom snitch. This was to maximise use of the row cache but had the effect of pinning requests for a key to a given server. It sounds like you want to do the same thing but ignoring the key. In more modern reversions I believe this may be done as a

Re: Experience with Kubernetes

2016-04-15 Thread David Aronchick
Hi-- It's trivial to do this in Kubernetes, even without Ubernetes. Please feel free to send me a note and I'll walk you through it. Disclosure: I work on Google on Kubernetes. On Thu, Apr 14, 2016 at 9:10 AM Joe Stein wrote: > You can do that with the Mesos scheduler > https://github.com/elod

Re: Experience with Kubernetes

2016-04-18 Thread David Aronchick
applies to a > database server that works best with fairly large amounts of ultra-fast > local data storage is not so obvious. Maybe that simply wasn't a design > goal? > > -- Jack Krupansky > > On Fri, Apr 15, 2016 at 3:48 PM, David Aronchick > wrote: > >> Hi--

Re: Connected file list in Cassandra

2012-07-11 Thread David McNelis
I would use something other than the page itself as the key. Maybe a filename, something smaller. Then you could use a LongType comparator for the columns and use the page number for the column name, the value being the contents of the files. On Wed, Jul 11, 2012 at 1:34 PM, Tomek Hankus wrote:

Re: Connected file list in Cassandra

2012-07-11 Thread David Brosius
why not just hold the pages as different columns in the same row? columns are automatically sorted such that if the column name was associated with the page number it would automatically flow the way you wanted. - Original Message -From: "Tomek Hankus" >;tom...@gmail.com

Secondary index impact on write performance

2012-08-04 Thread David McNelis
answer is "it doesn't", then how do brand new records get located by a subsequent indexed query? If someone has a link to a post with some of this info, that would be awesome. David

Re: Secondary index impact on write performance

2012-08-04 Thread David McNelis
and another to the index column family, where in this index > column family the key is the value of the secondary column, and the value > is the key of the original row. > > > > On 08/04/2012 11:40 AM, David McNelis wrote: > >> Morning, >> >> Was reading up on se

CQL connections

2012-08-10 Thread David McNelis
In using CQL (the python library, at least), I didn't see a way to pass in multiple nodes as hosts. With other libraries (like Hector and Pycassa) I can set multiple hosts and my app will work with anyone on that list. Is there something similar going on in the background with CQL? If not, then

Partial composite result limit possible?

2012-08-14 Thread David Turnbull
Hi, I have a CF with a composite type (LongType, IntegerType) with some data like this: RowKey: hihi => (column=1000:1, value=616263) => (column=1000:2, value=6465) => (column=1000:3, value=66) => (column=1000:4, value=6768) => (column=2000:1, value=616263) => (column=2000:2, value=6465) => (colu

Nodetool repair, exit code/status?

2012-10-08 Thread David Daeschler
me for any info. - David

Repair Failing due to bad network

2012-10-11 Thread David Koblas
is case, or is there something else I could be doing? --david

Re: Repair Failing due to bad network

2012-10-12 Thread David Koblas
Jim, Great idea - though it doesn't look like it's in 1.1.3 (which is what I'm running). My lame idea of the morning is that I'm going to just read the whole keyspace with QUORUM reads to force read repairs - the unfortunate truth is that this is about 2B reads... --

Re: Hinted Handoff runs every ten minutes

2012-10-18 Thread David Daeschler
Hi Steve, Also confirming this. After having a node go down on Cassandra 1.0.8 there seems to be hinted handoff between two of our 4 nodes every 10 minutes. Our setup also shows 0 rows. It does not appear to have any effect on the operation of the ring, just fills up the log files. - David On

Re: Java high-level client

2012-11-28 Thread David Schairer
Well, not really. Astyanax ('astu-wanax' in mycenaean greek, 'lord of the city') has his brains dashed out against the walls of troy by Neoptolemus, son of Achilles. So the suck was universal. --DRS, possibly the only trained classicist using big cassandra databases :) On Nov 28, 2012, at 1

failing reconcilliation during counter increment?

2012-11-29 Thread David Vanderfeesten
efore concluding. Txs, David INFO [ScheduledTasks:1] 2012-11-28 16:58:28,924 MessagingService.java (line 607) 1175 READ messages dropped in last 5000ms INFO [ScheduledTasks:1] 2012-11-28 16:58:28,924 StatusLogger.java (line 50) Pool Name Active Pending Blocked INFO [ScheduledTasks:1] 2012-11-

Re: failing reconcilliation during counter increment?

2012-12-03 Thread David Vanderfeesten
ments are more expensive then regular cf's. But can we expect linear scaling? Txs! David On Fri, Nov 30, 2012 at 1:19 PM, Sylvain Lebresne wrote: > To my understanding client will not be notified because this read step is >> asynchronously. > > > Yes, though for the reco

Re: Cassandra with SAN

2013-02-21 Thread David Schairer
"Who breaks a butterfly upon a wheel?" It will work, but you'd have a distributed database running on a single point of failure storage fabric, thus destroying much of your benefits, unless you have enough discrete SAN units that you treat them as racks in your cassandra topology to ensure that

Uncaught exception on thread CounterMutationStage

2017-07-25 Thread David Salz
d Thanks! David -- --- Technical Director / Co-Founder Sandbox Interactive GmbH http://albiononline.com - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional comman

Re: Uncaught exception on thread CounterMutationStage

2017-07-27 Thread David Salz
ve-Transport-Request. Googled a bit and now set -Dcassandra.max_queued_native_transport_requests=4096 and native_transport_max_threads=4096 Seeing no more blocked NTRs so far. Do you think this could have contributed to the problem? The default values se

Looking for advice and assistance upgrading from Cassandra 1.2.9

2017-10-17 Thread David Ellis
income :) David - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org

cassandra on own distributed network

2014-09-09 Thread David M
;ve missed I'd appreciate your sharing. Thanks, David

CQL3 vs Thrift

2014-12-22 Thread David Broyles
Although I used Cassandra 1.0.X extensively, I'm new to CQL3. Pages such as http://wiki.apache.org/cassandra/ClientOptionsThrift suggest new projects should use CQL3. I'm wondering, however, if there are certain use cases not well covered by CQL3. Consider the standard timeseries example: CREAT

Re: CQL3 vs Thrift

2014-12-23 Thread David Broyles
html > On Dec 22, 2014 10:50 PM, "David Broyles" wrote: > >> Although I used Cassandra 1.0.X extensively, I'm new to CQL3. Pages such >> as http://wiki.apache.org/cassandra/ClientOptionsThrift suggest new >> projects should use CQL3. >> >>

Deleted snapshot files filling up /var/lib/cassandra

2015-03-16 Thread David Wahler
t to upgrade to 2.1.x, since the consensus on this list seems to be that it's not yet production-ready. I'm fairly new to Cassandra, so general troubleshooting tips would also be much appreciated. Thanks, -- David

Re: Deleted snapshot files filling up /var/lib/cassandra

2015-03-16 Thread David Wahler
On Mon, Mar 16, 2015 at 5:28 PM, Jan wrote: > David; > > all the packaged installations use the /var/lib/cassandra directory. > Could you check your yaml config files and see if you are using this default > directory for backups > > May want to change it to a location

Re: Deleted snapshot files filling up /var/lib/cassandra

2015-03-16 Thread David Wahler
On Mon, Mar 16, 2015 at 6:12 PM, Ben Bromhead wrote: > Cassandra will by default snapshot your data directory on the following > events: > > TRUNCATE and DROP schema events > when you run nodetool repair > when you run nodetool snapshot > > Snapshots are just hardlinks to existing SSTables so the

Re: Deleted snapshot files filling up /var/lib/cassandra

2015-03-17 Thread David Wahler
On Mon, Mar 16, 2015 at 6:51 PM, Ben Bromhead wrote: > If you are running a sequential repair (or have previously run a sequential > repair that is still running) Cassandra will still have the file descriptors > open for files in the snapshot it is using for the repair operation. Yeah, that align

RE: Problems after trying a migration

2015-03-18 Thread David CHARBONNIER
Hi Fabien, Thank you for the link ! That’s exactly what we want to do. But before starting this, we need to clean up the mess in order to get a clean cluster. Thanks for your help. Best regards, [cid:image001.png@01D061A4.2E073720] David CHARBONNIER Sysadmin T : +33 411 934 200

RE: Problems after trying a migration

2015-03-20 Thread David CHARBONNIER
Hi Jan, Thank you for your help, we’ll see during next week. Have a nice day. Best regards, [cid:image001.png@01D062FA.DDD7FC50] David CHARBONNIER Sysadmin T : +33 411 934 200 david.charbonn...@rgsystem.com<mailto:david.charbonn...@rgsystem.com> ZAC Aéroport 125 Impasse Adam

Re: Deleted snapshot files filling up /var/lib/cassandra

2015-03-20 Thread David Wahler
gt; before), if you still have issues with repair not letting go of snapshotted > files even with free disk space I would look to raise a ticket in Jira. > > On 17 March 2015 at 12:46, David Wahler wrote: >> >> On Mon, Mar 16, 2015 at 6:51 PM, Ben Bromhead wrote: >&g

Re: Hey!

2013-10-31 Thread David Ward
ouch, seems like someones yahoo account was compromised. On Thu, Oct 31, 2013 at 9:18 PM, Alexandre Linares wrote: > ** > > > > http://subtesytrenes.com.ar/font/likeit.php?cmwvk250dfw > > > > > > > > > > > > > > > > > > > > > > > > > > > > > : > > lina...@ymail.com > Alexandre Linare

Re: Statistics

2013-11-08 Thread David Chia
http://www.datastax.com/dev/blog/metrics-in-cassandra12 On Fri, Nov 8, 2013 at 11:42 AM, Parag Patel wrote: >Hi, > > > > I’m looking for a way to view statistics. Mainly, I’d like to see the > distribution of writes and reads over the course of a day or a set of days. > Is there a way to do

Read inconsistency after backup and restore to different cluster

2013-11-14 Thread David Laube
ot;nodetool repair" on each of the nodes in cluster-B. Please let me know if you see any major errors or deviation from best practices which could be contributing to our read inconsistencies. I'll be happy to answer any specific question you may have regarding our configuration. Thank you in advance! Best regards, -David Laube

Re: Read inconsistency after backup and restore to different cluster

2013-11-14 Thread David Laube
Thank you for the detailed reply Rob! I have replied to your comments in-line below; On Nov 14, 2013, at 1:15 PM, Robert Coli wrote: > On Thu, Nov 14, 2013 at 12:37 PM, David Laube wrote: > It is almost as if the data only exists on some of the nodes, or perhaps the > token r

Commit log on USB flash disk?

2013-11-16 Thread David Tinker
use for a write heavy workload like this? Please tell me if this is a really bad idea. Our alternative is to use one 4TB disk for commit log and one for data. Of course this will give us only half the space. Thanks David

Re: Commit log on USB flash disk?

2013-11-17 Thread David Tinker
Sat, Nov 16, 2013 at 11:05 AM, Philippe wrote: >> >> Hi david, we tried it two years ago and the performance of the USB stick >> was so dismal we stopped. >> Cheers >> >> Le 16 nov. 2013 15:13, "David Tinker" a écrit : >> >>> Our hosting

Re: Commit log on USB flash disk?

2013-11-17 Thread David Tinker
Cg&usg=AFQjCNHTC7d6fcI1CNWmjbHMwgXI1nUWcQ&sig2=BaWgHj3ib-cQOBPQsoCadA&bvm=bv.56643336,d.aWc&cad=rjt > > If you you do end up using it, make sure to monitor write latency so you > don't get hit by the bus. > > > On Sat, Nov 16, 2013 at 6:12 AM, David Tinker > wrot

sstableloader does not support client encryption on Cassandra 2.0?

2013-11-18 Thread David Laube
EXCEPTION== Has anyone seen this before or can someone confirm that SSL/encryption is not supported under the open source project and only with d-stax enterprise? Thanks, -David Laube

Re: sstableloader does not support client encryption on Cassandra 2.0?

2013-11-19 Thread David Laube
Thank you Tyler. I took your advice and I have opened https://issues.apache.org/jira/browse/CASSANDRA-6378 Best regards, -David Laube On Nov 19, 2013, at 9:51 AM, Tyler Hobbs wrote: > I think this is just an oversight; would you mind opening a ticket here? > https://issues.apache.or

Nodetool repair exceptions in Cassandra 2.0.2

2013-12-09 Thread David Laube
Hi All, We are running Cassandra 2.0.2 and have recently stumbled upon an issue with nodetool repair. Upon running nodetool repair on each of the 5 nodes in the ring (one at a time) we observe the following exceptions returned to standard out; [2013-12-08 11:04:02,047] Repair session ff16c510

What is the fastest way to get data into Cassandra 2 from a Java application?

2013-12-10 Thread David Tinker
o tried using session.execute(cql, params) and it is faster but still doesn't match inline values. Composing CQL strings is certainly convenient and simple but is there a much faster way? Thanks David I have also posted this on Stackoverflow if anyone wants the points: http://stackoverf

Re: What is the fastest way to get data into Cassandra 2 from a Java application?

2013-12-10 Thread David Tinker
10, 2013, at 4:49 AM, David Tinker wrote: > >> I have tried the DataStax Java driver and it seems the fastest way to >> insert data is to compose a CQL string with all parameters inline. >> >> This loop takes 2500ms or so on my test cluster: >> >> PreparedStateme

Re: What is the fastest way to get data into Cassandra 2 from a Java application?

2013-12-11 Thread David Tinker
ly be unexpected, are you sure you're not re-preparing the > statement every time in the loop? > > -- > Sylvain > >> I know I can use batching to >> insert all the rows at once but thats not the purpose of this test. I >> also tried using session.execute(cql, para

Re: What is the fastest way to get data into Cassandra 2 from a Java application?

2013-12-11 Thread David Tinker
elize your inserts. Unlogged batches is one way to do it (it's > really > all Cassandra does with unlogged batch, parallelizing). But as John Sanda > mentioned, another option is to do the parallelization client side, with > executeAsync. > > -- > Sylvain > > >

Re: Nodetool repair exceptions in Cassandra 2.0.2

2013-12-12 Thread David Laube
Hi Michael, Upgrading from 2.0.2 to 2.0.3 seems to have done the trick! Thank you for the recommendation! Best regards, -David Laube On Dec 9, 2013, at 3:57 PM, "Laing, Michael" wrote: > My experience is that you must upgrade to 2.0.3 ASAP to fix this. > > Michael &g

Re: Nodetool repair exceptions in Cassandra 2.0.2

2013-12-12 Thread David Laube
Thank you for the reply Aaron. Unfortunately, I could not seem to find any additional info in the logs. However, upgrading from 2.0.2 to 2.0.3 seems to have done the trick! Best regards, -David Laube On Dec 11, 2013, at 6:51 PM, Aaron Morton wrote: >> [2013-12-08 11:04:02,047]

Re: What is the fastest way to get data into Cassandra 2 from a Java application?

2013-12-13 Thread David Tinker
inserts. Unlogged batches is one way to do it (it's > really > all Cassandra does with unlogged batch, parallelizing). But as John Sanda > mentioned, another option is to do the parallelization client side, with > executeAsync. > > -- > Sylvain > > > > On We

Occasional NPE using DataStax Java driver

2013-12-18 Thread David Tinker
We are using Cassandra 2.0.3-1 installed on Ubuntu 12.04 from the DataStax repo with the DataStax Java driver version 2.0.0-rc1. Every now and then we get the following exception: 2013-12-19 06:56:34,619 [sql-2-t15] ERROR core.RequestHandler - Unexpected error while querying /x.x.x.x java.lang.Nu

Re: Occasional NPE using DataStax Java driver

2013-12-19 Thread David Tinker
Done. https://datastax-oss.atlassian.net/browse/JAVA-231 On Thu, Dec 19, 2013 at 10:42 AM, Sylvain Lebresne wrote: > Mind opening a ticket on https://datastax-oss.atlassian.net/browse/JAVA? > It's almost surely a bug. > > -- > Sylvain > > > On Thu, Dec 19, 2013 at 8

Cleanup and old files

2013-12-29 Thread David McNelis
e remained the same. The only recently updated files in that data directory are secondary index sstable files. Am I doing something wrong here? Am I thinking about this wrong? David

Re: Cleanup and old files

2013-12-30 Thread David McNelis
on Morton > New Zealand > @aaronmorton > > Co-Founder & Principal Consultant > Apache Cassandra Consulting > http://www.thelastpickle.com > > On 30/12/2013, at 1:28 pm, David McNelis wrote: > > I am currently running a cluster with 1.2.8. One of my larger column >

Re: Crash with TombstoneOverwhelmingException

2014-01-13 Thread David Tinker
We are seeing the exact same exception in our logs. Is there any workaround? We never delete rows but we do a lot of updates. Is that where the tombstones are coming from? On Wed, Dec 25, 2013 at 5:24 PM, Sanjeeth Kumar wrote: > Hi all, > One of my cassandra nodes crashes with the following ex

Tracking word frequencies

2014-01-16 Thread David Tinker
I have an app that stores lots of bits of text in Cassandra. One of the things I need to do is keep a global word frequency table. Something like this: CREATE TABLE IF NOT EXISTS word_count ( word text, count value, PRIMARY KEY (word) ); This is slow to read as the rows (100's of thousands

Re: Tracking word frequencies

2014-01-20 Thread David Tinker
I haven't actually tried to use that schema yet, it was just my first idea. If we use that solution our app would have to read the whole table once a day or so to find the top 5000'ish words. On Fri, Jan 17, 2014 at 2:49 PM, Jonathan Lacefield wrote: > Hi David, > > How d

supervisord and cassandra

2014-02-13 Thread David Montgomery
omg..wow...can cassandra run under supervisor? this works from the command line as root /var/apache-cassandra-<%=@version%>/bin/cassandra -f this does not work. why? [program:cassandra] command = /var/apache-cassandra-<%=@version%>/bin/cassandra -f #environment=JVM_EXTRA_OPTS="-Dcom.sun.manage

Re: supervisord and cassandra

2014-02-13 Thread David Montgomery
: > Hi David, > > We've had no problems running C* with supervisor, and your conf.d file is > broadly similar to ours. I don't think those errors are anything to do with > supervisor. > > We did however have issues starting C* with the recommended resource &

Re: supervisord and cassandra

2014-02-13 Thread David Montgomery
Hi, I only added the -f flag after the first time it did not work. If I dont use the -f flag. cassandra_server:cassandra FATAL Exited too quickly (process log may have details) On Thu, Feb 13, 2014 at 11:25 PM, Tristan Seligmann wrote: > On 13 February 2014 11:39, Da

Re: supervisord and cassandra

2014-02-14 Thread David Montgomery
Hi, Using now oracle 7. commented out the line StringTableSize=103 same issue. but nothing in the log file now. but I start from, the command line the works. Thanks On Fri, Feb 14, 2014 at 9:48 AM, Michael Shuler wrote: > On 02/13/2014 07:03 PM, David Montgomery wrote: >

Re: supervisord and cassandra

2014-02-14 Thread David Montgomery
I had to give up on supervisor. I installed the deb package rather than from source. that worked though. thanks On Sat, Feb 15, 2014 at 10:10 AM, Michael Shuler wrote: > On 02/14/2014 07:34 PM, Michael Shuler wrote: > >> On 02/14/2014 06:58 PM, David Montgomery wrot

cold_reads_to_omit and tombstones

2014-02-17 Thread David Chia
ctions got kicked off? Cassandra version: 2.0.5 David

Re:

2014-03-12 Thread David McNelis
Not knowing anything about your data structure (to expand on what Edward said), you could be running into something where you've got some hot keys that are getting the majority of writes during those heavily loads more specifically I might look for a single key that you're writing, since you're

CQL Select Map using an IN relationship

2014-03-13 Thread David Savage
Hi there, I'm experimenting using cassandra and have run across an error message which I need a little more information on. The use case I'm experimenting with is a series of document updates (documents being an arbitrary map of key value pairs), I would like to find the latest document updates a

Re: CQL Select Map using an IN relationship

2014-03-13 Thread David Savage
ear to me if your "id" column is the KEY or just a regular > column with secondary index. > > queries that have IN on non primary key columns isn't supported yet. not > sure if that answers your question. > > > On Thu, Mar 13, 2014 at 7:12 AM, David Savage wrote: &

  1   2   3   4   5   6   7   >