Re: A connection attempt failed

2015-02-04 Thread Rene Kochen
After a little testing I see that the client has a time-out because the server takes longer. This large batch_mutate took 5 seconds in Cassandra 1.0.11 The same batch_mutate takes three minutes in Cassandra 1.2.18 Is that normal!? Thanks, Rene 2015-02-04 18:29 GMT+01:00 Rene Kochen : >

A connection attempt failed

2015-02-04 Thread Rene Kochen
Hi all, I have a problem with my client on Cassandra 1.2.18 which I did not have on Cassandra 1.0.11 I create a big row with a lot of super-columns. When writing that row using batch_mutate, I receive the following error in my client: "A connection attempt failed because the connected party did

Re: Communication between data-centers

2014-08-14 Thread Rene Kochen
n Thu, Aug 14, 2014 at 4:53 PM, Rene Kochen > wrote: > >> Hi all, >> >> I have a question about communication between two data-centers, both with >> replication-factor three. >> >> If I read data using local_quorum from datacenter1, I see that digest >>

Communication between data-centers

2014-08-14 Thread Rene Kochen
Hi all, I have a question about communication between two data-centers, both with replication-factor three. If I read data using local_quorum from datacenter1, I see that digest requests are sent to datacenter2. This is for read-repair I guess. How can I prevent this from happening? Setting read_

Re: Make an existing cluster multi data-center compatible.

2014-08-05 Thread Rene Kochen
des in the same data-center and rack. Thanks again! Rene 2014-08-05 20:05 GMT+02:00 Robert Coli : > On Tue, Aug 5, 2014 at 3:52 AM, Rene Kochen > wrote: > >> Do I have to run full repairs after this change? Because the yaml file >> states: IF YOU CHANGE THE SNITCH AFTER DA

Re: Make an existing cluster multi data-center compatible.

2014-08-05 Thread Rene Kochen
nitch puts all endpoints in the same data-center and rack, isn't the result of the endpoint selection basically the same? Thanks! Rene 2014-08-05 12:56 GMT+02:00 Mark Reddy : > Yes, you must run a full repair for the reasons stated in the yaml file. > > > Mark > > > O

Make an existing cluster multi data-center compatible.

2014-08-05 Thread Rene Kochen
Hi all, I want to add a data-center to an existing single data-center cluster. First I have to make the existing cluster multi data-center compatible. The existing cluster is a 12 node cluster with: - Replication factor = 3 - Placement strategy = SimpleStrategy - Endpoint snitch = SimpleSnitch I

Re: nodetool cfhistograms refresh

2013-10-01 Thread Rene Kochen
Thanks! Does that mean that cfhistograms scans all Statistics.db files in order to populate the "Row Size" and "Column Count" values? 2013/10/1 Tyler Hobbs > > On Tue, Oct 1, 2013 at 2:34 PM, Rene Kochen > wrote: > >> However, "Row Size" a

Re: nodetool cfhistograms refresh

2013-10-01 Thread Rene Kochen
If I look at Read Latency I see indeed that they are reset during two runs of cfhistograms. However, "Row Size" and "Column Count" keep the values. When are they re-evaluated? Thanks! Rene 2013/10/1 Richard Low > On 1 October 2013 16:21, Rene Kochen wrote: > >

nodetool cfhistograms refresh

2013-10-01 Thread Rene Kochen
Quick question. I am using Cassandra 1.0.11 When is nodetool cfhistograms output reset? I know that data is collected during read requests. But I am wondering if it is data since the beginning (start of Cassandra) or if it is reset periodically? Thanks! Rene

Re: Row size in cfstats vs cfhistograms

2013-09-20 Thread Rene Kochen
Nice! Thats explains it. 2013/9/19 Robert Coli > On Thu, Sep 19, 2013 at 3:08 AM, Rene Kochen wrote: > >> And how does cfstats track the maximum size? What does "Compacted" mean >> in "Compacted row maximum size". >> > > That maximum size

