X

mariadb innodb_snapshot_isolation=1 causes "Record has changed since last read in table" errors

Visitor Greeting

Welcome to NullWarehouse.com... We are currently seeking Mod's and Contributors. If you wish to apply for a Mod position then please click on Members dropdown arrow, then click on Staff App and fill it out completely and submit it. If you want to be a Contributor then start contributing and we will have our eye on you and take notice, something great could come of it.

  • We have redone the forum. If you notice any issues or errors please open a Support Ticket under the Members dropdown and let us know.
X

Xon

Guest

The default for innodb_snapshot_isolation has changed to default on from MariaDB 11.6.2 which changes transaction behavior.

This can causes errors such as:
Code:

XF\Db\Exception: MySQL query error [1020]: Record has changed since last read in table 'xf_user' src/XF/Db/AbstractStatement.php:230
Code:

XF\Db\Exception: MySQL query error [1020]: Record has changed since last read in table 'xf_data_registry' src/XF/Db/AbstractStatement.php:230

I can't actually see the change in major...

Read more

Continue reading...
 
Similar content Most view View more
Back
Top Bottom