git: bb4be35f40bb - 2022Q2 - databases/mysql80-{client, server}: Update to latest release 8.0.29

From: Jochen Neumeister <joneum_at_FreeBSD.org>
Date: Tue, 03 May 2022 17:14:09 UTC
The branch 2022Q2 has been updated by joneum:

URL: https://cgit.FreeBSD.org/ports/commit/?id=bb4be35f40bb08b1b00a9516148b956dd500a636

commit bb4be35f40bb08b1b00a9516148b956dd500a636
Author:     Jochen Neumeister <joneum@FreeBSD.org>
AuthorDate: 2022-05-03 16:53:20 +0000
Commit:     Jochen Neumeister <joneum@FreeBSD.org>
CommitDate: 2022-05-03 17:13:38 +0000

    databases/mysql80-{client, server}: Update to latest release 8.0.29
    
    Bugs Fixed
    
        InnoDB: A failure occurred when attempting to purge undo records for a table with an instantly added column. (Bug #33924532)
    
        InnoDB: High-priority transactions were not permitted to stop waiting when interrupted or to timeout while waiting for a lock, preventing deadlocks from being resolved. In cases where the blocking transaction is also high-priority, high-priority transactions are now permitted to stop waiting when interrupted or timeout when exceeding the lock wait timeout period. If a blocking transaction is not high-priority, high-priority transactions wait for the blocking transaction to release its locks. (Bug #33856332)
    
        InnoDB: The AIO synchronization queue used on Windows was removed. The synchronous file I/O read-write function (SyncFileIO::execute) was revised to handle files opened for both normal and overlapped I/O, as it does on Linux. (Bug #33840645)
    
        InnoDB: Table version metadata was not reset after truncating all partitions of a table with an instantly added column. (Bug #33822729)
    
        InnoDB: The srv_error_monitor_thread() function, which prints warnings about semaphore waits, failed to handle a long semaphore wait as expected. To address this issue, a blocking call was moved to a more appropriate location. Related monitor thread code was simplified and improved, and missing shutdown signals were added for several server threads.
    
        Enabling and disabling of the standard monitor by InnoDB is now performed independently of the user-settable innodb_status_output variable. This change addresses an issue in which the monitor was enabled by InnoDB in a particular scenario but not set back to its previous value. Thanks to Yuhui Wang for the contribution. (Bug #33789526, Bug #93878)
    
        InnoDB: Valgrind testing identified an off-by-one error in rec_convert_dtuple_to_rec_old() in the InnoDB sources. (Bug #33784672)
    
        InnoDB: The UNIV_DEBUG variant of the mem_heap_alloc() function in the InnoDB sources was modified to improve Valgrind error detection. (Bug #33783709)
    
        InnoDB: A fast shutdown did not wait for all active I/O operations to finish before closing all files. (Bug #33768584)
    
        InnoDB: A Clang warning reported an incorrectly placed @return command. (Bug #33734011)
    
        InnoDB: Values of the new record locks array (m_prebuilt->new_rec_locks[]) were not properly synchronized when switching between partitions, causing an assertion failure due to locks being freed or not freed as expected. (Bug #33724166)
    
        InnoDB: A race condition in the function that updates the double write buffer when a write request is completed caused a long semaphore wait error. (Bug #33712370)
    
        InnoDB: A function wrongly assumed that changing a record in an indexed column always requires creating a new record in the secondary index, resulting in an lock-related assertion failure. To address this and other similar cases, the lock_rec_convert_impl_to_expl() function that converts an implicit record lock to an explicit record lock is now used only when an implicit record lock is actually held. (Bug #33657235)
    
        InnoDB: A number of Doxygen issues in the InnoDB sources were addressed. (Bug #33603036)
    
        InnoDB: A missing null pointer check for an index instance caused a failure. (Bug #33600109)
    
    Full (and long) relnotes: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-29.html
    
    Sponsored by:   Netzkommune GmbH
    
    (cherry picked from commit 0517374e455af49ec25820891cb387e125d2cfde)
---
 databases/mysql80-client/Makefile                             |  2 +-
 databases/mysql80-server/Makefile                             |  4 ++--
 databases/mysql80-server/distinfo                             |  6 +++---
 ...rage_innobase_include_detail_ut_large__page__alloc-linux.h | 11 -----------
 databases/mysql80-server/pkg-plist                            |  7 +++++++
 5 files changed, 13 insertions(+), 17 deletions(-)

diff --git a/databases/mysql80-client/Makefile b/databases/mysql80-client/Makefile
index 0c8c8dd4ee7f..17516ff51626 100644
--- a/databases/mysql80-client/Makefile
+++ b/databases/mysql80-client/Makefile
@@ -1,7 +1,7 @@
 # Created by: "Mahdi Mokhtari <mokhi64@gmail.com>"
 
 PORTNAME=	mysql
-PORTREVISION=	1
+PORTREVISION=	0
 PKGNAMESUFFIX=	80-client
 
 COMMENT=	Multithreaded SQL database (client)
diff --git a/databases/mysql80-server/Makefile b/databases/mysql80-server/Makefile
index 64797e3f0842..30b0caee6b9a 100644
--- a/databases/mysql80-server/Makefile
+++ b/databases/mysql80-server/Makefile
@@ -1,8 +1,8 @@
 # Created by: Mahdi Mokhtari <mokhi64@gmail.com>
 
 PORTNAME?=		mysql
-PORTVERSION=		8.0.28
-PORTREVISION?=		2
+PORTVERSION=		8.0.29
+PORTREVISION?=		0
 CATEGORIES=		databases
 MASTER_SITES=		MYSQL/MySQL-8.0
 PKGNAMESUFFIX?=		80-server
diff --git a/databases/mysql80-server/distinfo b/databases/mysql80-server/distinfo
index d74c18256ce7..33a7799c04a9 100644
--- a/databases/mysql80-server/distinfo
+++ b/databases/mysql80-server/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1642804921
-SHA256 (mysql-boost-8.0.28.tar.gz) = 6dd0303998e70066d36905bd8fef1c01228ea182dbfbabc6c22ebacdbf8b5941
-SIZE (mysql-boost-8.0.28.tar.gz) = 298044027
+TIMESTAMP = 1651315615
+SHA256 (mysql-boost-8.0.29.tar.gz) = fd34a84c65fc7b15609d55b1f5d128c4d5543a6b95fa638569c3277c5c7bb048
+SIZE (mysql-boost-8.0.29.tar.gz) = 327770349
diff --git a/databases/mysql80-server/files/patch-storage_innobase_include_detail_ut_large__page__alloc-linux.h b/databases/mysql80-server/files/patch-storage_innobase_include_detail_ut_large__page__alloc-linux.h
deleted file mode 100644
index 3898f3653e6e..000000000000
--- a/databases/mysql80-server/files/patch-storage_innobase_include_detail_ut_large__page__alloc-linux.h
+++ /dev/null
@@ -1,11 +0,0 @@
---- storage/innobase/include/detail/ut/large_page_alloc-linux.h.orig	2021-12-17 16:07:27 UTC
-+++ storage/innobase/include/detail/ut/large_page_alloc-linux.h
-@@ -52,7 +52,7 @@ inline void *large_page_aligned_alloc(size_t n_bytes) 
-   // mmap will internally round n_bytes to the multiple of huge-page size if it
-   // is not already
-   void *ptr = mmap(nullptr, n_bytes, PROT_READ | PROT_WRITE,
--                   MAP_PRIVATE | MAP_ANON | MAP_HUGETLB, -1, 0);
-+                   MAP_PRIVATE | MAP_ANON, -1, 0);
-   if (unlikely(ptr == (void *)-1)) {
-     ib::log_warn(ER_IB_MSG_856) << "large_page_aligned_alloc mmap(" << n_bytes
-                                 << " bytes) failed;"
diff --git a/databases/mysql80-server/pkg-plist b/databases/mysql80-server/pkg-plist
index ac9c0b0e34ce..c94ddf4c94e7 100644
--- a/databases/mysql80-server/pkg-plist
+++ b/databases/mysql80-server/pkg-plist
@@ -31,6 +31,7 @@ lib/mysql/libmysqlharness_tls.so
 lib/mysql/libmysqlharness_tls.so.1
 lib/mysql/libmysqlrouter.so
 lib/mysql/libmysqlrouter.so.1
+lib/mysql/libmysqlrouter_connection_pool.so.1
 lib/mysql/libmysqlrouter_http.so
 lib/mysql/libmysqlrouter_http.so.1
 lib/mysql/libmysqlrouter_http_auth_backend.so
@@ -39,6 +40,10 @@ lib/mysql/libmysqlrouter_http_auth_realm.so
 lib/mysql/libmysqlrouter_http_auth_realm.so.1
 lib/mysql/libmysqlrouter_io_component.so
 lib/mysql/libmysqlrouter_io_component.so.1
+lib/mysql/libmysqlrouter_metadata_cache.so.1
+lib/mysql/libmysqlrouter_mysqlxmessages.so.1
+lib/mysql/libmysqlrouter_routing.so.1
+lib/mysql/mysqlrouter/connection_pool.so
 lib/mysql/mysqlrouter/http_auth_backend.so
 lib/mysql/mysqlrouter/http_auth_realm.so
 lib/mysql/mysqlrouter/http_server.so
@@ -46,6 +51,7 @@ lib/mysql/mysqlrouter/io.so
 lib/mysql/mysqlrouter/keepalive.so
 lib/mysql/mysqlrouter/metadata_cache.so
 lib/mysql/mysqlrouter/rest_api.so
+lib/mysql/mysqlrouter/rest_connection_pool.so
 lib/mysql/mysqlrouter/rest_metadata_cache.so
 lib/mysql/mysqlrouter/rest_router.so
 lib/mysql/mysqlrouter/rest_routing.so
@@ -79,6 +85,7 @@ lib/mysql/plugin/component_test_mysql_runtime_error.so
 lib/mysql/plugin/component_test_mysql_system_variable_set.so
 lib/mysql/plugin/component_test_pfs_notification.so
 lib/mysql/plugin/component_test_pfs_resource_group.so
+lib/mysql/plugin/component_test_sensitive_system_variables.so
 lib/mysql/plugin/component_test_status_var_service.so
 lib/mysql/plugin/component_test_status_var_service_int.so
 lib/mysql/plugin/component_test_status_var_service_reg_only.so