- update to 10.3.20
* notable changes for 10.3.20
* MDEV-20987: InnoDB fails to start when FTS table has FK relation
* notable changes for 10.3.19
* MDEV-20864: Debug-only option innodb_change_buffer_dump for
dumping the contents of the InnoDB change buffer to the
server error log at startup.
* MariaBackup:
* MDEV-18438: mbstream recreates xtrabackup_info on same
directory as backup file
* MDEV-20703: mariabackup creates binlog files in serve
binlog directory on --prepare --export step
* FULLTEXT INDEX:
* MDEV-19647: Server hangs after dropping full text indexes
and restart
* MDEV-19529: InnoDB hang on DROP FULLTEXT INDEX
* MDEV-19073: FTS row mismatch after crash recovery
* MDEV-20621: FULLTEXT INDEX activity causes InnoDB hang
* MDEV-20927: Duplicate key with auto increment
* ALTER TABLE:
* MDEV-20799: DROP Virtual Column crash
* MDEV-20852: BtrBulk is unnecessarily holding dict_index_t::lock
* System-Versioned Tables:
* MDEV-16210: FK constraints on versioned tables use historical
rows, which may cause constraint violation
* MDEV-20812: Unexpected ER_ROW_IS_REFERENCED_2 or server
crash in row_ins_foreign_report_err upon DELETE from
versioned table with FK
* Galera wsrep library updated to 25.3.28
* Fixes for the following security vulnerabilities:
OBS-URL: https://build.opensuse.org/request/show/747661
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=239
- update to 10.3.18
* notable changes
* Connect updated to Connect 1.06.0010
* MDEV-20066: This bug could cause a table to become corrupt if
a column was added instantly
* MDEV-15326: A race condition in InnoDB transaction commit that
affects record locking was fixed
* MDEV-17187: Table doesn't exist in engine after ALTER of
FOREIGN KEY
* MDEV-20301: InnoDB's MVCC has O(N^2) behaviors
* MDEV-18128: Simplify .ibd file creation
* MDEV-20060: Failing assertion: srv_log_file_size <= 512ULL
<< 30 while preparing backup
* MDEV-20247: Replication hangs with "preparing" and never starts
* MDEV-17614: Remove unnecessary locking for INSERT...ON
DUPLICATE KEY UPDATE
* MDEV-20311: row_ins_step accesses uninitialized memory
* MDEV-19947: Repositories for RHEL 8 ppc64le added
* fixes for the following security vulnerabilities: none
* release notes and changelog:
https://mariadb.com/kb/en/library/mariadb-10318-release-noteshttps://mariadb.com/kb/en/library/mariadb-10318-changelog
OBS-URL: https://build.opensuse.org/request/show/733168
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=238
- remove sql_mode from my.ini/my.cnf as NO_ENGINE_SUBSTITUTION and
STRICT_TRANS_TABLES are already set by default from version
10.2.4 [bsc#1144314]
- add mariadb-10.3.17-fix_ppc_build.patch to fix a compilation
failure for ppc if ${CRC32_LIBRARY} target has no COMPILE_FLAGS
yet. Then GET_TARGET_PROPERTY returns COMPILE_FLAGS-NOTFOUND,
which doesn't work very well when it's later fed back into
COMPILE_FLAGS.
- _constraints: increase the memory because of the ppc build
- adjust mysql-systemd-helper ("shutdown protected MySQL" section)
so it checks both ping response and the pid in a process list
as it can take some time till the process is terminated.
Otherwise it can lead to "found left-over process" situation
when regular mariadb is started [bsc#1143215]
OBS-URL: https://build.opensuse.org/request/show/721764
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=236
- update to 10.3.16 [bsc#1108088]
* notable changes:
* MDEV-19490: show tables fails when selecting the
information_schema database
* MDEV-19491: multi-update with triggers and stored routines
* MDEV-19541: InnoDB crashes when trying to recover
a corrupted page
* MDEV-19725: Incorrect error handling in ALTER TABLE
* MDEV-19445: FULLTEXT INDEX fix
* MDEV-19486: System Versioning fix
* MDEV-19509: InnoDB skips the tablespace in rotation list
* MDEV-19614: SET GLOBAL innodb_ deadlock due to
LOCK_global_system_variables
* MDEV-17458: Unable to start galera node
* MDEV-17456: Malicious SUPER user can possibly change audit
log configuration without leaving traces
* MDEV-19588: Wrong results from query, using left join
* MDEV-19258: RIGHT JOIN hangs in MariaDB
* Virtual columns fixes: MDEV-19027, MDEV-19602
* Crash recovery fixes: MDEV-13080, MDEV-19587, MDEV-19435
* MDEV-11094: Fixed row-based event applying with an error anymore
when the events aim at the blackhole engine and row annotation
is enabled
* MDEV-19076: Fixed slave_parallel_mode=optimistic did not always
properly order replication events on temporary tables in some
case to attempt execution before a parent event has been already
processed
* MDEV-19158: Fixed duplicated entries in binlog occurred in
combination of LOCK TABLES and binlog_format=MIXED when a being
locked table was under replication unsafe operation
OBS-URL: https://build.opensuse.org/request/show/717132
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=231
- update to 10.2.24 GA [bsc#1122198]
* notable changes:
* MDEV-18968 - Both (WHERE 0.1) and (WHERE NOT 0.1) return empty set
* MDEV-18466 - Unsafe to log updates on tables referenced by
foreign keys with triggers in statement format
* MDEV-18899 - Server crashes in Field::set_warning_truncated_wrong_value
* MDEV-18298 - Crashes server with segfault during role grants
* MDEV-17610 - Unexpected connection abort after certain operations
from within stored procedure
* MDEV-19112 - WITH clause does not work with information_schema
as default database
* MDEV-17830 - Server crashes in Item_null_result::field_type upon
SELECT with CHARSET(date) and ROLLUP
* MDEV-14041 - Server crashes in String::length on queries with
functions and ROLLUP
* MDEV-18920 - Prepared statements with st_convexhull hang and
eat 100% cpu.
* MDEV-15837 - Assertion item1->type() == Item::FIELD_ITEM &&
item2->type() == Item::FIELD_ITEM
* MDEV-9531 - GROUP_CONCAT with ORDER BY inside takes a lot of
memory while it's executed
* MDEV-17036 - BULK with replace doesn't take the first parameter
in account
* Bug#28986737 - RENAMING AND REPLACING MYSQL.USER TABLE CAN
LEAD TO A SERVER CRASH
* MDEV-19350 - Server crashes in delete_tree_element / ... /
Item_func_group_concat::repack_tree
* MDEV-19188 - Server Crash When Using a Trigger With A Number
of Virtual Columns on INSERT/UPDATE
* MDEV-19352 - Server crash in alloc_histograms_for_table_share
OBS-URL: https://build.opensuse.org/request/show/703404
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=230
