mirror/infrastructure
1
1
Fork 0
mirror of https://gitlab.archlinux.org/archlinux/infrastructure.git synced 2025-01-18 08:06:16 +01:00
Code Issues
innodb-snapshot-isolation
infrastructure/roles
History
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
..
alertmanager Capitalize the handler name in handler invocations 2022-08-29 21:46:39 +03:00
arch_boxes_sync arch_boxes_sync: Trigger immediately mirror sync by updating lastupdate 2022-09-18 13:25:52 +02:00
archbuild archbuild: fix srcdest perms, group renamed to junior-packager 2024-12-07 19:39:52 +01:00
archive archive: fix creates= argument to ia configure task 2023-03-20 22:09:01 +02:00
archive_web nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
archmanweb Replace deprecated git gpg_allowlist to gpg_whitelist 2024-09-15 12:47:29 +03:00
archusers Fix lint warning about non-FQCN ansible.builtin.user 2022-09-19 00:47:07 +03:00
archweb Replace deprecated git gpg_allowlist to gpg_whitelist 2024-09-15 12:47:29 +03:00
archwiki archwiki: add php syntax check 2024-10-21 00:53:30 +02:00
aurweb aurweb: upgrade to 6.2.15 2024-09-16 01:01:53 +01:00
borg_client Revert "Limit Borg CPU usage on single vCPU servers to 50%" 2024-07-27 19:56:43 +02:00
borg_server/tasks ansible-lint: Forbidden implicit octal value 'xxxx' 2023-02-18 20:15:54 +02:00
bugbot Replace deprecated git gpg_allowlist to gpg_whitelist 2024-09-15 12:47:29 +03:00
bugbuddy bugbuddy: allow releases from gromit 2024-07-01 00:14:21 +02:00
certbot Add Mumble server 2024-11-26 14:30:42 +01:00
certificate certificate: Allow creating legacy certs 2024-07-28 02:55:15 +02:00
common common: rebase pacman.conf to pacman 7.0.0.r1.g7cf2b01-1 2024-09-28 21:19:20 +03:00
dbscripts dbscripts: switch group perm of /srv/ftp/other/packages to dev-packager 2024-12-01 18:23:31 +01:00
debuginfod nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
dovecot dovecot: Enable the body Sieve extension 2024-08-14 14:33:37 -04:00
dyn_dns acme_dns_challenge: turn into more generic dyn_dns 2023-08-18 19:30:52 +03:00
fail2ban fail2ban: fix task name to refer to a correct file 2024-08-19 20:41:07 +02:00
fetchmail Capitalize the handler name in handler invocations 2022-08-29 21:46:39 +03:00
firewalld firewalld: add missing permanent option 2024-08-19 20:41:05 +02:00
fluxbb nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
geo_dns Enable HTTP/3 for the mirrors 2024-10-06 00:59:31 +02:00
geoipupdate geoipupdate: hardcode EditionIDs to country + city 2024-07-24 01:00:15 +03:00
gitlab gitlab: Fix bot-token-extender script not extending project membership 2024-12-15 21:03:21 +01:00
gitlab_runner gitlab_runner: Boot VMs in UEFI mode 2024-12-15 15:32:02 +01:00
gluebuddy gitlab: Add ruby script for continuous extending of bot tokens 2024-11-03 19:24:13 +01:00
grafana grafana: rebase grafana.ini to grafana 11.4.0-1 2024-12-07 22:03:21 +02:00
hardening hardening: reject authentication with empty passwd 2023-09-24 20:16:35 +03:00
hedgedoc nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
hetzner_storagebox ansible-lint: Forbidden implicit octal value 'xxxx' 2023-02-18 20:15:54 +02:00
install_arch install_arch: skip UEFI partition on cloud servers 2024-08-06 20:41:22 +03:00
keycloak nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
libvirt gitlab_runner: Remove tight coupling to libvirt filesystem pool 2024-12-15 15:14:20 +01:00
loki loki: switch index to TSDB 2024-07-03 08:05:18 +03:00
mailman nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
maintenance nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
mariadb mariadb: Add switch for innodb_snapshot_isolation 2024-12-16 17:58:56 +01:00
matrix matrix: Update synapse to 1.121.1 2024-12-11 23:40:57 +01:00
memcached ansible-lint: address no-changed-when fatal errors 2023-02-18 20:15:55 +02:00
mirrorsync nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
mta_sts nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
mumble_server Add Mumble server 2024-11-26 14:30:42 +01:00
networking networking: support additional addresses on networking role 2023-05-06 21:23:28 +01:00
nginx nginx: Add missing whitespace in "log_format main" 2024-08-18 17:29:30 +02:00
opensearch Setup OpenSearch server for GitLab's advanced search feature[1] 2023-05-24 19:04:26 +02:00
php_fpm php_fpm: rebase php.ini to php 8.3.2-1 2024-01-20 22:29:06 +02:00
phrik validate the sudoers files before using 2024-04-24 19:28:19 +02:00
ping nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
postfix ansible-lint: address no-changed-when fatal errors 2023-03-26 16:57:00 +03:00
postfix_null postfix_null: Use fixed amount of rounds for password_hash 2024-10-27 00:49:45 +02:00
postfwd postfwd: Disable the email limits for gitlab 2024-01-27 20:48:06 +01:00
postgres borg_client: refactor database related vars/tasks 2024-03-30 19:08:37 +02:00
prometheus Add alert for Fastly cost 2024-12-15 18:06:39 +01:00
prometheus_exporters Add alert for Fastly cost 2024-12-15 18:06:39 +01:00
promtail Move from broken ansible_fqdn variable to inventory_hostname 2024-08-18 18:01:56 +02:00
public_html nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
quassel Add ansible.builtin qualification to become_method 2023-09-22 23:38:23 +03:00
rebuilderd nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
rebuilderd_worker Capitalize the handler name in handler invocations 2022-08-29 21:46:39 +03:00
redirects nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
repo_archive_split_temp nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
root_ssh root_ssh: Add variable to define additional keys 2023-08-21 22:07:50 +02:00
rspamd migrate all services from redis to valkey 2024-08-19 11:02:31 +02:00
rsync_net Fix template-instead-of-copy lint failures 2022-09-18 23:49:50 +03:00
security_tracker nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
sources nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
sshd add the new build server 2024-01-19 23:16:55 +01:00
sudo sudo: drop task that sets secure_path in sudoers 2024-08-03 21:14:46 +03:00
syncrepo nginx: Add plumbing for enabling HTTP/3 conditionally 2024-08-17 21:53:32 +02:00
tempo tempo: fix wireguard firewall port for aur.archlinux.org 2024-08-16 21:02:33 +02:00
terraform_state Add ansible.builtin qualification to become_method 2023-09-22 23:38:23 +03:00
tools/tasks Capitalize the first letter of all task names 2022-08-23 06:57:13 +03:00
unbound Capitalize the handler name in handler invocations 2022-08-29 21:46:39 +03:00
uwsgi Capitalize the handler name in handler invocations 2022-08-29 21:46:39 +03:00
valkey/tasks migrate all services from redis to valkey 2024-08-19 11:02:31 +02:00
wireguard Remove the WG private keys from the vault and store them only on the servers 2024-12-15 17:08:21 +01:00