May 2022 - discuss - lists.mariadb.org

[Maria-discuss] Repos empty?
by William Edwards 15 Aug '22

15 Aug '22

Hello, The Debian repos @ https://mariadb.org/download/?t=repo-config don't seem to contain any packages and no Release file anymore. Last updated yesterday at 18:41 (IDK which timezone). E.g. http://ams2.mirrors.digitalocean.com/mariadb/repo/10.3/debian/dists/buster/… (the issue isn't with this specific mirror). When choosing a repo on mariadb.org, the error "An error occured. The mirrors could not be loaded." is shown. -- With kind regards, William Edwards

2 4

[Maria-discuss] Major upgrade instructions missing for Galera
by William Edwards 10 Aug '22

10 Aug '22

Hi, The documentation at https://mariadb.com/kb/en/upgrading-galera-cluster/ is missing major upgrade instructions > MariaDB 10.4. Someone else caught this as well: https://mariadb.com/kb/en/upgrading-from-104-to-105-galera-changes/ Is this intentional? -- With kind regards, William Edwards

3 6

[Maria-discuss] Incorrect Documentation: Replicating JSON from MySQL to MariaDB
by Gordan Bobic 29 May '22

29 May '22

On this page: https://mariadb.com/kb/en/json-data-type/ it states: If you must use row-based replication and cannot change the MySQL master from JSON to TEXT, you can try to introduce an intermediate MySQL slave and change the column type from JSON to TEXT on it. Then you replicate from this intermediate slave to MariaDB. I can confirm that this does not work with MySQL 5.7. If you have a 5.7 master and you replicate to 5.7 slave, and you convert the slave's json columns to longtext, replication fails with this error: "Column X of table 'dbname.tablename' cannot be converted from type 'json' to type 'longtext'" Using longblob doesn't work either. So it seems there is currently no viable solution for replicating anything that involves JSON columns from MySQL to MariaDB.

2 2

[Maria-discuss] Custom Galera SST Method Documentation
by Gordan Bobic 27 May '22

27 May '22

Hi, I vaguely remember reading something years ago about implementing a custom SST method, but I cannot seem to find any documentation for it now. Is there any documentation on the interfaces that scripts need to implement and how to hook up said scripts into the config files?

2 2

[Maria-discuss] dpkg: mariadb-client-10.x: dependency problems, but removing anyway as you requested
by William Edwards 25 May '22

25 May '22

