RE: Need company to support Cassandra on Windows

[SEAN_R_DURITY]

I highly recommend DataStax support, although we have not done Windows. They 
are in a growth phase, so I expect there will be growing pains with support. 
However, they have some top notch folks in place.

Sean Durity – Lead Cassandra Admin
From: Troy Collinsworth [mailto:troycollinswo...@gmail.com]
Sent: Tuesday, October 27, 2015 9:58 AM
To: user@cassandra.apache.org
Subject: Need company to support Cassandra on Windows

Searching for a well established company that can provide consulting and 
operations support for private multi-dc production Cassandra cluster on Windows 
OS. New project. OS is hosting mandate.

Troy Collinsworth
585-576-8761



The information in this Internet Email is confidential and may be legally 
privileged. It is intended solely for the addressee. Access to this Email by 
anyone else is unauthorized. If you are not the intended recipient, any 
disclosure, copying, distribution or any action taken or omitted to be taken in 
reliance on it, is prohibited and may be unlawful. When addressed to our 
clients any opinions or advice contained in this Email are subject to the terms 
and conditions expressed in any applicable governing The Home Depot terms of 
business or client engagement letter. The Home Depot disclaims all 
responsibility and liability for the accuracy and content of this attachment 
and for any damages or losses arising from any inaccuracies, errors, viruses, 
e.g., worms, trojan horses, etc., or other items of a destructive nature, which 
may be contained in this attachment and shall not be liable for direct, 
indirect, consequential or special damages in connection with this e-mail 
message or its attachment.

unsubscribe

[M.Tarkeshwar Rao]

Re: cassandra bootstrapping

[Lyubo Kamenov]

On Thu, Oct 22, 2015 at 12:57 PM, Nate McCall 
wrote:
[..]
>
> There is a good comment at the top of StorageService#joinTokenRing which
> explains the process at a high level:
>
> https://github.com/apache/cassandra/blob/cassandra-2.2/src/java/org/apache/cassandra/service/StorageService.java#L791-L803
>
> The method itself is long, but readible and has a series of comments that
> explain some of the decisions taken and even reference some issues which
> have been encountered over the years.
>
> You can change this value if you really want by passing
> "cassandra.ring_delay_ms" as a system property at startup.
>

Thanks Nate, I'm catching up on that.

Considering that this concerns mostly auto-bootstrap and seed nodes by
default do not do that,
would it be correct to assume that they could be started in parallel and
then the non-seed should be
added with the interval apart.

As in seeds-start -> wait -> add non-seed -> wait -> add non-seed.

Would that timeout be only between seeds started and non-seed, or every
non-seed will have to be
started serially with wait in between.

Thanks

Re: memtable flush size with LCS

[Nate McCall]

>  do you mean that this property is ignored at memtable flush time, and so
> memtables are already allowed to be much larger than sstable_size_in_mb?
>

Yes, 'sstable_size_in_mb' plays no part in the flush process. Flushing is
based on solely on runtime activity and the file size is determined by
whatever was in the memtable at that time.



-- 
-
Nate McCall
Austin, TX
@zznate

Co-Founder & Sr. Technical Consultant
Apache Cassandra Consulting
http://www.thelastpickle.com

Re: Need company to support Cassandra on Windows

[Kai Wang]

I would start with DataStax. In this year's summit keynote Jonathan Ellis
said C* would start receiving production level support on Windows.

On Tue, Oct 27, 2015 at 9:58 AM, Troy Collinsworth <
troycollinswo...@gmail.com> wrote:

> Searching for a well established company that can provide consulting and
> operations support for private multi-dc production Cassandra cluster on
> Windows OS. New project. OS is hosting mandate.
>
> Troy Collinsworth
> 585-576-8761
>

Re: Need company to support Cassandra on Windows

[Troy Collinsworth]

Jonathan Ellis slide showing windows support was at 1:02:18 minutes into
the Cassandra Summit Keynote. At 1:07:30 Jonathan specifically said, *“Windows
support…in 2.2 it is production ready first class citizen, we expect it to
be on a level playing field with our linux support”*.

