Re: Cassandra 311x broken on Debian docker images

2020-05-18 Thread Robert Snakard
Thanks James for helping On Mon, May 18, 2020 at 9:14 PM Robert Snakard wrote: > Solved. > > The user command `free` is not installed by default on the debian docker > images. Running `apt-get install procps` installs the `free` command. This > fixes the issue. > > Unsur

Re: Cassandra 311x broken on Debian docker images

2020-05-18 Thread Robert Snakard
debian dependencies somewhere? On Mon, May 18, 2020 at 8:56 PM Robert Snakard wrote: > Manually ran the start-stop-daemon without the quiet flag. Got some output > > # start-stop-daemon -S -c cassandra -a /usr/sbin/cassandra -p > /run/cassandra/cassandra.pid -- -p /run/cassandra/cassa

Re: Cassandra 311x broken on Debian docker images

2020-05-18 Thread Robert Snakard
lid initial heap size: -XmsM Error: Could not create the Java Virtual Machine. Error: A fatal exception has occurred. Program will exit. # On Mon, May 18, 2020 at 8:48 PM Robert Snakard wrote: > Apologies for the hyperlink > > On Mon, May 18, 2020 at 8:47 PM Robert Snakard > wrote:

Re: Cassandra 311x broken on Debian docker images

2020-05-18 Thread Robert Snakard
Apologies for the hyperlink On Mon, May 18, 2020 at 8:47 PM Robert Snakard wrote: > for dir in $(find / -name cassandra -type d); do > find $dir -type f > done > > > => > > /usr/share/doc/cassandra/copyright > > > > /usr/share/cassandra/cassandra.i

Re: Cassandra 311x broken on Debian docker images

2020-05-18 Thread Robert Snakard
n, May 18, 2020 at 10:51 PM Robert Snakard > wrote: > >> docker logs just outputs stderr and stdout. It doesn't show anything more >> than what I put in top email >> >> On Mon, May 18, 2020 at 7:42 PM James Shaw wrote: >> >>> docker logs ... see

Re: Cassandra 311x broken on Debian docker images

2020-05-18 Thread Robert Snakard
docker logs just outputs stderr and stdout. It doesn't show anything more than what I put in top email On Mon, May 18, 2020 at 7:42 PM James Shaw wrote: > docker logs ... see any error in docker/container logs ? > > On Mon, May 18, 2020 at 10:27 PM Robert Snakard > wrote: &g

Re: Cassandra 311x broken on Debian docker images

2020-05-18 Thread Robert Snakard
# cat /var/log/cassandra/system.log => cat: system.log: No such file or directory I've also checked other possible locations. Since this is occurring before startup no logs are created On Mon, May 18, 2020 at 7:03 PM Erick Ramirez wrote: > Can you inspect the C* system.log? It might give clues

Cassandra 311x broken on Debian docker images

2020-05-18 Thread Robert Snakard
Cassandra is failing to start with the error [FAIL] could not access pidfile for Cassandra ... failed! Steps to reproduce $ docker run -it debian: bash # apt-get update && apt-get install wget gnupg # echo "deb http://www.apache.org/dist/cassandra/debian 311x main" > /etc/apt/sources.list.d/

Token distribution with vnodes and Murmur3Partitioner

2019-01-30 Thread Robert Bialek
391804009 are assigned to the following vnode: start_token:9030094374857346834 end_token:-4188186923391804009 endpoints:[127.0.0.1] rpc_endpoints:[127.0.0.1] Thank you, Robert - To unsubscribe, e-mail: user-unsubscr...@cassand

"Impact of Meltdown patches to DSE performance"

2018-01-25 Thread Robert Stupp
munity as well. — Robert Stupp @snazy signature.asc Description: Message signed with OpenPGP

RequestResponseStage Threadpool

2018-01-24 Thread Robert Emery
the cluster and then never reads the result it would be in the RequestResponseStage Pending until it times out? - Is there any tracing or similar that can be used to inspect the content of the thread-pool so we can see what it actually is that's pending? -- Robert Emery -- <https://co

Creating a copy of a C* cluster

2017-08-07 Thread Robert Wille
advance Robert - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org

Re: Streaming error during repair

2017-01-05 Thread Robert Sicoie
Yes, I am running repairs in one single command. Thanks Paulo! Robert Sicoie On Thu, Jan 5, 2017 at 1:59 PM, Paulo Motta wrote: > Fixed on https://issues.apache.org/jira/browse/CASSANDRA-12905 (still to > be released). If you're running repair of all keyspace or tables in a >

Streaming error during repair

2017-01-05 Thread Robert Sicoie
3.0.5, 5 nodes, NetworkTopologyStrategy, single dc, RF=3 This happened only recently a few times on several different boxes. How worried should I be? Thanks, Robert

