Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2020-03-17 19:59:16
Message id: 20200317185916.BAB12FB27@cvs.NetBSD.org

Log Message:
mysql56: updated to 5.6.47

Changes in MySQL 5.6.47:

Bugs Fixed

Replication: When GTIDs are enabled on a replication master and slave, and the \ 
slave connects to the master with the MASTER_AUTO_POSITION=1 option set, the \ 
master must send the slave all the transactions that the slave has not already \ 
received, committed, or both. If any of the transactions that should be sent by \ 
the master have been already purged from the master's binary log, the master \ 
sends the error ER_MASTER_HAS_PURGED_REQUIRED_GTIDS (1789) to the slave, and \ 
replication does not start.

The message provided for the error ER_MASTER_HAS_PURGED_REQUIRED_GTIDS has been \ 
changed to provide advice on the correct action in this situation, which is for \ 
the slave to replicate the missing transactions from another source, or for the \ 
slave to be replaced by a new slave created from a more recent backup. The \ 
message advises that the master's binary log expiration period can be revised to \ 
avoid the situation in future. In addition, the master now identifies the GTIDs \ 
of the purged transactions and supplies them in its error log in the warning \ 
message ER_FOUND_MISSING_GTIDS (11809), so that you do not need to calculate the \ 
missing GTIDs manually.

With multiple sessions executing concurrent INSERT ... ON DUPLICATE KEY UPDATE \ 
statements into a table with an AUTO_INCREMENT column but not specifying the \ 
AUTO_INCREMENT value, inserts could fail with a unique index violation.

A SELECT using a WHERE condition of the form A AND (B OR C [OR ...]) resulting \ 
in an impossible range led to an unplanned exit of the server.

An incomplete connection packet could cause clients not to properly initialize \ 
the authentication plugin name.

Files:
RevisionActionfile
1.35modifypkgsrc/databases/mysql56-client/Makefile
1.54modifypkgsrc/databases/mysql56-client/Makefile.common
1.55modifypkgsrc/databases/mysql56-client/distinfo
1.43modifypkgsrc/databases/mysql56-server/Makefile
1.36modifypkgsrc/databases/mysql56-server/PLIST