By using AWS re:Post, you agree to the Terms of Use
/Update queries are returning Consistency level errors/

Update queries are returning Consistency level errors

0

In eu-north-1 (Stockholm) MCS

UPDATE tbl SET field='ABC' WHERE other_field='DEF';
InvalidRequest: Error from server: code=2200 [Invalid query] message="Consistency level ONE is not supported for this operation. Supported consistency levels are: LOCAL_QUORUM"

This was not the issue last week. Now Update is not working on existing tables.

The SELECT operations seems to be working fine.

According to Apache the default level is ONE. Same with Cassandra drivers, without config they defaults to ONE. Why now it is changed to LOCAL_QUORUM?

asked 2 years ago3 views
5 Answers
0

All writes in Amazon MCS are stored durably and replicated three times across multiple AWS Availability Zones using LOCAL_QUORUM consistency. To help customers optimize performance and consistency, reads can be executed using either ONE, LOCAL_ONE or LOCAL_QUORUM consistency. Early in the preview, MCS would map unsupported consistency levels to supported levels to help customers migrate workloads without minimal changes to their source code. In this case, ONE was mapped to LOCAL_QUORUM. However, based on customer feedback, we have adjusted MCS to explicitly reject unsupported consistency levels to ensure there is no confusion about the consistency level being used.

answered 2 years ago
0

You mentioned "can be executed using either ONE, LOCAL_ONE or LOCAL_QUORUM consistency". In that case why level ONE is not applicable for UPDATE command?

@cqlsh> CONSISTENCY;
Current consistency level is ONE.
@cqlsh> UPDATE ... SET ... WHERE ...;
InvalidRequest: Error from server: code=2200 [Invalid query] message="Consistency level ONE is not supported for this operation. Supported consistency levels are: LOCAL_QUORUM"
answered 2 years ago
0

Is there a way to configure created keyspace/tables to default to level ONE? Update and Insert commands in provisioning scripts are failing because of default level.

answered 2 years ago
0

Hey Dmitrijs - ONE is only supported for reads, not writes. Can you update your application to use LOCAL_QUORUM just for writes? Are you using ONE for performance? MCS will still offer single-digit write performance, even using LOCAL_QUORUM.

answered 2 years ago
0

I've updated scripts and connector to use configurable consistency level. Thank you for answer!

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions