[CASSANDRA-5875] Ambiguous error message: "You must specify one and only one PRIMARY KEY"

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.0.1
• Assignee: Lyuben Todorov
• Reporter: Jacob Rhoden

Authors

Lyuben Todorov

Reviewers

Jonathan Ellis

• Created: 10/Aug/13 11:41
• Updated: 16/Apr/19 09:32
• Resolved: 15/Aug/13 02:08

Description

Minor issue, but might be beneficial for new people. I was missing a primary key but thought it meant there was more than one primary key, and was confused for a minute. Here is the current error:

Caused by: com.datastax.driver.core.exceptions.InvalidQueryException: You must specify one and only one PRIMARY KEY
at com.datastax.driver.core.ResultSetFuture.convertException(ResultSetFuture.java:252)
at com.datastax.driver.core.ResultSetFuture$ResponseCallback.onSet(ResultSetFuture.java:119)
at com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:202)
at com.datastax.driver.core.RequestHandler.onSet(RequestHandler.java:319)

Recommend considering two different error messages, ie:

• No primary keys were found, when exactly one is required.
• Multiple primary keys were found, when exactly one may be specified.