Subject: CVS commit: [pkgsrc-2021Q1] pkgsrc/databases
From: Benny Siegert
Date: 2021-05-31 15:28:52
Message id: 20210531132852.C3A46FA95@cvs.NetBSD.org

Log Message:
Pullup ticket #6466 - requested by taca
databases/mysql57-client: security fix

Revisions pulled up:
- databases/mysql57-client/Makefile.common                      1.33-1.34
- databases/mysql57-client/PLIST                                1.21
- databases/mysql57-client/distinfo                             1.41-1.42
- \ 
databases/mysql57-client/patches/patch-cmake_build__configurations_compiler__options.cmake \ 
1.1
- databases/mysql57-client/patches/patch-mysys_kqueue__timers.c 1.2
- databases/mysql57-client/patches/patch-sql_locks_shared__spin__lock.cc 1.2
- databases/mysql57-server/PLIST                                1.21

---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Apr 21 13:26:55 UTC 2021

   Modified Files:
   	pkgsrc/databases/mysql57-client: Makefile.common PLIST distinfo
   	pkgsrc/databases/mysql57-client/patches: patch-mysys_kqueue__timers.c
   	    patch-sql_locks_shared__spin__lock.cc
   	pkgsrc/databases/mysql57-server: PLIST

   Log Message:
   mysql57: updated to 5.7.34

   Changes in MySQL 5.7.34 (2021-04-20, General Availability)

   Configuration Notes

   The CMAKE_BUILD_TYPE CMake option now supports a Release build type, which is \ 
like the RelWithDebInfo build type but omits debugging information to reduce the \ 
build size.

   Packaging Notes

   The bundled libedit library was upgraded to version 20190324-3.1.

   Binary packages that include curl rather than linking to the system curl \ 
library have been upgraded to use curl 7.74.0.

   Security Notes

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

   Functionality Added or Changed

   Microsoft Windows: The named_pipe_full_access_group system variable now \ 
defaults to an empty string (''), making named pipe connections secure. \ 
Previously, '*everyone*' was the default value. A valid Windows local group name \ 
may be substituted.

   Bugs Fixed

   InnoDB: The introduction of sharded rw_lock_stats counters in MySQL 5.7 \ 
caused a regression in CPU cache efficiency. To address this issue in MySQL 5.7, \ 
the sharding method was changed. For optimal performance, the rw_lock_stats \ 
counter is removed in MySQL 8.0.

   InnoDB: A delete operation on a parent table that initiated a cascading \ 
update on a child table with an indexed virtual column and indexed foreign key \ 
constraint column caused a virtual column corruption.

   InnoDB: An adaptive hash index (AHI) latch was held in shared mode by a \ 
thread truncating a large table, causing mutex waits for other threads. The AHI \ 
latch was not required and has been removed.

   InnoDB: The open and close sequence for table share instances (m_share \ 
objects) and dictionary table instances was modified to prevent accessing old \ 
m_share objects that could point to stale dictionary indexes.

   Thanks to Yuxiang Jiang for the contribution.

   InnoDB: An online ALTER TABLE operation failed with an “Incorrect key \ 
file for table” error due to an unnecessary encryption status check that \ 
was performed when reading online DDL row logs.

   Replication: If all previous binary log files were purged at startup because \ 
their retention period had expired, the new binary log file contained an empty \ 
Previous_gtids event, which could cause errors in replication. The order of \ 
initialization has now been changed so that previous binary log files are only \ 
purged after the previous GTID set has been written to the new binary log file \ 
that is created at startup.

   Replication: An assertion was raised in debug builds relating to lost GTIDs \ 
if binary log files were removed at startup because their retention period had \ 
expired.

   Replication: A deadlock could occur if the binary log file was rotated while \ 
system variables were being updated and read by different clients.

   Replication: The output of a SHOW PROCESSLIST statement for a \ 
replica’s SQL thread sometimes showed the last query as currently being \ 
applied when the replica was actually caught up.

   A query string was displayed before it had been rewritten.

   For builds compiled using the libedit library, if the mysql client was \ 
invoked with the --default-character-set=utf8 option, libedit rejected input of \ 
multibyte characters.

   On Windows, large result sets could cause the mysql client to exit unexpectedly.

   Improper locking on an internal queue could cause mysqlpump to exit unexpectedly.

   It is now possible to use START REPLICA SQL_THREAD and STOP REPLICA \ 
SQL_THREAD statements for the group_replication_applier channel when Group \ 
Replication is stopped. This enables an operator to apply any remaining \ 
unapplied transactions on a server that left the group, without having to rejoin \ 
the server to the group.

   When the mysql client was used in batch mode, its parser could be confused by \ 
USE followed by DROP DATABASE when the USE database name was quoted.

   While optimizing the ORDER BY clause of a subquery there was a possibility of \ 
cleaning up a subquery tree referenced in the outer SELECT, which could lead to \ 
a premature exit.

   A malformed name in the mysql.func system table could cause unexpected server \ 
behavior.

   Sessions could disable their own auditing.

   Mishandling of stored program local variables could lead to unexpected server \ 
behavior.

   Uninstalling a plugin could affect subsequent execution of prepared statements.

---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Thu Apr 29 16:50:33 UTC 2021

   Modified Files:
   	pkgsrc/databases/mysql57-client: Makefile.common distinfo
   Added Files:
   	pkgsrc/databases/mysql57-client/patches:
   	    patch-cmake_build__configurations_compiler__options.cmake

   Log Message:
   mysql57: fix building with GCC

Files:
RevisionActionfile
1.32.2.1modifypkgsrc/databases/mysql57-client/Makefile.common
1.20.2.1modifypkgsrc/databases/mysql57-client/PLIST
1.40.2.1modifypkgsrc/databases/mysql57-client/distinfo
1.1.38.1modifypkgsrc/databases/mysql57-client/patches/patch-mysys_kqueue__timers.c
1.1.2.1modifypkgsrc/databases/mysql57-client/patches/patch-sql_locks_shared__spin__lock.cc
1.20.2.1modifypkgsrc/databases/mysql57-server/PLIST
1.1.2.2addpkgsrc/databases/mysql57-client/patches/patch-cmake_build__configurations_compiler__options.cmake