I sent DataStax a copy of the keynote slide and the time it was shown and
the quote Jonathan made with the time in the keynote he made it. That's
when Datastax told me they don't currently support windows and probably
won't by January-March timeframe. This is an opportunity for another
company to step up and provide production Windows support.

So a co-founder and employee of Datastax stood on stage and
implied/stretched the truth about production Windows support for Cassandra.

How do you know a salesman is lying? His lips are moving.

Troy

Re: memtable flush size with LCS

[Jeff Jirsa]

It’s worth mentioning that initial flushed file size is typically determined by 
memtable_cleanup_threshold and the memtable space options 
(memtable_heap_space_in_mb, memtable_offheap_space_in_mb, depending on 
memtable_allocation_type)



From:  Nate McCall
Reply-To:  "user@cassandra.apache.org"
Date:  Wednesday, October 28, 2015 at 11:45 AM
To:  Cassandra Users
Subject:  Re: memtable flush size with LCS


 do you mean that this property is ignored at memtable flush time, and so 
memtables are already allowed to be much larger than sstable_size_in_mb?

Yes, 'sstable_size_in_mb' plays no part in the flush process. Flushing is based 
on solely on runtime activity and the file size is determined by whatever was 
in the memtable at that time. 
 


-- 
-
Nate McCall
Austin, TX
@zznate

Co-Founder & Sr. Technical Consultant
Apache Cassandra Consulting
http://www.thelastpickle.com



smime.p7s
Description: S/MIME cryptographic signature

Re: Need company to support Cassandra on Windows

[Phil Bayliss]

Just to clarify, support for Windows on Cassandra is there in 2.2, and that
is what Jonathan was referring to in his keynote. Support for an OS and
having a Support Team are two different things (DataStax's support team
supports DataStax Enterprise licensed customers).

Also, Cassandra Summit was a conference for Cassandra, hosted by DataStax.
Throughout Jonathan's keynote, he was addressing Apache Cassandra, not
DataStax Enterprise.

Hope that helps clear the muddy waters!


[image: DataStaxLogo copy3.png] 

PHIL BAYLISS

Solutions Engineer | 512.952.0909 | phil.bayl...@datastax.com



 

 






On Wed, Oct 28, 2015 at 12:26 PM, Troy Collinsworth <
troycollinswo...@gmail.com> wrote:

> Jonathan Ellis slide showing windows support was at 1:02:18 minutes into
> the Cassandra Summit Keynote. At 1:07:30 Jonathan specifically said, *“Windows
> support…in 2.2 it is production ready first class citizen, we expect it to
> be on a level playing field with our linux support”*.
>
> I sent DataStax a copy of the keynote slide and the time it was shown and
> the quote Jonathan made with the time in the keynote he made it. That's
> when Datastax told me they don't currently support windows and probably
> won't by January-March timeframe. This is an opportunity for another
> company to step up and provide production Windows support.
>
> So a co-founder and employee of Datastax stood on stage and
> implied/stretched the truth about production Windows support for Cassandra.
>
> How do you know a salesman is lying? His lips are moving.
>
> Troy
>
>

Re: Need company to support Cassandra on Windows

[Robert Coli]

On Wed, Oct 28, 2015 at 10:51 AM, Troy Collinsworth <
troycollinswo...@gmail.com> wrote:

> I was in discussions with Datastax to license DSE/support, however I was
> told Windows won't be production supported by Datastax by Jan-Mar. If no
> company supports Cassandra on Windows in production, especially Datastax,
> then it's hard to rationalize that it's ready or can/should be relied on in
> production.
>

Plenty of use cases for open source software exist when there is no company
that supports the software at all. "Production ready" is undefinable in the
abstract.

Now if you're asking if I personally would run Cassandra on Windows in
production... I probably would only do so after establishing to my
satisfaction that it worked with the kind of workloads I expected it to
receive. But I am a relatively cautious operator, and do not have a
requirement to run on Windows...

=Rob

Re: Error Connecting to Cassandra

[Jeff Jirsa]

The cassandra system.log would be more useful

