Sat Mar 18 15:05:41 2023 UTC ()
mariadb105: Update to 10.5.19

Notable Items

  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)

  JSON

     * JSON_PRETTY added as an alias for JSON_DETAILED (MDEV-19160)

  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 with 10.6.11 (MDEV-29988)


(nia)
diff -r1.19 -r1.20 pkgsrc/databases/mariadb105-client/Makefile.common
diff -r1.5 -r1.6 pkgsrc/databases/mariadb105-client/PLIST
diff -r1.17 -r1.18 pkgsrc/databases/mariadb105-client/distinfo
diff -r1.32 -r1.33 pkgsrc/databases/mariadb105-server/Makefile
cvs diff -r1.19 -r1.20 pkgsrc/databases/mariadb105-client/Makefile.common (expand / switch to unified diff)

--- pkgsrc/databases/mariadb105-client/Makefile.common 2023/03/07 10:28:02 1.19
+++ pkgsrc/databases/mariadb105-client/Makefile.common 2023/03/18 15:05:41 1.20
@@ -1,19 +1,19 @@ @@ -1,19 +1,19 @@
1# $NetBSD: Makefile.common,v 1.19 2023/03/07 10:28:02 jperkin Exp $ 1# $NetBSD: Makefile.common,v 1.20 2023/03/18 15:05:41 nia Exp $
2# 2#
3# used by databases/mariadb105-client/Makefile 3# used by databases/mariadb105-client/Makefile
4# used by databases/mariadb105-server/Makefile 4# used by databases/mariadb105-server/Makefile
5 5
6DISTNAME= mariadb-10.5.18 6DISTNAME= mariadb-10.5.19
7CATEGORIES= databases 7CATEGORIES= databases
8MASTER_SITES= https://archive.mariadb.org/${DISTNAME}/source/ 8MASTER_SITES= https://archive.mariadb.org/${DISTNAME}/source/
9 9
10MAINTAINER?= pkgsrc-users@NetBSD.org 10MAINTAINER?= pkgsrc-users@NetBSD.org
11HOMEPAGE= https://mariadb.org/ 11HOMEPAGE= https://mariadb.org/
12LICENSE= gnu-gpl-v2 12LICENSE= gnu-gpl-v2
13 13
14DISTINFO_FILE?= ${.CURDIR}/../../databases/mariadb105-client/distinfo 14DISTINFO_FILE?= ${.CURDIR}/../../databases/mariadb105-client/distinfo
15PATCHDIR?= ${.CURDIR}/../../databases/mariadb105-client/patches 15PATCHDIR?= ${.CURDIR}/../../databases/mariadb105-client/patches
16 16
17USE_CMAKE= yes 17USE_CMAKE= yes
18USE_LANGUAGES= c c++ 18USE_LANGUAGES= c c++
19USE_TOOLS+= perl:run pkg-config bison 19USE_TOOLS+= perl:run pkg-config bison
cvs diff -r1.5 -r1.6 pkgsrc/databases/mariadb105-client/PLIST (expand / switch to unified diff)

--- pkgsrc/databases/mariadb105-client/PLIST 2022/11/27 23:34:48 1.5
+++ pkgsrc/databases/mariadb105-client/PLIST 2023/03/18 15:05:41 1.6
@@ -1,14 +1,14 @@ @@ -1,14 +1,14 @@
1@comment $NetBSD: PLIST,v 1.5 2022/11/27 23:34:48 nia Exp $ 1@comment $NetBSD: PLIST,v 1.6 2023/03/18 15:05:41 nia Exp $
2bin/mariadb 2bin/mariadb
3bin/mariadb-access 3bin/mariadb-access
4bin/mariadb-admin 4bin/mariadb-admin
5bin/mariadb-binlog 5bin/mariadb-binlog
6bin/mariadb-check 6bin/mariadb-check
7bin/mariadb-conv 7bin/mariadb-conv
8bin/mariadb-convert-table-format 8bin/mariadb-convert-table-format
9bin/mariadb-dump 9bin/mariadb-dump
10bin/mariadb-find-rows 10bin/mariadb-find-rows
11bin/mariadb-import 11bin/mariadb-import
12bin/mariadb-plugin 12bin/mariadb-plugin
13bin/mariadb-secure-installation 13bin/mariadb-secure-installation
14bin/mariadb-setpermission 14bin/mariadb-setpermission
@@ -62,26 +62,27 @@ include/mysql/server/big_endian.h @@ -62,26 +62,27 @@ include/mysql/server/big_endian.h
62include/mysql/server/byte_order_generic.h 62include/mysql/server/byte_order_generic.h
63include/mysql/server/byte_order_generic_x86.h 63include/mysql/server/byte_order_generic_x86.h
64include/mysql/server/byte_order_generic_x86_64.h 64include/mysql/server/byte_order_generic_x86_64.h
65include/mysql/server/decimal.h 65include/mysql/server/decimal.h
66include/mysql/server/errmsg.h 66include/mysql/server/errmsg.h
67include/mysql/server/handler_ername.h 67include/mysql/server/handler_ername.h
68include/mysql/server/handler_state.h 68include/mysql/server/handler_state.h
69include/mysql/server/json_lib.h 69include/mysql/server/json_lib.h
70include/mysql/server/keycache.h 70include/mysql/server/keycache.h
71include/mysql/server/little_endian.h 71include/mysql/server/little_endian.h
72include/mysql/server/m_ctype.h 72include/mysql/server/m_ctype.h
73include/mysql/server/m_string.h 73include/mysql/server/m_string.h
74include/mysql/server/ma_dyncol.h 74include/mysql/server/ma_dyncol.h
 75include/mysql/server/mariadb_capi_rename.h
