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_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
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 Log: 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 Changes: head/databases/mariadb105-client/pkg-plist head/databases/mariadb105-server/Makefile head/databases/mariadb105-server/distinfo head/databases/mariadb105-server/files/mysql-server.in head/databases/mariadb105-server/files/server.cnf.sample.in head/databases/mariadb105-server/pkg-plist
Hi VVD, Thanks for your time (and patience). If something's still amiss I'll be sure to hear from you! Cheers, Bernard.
(In reply to Bernard Spil from comment #2) Look correct. But didn't tested a lot.
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 Log: 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) Changes: _U branches/2020Q4/ branches/2020Q4/databases/mariadb105-client/pkg-plist branches/2020Q4/databases/mariadb105-server/Makefile branches/2020Q4/databases/mariadb105-server/distinfo branches/2020Q4/databases/mariadb105-server/files/mysql-server.in branches/2020Q4/databases/mariadb105-server/files/server.cnf.sample.in branches/2020Q4/databases/mariadb105-server/pkg-plist