When Cassandra starts rejecting or dropping tcp connections, try to connect 
using cqlsh, and check the logs for indication that it’s failing. 

From:  Eduardo Alfaia
Reply-To:  "user@cassandra.apache.org"
Date:  Wednesday, October 28, 2015 at 5:09 PM
To:  "user@cassandra.apache.org"
Subject:  Re: Error Connecting to Cassandra

I am using cassandra standalone, the machine is up, I was monitoring the 
cassandra seeing the system.log but I didn’t see anything wrong. 
I’ve captured the flow of packets using wireshark and I’ve seen that the 
cassandra server is reset the connection with the client. I am sending the 
python app which I am using.




smime.p7s
Description: S/MIME cryptographic signature

Re: Cassandra 2.2.1 on Windows

[Alaa Zubaidi (PDF)]

Thanks Rob,
We are using 7GB JVM on a 32GB RAM VM
Alaa

On Wed, Oct 28, 2015 at 11:18 AM, Robert Coli  wrote:

> On Tue, Oct 27, 2015 at 8:47 PM, Alaa Zubaidi (PDF) 
> wrote:
>
>> We have Cassandra 2.2.1 on Windows 2008R2-64-bit.
>>
>> We are noticing that during compaction Cassandra consumes all the
>> available memory for the VM and bring the VM to a crawl. compaction
>> settings are default, and we are using sized tiered compaction.
>>
>> When investigating this, we find through VMMAP that the memory is
>> consumed by mapped files.
>> These are almost all the sstables (index and data) for all keyspaces,
>> mapped into memory (system and user defined keyspaces) .
>>
>> Is this normal, or should these files not be mapped into memroy after
>> compaction?
>>
>
> https://wiki.apache.org/cassandra/FAQ#mmap
>
> However that is probably not really your problem, you probably just have
> too small of a heap if GC is failing?
>
> =Rob
>
>



-- 

Alaa Zubaidi
PDF Solutions, Inc.
333 West San Carlos Street, Suite 1000
San Jose, CA 95110  USA
Tel: 408-283-5639
fax: 408-938-6479
email: alaa.zuba...@pdf.com

-- 
*This message may contain confidential and privileged information. If it 
has been sent to you in error, please reply to advise the sender of the 
error and then immediately permanently delete it and all attachments to it 
from your systems. If you are not the intended recipient, do not read, 
copy, disclose or otherwise use this message or any attachments to it. The 
sender disclaims any liability for such unauthorized use. PLEASE NOTE that 
all incoming e-mails sent to PDF e-mail accounts will be archived and may 
be scanned by us and/or by external service providers to detect and prevent 
threats to our systems, investigate illegal or inappropriate behavior, 
and/or eliminate unsolicited promotional e-mails (“spam”). If you have any 
concerns about this process, please contact us at *
*legal.departm...@pdf.com* *.*

Re: Error Connecting to Cassandra

[Surbhi Gupta]

Are you running heavy load?
I have seen these kinds error application team reporting to us in case when
they have too many connection already setup and they are trying to connect
more applications.

Try to disconnect the applications which are not required and try again ..
Hope this helps...

On 28 October 2015 at 16:22, Eduardo Alfaia 
wrote:

> Hi Guys,
>
> I am some problems of  Connection Timeout in a random mode, that is, the
> application in python that I am using sometimes it does work very well
> sometimes not, I am getting this error:
>
> 015-10-28 19:49:05,286 [WARNING] cassandra.cluster: [control connection]
> Error connecting to 10.20.255.191:
> Traceback (most recent call last):
>   File
> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", line
> 2117, in _reconnect_internal
> return self._try_connect(host)
>   File
> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", line
> 2164, in _try_connect
> self._refresh_schema(connection, preloaded_results=shared_results,
> schema_agreement_wait=-1)
>   File
> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", line
> 2343, in _refresh_schema
> responses = connection.wait_for_responses(*queries,
> timeout=self._timeout, fail_on_error=False)
>   File
> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/connection.py",
> line 438, in wait_for_responses
> return waiter.deliver(timeout)
>   File
> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/connection.py",
> line 839, in deliver
> raise OperationTimedOut()
> OperationTimedOut: errors=None, last_host=None
> 2015-10-28 19:49:05,292 [ERROR] cassandra.cluster: Control connection
> failed to connect, shutting down Cluster:
> Traceback (most recent call last):
>   File
> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", line
> 840, in connect
> self.control_connection.connect()
>   File
> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", line
> 2091, in connect
> self._set_new_connection(self._reconnect_internal())
>   File
> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", line
> 2126, in _reconnect_internal
> raise NoHostAvailable("Unable to connect to any servers", errors)
> NoHostAvailable: ('Unable to connect to any servers', {'10.20.255.191':
> OperationTimedOut('errors=None, last_host=None',)})
>
> I have had some tests with others applications in python and the same
> error occur. Does anyone have any idea?
>
> Thanks a lot

