> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/release-notes/community-server/old-releases/10.4/10.4.34.md). # MariaDB 10.4.34 Release Notes [Download](https://mariadb.com/downloads/) | [Release Notes](/docs/release-notes/community-server/old-releases/10.4/10.4.34.md) | [Changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-10-4-series/mariadb-10-4-34-changelog.md) | [Overview of 10.4](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-4-series) [*Alternate download from mariadb.org*](https://downloads.mariadb.org/mariadb/10.4.34/) **Release date:** 16 May 2024 [MariaDB 10.4](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-4-series) is a previous *stable* series of MariaDB, [maintained until](https://mariadb.org/about/#maintenance-policy) June 2024. It is an evolution of [MariaDB 10.3](/docs/release-notes/community-server/old-releases/10.3/what-is-mariadb-103.md) with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL. [MariaDB 10.4.34](/docs/release-notes/community-server/old-releases/10.4/10.4.34.md) is a [***Stable (GA)***](/docs/release-notes/community-server/about/release-criteria.md) release. [MariaDB 10.4.34](/docs/release-notes/community-server/old-releases/10.4/10.4.34.md) is the last release of the [MariaDB 10.4](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-4-series) release series. **For an overview of** [**MariaDB 10.4**](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-4-series) **see the**[**What is MariaDB 10.4?**](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-10-4-series/what-is-mariadb-104) **page.** Thanks, and enjoy MariaDB! ## Notable Items ### Storage Engines #### InnoDB * Fix adaptive hash index corruption after [ALTER TABLE…DISCARD TABLESPACE](/docs/server/reference/sql-statements/data-definition/alter/alter-table.md#discard-tablespace) ([MDEV-33400](https://jira.mariadb.org/browse/MDEV-33400)) * Fix InnoDB: Failing assertion on UPDATE ([MDEV-32346](https://jira.mariadb.org/browse/MDEV-32346)) * Fix fatal InnoDB error or assertion \`\`!is\_v'\` failure upon multi-update with indexed virtual column ([MDEV-31154](https://jira.mariadb.org/browse/MDEV-31154)) * Fix InnoDB fatal error: Clustered record field for column x not found ([MDEV-33558](https://jira.mariadb.org/browse/MDEV-33558)) * Fix alter operation hang when encryption thread works on the same tablespace ([MDEV-33770](https://jira.mariadb.org/browse/MDEV-33770)) * Fix MariaDB segfault on rowid filter query involving generated column ([MDEV-33795](https://jira.mariadb.org/browse/MDEV-33795)) * Fix discard/import tablespace, restart, index corruption ([MDEV-33512](https://jira.mariadb.org/browse/MDEV-33512)) * Fix alter table corruption while applying the modification log ([MDEV-19044](https://jira.mariadb.org/browse/MDEV-19044)) * Fix weird read view after ROLLBACK of other transactions ([MDEV-33802](https://jira.mariadb.org/browse/MDEV-33802)) * Table no longer gets rebuilt with ALTER TABLE ADD COLUMN ([MDEV-33214](https://jira.mariadb.org/browse/MDEV-33214)) #### RocksDB * Unsafe use of LOCK\_thd\_kill in my\_malloc\_size\_cb\_func() ([MDEV-33443](https://jira.mariadb.org/browse/MDEV-33443)) #### [Spider](/docs/server/server-usage/storage-engines/spider.md) * Improve Spider performance by pushing down [TIMESTAMPDIFF](/docs/server/reference/sql-functions/date-time-functions/timestampdiff.md) function ([MDEV-28992](https://jira.mariadb.org/browse/MDEV-28992)) and [CASE](/docs/server/reference/sql-statements/programmatic-compound-statements/case-statement.md) statement ([MDEV-28993](https://jira.mariadb.org/browse/MDEV-28993)) to data nodes * Fix sql plugin init failure with traditional sql\_mode ([MDEV-33584](https://jira.mariadb.org/browse/MDEV-33584)) * Fix parsing failure on valid left join select by translating the on expression to () ([MDEV-33679](https://jira.mariadb.org/browse/MDEV-33679)) * Fix Spider: ERROR 12710 (HY000): Invalid information from remote table when using [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) local and [MariaDB 10.6](/docs/release-notes/community-server/10.6/what-is-mariadb-106.md) remote ([MDEV-33777](https://jira.mariadb.org/browse/MDEV-33777)) * Fix bug where [Spider variables](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md) were not available if Spider was loaded upon server startup ([MDEV-33441](https://jira.mariadb.org/browse/MDEV-33441)) ### Backup * [MariaDB Backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/) now preserves [innodb\_encrypt\_tables](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_encrypt_tables) ([MDEV-33334](https://jira.mariadb.org/browse/MDEV-33334)) * Fix [MariaDB Backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/) problem on older mariadb (opendir(NULL)) caused by [MDEV-30968](https://jira.mariadb.org/browse/MDEV-30968) ([MDEV-31251](https://jira.mariadb.org/browse/MDEV-31251)) * [mariadb-backup --backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup) now includes retry logic for undo tablespaces ([MDEV-33980](https://jira.mariadb.org/browse/MDEV-33980)) * Fix crash recovery in mariadb-backup --prepare due to insufficient [innodb\_log\_file\_size](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_log_file_size) ([MDEV-33540](https://jira.mariadb.org/browse/MDEV-33540)) ### [Character Sets](/docs/server/reference/data-types/string-data-types/character-sets.md), [Data Types](/docs/server/reference/data-types.md) * Default charset now works with PHP MySQLi extension ([MDEV-32975](https://jira.mariadb.org/browse/MDEV-32975)) ### Optimization & Tuning * Server crashes in JOIN\_CACHE::write\_record\_data upon EXPLAIN with subqueries and constant tables ([MDEV-21102](https://jira.mariadb.org/browse/MDEV-21102)) ### Replication * \--gtid-ignore-duplicate can double-apply event in case of parallel replication retry ([MDEV-33475](https://jira.mariadb.org/browse/MDEV-33475)) ### Galera * [Galera](https://github.com/mariadb-corporation/docs-release-notes/blob/test/kb/en/galera-cluster/README.md) updated to 26.4.18 * NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated ### SQL, Data Definition, and Data Manipulation * Fix incorrect DEFAULT expression evaluated in [UPDATE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/update.md) ([MDEV-33790](https://jira.mariadb.org/browse/MDEV-33790)) #### Prepared Statements * Incorrect handling of UPDATE in PS mode in case a table's colum declared as NOT NULL ([MDEV-33549](https://jira.mariadb.org/browse/MDEV-33549)) * Crash in EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a INT DEFAULT ?)' USING DEFAULT, UBSAN runtime error: member call on null pointer of type 'struct TABLE\_LIST' in Item\_param::save\_in\_field ([MDEV-15703](https://jira.mariadb.org/browse/MDEV-15703)) ### General #### Server * Original IP not shown in network related error messages when proxy\_protocol is in use ([MDEV-33506](https://jira.mariadb.org/browse/MDEV-33506)) ### Security * Fixes for the following [security vulnerabilities](/docs/server/security/cve.md): * CVE-`-``#` ## Changelog For a complete list of changes made in [MariaDB 10.4.34](/docs/release-notes/community-server/old-releases/10.4/10.4.34.md), with links to detailed\ information on each push, see the [changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-10-4-series/mariadb-10-4-34-changelog.md). ## Contributors For a full list of contributors to [MariaDB 10.4.34](/docs/release-notes/community-server/old-releases/10.4/10.4.34.md), see the [MariaDB Foundation release announcement](https://mariadb.org/mariadb-11-2-4-11-1-5-11-0-6-10-11-8-10-6-18-10-5-25-10-4-34-now-available/). {% hint style="info" %} Be notified of new MariaDB Server releases automatically by [subscribing](https://lists.mariadb.org/postorius/lists/announce.lists.mariadb.org/) 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](/docs/general-resources/distributions-including-mariadb.md) page. {% endhint %} *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formid="4316" formId="4316" %}