You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Ekaterina Dimitrova (Jira)" <ji...@apache.org> on 2021/05/05 01:35:00 UTC
[jira] [Comment Edited] (CASSANDRA-16652) "desc" on cqlsh 6.0.0 not
working with a Cassandra 3.x server
[ https://issues.apache.org/jira/browse/CASSANDRA-16652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17339369#comment-17339369 ]
Ekaterina Dimitrova edited comment on CASSANDRA-16652 at 5/5/21, 1:34 AM:
--------------------------------------------------------------------------
Hi Bowen,
First of all, thank you for the report! Appreciate it!
I started 3.11 instance, the latest one and then 4.0 cqlsh and this is the result I get:
{code:java}
$ bin/cqlsh
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.11.11-SNAPSHOT | CQL spec 3.4.4 | Native protocol v4]
Use HELP for help.
cqlsh> desc keyspaces;
system_traces system_schema system_auth system system_distributed
cqlsh> use system_auth;
cqlsh:system_auth> desc tables;
resource_role_permissons_index role_permissions role_members roles
cqlsh:system_auth> select * from roles;
role | can_login | is_superuser | member_of | salted_hash
-----------+-----------+--------------+-----------+--------------------------------------------------------------
cassandra | True | True | null | $2a$10$Z8p2Gk1tjQe6VMNRm9/6j.zCX3oVXv3b4h.KxmG7qFIAnQAhJNpHa
{code}
The thing I see is that you are on 3.11.10 and I think I saw [~blerer] fixing DESC at some point but I can't recall what issue it was, whether it was the same one, and I can't find a ticket now. I will confirm my assumptions tomorrow but seems to me upgrading to the latest version should solve your issue.
was (Author: e.dimitrova):
Hi Bowen,
First of all, thank you for the report! Appreciate it!
I started 3.11 instance, the latest one and then 4.0 cqlsh and this is the result I get:
{code:java}
$ bin/cqlsh
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.11.11-SNAPSHOT | CQL spec 3.4.4 | Native protocol v4]
Use HELP for help.
cqlsh> desc keyspaces;
system_traces system_schema system_auth system system_distributed
cqlsh> use system_auth;
cqlsh:system_auth> desc tables;
resource_role_permissons_index role_permissions role_members roles
cqlsh:system_auth> select * from roles;
role | can_login | is_superuser | member_of | salted_hash
-----------+-----------+--------------+-----------+--------------------------------------------------------------
cassandra | True | True | null | $2a$10$Z8p2Gk1tjQe6VMNRm9/6j.zCX3oVXv3b4h.KxmG7qFIAnQAhJNpHa
{code}
The thing I see is that you are on 3.11.10 and I think I saw [~blerer] fixing DESC at some point but I can't recall what issue it was, whether it was the same one and I can't find a ticket now. I will confirm my assumptions tomorrow but seems to me upgrading to the latest version should solve your issue.
> "desc" on cqlsh 6.0.0 not working with a Cassandra 3.x server
> -------------------------------------------------------------
>
> Key: CASSANDRA-16652
> URL: https://issues.apache.org/jira/browse/CASSANDRA-16652
> Project: Cassandra
> Issue Type: Bug
> Components: CQL/Interpreter
> Reporter: Bowen Song
> Assignee: Ekaterina Dimitrova
> Priority: Normal
> Fix For: 4.0-rc2
>
>
> The "desc" statement on cqlsh 6.0.0 shipped with Cassandra 4.0 RC1 is not working correctly when it's connected to a Cassandra 3.x server.
> Steps to reproduce:
> * Ensure you have docker installed and running
> * Run the following docker commands to create and start a Cassandra 3.11 container
> {code:java}
> ~ $ docker create --name cassandra3 cassandra:3.11.10
> 5d903e48e0661e39080198de5e8752356a5a666132211a500ea38af0fc2a0356
> ~ $ docker start cassandra3
> cassandra3
> ~ $ docker exec -ti cassandra3 bash
> {code}
> * Inside the docker container, try the default cqlsh version, make sure everything is working correctly
> {code:java}
> root@5d903e48e066:/# cqlsh
> Connected to Test Cluster at 127.0.0.1:9042.
> [cqlsh 5.0.1 | Cassandra 3.11.10 | CQL spec 3.4.4 | Native protocol v4]
> Use HELP for help.
> cqlsh> desc keyspaces;
> system_traces system_schema system_auth system system_distributed
> cqlsh> use system_auth;
> cqlsh:system_auth> desc tables;
> resource_role_permissons_index role_permissions role_members roles
> cqlsh:system_auth> select * from roles;
> role | can_login | is_superuser | member_of | salted_hash
> -----------+-----------+--------------+-----------+--------------------------------------------------------------
> cassandra | True | True | null | $2a$10$8UNyioBF41/OZfcCa2aqXOHvXiNXArBHKaUUhMyPAFKpfN8byXonm
> (1 rows)
> cqlsh:system_auth> exit
> {code}
> * Okay, everything worked as expected. Now install {{git}} to clone the Cassandra 4.0 RC1 source code, and {{python3-six}}, which is a dependency of cqlsh
> {code:java}
> root@5d903e48e066:/# apt-get update -qq && apt-get install -qq git python3-six
> ...... [truncated]
> {code}
> * Clone the Cassandra repository and checkout the cassandra-4.0-rc1 tag
> {code:java}
> root@5d903e48e066:/# git clone -b cassandra-4.0-rc1 --depth 1 https://github.com/apache/cassandra.git cassandra-4.0-rc1
> Cloning into 'cassandra-4.0-rc1'...
> ...... [truncated]
> {code}
> * Run the cqlsh from the Git repository, and then repeat all the cqlsh statements above
> {code:java}
> root@5d903e48e066:/# cd cassandra-4.0-rc1/bin
> root@5d903e48e066:/cassandra-4.0-rc1/bin# ./cqlsh
> Connected to Test Cluster at 127.0.0.1:9042
> [cqlsh 6.0.0 | Cassandra 3.11.10 | CQL spec 3.4.4 | Native protocol v4]
> Use HELP for help.
> cqlsh> desc keyspaces;
> cqlsh> use system_auth;
> cqlsh:system_auth> desc tables;
> cqlsh:system_auth> select * from roles;
> role | can_login | is_superuser | member_of | salted_hash
> -----------+-----------+--------------+-----------+--------------------------------------------------------------
> cassandra | True | True | null | $2a$10$8UNyioBF41/OZfcCa2aqXOHvXiNXArBHKaUUhMyPAFKpfN8byXonm
> (1 rows)
> cqlsh:system_auth> exit
> root@5d903e48e066:/cassandra-4.0-rc1/bin#
> {code}
> "desc" did not work correctly, but "use" and "select" worked.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org