Questions tagged [mariadb]
MariaDB is a drop-in replacement for Oracle(R) MySQL(TM). The MariaDB tag is for versions 10.6 LTS, 10.11 LTS, and 11.4 LTS or higher.
922 questions
0 votes
1 answer
140 views
backing up a mariadb database and recreating indexes on restoration
We are running mariadb: Server version: 10.5.27-MariaDB-log MariaDB Server and we need to backup a database named sports and on restoration "rebuild" all its indexes. For mysql AI suggest to ...
1 vote
1 answer
126 views
mariabackup --prepare keeps backup state at "log-applied", not "full-prepared"
I'm performing a full backup on a MariaDB 10.6.8 instance on linux and encountering an issue where the --prepare step finishes successfully but fails to transition the backup state to full-prepared. ...
- 21
1 vote
1 answer
174 views
Unable to login to Mariadb as root
I have a mariabd 11.8.3 server running on debian trixie and I am unable to login to root account. I want to login as root using sudo mariadb without specifying any password. However, it always fail ...
- 131
0 votes
0 answers
63 views
mariadb-backup hanging / SET GLOBAL innodb_log_checkpoint_now=ON
I've started using mariadb-backup instead of regular mariadb-dump for my backups and they've been working well for months. Then, I've made some changes resulting in more frequent inserts and updates, ...
- 141
1 vote
0 answers
168 views
Is mariadb-secure-installation still relevant?
I just installed MariaDB on a brand new Ubuntu 24.04 LTS server, and most online configuration tutorials suggest I run mariadb-secure-installation right after installation, otherwise my database ...
- 76
3 votes
1 answer
477 views
Import database Zabbix 6.0.40 into Zabbix 7.4.2 -> fails due to table already exists
I upgraded a Zabbix installation (VM) by cloning that VM, updating the OS, database, PHP and zabbix. After the cloned Zabbix installation worked, I wanted to import the database from the old VM, so ...
- 373
0 votes
1 answer
237 views
Could not increase number of max_open_files to more than 32768 in MariaDB 10.5.29 after upgrading from Debian 10 (buster) to Debian 11 (bullseye)
After upgrading from Debian 10 (buster) to Debian 11 (bullseye) I found that when starting mariadb service (MariaDB 10.5.29), I get the following warning: sudo systemctl start mariadb.service sudo ...
- 402
0 votes
1 answer
91 views
MariaDB 10.5.29 database server is not starting after upgrading from Debian 10 (buster) to Debian 11 (bullseye)
After upgrading from Linux Debian 10 (buster) to Debian 11 (bullseye) MariaDB 10.5.29 database server is not starting. I see the following in the /var/log/syslog: tail -f /var/log/syslog # Aug 27 10:...
- 402
-1 votes
1 answer
133 views
SSL error: Unable to get private key from '/etc/mysql-ssl/server-key.pem' after Debian 9 (stretch) to 10 (buster) upgrade
Upgraded Debian Linux 9 (stretch) to 10 (buster). Now I get the following error: SSL error: Unable to get private key from '/etc/mysql-ssl/server-key.pem' The detailed status message is: systemctl ...
- 402
0 votes
1 answer
153 views
Maxscale doesn't have a master connection
I have a mariadb galera master-master cluster with 2 nodes and 1 arbitrator. I have to reboot one node and after the startup galera was synced and in primary status, however maxscale started to not ...
- 1,490
-2 votes
2 answers
159 views
MariaDB Server Disk Full Err28 Pointing to /tmp/#sql-temptable-468-19b-2.MAI - Where Do I Find This, What Might Have Caused The Issue
Thank you for looking at my question, We have a MariaDB MySQL database server version 10.6.21 It is reporting Fatal Error - SQL select table_schema,table_name from information_schema.views where ...
0 votes
1 answer
127 views
What are you planning to do when MySQL 8.0 goes end of life?
It seems a lot of people were running MySQL 5.7 for many years until it went end-of-life last year, and many have been on MySQL 8.0 series since 2019 which is going end-of-life next. What are people ...
- 1,059
3 votes
1 answer
295 views
Setting for read_only on MaxScale controlled primary/replica
We're running two MariaDB 11.7.2 replica servers and one primary behind a MaxScale 24.02.04. The replicas are set to read_only in their configuration. MaxScale does not change the configuration on ...
- 555
3 votes
2 answers
3k views
MariaDB on Ubuntu 24.04 Server: "Referenced but unset environment variable evaluates to an empty string: MYSQLD_OPTS, _WSREP_NEW_CLUSTER"
I just recently upgraded to Ubuntu 24.04 Server, and noticed some notices from MariaDB-server 11.4.5. When I run sudo systemctl status mariadb.service, I notice the following in the log: Apr 05 22:13:...
- 203
0 votes
1 answer
255 views
MariaDB on Windows always allows root login without password when using HeidiSQL as Administrator
I've encountered a strange behaviour when using MariaDB (in my case 11.4 LTS) on Windows, and I haven't been able to find anything about it online so far. After a fresh installation of MariaDB 11.4 ...
- 1