Skip site navigation (1)Skip section navigation (2) 
Date:      Sat, 15 Aug 2020 22:28:55 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 248677] databases/mariadb105-{server,client}: update to 10.5.5 + optimization
Message-ID:  <bug-248677-7788@https.bugs.freebsd.org/bugzilla/>
next in thread | raw e-mail | index | archive | help 
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D248677

            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@FreeBSD.org
          Reporter: vvd@unislabs.com
                CC: brnrd@freebsd.org
 Attachment #217247 maintainer-approval?(brnrd@freebsd.org)
             Flags:
             Flags: maintainer-feedback?(brnrd@freebsd.org)

Created attachment 217247
  --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=3D217247&action=
=3Dedit
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=3D248160

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)=20

* InnoDB
    Fixed corruption in delete buffering (MDEV-22497)
    Fixed a deadlock in FLUSH TABLES=E2=80=A6FOR 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=3DOFF 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-230=
17,
MDEV-23369, MDEV-23410)
    Performance improvements (MDEV-22110, MDEV-22930, MDEV-23379, MDEV-2277=
8)
    Correctly implemented the scrubbing of freed pages (MDEV-8139)
    Crash recovery fixes (MDEV-21347, MDEV-23190, MDEV-11799)=20

* Replication
    Make the binlog dump thread to log into errorlog a requested GTID posit=
ion
(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 TAB=
LES
WITH READ LOCK (MDEV-23089)
    Correct master-slave automatic reconnection by slave to always pass thr=
ough
all steps of the initial connect. Specifically, do not skip master notifica=
tion
about slave binlog checksum awareness (MDEV-14203)
    Refine mysqlbinlog output to print out START TRANSACTION at Gtid_log_ev=
ent
processing which satisfies clients that submit the output with sql_mode=3Do=
racle
(MDEV-23108)
    Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ... SELE=
CT
in ORACLE mode (MDEV-19632)=20

* 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 ra=
nges
constructed while getting estimates from EITS (MDEV-22665)
    LATERAL DERIVED is not clearly visible in EXPLAIN FORMAT=3DJSON, make L=
ATERAL
DERIVED tables visible in EXPLAIN FORMAT=3DJSON 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)=20

* 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 =
=3D 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=3DINPLACE (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

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

Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-248677-7788>