CVS commit: pkgsrc/databases

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Thu Apr 28 13:19:04 UTC 2022

Modified Files:
        pkgsrc/databases/mysql57-client: Makefile.common PLIST distinfo
        pkgsrc/databases/mysql57-server: PLIST

Log Message:
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.


To generate a diff of this commit:
cvs rdiff -u -r1.37 -r1.38 pkgsrc/databases/mysql57-client/Makefile.common
cvs rdiff -u -r1.24 -r1.25 pkgsrc/databases/mysql57-client/PLIST
cvs rdiff -u -r1.48 -r1.49 pkgsrc/databases/mysql57-client/distinfo
cvs rdiff -u -r1.23 -r1.24 pkgsrc/databases/mysql57-server/PLIST

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/mysql57-client/Makefile.common
diff -u pkgsrc/databases/mysql57-client/Makefile.common:1.37 pkgsrc/databases/mysql57-client/Makefile.common:1.38
--- pkgsrc/databases/mysql57-client/Makefile.common:1.37        Fri Jan 21 11:23:50 2022
+++ pkgsrc/databases/mysql57-client/Makefile.common     Thu Apr 28 13:19:04 2022
@@ -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/}
 

Index: pkgsrc/databases/mysql57-client/PLIST
diff -u pkgsrc/databases/mysql57-client/PLIST:1.24 pkgsrc/databases/mysql57-client/PLIST:1.25
--- pkgsrc/databases/mysql57-client/PLIST:1.24  Fri Jan 21 11:23:50 2022
+++ pkgsrc/databases/mysql57-client/PLIST       Thu Apr 28 13:19:04 2022
@@ -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 @@ include/mysql/typelib.h
 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

Index: pkgsrc/databases/mysql57-client/distinfo
diff -u pkgsrc/databases/mysql57-client/distinfo:1.48 pkgsrc/databases/mysql57-client/distinfo:1.49
--- pkgsrc/databases/mysql57-client/distinfo:1.48       Fri Jan 21 11:23:50 2022
+++ pkgsrc/databases/mysql57-client/distinfo    Thu Apr 28 13:19:04 2022
@@ -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

Index: pkgsrc/databases/mysql57-server/PLIST
diff -u pkgsrc/databases/mysql57-server/PLIST:1.23 pkgsrc/databases/mysql57-server/PLIST:1.24
--- pkgsrc/databases/mysql57-server/PLIST:1.23  Tue Oct 19 18:57:37 2021
+++ pkgsrc/databases/mysql57-server/PLIST       Thu Apr 28 13:19:04 2022
@@ -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-max.result
 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_log_bin.result
 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-m
 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-master.o
 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