Re: Reads not returning data after adding node

2023-04-04 Thread David Tinker
wrote: > Perhaps have a read here? > https://docs.datastax.com/en/cassandra-oss/3.x/cassandra/operations/opsAddNodeToCluster.html > > > On 04/04/2023 06:41, David Tinker wrote: > > Ok. Have to psych myself up to the add node task a bit. Didn't go well the > first time

Re: Reads not returning data after adding node

2023-04-04 Thread David Tinker
user < user@cassandra.apache.org> wrote: > Perhaps have a read here? > https://docs.datastax.com/en/cassandra-oss/3.x/cassandra/operations/opsAddNodeToCluster.html > > > On 04/04/2023 06:41, David Tinker wrote: > > Ok. Have to psych myself up to the add node task a bit.

Re: Reads not returning data after adding node

2023-04-03 Thread David Tinker
hen you’re done > (successfully) will remove a lot of it. > > > > On Apr 3, 2023, at 8:14 PM, David Tinker wrote: > >  > Looks like the remove has sorted things out. Thanks. > > One thing I am wondering about is why the nodes are carrying a lot more >

Re: Reads not returning data after adding node

2023-04-03 Thread David Tinker
and bring your cluster back. >> >> Next time when you are doing something like this again, please test it >> out on a non-production environment, make sure everything works as expected >> before moving onto the production. >> >> >> On 03/04/2023 06:28, Davi

Re: Reads not returning data after adding node

2023-04-03 Thread David Tinker
ed in the same rack. TBH - > I'd build out two more nodes to have 6 nodes across 3 racks (2 in each), > just to ensure even distribution. Otherwise, you might notice that the > nodes sharing a rack will consume disk at a different rate than the nodes > which have their own ra

Understanding rack in cassandra-rackdc.properties

2023-04-03 Thread David Tinker
was going to use rack4 for the next node, then rack5 and rack6 because the nodes are physically all on different racks. Elsewhere on this list someone mentioned that I should use rack1, rack2 and rack3 again. Why is that? Thanks David

Re: Reads not returning data after adding node

2023-04-03 Thread David Tinker
ng works as expected > before moving onto the production. > > > On 03/04/2023 06:28, David Tinker wrote: > > Should I use assassinate or removenode? Given that there is some data on > the node. Or will that be found on the other nodes? Sorry for all the > questions but I really

Re: Reads not returning data after adding node

2023-04-02 Thread David Tinker
run nodetool rebuild on the new node > > If you assassinate it now you violate consistency for your most recent > writes > > > > On Apr 2, 2023, at 10:22 PM, Carlos Diaz wrote: > >  > That's what nodetool assassinte will do. > > On Sun, Apr 2, 2023 at 10:19 P

Re: Reads not returning data after adding node

2023-04-02 Thread David Tinker
o. > > On Sun, Apr 2, 2023 at 10:19 PM David Tinker > wrote: > >> Is it possible for me to remove the node from the cluster i.e. to undo >> this mess and get the cluster operating again? >> >> On Mon, Apr 3, 2023 at 7:13 AM Carlos Diaz wrote: >> >>>

Re: Reads not returning data after adding node

2023-04-02 Thread David Tinker
d list. However, if you do decide to fix > the issue with the racks first assassinate this node (nodetool assassinate > ), and update the rack name before you restart. > > On Sun, Apr 2, 2023 at 10:06 PM David Tinker > wrote: > >> It is also in the seeds list for the other

Re: Reads not returning data after adding node

2023-04-02 Thread David Tinker
I should add that the new node does have some data. On Mon, Apr 3, 2023 at 7:04 AM David Tinker wrote: > It is also in the seeds list for the other nodes. Should I remove it from > those, restart them one at a time, then restart it? > > /etc/cassandra # grep -i bootstrap * &g

Re: Reads not returning data after adding node

