MariaDB 10.2.28 Changelog

The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

After an upgrade MariaDB Server can crash if InnoDB tables exist with a FULLTEXT INDEX and a FOREIGN KEY constraint attached to them. We got reports that the crash already will be encountered on startup, but a crash is also possible at a later stage. See MDEV-20987 for more details.Do not download or use this release.

DownloadRelease NotesChangelogOverview of 10.2

Alternate download from mariadb.org

Release date: 5 Nov 2019

For the highlights of this release, see therelease notes.

The revision number links will take you to the revision's page on GitHub. OnGitHub you can view more details of the revision and view diffs of the code modified in that revision.

• Includes all fixes from MariaDB 10.1.42

• Revision #1552b254a0 2019-10-31 20:42:08 +0200

  • List of unstable tests for 10.2.28 release

• Merge Revision #259edb1f60 2019-10-31 09:07:26 +0100 - Merge branch '10.1' into 10.2

• Revision #2ba9a269df 2019-10-31 06:13:38 +0100

  • new CC 3.1 due to typo in it

• Merge Revision #fd6dfb3b54 2019-10-30 23:38:05 +0100 - Merge branch 'github/10.1' into 10.2

• Merge Revision #6680b04961 2019-10-30 21:56:35 +0100 - Merge remote-tracking branch 'connect/10.2' into 10.2

• Revision #a00b713130 2019-10-16 22:12:47 +0200

  • Fix wrong second parameter in snprintf

• Revision #b56589eaf2 2019-10-16 17:40:49 +0200

  • Fix unhandled throws, add some trace + typo

• Revision #425dc6d66f 2019-09-10 15:57:48 +0200

  • Remove some incorrect compile flags Just keep the /MDd flag but only for Windows Debug REST compile

• Revision #baaf02a48b 2019-10-30 21:37:46 +0100

  • new CC 3.1

• Merge Revision #36f67a7dff 2019-10-30 21:33:01 +0100 - Merge branch '10.1' into 10.2

• Revision #cd1c10859d 2019-10-29 13:13:31 +0200

  • Fix test cases that use debug galera library.

• Revision #36a9694378 2019-10-29 13:11:34 +0200

  • MDEV-18562 - InnoDB: WSREP: referenced FK check fail: Lock wait index

• Revision #44b0c86971 2019-10-30 06:42:51 +0200

  • Clean up ut_strlcpy(), ut_strlcpy_rev()

• Revision #814534745b 2019-10-29 17:11:34 +0200

  • MDEV-20917 InnoDB is passing NULL to nonnull function parameters

• Revision #2d82ae5ba3 2019-10-28 17:01:32 +0000

  • MDEV-20825 : Innodb does not start if GetDiskFreeSpace() fails.

• Revision #c13519312b 2019-10-25 17:17:32 +0200

  • MDEV-20799 DROP Virtual Column crashes MariaDB

• Revision #8bb6b9c634 2019-09-18 14:00:32 +0200

  • gis2 test no longer exists after 3fe38574fbdd

• Revision #c075c7a861 2019-09-10 17:31:10 +0200

  • MDEV-20549 SQL SECURITY DEFINER does not work for INFORMATION_SCHEMA tables

• Revision #be780c0555 2019-09-10 19:15:32 +0200

  • fix CONNECT engine to issue the correct error message

• Revision #42ada91542 2019-09-10 17:24:34 +0200

  • cleanup: RAII helper for swapping of thd->security_ctx

• Merge Revision #d752a97ebb 2019-10-25 17:33:39 +0300 - Merge 10.1 to 10.2

• Merge Revision #19ceaf2928 2019-10-25 12:57:36 +0300 - Merge 10.1 into 10.2

• Revision #7457181ba4 2019-10-24 21:20:53 +0300

  • Clean up innodb.innodb_stats_persistent

• Revision #2809842031 2019-10-19 15:16:47 +0300

  • MDEV-20864 Introduce debug option innodb_change_buffer_dump

• Revision #fa929f7cdf 2019-10-17 17:12:23 +0300

  • Simplify row_undo_ins_remove_sec_low()

• Merge Revision #b027830232 2019-10-17 17:08:58 +0300 - MDEV-20850 Merge new release of InnoDB 5.7.28 to 10.2

