mariadb: Add switch for innodb_snapshot_isolation

With the 11.6.2 release mariadb has made snapshot isolation a default setting which recently caused issues on the AUR and the Forums, where the respective database engines would fail due to the table changing since the last time they read it:

PHP Fatal error:  Uncaught mysqli_sql_exception: Record has changed since last read in table 'fluxbb_online' in /srv/http/fluxbb/include/dblayer/mysqli_innodb.php:79
Stack trace:
#0 /srv/http/fluxbb/include/dblayer/mysqli_innodb.php(79): mysqli_query()
#1 /srv/http/fluxbb/include/functions.php(485): DBLayer->query()
#2 /srv/http/fluxbb/include/common.php(162): update_users_online()
#3 /srv/http/fluxbb/viewtopic.php(10): require('...')
#4 {main}

We therefore introduce a config switch to restore the old behavior and apply the changed setting on the two services.

Link: https://mariadb.com/kb/en/mariadb-11-6-2-release-notes/#innodb
Link: https://bbs.archlinux.org/viewtopic.php?id=301802
Link: aurweb#525 (closed)
Signed-off-by: Christian Heusel christian@heusel.eu

requested review from @artafinde

assigned to @gromit

changed the description

added 1 commit

• f946e7f0 - mariadb: Add switch for innodb_snapshot_isolation

Compare with previous version

added 2 commits

• ff328905 - 1 commit from branch master
• a52b0e55 - mariadb: Add switch for innodb_snapshot_isolation

Compare with previous version

I have already deployed this MR and it fixes the issue on the BBS, @artafinde did the same a few days ago on the AUR.

changed the description

added 1 commit

• 3300cad0 - mariadb: Add switch for innodb_snapshot_isolation

Compare with previous version

approved this merge request

approved this merge request

Thanks for this @gromit I was planning to make an MR about it and then forgot.

added 3 commits

• 3300cad0...dcdfdc93 - 2 commits from branch master
• ca5f9d5c - mariadb: Add switch for innodb_snapshot_isolation

Compare with previous version

added 1 commit

• 79d069df - mariadb: Add switch for innodb_snapshot_isolation

Compare with previous version

reset approvals from @svenstaro and @artafinde by pushing to the branch

mentioned in commit 7c2672e9

merged manually