MySQL Forums
Forum List  »  MySQL & Kubernetes

report error "1713 - Undo log record is too big" when update a record
Posted by: Victor Ke
Date: June 08, 2023 08:47PM

when I try to update a record with blob data,it occurs the following error:
[Err] 1713 - Undo log record is too big.

and I‘ve created more undo files by following cmds to fix this problem, but failed.

create undo tablespace undo_003 add datafile '/var/lib/mysql/undo_003.ibu';
create undo tablespace undo_004 add datafile '/var/lib/mysql/undo_004.ibu';
create undo tablespace undo_005 add datafile '/var/lib/mysql/undo_005.ibu';

I've found that it seems bug of mysql,
How can I quikly restore undo space?

Options: ReplyQuote


Subject
Written By
Posted
report error "1713 - Undo log record is too big" when update a record
June 08, 2023 08:47PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.