Instructions for reproducing the bug MDEV-6075 by Edward Stoever for Mariadb Support
September 19, 2025
Requires the file reproduce_std_bad_alloc.zip - available on the internal download site:
https://drive.google.com/drive/u/0/folders/17mLWGlFt8_EsH1jsEyFL1HvvBQMHkq7o

Virtual machine is configured with 3G of ram
root@cs1:~/repro$ free -m
               total        used        free      shared  buff/cache   available
Mem:            2987         274        2311          60         401        2506
Swap:            974           0         974

Version before upgrade:
root@cs1:~$ mariadb -Ae "select version(), VARIABLE_VALUE from information_schema.GLOBAL_STATUS where VARIABLE_NAME = 'Columnstore_version';"
+----------------------------------+----------------+
| version()                        | VARIABLE_VALUE |
+----------------------------------+----------------+
| 10.6.14-9-MariaDB-enterprise-log | 23.02.13       |
+----------------------------------+----------------+


unzip reproduce_std_bad_alloc.zip
cd ~/repro
mariadb < create_tables.sql
./cp-imp.sh
mariadb < q_limit_100000.sql 1>/dev/null # no error!
systemctl stop mariadb
systemctl stop mariadb-columnstore

apt remove -y mariadb-server mariadb-plugin-columnstore
# A final error "Sub-process /usr/bin/dpkg returned an error code (1)" is ignored.


wget https://dlm.mariadb.com/enterprise-release-helpers/mariadb_es_repo_setup
chmod 755 mariadb_es_repo_setup

./mariadb_es_repo_setup --token=$MY_CUSTOMER_TOKEN --mariadb-server-version=10.6.21-17 --skip-maxscale --apply
apt install -y mariadb-server mariadb-plugin-columnstore
# When the install script gets to Columnstore.xml, it asks: The default action is to keep your current version. *** Columnstore.xml (Y/I/N/O/D/Z) [default=N] ?
# Just hit enter and keep current version.

root@cs1:~/repro$ mariadb < q_limit_100000.sql 1>/dev/null
ERROR 1815 (HY000) at line 3: Internal error: (358) MCS-2001: Join or subselect exceeds memory limit.

root@cs1:~/repro$ cat /var/log/mariadb/columnstore/err.log
Sep 19 12:57:36 cs1 ddlpackageproc[4201]: 36.100715 |0|0|0| C 23 CAL0008: DMLProc main process has started
Sep 19 12:57:36 cs1 ddlpackageproc[4221]: 36.120628 |0|0|0| C 23 CAL0008: DDLProc main process has started
Sep 19 12:57:47 cs1 threadpool[4165]: 47.925379 |0|0|0| E 22 CAL0005: threadFcn: Caught exception:  std::bad_alloc
Sep 19 12:57:47 cs1 threadpool[4165]: 47.926126 |0|0|0| E 22 CAL0005: threadFcn: Caught exception:  std::bad_alloc
Sep 19 12:58:02 cs1 threadpool[4165]: 02.039549 |0|0|0| E 22 CAL0005: threadFcn: Caught exception:  std::bad_alloc