[pkgsrc/trunk]: pkgsrc/databases mysql57: updated to 5.7.38

[adam <adam%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/cbf0cd7ea065
branches:  trunk
changeset: 378070:cbf0cd7ea065
user:      adam <adam%pkgsrc.org@localhost>
date:      Thu Apr 28 13:19:04 2022 +0000

description:
mysql57: updated to 5.7.38

Changes in MySQL 5.7.38

SQL Function and Operator Notes

When the mysql client was started with --default-character-set=utf8mb4, successive calls to the UUID() function returned duplicate values.

Security Notes

The linked OpenSSL library for MySQL Server has been updated to version 1.1.1n from 1.1.1l. Issues fixed in OpenSSL are described at https://www.openssl.org/news/cl111.txt and at 
http://www.openssl.org/news/vulnerabilities.html.

Functionality Added or Changed

The default for the group_replication_transaction_size_limit system variable, which sets the maximum transaction size that a replication group accepts, is changed from zero (no limit) to 150000000 
bytes (approximately 143 MB), which is the same as the default in MySQL 8.0. Setting a limit for this system variable by default helps to avoid delays or errors caused by excessively large 
transactions. Transactions above the limit are rolled back and are not sent to Group Replication's Group Communication System (GCS) for distribution to the group. If your Group Replication servers 
previously accepted transactions larger than the new default limit, and you were allowing group_replication_transaction_size_limit to default to the old zero limit, those transactions will start to 
fail after the upgrade to the new default. You must either specify an appropriate size limit that allows the maximum message size you need the group to tolerate (which is the recommended solution), 
or specify a zero setting to restore the previous behavior.

The myisam_repair_threads system variable and myisamchk --parallel-recover option are deprecated; expect support for both to be removed in a future release of MySQL.

Values other than 1 (the default) for myisam_repair_threads produce a warning.

Bugs Fixed

InnoDB: A missing null pointer check for an index instance caused a failure.

InnoDB: Purge threads processed undo records of an encrypted table for which the tablespace was not loaded, causing a failure.

InnoDB: Incorrect AUTO_INCREMENT values were generated when the maximum integer column value was exceeded. The error was due to the maximum column value not being considered. The previous valid 
AUTO_INCREMENT value should have been returned in this case, causing a duplicate key error.

Partitioning: In some cases, establishing a connection to MySQL server could fail if the .ibd file for a partition was missing.

Statements that cannot be parsed (due, for example, to syntax errors) are no longer written to the slow query log.

It was not possible to revoke the DROP privilege on the Performance Schema.

A page cleaner thread timed out as it waited for an exclusive lock on an index page held by a full-text index creation operation on a large table.

A memory leak occurred if mysqldump was used on more than one table with the --order-by-primary option. The memory allocated for sorting each table’s rows is now freed after every table, rather than 
only once.

mysqld_safe log message textual errors were corrected.

diffstat:

 databases/mysql57-client/Makefile.common |  4 ++--
 databases/mysql57-client/PLIST           |  4 ++--
 databases/mysql57-client/distinfo        |  8 ++++----
 databases/mysql57-server/PLIST           |  6 +++++-
 4 files changed, 13 insertions(+), 9 deletions(-)

diffs (90 lines):

diff -r d91b9123aa15 -r cbf0cd7ea065 databases/mysql57-client/Makefile.common
--- a/databases/mysql57-client/Makefile.common  Thu Apr 28 12:33:30 2022 +0000
+++ b/databases/mysql57-client/Makefile.common  Thu Apr 28 13:19:04 2022 +0000
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile.common,v 1.37 2022/01/21 11:23:50 adam Exp $
+# $NetBSD: Makefile.common,v 1.38 2022/04/28 13:19:04 adam Exp $
 #
 # used by databases/mysql57-client/Makefile
 # used by databases/mysql57-server/Makefile
 
-DISTNAME=      mysql-5.7.37
+DISTNAME=      mysql-5.7.38
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_MYSQL:=MySQL-5.7/}
 
diff -r d91b9123aa15 -r cbf0cd7ea065 databases/mysql57-client/PLIST
--- a/databases/mysql57-client/PLIST    Thu Apr 28 12:33:30 2022 +0000
+++ b/databases/mysql57-client/PLIST    Thu Apr 28 13:19:04 2022 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.24 2022/01/21 11:23:50 adam Exp $
+@comment $NetBSD: PLIST,v 1.25 2022/04/28 13:19:04 adam Exp $
 bin/mysql
 bin/mysql_client_test
 bin/mysql_config