Re: Row size in cfstats vs cfhistograms

2013-09-19 Thread Rene Kochen
That is indeed how I read it. The maximal size is 3 rows with an offset of 126934, while cfstats reports 43388628. Thanks, Rene 2013/9/19 Richard Low > On 19 September 2013 10:31, Rene Kochen wrote: > > I use Cassandra 1.0.11 >> >> If I do cfstats for a particular c

Re: Row size in cfstats vs cfhistograms

2013-09-19 Thread Rene Kochen
sponse to the read request, while > cfstats tracks the largest row stored on given node. > > M. > > W dniu 19.09.2013 11:31, Rene Kochen pisze: > > Hi all, >> >> I use Cassandra 1.0.11 >> >> If I do cfstats for a particular column family, I see a

Row size in cfstats vs cfhistograms

2013-09-19 Thread Rene Kochen
Hi all, I use Cassandra 1.0.11 If I do cfstats for a particular column family, I see a "Compacted row maximum size" of 43388628 However, when I do a cfhistograms I do not see such a big row in the Row Size column. The biggest row there is 126934. Can someone explain this? Thanks! Rene

Re: Cluster processing not balanced

2013-06-28 Thread Rene Kochen
reside on the first node (actually the first three nodes because of the replication factor of three). Thanks, Rene 2013/6/28 Rene Kochen > Hi All, > > I have the following situation: > > - Cassandra 1.0.11 > - A 6 node cluster > - Random partitioner > - Tokens are bal

Cluster processing not balanced

2013-06-28 Thread Rene Kochen
Hi All, I have the following situation: - Cassandra 1.0.11 - A 6 node cluster - Random partitioner - Tokens are balanced (according to node-tool) - Data-load is balanced (according to node-tool) I have a customers column-family with 100 customers. I also have a test client which requests ran

Re: Backup solution

2013-03-18 Thread Rene Kochen
ve DC) will take too long. I expect the data to grow significantly. It makes more sense to use the second cluster as a hot standby (and make snapshots on both clusters). Rene 2013/3/16 Aaron Turner > On Fri, Mar 15, 2013 at 10:35 AM, Rene Kochen > wrote: > > Hi Aaron, > > >

Re: Backup solution

2013-03-15 Thread Rene Kochen
put the backup cluster close to the live cluster with a gigabit connection only for Cassandra. Thanks! Rene 2013/3/15 Aaron Turner > On Fri, Mar 15, 2013 at 3:12 AM, Rene Kochen > wrote: > > Thank you. I have a high bandwidth connection. But that also means that > > regu

Re: Backup solution

2013-03-15 Thread Rene Kochen
the data is going from one data centre to > another, unless you have a high bandwidth connection between data centres > or you have a small amount of data. > > Jabbar Azam > On 14 Mar 2013 14:31, "Rene Kochen" wrote: > >> Hi all, >> >> Is the follo

Backup solution

2013-03-14 Thread Rene Kochen
Hi all, Is the following a good backup solution. Create two data-centers: - A live data-center with multiple nodes (commodity hardware). Clients connect to this cluster with LOCAL_QUORUM. - A backup data-center with 1 node (with fast SSDs). Clients do not connect to this cluster. Cluster only us

Re: UnreachableNodes

2012-10-18 Thread Rene Kochen
> If is still shows as down can you post the output from nodetool gossipinfo > from 9.109 and the node that sees 9.109 as down. > > Cheers > > > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 18/

UnreachableNodes

2012-10-18 Thread Rene Kochen
I have a four node EC2 cluster. Three machines show via nodetool ring that all machines are UP. One machine shows via nodetool ring that one machine is DOWN. If I take a closer to the machine reporting the other machine as down, I see the following: - StorageService.UnreachableNodes = 10.49.9.10

The compaction task cannot delete sstables which are used in a repair session

