prepare() server internal error when using TTL
<b>AWS Update:</b> Keyspaces now supports TTL: https://aws.amazon.com/blogs/database/announcing-amazon-keyspaces-time-to-live-ttl-general-availability/
I am seeing an internal error returrned from key space when I try to prepare the following statement.
createAccessToken = getSession().prepare(
"INSERT INTO access_tokens" + "(atokenid, atoken, useruuid, auth, clientid, expiration, time, code, version)"
+ "VALUES (?,?,?,?,?, ?,?,?,?) IF NOT EXISTS USING TTL ?;");
The issue appears to be with the USING TTL ? since the following prepare doesn't exhibit the issue.
createAccessToken = getSession().prepare(
"INSERT INTO access_tokens" + "(atokenid, useruuid, atoken, auth, clientid, code, expiration, time, version)"
+ "VALUES (?,?,?,?,?, ?,?,?,?) USING TTL 200;");
Anybody know of a work around that doesn't have me hard code the ttl?
Edited by: ArturoAtAWS on Oct 18, 2021 3:03 PM
Thanks for the question and info! Our roadmap is driven by customer feedback so it's super helpful to get more info on how you are using prepared statements with TTL.
Relevant questions
TTL_EXPIRED in aws pinpoint: How to handle it, how to override the TTL?
Accepted Answerasked a month agoDynamoDB TTL - Expiration Time
Accepted Answerasked a year agoLambda triggers and Time to Live (TTL)
asked a year agoDelete records in Dynamodb without a TTL
Accepted Answerasked 3 years agoDAX Evict Query Cache
asked 3 years agoEB instance Degraded after Platform update
asked 2 years agoAmazon dax client not working as per TTL set on the item
asked 3 years agoprepare() server internal error when using TTL
asked 2 years agoApplication Migration Service, 2 source servers into 1
asked 12 days agoRoute 53 Default TTL
Accepted Answerasked 2 years ago