pkgsrc-Changes-HG archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

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



details:   https://anonhg.NetBSD.org/pkgsrc/rev/73203f6b76c9
branches:  trunk
changeset: 440914:73203f6b76c9
user:      adam <adam%pkgsrc.org@localhost>
date:      Wed Oct 21 13:34:50 2020 +0000

description:
mysql57: updated to 5.7.32

Changes in MySQL 5.7.32 (2020-10-19, General Availability)

Functionality Added or Changed

Bugs Fixed

Functionality Added or Changed

LOCK TABLES privilege checking for views was improved.

Bugs Fixed

InnoDB: A query that updated the clustered index of an internal temporary table returned an incorrect result. The modified pages of the clustered index were not added to the flush list resulting in 
lost changes when the modified pages were evicted from the buffer pool.

References: This issue is a regression of:

InnoDB: An ALTER TABLE ... IMPORT TABLESPACE operation on a large encrypted and compressed table failed with a Page decompress failed after reading from disk error. The decryption operation did not 
use the encryption block size used during encryption. Also, the encryption process did not consider compressed length, while the decryption process decrypts data by compressed length only.

InnoDB: A failure occurred during a concurrent update operation. The failure was due to an invalid previous record value.

InnoDB: The function used to process the SHOW ENGINE INNODB MUTEX statement was insufficiently isolated from other threads adding new mutexes concurrently.

InnoDB: The buffer control block structure (buf_block_t) was freed while reducing the size of the buffer pool, causing an assertion failure. The fix for this bug also backports important aspects of 
the fix for

InnoDB: In session started with START TRANSACTION WITH CONSISTENT SNAPSHOT, a range query returned a truncated result. The end range flag was not reset at the beginning of the index read resulting in 
an aborted read and missing rows.

References: This issue is a regression of:

InnoDB: A full-text phrase search raised an assertion failure.

Thanks to TXSQL (Tencent MySQL) for the contribution.

References: This issue is a regression of:

InnoDB: A long running statistics calculation operation on a large table blocked other operations requiring access to the table's statistics, causing those operations to fail. A new statistics 
calculation mutex was introduced, which permits concurrent access table statistics.

Thanks to Kamil Holubicki for the contribution.

InnoDB: Two connections attempted to use the same transaction handler object resulting in a stalled query.

Replication: When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the first time that the source uses a given MEMORY table 
after startup, it logs an event that notifies replicas that the table must be emptied by writing a statement to the binary log to that effect. Previously, this was a DELETE statement, but it is now a 
TRUNCATE TABLE statement. A replica server also writes this statement to its own binary log when it shuts down and restarts. The statement is always logged in statement format, even if the binary 
logging format is set to ROW, and it is written even if read_only or super_read_only mode is set on the server.

Replication: When the system variable session_track_gtids was set to OWN_GTID on a multithreaded replica, the replica’s performance would degrade over time and begin to lag behind the master. The 
cause was the buildup of the GTIDs recorded by the replica’s worker threads at each transaction commit, which increased the time taken by the worker threads to insert new ones. Session state tracking 
is now disabled for worker threads on a multithreaded replica. Thanks to Facebook for the contribution.

Certain cases of successful LDAP authentication could cause the server to hang.

In bootstrapping mode, certain multiple-statement transactions could cause unexpected server behavior.

Sensitive LDAP authentication plugin system variables now display as asterisks when retrieved in SQL statements.

After the fix for

References: This issue is a regression of:

Some INSERT statements were not handled correctly.

Certain prepared statements could cause an unexpected server exit.

mysqlpump object validation included objects in excluded databases.

LDAP authentication plugins enforced CA verification incorrectly, which could result in use of an incorrect CA.

ORDER BY queries were not executed correctly when sort_buffer_size and max_sort_length were set to values which caused the internal limit on the maximum number of keys allowed per sort buffer to be 
set to 0.

A large number of nested arguments in full-text search query caused an error.

When explicit_defaults_for_timestamp was disabled and a NULL was inserted into a generated column declared as TIMESTAMP NOT NULL, the server would attempt to convert the inserted value to 
CURRENT_TIMESTAMP. Such an insertion is now rejected with ER_BAD_NULL_ERROR.

An assertion could be raised when the SQL layer passed incorrect information to InnoDB about the type of operation to be performed on a temporary table.