Re: Exception thrown on repair after change was made to existing cassandra type

2016-12-06 Thread Robert Sicoie
Thank you Alexander, The restart did the trick. Thank you, Robert Robert Sicoie On Tue, Dec 6, 2016 at 5:00 PM, Alexander Dejanovski wrote: > Hi Robert, > > Some of your nodes did not accept the new schema, or several alter > commands were issued on different nodes concurrent

Re: Exception thrown on repair after change was made to existing cassandra type

2016-12-06 Thread Robert Sicoie
Any suggestion is more than welcome. The fact is that the same alter commands worked in two other environments and now fails in the thirds environment. No downtime is accepted. Thanks, Robert Robert Sicoie On Tue, Dec 6, 2016 at 4:11 PM, Robert Sicoie wrote: > Hi guys, > > I a

Exception thrown on repair after change was made to existing cassandra type

2016-12-06 Thread Robert Sicoie
[na:1.8.0_60]* * at java.lang.Thread.run(Thread.java:745) [na:1.8.0_60]* On the node /x.x.x.y Do you any suggestion? Thank you in advance, Robert

Re: Why does `now()` produce different times within the same query?

2016-11-30 Thread Robert Wille
In my opinion, this is not broken and “fixing” it would break existing code. Consider a batch that includes multiple inserts, each of which inserts the value returned by now(). Getting the same UUID for each insert would be a major problem. Cheers Robert On Nov 30, 2016, at 4:46 PM, Todd

Re: Problem with Jython UDF

2016-11-05 Thread Robert Stupp
;) There’s no way around the sandbox. Scala is “enabled” via a JSR-223 provider - i.e. the same restrictions apply. There’s no special handling for Scala. — Robert Stupp @snazy > On 5 Nov 2016, at 20:36, Maciej Bryński wrote: > > Robert, > Thank you for the answer. > > Do yo

Re: Problem with Jython UDF

2016-11-05 Thread Robert Stupp
better: bytecode) is well defined. However, JavaScript (i.e. the Nashorn implementation) changes. IMHO your “best” option is to switch to Java UDFs. TL;DR Python and probably all script languages except JavaScript don’t work since 3.0. Robert PS: Honestly, looking backwards it was maybe a

Re: Cannot mix counter and non counter columns in the same table

2016-11-01 Thread Robert Wille
I used to think it was terrible as well. But it really isn’t. Just put your non-counter columns in a separate table with the same primary key. If you want to query both counter and non-counter columns at the same time, just query both tables at the same time with asynchronous queries. On Nov 1,

Property file snitch and unbalanced cluster

2016-10-28 Thread Robert Sicoie
node 4 and 5, and then roll restart 4 and 5? Will the cluster balance itself? Currently 1, 2, 3 have about 16GB each and 4,5 about 6 GB each. Thanks, Robert

Re: How to get rid of "Cannot start multiple repair sessions over the same sstables" exception

2016-09-29 Thread Robert Sicoie
Thanks Alexander, After roll restart the blocked repair job stopped and I was able to run repair again. Regards, Robert Robert Sicoie On Wed, Sep 28, 2016 at 6:46 PM, Alexander Dejanovski < a...@thelastpickle.com> wrote: > Robert, > > You can restart them in any order, that

Re: WARN Writing large partition for materialized views

2016-09-29 Thread Robert Sicoie
Thanks! Robert Sicoie On Thu, Sep 29, 2016 at 12:49 PM, Alexander Dejanovski < a...@thelastpickle.com> wrote: > Hi Robert, > > Materialized Views are regular C* tables underneath, so based on their PK > they can generate big partitions. > It is often advised to keep parti

WARN Writing large partition for materialized views

2016-09-28 Thread Robert Sicoie
in the schema design. Thanks, Robert Sicoie

Re: How to get rid of "Cannot start multiple repair sessions over the same sstables" exception

2016-09-28 Thread Robert Sicoie
, Robert Robert Sicoie On Wed, Sep 28, 2016 at 5:35 PM, Alexander Dejanovski < a...@thelastpickle.com> wrote: > They will show up in nodetool compactionstats : https://issues.apache.org/ > jira/browse/CASSANDRA-9098 > > Did you check nodetool tpstats to see if you didn't ha

Re: How to get rid of "Cannot start multiple repair sessions over the same sstables" exception

2016-09-28 Thread Robert Sicoie
, Robert Robert Sicoie On Wed, Sep 28, 2016 at 4:44 PM, Alexander Dejanovski < a...@thelastpickle.com> wrote: > Robert, > > you need to make sure you have no repair session currently running on your > cluster, and no anticompaction. > I'd recommend doing a rolling re