2023-04-02 Thread David Tinker
at 7:01 AM Carlos Diaz wrote: > Just remove it from the seed list in the cassandra.yaml file and restart > the node. Make sure that auto_bootstrap is set to true first though. > > On Sun, Apr 2, 2023 at 9:59 PM David Tinker > wrote: > >> So likely because I made it a seed n

Re: Reads not returning data after adding node

2023-04-02 Thread David Tinker
So likely because I made it a seed node when I added it to the cluster it didn't do the bootstrap process. How can I recover this? On Mon, Apr 3, 2023 at 6:41 AM David Tinker wrote: > Yes replication factor is 3. > > I ran nodetool repair -pr on all the nodes (one at a time

Re: Reads not returning data after adding node

2023-04-02 Thread David Tinker
es of your replication factor in order to keep the "racks" > balanced. In other words, this node should have been added to rack 1, 2 or > 3. > > Having said that, you should be able to easily fix your problem by running > a nodetool repair -pr on the new node. > > O

Reads not returning data after adding node

2023-04-02 Thread David Tinker
l 2.6 TiB 73.92% -9112518853051755414 xxx.xxx.xxx.105 rack3 Up Normal 2.65 TiB72.88% -9100516173422432134 ... This is causing a serious production issue. Please help if you can. Thanks David

Re: JMX exposing non-standard java classes, to fix requires a breaking change

2022-05-05 Thread David Capwell
-Dcassandra.settings.jmx_hide_non_java_exceptions=false Does anyone see any issues about this? > On Apr 6, 2022, at 9:35 AM, David Capwell wrote: > > I noticed in DatabaseDescriptor there are setters that are leaking it to JMX > since cassandra-3.0. I am not sure whether we can just

Re: JMX exposing non-standard java classes, to fix requires a breaking change

2022-04-06 Thread David Capwell
have different understanding so I want to align us to ensure we > don’t break tools by fixing or not stuff… > In many setters we were actually not doing the same checks we do on > Startup too… I consider this being a bug. > > On Tue, 5 Apr 2022 at 18:21, David Capwell wrote: >

JMX exposing non-standard java classes, to fix requires a breaking change

2022-04-05 Thread David Capwell
There are 2 places that expose non-standard java classes, so JMX only works if and only if the JMX client also has Cassandra's jars, else they will fail; the 2 examples are org.apache.cassandra.service.StorageServiceMBean#enableAuditLog throws org.apache.cassandra.exceptions.ConfigurationException

Barman equivalent for Cassandra?

2021-03-12 Thread David Tinker
. It would be difficult for me to recover even a day of lost data. An hour might be ok. Thanks David

Re: Recovery after server crash 4.0b3

2021-03-01 Thread David Tinker
Thanks guys. The IP address hasn't changed so I will go ahead and start the server and repair. On Mon, Mar 1, 2021 at 1:50 PM Erick Ramirez wrote: > If the node's only been down for less than gc_grace_seconds and the data > in the drives are intact, you should be fine just booting the server and

Recovery after server crash 4.0b3

2021-03-01 Thread David Tinker
replaced the server and moved the drives across. Is it safe for me to boot the machine and let it join the cluster? Thanks David

kill session in cassandra cluster

2021-01-06 Thread David Ni
Hello,Experts! I want to know if there is a way to kill the session in cassandra cluster,for example,I get session_id from system_traces.sessions:4c9049a0-4fed-11eb-a60d-7f98ffdaf6cd,the session is running with very bad cql which causing bad performance,I need to kill it ASAP,could any

How beta is 4.0-beta3?

2020-11-24 Thread David Tinker
I could really use zstd compression! So if it's not too buggy I will take a chance :) Tx

Re:Re:Re: Re: Re: unconfigured table logtabl

