You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@cassandra.apache.org by kedar <ke...@netcore.co.in> on 2016/02/11 14:56:27 UTC

Keyspaces not found in cqlsh

Dev Team,

Need some help with a burning cqlsh issue

I am using cqlsh 5.0.1 | Cassandra 2.1.2, recently we are unable to see
/ desc keyspaces and query tables through cqlsh on either of the two nodes

cqlsh> desc keyspaces

<empty>

cqlsh> use user_index;
cqlsh:user_index> desc table list_1_10;

Keyspace 'user_index' not found.
cqlsh:user_index>
cqlsh>  select * from system.schema_keyspaces;
Keyspace 'system' not found.
cqlsh>
We are running a 2 node cluster. The Python - Django app that inserts
data is running without any failure and system logs show nothing abnormal.

./nodetool repair on one node hasn't helped ./nodetool cfstats shows all
the tables too

ls -l cassandra/data/*  on each node:

https://gist.github.com/anonymous/3dddbe728a52c07d7c52
https://gist.github.com/anonymous/302ade0875dd6410087b




  --
Thanks,
Kedar Parikh

Re: Keyspaces not found in cqlsh

Posted by Ryan Svihla <rs...@foundev.pro>.

Kedar,

I recommend asking the user list user@cassandra.apache.org this list is for the development of cassandra and you're more likely to find someone on the user list who may have hit this issue.

Curious issue though I haven't seen that myself.

Regards,
Ryan Svihla

> On Feb 11, 2016, at 7:56 AM, kedar <ke...@netcore.co.in> wrote:
> 
> Dev Team,
> 
> Need some help with a burning cqlsh issue
> 
> I am using cqlsh 5.0.1 | Cassandra 2.1.2, recently we are unable to see
> / desc keyspaces and query tables through cqlsh on either of the two nodes
> 
> cqlsh> desc keyspaces
> 
> <empty>
> 
> cqlsh> use user_index;
> cqlsh:user_index> desc table list_1_10;
> 
> Keyspace 'user_index' not found.
> cqlsh:user_index>
> cqlsh>  select * from system.schema_keyspaces;
> Keyspace 'system' not found.
> cqlsh>
> We are running a 2 node cluster. The Python - Django app that inserts
> data is running without any failure and system logs show nothing abnormal.
> 
> ./nodetool repair on one node hasn't helped ./nodetool cfstats shows all
> the tables too
> 
> ls -l cassandra/data/*  on each node:
> 
> https://gist.github.com/anonymous/3dddbe728a52c07d7c52
> https://gist.github.com/anonymous/302ade0875dd6410087b
> 
> 
> 
> 
> --
> Thanks,
> Kedar Parikh
> 
> 
> 
> 
> 
> 
> 
> 
>

Re: Keyspaces not found in cqlsh

Posted by Ryan Svihla <rs...@foundev.pro>.

Kedar,

I recommend asking the user list user@cassandra.apache.org this list is for the development of cassandra and you're more likely to find someone on the user list who may have hit this issue.

Curious issue though I haven't seen that myself.

Regards,
Ryan Svihla

> On Feb 11, 2016, at 7:56 AM, kedar <ke...@netcore.co.in> wrote:
> 
> Dev Team,
> 
> Need some help with a burning cqlsh issue
> 
> I am using cqlsh 5.0.1 | Cassandra 2.1.2, recently we are unable to see
> / desc keyspaces and query tables through cqlsh on either of the two nodes
> 
> cqlsh> desc keyspaces
> 
> <empty>
> 
> cqlsh> use user_index;
> cqlsh:user_index> desc table list_1_10;
> 
> Keyspace 'user_index' not found.
> cqlsh:user_index>
> cqlsh>  select * from system.schema_keyspaces;
> Keyspace 'system' not found.
> cqlsh>
> We are running a 2 node cluster. The Python - Django app that inserts
> data is running without any failure and system logs show nothing abnormal.
> 
> ./nodetool repair on one node hasn't helped ./nodetool cfstats shows all
> the tables too
> 
> ls -l cassandra/data/*  on each node:
> 
> https://gist.github.com/anonymous/3dddbe728a52c07d7c52
> https://gist.github.com/anonymous/302ade0875dd6410087b
> 
> 
> 
> 
> --
> Thanks,
> Kedar Parikh
> 
> 
> 
> 
> 
> 
> 
> 
>