Re: How to get rid of "Cannot start multiple repair sessions over the same sstables" exception

2016-09-28 Thread Robert Sicoie
epair, and I still get this error... Is there a way to continue that hanging repair, if it remained in progress? Thanks, Robert Robert Sicoie On Wed, Sep 28, 2016 at 3:56 PM, Robert Sicoie wrote: > Thanks Alexander, > > Now I started to run the repair with -pr arg and with keyspa

Re: How to get rid of "Cannot start multiple repair sessions over the same sstables" exception

2016-09-28 Thread Robert Sicoie
22791], ..., (4212695343340915405,4229348077081465596]]] Validation failed in / 10.45.113.88" for one of the tables. 10.45.113.88 is the ip of the machine I am running the nodetool on. I'm wondering if this is normal... Thanks, Robert Robert Sicoie On Wed, Sep 28, 2016 at 11:53 AM, Alexa

How to get rid of "Cannot start multiple repair sessions over the same sstables" exception

2016-09-28 Thread Robert Sicoie
I run nodetool repair I get the *java.lang.RuntimeException: Cannot start multiple repair sessions over the same sstables* exception. What do you suggest? would nodetool scrub or sstablescrub help in this case. or it would just make it worse? Thanks, Robert

Re: Transaction failed because of timeout, retry failed because of the first try actually succeeded.

2016-06-30 Thread Robert Wille
I had this problem, and it was caused by my retry policy. For reasons I don’t remember (but is documented in a C* Jira ticket), when onWriteTimeout() is called, you cannot call RetryDecision.retry(cl), as it will be a CL that is incompatible with LWT. After the fix (2.1.?), you can pass null, an

Re: High Heap Memory usage during nodetool repair in Cassandra 3.0.3

2016-06-20 Thread Robert Stupp
see the same behaviour in 3.7 with that setting, there’s not much you can do except upgrading to 3.7 as that change went into 3.6 and not into 3.0.x. — Robert Stupp @snazy > On 20 Jun 2016, at 18:13, Bhuvan Rawal wrote: > > Hi All, > > We are running Cassandra 3.0.3 on Productio

Re: Intermittent CAS error

2016-05-19 Thread Robert Wille
have found a similar bug. The Java driver mailing list is the best place to follow up on this. It can be found at https://groups.google.com/a/lists.datastax.com/forum/#!forum/java-driver-user. On Thu, May 19, 2016 at 12:11 AM, Robert Wille mailto:rwi...@fold3.com>> wrote: When executing b

Intermittent CAS error

2016-05-18 Thread Robert Wille
Obviously, it IS supported because it works most of the time. Is this just a result of not enough replicas, and the error message is jacked up? I’m running 2.1.13. Thanks Robert

MX4J support broken in cassandra 3.0.5?

2016-04-27 Thread Robert Sicoie
guration needed in 3.0.5? Any advice? Thanks, Robert In order to protect our email recipients, the Paddy Power Betfair plc group of companies use MessageLabs to scan all Incoming and Outgoing mail for viruses. Paddy Power Betfair may monitor the content of email sent and received for the

Re: Large primary keys

2016-04-14 Thread Robert Wille
to the document given the document text. -- Jack Krupansky On Mon, Apr 11, 2016 at 7:12 PM, James Carman mailto:ja...@carmanconsulting.com>> wrote: S3 maybe? On Mon, Apr 11, 2016 at 7:05 PM Robert Wille mailto:rwi...@fold3.com>> wrote: I do realize its kind of a weird use case, but it is

Re: Large primary keys

2016-04-11 Thread Robert Wille
index the next time the document is indexed. I will use a digest as the key. I suspected that would be the answer, but its good to get confirmation. Robert On Apr 11, 2016, at 4:36 PM, Jan Kesten wrote: > Hi Robert, > > why do you need the actual text as a key? I sounds a bit unatural

Large primary keys

2016-04-11 Thread Robert Wille
table scan and retrieve all of the texts, so using the digest doesn’t eliminate the need to store the text. Anyway, is it better to keep primary keys small, or is C* okay with large primary keys? Robert

Re: disable compaction if all data are read-only?

2016-04-08 Thread Robert Wille
You still need compaction. Compaction is what organizes your data into levels. Without compaction, every query would have to look at every SSTable. Also, due to commit log rotation, your memtable may get flushed from time to time before it is full, resulting in small SSTables that would benefit

Re: Returning an UDT from a user defined function (UDF)

2016-04-08 Thread Robert Stupp
Hi Henry, there’s https://issues.apache.org/jira/browse/CASSANDRA-10818 <https://issues.apache.org/jira/browse/CASSANDRA-10818> to allow creation of UDTs and tuples. Robert — Robert Stupp @snazy > On Apr 8, 2016, at 07:12, Henry M wrote: > > Whatever I wanted to do does

