- 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
- Using basic.target dependencies is not needed with any systemd
release unless DefaultDependencies is disabled, remove from
unit files
- Mariadb uses hrtimers with absolute CLOCK_REALTIME values, this
won't work correctly if the clock isn't set and will do funny things
if it goes backward after starting the server as POSIX says that the new
clock value shall influence them, start the service after time-sync.target
to workaround the problem.
OBS-URL: https://build.opensuse.org/request/show/831240
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=259
- 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