2012-09-25 Thread Rene Kochen
Is this a bug? I'm using Cassandra 1.0.11: INFO 13:45:43,750 Compacting [SSTableReader(path='d:\data\Traxis\Parameters-hd-47-Data.db'), SSTableReader(path='d:\data\Traxis\Parameters-hd-44-Data.db'), SSTableReader(path='d:\data\Traxis\Parameters-hd-46-Data.db'), SSTableReader(path='d:\data\Traxis\P

Re: Many ParNew collections

2012-09-17 Thread Rene Kochen
ry_compaction_limit in the yaml. Note this > is often a simple / quick fix that can increase IO load and slow down > compaction. The harder thing is to tune the JVM memory settings (the > defaults often do a good job). > > Hope that helps. > > - > Aaron Morton &g

Re: minor compaction and delete expired column-tombstones

2012-09-17 Thread Rene Kochen
> - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 15/09/2012, at 6:32 AM, Rene Kochen wrote: > > Hi all, > > Does minor compaction delete expired column-tombstones when the row is > also present in another

minor compaction and delete expired column-tombstones

2012-09-14 Thread Rene Kochen
Hi all, Does minor compaction delete expired column-tombstones when the row is also present in another table which is not subject to the minor compaction? Example: Say there are 5 SStables: - Customers_0 (10 MB) - Customers_1 (10 MB) - Customers_2 (10 MB) - Customers_3 (10 MB) - Customers_4 (30

Re: Many ParNew collections

2012-09-14 Thread Rene Kochen
onmorton > http://www.thelastpickle.com > > On 17/08/2012, at 2:58 AM, Rene Kochen wrote: > > Hi > > I have a cluster of 7 nodes: > > - Windows Server 2008 > - Cassandra 0.7.10 > - The nodes are identical (hardware, configuration and client request load) > -

Re: High commit size

2012-09-10 Thread Rene Kochen
l the RAM of the machine, but you won't run into swapping > hell. > > So, disable mmap, benchmark it, and see if it outperforms running with > mmap. I'm pretty sure you will find that it does. > > > /Henrik > > > On Mon, Sep 10, 2012 at 4:02 PM, Rene Kochen > wr

Re: High commit size

2012-09-10 Thread Rene Kochen
mains the property of the sender. You must not use, > disclose, distribute, copy, print or rely on this e-mail. If you have > received this message in error, please contact the sender immediately and > irrevocably delete this message and any copies. > > *From:* Rene Kochen [mailto:re

Re: High commit size

2012-09-10 Thread Rene Kochen
r support Windows as our production platform. > > Regards, > Oleg > > > On 2012-09-10 09:00:02 +, Rene Kochen said: > > Hi all, >> >> On my test cluster I have three Windows Server 2008 R2 machines running >> Cassandra 1.0.11 >> >> If i

Re: Node-tool drain on Cassandra 1.0

2012-09-08 Thread Rene Kochen
) Restart Cassandra Thanks Rene 2012/9/7 Rob Coli > On Fri, Sep 7, 2012 at 6:38 AM, Rene Kochen > wrote: > > If I use node-tool drain, it does stop accepting writes and flushes the > > tables. However, is it normal that the commit log files are not deleted > and >

Node-tool drain on Cassandra 1.0

2012-09-07 Thread Rene Kochen
Hi All, I have a question about node-tool drain on a single Cassandra 1.0.11 node: If I use node-tool drain, it does stop accepting writes and flushes the tables. However, is it normal that the commit log files are not deleted and that it gets replayed? Because if I do the following: 1) Write s

Re: ColumnFamilies.ReadCount

2012-08-20 Thread Rene Kochen
Okay, thanks for the info! I was just trying to understand what I saw. 2012/8/20 Tyler Hobbs : > > > On Sun, Aug 19, 2012 at 6:27 AM, Rene Kochen > wrote: >> >> >> Why does it not increase when servicing a range operation? > > > It doesn't becau

ColumnFamilies.ReadCount

