RSS Feed/News mariadb innodb_snapshot_isolation=1 causes "Record has changed since last read in table" errors

[ENXF NET]

The default for innodb_snapshot_isolation has changed to default on from MariaDB 10.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

This change apparently applies to...

Read more

Continue reading...