Re: Adding Options to Create Statements...

2016-04-01 Thread Robert Coli
On Fri, Apr 1, 2016 at 10:43 AM, James Carman wrote: > A, my bad. One might wonder why the heck the Java driver is "owned" > by an outside entity, eh? > FWIW, the status quo prior to the Datastax drivers was a wide assortment of non-compatible drivers in different languages, not one set of

Re: Consistency Level (QUORUM vs LOCAL_QUORUM)

2016-03-31 Thread Robert Coli
On Thu, Mar 31, 2016 at 4:35 AM, Alain RODRIGUEZ wrote: > My understanding is using RF 3 and LOCAL_QUORUM for both reads and writes > will provide a strong consistency and a high availability. One node can go > down and also without lowering the consistency. Or RF = 5, Quorum = 3, > allowing 2 no

Re: Speeding up "nodetool rebuild"

2016-03-30 Thread Robert Coli
On Wed, Mar 30, 2016 at 1:44 PM, Anubhav Kale wrote: > Will changing compactionthroughput and streamingthroughput help with > reducing the “rebuild” time on a brand new node ? We will do it both on the > new node, and the nodes in source DC from where data is streamed. > streamingthroughput yes

Re: How is the coordinator node in LOCAL_QUORUM chosen?

2016-03-25 Thread Robert Coli
On Fri, Mar 25, 2016 at 1:04 PM, X. F. Li wrote: > Suppose I have replication factor 3. If one of the node fails, will > queries with ALL consistency fail if the queried partition is on the failed > node? Or would they continue to work with 2 replicas during the time while > cassandra is replicat

Re: Counter values become under-counted when running repair.

2016-03-24 Thread Robert Coli
On Thu, Mar 24, 2016 at 7:17 AM, Jack Krupansky wrote: > Can you advise us on your thinking when you selected RF=2? > I figure he was probably thinking "I want to operate in a bunch of different regions and don't need to use QUORUM for my use cases, and want to save money by not storing 3 copies

Re: Rack aware question.

2016-03-23 Thread Robert Coli
4209. > > > > So, few questions because things don’t add up: > > > >1. How come 127.0.0.1 is shown as an endpoint holding the ID when its >token range doesn’t contain it ? Does “nodetool ring” shows all >token-ranges for a node or just the primary range ? I am

Re: Rack aware question.

2016-03-23 Thread Robert Coli
On Wed, Mar 23, 2016 at 8:07 AM, Anubhav Kale wrote: > Suppose we change the racks on VMs on a running cluster. (We need to do > this while running on Azure, because sometimes when the VM gets moved its > rack changes). > > In this situation, new writes will be laid out based on new rack info on

Re: Large number of tombstones without delete or update

2016-03-23 Thread Robert Coli
On Wed, Mar 23, 2016 at 9:50 AM, Ralf Steppacher wrote: > How come I end up with that large a number of tombstones? > Are you inserting NULLs? =Rob

Re: Compaction Filter in Cassandra

2016-03-20 Thread Robert Coli
On Fri, Mar 11, 2016 at 10:05 PM, Dikang Gu wrote: > RocksDB has the feature called "Compaction Filter" to allow application to > modify/delete a key-value during the background compaction. > https://github.com/facebook/rocksdb/blob/v4.1/include/rocksdb/options.h#L201-L226 > > I'm wondering is th

Re: Read consistency

2016-03-19 Thread Robert Coli
On Tue, Mar 15, 2016 at 6:43 PM, Arko Provo Mukherjee < arkoprovomukher...@gmail.com> wrote: > I am designing a system where for a situation, I need to have SERIAL > consistency during writes. > Be sure to understand the implications of : https://issues.apache.org/jira/browse/CASSANDRA-9328 =Ro

Re: Deploy latest cassandra on top of datastax-ddc ?

2016-03-19 Thread Robert Coli
On Thu, Mar 17, 2016 at 10:38 PM, Mohamed Lrhazi < mohamed.lrh...@georgetown.edu> wrote: > Would simply overriding this one jar file do it? else could you please > share a procedure? > This seems like an odd thing to want to do. Why do you believe it is likely to work? =Rob

Re: Deploy latest cassandra on top of datastax-ddc ?

2016-03-18 Thread Robert Coli
On Fri, Mar 18, 2016 at 5:00 PM, Mohamed Lrhazi < mohamed.lrh...@georgetown.edu> wrote: > FYI.. for the curious.. what I did resulted in a cluster where i tested > these two things: > ... > I have no inclination to keep using such a setup.. just reporting the > experiment :) > FWIW, given the gen