Hi, Using the official MariaDB repos, since MariaDB 10.4, mariadb-client-10.x is removed, then installed on 'apt upgrade': ``` Unpacking libmariadb3:amd64 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... dpkg: mariadb-client-10.7: dependency problems, but removing anyway as you requested: mariadb-server-10.7 depends on mariadb-client-10.7 (>= 1:10.7.3+maria~buster). mariadb-client depends on mariadb-client-10.7 (>= 1:10.7.4+maria~buster). (Reading database ... 87804 files and directories currently installed.) Removing mariadb-client-10.7 (1:10.7.3+maria~buster) ... Setting up mysql-common (1:10.7.4+maria~buster) ... Setting up mariadb-common (1:10.7.4+maria~buster) ... (Reading database ... 87703 files and directories currently installed.) Preparing to unpack .../00-mariadb-server-10.7_1%3a10.7.4+maria~buster_amd64.deb ... /var/lib/mysql: found previous version 10.7 Unpacking mariadb-server-10.7 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../01-mariadb-server-core-10.7_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking mariadb-server-core-10.7 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../02-mariadb-client-core-10.7_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking mariadb-client-core-10.7 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Selecting previously unselected package mariadb-client-10.7. Preparing to unpack .../03-mariadb-client-10.7_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking mariadb-client-10.7 (1:10.7.4+maria~buster) ... ``` This does not seem to be a problem, but I'd like to understand what changed between 10.3 and 10.4 that causes this. Policy output and full 'apt upgrade' transaction log: ``` root@http-msh01:~# apt upgrade Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... Done The following packages will be upgraded: filebeat libavcodec58 libavfilter7 libavformat58 libavutil56 libldap-2.4-2 libldap-common libmariadb-dev libmariadb-dev-compat libmariadb3 libpostproc55 libpq5 libssl-dev libssl1.1 libswresample3 libswscale5 libxml2 mariadb-client mariadb-client-10.7 mariadb-client-core-10.7 mariadb-common mariadb-server mariadb-server-10.7 mariadb-server-core-10.7 mysql-common nodejs openjdk-11-jre openjdk-11-jre-headless openssl php8.1 php8.1-bcmath php8.1-cli php8.1-common php8.1-curl php8.1-dev php8.1-fpm php8.1-gd php8.1-imap php8.1-intl php8.1-mbstring php8.1-mysql php8.1-opcache php8.1-readline php8.1-soap php8.1-sqlite3 php8.1-xml php8.1-zip sensu-go-agent 55 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 142 MB of archives. After this operation, 10.3 MB of additional disk space will be used. Do you want to continue? [Y/n] Get:1 http://security.debian.org/debian-security buster/updates/main amd64 libssl-dev amd64 1.1.1n-0+deb10u2 [1,807 kB] Get:9 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mysql-common all 1:10.7.4+maria~buster [2,880 B] Get:10 http://security.debian.org/debian-security buster/updates/main amd64 libssl1.1 amd64 1.1.1n-0+deb10u2 [1,551 kB] Get:11 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-common all 1:10.7.4+maria~buster [4,052 B] Get:12 http://security.debian.org/debian-security buster/updates/main amd64 libldap-common all 2.4.47+dfsg-3+deb10u7 [90.1 kB] Get:13 http://security.debian.org/debian-security buster/updates/main amd64 libldap-2.4-2 amd64 2.4.47+dfsg-3+deb10u7 [224 kB] Get:14 https://artifacts.elastic.co/packages/7.x/apt stable/main amd64 filebeat amd64 7.17.4 [37.8 MB] Get:15 http://security.debian.org/debian-security buster/updates/main amd64 libavfilter7 amd64 7:4.1.9-0+deb10u1 [1,053 kB] Get:16 https://packages.sury.org/php buster/main amd64 libxml2 amd64 2.9.14+dfsg-0+0~20220524.12+debian10~1.gbpc5dc45 [701 kB] Get:17 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-server all 1:10.7.4+maria~buster [2,832 B] Get:18 http://security.debian.org/debian-security buster/updates/main amd64 libswscale5 amd64 7:4.1.9-0+deb10u1 [209 kB] Get:19 http://security.debian.org/debian-security buster/updates/main amd64 libavformat58 amd64 7:4.1.9-0+deb10u1 [1,019 kB] Get:20 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-client all 1:10.7.4+maria~buster [2,704 B] Get:21 http://security.debian.org/debian-security buster/updates/main amd64 libavcodec58 amd64 7:4.1.9-0+deb10u1 [4,810 kB] Get:22 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 libmariadb-dev amd64 1:10.7.4+maria~buster [158 kB] Get:23 https://packages.sury.org/php buster/main amd64 php8.1-bcmath amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [15.4 kB] Get:24 https://packages.sury.org/php buster/main amd64 php8.1-zip amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [24.2 kB] Get:25 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 libmariadb-dev-compat amd64 1:10.7.4+maria~buster [3,084 B] Get:26 https://packages.sury.org/php buster/main amd64 php8.1-xml amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [107 kB] Get:27 https://packages.sury.org/php buster/main amd64 php8.1-sqlite3 amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [29.3 kB] Get:28 https://packages.sury.org/php buster/main amd64 php8.1-soap amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [120 kB] Get:29 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 libmariadb3 amd64 1:10.7.4+maria~buster [148 kB] Get:30 https://packages.sury.org/php buster/main amd64 php8.1-readline amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [12.6 kB] Get:31 https://packages.sury.org/php buster/main amd64 php8.1-opcache amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [332 kB] Get:32 https://packages.sury.org/php buster/main amd64 php8.1-mysql amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [116 kB] Get:33 https://packages.sury.org/php buster/main amd64 php8.1-mbstring amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [396 kB] Get:34 https://packages.sury.org/php buster/main amd64 php8.1-intl amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [127 kB] Get:35 https://packages.sury.org/php buster/main amd64 php8.1-imap amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [32.6 kB] Get:36 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-client-core-10.7 amd64 1:10.7.4+maria~buster [832 kB] Get:37 https://packages.sury.org/php buster/main amd64 php8.1-gd amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [28.5 kB] Get:38 https://packages.sury.org/php buster/main amd64 php8.1-dev amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [488 kB] Get:39 https://packages.sury.org/php buster/main amd64 php8.1-curl amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [34.4 kB] Get:40 https://packages.sury.org/php buster/main amd64 php8.1-fpm amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [1,672 kB] Get:41 http://security.debian.org/debian-security buster/updates/main amd64 libswresample3 amd64 7:4.1.9-0+deb10u1 [112 kB] Get:42 http://security.debian.org/debian-security buster/updates/main amd64 libpostproc55 amd64 7:4.1.9-0+deb10u1 [108 kB] Get:43 http://security.debian.org/debian-security buster/updates/main amd64 libavutil56 amd64 7:4.1.9-0+deb10u1 [244 kB] Get:44 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-server-10.7 amd64 1:10.7.4+maria~buster [3,461 kB] Get:45 https://packages.sury.org/php buster/main amd64 php8.1-cli amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [1,662 kB] Get:46 http://security.debian.org/debian-security buster/updates/main amd64 libpq5 amd64 11.16-0+deb10u1 [172 kB] Get:47 https://packages.sury.org/php buster/main amd64 php8.1-common amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [660 kB] Get:48 http://security.debian.org/debian-security buster/updates/main amd64 openjdk-11-jre amd64 11.0.15+10-1~deb10u1 [174 kB] Get:49 https://packages.sury.org/php buster/main amd64 php8.1 all 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [24.7 kB] Get:50 http://security.debian.org/debian-security buster/updates/main amd64 openjdk-11-jre-headless amd64 11.0.15+10-1~deb10u1 [37.2 MB] Get:51 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-client-10.7 amd64 1:10.7.4+maria~buster [2,411 kB] Get:52 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-server-core-10.7 amd64 1:10.7.4+maria~buster [7,153 kB] Get:53 https://packagecloud.io/sensu/stable/debian buster/main amd64 sensu-go-agent amd64 6.7.2-6283 [6,975 kB] Get:54 http://security.debian.org/debian-security buster/updates/main amd64 openssl amd64 1.1.1n-0+deb10u2 [855 kB] Get:55 https://deb.nodesource.com/node_16.x buster/main amd64 nodejs amd64 16.15.0-deb-1nodesource1 [26.4 MB] Fetched 142 MB in 6s (24.2 MB/s) Reading changelogs... Done Extracting templates from packages: 100% Preconfiguring packages ... (Reading database ... 87804 files and directories currently installed.) Preparing to unpack .../0-mysql-common_1%3a10.7.4+maria~buster_all.deb ... Unpacking mysql-common (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../1-mariadb-common_1%3a10.7.4+maria~buster_all.deb ... Unpacking mariadb-common (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../2-mariadb-server_1%3a10.7.4+maria~buster_all.deb ... Unpacking mariadb-server (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../3-mariadb-client_1%3a10.7.4+maria~buster_all.deb ... Unpacking mariadb-client (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../4-libmariadb-dev_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking libmariadb-dev (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../5-libmariadb-dev-compat_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking libmariadb-dev-compat:amd64 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../6-libssl-dev_1.1.1n-0+deb10u2_amd64.deb ... Unpacking libssl-dev:amd64 (1.1.1n-0+deb10u2) over (1.1.1n-0+deb10u1) ... Preparing to unpack .../7-libssl1.1_1.1.1n-0+deb10u2_amd64.deb ... Unpacking libssl1.1:amd64 (1.1.1n-0+deb10u2) over (1.1.1n-0+deb10u1) ... Preparing to unpack .../8-libmariadb3_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking libmariadb3:amd64 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... dpkg: mariadb-client-10.7: dependency problems, but removing anyway as you requested: mariadb-server-10.7 depends on mariadb-client-10.7 (>= 1:10.7.3+maria~buster). mariadb-client depends on mariadb-client-10.7 (>= 1:10.7.4+maria~buster). (Reading database ... 87804 files and directories currently installed.) Removing mariadb-client-10.7 (1:10.7.3+maria~buster) ... Setting up mysql-common (1:10.7.4+maria~buster) ... Setting up mariadb-common (1:10.7.4+maria~buster) ... (Reading database ... 87703 files and directories currently installed.) Preparing to unpack .../00-mariadb-server-10.7_1%3a10.7.4+maria~buster_amd64.deb ... /var/lib/mysql: found previous version 10.7 Unpacking mariadb-server-10.7 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../01-mariadb-server-core-10.7_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking mariadb-server-core-10.7 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../02-mariadb-client-core-10.7_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking mariadb-client-core-10.7 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Selecting previously unselected package mariadb-client-10.7. Preparing to unpack .../03-mariadb-client-10.7_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking mariadb-client-10.7 (1:10.7.4+maria~buster) ... Preparing to unpack .../04-libldap-common_2.4.47+dfsg-3+deb10u7_all.deb ... Unpacking libldap-common (2.4.47+dfsg-3+deb10u7) over (2.4.47+dfsg-3+deb10u6) ... Preparing to unpack .../05-libldap-2.4-2_2.4.47+dfsg-3+deb10u7_amd64.deb ... Unpacking libldap-2.4-2:amd64 (2.4.47+dfsg-3+deb10u7) over (2.4.47+dfsg-3+deb10u6) ... Preparing to unpack .../06-libavfilter7_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libavfilter7:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../07-libswscale5_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libswscale5:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../08-libavformat58_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libavformat58:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../09-libavcodec58_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libavcodec58:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../10-libswresample3_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libswresample3:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../11-libpostproc55_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libpostproc55:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../12-libavutil56_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libavutil56:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../13-libxml2_2.9.14+dfsg-0+0~20220524.12+debian10~1.gbpc5dc45_amd64.deb ... Unpacking libxml2:amd64 (2.9.14+dfsg-0+0~20220524.12+debian10~1.gbpc5dc45) over (2.9.13+dfsg-0+0~20220410.11+debian10~1.gbp692312) ... Preparing to unpack .../14-libpq5_11.16-0+deb10u1_amd64.deb ... Unpacking libpq5:amd64 (11.16-0+deb10u1) over (11.14-0+deb10u1) ... Preparing to unpack .../15-nodejs_16.15.0-deb-1nodesource1_amd64.deb ... Unpacking nodejs (16.15.0-deb-1nodesource1) over (16.14.2-deb-1nodesource1) ... Preparing to unpack .../16-openjdk-11-jre_11.0.15+10-1~deb10u1_amd64.deb ... Unpacking openjdk-11-jre:amd64 (11.0.15+10-1~deb10u1) over (11.0.14+9-1~deb10u1) ... Preparing to unpack .../17-openjdk-11-jre-headless_11.0.15+10-1~deb10u1_amd64.deb ... Unpacking openjdk-11-jre-headless:amd64 (11.0.15+10-1~deb10u1) over (11.0.14+9-1~deb10u1) ... Preparing to unpack .../18-openssl_1.1.1n-0+deb10u2_amd64.deb ... Unpacking openssl (1.1.1n-0+deb10u2) over (1.1.1n-0+deb10u1) ... Preparing to unpack .../19-php8.1-bcmath_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-bcmath (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../20-php8.1-zip_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-zip (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../21-php8.1-xml_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-xml (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../22-php8.1-sqlite3_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-sqlite3 (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../23-php8.1-soap_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-soap (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../24-php8.1-readline_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-readline (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../25-php8.1-opcache_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-opcache (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../26-php8.1-mysql_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-mysql (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../27-php8.1-mbstring_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-mbstring (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../28-php8.1-intl_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-intl (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../29-php8.1-imap_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-imap (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../30-php8.1-gd_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-gd (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../31-php8.1-dev_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-dev (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../32-php8.1-curl_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-curl (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../33-php8.1-fpm_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-fpm (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../34-php8.1-cli_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-cli (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../35-php8.1-common_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-common (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../36-php8.1_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_all.deb ... Unpacking php8.1 (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../44-sensu-go-agent_6.7.2-6283_amd64.deb ... Unpacking sensu-go-agent (6.7.2-6283) over (6.7.0-6196) ... Preparing to unpack .../45-filebeat_7.17.4_amd64.deb ... Unpacking filebeat (7.17.4) over (7.17.3) ... Setting up libssl1.1:amd64 (1.1.1n-0+deb10u2) ... Setting up openjdk-11-jre-headless:amd64 (11.0.15+10-1~deb10u1) ... Setting up openjdk-11-jre:amd64 (11.0.15+10-1~deb10u1) ... Setting up nodejs (16.15.0-deb-1nodesource1) ... Setting up libldap-common (2.4.47+dfsg-3+deb10u7) ... Setting up libavutil56:amd64 (7:4.1.9-0+deb10u1) ... Setting up libssl-dev:amd64 (1.1.1n-0+deb10u2) ... Setting up libpostproc55:amd64 (7:4.1.9-0+deb10u1) ... Setting up libmariadb3:amd64 (1:10.7.4+maria~buster) ... Setting up libmariadb-dev (1:10.7.4+maria~buster) ... Setting up sensu-go-agent (6.7.2-6283) ... Setting up libswscale5:amd64 (7:4.1.9-0+deb10u1) ... Setting up mariadb-server-core-10.7 (1:10.7.4+maria~buster) ... Setting up filebeat (7.17.4) ... Installing new version of config file /etc/filebeat/filebeat.reference.yml ... Configuration file '/etc/filebeat/filebeat.yml' ==> Modified (by you or by a script) since installation. ==> Package distributor has shipped an updated version. What would you like to do about it ? Your options are: Y or I : install the package maintainer's version N or O : keep your currently-installed version D : show the differences between the versions Z : start a shell to examine the situation The default action is to keep your current version. *** filebeat.yml (Y/I/N/O/D/Z) [default=N] ? Installing new version of config file /etc/filebeat/modules.d/azure.yml.disabled ... Setting up openssl (1.1.1n-0+deb10u2) ... Setting up libxml2:amd64 (2.9.14+dfsg-0+0~20220524.12+debian10~1.gbpc5dc45) ... Setting up libmariadb-dev-compat:amd64 (1:10.7.4+maria~buster) ... Installing all pip dependencies Requirement already satisfied: pika==1.2.0 in /usr/local/lib/python3.7/dist-packages (1.2.0) Setting up php8.1-common (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-imap (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-gd (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up libldap-2.4-2:amd64 (2.4.47+dfsg-3+deb10u7) ... Setting up libswresample3:amd64 (7:4.1.9-0+deb10u1) ... Setting up php8.1-curl (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-sqlite3 (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-xml (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-soap (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up mariadb-client-core-10.7 (1:10.7.4+maria~buster) ... Setting up php8.1-mysql (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-zip (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up libavcodec58:amd64 (7:4.1.9-0+deb10u1) ... Setting up php8.1-readline (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up mariadb-client-10.7 (1:10.7.4+maria~buster) ... Setting up php8.1-opcache (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-intl (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-bcmath (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up mariadb-client (1:10.7.4+maria~buster) ... Setting up php8.1-mbstring (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up libavformat58:amd64 (7:4.1.9-0+deb10u1) ... Setting up libpq5:amd64 (11.16-0+deb10u1) ... Setting up mariadb-server-10.7 (1:10.7.4+maria~buster) ... Installing new version of config file /etc/mysql/debian-start ... mariadb-extra.socket is a disabled or a static unit not running, not starting it. mariadb-extra.socket is a disabled or a static unit, not starting it. Setting up php8.1-cli (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-dev (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up libavfilter7:amd64 (7:4.1.9-0+deb10u1) ... Setting up mariadb-server (1:10.7.4+maria~buster) ... Setting up php8.1-fpm (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1 (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Processing triggers for hicolor-icon-theme (0.17-2) ... Processing triggers for libc-bin (2.28-10+deb10u1) ... Processing triggers for systemd (241-7~deb10u8) ... Processing triggers for man-db (2.8.5-2) ... Processing triggers for mime-support (3.62) ... Processing triggers for php8.1-cli (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Processing triggers for php8.1-fpm (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... root@http-msh02:~# apt-cache policy libmariadb-dev libmariadb-dev-compat libmariadb3 mariadb-client mariadb-client-10.7 mariadb-client-core-10.7 mariadb-common mariadb-server mariadb-server-10.7 mariadb-server-core-10.7 mysql-common libmariadb-dev: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1:10.3.34-0+deb10u1 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages 1:10.3.25-0+deb10u1 500 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages libmariadb-dev-compat: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1:10.3.34-0+deb10u1 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages 1:10.3.25-0+deb10u1 500 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages libmariadb3: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1:10.3.34-0+deb10u1 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages 1:10.3.25-0+deb10u1 500 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages mariadb-client: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 1:10.3.34-0+deb10u1 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages 1:10.3.25-0+deb10u1 500 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages mariadb-client-10.7: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages mariadb-client-core-10.7: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages mariadb-common: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 1:10.3.34-0+deb10u1 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages 1:10.3.25-0+deb10u1 500 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages mariadb-server: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 1:10.3.34-0+deb10u1 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages 1:10.3.25-0+deb10u1 500 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages mariadb-server-10.7: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages mariadb-server-core-10.7: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages mysql-common: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 5.8+1.0.5 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages root@http-msh02:~# apt-cache policy Package files: 100 /var/lib/dpkg/status release a=now 500 https://packages.sury.org/php buster/main amd64 Packages release o=deb.sury.org,a=buster,n=buster,c=main,b=amd64 origin packages.sury.org 500 https://packagecloud.io/sensu/stable/debian buster/main amd64 Packages release v=1,o=packagecloud.io/sensu/stable,a=buster,n=buster,l=stable,c=main,b=amd64 origin packagecloud.io 500 http://nginx.org/packages/mainline/debian buster/nginx amd64 Packages release v=10.0,o=nginx,a=stable,n=buster,l=nginx,c=nginx,b=amd64 origin nginx.org 100 http://debmirror.tuxis.nl/debian buster-backports/main amd64 Packages release o=Debian Backports,a=buster-backports,n=buster-backports,l=Debian Backports,c=main,b=amd64 origin debmirror.tuxis.nl 500 https://deb.nodesource.com/node_16.x buster/main amd64 Packages release o=Node Source,n=buster,l=Node Source,c=main,b=amd64 origin deb.nodesource.com 500 https://artifacts.elastic.co/packages/7.x/apt stable/main amd64 Packages release o=elastic,a=stable,n=stable,l=. stable,c=main,b=amd64 origin artifacts.elastic.co 500 https://apt.tuxis.nl/tuxis monitoring/main amd64 Packages release o=tuxis monitoring,a=monitoring,n=monitoring,l=tuxis monitoring,c=main,b=amd64 origin apt.tuxis.nl 500 https://apt.tuxis.nl/tuxis tuxis-cron/main amd64 Packages release o=tuxis tuxis-cron,a=tuxis-cron,n=tuxis-cron,l=tuxis tuxis-cron,c=main,b=amd64 origin apt.tuxis.nl 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages release o=MariaDB,n=buster,l=MariaDB,c=main,b=ppc64el origin ams2.mirrors.digitalocean.com 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages release o=MariaDB,n=buster,l=MariaDB,c=main,b=arm64 origin ams2.mirrors.digitalocean.com 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages release o=MariaDB,n=buster,l=MariaDB,c=main,b=amd64 origin ams2.mirrors.digitalocean.com 500 http://debmirror.tuxis.nl/debian buster-updates/main amd64 Packages release o=Debian,a=oldstable-updates,n=buster-updates,l=Debian,c=main,b=amd64 origin debmirror.tuxis.nl 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages release v=10,o=Debian,a=oldstable,n=buster,l=Debian-Security,c=main,b=amd64 origin security.debian.org 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages release v=10.12,o=Debian,a=oldstable,n=buster,l=Debian,c=main,b=amd64 origin debmirror.tuxis.nl Pinned packages: ``` -- With kind regards, William Edwards

1 0

[Maria-discuss] In memory DB, how to in MariaDB?
by Eliezer Croitoru 23 May '22

23 May '22

I have seen the next blog post which had a video at 2014: https://blogs.oracle.com/pcoe/post/the-future-of-the-database-begins The demo video was removed from YouTube for some reason but I had a copy of it at: https://cloud1.ngtech.co.il/static/oracle/Oracle%20Database%20In-Memory%20Po wering%20the%20Real-Time%20Enterprise%20.mp4 I am not a MariaDB or MySQL or DB in general expert and was wondering if there is something these days in MariaDB that can be used in comparison to what Oracle DB demo shows? I have used LevelDB as a backend in a customized DB and it worked very very fast and it is great. With batches it works even faster but in general it works faster then standard MariaDB setups I have implemented. So what are the options? I have millions of values and I would like to be able to insert and select as fast as possible on a single DB Server. Currently I am using a Caching tier with a specific TTL to lower the stress off the DB, but, is I possible to make the DB Faster like maybe with some writeback (leaving aside fault tolerance for speed). Thanks, Eliezer ---- Eliezer Croitoru NgTech, Tech Support Mobile: +972-5-28704261 Email: <mailto:ngtech1ltd@gmail.com> ngtech1ltd(a)gmail.com

3 4

[Maria-discuss] Debian revision should not contain codename
by William Edwards 19 May '22

19 May '22

Hi, I'm attempting to upgrade a machine with MariaDB 10.6 from Buster to Bullseye using the official MariaDB repo. I was surprised to see that apt wanted to downgrade a few packages: ``` $ apt upgrade --without-new-pkgs The following packages will be DOWNGRADED: libmariadb-dev libmariadb-dev-compat libmariadb3 mysql-common ``` I was confused at first, as the priority of the candidate is higher, and the epoch is unchanged, and the upstream version is unchanged: ``` $ apt policy mysql-common mysql-common: Installed: 1:10.6.7+maria~buster Candidate: 1:10.6.7+maria~bullseye Version table: *** 1:10.6.7+maria~buster 100 100 /var/lib/dpkg/status 1:10.6.7+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main ppc64el Packages 1:10.6.5+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main ppc64el Packages 1:10.6.4+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main ppc64el Packages 5.8+1.0.7 500 500 http://debmirror.tuxis.nl/debian bullseye/main amd64 Packages $ apt policy libmariadb3 libmariadb3: Installed: 1:10.6.7+maria~buster Candidate: 1:10.6.7+maria~bullseye Version table: *** 1:10.6.7+maria~buster 100 100 /var/lib/dpkg/status 1:10.6.7+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.6.5+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.6.4+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.5.15-0+deb11u1 500 500 http://debmirror.tuxis.nl/debian bullseye/main amd64 Packages $ apt policy libmariadb-dev-compat libmariadb-dev-compat: Installed: 1:10.6.7+maria~buster Candidate: 1:10.6.7+maria~bullseye Version table: *** 1:10.6.7+maria~buster 100 100 /var/lib/dpkg/status 1:10.6.7+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.6.5+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.6.4+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.5.15-0+deb11u1 500 500 http://debmirror.tuxis.nl/debian bullseye/main amd64 Packages $ apt policy libmariadb-dev libmariadb-dev: Installed: 1:10.6.7+maria~buster Candidate: 1:10.6.7+maria~bullseye Version table: *** 1:10.6.7+maria~buster 100 100 /var/lib/dpkg/status 1:10.6.7+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.6.5+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.6.4+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.5.15-0+deb11u1 500 500 http://debmirror.tuxis.nl/debian bullseye/main amd64 Packages ``` A simulation also reported that apt would 'downgrade' to the same versions: ``` $ apt upgrade --without-new-pkgs -s Inst libmariadb-dev [1:10.6.7+maria~buster] (1:10.6.7+maria~bullseye MariaDB:ams2.mirrors.digitalocean.com [amd64]) [] Inst libmariadb-dev-compat [1:10.6.7+maria~buster] (1:10.6.7+maria~bullseye MariaDB:ams2.mirrors.digitalocean.com [amd64]) [] Inst libmariadb3 [1:10.6.7+maria~buster] (1:10.6.7+maria~bullseye MariaDB:ams2.mirrors.digitalocean.com [amd64]) Inst mysql-common [1:10.6.7+maria~buster] (1:10.6.7+maria~bullseye MariaDB:ams2.mirrors.digitalocean.com [all]) ``` Some folks on IRC pointed me to the fact that the Debian revision has been updated from `maria~buster` to `maria~bullseye`. The following documentation at https://www.debian.org/doc/debian-policy/ch-controlfields.html#special-vers… says: > The lexical comparison is a comparison of ASCII values modified so that > all the letters sort earlier than all the non-letters and so that a > tilde sorts before anything, even the end of a part. 'bul' comes before 'bus', so the package for Bullseye is perceived as older, despite it being the same effective upstream version... According to https://www.debian.org/doc/debian-policy/ch-controlfields.html#special-vers…, the Debian revision should NOT contain the Debian release codename. This problem will re-appear with Bookworm. Could the package maintainer(s) attend to this? -- With kind regards, William Edwards

2 2

Re: [Maria-discuss] MariaDB latest source tarballs missing
by Sergei Golubchik 19 May '22

19 May '22

Hi, Shreenidhi, On May 19, Shreenidhi Shedi wrote: > > I am from VMware Photon OS engineering team. > > We are trying to fix few CVEs that are being reported in 10.2.x & > 10.3.x versions of MariaDB. > > There is release note for v10.2.44 but I cannot find the source > tarball in downloads page or in github tags of maria db server. You cannot find it, because it wasn't released yet. > https://mariadb.com/kb/en/mariadb-10244-release-notes/ This page says, on the very top, in a red box: Note: This page describes features in the source repository for MariaDB 10.2. There are currently no official packages or binaries available for download which contain the features. If you want to try out any of the new features described here you will need to get and compile the code yourself. > Can you guys please help me out here? Where can I get the latest > released source tarballs? https://mariadb.org/download/ > Also, when can we expect a fix for this? If at all this is not > released, when can we expect next release of MariaDB server versions? Any day now. Regards, Sergei VP of MariaDB Server Engineering and security(a)mariadb.org

1 0

[Maria-discuss] Galera: jump through major versions at once
by William Edwards 19 May '22

19 May '22

Hi, Does Galera support rolling upgrades between multiple major versions? I will be upgrading my Galera cluster from MariaDB 10.3.34 to 10.6.x. It'd save a lot of time to jump straight from 10.3 to 10.6 instead of upgrading 10.3 -> 10.4 -> 10.5 -> 10.6. The documentation at https://mariadb.com/kb/en/upgrading-from-mariadb-103-to-mariadb-104-with-ga… implies that the MariaDB version is irrelevant, and only the Galera version matters. > Next, make sure that the Galera version numbers are compatible. > > If you are upgrading from the most recent MariaDB 10.3 release to > MariaDB 10.4, then the versions will > be compatible. MariaDB 10.3 uses Galera 3 (i.e. Galera wsrep provider > versions 25.3.x), and MariaDB > 10.4 uses Galera 4 (i.e. Galera wsrep provider versions 26.4.x). This > means that upgrading to MariaDB > 10.4 also upgrades the system to Galera 4. However, Galera 3 and Galera > 4 should be compatible for the > purposes of a rolling upgrade, as long as you are using Galera 26.4.2 > or later. -- With kind regards, William Edwards

2 3

[Maria-discuss] FLUSH TABLES ... FOR EXPORT SLOW
by mariadb＠Biblestuph.com 18 May '22

18 May '22

I've recently updated from 10.3.14 => 10.6.7, and am running into an issue where FLUSH TABLES ... FOR EXPORT is sometimes very slow on large tables. One particular table that it seems to happen on often is over 20G. It doesn't hang, per se; it will complete eventually, but can take an hour or more. 2022-05-17 0:14:06 105636 [Note] InnoDB: Sync to disk of `MyDB`.`t1` started. 2022-05-17 0:14:06 105636 [Note] InnoDB: Writing table metadata to './MyDB/t1.cfg' 2022-05-17 0:14:06 105636 [Note] InnoDB: Table `MyDB`.`t1` flushed to disk 2022-05-17 0:14:06 105636 [Note] InnoDB: Sync to disk of `MyDB`.`t2` started. 2022-05-17 1:49:53 105636 [Note] InnoDB: Writing table metadata to './MyDB/t2.cfg' 2022-05-17 1:49:53 105636 [Note] InnoDB: Table `MyDB`.`t2` flushed to disk in the above the obfuscated table name t2 took about 1.5 hours to complete. In the previous version (10.3.14), these were always nearly instantaneous, even for the largest tables. At the time I'm executing the FLUSH TABLES the slave is stopped on the DB and there are no other users logged in to the DB (other than myself). I know from the docs that FLUSH TABLES has seen changes since my previous version, but I'm not clear as to what the process is waiting for (or how to avoid it). Shutting down the server first (I have innodb_fast_shutdown = 0) seems to prevent it; and the shutdown generally only takes 5-10 minutes or so. But I'd rather not shutdown if I don't have to (and I'm not 100% convinced that I won't someday see the issue in that scenario, as well). I've also tried this sequence thinking it might help: ---> STOP SLAVE Wed May 18 10:30:13 2022 ---> SLAVE STOPPED Wed May 18 10:30:13 2022 ---> FLUSH LOCAL TABLES WITH READ LOCK Wed May 18 10:30:14 2022 ---> UNLOCK TABLES Wed May 18 10:30:15 2022 ---> SET GLOBAL innodb_purge_rseg_truncate_frequency = 1 Wed May 18 10:30:15 2022 ---> SET GLOBAL innodb_max_purge_lag_wait = 0 Wed May 18 10:30:15 2022 ---> FLUSH TABLES ... FOR EXPORT Wed May 18 10:30:15 2022 but the FLUSH TABLES FOR EXPORT still waits on that large table. Is there a way to make this happen quicker without requiring the DB to be shutdown first? Or am I missing something else in the process? Thanks, Dan

1 0