• Revision #fa32d28f2f 2019-10-17 13:58:04 +0300

  • MDEV-20852 BtrBulk is unnecessarily holding dict_index_t::lock

• Revision #3ce14a66ef 2019-10-16 18:40:31 +0300

  • Fixed bug in lock tables + alter table with Aria tables.

• Revision #7952f7720f 2019-10-15 20:26:40 +0300

  • MDEV-10748 Server crashes in ha_maria::implicit_commit

• Revision #4d14785546 2019-10-09 03:09:48 +0300

  • MDEV-20778 UBSAN: call to function free_rpl_filter() through pointer to incorrect function type

• Revision #f989c0ce66 2019-10-14 17:26:21 +0300

  • MDEV-20813: Do not rotate keys for unallocated pages

• Merge Revision #4f9f3f19cd 2019-10-14 16:53:57 +0300 - Merge 10.1 into 10.2

• Revision #361e8284f3 2019-10-12 15:28:55 +0300

  • MDEV-20813 Assertion failure in buf_flush_init_for_writing() for innodb_immediate_scrub_data_uncompressed=ON

• Merge Revision #2227dec45e 2019-10-12 06:10:41 +0300 - Merge 10.1 into 10.2

• Revision #4ca0abe964 2019-10-07 12:34:08 +0200

  • MDEV-20728: /usr/sbin/mysqld: unknown variable 'defaults-group-suffix=mysqld1

• Revision #38736928e7 2019-10-11 21:26:16 +0300

  • Fix -std=c++98 -Wzero-length-array

• Revision #1e1b53ccfd 2019-10-11 21:24:48 +0300

  • After-merge fix: Correct an assertion

• Merge Revision #966d97b5f9 2019-10-11 18:38:18 +0300 - Merge 10.1 into 10.2

• Revision #1fd1ef25c2 2019-10-11 18:36:08 +0300

  • Fix CMAKE_BUILD_TYPE=Debug

• Revision #350e46a8b5 2019-07-30 22:39:55 +1000

  • MDEV-18546 ASAN heap-use-after-free in innobase_get_computed_value / row_purge

• Revision #b393e2cb0c 2019-07-25 22:17:04 +1000

  • add innodb_debug_sync var to support DEBUG_SYNC from purge threads

• Revision #6d7a826953 2019-10-10 20:29:30 +0300

  • MDEV-20788: Bogus assertion failure for PAGE_FREE list

• Revision #726b1998fc 2019-10-10 10:25:32 +0300

  • Fixed feedback_plugin_load to work with staticly loaded plugin

• Revision #6fde0073bf 2019-10-09 18:47:14 +0300

  • Rename log_make_checkpoint_at() to log_make_checkpoint()

• Revision #c65cb244b3 2019-10-03 18:12:08 +0530

  • MDEV-19335 Remove buf_page_t::encrypted

• Merge Revision #24232ec12c 2019-10-09 08:30:23 +0300 - Merge 10.1 into 10.2

• Revision #ed0793e096 2019-10-02 22:47:45 +0300

  • MDEV-19783: Add more REC_INFO_MIN_REC_FLAG checks

• Revision #99dc40d6ac 2019-09-30 20:58:50 +0300

  • MDEV-19783 Random crashes and corrupt data in INSTANT-added columns

• Revision #d480d28f4f 2019-10-08 18:18:48 +0300

  • Add page_has_prev(), page_has_next(), page_has_siblings()

• Revision #27664ef29d 2019-09-26 15:05:55 +0530

  • MDEV-20574 Position of events reported by mysqlbinlog is wrong with encrypted binlogs, SHOW BINLOG EVENTS reports the correct one.

• Revision #13535b2713 2019-09-30 09:08:17 +0200

  • Fix problem with warnings of new compilers.

• Revision #5e65c67cfc 2019-10-03 17:45:36 +0300

  • fix clang warning

• Revision #edda2fd149 2019-10-01 03:23:33 +0300

  • MDEV-20703: mariadb-backup creates binlog files in server binlog directory on --prepare --export step

• Merge Revision #f203245e9e 2019-10-01 06:10:19 +0400 - Merge remote-tracking branch 'origin/10.1' into 10.2

• Revision #576a5f091e 2019-09-24 16:20:59 +0300

  • MDEV-20647 Fix and enable SphinxSE tests

