[jira] [Commented] (CASSANDRA-8012) cqlsh "DESCRIBE KEYSPACES;" returns empty after upgrade

["Phil Yang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-8012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14290508#comment-14290508 ] 

Phil Yang commented on CASSANDRA-8012:
--------------------------------------

I have the same issue, and even more, sometimes I can not select any data.
{noformat}
cqlsh> desc keyspaces;

<empty>

cqlsh> SELECT * FROM system.schema_keyspaces;
Traceback (most recent call last):
  File "/apache-cassandra-2.1.1/bin/cqlsh", line 861, in onecmd
    self.handle_statement(st, statementtext)
  File "/apache-cassandra-2.1.1/bin/cqlsh", line 899, in handle_statement
    return custom_handler(parsed)
  File "/apache-cassandra-2.1.1/bin/cqlsh", line 930, in do_select
    self.perform_statement(statement)
  File "/apache-cassandra-2.1.1/bin/cqlsh", line 935, in perform_statement
    result = self.perform_simple_statement(stmt)
  File "/apache-cassandra-2.1.1/bin/cqlsh", line 968, in perform_simple_statement
    self.print_result(rows, self.parse_for_table_meta(statement.query_string))
  File "/apache-cassandra-2.1.1/bin/cqlsh", line 949, in parse_for_table_meta
    return self.get_table_meta(ks, cf)
  File "/apache-cassandra-2.1.1/bin/cqlsh", line 714, in get_table_meta
    ksmeta = self.get_keyspace_meta(ksname)
  File "/apache-cassandra-2.1.1/bin/cqlsh", line 699, in get_keyspace_meta
    raise KeyspaceNotFound('Keyspace %r not found.' % ksname)
KeyspaceNotFound: Keyspace 'system' not found.

cqlsh> use system;
cqlsh:system> 
cqlsh:system> use system2;
code=2200 [Invalid query] message="Keyspace 'system2' does not exist"
cqlsh:system> 

{noformat}
I can change the keyspace by "use" and it can judge whether this keyspace is exist.

And if I use 2.0.6's cqlsh to connect 2.1.1 cluster, it will work without any error at all.

> cqlsh "DESCRIBE KEYSPACES;" returns empty after upgrade
> -------------------------------------------------------
>
>                 Key: CASSANDRA-8012
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8012
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: cassandra 2.1.0 
>            Reporter: Shawn Zhou
>            Assignee: Tyler Hobbs
>            Priority: Minor
>              Labels: cqlsh
>             Fix For: 2.1.3
>
>
> after upgrade from 2.0.7 to 2.1.0
> run cqlsh  "DESCRIBE KEYSPACES;" returns empty result;
> query individual table does return data;
> See below:
> {noformat}
> [root@dc1-stg-cassandra-08 cassandra]# cqlsh dc1-stg-cassandra-08.dc01.revsci.net -k as_user_segment
> Connected to Stage Cluster at dc1-stg-cassandra-08.dc01.revsci.net:9042.
> [cqlsh 5.0.1 | Cassandra 2.1.0 | CQL spec 3.2.0 | Native protocol v3]
> Use HELP for help.
> cqlsh:as_user_segment> DESCRIBE KEYSPACES;
> <empty>
> cqlsh:as_user_segment>  select * from user_segments_blob where id = '8e6090087fc1a7591a99dc4cb744ac43';
>  id                               | segments
> ----------------------------------+------------------------------------------------------------------------------------
>  8e6090087fc1a7591a99dc4cb744ac43 | 0x94160000b0150000911d00003b0e0000211a0000ee22000072160000ab1c0000df0f000042040000
> (1 rows)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)