You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Vivek Mishra <mi...@gmail.com> on 2014/01/20 16:16:04 UTC
one or more nodes were unavailable.
Hi,
Trying CAS feature of cassandra 2.x and somehow getting given below error:
cqlsh:sample> insert into "User"(user_id,first_name) values(
fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1') if not exists;
Unable to complete request: one or more nodes were unavailable.
cqlsh:training>
cqlsh:sample> insert into "User"(user_id,first_name) values(
fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1')
It works fine.
Any idea?
-Vivek
Re: one or more nodes were unavailable.
Posted by Drew Kutcharian <dr...@venarc.com>.
What do you see when you run "desc keyspace;” in cqlsh?
On Jan 20, 2014, at 10:10 PM, Vivek Mishra <mi...@gmail.com> wrote:
> 1 have downloaded cassandra 2.x and set up on single machine. Started Cassandra server and connecting via cqlsh. Created a column family and inserting a single record into it(via cqlsh).
>
> Wondering why it gives "No node available"
>
> Even though simple insert queries(without CAS) works!
>
> -Vivek
>
>
> On Tue, Jan 21, 2014 at 11:33 AM, Drew Kutcharian <dr...@venarc.com> wrote:
> If you are trying this out on a single node, make sure you set the replication_factor of the keyspace to one.
>
>
> On Jan 20, 2014, at 7:41 PM, Vivek Mishra <mi...@gmail.com> wrote:
>
>> Single node and default consistency. Running via cqsh
>>
>>
>> On Tue, Jan 21, 2014 at 1:47 AM, sankalp kohli <ko...@gmail.com> wrote:
>> Also do you have any nodes down...because it is possible to reach write consistency and not do CAS because some machines are down.
>>
>>
>> On Mon, Jan 20, 2014 at 12:16 PM, sankalp kohli <ko...@gmail.com> wrote:
>> What consistency level are you using?
>>
>>
>> On Mon, Jan 20, 2014 at 7:16 AM, Vivek Mishra <mi...@gmail.com> wrote:
>> Hi,
>> Trying CAS feature of cassandra 2.x and somehow getting given below error:
>>
>>
>> cqlsh:sample> insert into "User"(user_id,first_name) values( fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1') if not exists;
>> Unable to complete request: one or more nodes were unavailable.
>> cqlsh:training>
>>
>>
>> cqlsh:sample> insert into "User"(user_id,first_name) values( fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1')
>>
>> It works fine.
>>
>> Any idea?
>>
>> -Vivek
>>
>>
>>
>>
>>
>
>
Re: one or more nodes were unavailable.
Posted by Vivek Mishra <mi...@gmail.com>.
1 have downloaded cassandra 2.x and set up on single machine. Started
Cassandra server and connecting via cqlsh. Created a column family and
inserting a single record into it(via cqlsh).
Wondering why it gives "No node available"
Even though simple insert queries(without CAS) works!
-Vivek
On Tue, Jan 21, 2014 at 11:33 AM, Drew Kutcharian <dr...@venarc.com> wrote:
> If you are trying this out on a single node, make sure you set the
> replication_factor of the keyspace to one.
>
>
> On Jan 20, 2014, at 7:41 PM, Vivek Mishra <mi...@gmail.com> wrote:
>
> Single node and default consistency. Running via cqsh
>
>
> On Tue, Jan 21, 2014 at 1:47 AM, sankalp kohli <ko...@gmail.com>wrote:
>
>> Also do you have any nodes down...because it is possible to reach write
>> consistency and not do CAS because some machines are down.
>>
>>
>> On Mon, Jan 20, 2014 at 12:16 PM, sankalp kohli <ko...@gmail.com>wrote:
>>
>>> What consistency level are you using?
>>>
>>>
>>> On Mon, Jan 20, 2014 at 7:16 AM, Vivek Mishra <mi...@gmail.com>wrote:
>>>
>>>> Hi,
>>>> Trying CAS feature of cassandra 2.x and somehow getting given below
>>>> error:
>>>>
>>>>
>>>> cqlsh:sample> insert into "User"(user_id,first_name) values(
>>>> fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1') if not exists;
>>>> Unable to complete request: one or more nodes were unavailable.
>>>> cqlsh:training>
>>>>
>>>>
>>>> cqlsh:sample> insert into "User"(user_id,first_name) values(
>>>> fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1')
>>>>
>>>> It works fine.
>>>>
>>>> Any idea?
>>>>
>>>> -Vivek
>>>>
>>>>
>>>>
>>>
>>
>
>
Re: one or more nodes were unavailable.
Posted by Drew Kutcharian <dr...@venarc.com>.
If you are trying this out on a single node, make sure you set the replication_factor of the keyspace to one.
On Jan 20, 2014, at 7:41 PM, Vivek Mishra <mi...@gmail.com> wrote:
> Single node and default consistency. Running via cqsh
>
>
> On Tue, Jan 21, 2014 at 1:47 AM, sankalp kohli <ko...@gmail.com> wrote:
> Also do you have any nodes down...because it is possible to reach write consistency and not do CAS because some machines are down.
>
>
> On Mon, Jan 20, 2014 at 12:16 PM, sankalp kohli <ko...@gmail.com> wrote:
> What consistency level are you using?
>
>
> On Mon, Jan 20, 2014 at 7:16 AM, Vivek Mishra <mi...@gmail.com> wrote:
> Hi,
> Trying CAS feature of cassandra 2.x and somehow getting given below error:
>
>
> cqlsh:sample> insert into "User"(user_id,first_name) values( fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1') if not exists;
> Unable to complete request: one or more nodes were unavailable.
> cqlsh:training>
>
>
> cqlsh:sample> insert into "User"(user_id,first_name) values( fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1')
>
> It works fine.
>
> Any idea?
>
> -Vivek
>
>
>
>
>
Re: one or more nodes were unavailable.
Posted by Vivek Mishra <mi...@gmail.com>.
Single node and default consistency. Running via cqsh
On Tue, Jan 21, 2014 at 1:47 AM, sankalp kohli <ko...@gmail.com>wrote:
> Also do you have any nodes down...because it is possible to reach write
> consistency and not do CAS because some machines are down.
>
>
> On Mon, Jan 20, 2014 at 12:16 PM, sankalp kohli <ko...@gmail.com>wrote:
>
>> What consistency level are you using?
>>
>>
>> On Mon, Jan 20, 2014 at 7:16 AM, Vivek Mishra <mi...@gmail.com>wrote:
>>
>>> Hi,
>>> Trying CAS feature of cassandra 2.x and somehow getting given below
>>> error:
>>>
>>>
>>> cqlsh:sample> insert into "User"(user_id,first_name) values(
>>> fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1') if not exists;
>>> Unable to complete request: one or more nodes were unavailable.
>>> cqlsh:training>
>>>
>>>
>>> cqlsh:sample> insert into "User"(user_id,first_name) values(
>>> fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1')
>>>
>>> It works fine.
>>>
>>> Any idea?
>>>
>>> -Vivek
>>>
>>>
>>>
>>
>
Re: one or more nodes were unavailable.
Posted by sankalp kohli <ko...@gmail.com>.
Also do you have any nodes down...because it is possible to reach write
consistency and not do CAS because some machines are down.
On Mon, Jan 20, 2014 at 12:16 PM, sankalp kohli <ko...@gmail.com>wrote:
> What consistency level are you using?
>
>
> On Mon, Jan 20, 2014 at 7:16 AM, Vivek Mishra <mi...@gmail.com>wrote:
>
>> Hi,
>> Trying CAS feature of cassandra 2.x and somehow getting given below error:
>>
>>
>> cqlsh:sample> insert into "User"(user_id,first_name) values(
>> fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1') if not exists;
>> Unable to complete request: one or more nodes were unavailable.
>> cqlsh:training>
>>
>>
>> cqlsh:sample> insert into "User"(user_id,first_name) values(
>> fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1')
>>
>> It works fine.
>>
>> Any idea?
>>
>> -Vivek
>>
>>
>>
>
Re: one or more nodes were unavailable.
Posted by sankalp kohli <ko...@gmail.com>.
What consistency level are you using?
On Mon, Jan 20, 2014 at 7:16 AM, Vivek Mishra <mi...@gmail.com> wrote:
> Hi,
> Trying CAS feature of cassandra 2.x and somehow getting given below error:
>
>
> cqlsh:sample> insert into "User"(user_id,first_name) values(
> fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1') if not exists;
> Unable to complete request: one or more nodes were unavailable.
> cqlsh:training>
>
>
> cqlsh:sample> insert into "User"(user_id,first_name) values(
> fe08e810-81e4-11e3-9470-c3aa8ce77cc4,'vivek1')
>
> It works fine.
>
> Any idea?
>
> -Vivek
>
>
>