[CASSANDRA-18030] Few nodes in cassandra 3.11 cluster is unable to connect to v4 protocol version

• Type: Bug
• Status: Resolved
• Priority: Urgent
• Resolution: Invalid
• Severity: Critical
• Platform: All
• Impacts: Spark
• Since Version: 3.11.5
• Assignee: Unassigned
• Reporter: sainath vadyala
• Created: 10/Nov/22 16:32
• Updated: 10/Nov/22 16:36
• Resolved: 10/Nov/22 16:36

Description

We have a Apache Cassandra cluster with 36 nodes running on k8s, cqlsh client was installed in a separate namespace. cqlsh is downgrading version from v4 to v3 on some of the nodes but we have a case where all the nodes need to connect to v4, this is a requirement to set UNSET for avoiding null values to be converted to tombstones (only v4 is supported). 

cqlsh 10.1.2.3 --ssl --protocol-version=3
Connected to production at 10.1.2.3:9042.
[cqlsh 5.0.1 | Cassandra 3.11.5 | CQL spec 3.4.4 | Native protocol v3]
Use HELP for help. 
cqlsh>

cqlsh 10.1.2.3 --ssl --protocol-version=4
Connection error: ('Unable to connect to any servers', {'10.1.2.3': DriverException('ProtocolError returned from server while using explicitly set client protocol_version 4',)})