75include/mysql/server/my_alloc.h 76include/mysql/server/my_alloc.h
76include/mysql/server/my_attribute.h 77include/mysql/server/my_attribute.h
77include/mysql/server/my_byteorder.h 78include/mysql/server/my_byteorder.h
78include/mysql/server/my_compiler.h 79include/mysql/server/my_compiler.h
79include/mysql/server/my_config.h 80include/mysql/server/my_config.h
80include/mysql/server/my_dbug.h 81include/mysql/server/my_dbug.h
81include/mysql/server/my_decimal_limits.h 82include/mysql/server/my_decimal_limits.h
82include/mysql/server/my_dir.h 83include/mysql/server/my_dir.h
83include/mysql/server/my_getopt.h 84include/mysql/server/my_getopt.h
84include/mysql/server/my_global.h 85include/mysql/server/my_global.h
85include/mysql/server/my_list.h 86include/mysql/server/my_list.h
86include/mysql/server/my_net.h 87include/mysql/server/my_net.h
87include/mysql/server/my_pthread.h 88include/mysql/server/my_pthread.h
@@ -130,50 +131,48 @@ include/mysql/server/mysql/service_my_cr @@ -130,50 +131,48 @@ include/mysql/server/mysql/service_my_cr
130include/mysql/server/mysql/service_my_print_error.h 131include/mysql/server/mysql/service_my_print_error.h
131include/mysql/server/mysql/service_my_snprintf.h 132include/mysql/server/mysql/service_my_snprintf.h
132include/mysql/server/mysql/service_progress_report.h 133include/mysql/server/mysql/service_progress_report.h
133include/mysql/server/mysql/service_sha1.h 134include/mysql/server/mysql/service_sha1.h
134include/mysql/server/mysql/service_sha2.h 135include/mysql/server/mysql/service_sha2.h
135include/mysql/server/mysql/service_thd_alloc.h 136include/mysql/server/mysql/service_thd_alloc.h
136include/mysql/server/mysql/service_thd_autoinc.h 137include/mysql/server/mysql/service_thd_autoinc.h
137include/mysql/server/mysql/service_thd_error_context.h 138include/mysql/server/mysql/service_thd_error_context.h
138include/mysql/server/mysql/service_thd_mdl.h 139include/mysql/server/mysql/service_thd_mdl.h
139include/mysql/server/mysql/service_thd_rnd.h 140include/mysql/server/mysql/service_thd_rnd.h
140include/mysql/server/mysql/service_thd_specifics.h 141include/mysql/server/mysql/service_thd_specifics.h
141include/mysql/server/mysql/service_thd_timezone.h 142include/mysql/server/mysql/service_thd_timezone.h
142include/mysql/server/mysql/service_thd_wait.h 143include/mysql/server/mysql/service_thd_wait.h
143include/mysql/server/mysql/service_wsrep.h 
144include/mysql/server/mysql/services.h 144include/mysql/server/mysql/services.h
145include/mysql/server/mysql_com.h 145include/mysql/server/mysql_com.h
146include/mysql/server/mysql_com_server.h 146include/mysql/server/mysql_com_server.h
147include/mysql/server/mysql_embed.h 147include/mysql/server/mysql_embed.h
148include/mysql/server/mysql_time.h 148include/mysql/server/mysql_time.h
149include/mysql/server/mysql_version.h 149include/mysql/server/mysql_version.h
150include/mysql/server/mysqld_ername.h 150include/mysql/server/mysqld_ername.h
151include/mysql/server/mysqld_error.h 151include/mysql/server/mysqld_error.h
152include/mysql/server/pack.h 152include/mysql/server/pack.h
153include/mysql/server/private/aria_backup.h 153include/mysql/server/private/aria_backup.h
154include/mysql/server/private/assume_aligned.h 154include/mysql/server/private/assume_aligned.h
155include/mysql/server/private/atomic/gcc_builtins.h 155include/mysql/server/private/atomic/gcc_builtins.h
156include/mysql/server/private/atomic/generic-msvc.h 156include/mysql/server/private/atomic/generic-msvc.h
157include/mysql/server/private/atomic/solaris.h 157include/mysql/server/private/atomic/solaris.h
158include/mysql/server/private/config.h 158include/mysql/server/private/config.h
159include/mysql/server/private/dur_prop.h 159include/mysql/server/private/dur_prop.h
160include/mysql/server/private/ft_global.h 160include/mysql/server/private/ft_global.h
161include/mysql/server/private/hash.h 161include/mysql/server/private/hash.h
162include/mysql/server/private/heap.h 162include/mysql/server/private/heap.h
163include/mysql/server/private/ilist.h 163include/mysql/server/private/ilist.h
164include/mysql/server/private/lf.h 164include/mysql/server/private/lf.h
165include/mysql/server/private/maria.h 165include/mysql/server/private/maria.h
166include/mysql/server/private/mariadb_capi_rename.h 
167include/mysql/server/private/my_alarm.h 166include/mysql/server/private/my_alarm.h
168include/mysql/server/private/my_atomic.h 167include/mysql/server/private/my_atomic.h
169include/mysql/server/private/my_atomic_wrapper.h 168include/mysql/server/private/my_atomic_wrapper.h
170include/mysql/server/private/my_base.h 169include/mysql/server/private/my_base.h
171include/mysql/server/private/my_bit.h 170include/mysql/server/private/my_bit.h
172include/mysql/server/private/my_bitmap.h 171include/mysql/server/private/my_bitmap.h
173include/mysql/server/private/my_check_opt.h 172include/mysql/server/private/my_check_opt.h
174include/mysql/server/private/my_compare.h 173include/mysql/server/private/my_compare.h
175include/mysql/server/private/my_context.h 174include/mysql/server/private/my_context.h
176include/mysql/server/private/my_counter.h 175include/mysql/server/private/my_counter.h
177include/mysql/server/private/my_cpu.h 176include/mysql/server/private/my_cpu.h
178include/mysql/server/private/my_crypt.h 177include/mysql/server/private/my_crypt.h
179include/mysql/server/private/my_default.h 178include/mysql/server/private/my_default.h
@@ -245,28 +244,26 @@ lib/libmysqlclient_r.so @@ -245,28 +244,26 @@ lib/libmysqlclient_r.so
245lib/mysql/plugin/auth_gssapi_client.so 244lib/mysql/plugin/auth_gssapi_client.so
246lib/mysql/plugin/caching_sha2_password.so 245lib/mysql/plugin/caching_sha2_password.so
247lib/mysql/plugin/client_ed25519.so 246lib/mysql/plugin/client_ed25519.so
248lib/mysql/plugin/dialog.so 247lib/mysql/plugin/dialog.so
249lib/mysql/plugin/mysql_clear_password.so 248lib/mysql/plugin/mysql_clear_password.so
250lib/mysql/plugin/sha256_password.so 249lib/mysql/plugin/sha256_password.so
251lib/pkgconfig/libmariadb.pc 250lib/pkgconfig/libmariadb.pc
252man/man1/aria_chk.1 251man/man1/aria_chk.1
253man/man1/aria_dump_log.1 252man/man1/aria_dump_log.1
254man/man1/aria_ftdump.1 253man/man1/aria_ftdump.1
255man/man1/aria_pack.1 254man/man1/aria_pack.1
256man/man1/aria_read_log.1 255man/man1/aria_read_log.1
257man/man1/aria_s3_copy.1 256man/man1/aria_s3_copy.1
258man/man1/galera_new_cluster.1 
259man/man1/galera_recovery.1 
260man/man1/innochecksum.1 257man/man1/innochecksum.1
261man/man1/mariabackup.1 258man/man1/mariabackup.1
262man/man1/mariadb-access.1 259man/man1/mariadb-access.1
263man/man1/mariadb-admin.1 260man/man1/mariadb-admin.1
264man/man1/mariadb-backup.1 261man/man1/mariadb-backup.1
265man/man1/mariadb-binlog.1 262man/man1/mariadb-binlog.1
266man/man1/mariadb-check.1 263man/man1/mariadb-check.1
267man/man1/mariadb-client-test-embedded.1 264man/man1/mariadb-client-test-embedded.1
268man/man1/mariadb-client-test.1 265man/man1/mariadb-client-test.1
269man/man1/mariadb-conv.1 266man/man1/mariadb-conv.1
270man/man1/mariadb-convert-table-format.1 267man/man1/mariadb-convert-table-format.1
271man/man1/mariadb-dump.1 268man/man1/mariadb-dump.1
272man/man1/mariadb-dumpslow.1 269man/man1/mariadb-dumpslow.1
@@ -331,20 +328,15 @@ man/man1/mysqld_safe_helper.1 @@ -331,20 +328,15 @@ man/man1/mysqld_safe_helper.1
331man/man1/mysqldump.1 328man/man1/mysqldump.1
332man/man1/mysqldumpslow.1 329man/man1/mysqldumpslow.1
333man/man1/mysqlhotcopy.1 330man/man1/mysqlhotcopy.1
334man/man1/mysqlimport.1 331man/man1/mysqlimport.1
335man/man1/mysqlshow.1 332man/man1/mysqlshow.1
336man/man1/mysqlslap.1 333man/man1/mysqlslap.1
337man/man1/mysqltest.1 334man/man1/mysqltest.1
338man/man1/mysqltest_embedded.1 335man/man1/mysqltest_embedded.1
339man/man1/mytop.1 336man/man1/mytop.1
340man/man1/perror.1 337man/man1/perror.1
341man/man1/replace.1 338man/man1/replace.1
342man/man1/resolve_stack_dump.1 339man/man1/resolve_stack_dump.1
343man/man1/resolveip.1 340man/man1/resolveip.1
344man/man1/wsrep_sst_common.1 
345man/man1/wsrep_sst_mariabackup.1 
346man/man1/wsrep_sst_mysqldump.1 
347man/man1/wsrep_sst_rsync.1 
348man/man1/wsrep_sst_rsync_wan.1 
349man/man8/mariadbd.8 341man/man8/mariadbd.8
350man/man8/mysqld.8 342man/man8/mysqld.8
cvs diff -r1.17 -r1.18 pkgsrc/databases/mariadb105-client/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/mariadb105-client/distinfo 2023/03/07 10:28:02 1.17
+++ pkgsrc/databases/mariadb105-client/distinfo 2023/03/18 15:05:41 1.18
@@ -1,18 +1,18 @@ @@ -1,18 +1,18 @@
1$NetBSD: distinfo,v 1.17 2023/03/07 10:28:02 jperkin Exp $ 1$NetBSD: distinfo,v 1.18 2023/03/18 15:05:41 nia Exp $
2 2
3BLAKE2s (mariadb-10.5.18.tar.gz) = fed6b47a5fa140311a20a0c1f87ff04713dcfd51939dc71defed248755160c41 3BLAKE2s (mariadb-10.5.19.tar.gz) = cc7735ea49b9b2f5e14a9534b26859461b977266bfa605e44201e9dfcc431f92
4SHA512 (mariadb-10.5.18.tar.gz) = 1fe13db1c0b66d2bc0c4d80e2c278f6e64027aaeebebfa5a179bd8ca92ae135ae53b72ed26c9b6d35b35fd2ad2a3cb390fd5ee0715b22d4bfafe773f950d804c 4SHA512 (mariadb-10.5.19.tar.gz) = 4a72ca4dfee0d3fa5432495f62c7eb03addc067e2f023b1ebe32bd1d3a0687c2c61c3316c0c4f690db4f74559bce668c6accbe137d906a52116db2bb2f454699
5Size (mariadb-10.5.18.tar.gz) = 111568643 bytes 5Size (mariadb-10.5.19.tar.gz) = 111958233 bytes
6SHA1 (patch-BUILD_compile-pentium32-gcov) = 89a7da728f94f19c153b4d2d2d6ba5462acc941f 6SHA1 (patch-BUILD_compile-pentium32-gcov) = 89a7da728f94f19c153b4d2d2d6ba5462acc941f
7SHA1 (patch-CMakeLists.txt) = 574131db46854715758c60ba5f026498f5b29564 7SHA1 (patch-CMakeLists.txt) = 574131db46854715758c60ba5f026498f5b29564
8SHA1 (patch-client_CMakeLists.txt) = 8fdd8a182304f0b84e120ce95334ace23d02ce88 8SHA1 (patch-client_CMakeLists.txt) = 8fdd8a182304f0b84e120ce95334ace23d02ce88
9SHA1 (patch-client_mysql.cc) = 89fe80fb66b8791131a8c6d1b209e57082804a01 9SHA1 (patch-client_mysql.cc) = 89fe80fb66b8791131a8c6d1b209e57082804a01
10SHA1 (patch-include_my__global.h) = a3b831f91ba2efea9f78e70ab4f706da23b80403 10SHA1 (patch-include_my__global.h) = a3b831f91ba2efea9f78e70ab4f706da23b80403
11SHA1 (patch-include_mysql_service__encryption.h) = bfc2fcba9f33cc58b726f8645dc5400a0df27bd9 11SHA1 (patch-include_mysql_service__encryption.h) = bfc2fcba9f33cc58b726f8645dc5400a0df27bd9
12SHA1 (patch-mysys_my__context.c) = f9c7e6b3b68b857e7781cf5f36c49e88051cfb66 12SHA1 (patch-mysys_my__context.c) = f9c7e6b3b68b857e7781cf5f36c49e88051cfb66
13SHA1 (patch-mysys_my__gethwaddr.c) = f4fd827617697ff386099defc839fe8d082e6c3e 13SHA1 (patch-mysys_my__gethwaddr.c) = f4fd827617697ff386099defc839fe8d082e6c3e
14SHA1 (patch-plugin_auth__pam_testing_pam__mariadb__mtr.c) = 5c7978b5bec79bbc09d3ebeb69dd85f3e6f8a423 14SHA1 (patch-plugin_auth__pam_testing_pam__mariadb__mtr.c) = 5c7978b5bec79bbc09d3ebeb69dd85f3e6f8a423
15SHA1 (patch-plugin_auth__socket_CMakeLists.txt) = 11f52f5335ac56888d8a367caa03c68059eb61c9 15SHA1 (patch-plugin_auth__socket_CMakeLists.txt) = 11f52f5335ac56888d8a367caa03c68059eb61c9
16SHA1 (patch-plugin_auth__socket_auth__socket.c) = 850e94faff382a7e962f6d4d6ff960ddddc624c4 16SHA1 (patch-plugin_auth__socket_auth__socket.c) = 850e94faff382a7e962f6d4d6ff960ddddc624c4
17SHA1 (patch-scripts_CMakeLists.txt) = 54591a4d255a8133e06ab5d52bad262acffcddda 17SHA1 (patch-scripts_CMakeLists.txt) = 54591a4d255a8133e06ab5d52bad262acffcddda
18SHA1 (patch-scripts_mysqld__safe.sh) = 4124e4c8df1527049f5eec9f3d2d4bbe80e7c33f 18SHA1 (patch-scripts_mysqld__safe.sh) = 4124e4c8df1527049f5eec9f3d2d4bbe80e7c33f
cvs diff -r1.32 -r1.33 pkgsrc/databases/mariadb105-server/Makefile (expand / switch to unified diff)

