1
1
mirror of https://gitlab.archlinux.org/archlinux/infrastructure.git synced 2025-01-18 08:06:16 +01:00
infrastructure/playbooks
Christian Heusel 79d069df89
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: https://gitlab.archlinux.org/archlinux/aurweb/-/issues/525
Signed-off-by: Christian Heusel <christian@heusel.eu>
2024-12-16 17:58:56 +01:00
..
tasks Fix packer and update plugins 2024-11-19 11:34:37 +01:00
accounts.archlinux.org.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
all-hosts-basic.yml Enable the sshd role in playbooks/all-hosts-basic 2022-10-14 20:14:16 +03:00
archive-mirrors.yml Combine sync{archive,debug,riscv} into mirrorsync 2022-09-28 21:52:52 +03:00
archlinux.org.yml Capitalize a play name that was originally missed 2022-09-01 20:12:18 +03:00
aur-dev.archlinux.org.yml migrate all services from redis to valkey 2024-08-19 11:02:31 +02:00
aur.archlinux.org.yml mariadb: Add switch for innodb_snapshot_isolation 2024-12-16 17:58:56 +01:00
bbs.archlinux.org.yml mariadb: Add switch for innodb_snapshot_isolation 2024-12-16 17:58:56 +01:00
bugbuddy.archlinux.org.yml bugbuddy: add role with full service setup 2023-10-16 22:14:10 +02:00
build.archlinux.org.yml Replace mlocate with plocate on build.archlinux.org 2024-10-06 14:51:16 +02:00
dashboards.archlinux.org.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
debuginfod.archlinux.org.yml Combine sync{archive,debug,riscv} into mirrorsync 2022-09-28 21:52:52 +03:00
gemini.archlinux.org.yml playbooks/gemini: drop svntogit_repos dbscripts var 2023-05-23 23:37:13 +03:00
gitlab-runners.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
gitlab.archlinux.org.yml gitlab: move gitlab to bare metal host 2023-05-06 21:23:29 +01:00
gluebuddy.archlinux.org.yml Don't backup the gluebuddy server 2023-07-23 22:57:07 +02:00
hetzner_storagebox.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
homedir.archlinux.org.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
lists.archlinux.org.yml Kill the mailman2 server and put the mailman3 server in its place 2022-09-28 21:04:41 +02:00
mail.archlinux.org.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
man.archlinux.org.yml Update archmanweb to v1.14 2024-10-19 21:23:42 +02:00
matrix.archlinux.org.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
md.archlinux.org.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
mirrors.yml Combine sync{archive,debug,riscv} into mirrorsync 2022-09-28 21:52:52 +03:00
monitoring.archlinux.org.yml Deploy tempo 2024-08-03 22:30:16 +02:00
mumble.archlinux.org.yml Add Mumble server 2024-11-26 14:30:42 +01:00
opensearch.archlinux.org.yml Setup OpenSearch server for GitLab's advanced search feature[1] 2023-05-24 19:04:26 +02:00
phrik.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
quassel.archlinux.org.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
rebuilderd-workers.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
redirect.archlinux.org.yml acme_dns_challenge: turn into more generic dyn_dns 2023-08-18 19:30:52 +03:00
repos.archlinux.org.yml add the certbot role to repos.archlinux.org 2024-07-21 23:59:11 +02:00
reproducible.archlinux.org.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
rsync.net.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
security.archlinux.org.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
state.archlinux.org.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
wiki.archlinux.org.yml Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00