diffstat:

 databases/mysql57-client/Makefile        |   3 +--
 databases/mysql57-client/Makefile.common |   4 ++--
 databases/mysql57-client/PLIST           |   4 ++--
 databases/mysql57-client/distinfo        |  10 +++++-----
 databases/mysql57-server/Makefile        |   3 +--
 databases/mysql57-server/PLIST           |  27 +++++++++++++++++++++------
 6 files changed, 32 insertions(+), 19 deletions(-)

diffs (234 lines):

diff -r 77ba65f30697 -r 73203f6b76c9 databases/mysql57-client/Makefile
--- a/databases/mysql57-client/Makefile Wed Oct 21 12:30:13 2020 +0000
+++ b/databases/mysql57-client/Makefile Wed Oct 21 13:34:50 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.33 2020/08/31 18:06:56 wiz Exp $
+# $NetBSD: Makefile,v 1.34 2020/10/21 13:34:50 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/-client-/}
-PKGREVISION=   1
 COMMENT=       MySQL 5, a free SQL database (client)
 
 CONFLICTS=     mysql3-client-[0-9]*
diff -r 77ba65f30697 -r 73203f6b76c9 databases/mysql57-client/Makefile.common
--- a/databases/mysql57-client/Makefile.common  Wed Oct 21 12:30:13 2020 +0000
+++ b/databases/mysql57-client/Makefile.common  Wed Oct 21 13:34:50 2020 +0000
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile.common,v 1.28 2020/08/05 16:12:11 adam Exp $
+# $NetBSD: Makefile.common,v 1.29 2020/10/21 13:34:50 adam Exp $
 #
 # used by databases/mysql57-client/Makefile
 # used by databases/mysql57-server/Makefile
 
-DISTNAME=      mysql-5.7.31
+DISTNAME=      mysql-5.7.32
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_MYSQL:=MySQL-5.7/}
 
diff -r 77ba65f30697 -r 73203f6b76c9 databases/mysql57-client/PLIST
--- a/databases/mysql57-client/PLIST    Wed Oct 21 12:30:13 2020 +0000
+++ b/databases/mysql57-client/PLIST    Wed Oct 21 13:34:50 2020 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.18 2020/08/05 16:12:11 adam Exp $
+@comment $NetBSD: PLIST,v 1.19 2020/10/21 13:34:50 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.18
+lib/libmysqlclient.so.20.3.19
 lib/pkgconfig/mysqlclient.pc
 man/man1/comp_err.1
 man/man1/innochecksum.1
diff -r 77ba65f30697 -r 73203f6b76c9 databases/mysql57-client/distinfo
--- a/databases/mysql57-client/distinfo Wed Oct 21 12:30:13 2020 +0000
+++ b/databases/mysql57-client/distinfo Wed Oct 21 13:34:50 2020 +0000
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.38 2020/08/05 16:12:11 adam Exp $
+$NetBSD: distinfo,v 1.39 2020/10/21 13:34:50 adam Exp $
 
-SHA1 (mysql-5.7.31.tar.gz) = de7096fd56bfb9e904f81f7b0cff01ca9f1b89c4
-RMD160 (mysql-5.7.31.tar.gz) = a5ebd18b6841b0fb794e5fa88fac302f24c5e860
-SHA512 (mysql-5.7.31.tar.gz) = b529f19585e99a48264b4ca4cadba4ea81714750b9517df55a32f52accf3bc01bae9bcd40fdce097db8c7aa10e3a986d936cfceec5664121ebb5785c32d6db84
-Size (mysql-5.7.31.tar.gz) = 54418341 bytes
+SHA1 (mysql-5.7.32.tar.gz) = ef8e61325901edf011c29fd0dca35c4c8f07ca74
+RMD160 (mysql-5.7.32.tar.gz) = 848533114b445f91a3fb2abf7d840f81b38c9679
+SHA512 (mysql-5.7.32.tar.gz) = 01336bd2e81514223bdb23220f9bda02432951bfc3e9f3ae0688d4c371f5aade608d6cb57df06c60c54a3810da43007d671b8b423805d7ec0992388fc605b411
+Size (mysql-5.7.32.tar.gz) = 56154080 bytes
 SHA1 (patch-CMakeLists.txt) = 1409a98380c999c6973fa3106dc35684b7c3b3cc
 SHA1 (patch-client_CMakeLists.txt) = 4af2fb3f3d05a66a9ee89f3653e2fcccadfa5f79
 SHA1 (patch-client_completion_hash.cc) = b86ec80beac624b2aa21c7587e351ff126400ecb
