[Bug 248677] databases/mariadb105-{server,client}: update to 10.5.5 + optimization

Sat Aug 15 22:28:56 UTC 2020

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=248677

            Bug ID: 248677
           Summary: databases/mariadb105-{server,client}: update to 10.5.5
                    + optimization
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
               URL: https://mariadb.com/kb/en/mariadb-1055-release-notes/
                OS: Any
            Status: New
          Severity: Affects Many People
          Priority: ---
         Component: Individual Port(s)
          Assignee: ports-bugs at FreeBSD.org
          Reporter: vvd at unislabs.com
                CC: brnrd at freebsd.org
 Attachment #217247 maintainer-approval?(brnrd at freebsd.org)
             Flags:
             Flags: maintainer-feedback?(brnrd at freebsd.org)

Created attachment 217247
  --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=217247&action=edit
update to 10.5.5 + optimization

Tested on 11.4 and 12.1 amd64: make check-plist/install, run (clean install
too).

Fixed this issue: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=248160

Release Notes: https://mariadb.com/kb/en/mariadb-1055-release-notes/
Changelog: https://mariadb.com/kb/en/mariadb-1055-changelog/

Notable Changes

* Deprecated variables
    innodb_thread_concurrency
    innodb_commit_concurrency
    innodb_replication_delay
    innodb_concurrency_tickets
    innodb_thread_sleep_delay
    innodb_adaptive_max_sleep_delay (MDEV-23379) 

* InnoDB
    Fixed corruption in delete buffering (MDEV-22497)
    Fixed a deadlock in FLUSH TABLES…FOR EXPORT (MDEV-22890)
    InnoDB data file extension is not crash-safe (MDEV-23190)
    Minor fixes related to encryption and FULLTEXT INDEX
    Dropping the adaptive hash index may cause DDL to lock up InnoDB
(MDEV-22456)
    innodb_log_optimize_ddl=OFF is not crash safe (MDEV-21347)
    Mariadb service won't shutdown when it's running and the OS datetime
updated backwards (MDEV-17481)
    Doublewrite recovery can corrupt data pages (MDEV-11799)
    Fixed race conditions related to buffer pool resizing
    ALTER TABLE fixes (MDEV-22637, MDEV-23244, MDEV-22988, MDEV-23295,
MDEV-22771, MDEV-22811, MDEV-22899)
    Slow InnoDB shutdown on large instance (MDEV-22778)
    Fixes to performance regressions introduced in MariaDB 10.5.4 (MDEV-23017,
MDEV-23369, MDEV-23410)
    Performance improvements (MDEV-22110, MDEV-22930, MDEV-23379, MDEV-22778)
    Correctly implemented the scrubbing of freed pages (MDEV-8139)
    Crash recovery fixes (MDEV-21347, MDEV-23190, MDEV-11799) 

* Replication
    Make the binlog dump thread to log into errorlog a requested GTID position
(MDEV-20428)
    Fix stop of the optimistic parallel slave at requested START-SLAVE-UNTIL
position (MDEV-15152)
    Properly handle RESET MASTER TO value, when the value exceeds the max
allowed 2147483647 (MDEV-22451)
    Correct 'relay-log.info' updating by concurrent parallel workers
(MDEV-22806)
    Eliminate deadlock involving parallel workers, STOP SLAVE and FLUSH TABLES
WITH READ LOCK (MDEV-23089)
    Correct master-slave automatic reconnection by slave to always pass through
all steps of the initial connect. Specifically, do not skip master notification
about slave binlog checksum awareness (MDEV-14203)
    Refine mysqlbinlog output to print out START TRANSACTION at Gtid_log_event
processing which satisfies clients that submit the output with sql_mode=oracle
(MDEV-23108)
    Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ... SELECT
in ORACLE mode (MDEV-19632) 

* Optimizer
    ALTER TABLE ... ANALYZE PARTITION ... with EITS reads and locks all rows
... (MDEV-21472)
    Print ranges in the optimizer trace created for non-indexed columns when
optimizer_use_condition_selectivity >2 Now the optimizer trace shows the ranges
constructed while getting estimates from EITS (MDEV-22665)
    LATERAL DERIVED is not clearly visible in EXPLAIN FORMAT=JSON, make LATERAL
DERIVED tables visible in EXPLAIN FORMAT=JSON output (MDEV-17568)
    Crash on WITH RECURSIVE large query (MDEV-22748)
    Crash with Prepared Statement with a '?' parameter inside a re-used CTE
(MDEV-22779) 

* Other
    MariaDB could crash after changing the query_cache size (MDEV-5924)
    Errors and SIGSEGV on CREATE TABLE w/ various charsets (MDEV-22111)
    Crash in CREATE TABLE AS SELECT when the precision of returning type = 0
(MDEV-22502)
    XA: Reject DDL operations between PREPARE and COMMIT (MDEV-22420)
    Stop mariabackup --prepare on errors during innodb redo log applying
(MDEV-22354)
    Server crashes in mysql_alter_table upon adding a non-null date column
under NO_ZERO_DATE with ALGORITHM=INPLACE (MDEV-18042)
    Can't uninstall plugin if the library file doesn't exist (MDEV-21258)
    Mariabackup parameter cleanup (MDEV-18215, MDEV-21298, MDEV-21301,
MDEV-22894)
    Rounding functions return wrong datatype (MDEV-23366, MDEV-23367,
MDEV-23368, MDEV-23350, MDEV-23351, MDEV-23337, MDEV-23323)
    Create mariadb.sys user on each update even is the user is not needed
(MDEV-23102)
    INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION required SUPER instead
PROCESS privilege (MDEV-23003)
    Reinforce DDL operation rejection after XA PREPARE (MDEV-22420)
    As per the MariaDB Deprecation Policy, this will be the last release of
MariaDB 10.5 for Ubuntu 19.10 Eoan and Fedora 30

-- 
You are receiving this mail because:
You are the assignee for the bug.