Re: Error Connecting to Cassandra

[Surbhi Gupta]

Hi Eduardo,

Is the cluster up and running?
As your message says "Control connection failed to connect, shutting down
Cluster"

May be you can get some more info from the system.log.

Thanks
Surbhi

On 28 October 2015 at 16:46, Eduardo Alfaia 
wrote:

> Hi Gupta,
>
> I am running a simple python application that isn’t heavy from point of
> view of access to cassandra. The application create a new keyspace, tables
> and do the load of data.
> The application is an example in python-driver folder.
>
>
> On 29 Oct 2015, at 00:33, Surbhi Gupta  wrote:
>
> Are you running heavy load?
> I have seen these kinds error application team reporting to us in case
> when they have too many connection already setup and they are trying to
> connect more applications.
>
> Try to disconnect the applications which are not required and try again ..
> Hope this helps...
>
> On 28 October 2015 at 16:22, Eduardo Alfaia 
> wrote:
>
>> Hi Guys,
>>
>> I am some problems of  Connection Timeout in a random mode, that is, the
>> application in python that I am using sometimes it does work very well
>> sometimes not, I am getting this error:
>>
>> 015-10-28 19:49:05,286 [WARNING] cassandra.cluster: [control connection]
>> Error connecting to 10.20.255.191:
>> Traceback (most recent call last):
>>   File
>> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", line
>> 2117, in _reconnect_internal
>> return self._try_connect(host)
>>   File
>> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", line
>> 2164, in _try_connect
>> self._refresh_schema(connection, preloaded_results=shared_results,
>> schema_agreement_wait=-1)
>>   File
>> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", line
>> 2343, in _refresh_schema
>> responses = connection.wait_for_responses(*queries,
>> timeout=self._timeout, fail_on_error=False)
>>   File
>> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/connection.py",
>> line 438, in wait_for_responses
>> return waiter.deliver(timeout)
>>   File
>> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/connection.py",
>> line 839, in deliver
>> raise OperationTimedOut()
>> OperationTimedOut: errors=None, last_host=None
>> 2015-10-28 19:49:05,292 [ERROR] cassandra.cluster: Control connection
>> failed to connect, shutting down Cluster:
>> Traceback (most recent call last):
>>   File
>> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", line
>> 840, in connect
>> self.control_connection.connect()
>>   File
>> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", line
>> 2091, in connect
>> self._set_new_connection(self._reconnect_internal())
>>   File
>> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", line
>> 2126, in _reconnect_internal
>> raise NoHostAvailable("Unable to connect to any servers", errors)
>> NoHostAvailable: ('Unable to connect to any servers', {'10.20.255.191':
>> OperationTimedOut('errors=None, last_host=None',)})
>>
>> I have had some tests with others applications in python and the same
>> error occur. Does anyone have any idea?
>>
>> Thanks a lot
>
>
>
>

Error Connecting to Cassandra

[Eduardo Alfaia]

Hi Guys,

I am some problems of  Connection Timeout in a random mode, that is, the 
application in python that I am using sometimes it does work very well 
sometimes not, I am getting this error:

015-10-28 19:49:05,286 [WARNING] cassandra.cluster: [control connection] Error 
connecting to 10.20.255.191:
Traceback (most recent call last):
  File "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", 
