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

Paulo Motta commented on CASSANDRA-11850:
-----------------------------------------

Thanks for the patch and detailed explanation! Overall it looks good, see 
follow-up:
* The 2.1 patch looks, can you just update to use the 2.7.2 zip now that 
[#606|https://github.com/datastax/python-driver/pull/606] got in?
* Similarly, can you regenerate the 2.2+ cassandra-driver libs after 
[#617|https://github.com/datastax/python-driver/pull/617] was merged?
* I didn't get [this 
change|https://github.com/apache/cassandra/compare/trunk...stef1927:11850-cqlsh-2.2#diff-27e394435c04a60c58ec9d5c34397341R739],
 is this related to this patch? won't {{prev_worker_no=-1}} and thus {{i=0}} 
always?
* +1 to dtest and cdc-related changes (afaic)
* The original intent of {{test_refresh_schema_on_timeout_error}} on 
CASSANDRA-9689 was to make sure a newly created keyspace/table will show up if 
there is a down node during the {{DDL}} statement, but since down nodes no 
longer causes schema mismatches after 
[PYTHON-531|https://datastax-oss.atlassian.net/browse/PYTHON-531] the schema 
mismatch assertions are no longer necessary (even though we still need to keep 
the {{--request-timeout}} option on 2.1 dtest to avoid flakiness - see 
CASSANDRA-10686), so I renamed the test to 
{{test_update_schema_with_down_node}}. Here is the [dtest 
branch|https://github.com/pauloricardomg/cassandra-dtest/tree/11850] with these 
changes.
* I also added a [new 
commit|https://github.com/pauloricardomg/cassandra/commit/02c3c25f92e395e09c66ba36010abb8e38f23d0b]
 with the following changes:
** Refactor {{perform_simple_statement}} to always [try to reload the 
schema|https://github.com/pauloricardomg/cassandra/commit/02c3c25f92e395e09c66ba36010abb8e38f23d0b#diff-1cce67f7d76864f07aaf4d986d6fc051R1272]
 if there's a mismatch in order to cover both CASSANDRA-9689 and 
CASSANDRA-10686.
** 
[Remove|https://github.com/pauloricardomg/cassandra/commit/02c3c25f92e395e09c66ba36010abb8e38f23d0b#diff-1cce67f7d76864f07aaf4d986d6fc051L724]
 the schema mismatch check on startup, since this is no longer necessary after 
[PYTHON-303|https://github.com/datastax/python-driver/pull/349].
** Update the schema mismatch warning 
[message|https://github.com/pauloricardomg/cassandra/commit/02c3c25f92e395e09c66ba36010abb8e38f23d0b#diff-1cce67f7d76864f07aaf4d986d6fc051R1276]
* It would be nice to add a dtest to verify that the schema mismatch warning is 
being print on a proper schema mismatch but I didn't find a simple way to 
induce a schema mismatch without adding a special test flag on C* which is not 
an ideal solution. I tested manually by disabling the {{schema_version}} update 
on the {{system.peers}} table, and the warning is being printed correctly. We 
could probably achieve that easily with byteman but since that is not yet 
integrated with dtests let's maybe leave it for another ticket.
* Submitted multiplexer 100x runs for 
[2.1|https://cassci.datastax.com/view/Parameterized/job/parameterized_dtest_multiplexer/176/]
 and 
[trunk|https://cassci.datastax.com/view/Parameterized/job/parameterized_dtest_multiplexer/173/]
 so we can remove the {{@known_failure}} annotations and close CASSANDRA-11999 
and CASSANDRA-10884.
* It would be nice if you could maybe extract CASSANDRA-11979 to a separate 
commit to improve traceability?

Submitted tests with updates below:
||2.1||2.2||3.0||3.9||trunk||dtest||
|[branch|https://github.com/apache/cassandra/compare/cassandra-2.1...pauloricardomg:11850-cqlsh-2.1]|[branch|https://github.com/apache/cassandra/compare/cassandra-2.2...pauloricardomg:11850-cqlsh-2.2]|[branch|https://github.com/apache/cassandra/compare/cassandra-3.0...pauloricardomg:11850-cqlsh-3.0]|[branch|https://github.com/apache/cassandra/compare/cassandra-3.9...pauloricardomg:11850-cqlsh-3.9]|[branch|https://github.com/apache/cassandra/compare/trunk...pauloricardomg:11850-cqlsh]|[branch|https://github.com/riptano/cassandra-dtest/compare/master...pauloricardomg:11850]|
|[dtest|http://cassci.datastax.com/view/Dev/view/paulomotta/job/pauloricardomg-11850-cqlsh-2.1-dtest/lastCompletedBuild/testReport/]|[dtest|http://cassci.datastax.com/view/Dev/view/paulomotta/job/pauloricardomg-11850-cqlsh-2.2-dtest/lastCompletedBuild/testReport/]|[dtest|http://cassci.datastax.com/view/Dev/view/paulomotta/job/pauloricardomg-11850-cqlsh-3.0-dtest/lastCompletedBuild/testReport/]|[dtest|http://cassci.datastax.com/view/Dev/view/paulomotta/job/pauloricardomg-11850-cqlsh-3.9-dtest/lastCompletedBuild/testReport/]|[dtest|http://cassci.datastax.com/view/Dev/view/paulomotta/job/pauloricardomg-11850-cqlsh-dtest/lastCompletedBuild/testReport/]|

> cannot use cql since upgrading python to 2.7.11+
> ------------------------------------------------
>
>                 Key: CASSANDRA-11850
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11850
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CQL
>         Environment: Development
>            Reporter: Andrew Madison
>            Assignee: Stefania
>              Labels: cqlsh
>             Fix For: 2.1.x, 2.2.x, 3.0.x, 3.x
>
>
> OS: Debian GNU/Linux stretch/sid 
> Kernel: 4.5.0-2-amd64 #1 SMP Debian 4.5.4-1 (2016-05-16) x86_64 GNU/Linux
> Python version: 2.7.11+ (default, May  9 2016, 15:54:33)
> [GCC 5.3.1 20160429]
> cqlsh --version: cqlsh 5.0.1
> cassandra -v: 3.5 (also occurs with 3.0.6)
> Issue:
> when running cqlsh, it returns the following error:
> cqlsh -u dbarpt_usr01
> Password: *****
> Connection error: ('Unable to connect to any servers', {'odbasandbox1': 
> TypeError('ref() does not take keyword arguments',)})
> I cleared PYTHONPATH:
> python -c "import json; print dir(json); print json.__version__"
> ['JSONDecoder', 'JSONEncoder', '__all__', '__author__', '__builtins__', 
> '__doc__', '__file__', '__name__', '__package__', '__path__', '__version__', 
> '_default_decoder', '_default_encoder', 'decoder', 'dump', 'dumps', 
> 'encoder', 'load', 'loads', 'scanner']
> 2.0.9
> Java based clients can connect to Cassandra with no issue. Just CQLSH and 
> Python clients cannot.
> nodetool status also works.
> Thank you for your help.



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

Reply via email to