Can you please run the following query on the problematic node?
select peer, host_id, release_version from system.peers where
release_version < '3.0.0' allow filtering;
I suspect you have a "ghost" 2.x node in the system.peers table on this
problematic node.
The "ghost" node will not show up in the "nodetool status" output,
because it does not exist except in the system.peers table.
On 29/07/2021 05:22, Srinivas Polamarasetty wrote:
We have tried restarting couple of times and issue remains same so
repointed to another node and able to communicate with db. We think
some issue with this particular node only
Regards,
Srinivas
Get Outlook for Android <https://aka.ms/AAb9ysg>
------------------------------------------------------------------------
*From:* manish khandelwal <manishkhandelwa...@gmail.com>
*Sent:* Thursday, July 29, 2021 8:31:17 AM
*To:* user@cassandra.apache.org <user@cassandra.apache.org>
*Subject:* Re: Issue with native protocol
Have you tried restarting your application? It should renegotiate the
protoco during handshake and should resolve the issue.
On Wed, Jul 28, 2021 at 3:06 PM Srinivas Polamarasetty
<srinivas.polamarase...@logmein.com
<mailto:srinivas.polamarase...@logmein.com>> wrote:
Query shows 4 but App team also getting below error. They were not
able to communicate with this node.
com.datastax.driver.core.exceptions.CodecNotFoundException: Codec
not found for requested operation:
['org.apache.cassandra.db.marshal.ShortType' <-> java.lang.Short]
[2021-07-09 23:26:52.382 -0700] <cluster1-nio-worker-1>
com.datastax.driver.core.Connection - DEBUG: Got unsupported
protocol version error from /<ip>:<port> for version V4 server
supports version V3
[2021-07-09 23:26:52.382 -0700] <cluster1-nio-worker-1>
com.datastax.driver.core.Connection - DEBUG:
Connection[//<ip>:<port> -1, inFlight=0, closed=true] closing
connection
[2021-07-09 23:26:52.382 -0700] <cluster1-nio-worker-1>
com.datastax.driver.core.Host.STATES - DEBUG: [//<ip>:<port>]
Connection[/10.39.38.166:9042-1, inFlight=0, closed=true] closed,
remaining = 0
[2021-07-09 23:26:52.383 -0700] <main>
com.datastax.driver.core.Cluster - DEBUG: Cannot connect with
protocol V4, trying V3
Regards,
Srinivas P
*From: *Erick Ramirez <erick.rami...@datastax.com
<mailto:erick.rami...@datastax.com>>
*Date: *Wednesday, 28 July 2021 at 12:39 PM
*To: *user@cassandra.apache.org <mailto:user@cassandra.apache.org>
<user@cassandra.apache.org <mailto:user@cassandra.apache.org>>
*Subject: *Re: Issue with native protocol
Someone asked me about the same issue a couple of months ago and
we never managed to figure out why the wrong version is being
displayed.
Could you try to run `SELECT native_protocol_version FROM
system.local`? It should come back with 4. Cheers!