2020-04-05 Thread David Ni
Hi Erick Thank you very much for your friendly note. ERROR [AntiEntropyStage:1] 2020-04-04 13:57:09,614 RepairMessageVerbHandler.java:177 - Table with id 21a3fa90-74c7-11ea-978a-b556b0c3a5ea was dropped during prepare phase of repair cassandra@cqlsh:system_schema> select keyspace_name,table_name

Re:Re: Re: Re: unconfigured table logtabl

2020-04-04 Thread David Ni
Thank you very much for your friendly note. ERROR [AntiEntropyStage:1] 2020-04-04 13:57:09,614 RepairMessageVerbHandler.java:177 - Table with id 21a3fa90-74c7-11ea-978a-b556b0c3a5ea was dropped during prepare phase of repair cassandra@cqlsh:system_schema> select keyspace_name,table_name,id f

Re:Re: Re: unconfigured table logtabl

2020-04-03 Thread David Ni
Hi Erick here is the log from system.log but when I desc keyspace the table is still there At 2020-04-04 11:56:15, "Erick Ramirez" wrote: And from your review of the logs, what was the cause of the repair failures? Because that's likely to yield clues on the root cause. Cheers

Re:Re: unconfigured table logtabl

2020-04-03 Thread David Ni
Thanks Erick I think there is no problem with schema version: At 2020-04-04 10:35:06, "Erick Ramirez" wrote: The symptoms in your post indicate that you have a schema disagreement in your cluster which you need to resolve. These 2 nodes in particular are the ones you ne

unconfigured table logtabl

2020-04-03 Thread David Ni
Hello experts: I am using cassandra 3.11.2 and having below problem: cassandra@cqlsh> select * from oapi_dev.logtabl; InvalidRequest: Error from server: code=2200 [Invalid query] message="unconfigured table logtabl" but when I descrbibe keyspace,it shows in the result:

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

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
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

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

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?

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

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: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: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

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

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>

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>

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.

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

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

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

UNSUBSCRIBE

2017-06-15 Thread Patten, David E
UNSUBSCRIBE This email message and any attachments are for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original me

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

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: 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

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: 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 > >

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 >

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: 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: 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: 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: 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:

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

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: 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

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

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: 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. > >

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
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: 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-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: 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-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

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

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

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: 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: 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: 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: 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-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

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: 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. >> >>

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

cassandra on own distributed network

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

Re: Weird timeout errors

