Error 1020: Record has changed since last read in table

Error Code	SQLSTATE	Error	Description
1020	HY000	ER_CHECKREAD	Record has changed since last read in table '%s'; try restarting transaction

This error is more common in MariaDB 11.8 and later due to changes in snapshot isolation behavior. For more information, see the upgrade guide and innodb_snapshot_isolation pages.

Possible Causes and Solutions

When InnoDB returns this error, it results in a full transaction rollback, not just a statement rollback. For that reason, this error should be treated similarly to a deadlock (ER_LOCK_DEADLOCK) or a lock wait timeout (ER_LOCK_WAIT_TIMEOUT).

Try restarting the transaction.

_{This page is licensed: CC BY-SA / Gnu FDL}