[jira] [Commented] (CASSANDRA-9689) keyspace does not show in describe list, if create query times out

["Tyler Hobbs (JIRA)" <ji...@apache.org>]

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

Tyler Hobbs commented on CASSANDRA-9689:
----------------------------------------

I imagine this is caused by the python driver not refreshing the schema metadata while there is a schema disagreement.  On startup cqlsh forces the driver to ignore schema disagreements to ensure that some schema metadata is populated, even if it's not perfectly correct.  However, we don't do the same thing for later schema disagreements.

I think the best solution is for cqlsh to refresh schema metadata regardless of schema disagreement, but it should probably also print a warning about the schema disagreement.  The warning could mention that down nodes may cause the disagreement.

> keyspace does not show in describe list, if create query times out
> ------------------------------------------------------------------
>
>                 Key: CASSANDRA-9689
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9689
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: Roopesh
>            Assignee: Tyler Hobbs
>              Labels: cqlsh
>             Fix For: 2.1.x
>
>
> Here is the snapshot of the overall issue :
> whiterabbit@whiterabbit:~/cassandra/bin$ ccm create 'demo2' -v binary:2.1.7 -n 3 -s -d 
> Current cluster is now: demo2
> whiterabbit@whiterabbit:~/cassandra/bin$ ccm list
>   demo_1node
>  *demo2
> whiterabbit@whiterabbit:~/cassandra/bin$ ccm status
> Cluster: 'demo2'
> ----------------
> node1: UP
> node3: UP
> node2: UP
> whiterabbit@whiterabbit:~/cassandra/bin$ ccm node2 nodetool version
> ReleaseVersion: 2.1.7
> whiterabbit@whiterabbit:~/cassandra/bin$ ccm node2 stop
> whiterabbit@whiterabbit:~/cassandra/bin$ ccm status
> Cluster: 'demo2'
> ----------------
> node1: UP
> node3: UP
> node2: DOWN
> whiterabbit@whiterabbit:~/cassandra/bin$ ccm node1 cqlsh
> Connected to demo2 at 127.0.0.1:9042.
> [cqlsh 5.0.1 | Cassandra 2.1.7 | CQL spec 3.2.0 | Native protocol v3]
> Use HELP for help.
> cqlsh> describe keyspaces;
> system_traces  system
> cqlsh> create keyspace training with replication={'class':'SimpleStrategy','replication_factor':1};
> OperationTimedOut: errors={}, last_host=127.0.0.1
> cqlsh> create keyspace training with replication={'class':'SimpleStrategy','replication_factor':1};
> AlreadyExists: Keyspace 'training' already exists
> cqlsh> describe keyspaces;
> system_traces  system
> cqlsh> 



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