diff -r 77ba65f30697 -r 73203f6b76c9 databases/mysql57-server/Makefile
--- a/databases/mysql57-server/Makefile Wed Oct 21 12:30:13 2020 +0000
+++ b/databases/mysql57-server/Makefile Wed Oct 21 13:34:50 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.34 2020/08/31 18:06:56 wiz Exp $
+# $NetBSD: Makefile,v 1.35 2020/10/21 13:34:50 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/-server-/}
-PKGREVISION=   1
 COMMENT=       MySQL 5, a free SQL database (server)
 
 CONFLICTS=     mysql3-server-[0-9]*
diff -r 77ba65f30697 -r 73203f6b76c9 databases/mysql57-server/PLIST
--- a/databases/mysql57-server/PLIST    Wed Oct 21 12:30:13 2020 +0000
+++ b/databases/mysql57-server/PLIST    Wed Oct 21 13:34:50 2020 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.18 2020/08/05 16:12:11 adam Exp $
+@comment $NetBSD: PLIST,v 1.19 2020/10/21 13:34:50 adam Exp $
 bin/innochecksum
 bin/lz4_decompress
 bin/my_print_defaults
@@ -619,6 +619,7 @@
 share/mysql/test/include/have_plugin_interface.inc
 share/mysql/test/include/have_plugin_server.inc
 share/mysql/test/include/have_profiling.inc
+share/mysql/test/include/have_punch_hole.inc
 share/mysql/test/include/have_query_cache.inc
 share/mysql/test/include/have_query_cache_disabled.inc
 share/mysql/test/include/have_replication_observers_example_plugin.inc
@@ -2153,8 +2154,9 @@
 share/mysql/test/std_data/crl-client-revoked.crl
 share/mysql/test/std_data/crl-server-cert.pem
 share/mysql/test/std_data/crl-server-key.pem
-share/mysql/test/std_data/crldir/b23bb52f.r0
+share/mysql/test/std_data/crldir/5df06fcb.r0
 share/mysql/test/std_data/data_50722.zip
+share/mysql/test/std_data/data_57_32.zip
 share/mysql/test/std_data/des_key_file
 share/mysql/test/std_data/dtrace.d
 share/mysql/test/std_data/expired-ca-key.pem
@@ -2184,6 +2186,8 @@
 share/mysql/test/std_data/funcs_1/t4.txt
 share/mysql/test/std_data/funcs_1/t7.txt
 share/mysql/test/std_data/funcs_1/t9.txt
+share/mysql/test/std_data/import2_57_32.zip
+share/mysql/test/std_data/import_57_32.zip
 share/mysql/test/std_data/init-file-rpl-filter.dat
 share/mysql/test/std_data/init_file.dat
 share/mysql/test/std_data/intersect-bug50389.tsv
@@ -5130,6 +5134,7 @@
 share/mysql/test/suite/innodb/r/alter_rename_files.result
 share/mysql/test/suite/innodb/r/alter_table_redundant.result
 share/mysql/test/suite/innodb/r/alter_table_stage_progress.result
+share/mysql/test/suite/innodb/r/analyze_index.result
 share/mysql/test/suite/innodb/r/analyze_table.result
 share/mysql/test/suite/innodb/r/attachable_trx.result
 share/mysql/test/suite/innodb/r/autoinc_debug.result
@@ -5192,6 +5197,7 @@
 share/mysql/test/suite/innodb/r/i_s_files_debug.result
 share/mysql/test/suite/innodb/r/ibuf_not_empty.result
 share/mysql/test/suite/innodb/r/import.result
+share/mysql/test/suite/innodb/r/import_compress_encrypt.result
 share/mysql/test/suite/innodb/r/import_export_4k.result
 share/mysql/test/suite/innodb/r/import_tablespace_page_corrupt.result
 share/mysql/test/suite/innodb/r/import_tablespace_schema_missmatch.result
@@ -5289,7 +5295,9 @@
 share/mysql/test/suite/innodb/r/innodb_bug21704.result
 share/mysql/test/suite/innodb/r/innodb_bug30113362.result
 share/mysql/test/suite/innodb/r/innodb_bug30423.result