Re: Deploy latest cassandra on top of datastax-ddc ?

2016-03-18 Thread Robert Coli
On Fri, Mar 18, 2016 at 2:18 PM, Mohamed Lrhazi < mohamed.lrh...@georgetown.edu> wrote: > So, after doing an ant build from the latest source... how would one > "install" or deploy cassandra? Could not find a document on the install > from source part... any pointers? All I find makes use of yum

Re: Cassandra Upgrade 3.0.x vs 3.x (Tick-Tock Release)

2016-03-14 Thread Robert Coli
On Mon, Mar 14, 2016 at 12:40 PM, Kathiresan S wrote: > We are planning for Cassandra upgrade in our production environment. > Which version of Cassandra is stable and is advised to upgrade to, at the > moment? > https://www.eventbrite.com/engineering/what-version-of-cassandra-should-i-run/ (IO

Re: Regarding cassandra-stress results

2016-03-14 Thread Robert Coli
On Mon, Mar 14, 2016 at 11:38 AM, Rajath Subramanyam wrote: > When cassandra-stress tool dumps the output at the end of the benchmarking > run, what is the unit of latency statistics ? > This is becoming a FAQ. Perhaps the docs for the tool (and/or the tool itself) should be modified to specify

Re: JMX liveSSTableCount

2016-03-11 Thread Robert Coli
On Fri, Mar 11, 2016 at 10:04 AM, Hazel Bobins wrote: > Does anyone know if the removal of the liveSSTableCount JMX attribute > from the 'org.apache.cassandra.db:type=Tables,keyspaces=' mbean was > intentional in 3.x? I can not see reference to its removal in any Jira etc > Yukim@IRC sends this

Re: ntpd clock sync

2016-03-10 Thread Robert Coli
On Wed, Mar 9, 2016 at 9:03 AM, K F wrote: > the clock is about 30 to 40 seconds behind. > If you don't want to get ntp working there, why not just... manually... set the clocks? =Rob

Re: How can I make Cassandra stable in a 2GB RAM node environment ?

2016-03-10 Thread Robert Coli
On Thu, Mar 10, 2016 at 3:27 AM, Alain RODRIGUEZ wrote: > So, like Jack, I globally really not recommend it unless you know what you > are doing and don't care about facing those issues. > Certainly a spectrum of views here, but everyone (including OP) seems to agree with the above. :D =Rob

Re: Unexplainably large reported partition sizes

2016-03-09 Thread Robert Coli
On Mon, Mar 7, 2016 at 1:25 PM, Nate McCall wrote: > >> Rob, can you remember which bug/jira this was? I have not been able to >> find it. >> I'm using 2.1.9. >> > > https://issues.apache.org/jira/browse/CASSANDRA-7953 > > Rob may have a different one, but I've something similar from this issue.

Re: How can I make Cassandra stable in a 2GB RAM node environment ?

2016-03-07 Thread Robert Coli
On Fri, Mar 4, 2016 at 8:27 PM, Jack Krupansky wrote: > Please review the minimum hardware requirements as clearly documented: > > http://docs.datastax.com/en/cassandra/3.x/cassandra/planning/planPlanningHardware.html > That is a document for Datastax Cassandra, not Apache Cassandra. It's wonder

Re: Unexplainably large reported partition sizes

2016-03-07 Thread Robert Coli
On Sat, Mar 5, 2016 at 9:16 AM, Tom van den Berge wrote: > I don't think compression can be the cause of the difference, because of > two reasons: > Your two reasons seem legitimate. Though you say you do not frequently do DELETE and so it shouldn't be due to tombstones, there are semi-recent v

Re: moving keyspaces to another disk while Cassandra is running

2016-03-07 Thread Robert Coli
On Mon, Mar 7, 2016 at 2:57 AM, Krzysztof Księżyk wrote: > I see on lsof output that even if keyspace > is not queried, Cassandra keeps files opened, so I guess it's not safe to > hotswap, but I'd like to make sure. > It is not safe for exactly this reason. Just restart your nodes. Were I doing

Re: Unexplainably large reported partition sizes

2016-03-04 Thread Robert Coli
On Fri, Mar 4, 2016 at 5:56 AM, Tom van den Berge wrote: > Compacting large partition > drillster/subscriberstats:rqtPewK-1chi0JSO595u-Q (1,470,058,292 bytes) > > This means that this single partition is about 1.4GB large. This is much > larger that it can possibly be, because of two reasons: >

Re: Broken links in Apache Cassandra home page

