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

[Xon]

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...