• Revision #46b785262b 2019-09-30 12:48:26 +0300

  • Fix -Wunused for CMAKE_BUILD_TYPE=RelWithDebInfo

• Revision #bc70862e13 2019-09-25 14:00:39 +0200

  • MDEV-20614: Syntax error, and option put in wrong place

• Revision #c76873f23d 2019-09-27 17:46:10 +0530

  • MDEV-20688 Recovery crashes after unnecessarily reading a corrupted page

• Revision #d874cdeccc 2019-09-27 14:29:22 +0300

  • dict_load_table(): Remove constant parameter cached=true

• Revision #718fcee0a3 2019-09-27 14:22:59 +0300

  • Reduce rw_lock_debug_mutex contention

• Revision #4ec0c346b8 2019-09-27 13:58:01 +0300

  • Remove a useless large test, and add a debug assertion

• Revision #ca9e0089d5 2019-09-27 10:43:23 +0300

  • MDEV-19740: Fix GCC 9.2.1 -Wmaybe-uninitialized on AMD64

• Revision #2d6719d7ee 2019-09-26 12:48:55 +0300

  • MDEV-19514 preparation: Extend innodb.innodb-change-buffer-recovery

• Revision #23d675453f 2019-09-26 12:44:04 +0300

  • MDEV-20675 Crash in SHOW ENGINE INNODB STATUS with innodb_force_recovery=5

• Merge Revision #574ff87f2a 2019-09-26 12:36:01 +0300 - Merge 10.1 into 10.2

• Revision #102bc7beb0 2019-09-24 19:24:32 +0400

  • Fixing tests according to MDEV-20655 maturity stable for user_variables

• Merge Revision #0a359d7627 2019-09-24 19:19:25 +0400 - Merge remote-tracking branch 'origin/10.1' into 10.2

• Revision #fa9e012a34 2019-09-24 14:37:01 +0300

  • MDEV-20655 maturity stable for user_variables

• Revision #ef701bfd07 2019-09-24 13:29:23 +0300

  • Remove the unused function btr_page_get()

• Revision #ab9f378b0b 2019-09-23 13:47:52 +0530

  • Backporting 273d8eb12c40a6dcd05a8148bdfba3f1fd96e764 Proper fix for disabling warnings in read_statistics_for_table()

• Revision #2931fd2917 2019-09-23 09:04:51 +0300

  • After-merge fix: Adjust a result

• Revision #60cb5559a9 2019-09-23 08:29:39 +0300

  • MDEV-17614 post-fix: Remove dead dup_chk_only=true code.

• Merge Revision #44c5144943 2019-09-23 08:26:08 +0300 - Merge 10.1 into 10.2

• Revision #1ad79c8187 2019-06-18 06:58:41 -0700

  • MDEV-19679 - CREATE SERVER needs tweaks for compatibility with CONNECT engine

• Revision #fd5cd073cc 2019-05-08 06:40:37 -0700

  • MDEV 19205 Sphinx unable to connect using a host name

• Revision #9611d7e08a 2018-01-03 11:27:20 +0100

  • Fix

• Revision #75bcf1f9ad 2017-05-08 16:36:37 +1000

  • MDEV-12646: systemd service file changes from Fedora

• Revision #4afe9d4b6d 2019-09-20 08:30:31 +0300

  • MDEV-16222: Move the test to gcol.innodb_virtual_debug_purge

• Revision #c0db3fe6da 2019-05-27 13:52:27 +0200

  • MDEV-18438 Don't stream xtrabackup_info of extra-lsndir

• Revision #f94d9ab9f8 2019-09-18 20:19:03 +0530

  • MDEV-20483 Follow-up fix

• Revision #b3a7c07eae 2019-09-18 16:50:46 +0300

  • Enable galera.MW-286 test case.

• Merge Revision #bb4214272a 2019-09-18 16:24:48 +0300 - Merge 10.1 into 10.2

• Revision #24859049c6 2019-09-18 16:04:43 +0300

  • MDEV-20485: Disable galera.galera_var_node_address

• Revision #a624b99f91 2019-09-18 12:17:09 +0300

  • Remove an unused declaration

• Revision #273d8eb12c 2019-09-18 01:59:29 +0530

  • MDEV-20589: Server still crashes in Field::set_warning_truncated_wrong_value