+share/mysql/test/suite/innodb/r/innodb_bug30594501.result
 share/mysql/test/suite/innodb/r/innodb_bug30919.result
+share/mysql/test/suite/innodb/r/innodb_bug31205266.result
 share/mysql/test/suite/innodb/r/innodb_bug34053.result
 share/mysql/test/suite/innodb/r/innodb_bug34300.result
 share/mysql/test/suite/innodb/r/innodb_bug35220.result
@@ -5494,6 +5502,7 @@
 share/mysql/test/suite/innodb/t/alter_table_redundant.test
 share/mysql/test/suite/innodb/t/alter_table_stage_progress-master.opt
 share/mysql/test/suite/innodb/t/alter_table_stage_progress.test
+share/mysql/test/suite/innodb/t/analyze_index.test
 share/mysql/test/suite/innodb/t/analyze_table.test
 share/mysql/test/suite/innodb/t/attachable_trx.test
 share/mysql/test/suite/innodb/t/autoinc_debug.test
@@ -5566,6 +5575,7 @@
 share/mysql/test/suite/innodb/t/ibuf_not_empty-master.opt
 share/mysql/test/suite/innodb/t/ibuf_not_empty.test
 share/mysql/test/suite/innodb/t/import.test
+share/mysql/test/suite/innodb/t/import_compress_encrypt.test
 share/mysql/test/suite/innodb/t/import_export_4k.test
 share/mysql/test/suite/innodb/t/import_tablespace_page_corrupt.test
 share/mysql/test/suite/innodb/t/import_tablespace_schema_missmatch.test
@@ -5690,8 +5700,11 @@
 share/mysql/test/suite/innodb/t/innodb_bug21704.test
 share/mysql/test/suite/innodb/t/innodb_bug30113362.test
 share/mysql/test/suite/innodb/t/innodb_bug30423.test
+share/mysql/test/suite/innodb/t/innodb_bug30594501-master.opt
+share/mysql/test/suite/innodb/t/innodb_bug30594501.test
 share/mysql/test/suite/innodb/t/innodb_bug30919-master.opt
 share/mysql/test/suite/innodb/t/innodb_bug30919.test
+share/mysql/test/suite/innodb/t/innodb_bug31205266.test
 share/mysql/test/suite/innodb/t/innodb_bug34053.test
 share/mysql/test/suite/innodb/t/innodb_bug34300.test
 share/mysql/test/suite/innodb/t/innodb_bug35220.test
@@ -5959,6 +5972,7 @@
 share/mysql/test/suite/innodb_fts/r/ngram_debug.result
 share/mysql/test/suite/innodb_fts/r/opt.result
 share/mysql/test/suite/innodb_fts/r/phrase.result
+share/mysql/test/suite/innodb_fts/r/phrase_clear_no_match.result
 share/mysql/test/suite/innodb_fts/r/plugin.result
 share/mysql/test/suite/innodb_fts/r/plugin_1.result
 share/mysql/test/suite/innodb_fts/r/plugin_debug.result
@@ -6019,6 +6033,7 @@
 share/mysql/test/suite/innodb_fts/t/opt-master.opt
 share/mysql/test/suite/innodb_fts/t/opt.test
 share/mysql/test/suite/innodb_fts/t/phrase.test
+share/mysql/test/suite/innodb_fts/t/phrase_clear_no_match.test
 share/mysql/test/suite/innodb_fts/t/plugin-master.opt
 share/mysql/test/suite/innodb_fts/t/plugin.test
 share/mysql/test/suite/innodb_fts/t/plugin_1-master.opt
@@ -9733,7 +9748,6 @@
 share/mysql/test/suite/rpl/r/rpl_gtid_binary_log_as_relay_log.result
 share/mysql/test/suite/rpl/r/rpl_gtid_compress_thd_ignore_super_read_only.result
 share/mysql/test/suite/rpl/r/rpl_gtid_create_select.result
-share/mysql/test/suite/rpl/r/rpl_gtid_delete_memory_table_after_start_server.result
 share/mysql/test/suite/rpl/r/rpl_gtid_deleted_binlog_fail_to_connect.result
 share/mysql/test/suite/rpl/r/rpl_gtid_do_table_filter_insensitive.result
 share/mysql/test/suite/rpl/r/rpl_gtid_do_table_filter_sensitive.result
