[ https://issues.apache.org/jira/browse/CASSANDRA-8012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14180120#comment-14180120 ]
Serge Balyuk commented on CASSANDRA-8012: ----------------------------------------- I've witnessed similar issue. After upgrading one node from 2.0.8 to 2.1.0, cqlsh on that node was behaving as described above. At the same time, {{nodetool describecluster}} showed different schema versions for the upgraded node and the rest of nodes in cluster. After the first attempt at {{nodetool resetlocalschema}}, the node's schema version changed but it was still different from cluster's common schema version. Subsequent attempts at {{resetlocalchema}} had no effect. After restarting upgraded node {{nodetool describecluster}} on it showed {{UNREACHABLE}} for all nodes except itself. boot.log had many exceptions similar to this: {code} WARN o.a.c.net.IncomingTcpConnection - UnknownColumnFamilyException reading from socket; closing org.apache.cassandra.db.UnknownColumnFamilyException: Couldn't find cfId=..... .... DEBUG o.a.cassandra.net.MessagingService - Reseting version for /A.B.C.D {code} At the same time {{nodetool status}} shows {{UN}} for all nodes from both upgraded node and old nodes. Had to fallback to upgrading to 2.0.10. After removing all incompatible sstables which 2.1.0 created during its uptime, {{describecluster}} shows single version for all nodes, cqlsh performs as expected on upgraded-then-downgraded node. As noted in CASSANDRA-8023 this issue may be not just a tools issue unless I've missed some important step in 2.0.x -> 2.1.0 upgrade procedure. > 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 > Labels: cqlsh > > 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)