• Revision #c471bfb34e 2019-09-18 01:44:36 +0530

  • Fixing a test to reset to original state

• Revision #fb3e3a6a3d 2019-09-17 19:54:15 +0530

  • MDEV-20483 trx_lock_t::table_locks is not a subset of trx_lock_t::trx_locks

• Revision #2a98d0b5ca 2019-09-14 12:14:20 +0300

  • Fix #2 for galera.MW-336

• Revision #23657a2101 2019-09-13 17:07:58 +0300

  • MDEV-13893/MDEV-12699: Enable encryption.innodb-redo-badkey

• Revision #3793da44cf 2018-04-16 20:49:27 +0000

  • Enable the auto parameter of the flag default-character-set

• Revision #3422c13ab7 2019-09-11 14:15:17 +0300

  • Try to fix galera.MW-336 test case.

• Revision #40beeb1402 2019-09-13 09:18:11 +0300

  • MDEV-20561 Galera node shutdown fails in non-Primary (#1386)

• Revision #99ecb33389 2019-09-12 15:15:33 +0200

  • MDEV-20570 : Packaging fails "The specified timestamp server either could not be reached"

• Revision #be6beb73e9 2019-09-11 23:05:12 +0300

  • MDEV-16560: [counter] rocksdb.ttl_secondary_read_filtering fail in buildbot

• Revision #c8dc866fde 2019-09-10 23:51:42 +0300

  • MDEV-20371: Invalid reads at plan refinement stage: join->positions...

• Revision #863a951731 2019-09-11 09:11:58 -0400

  • bump the VERSION

• Revision #0f950e53f0 2019-09-11 15:08:32 +0300

  • MDEV-20562 btr_cur_open_at_rnd_pos() fails to return error for corrupted page

• Revision #df4dee4b84 2019-09-11 16:02:41 +0530

  • MDEV-17939 Assertion `++loop_count < 2' failed in trx_undo_report_rename

• Merge Revision #f7fe51f126 2019-09-11 08:48:00 +0300 - Merge 10.1 into 10.2

• Revision #5ec4efb7b1 2019-09-11 04:44:24 +0400

  • Adding missing semicolons to sql_yacc.yy (10.2)

• Revision #acf0f2d592 2019-09-10 14:54:31 +0300

  • MDEV-20143 innodb.innodb-virtual-columns-debug failed in buildbot with wrong result

• Revision #879c9ddce7 2019-09-09 19:57:25 +0200

  • MDEV-20542 Windows enable/d2OptimizeHugeFunctions

• Revision #43a6e81ccb 2019-09-09 18:18:52 +0300

  • MDEV-19514 preparation: Remove innodb_change_buffering_debug=2

• Revision #2336e0b394 2019-09-09 13:48:36 +0200

  • MDEV-20206 : Crash inside timer_callback()[threadpool_win.cc:419]

• Revision #a895c68c58 2019-09-09 12:08:47 +0200

  • On Windows, treat linker warnings as errors, if MYSQL_MAINTAINER_MODE is ERR

• Revision #d251b76884 2019-09-09 12:07:47 +0200

  • Fix warning when compiling with OpenSSL.

• Revision #7e7b6ec4d6 2019-09-09 12:06:29 +0200

  • Fix connect RESTSDK support.

• Revision #803bb5cdf8 2019-09-09 10:51:10 +0200

  • Windows, cmake : Fix occasional link error when switching between debug to optimized compilation

• Revision #0fd5b11eb0 2019-09-06 14:54:22 +0300

  • MDEV-20511: Galera replication of events is not consistent

• Revision #efbfded563 2019-09-05 12:26:36 +0300

  • Move MW-328B to big test to avoid test timeout.

• Revision #caa7bb62f6 2019-09-04 09:21:07 +0300

  • MDEV-20485: Galera test failure on galera.galera_var_node_address

• Revision #b8b4b6594e 2019-09-05 07:43:57 +0300

  • MDEV-19926: Galera SST tests fail

• Revision #7591a24fa6 2019-09-09 13:06:33 +0300

  • MDEV-20531: innodb.temporary_table_optimisation fails

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

_{This page is licensed: CC BY-SA / Gnu FDL}