- revert the permission change, we will revisit it at a later point
- we give the config files and directory the permissions
u=rwx,go=rx root:mysql, if we give the mysql group permissions we
should not need to leave the permissions open for others.
change permissions to u=rwx,g=rx,o=
- exclude galera files if we build without this feature.
- instead of setting the permissions in the files section inherit
what ever we set during installation. This simplifies the code
for the file section a lot. and we have a lot more flexiblity to
fix permissions in %install
- added fix-lock-rollback-assert-abort.patch
fix an abort when a transaction is rolled back
- track all patches in a series so we can easily set up a quilt
tree without requiring all the devel packages
OBS-URL: https://build.opensuse.org/request/show/866424
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=264
- 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
- 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
