Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2015-06-01 10:15:05
Message id: 20150601081505.CF96898@cvs.netbsd.org

Log Message:
Changes 5.6.25:
Functionality Added or Changed
* MySQL Enterprise Firewall operates on parser states and does not work well \ 
together with the query cache, which circumvents the parser. MySQL Enterprise \ 
Firewall now checks whether the query cache is enabled. If so, it displays a \ 
message that the query cache must be disabled and does not load.

* my_print_defaults now masks passwords. To display passwords in cleartext, use \ 
the new --show option.

* MySQL distributions now include an innodb_stress suite of test cases. Thanks \ 
to Mark Callaghan for the contribution.

Bugs Fixed
* InnoDB; Partitioning: The CREATE_TIME column of the INFORMATION_SCHEMA.TABLES \ 
table now shows the correct table creation time for partitioned InnoDB tables. \ 
The CREATE_TIME column of the INFORMATION_SCHEMA.PARTITIONS table now shows the \ 
correct partition creation time for a partition of partitioned InnoDB tables.

The UPDATE_TIME column of the INFORMATION_SCHEMA.TABLES table now shows when a \ 
partitioned InnoDB table was last updated by an INSERT, DELETE, or UPDATE. The \ 
UPDATE_TIME column of the INFORMATION_SCHEMA.PARTITIONS table now shows when a \ 
partition of a partitioned InnoDB table was last updated.

* InnoDB: An assertion was raised on shutdown due to XA PREPARE transactions \ 
holding explicit locks.

* InnoDB: The strict_* forms of innodb_checksum_algorithm settings (strict_none, \ 
strict_innodb, and strict_crc32) caused the server to halt when a non-matching \ 
checksum was encountered, even though the non-matching checksum was valid. For \ 
example, with innodb_checksum_algorithm=strict_crc32, encountering a valid \ 
innodb checksum caused the server to halt. Instead of halting the server, a \ 
message is now printed to the error log and the page is accepted as valid if it \ 
matches an innodb, crc32 or none checksum.

* InnoDB: The memcached set command permitted a negative expire time value. \ 
Expire time is stored internally as an unsigned integer. A negative value would \ 
be converted to a large number and accepted. The maximum expire time value is \ 
now restricted to INT_MAX32 to prevent negative expire time values.

* InnoDB: Removal of a foreign key object from the data dictionary cache during \ 
error handling caused the server to exit.

* InnoDB: SHOW ENGINE INNODB STATUS output showed negative reservation and \ 
signal count values due to a counter overflow error.

* InnoDB: Failure to check the status of a cursor transaction read-only option \ 
before reusing the cursor transaction for a write operation resulted in a server \ 
exit during a memcached workload.

* InnoDB: MDL locks taken by memcached clients caused a MySQL Enterprise Backup \ 
FLUSH TABLES WITH READ LOCK operation to hang.

* InnoDB: Estimates that were too low for the size of merge chunks in the result \ 
sorting algorithm caused a server exit.

* InnoDB: For full-text searches, the optimizer could choose an index that does \ 
not produce correct relevancy rankings.

* Partitioning: When creating a partitioned table, partition-level DATA \ 
DIRECTORY or INDEX DIRECTORY option values that contained an excessive number of \ 
characters were handled incorrectly.

* Partitioning: Executing an ALTER TABLE on a partitioned table on which a write \ 
lock was in effect could cause subsequent SQL statements on this table to fail.

* Replication: When binary logging was enabled, using stored functions and \ 
triggers resulting in a long running procedure that inserted many records caused \ 
the memory use to increase rapidly. This was due to memory being allocated per \ 
variable. The fix ensures that in such a situation, memory is allocated once and \ 
the same memory is reused.

* Replication: If an error was encountered while adding a GTID to the received \ 
GTID set, the log lock was not being correctly released. This could cause a \ 
deadlock.

more...

Files:
RevisionActionfile
1.23modifypkgsrc/databases/mysql56-client/Makefile.common
1.23modifypkgsrc/databases/mysql56-client/distinfo
1.17modifypkgsrc/databases/mysql56-server/PLIST
1.2removepkgsrc/databases/mysql56-client/patches/patch-vio_viossl.c