StorageGRID Upgrade to 12.0 fails while enabling new features waiting for the drop table operation

• Upgrading StorageGRID version to 12.0 fails with the error while enabling features step:
  • An error occurred while enabling new features: Timed out or reached maximum attempts while waiting for the drop table operation to complete.

• Review /var/local/log/upgrade.log: We find 2 different schemas causing mismatch due to one of Cassandra nodes:

I, [2025-11-18T11:08:32.336919 #2880821]  INFO -- : Schema not in agreement across entire cluster.
I, [2025-11-18T11:08:32.336979 #2880821]  INFO -- : Local schema (XXXXX): e0cb085s-4a02-3d41-8783-44f78946ff5g
peer      | schema_version
-----------+--------------------------------------
XX.XX.XX.XX | 6026e8ee-XXXX-XXXX-XXXX-30XXXXXX
XX.XX.XX.XX | 6026e8ee-XXXX-XXXX-XXXX-30XXXXXX
XX.XX.XX.XX | 6026e8ee-XXXX-XXXX-XXXX-30XXXXXX
XX.XX.XX.XX | 6026e8ee-XXXX-XXXX-XXXX-30XXXXXX
XX.XX.XX.XX | 6026e8ee-XXXX-XXXX-XXXX-30XXXXXX
XX.XX.XX.XX | 6026e8ee-XXXX-XXXX-XXXX-30XXXXXX
XX.XX.XX.XX | 6026e8ee-XXXX-XXXX-XXXX-30XXXXXX
XX.XX.XX.XX | 6026e8ee-XXXX-XXXX-XXXX-30XXXXXX
XX.XX.XX.XX | 6026e8ee-XXXX-XXXX-XXXX-30XXXXXX
XX.XX.XX.XX | 6026e8ee-XXXX-XXXX-XXXX-30XXXXXX
XX.XX.XX.XX | e0cb085s-4a02-3d41-8783-44f78946ff5g
XX.XX.XX.XX | 6026e8ee-XXXX-XXXX-XXXX-30XXXXXX

 E, [2025-11-18T11:08:36.251773 #2880821] ERROR -- : Error while running upgrade enable features. 

E, [2025-11-18T11:08:36.251851 #2880821] ERROR -- : Timed out or reached maximum attempts while waiting for the drop table operation to complete. (Cassandra::Error)

E, [2025-11-18T11:08:36.251881 #2880821] ERROR -- :     /var/local/install/upgrade-stage/swupdate/lib/upgrade/cassandra-schema.rb:350:in `rescue in block in drop_tables'

"failure": "Timed out or reached maximum attempts while waiting for the drop table operation to complete."

• Review of command nodetool describecluster on any storage node shows 2 different schemas causing mismatch:
  • Schema versions: 6026e8ee-XXXX-XXXX-XXXX-30XXXXXX
  • Schema versions: e0cb085d-XXXX-XXXX-XXXX-55f68926df5f

• Further looking into upgrade.log file, we observe failed table drop errors:

I, [2025-11-17T18:21:25.353131 #1268849]INFO -- : Executing command `cql -e "DROP TABLE IF EXISTS accounts.keystone_servers" 2>&1` on XXXXX
W, [2025-11-17T18:21:37.470750 #1268849]WARN -- : Failed to drop table on attempt 2. Retrying in 15 seconds.

W, [2025-11-17T18:51:47.639017 #1268849]WARN -- : Failed to drop table on attempt 9. Retrying in 15 seconds.
E, [2025-11-17T18:56:06.484958 #1268849] ERROR -- : Timed out or reached maximum attempts while waiting for the drop table operation to complete. (Cassandra::Error)