2012-08-19 Thread Rene Kochen
Hi All, I have a question about the ColumnFamilies.ReadCount counter. I use: - One node. - Cassandra 1.0.10. - No row cache. - One table "Products" containing a few rows If I use the cli command "list Products", the ColumnFamilies.ReadCount counter does not increase (also via nodetool cfstats).

Many ParNew collections

2012-08-16 Thread Rene Kochen
Hi I have a cluster of 7 nodes: - Windows Server 2008 - Cassandra 0.7.10 - The nodes are identical (hardware, configuration and client request load) - Standard batch file with 8GB heap - I use disk_access_mode = standard - Random partitioner - TP stats shows no problems - Ring command shows no pr

RE: Node down

2012-02-02 Thread Rene Kochen
what gossip is telling it. Add it as a new line at the bottom of cassandra-env.sh. If it's still failing watch the logs and see what it says when it marks the other as been down. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 1/02/201

Node down

2012-02-01 Thread Rene Kochen
I have a cluster with seven nodes. If I run the node-tool ring command on all nodes, I see the following: Node1 says that node2 is down. Node 2 says that node1 is down. All other nodes say that everyone is up. Is this normal behavior? I see no network related problems. Also no problems between

RE: Garbage collection freezes cassandra node

2012-01-20 Thread Rene Kochen
Thanks for this very helpful info. It is indeed a production site which I cannot easily upgrade. I will try the various gc knobs and post any positive results. -Original Message- From: sc...@scode.org [mailto:sc...@scode.org] On Behalf Of Peter Schuller Sent: vrijdag 20 januari 2012 4:23

RE: Garbage collection freezes cassandra node

2012-01-19 Thread Rene Kochen
Thanks for your comments. The application is indeed suffering from a freezing Cassandra node. Queries are taking longer than 10 seconds at the moment of a full garbage collect. Here is an example from the logs. I have a three node cluster. At some point I see on a node the following log: 21:53

RE: Garbage collection freezes cassandra node

2011-12-23 Thread Rene Kochen
Thanks for your quick response! I am currently running the performance tests with extended gc logging. I will post the gc logging if clients time out at the same moment that the full garbage collect runs. Thanks Rene -Original Message- From: sc...@scode.org [mailto:sc...@scode.org] On

RE: Question about minor compaction

2011-11-04 Thread Rene Kochen
: Question about minor compaction On Fri, Nov 4, 2011 at 5:22 PM, Rene Kochen wrote: > Thanks for your quick response. > > I indeed see that similar sized files are compacted. However, for four > similar 1GB files, this is not what I see. > > The documentation states: > &g

RE: Question about minor compaction

2011-11-04 Thread Rene Kochen
ely (when there are four similar sized files), but waits (up to 32)? Thanks! -Original Message- From: Radim Kolar [mailto:h...@sendmail.cz] Sent: vrijdag 4 november 2011 16:48 To: user@cassandra.apache.org Subject: Re: Question about minor compaction Dne 4.11.2011 16:16, Rene Kochen napsal

RE: Question about minor compaction

2011-11-04 Thread Rene Kochen
I'm using Cassandra 0.7.9. Ok, so in this version, Cassandra waits with compaction. But when (in my original example) are the four 1GB files compacted? Thanks! -Original Message- From: Radim Kolar [mailto:h...@sendmail.cz] Sent: vrijdag 4 november 2011 15:55 To: user@cassandra.apache.o

Question about minor compaction

2011-11-04 Thread Rene Kochen
Assume the following default settings: min_compaction_threshold = 4, max_compaction_threshold = 32. When I start a bulk insert in Cassandra, I see minor compactions work: all similar sized files are compacted when there are four of them. However, when files gets larger, Cassandra waits with min

TotalDiskSpaceUsed and LiveDiskSpaceUsed

2011-10-24 Thread Rene Kochen
What is the difference between these JMX column family attributes: TotalDiskSpaceUsed and LiveDiskSpaceUsed Thanks! Rene

RE: log line question

