[CASSANDRA-7256] Error when dropping keyspace.

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.0.11, 2.1.1
• Labels: schema

Environment

ubuntu 3 nodes (had 3 more in 2nd datacenter but removed it)

• Severity: Normal
• Assignee: Aleksey Yeschenko
• Reporter: Steven Lowenthal

Authors

Aleksey Yeschenko

Reviewers

Jonathan Ellis

• Created: 17/May/14 01:20
• Updated: 16/Apr/19 09:31
• Resolved: 10/Oct/14 17:30

Description

created a 3 node datacenter called existing.

ran cassandra-stress:

cassandra-stress -R NetworkTopologyStrategy -O existing:2 -d existing0 -n 2000000 -k

Added a 2nd datacenter called new with 3 nodes started it with auto_bootstrap: false

alter keyspace "Keyspace1" with replication = {'class':'NetworkTopologyStrategy','existing':2,'new':2};

I then discovered that cassandra-stress --operation=read failed with LOCAL_QUORUM if a node was down in the local datacenter - this occured in both, but should not have, so decided to try again.

I shut down the new datacenter and removed all 3 nodes. I then tried to drop the Keyspace1 keyspace. cqlsh disconnected, and the log shows the error below.

ERROR [MigrationStage:1] 2014-05-16 23:57:03,085 CassandraDaemon.java (line 198) Exception in thread Thread[MigrationStage:1,5,main]
java.lang.IllegalStateException: One row required, 0 found
at org.apache.cassandra.cql3.UntypedResultSet.one(UntypedResultSet.java:53)
at org.apache.cassandra.config.KSMetaData.fromSchema(KSMetaData.java:263)
at org.apache.cassandra.db.DefsTables.mergeKeyspaces(DefsTables.java:227)
at org.apache.cassandra.db.DefsTables.mergeSchema(DefsTables.java:182)
at org.apache.cassandra.service.MigrationManager$2.runMayThrow(MigrationManager.java:303)
at org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)

Issue Links

• is duplicated by: CASSANDRA-7823 IllegalStateException with DROP KEYSPACE IF EXISTS XXX