2016-03-02 Thread Robert Coli
On Wed, Mar 2, 2016 at 7:00 AM, Eric Evans wrote: > On Tue, Mar 1, 2016 at 8:30 PM, ANG ANG wrote: > > "#cassandra channel": http://freenode.net/ > > The latter, while not presently useful, links to a "coming soon..." > for Freenode. It might be pedantic to insist it's not broken, but I > don't

Re: Snitch for AWS EC2 nondefaultVPC

2016-03-02 Thread Robert Coli
On Wed, Mar 2, 2016 at 7:21 AM, Arun Sandu wrote: > > All the nodes in both datacenters are in DSE Search Mode(Solr). We may > have analytics datacenter as well in future. Will this have any impact in > using Ec2MultiRegionSnitch? > This list does not support DSE, but as I understand it, they cre

Re: Removing Node causes bunch of HostUnavailableException

2016-03-02 Thread Robert Coli
On Wed, Mar 2, 2016 at 8:10 AM, Peddi, Praveen wrote: > We have few dead nodes in the cluster (Amazon ASG removed those thinking > there is an issue with health). Now we are trying to remove those dead > nodes from the cluster so that other nodes can take over. As soon as I > execute nodetool rem

Re: Snitch for AWS EC2 nondefaultVPC

2016-03-01 Thread Robert Coli
On Tue, Mar 1, 2016 at 12:12 PM, Arun Sandu wrote: > All our nodes are launched in AWS EC2 VPC (private). We have 2 > datacenters(1 us-east , 1- asiapacific) and all communication is through > private IP's and don't have any public IPs. What is the recommended snitch > to be used? We currently ha

Re: List of List

2016-03-01 Thread Robert Coli
On Tue, Mar 1, 2016 at 3:23 PM, Jonathan Haddad wrote: > Thrift is deprecated, and will be removed in Cassandra 4.0 Don't do any > new development with it. > +infinity this. =Rob

Re: Practical limit on number of column families

2016-02-29 Thread Robert Wille
Yes, there is memory overhead for each column family, effectively limiting the number of column families. The general wisdom is that you should limit yourself to a few hundred. Robert On Feb 29, 2016, at 10:30 AM, Fernando Jimenez mailto:fernando.jime...@wealth-port.com>> wrote: Hi

Re: Handling uncommitted paxos state

2016-02-25 Thread Robert Coli
On Thu, Feb 25, 2016 at 1:23 AM, Nicholas Wilson < nicholas.wil...@realvnc.com> wrote: > If a WriteTimeoutException with WriteType.SIMPLE is thrown for a CAS > write, that means that the paxos phase was successful, but the data > couldn't be committed during the final 'commit/reset' phase. On the

Re: copy and rename sstable files as keyspace migration approach

2016-02-23 Thread Robert Coli
On Tue, Feb 23, 2016 at 6:44 AM, Jarod Guertin wrote: > Being fairly new to Cassandra, I'd like to run the following with the > experts to make sure it's an ok thing to do. > > We have a particular case where we have multiple keyspaces with multiple > tables each and we want to migrate to a new u

Re: Cassandra nodes reduce disks per node

2016-02-17 Thread Robert Coli
On Tue, Feb 16, 2016 at 11:29 PM, Anishek Agarwal wrote: > > To accomplish this can I just copy the data from disk1 to disk2 with in > the relevant cassandra home location folders, change the cassanda.yaml > configuration and restart the node. before starting i will shutdown the > cluster. > Yes.

Re: Sudden disk usage

2016-02-16 Thread Robert Coli
On Sat, Feb 13, 2016 at 4:30 PM, Branton Davis wrote: > We use SizeTieredCompaction. The nodes were about 67% full and we were > planning on adding new nodes (doubling the cluster to 6) soon. > Be sure to add those new nodes one at a time. Have you checked for, and cleared, old snapshots? Snap

Re: Restart Cassandra automatically

2016-02-09 Thread Robert Coli
On Tue, Feb 9, 2016 at 6:20 AM, wrote: > Call me naïve, but we do use an in-house built program for keeping nodes > started (based on a flag-check). The program is something that was written > for all kinds of daemon processes here, not Cassandra specifically. The > basic idea is that is runs a s

Re: Cassandra Collections performance issue

2016-02-08 Thread Robert Coli
On Mon, Feb 8, 2016 at 2:10 PM, Agrawal, Pratik wrote: > Recently we added one of the table fields from as Map in > *Cassandra > 2.1.11*. Currently we read every field from Map and overwrite map values. > Map is of size 3. We saw that writes are 30-40% slower while reads are > 70-80% slower. Ple

Re: Restart Cassandra automatically

2016-02-05 Thread Robert Coli
On Thu, Feb 4, 2016 at 8:26 PM, Debraj Manna wrote: > What is the best way to keep cassandra running? My requirement is if for > some reason cassandra stops then it should get started automatically. > I recommend against this mode of operation. When automatically restarting, you have no idea how