2011-10-21 Thread Rene Kochen
- From: Sylvain Lebresne [mailto:sylv...@datastax.com] Sent: vrijdag 21 oktober 2011 13:16 To: user@cassandra.apache.org Subject: Re: log line question On Fri, Oct 21, 2011 at 12:48 PM, Rene Kochen wrote: > Given the following log line: > > > > DEBUG [ReadStage:20] 11:39:07,028

log line question

2011-10-21 Thread Rene Kochen
Given the following log line: DEBUG [ReadStage:20] 11:39:07,028 collecting 0 of 2147483647: SuperColumn(2150726f70657274696573 [64617461:false:4@1319189945952058,]) What does "false:4" in the column mean? Thanx! Rene

RE: Hinted handoff question

2011-10-07 Thread Rene Kochen
good idea to upgrade to the latest stable release before spending a lot of time debugging :) On Fri, Oct 7, 2011 at 8:33 AM, Rene Kochen wrote: > If I trigger hint delivery using JMX, it works. I see in the log: > > > > 2011-10-07 15:17:51,216 INFO 15:17:51,216 Started hinted ha

RE: Hinted handoff question

2011-10-07 Thread Rene Kochen
deliver them if you restart it (i think). Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 6/10/2011, at 11:40 PM, Rene Kochen wrote: Node 3 is up (using ring on node 1). There is no HH task (active = 0, pending = 0, completed

RE: Hinted handoff question

2011-10-06 Thread Rene Kochen
/10/2011, at 10:35 PM, Rene Kochen wrote: I'am using Cassandra 0.7.7 and have a question about hinted handoff. I have a cluster of three nodes. I stop node 3. I see that the hint count for node 3 increases on node 1 (countPendingHints = 28709). However, when I start node 3 again, I ca

Hinted handoff question

2011-10-06 Thread Rene Kochen
I'am using Cassandra 0.7.7 and have a question about hinted handoff. I have a cluster of three nodes. I stop node 3. I see that the hint count for node 3 increases on node 1 (countPendingHints = 28709). However, when I start node 3 again, I cannot see anything in the log regarding hinted handoff

Flushing behavior in Cassandra 0.8

2011-06-21 Thread Rene Kochen
I try to understand the flushing behavior in Cassandra 0.8 When I create rows, after a few seconds, I see the following line in the log: INFO 11:18:46,470 flushing high-traffic column family ColumnFamilyStore(table='Traxis', columnFamily='Customers') INFO 11:18:46,471 Enqueuing flush of Memtabl

RE: MemoryMeter uninitialized (jamm not specified as java agent)

2011-06-20 Thread Rene Kochen
aux | grep javaagent The args to the java process should include -javaagent:bin/../lib/jamm-0.2.2.jar Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 17 Jun 2011, at 22:18, Rene Kochen wrote: Since using cassandra 0.8, I see the followi

MemoryMeter uninitialized (jamm not specified as java agent)

2011-06-17 Thread Rene Kochen
Since using cassandra 0.8, I see the following warning: WARN 12:05:59,807 MemoryMeter uninitialized (jamm not specified as java agent); assuming liveRatio of 10.0. Usually this means cassandra-env.sh disabled jamm because you are using a buggy JRE; upgrade to the Sun JRE instead I'am using Sun

RE: java.io.IOError: java.io.EOFException with version 0.7.6

2011-05-23 Thread Rene Kochen
: java.io.EOFException with version 0.7.6 Would you have a simple script to reproduce the issue ? And could you open a JIRA ticket. Sylvain On Thu, May 19, 2011 at 4:22 PM, Rene Kochen wrote: > I have some severe problems on our production site. > I created the following test program to reprodu

java.io.IOError: java.io.EOFException with version 0.7.6

2011-05-19 Thread Rene Kochen
I have some severe problems on our production site. I created the following test program to reproduce the issue with Cassandra 0.7.6 (with empty data set). I use the following data-model column_metadata: [] name: Customers column_type: Super gc_grace_seconds: 60 I have a super-column-family wit