new version fixes some issues: https://mariadb.com/kb/en/mariadb-10-5-19-release-notes/
Bugfixes for MariaDB InnoDB - Full-text index corruption with system versioning (MDEV-25004) innodb_undo_log_truncate=ON recovery and backup fixes (MDEV-29999, MDEV-30179, MDEV-30438) - Upgrade after a crash is not supported (MDEV-24412) - Remove InnoDB buffer pool load throttling (MDEV-25417) - InnoDB shutdown hangs when the change buffer is corrupted (MDEV-30009) - innodb_fast_shutdown=0 fails to report change buffer merge progress (MDEV-29984) Galera - Fixes for cluster wide write conflict resolving (MDEV-29684) Replication - Parallel slave applying in binlog order is corrected for admin class of commands including ANALYZE (MDEV-30323) - Seconds_Behind_Master is showed now more precisely at the slave applier start, - including in the delayed mode (MDEV-29639) - mysqlbinlog --verbose is made to show the type of compressed columns (MDEV-25277) - Deadlock is resolved on replica involving BACKUP STAGE BLOCK_COMMIT and a committing user XA (MDEV-30423) General - Infinite sequence of recursive calls when processing embedded CTE (MDEV-30248) - Crash with a query containing nested WINDOW clauses (MDEV-30052) - Major performance regression (MDEV-29988) References: https://mariadb.com/kb/en/mariadb-10-5-19-release-notes/ ======================== Updated packages in core/updates_testing: ======================== mariadb-spider-10.5.19-1.mga8 mariadb-connect-10.5.19-1.mga8 mariadb-sphinx-debuginfo-10.5.19-1.mga8 mariadb-feedback-debuginfo-10.5.19-1.mga8 lib64mariadb3-debuginfo-10.5.19-1.mga8 mariadb-10.5.19-1.mga8 mariadb-obsolete-debuginfo-10.5.19-1.mga8 lib64mariadb3-10.5.19-1.mga8 mariadb-extra-debuginfo-10.5.19-1.mga8 mariadb-sequence-debuginfo-10.5.19-1.mga8 mariadb-common-core-10.5.19-1.mga8 mariadb-extra-10.5.19-1.mga8 mariadb-sphinx-10.5.19-1.mga8 mariadb-obsolete-10.5.19-1.mga8 mariadb-pam-debuginfo-10.5.19-1.mga8 mariadb-sequence-10.5.19-1.mga8 mariadb-pam-10.5.19-1.mga8 mariadb-feedback-10.5.19-1.mga8 mysql-MariaDB-10.5.19-1.mga8 lib64mariadb-devel-debuginfo-10.5.19-1.mga8 mariadb-spider-debuginfo-10.5.19-1.mga8 mariadb-bench-debuginfo-10.5.19-1.mga8 lib64mariadb-devel-10.5.19-1.mga8 mariadb-connect-debuginfo-10.5.19-1.mga8 mariadb-mroonga-10.5.19-1.mga8 mariadb-client-10.5.19-1.mga8 mariadb-mroonga-debuginfo-10.5.19-1.mga8 mariadb-rocks-10.5.19-1.mga8 lib64mariadbd19-10.5.19-1.mga8 mariadb-client-debuginfo-10.5.19-1.mga8 mariadb-core-10.5.19-1.mga8 lib64mariadb-embedded-devel-10.5.19-1.mga8 mariadb-common-10.5.19-1.mga8 mariadb-debuginfo-10.5.19-1.mga8 mariadb-debugsource-10.5.19-1.mga8 lib64mariadbd19-debuginfo-10.5.19-1.mga8 mariadb-core-debuginfo-10.5.19-1.mga8 mariadb-common-debuginfo-10.5.19-1.mga8 mariadb-bench-10.5.19-1.mga8 lib64mariadb-embedded-devel-debuginfo-10.5.19-1.mga8 mariadb-rocks-debuginfo-10.5.19-1.mga8 SRPM: mariadb-10.5.19-1.mga8.src.rpm
Assignee: mageia => qa-bugs
$ uname -a Linux localhost.localdomain 5.15.88-desktop-1.mga8 #1 SMP Sat Jan 14 15:00:41 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux The following 46 packages are going to be installed: - binutils-2.36.1-1.5.mga8.x86_64 - gcc-10.4.0-3.mga8.x86_64 - gcc-cpp-10.4.0-3.mga8.x86_64 - isl-0.18-2.mga8.x86_64 - lib64aio-devel-0.3.112-1.mga8.x86_64 - lib64bz2-devel-1.0.8-2.mga8.x86_64 - lib64isl15-0.18-2.mga8.x86_64 - lib64lz4-devel-1.9.3-1.1.mga8.x86_64 - lib64lzma-devel-5.2.5-2.1.mga8.x86_64 - lib64lzo-devel-2.10-4.mga8.x86_64 - lib64mariadb-devel-10.5.19-1.mga8.x86_64 - lib64mariadb-embedded-devel-10.5.19-1.mga8.x86_64 - lib64mariadb3-10.5.19-1.mga8.x86_64 - lib64mariadbd19-10.5.19-1.mga8.x86_64 - lib64minilzo0-2.10-4.mga8.x86_64 - lib64mpc3-1.2.1-1.mga8.x86_64 - lib64openssl-devel-1.1.1q-1.mga8.x86_64 - lib64pcre2-devel-10.36-1.1.mga8.x86_64 - lib64pcre2posix2-10.36-1.1.mga8.x86_64 - lib64pq5-13.9-1.mga8.x86_64 - lib64unixODBC2-2.3.9-1.mga8.x86_64 - lib64zlib-devel-1.2.12-1.3.mga8.x86_64 - libstdc++-devel-10.4.0-3.mga8.x86_64 - libstdc++-python-devel-10.4.0-3.mga8.x86_64 - mariadb-10.5.19-1.mga8.x86_64 - mariadb-bench-10.5.19-1.mga8.x86_64 - mariadb-client-10.5.19-1.mga8.x86_64 - mariadb-common-10.5.19-1.mga8.x86_64 - mariadb-common-core-10.5.19-1.mga8.x86_64 - mariadb-connect-10.5.19-1.mga8.x86_64 - mariadb-core-10.5.19-1.mga8.x86_64 - mariadb-extra-10.5.19-1.mga8.x86_64 - mariadb-feedback-10.5.19-1.mga8.x86_64 - mariadb-mroonga-10.5.19-1.mga8.x86_64 - mariadb-obsolete-10.5.19-1.mga8.x86_64 - mariadb-pam-10.5.19-1.mga8.x86_64 - mariadb-rocks-10.5.19-1.mga8.x86_64 - mariadb-sequence-10.5.19-1.mga8.x86_64 - mariadb-sphinx-10.5.19-1.mga8.x86_64 - mariadb-spider-10.5.19-1.mga8.x86_64 - multiarch-utils-1.0.14-3.mga8.noarch - mysql-MariaDB-10.5.19-1.mga8.x86_64 - perl-DBD-MariaDB-1.210.0-6.mga8.x86_64 - perl-DBI-1.643.0-4.1.mga8.x86_64 - perl-GD-2.730.0-1.mga8.x86_64 - sphinx-2.3.2-0.beta.3.1.mga8.x86_64 791MB of additional disk space will be used. 119MB of packages will be retrieved. -- started mysqld service Hardening # mysql --version mysql Ver 15.1 Distrib 10.5.19-MariaDB, for Linux (x86_64) using readline 5.1 create database - working create table - working inserting rows - working delete rows with where clause - working final query MariaDB [brian]> select * from mageia; +---------+------------+ | version | enabledate | +---------+------------+ | 1 | 2011-06-01 | | 2 | 2012-05-22 | | 3 | 2013-05-19 | | 4 | 2014-02-01 | | 4.1 | 2014-06-20 | +---------+------------+ 5 rows in set (0.000 sec) works for me in my limited tests.
CC: (none) => brtians1
Installed and tested without issues. Tested with mysql CLI, phpMyAdmin, MySQL Workbench, PHP scripts using PDO/mysql, and Qt6 apps using mysql plugin. Using systemd unix socket activation. Network access is disabled with "skip-networking" option. No issues or regressions noticed. System: Mageia 8, x86_64, AMD CPU. $ uname -a Linux jupiter 6.1.6-desktop-1.mga8 #1 SMP PREEMPT_DYNAMIC Sat Jan 14 13:18:00 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux $ rpm -qa | grep -i mariadb | sort lib64mariadb3-10.5.19-1.mga8 mariadb-10.5.19-1.mga8 mariadb-client-10.5.19-1.mga8 mariadb-common-10.5.19-1.mga8 mariadb-common-core-10.5.19-1.mga8 mariadb-core-10.5.19-1.mga8 mariadb-extra-10.5.19-1.mga8 perl-DBD-MariaDB-1.210.0-6.mga8 # systemctl status mysqld.socket mysqld.service ● mysqld.socket - mysqld Server Socket Loaded: loaded (/usr/local/lib/systemd/system/mysqld.socket; enabled; vendor preset: disabled) Active: inactive (dead) since Thu 2023-02-09 23:43:16 WET; 10min ago Triggers: ● mysqld.service Listen: /run/mysqld/mysqld.socket (Stream) fev 09 10:05:35 jupiter systemd[1]: Listening on mysqld Server Socket. fev 09 23:43:16 jupiter systemd[1]: mysqld.socket: Succeeded. fev 09 23:43:16 jupiter systemd[1]: Closed mysqld Server Socket. ● mysqld.service - MySQL database server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled) Active: active (running) since Thu 2023-02-09 23:43:16 WET; 10min ago TriggeredBy: ● mysqld.socket Process: 29498 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS) Main PID: 29522 (mysqld) Status: "Taking your SQL requests now..." Tasks: 20 (limit: 37625) Memory: 133.3M CPU: 551ms CGroup: /system.slice/mysqld.service └─29522 /usr/sbin/mysqld fev 09 23:43:16 jupiter mysqld[29522]: 2023-02-09 23:43:16 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. fev 09 23:43:16 jupiter mysqld[29522]: 2023-02-09 23:43:16 0 [Note] InnoDB: 10.5.19 started; log sequence number 33050191; transaction id 53035 fev 09 23:43:16 jupiter mysqld[29522]: 2023-02-09 23:43:16 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool fev 09 23:43:16 jupiter mysqld[29522]: 230209 23:43:16 server_audit: MariaDB Audit Plugin version 1.4.14 STARTED. fev 09 23:43:16 jupiter mysqld[29522]: 230209 23:43:16 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2023-02-09 23:43:16 0 [Note] Reading of all Master_info entries succeeded fev 09 23:43:16 jupiter mysqld[29522]: 2023-02-09 23:43:16 0 [Note] Added new Master_info '' to hash table fev 09 23:43:16 jupiter mysqld[29522]: 2023-02-09 23:43:16 0 [Note] /usr/sbin/mysqld: ready for connections. fev 09 23:43:16 jupiter mysqld[29522]: Version: '10.5.19-MariaDB' socket: '/run/mysqld/mysqld.socket' port: 0 Mageia MariaDB Server fev 09 23:43:16 jupiter systemd[1]: Started MySQL database server. fev 09 23:43:16 jupiter mysqld[29522]: 2023-02-09 23:43:16 0 [Note] InnoDB: Buffer pool(s) load completed at 230209 23:43:16
CC: (none) => mageia
This update has been working for 4 days without issues so will give it the OK. Please undo if needed.
Whiteboard: (none) => MGA8-64-OK
Validating. Advisory in comment 1.
Keywords: (none) => validated_updateCC: (none) => andrewsfarm, sysadmin-bugs
Keywords: (none) => advisoryCC: (none) => davidwhodgins
An update for this issue has been pushed to the Mageia Updates repository. https://advisories.mageia.org/MGAA-2023-0015.html
Resolution: (none) => FIXEDStatus: NEW => RESOLVED