[CASSANDRA-12351] IllegalStateException: empty rows returned when reading system.schema_keyspaces

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.2.8
• Component/s: Legacy/Local Write-Read Paths
• Severity: Normal
• Assignee: Sylvain Lebresne
• Reporter: Michael Semb Wever

Authors

Sylvain Lebresne

• Created: 01/Aug/16 03:56
• Updated: 16/Apr/19 09:30
• Resolved: 02/Aug/16 14:00

Description

After 2.2.6 the following error is thrown during startup, resulting in Cassandra not starting.

CassandraDaemon.java:644 - Exception encountered during startup
java.lang.IllegalStateException: One row required, 0 found
at org.apache.cassandra.cql3.UntypedResultSet$FromResultSet.one(UntypedResultSet.java:77) ~[apache-cassandra-2.2.7.jar:2.2.7-SNAPSHOT]
at org.apache.cassandra.schema.LegacySchemaTables.createKeyspaceFromSchemaPartition(LegacySchemaTables.java:758) ~[apache-cassandra-2.2.7.jar:2.2.7-SNAPSHOT]
at org.apache.cassandra.schema.LegacySchemaTables.createKeyspaceFromSchemaPartitions(LegacySchemaTables.java:737) ~[apache-cassandra-2.2.7.jar:2.2.7-SNAPSHOT]
at org.apache.cassandra.schema.LegacySchemaTables.readSchemaFromSystemTables(LegacySchemaTables.java:219) ~[apache-cassandra-2.2.7.jar:2.2.7-SNAPSHOT]
at org.apache.cassandra.config.Schema.loadFromDisk(Schema.java:117) ~[apache-cassandra-2.2.7.jar:2.2.7-SNAPSHOT]
at org.apache.cassandra.config.Schema.loadFromDisk(Schema.java:107) ~[apache-cassandra-2.2.7.jar:2.2.7-SNAPSHOT]
at org.apache.cassandra.service.CassandraDaemon.setup(CassandraDaemon.java:215) [apache-cassandra-2.2.7.jar:2.2.7-SNAPSHOT]
at org.apache.cassandra.service.CassandraDaemon.activate(CassandraDaemon.java:522) [apache-cassandra-2.2.7.jar:2.2.7-SNAPSHOT]
at org.apache.cassandra.service.CassandraDaemon.main(CassandraDaemon.java:631) [apache-cassandra-2.2.7.jar:2.2.7-SNAPSHOT]

In LegacySchemaTables.readSchemaFromSystemTables(..) the call to getSchemaPartitionsForTable(KEYSPACES) is now (since 2.2.6) returning more rows. The additional rows are empty.

These rows are coming out of the row iterator post 2.2.6, where they were not in 2.2.6.

This issue was raised on the mailing list here.

Issue Links

• is broken by: CASSANDRA-11427 Range slice queries CL > ONE trigger read-repair of purgeable tombstones
• is duplicated by: CASSANDRA-12592 Error when upgrading from 2.2.6 to 2.2.7