RDS column is reverting to old value after update

Question

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?

Answer

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

RDS column is reverting to old value after update

Relevanter Inhalt