Re: "Not enough replicas available for query" after reboot

2016-02-04 Thread Robert Coli
On Thu, Feb 4, 2016 at 12:53 PM, Flavien Charlon wrote: > My cluster was running fine. I rebooted all three nodes (one by one), and > now all nodes are back up and running. "nodetool status" shows UP for all > three nodes on all three nodes: > > -- AddressLoad Tokens OwnsHost

Re: Want inputs about super column family vs map/list

2016-02-04 Thread Robert Coli
On Thu, Feb 4, 2016 at 2:37 AM, Bhuvan Rawal wrote: > 1. Using super column family: > Super columns have been not-recommended for use for about five years now. =Rob

Re: Duplicated key with an IN statement

2016-02-04 Thread Robert Wille
You shouldn’t be using IN anyway. It is better to issue multiple queries, each for a single key, and issue them in parallel. Better performance. Less GC pressure. On Feb 4, 2016, at 7:54 AM, Sylvain Lebresne mailto:sylv...@datastax.com>> wrote: That behavior has been changed in 2.2 and upwards

Re: Re : Possibility of using 2 different snitches in the Multi_DC cluster

2016-02-02 Thread Robert Coli
On Tue, Feb 2, 2016 at 1:23 PM, sai krishnam raju potturi < pskraj...@gmail.com> wrote: > What is the possibility of using GossipingPropertFileSnitch on datacenters > in our private cloud, and Ec2MultiRegionSnitch in AWS? > You should just use GPFS everywhere. This is also the reason why you sho

Re: Session timeout

2016-01-29 Thread Robert Coli
On Fri, Jan 29, 2016 at 3:12 PM, Jack Krupansky wrote: > One last time, I'll simply renew my objection to the way you are abusing > this list. > FWIW, while I appreciate that OP (Oleg) is attempting to do a service for the community, I agree that the flood of single topic, context-lacking posts

Re: Rename Keyspace offline

2016-01-27 Thread Robert Coli
On Wed, Jan 27, 2016 at 6:49 AM, Jean Tremblay < jean.tremb...@zen-innovations.com> wrote: > Since it takes me 2 days to load my data, I was planning to load the new > set on a new keyspace (KS-Y), and when loaded drop KS-X and rename KS-Y to > KS-X. > Why bother with the rename? Just have two ke

Re: Strategy / order for upgradesstables during rolling upgrade.

2016-01-21 Thread Robert Coli
On Thu, Jan 21, 2016 at 11:37 AM, Kevin Burton wrote: > I think there are two strategies to upgradesstables after a release. > > We're doing a 2.0 to 2.1 upgrade (been procrastinating here). > > I think we can go with B below... Would you agree? > > Strategy A: > > - foreach server >

Re: Using cassandra a BLOB store / web cache.

2016-01-19 Thread Robert Coli
On Tue, Jan 19, 2016 at 2:07 PM, Richard L. Burton III wrote: > I would ask why do this over say HDFS, S3, etc. seems like this problem > has been solved with other solutions that are specifically designed for > blob storage? > HDFS's default block size is 64mb. If you are storing objects smalle

Re: Using cassandra a BLOB store / web cache.

2016-01-19 Thread Robert Coli
On Mon, Jan 18, 2016 at 6:52 PM, Kevin Burton wrote: > Internally we have the need for a blob store for web content. It's MOSTLY > key, ,value based but we'd like to have lookups by coarse grained tags. > I know you know how to operate and scale MySQL, so I suggest MogileFS for the actual blob

Re: Cassandra Performance on a Single Machine

2016-01-14 Thread Robert Wille
I disagree. I think that you can extrapolate very little information about RF>1 and CL>1 by benchmarking with RF=1 and CL=1. On Jan 13, 2016, at 8:41 PM, Anurag Khandelwal mailto:anur...@berkeley.edu>> wrote: Hi John, Thanks for responding! The aim of this benchmark was not to benchmark Cassa

Re: max connection per user

2016-01-13 Thread Robert Coli
On Wed, Jan 13, 2016 at 1:41 PM, oleg yusim wrote: > Quick question, here: does Cassandra have a configuration switch to limit > number of connections per user (protection of DoS attack, security)? > Quick answer : no. =Rob

Re: Help debugging a very slow query

2016-01-13 Thread Robert Coli
On Wed, Jan 13, 2016 at 12:40 PM, Bryan Cheng wrote: > 1) What's up with the megapartition? What's the best way to debug this? > Our data model is largely write once, we don't do any updates. We do > DELETE, but the partitions that are giving us issues haven't been removed. > We had some suspicio

Re: Repair with "-pr" and vnodes

