[CASSANDRA-17972] nodetool resetlocalschema does not sync schema

• Type: Bug
• Status: Open
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 3.0.x, 3.11.x
• Component/s: Cluster/Schema
• Bug Category: Degradation - Performance Bug/Regression
• Severity: Normal
• Complexity: Normal
• Discovered By: User Report
• Platform: All

Test and Documentation Plan

backported test from newer branches

• Assignee: Stefan Miklosovic
• Reporter: Cameron Zemek

Authors

Stefan Miklosovic

• Created: 19/Oct/22 03:44
• Updated: 10/Nov/22 16:58

Description

Steps to reproduce:

$ ccm create -n 2 -v 3.11.13 -s resettest
$ ccm node1 cqlsh -e "CREATE KEYSPACE test WITH replication = {'class':'NetworkTopologyStrategy', 'datacenter1': 2}"
$ ccm node1 cqlsh -e "CREATE TABLE test.messages(id int primary key, message text)"
$ ccm node1 nodetool describecluster

Cluster Information:
        Name: resettest
        Snitch: org.apache.cassandra.locator.SimpleSnitch
        DynamicEndPointSnitch: enabled
        Partitioner: org.apache.cassandra.dht.Murmur3Partitioner
        Schema versions:
                5172094b-dee2-3967-b5f0-dfd81d572a74: [127.0.0.1, 127.0.0.2]

$ ccm node2 nodetool resetlocalschema
$ ccm node2 cqlsh -e 'describe full schema'

$ find ~/.ccm/resettest/node2/data0/system_schema/ -maxdepth 2 -type f
$ ccm node2 nodetool describecluster

Cluster Information:
        Name: resettest
        Snitch: org.apache.cassandra.locator.SimpleSnitch
        DynamicEndPointSnitch: enabled
        Partitioner: org.apache.cassandra.dht.Murmur3Partitioner
        Schema versions:
                5172094b-dee2-3967-b5f0-dfd81d572a74: [127.0.0.1]

                59adb24e-f3cd-3e02-97f0-5b395827453f: [127.0.0.2]

$ ccm node2 stop
$ ccm node2 start
$ ccm node2 nodetool describecluster

Cluster Information:
        Name: jpmctest
        Snitch: org.apache.cassandra.locator.SimpleSnitch
        DynamicEndPointSnitch: enabled
        Partitioner: org.apache.cassandra.dht.Murmur3Partitioner
        Schema versions:
                5172094b-dee2-3967-b5f0-dfd81d572a74: [127.0.0.1, 127.0.0.2]

Its not resyncing the schema until after restarting the node.

Issue Links

• is caused by: CASSANDRA-15158 Wait for schema agreement rather than in flight schema requests when bootstrapping
• relates to: CASSANDRA-17819 Test failure: org.apache.cassandra.distributed.test.SchemaTest.schemaReset