line 2117, in _reconnect_internal
return self._try_connect(host)
  File "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", 
line 2164, in _try_connect
self._refresh_schema(connection, preloaded_results=shared_results, 
schema_agreement_wait=-1)
  File "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", 
line 2343, in _refresh_schema
responses = connection.wait_for_responses(*queries, timeout=self._timeout, 
fail_on_error=False)
  File 
"/home/ealfaia/workspace_patrizio/python-driver/cassandra/connection.py", line 
438, in wait_for_responses
return waiter.deliver(timeout)
  File 
"/home/ealfaia/workspace_patrizio/python-driver/cassandra/connection.py", line 
839, in deliver
raise OperationTimedOut()
OperationTimedOut: errors=None, last_host=None
2015-10-28 19:49:05,292 [ERROR] cassandra.cluster: Control connection failed to 
connect, shutting down Cluster:
Traceback (most recent call last):
  File "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", 
line 840, in connect
self.control_connection.connect()
  File "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", 
line 2091, in connect
self._set_new_connection(self._reconnect_internal())
  File "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", 
line 2126, in _reconnect_internal
raise NoHostAvailable("Unable to connect to any servers", errors)
NoHostAvailable: ('Unable to connect to any servers', {'10.20.255.191': 
OperationTimedOut('errors=None, last_host=None',)})

I have had some tests with others applications in python and the same error 
occur. Does anyone have any idea?

Thanks a lot 

Re: Error Connecting to Cassandra

[Eduardo Alfaia]

Hi Gupta,

I am running a simple python application that isn’t heavy from point of view of 
access to cassandra. The application create a new keyspace, tables and do the 
load of data.
The application is an example in python-driver folder.


> On 29 Oct 2015, at 00:33, Surbhi Gupta  wrote:
> 
> Are you running heavy load?
> I have seen these kinds error application team reporting to us in case when 
> they have too many connection already setup and they are trying to connect 
> more applications. 
> 
> Try to disconnect the applications which are not required and try again ..
> Hope this helps...
> 
> On 28 October 2015 at 16:22, Eduardo Alfaia  > wrote:
> Hi Guys,
> 
> I am some problems of  Connection Timeout in a random mode, that is, the 
> application in python that I am using sometimes it does work very well 
> sometimes not, I am getting this error:
> 
> 015-10-28 19:49:05,286 [WARNING] cassandra.cluster: [control connection] 
> Error connecting to 10.20.255.191 :
> Traceback (most recent call last):
>   File "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", 
> line 2117, in _reconnect_internal
> return self._try_connect(host)
>   File "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", 
> line 2164, in _try_connect
> self._refresh_schema(connection, preloaded_results=shared_results, 
> schema_agreement_wait=-1)
>   File "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", 
> line 2343, in _refresh_schema
> responses = connection.wait_for_responses(*queries, 
> timeout=self._timeout, fail_on_error=False)
>   File 
> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/connection.py", 
> line 438, in wait_for_responses
> return waiter.deliver(timeout)
>   File 
> "/home/ealfaia/workspace_patrizio/python-driver/cassandra/connection.py", 
> line 839, in deliver
> raise OperationTimedOut()
> OperationTimedOut: errors=None, last_host=None
> 2015-10-28 19:49:05,292 [ERROR] cassandra.cluster: Control connection failed 
> to connect, shutting down Cluster:
> Traceback (most recent call last):
>   File "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", 
> line 840, in connect
> self.control_connection.connect()
>   File "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", 
> line 2091, in connect
> self._set_new_connection(self._reconnect_internal())
>   File "/home/ealfaia/workspace_patrizio/python-driver/cassandra/cluster.py", 
> line 2126, in _reconnect_internal
> raise NoHostAvailable("Unable to connect to any servers", errors)
> NoHostAvailable: ('Unable to connect to any servers', {'10.20.255.191': 
> OperationTimedOut('errors=None, last_host=None',)})
> 
> I have had some tests with others applications in python and the same error 
> occur. Does anyone have any idea?
> 
> Thanks a lot
>