2016-01-12 Thread Robert Coli
On Tue, Jan 12, 2016 at 3:46 PM, Roman Tkachenko wrote: > The documentation for the "-pr" repair option says it repairs only the > first range returned by the partitioner. However, with vnodes a node owns a > lot of small ranges. > > Does that mean that if I run rolling "nodetool repair -pr" on t

Re: Cassandra 1.2.19 and Java 8

2016-01-12 Thread Robert Coli
On Tue, Jan 12, 2016 at 2:31 PM, Tim Heckman wrote: > We still have an installation of Cassandra on the 1.2.19 release, > running on Java 7. We do plan on upgrading to a newer version, but in > the mean time there has been some questions internally about running > 1.2 on Java 8 until the upgrade

Re: Sorting & pagination in apache cassandra 2.1

2016-01-12 Thread Robert Coli
On Mon, Jan 11, 2016 at 11:30 PM, anuja jain wrote: > 1 more question, what does it mean by "cassandra inherently sorts data"? > SSTable = Sorted Strings Table. It doesn't contain "Strings" anymore, really, but that's a hint.. :) =Rob

Re: Too many compactions, maybe keyspace system?

2016-01-12 Thread Robert Coli
On Mon, Jan 11, 2016 at 9:12 PM, Shuo Chen wrote: > I have a assumption that, lots of pending compaction tasks jam the memory > and raise full gc. The full chokes the process and slows down compaction. > And this causes more pending compaction tasks and more pressure on memory. > The question is

Re: Too many compactions, maybe keyspace system?

2016-01-11 Thread Robert Coli
The lines you are looking for look like this : INFO [CompactionExecutor:48] 2016-01-12 09:07:59,995 CompactionTask.java (line 120) Compacting [SSTableReader(path='/usr/local/cassandra/data/system/sstable_activity/system-sstable_activity-jb-4959-Data.db'), SSTableReader(path='/usr/local/cassandra/d

Re: Too many compactions, maybe keyspace system?

2016-01-11 Thread Robert Coli
On Sat, Jan 9, 2016 at 8:23 AM, Shuo Chen wrote: > I don't know what exactly compaction logs is like in system.log. But I see > logs like this in system.log, I think maybe this is the compaction log > grep -i compact /path/to/system.log =Rob

Re: Too many compactions, maybe keyspace system?

2016-01-08 Thread Robert Coli
On Thu, Jan 7, 2016 at 6:30 PM, Shuo Chen wrote:, > > I am using Cassandra 2.0.16 with 4 nodes and found too many compactions > for this cluster. This caused too much full gc and choked the system. I > have discussed the high gc in previous mails but didnot get the satisfied > answers. > > To clar

Re: Data rebalancing algorithm

2016-01-08 Thread Robert Coli
On Thu, Jan 7, 2016 at 11:42 PM, Jonathan Haddad wrote: > num_tokens is the number of tokens per node, not per cluster. > MySQL docs are enumerated in the manual along with their scope. I have seen the enumeration in the Cassandra docs, but I don't remember seeing scope there. Perhaps a useful s

Re: Revisit Cassandra EOL Policy

2016-01-08 Thread Robert Coli
On Fri, Jan 8, 2016 at 9:45 AM, Anuj Wadehra wrote: > *"Unfortunately how to get firm agreement on what criteria should be used > to judge "Production Ready" is unclear."* > Only you know how comfortable you are with the various types of risk that are involved in a particular version choice giv

Re: Revisit Cassandra EOL Policy

2016-01-07 Thread Robert Coli
On Wed, Jan 6, 2016 at 5:26 PM, Anuj Wadehra wrote: > I would like to understand how various users are dealing with the > situation. Are you upgrading Cassandra every 3-6 mths? How do you cut short > your planning,test and release cycles for Cassandra upgrades in your > application/products? > I

Re: CQL Composite Key Seen After Table Creation

2016-01-06 Thread Robert Coli
On Wed, Jan 6, 2016 at 12:54 PM, Chris Burroughs wrote: > I work with Amir and further experimentation I can shed a little more > light on what exactly is going on under the hood. For background our goal > is to take data that is currently being read and written to via thrift, > switch reads to

Re: Slow performance after upgrading from 2.0.9 to 2.1.11

2016-01-06 Thread Robert Coli
On Wed, Jan 6, 2016 at 11:49 AM, Peddi, Praveen wrote: > 2nd column is replication factor (RF). I have 2 rows for reads and 2 for > writes. First row is RF=1 and 2nd row is RF=3. So when I said increasing RF > , I meant from 1 to 3. Sorry the table is probably not clear. > Ah, I see now, I was m

  1   2   3   4   5   6   7   8   9   10   >