@@ -9777,6 +9791,7 @@
 share/mysql/test/suite/rpl/r/rpl_gtid_table_repository_split_trx.result
 share/mysql/test/suite/rpl/r/rpl_gtid_temp_table.result
 share/mysql/test/suite/rpl/r/rpl_gtid_transaction_split_across_relay_logs.result
+share/mysql/test/suite/rpl/r/rpl_gtid_truncate_memory_table_after_start_server.result
 share/mysql/test/suite/rpl/r/rpl_gtid_validate_slave_gtids.result
 share/mysql/test/suite/rpl/r/rpl_gtids_restart_slave_io_lost_trx.result
 share/mysql/test/suite/rpl/r/rpl_gtids_table.result
@@ -9910,8 +9925,8 @@
 share/mysql/test/suite/rpl/r/rpl_mysqlbinlog_gtid_on.result
 share/mysql/test/suite/rpl/r/rpl_mysqlbinlog_relay_start_position.result
 share/mysql/test/suite/rpl/r/rpl_name_const.result
-share/mysql/test/suite/rpl/r/rpl_no_gtid_delete_memory_table_after_start_server.result
 share/mysql/test/suite/rpl/r/rpl_no_gtid_split_statements.result
+share/mysql/test/suite/rpl/r/rpl_no_gtid_truncate_memory_table_after_start_server.result
 share/mysql/test/suite/rpl/r/rpl_nogtid_rollback_on_anonymous_gtid.result
 share/mysql/test/suite/rpl/r/rpl_non_direct_mixed_mixing_engines.result
 share/mysql/test/suite/rpl/r/rpl_non_direct_row_mixing_engines.result
@@ -10452,7 +10467,6 @@
 share/mysql/test/suite/rpl/t/rpl_gtid_compress_thd_ignore_super_read_only-slave.opt
 share/mysql/test/suite/rpl/t/rpl_gtid_compress_thd_ignore_super_read_only.test
 share/mysql/test/suite/rpl/t/rpl_gtid_create_select.test
-share/mysql/test/suite/rpl/t/rpl_gtid_delete_memory_table_after_start_server.test
 share/mysql/test/suite/rpl/t/rpl_gtid_deleted_binlog_fail_to_connect.test
 share/mysql/test/suite/rpl/t/rpl_gtid_do_table_filter_insensitive-master.opt
 share/mysql/test/suite/rpl/t/rpl_gtid_do_table_filter_insensitive-slave.opt
@@ -10522,6 +10536,7 @@
 share/mysql/test/suite/rpl/t/rpl_gtid_temp_table.test
 share/mysql/test/suite/rpl/t/rpl_gtid_transaction_split_across_relay_logs.cnf
 share/mysql/test/suite/rpl/t/rpl_gtid_transaction_split_across_relay_logs.test
+share/mysql/test/suite/rpl/t/rpl_gtid_truncate_memory_table_after_start_server.test
 share/mysql/test/suite/rpl/t/rpl_gtid_validate_slave_gtids.test
 share/mysql/test/suite/rpl/t/rpl_gtids_restart_slave_io_lost_trx.test
 share/mysql/test/suite/rpl/t/rpl_gtids_table.test
@@ -10746,8 +10761,8 @@
 share/mysql/test/suite/rpl/t/rpl_mysqlbinlog_gtid_on.test
 share/mysql/test/suite/rpl/t/rpl_mysqlbinlog_relay_start_position.test
 share/mysql/test/suite/rpl/t/rpl_name_const.test
-share/mysql/test/suite/rpl/t/rpl_no_gtid_delete_memory_table_after_start_server.test
 share/mysql/test/suite/rpl/t/rpl_no_gtid_split_statements.test
+share/mysql/test/suite/rpl/t/rpl_no_gtid_truncate_memory_table_after_start_server.test
 share/mysql/test/suite/rpl/t/rpl_nogtid_rollback_on_anonymous_gtid.test
 share/mysql/test/suite/rpl/t/rpl_non_direct_mixed_mixing_engines.test
 share/mysql/test/suite/rpl/t/rpl_non_direct_row_mixing_engines.test


Home | Main Index | Thread Index | Old Index