@@ -122,7 +122,7 @@
 lib/libmysqlclient.a
 lib/libmysqlclient.so
 lib/libmysqlclient.so.20
-lib/libmysqlclient.so.20.3.24
+lib/libmysqlclient.so.20.3.25
 lib/pkgconfig/mysqlclient.pc
 man/man1/comp_err.1
 man/man1/innochecksum.1
diff -r d91b9123aa15 -r cbf0cd7ea065 databases/mysql57-client/distinfo
--- a/databases/mysql57-client/distinfo Thu Apr 28 12:33:30 2022 +0000
+++ b/databases/mysql57-client/distinfo Thu Apr 28 13:19:04 2022 +0000
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.48 2022/01/21 11:23:50 adam Exp $
+$NetBSD: distinfo,v 1.49 2022/04/28 13:19:04 adam Exp $
 
-BLAKE2s (mysql-5.7.37.tar.gz) = f4871be0ffd6432fa7a6b6833d30eb38e49ecc95bc0df154b0f5b13a4b4d26b9
-SHA512 (mysql-5.7.37.tar.gz) = 6268227d61d4ff7d29c767c409245a1ba26f6760fac724d53af18931b27295c8e7ef70819b7991746b57f36fe863561afff1577b01b73b517444a4aea3d867d3
-Size (mysql-5.7.37.tar.gz) = 56248775 bytes
+BLAKE2s (mysql-5.7.38.tar.gz) = 4e3a03502455685971333d26608680590ba5b7f1957b2f1dbc899b5041d9d778
+SHA512 (mysql-5.7.38.tar.gz) = 1f861c6edd81a89aff6a4e8116bf78a1df11c3fa6bedbf99dbd827ae1e4dbae5b3625f825b00410c731dd298d1563feb922fd65d8c48036ba46e0d8dffb80f81
+Size (mysql-5.7.38.tar.gz) = 56247722 bytes
 SHA1 (patch-CMakeLists.txt) = 1409a98380c999c6973fa3106dc35684b7c3b3cc
 SHA1 (patch-client_CMakeLists.txt) = 4af2fb3f3d05a66a9ee89f3653e2fcccadfa5f79
 SHA1 (patch-client_completion_hash.cc) = b86ec80beac624b2aa21c7587e351ff126400ecb
diff -r d91b9123aa15 -r cbf0cd7ea065 databases/mysql57-server/PLIST
--- a/databases/mysql57-server/PLIST    Thu Apr 28 12:33:30 2022 +0000
+++ b/databases/mysql57-server/PLIST    Thu Apr 28 13:19:04 2022 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.23 2021/10/19 18:57:37 adam Exp $
+@comment $NetBSD: PLIST,v 1.24 2022/04/28 13:19:04 adam Exp $
 bin/innochecksum
 bin/lz4_decompress
 bin/my_print_defaults
@@ -1601,6 +1601,7 @@
 share/mysql/test/r/mysqldump-no-binlog.result
 share/mysql/test/r/mysqldump.result
 share/mysql/test/r/mysqldump_bug29998457.result
+share/mysql/test/r/mysqldump_bug30042589.result
 share/mysql/test/r/mysqldump_bugs.result
 share/mysql/test/r/mysqldump_gtid_state.result
 share/mysql/test/r/mysqldump_restore.result
@@ -1854,6 +1855,7 @@
 share/mysql/test/r/skip_name_resolve.result
 share/mysql/test/r/slave-running.result
 share/mysql/test/r/slave-stopped.result
+share/mysql/test/r/slow_log.result
 share/mysql/test/r/sort_buffer_size_functionality.result
 share/mysql/test/r/sp-big.result
 share/mysql/test/r/sp-bugs.result
@@ -14195,6 +14197,7 @@
 share/mysql/test/t/mysqldump-no-binlog.test
 share/mysql/test/t/mysqldump.test
 share/mysql/test/t/mysqldump_bug29998457.test
+share/mysql/test/t/mysqldump_bug30042589.test
 share/mysql/test/t/mysqldump_bugs.test
 share/mysql/test/t/mysqldump_gtid_state-master.opt
 share/mysql/test/t/mysqldump_gtid_state.test
@@ -14497,6 +14500,7 @@
 share/mysql/test/t/skip_log_bin.test
 share/mysql/test/t/skip_name_resolve-master.opt
 share/mysql/test/t/skip_name_resolve.test
+share/mysql/test/t/slow_log.test
 share/mysql/test/t/sort_buffer_size_functionality-master.opt
 share/mysql/test/t/sort_buffer_size_functionality.test
 share/mysql/test/t/sp-big.test