--- pkgsrc/databases/mariadb105-server/Makefile 2023/03/07 10:28:02 1.32
+++ pkgsrc/databases/mariadb105-server/Makefile 2023/03/18 15:05:41 1.33
@@ -1,17 +1,16 @@ @@ -1,17 +1,16 @@
1# $NetBSD: Makefile,v 1.32 2023/03/07 10:28:02 jperkin Exp $ 1# $NetBSD: Makefile,v 1.33 2023/03/18 15:05:41 nia Exp $
2 2
3PKGNAME= ${DISTNAME:S/-/-server-/} 3PKGNAME= ${DISTNAME:S/-/-server-/}
4PKGREVISION= 1 
5COMMENT= MariaDB 10.5, a free MySQL compatible database (server) 4COMMENT= MariaDB 10.5, a free MySQL compatible database (server)
6 5
7CONFLICTS= mysql-server-[0-9]* 6CONFLICTS= mysql-server-[0-9]*
8 7
9.include "../../databases/mariadb105-client/Makefile.common" 8.include "../../databases/mariadb105-client/Makefile.common"
10 9
11BUILD_DEFS+= VARBASE 10BUILD_DEFS+= VARBASE
12PLIST_VARS+= disks 11PLIST_VARS+= disks
13 12
14.include "../../mk/bsd.fast.prefs.mk" 13.include "../../mk/bsd.fast.prefs.mk"
15 14
16# Requires getmntinfo 15# Requires getmntinfo
17.if ${OPSYS} != "SunOS" 16.if ${OPSYS} != "SunOS"