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,

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

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

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