By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

RDS column is reverting to old value after update

0

After updating a particular column value in one of my Aurora MySql tables, the value gets reverted sometime within the next 24 hours. I've been searching the app's business logic to see if there's a process we created that might cause this, but I haven't found anything yet. Is there any RDS setting that might be doing this?

Topics
AnalyticsDatabase
Tags
Amazon Aurora
Language
English
AWS-User-8629651
asked 2 years ago344 views
1 Answer
0

Hi.

Will only that particular column be returned, and will other columns and tables retain updates?

If so, I think something has been updated, rolled back, or uncommitted.

By outputting the query log, it is possible to analyze whether someone has updated the column.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_LogAccess.html

profile picture
EXPERT
iwasa
answered 2 years ago
profile picture
EXPERT
Gary Mclean
reviewed a month 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

Relevant content