- 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
- update to 10.2.21 GA
* notable changes:
* MDEV-17589 - Stack-buffer-overflow with indexed varchar
(utf8) field
* MDEV-16987 - ALTER DATABASE possible in read-only mode
(forbid ALTER DATABASE in read_only)
* MDEV-17720 - slave_ddl_exec_mode=IDEMPOTENT does not handle
DROP DATABASE
* MDEV-6453 - Assertion `inited==NONE || (inited==RND && scan)'
failed in handler::ha_rnd_init(bool) with InnoDB, joins,
AND/OR conditions
* MDEV-18105 - Mariabackup fails to copy encrypted InnoDB
system tablespace if LSN>4G
* MDEV-18041 - Database corruption after renaming a
prefix-indexed column [bsc#1120041]
* MDEV-17470 - Orphan temporary files after interrupted ALTER
cause InnoDB: Operating system error number 17 and eventual
fatal error 71
* MDEV-17833: ALTER TABLE is not enforcing prefix index size
limit
* MDEV-17989: InnoDB: Failing assertion:
dict_tf2_is_valid(flags, flags2)
* MDEV-17765: Locking bug fix for SPATIAL INDEX
* MDEV-17923, MDEV-17904, MDEV-17938: Fixes for FULLTEXT INDEX
* Fixes for regressions introduced in MariaDB Server 10.2.19 by
the backup-safe TRUNCATE TABLE (MDEV-13564,
innodb_safe_truncate=ON) and innodb_undo_log_truncate:
* MDEV-17780, MDEV-17816, MDEV-17849, MDEV-17851, MDEV-17885
* Several improvements to MariaDB Server and backup for dealing
with encrypted or page_compressed pages:
OBS-URL: https://build.opensuse.org/request/show/664425
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=222
- update to 10.2.19 GA [bsc#1116686]
* notable changes:
* innodb_safe_truncate system variable for a backup-safe
TRUNCATE TABLE implementation that is based on RENAME,
CREATE, DROP (MDEV-14717, MDEV-14585, MDEV-13564). Default
value for this variable is ON. If you absolutely must use
XtraBackup instead of Mariabackup, you can set it to OFF and
restart the server
* MDEV-17289: Multi-pass recovery fails to apply some redo
log records
* MDEV-17073: INSERT…ON DUPLICATE KEY UPDATE became more
deadlock-prone
* MDEV-17491: micro optimize page_id_t
* MDEV-13671: InnoDB should use case-insensitive column name
comparisons like the rest of the server
* Fixes for indexed virtual columns: MDEV-17215, MDEV-16980
* MDEV-17433: Allow InnoDB start up with empty ib_logfile0
from mariabackup --prepare
* MDEV-12547: InnoDB FULLTEXT index has too strict
innodb_ft_result_cache_limit max limit
* MDEV-17541: KILL QUERY during lock wait in FOREIGN KEY
check causes hang
* MDEV-17531: Crash in RENAME TABLE with FOREIGN KEY and
FULLTEXT INDEX
* MDEV-17532: Performance_schema reports wrong directory for
the temporary files of ALTER TABLE…ALGORITHM=INPLACE
* MDEV-17545: Predicate lock for SPATIAL INDEX should lock
non-matching record
* MDEV-17546: SPATIAL INDEX should not be allowed for
FOREIGN KEY
OBS-URL: https://build.opensuse.org/request/show/651379
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=219
- update to 10.2.18 GA
* notable changes:
* MDEV-15511 - if available, stunnel can be used during Galera
rsync SST
* MDEV-16791 - mariabackup: Support DDL commands during backup
* MDEV-13564 - Refuse MLOG_TRUNCATE in mariabackup
* MDEV-16934 - add new system variable eq_range_index_dive_limit
to speed up queries that new long nested IN lists. The default
value, for backward compatibility, is 0 meaning "unlimited".
* MDEV-13333 - errors on InnoDB lock conflict
* Report all InnoDB redo log corruption
* MDEV-17043 - Purge of indexed virtual columns may cause hang
on table-rebuilding DDL
* MDEV-16868 - corruption of InnoDB temporary tables
* MDEV-16465 - Invalid (old?) table or database name or hang
in ha_innobase::delete_table and log semaphore wait upon
concurrent DDL with foreign keys
* fixes for the following security vulnerabilities: none
* release notes and changelog:
https://mariadb.com/kb/en/library/mariadb-10218-release-noteshttps://mariadb.com/kb/en/library/mariadb-10218-changelog
- refresh mariadb-10.2.4-fortify-and-O.patch
OBS-URL: https://build.opensuse.org/request/show/638722
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=218
- update to 10.2.17 GA
* notable changes:
* New variable innodb_log_optimize_ddl for avoiding delay due
to page flushing and allowing concurrent backup
* InnoDB updated to 5.7.23
* MDEV-14637 - Fix hang due to DDL with FOREIGN KEY or
persistent statistics
* MDEV-15953 - Alter InnoDB Partitioned Table Moves Files
(which were originally not in the datadir) to the datadir
* MDEV-16515 - InnoDB: Failing assertion: ++retries < 10000 in
file dict0dict.cc line 2737
* MDEV-16809 - Allow full redo logging for ALTER TABLE
* Temporary tables: MDEV-16713 - InnoDB hang with repeating
log entry
* indexed virtual columns: MDEV-15855 - Deadlock between purge
thread and DDL statement
* MDEV-16664 - Change the default to
innodb_lock_schedule_algorithm=fcfs
* Galera: MDEV-15822 - WSREP: BF lock wait long for trx
* fixes for the following security vulnerabilities:
CVE-2018-3064 [bsc#1103342], CVE-2018-3063 [bsc#1101677],
CVE-2018-3058 [bsc#1101676], CVE-2018-3066 [bsc#1101678],
CVE-2018-3060
* release notes and changelog:
https://mariadb.com/kb/en/library/mariadb-10217-release-noteshttps://mariadb.com/kb/en/library/mariadb-10217-changelog
OBS-URL: https://build.opensuse.org/request/show/632041
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=216
- update to 10.2.16 GA
* notable changes:
* MDEV-13122: mariabackup now supports MyRocks
* MDEV-13779 - InnoDB fails to shut down purge workers, causing
hang
* MDEV-16267 - Wrong INFORMATION_SCHEMA.INNODB_BUFFER_PAGE.\
TABLE_NAME
* MDEV-13834 - Upgrade failure from 10.1 innodb_encrypt_log
* MDEV-16283 - ALTER TABLE...DISCARD TABLESPACE still takes long
on a large buffer pool
* MDEV-16376 - ASAN: heap-use-after-free in
gcol.innodb_virtual_debug
* MDEV-15824 - innodb_defragment=ON trumps
innodb_optimize_fulltext_only=ON in OPTIMIZE TABLE
* MDEV-16124 - fil_rename_tablespace() times out and crashes
server during table-rebuilding ALTER TABLE
* MDEV-16416 - Crash on IMPORT TABLESPACE of a
ROW_FORMAT=COMPRESSED table
* MDEV-16456 - InnoDB error "returned OS error 71" complains
about wrong path
* MDEV-13103 - Deal with page_compressed page corruption
* MDEV-16496 - Mariabackup: Implement --verbose option to
instrument InnoDB log apply
* MDEV-16087 - Inconsistent SELECT results when query cache
is enabled
* MDEV-15114 - ASAN heap-use-after-free in mem_heap_dup or
dfield_data_is_binary_equal (fix for indexed virtual columns)
* fixes for the following security vulnerabilities:
none
* release notes and changelog:
OBS-URL: https://build.opensuse.org/request/show/624013
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=214
- update to 10.2.14 GA
* notable changes:
* MyRocks is now Gamma (RC)
* MDEV-14533 - Added the DISKS plugin, for monitoring disk
space
* MDEV-14611 - ALTER TABLE EXCHANGE PARTITION does not work
properly when used with DATA DIRECTORY.
* MDEV-15333 - MariaDB (still) slow start
* MDEV-12255 - Wrong result with
innodb_prefix_index_cluster_optimization
* MDEV-12396 - IMPORT TABLESPACE cleanup
* MDEV-14648 - Restore fix for MySQL BUG#39053 - UNINSTALL
PLUGIN does not allow the storage engine to cleanup open
connections
* MDEV-15249 - IMPORT fixes
* MDEV-14988 - innodb_read_only tries to modify files if
transactions were recovered in COMMITTED state
* MDEV-14773 - DROP TABLE hangs for InnoDB table with FULLTEXT
index (fixing a recent regression from upstream)
* MDEV-15529 - IMPORT TABLESPACE unnecessarily uses the
doublewrite buffer
* MDEV-15554 - InnoDB page_cleaner shutdown sometimes hangs
* MDEV-14545 - Mariabackup - Backup fails due to
MLOG_INDEX_LOAD record
* fixes for the following security vulnerabilities: none
* release notes and changelog:
https://mariadb.com/kb/en/library/mariadb-10214-release-noteshttps://mariadb.com/kb/en/library/mariadb-10214-changelog
- remove the following patches
* mariadb-10.2.14-xtrabackup-v2.patch (applied upstream,
OBS-URL: https://build.opensuse.org/request/show/602556
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=211
- update to 10.2.13 GA
* notable changes
* InnoDB updated to 5.7.21
* Galera wsrep library updated to 25.3.23
* MDEV-13869 - MariaDB slow start
* MDEV-14611 - ALTER TABLE EXCHANGE PARTITION does not work
properly when used with DATA DIRECTORY
* MDEV-15249 - Crash in MVCC read after IMPORT TABLESPACE
* Foreign key bugs:
* MDEV-15199 - Referential integrity broken in ON DELETE
CASCADE/MDEV-14222 Unnecessary 'cascade' memory allocation
for every updated row
* MDEV-15219 - FOREIGN KEY CASCADE or SET NULL operations will
not resume after lock wait
* MDEV-15042 - INSERT ON DUPLICATE KEY UPDATE produces error
1032 (Can't find record)
* MDEV-13205 - InnoDB: Failing assertion:
!dict_index_is_online_ddl(index) upon ALTER TABLE
* MDEV-14958 - Merge new release of InnoDB MySQL 5.7.21 to 10.2
* MDEV-15165 - InnoDB purge for index on virtual column is
trying to access an incomplete record
* MDEV-15143 - InnoDB: Rollback of trx with id 0 completed
* MDEV-11415 - Remove excessive undo logging during ALTER
TABLE…ALGORITHM=COPY
* MDEV-15016 - multiple page cleaner threads use a lot of CPU
* MDEV-14941 - Timeouts on persistent statistics tables caused
by MDEV-14511
* MDEV-14985 - innodb_undo_log_truncate may be blocked if
transactions were recovered at startup
* MDEV-14441 - InnoDB hangs when setting
OBS-URL: https://build.opensuse.org/request/show/579672
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=207
