Question upon gracefully restarting c* node(s)

2018-01-01 Thread Jing Meng
Hi all. Recently we made a change to our production env c* cluster (2.1.18) - placing the commit log to the same SSD where data is stored, which needs restarting all nodes. Before restarting a cassandra node, we ran the following nodetool utils: $ nodetool disablethrift && sleep 5 $ nodetool

Re: [python] [flask] [CQLAlchemy] NoHostAvailable on create

2018-01-01 Thread Alan Hamlett
Adding more nodes to the cluster fixed the error. Looks like a bug in python-driver connection pool: 1. The connection pool only has one host 2. A query times out, causing that connection to be removed from the pool 3. Another query executes, but there are no hosts in the pool On Mon, Jan 1,

Reg:- limitation as PROS and CONS of Using Collections in Data modeling

2018-01-01 Thread @Nandan@
Hi All, I want to know, what will be a limitation in case of using Collections such as SET, LIST, MAP? Like in my condition, which inserting Video details, I have to insert language based such as Language:- English Title:- Video Name Language:- Hindi Title:- Video_name in Hindi Language:- Chinese

Re: How to get page id without transmitting data to client

2018-01-01 Thread Eunsu Kim
Thank you for your response. happy new year > On 30 Dec 2017, at 5:33 AM, Andy Tolbert wrote: > > Hi Eunsu, > > Unfortunately there is not really a way to do this that I'm aware of. The > page id contains data indicating where to start reading the next set of

Re: [python] [flask] [CQLAlchemy] NoHostAvailable on create

2018-01-01 Thread Jeff Jirsa
Well the python driver you reference is a third party driver, because the project doesn’t ship official drivers. You may have better luck looking for a datastax driver support forum, or wait until after the holiday for more people to be checking email. -- Jeff Jirsa > On Jan 1, 2018, at

Re: [python] [flask] [CQLAlchemy] NoHostAvailable on create

2018-01-01 Thread Alan Hamlett
Still getting the cassandra.cluster.NoHostAvailable error periodically from uWSGI hosts. Setting up the connection with postfork: https://github.com/alanhamlett/flask-cqlalchemy/blob/653ed3298af7dd617a972e9f87437f6e53f741b9/flask_cqlalchemy/__init__.py#L56 Lazy connection is False, Retry

Re: Upgrade from 1.2.x to 2.0.x, upgradesstables has doubled the size on disk?

2018-01-01 Thread Matija Gobec
Dan, What partitioner are you using and did you just swap out the binary? Going from 70GB to 200GB+ is extremely odd in any scenario. Maybe Carlos Rolo has an idea about this issue. He did a ton of 1.2 cluster upgrades. As for the tombstones, its the stat for the last five minutes. You could