2014-06-13 Thread David Mitchell
On Jun 12, 2014, at 11:39 AM, Robert Coli wrote: > On Thu, Jun 12, 2014 at 10:29 AM, David Mitchell wrote: > session.execute("""insert into raw_data (key,column1,value) values > (%s,%s,%s)""", > ... > and then delete them like so: >

Weird timeout errors

2014-06-12 Thread David Mitchell
clear it up is to completely stop and start the Cassandra server. I’m running version 2.0.7 and I don’t think this was happening under 2.0.1. Is this a known bug? Any ideas what might be causing this? Thanks in advance, -David Mitchell -- David Mitchell, Network Engineer Energy Sciences Network (ESnet) Lawrence Berkeley National Laboratory (LBL) Email:mitch...@es.net Phone:(510) 936-0720

Re: VPC AWS

2014-06-05 Thread David McNelis
re already several Cassandra chef recipes available with a little searching. David On Thu, Jun 5, 2014 at 9:26 AM, William Oberman wrote: > I was making assumptions (sorry!), namely the goal to switching to vpc > was getting "backend resources" (like cassandra) off the public

Re: I have a deaf node?

2014-06-01 Thread David Daeschler
r >>>>>>>> in >>>>>>>> getting rid of it. >>>>>>>> >>>>>>>> I've made a couple of attempts to get rid of this so far. I'm about >>>>>>>> to try again. >>>>>>>> >>>>>>>> Thanks >>>>>>>> Tim >>>>>>>> >>>>>>>> -- >>>>>>>> GPG me!! >>>>>>>> >>>>>>>> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> GPG me!! >>>>>> >>>>>> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> Founder/CEO Spinn3r.com >>>>> Location: *San Francisco, CA* >>>>> Skype: *burtonator* >>>>> blog: http://burtonator.wordpress.com >>>>> … or check out my Google+ profile >>>>> <https://plus.google.com/102718274791889610666/posts> >>>>> <http://spinn3r.com> >>>>> War is peace. Freedom is slavery. Ignorance is strength. Corporations >>>>> are people. >>>>> >>>>> >>> >>> >>> -- >>> GPG me!! >>> >>> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B >>> >>> >> >> >> -- >> *Paulo Motta* >> >> Chaordic | *Platform* >> *www.chaordic.com.br <http://www.chaordic.com.br/>* >> +55 48 3232.3200 >> > > > > -- > GPG me!! > > gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B > > -- David Daeschler

Re: Strange trouble with JNA on CentOS6

2014-05-26 Thread David Daeschler
Figured this one out.. In the new setup /tmp was mounted as noexec. So it looks like JNA was putting the native library here and then it was unable to execute it. I hope this can help someone else. On Mon, May 26, 2014 at 11:33 PM, David Daeschler wrote: > Good evening list, > > I

Strange trouble with JNA on CentOS6

2014-05-26 Thread David Daeschler
4/jna4691935553862497129.tmp. Thank you ahead of time for any help you may be able to offer. -- David Daeschler

Re: What % of cassandra developers are employed by Datastax?

2014-05-23 Thread David Daeschler
pretty confident Datastax is a significant net positive for contribution to > and promotion of Apache Cassandra. > > =Rob > -- David Daeschler

cassandra woes ----- why cant cassandra work with the outside world with port 9160

2014-04-17 Thread David Montgomery
Why can no server connect to 9160? I dont understand? Yes...i have the port open. I am using ip address as listen_address on cassandra.yaml. I can telnet to 7199but 9160 is a total disaster. I can telnet from localhost but fro remote? no way. How do I open up 9160? I have both brodcast

Re: CQL Select Map using an IN relationship

2014-03-14 Thread David Savage
Hi Michael, Thanks for the feedback, all makes sense. If anyone wants me to raise a jira ticket for docs on (key1, key2) vs ((key1,key2)) and their implications, or fixing that if block in SelectStatement, let me know - though for the if block possibly best if that jira is raised by a C* expert s

Re: CQL Select Map using an IN relationship

2014-03-13 Thread David Savage
is no range key - and you can specify = on > key1 and = or IN on key2 (but not a range). > > Anyway that's what I remember! Hope it helps. > > ml > > > On Thu, Mar 13, 2014 at 11:27 AM, David Savage wrote: > >> Great that works, thx! I probably would have nev

Re: CQL Select Map using an IN relationship

2014-03-13 Thread David Savage
artition key. > > ml > > > On Thu, Mar 13, 2014 at 10:40 AM, David Savage wrote: > >> Nope, upgraded to 2.0.5 and still get the same problem, I actually >> simplified the problem a little in my first post, there's a composite >> primary key involved as I ne

Re: CQL Select Map using an IN relationship

2014-03-13 Thread David Savage
) VALUES (1,'test',{'count':'1'}); INSERT INTO test.documents(id,group,data) VALUES (2,'test',{'count':'2'}); SELECT id,data FROM test.documents WHERE group='test' AND id IN (0,1,2); Thanks for your help. Kind regards,

Re: CQL Select Map using an IN relationship

2014-03-13 Thread David Savage
PM, Laing, Michael wrote: > I have no problem doing this w 2.0.5 - what version of C* are you using? > Or maybe I don't understand your data model... attach 'creates' if you > don't mind. > > ml > > > On Thu, Mar 13, 2014 at 9:24 AM, David Savage wrote: >

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: &

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:

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

cold_reads_to_omit and tombstones

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

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

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-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

  1   2   3   4   5   6   7   >