Bug 248677 - databases/mariadb105-{server,client}: update to 10.5.5 + optimization
Summary: databases/mariadb105-{server,client}: update to 10.5.5 + optimization
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Many People
Assignee: Bernard Spil
URL: https://mariadb.com/kb/en/mariadb-105...
Depends on:
Reported: 2020-08-15 22:28 UTC by VVD
Modified: 2020-11-12 17:23 UTC (History)
1 user (show)

See Also:
vvd: maintainer-feedback? (brnrd)

update to 10.5.5 + optimization (12.88 KB, patch)
2020-08-15 22:28 UTC, VVD
vvd: maintainer-approval? (brnrd)
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description VVD 2020-08-15 22:28:55 UTC
Created attachment 217247 [details]
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_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)
    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
Comment 1 commit-hook freebsd_committer 2020-11-08 19:03:25 UTC
A commit references this bug:

Author: brnrd
Date: Sun Nov  8 19:02:31 UTC 2020
New revision: 554643
URL: https://svnweb.freebsd.org/changeset/ports/554643

  databases/mariadb105-server: Security update to 10.5.7

   * Cleanup/polish PLIST_SUB and SUB_LIST [1]

  PR:		248677 [1]
  MFH:		2020Q4
  Security:	4fba07ca-13aa-11eb-b31e-d4c9ef517024

Comment 2 Bernard Spil freebsd_committer 2020-11-08 19:09:37 UTC

Thanks for your time (and patience). If something's still amiss I'll be sure to hear from you!

Cheers, Bernard.
Comment 3 VVD 2020-11-08 23:57:24 UTC
(In reply to Bernard Spil from comment #2)
Look correct. But didn't tested a lot.
Comment 4 commit-hook freebsd_committer 2020-11-12 17:23:43 UTC
A commit references this bug:

Author: brnrd
Date: Thu Nov 12 17:23:21 UTC 2020
New revision: 554978
URL: https://svnweb.freebsd.org/changeset/ports/554978

  MFH: r554643 r554954

  databases/mariadb105-server: Security update to 10.5.7

   * Cleanup/polish PLIST_SUB and SUB_LIST [1]

  PR:		248677 [1]
  Security:	4fba07ca-13aa-11eb-b31e-d4c9ef517024

  databases/mariadb105-server: Bugfix update to 10.5.8

   * Arbitrary InnoDB buffer pool and data file corruption

  Approved by:	ports-secteam (joneum, fluffy)

_U  branches/2020Q4/