Questions tagged [mariadb]
MariaDB is a drop-in replacement for Oracle(R) MySQL(TM).
851
questions
0
votes
0
answers
37
views
mariadb 10.3 not sending CA certificate, so clients can't verify the server [duplicate]
I've partially successfully installed a Let's Encrypt certificate for mariadb 10.3.34
I've configured a user with REQUIRE SSL and that works fine with local command line.
Server system is Ubuntu 20.04....
- 1
0
votes
1
answer
82
views
MySQL Update Statement taking long time to update small table with 4 rows
I've got a ridiculously small table in MySQL that consists of four rows of data. Updating this table is taking a long time, often upwards of 50 seconds.
CREATE TABLE `log_CacheQueueEntity` ( `ID` int(...
- 217
1
vote
1
answer
41
views
Restore MariaDB masked service
I have a situation where MariaDB service has become masked. This happened when a colleague tried to remove a package from an Debian 11 server. Obviously the package manager warned him but on the rush ...
- 173
-2
votes
1
answer
99
views
How Can I Automatically Restart MariaDB After Memory-Induced Crashes to Reduce Website Downtime?
How Can I Automatically Restart MariaDB After Memory-Induced Crash.
I've encountered a recurring problem where memory spikes lead to the crash of MariaDB on my server, causing my site to go offline.
I ...
0
votes
1
answer
74
views
Mariadb active passive failover doesn't work with HAProxy
What is wrong with my HAProxy config?
This thread kind of similar, but still not the same: Haproxy mysql failover load balancing
I have an active-passive Mariadb galera cluster.
Today on the master ...
- 115
0
votes
1
answer
57
views
Grafana not sharing dashboards in High Availability mode
I am trying to set Grafana (version 9.5.5, SUSE Linux) to high availability mode using MariaDB on an external server. My understanding is that this should result in my multiple Grafana instances ...
- 111
0
votes
1
answer
66
views
Dovecot can't connect to MariaDB when require_secure_transport is on
I have a Dovecot server that uses MariaDB for virtual mailboxes. The MariaDB server is on another machine in the same LAN.
We recently enabled TLS on the MariaDB machine.
Dovecot works fine when ...
- 105
2
votes
2
answers
134
views
MariaDB on Windows 11 Pro fails due to privilege tables' file problems
About 5-6 days after each fresh installation of (the newest) XAMPP 8.2.4 on Windows 11 Pro (10.0.22621 Build 22621), MariaDB 10.4.28 on-board it starts to fail during every run:
Sometimes I am getting ...
- 163
0
votes
0
answers
69
views
mariadb access denied to centreon@localhost
Im trying to migrate centreon to new server and version, i have this error in syslog on debian11.
mariadbd[1640]: 2023-10-20 11:13:52 13360 [Warning] Access denied for user 'centreon'@'localhost' (...
- 1
0
votes
1
answer
43
views
How to stop a killed rollback process on MariaDB?
We have a failed attempt of a rollback on a Mariabd. The process is still listed in show full processlist but show no progress. How to stop this process?
22301639 user localhost db Killed ...
- 179
2
votes
1
answer
87
views
How to run mariadb replication without error?
I set up a master to slave replication according to the docs. I'm using ansible for this (see below).
After the initial run (lock, backup, unlock, copy to slave host, import and start slave) the slave ...
- 121
0
votes
0
answers
72
views
Change the user name debian-sys-maint in Debian mariadb
The account "debian-sys-maint" in Debian mysql/mariadb is important to maintain the DB system function normally. It needs full administrative privileges, as some people has discussed in What ...
1
vote
0
answers
308
views
Connecting to MariaDB server: ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 11
I am trying to connect to an AWS hosted (RDS) MariaDB database (engine version 10.6.14). The database is hosted on a private subnet but it's accessible through a bastion host. I use an SSH tunnel to ...
- 111
0
votes
1
answer
74
views
Getting below error on ActiveMQ "Classic" message broker log. I'm looking for some solution to find the root cause and fix for this issue
Getting below error on ActiveMQ "Classic" message broker log. I'm looking for some solution to find the root cause and fix for this issue.
Sep 6 16:10:46 SERVER activemq_db8159[1168628]: ...
- 1
1
vote
1
answer
102
views
MariaDB randomly crashes
I've encountered a peculiar issue related to my MariaDB database instance (version 10.2) that causes my MariaDB service to stop unexpectedly. I've attempted to investigate the problem by regularly ...
- 19
2
votes
1
answer
104
views
MaxScale doesn't connect to Galera Cluster
I am working on a distributed HA cloud system and I have a Galera Cluster with 3 separated servers in Docker Swarm. It works as expected.
I have 3 separated services for the Galera members due to ...
- 131
1
vote
1
answer
60
views
Disk saturated by mariadb on CentOS 7, blocks everything
For the past few days I have been having a problem with a webserver running CentOS 7. Every 13-14 minutes some operation (which I identified with mariadb using iostat) seems to completely saturate the ...
-1
votes
2
answers
122
views
MariaDB Docker lagre db/binlog.* files. Overflows the disk to the point of failure
How to Fix?
ls -lh /root/docker/yml/nextcloud/db/binlog.*
-rw-rw---- 1 999 999 960M Aug 25 22:55 /root/docker/yml/nextcloud/db/binlog.000043
-rw-rw---- 1 999 999 5.5M Aug 25 23:52 /root/docker/yml/...
1
vote
0
answers
119
views
MariaDB Galera cluster with failed node
A client of mine asked a question that I'm not really sure how to answer correctly. His question is: In case of one node falls out of the cluster, stays offline for a few hours or days and then comes ...
- 1,048
0
votes
1
answer
96
views
Is the MariaDB ODBC Connector 3.1.19 now stable for production when used with ASP Classic?
Has anyone used this driver successfully in a production environment?
Some time back I tried the MariaDB ODBC Connector 3.1.15 with a MariaDB 10.6 database; and the site kept crashing.
I had to ...
- 274
0
votes
0
answers
139
views
Windows MariaDB 10.6.5 upgrade to MariaDB 10.6.11
I am considering upgrading my MariaDB 10.6 to 10.11 -- (maintained for 5 years).
I updated 10.6.5 to 10.6.15 with a simple in-place update; but found these troubling comments on doing updates form 10....
- 274
0
votes
1
answer
337
views
MariaDB 10.3.38 does not start after change from MySQL 5.7.41
I replaces MySQL 5.7.41 with MariaDB 10.3.38 on Ubuntu 20.04.
Unfortunately MariaDB does not start by itself over systemctl:
sudo systemctl status mariadb ● mariadb.service - MariaDB 10.3.38 database ...
- 33
1
vote
0
answers
149
views
Using MySQL/MariaDB replication, how to know when the Replica is in a consistent state?
This is a question about MariaDB (mostly) and a replication that I am considering.
For this replication, the Primary database is updated every minute by a process which can take about 15 seconds to ...
- 83
2
votes
1
answer
191
views
Is it possible to have MySQL/MariaDB bidirectional replication?
I am trying to install replication on several MariaDB servers.
With no experience at all on this.
I am wondering something.
Would it be possible to have both servers acting simultaneously as master ...
- 83
0
votes
0
answers
109
views
Cant install Mariadb on Debian 11
Im trying to install it on Debian 11
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --os-type=debian --os-version=11 --mariadb-server-version="mariadb-10.5"
# ...
- 1
0
votes
0
answers
622
views
mysqld[1108] [Warning] Aborted connection 7466 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1'
I am running Ubuntu Server 20.04. It is a LEMP server running Mariadb. When I run the command sudo service mariadb status I get the following warnings:
Jul 28 00:18:59 mail.example.com mysqld[1108]: ...
- 103
1
vote
1
answer
145
views
MariaDB / MySql Warning after Netdata installation. "Access denied for user 'netdata'@'localhost' (using password: NO)" How to fix?
I have configured Netdata on an Ubuntu 20.04 Server LEMP server, according to this Linuxbabe.com tutorial.
After installation, I run the following command
sudo systemctl status mariadb.service
which ...
- 103
0
votes
0
answers
52
views
pgloader + docker mariadb and postgres = no connection on localhost for my databases
I am trying to migrate from mariaDB to postgres via pgLoader
I have two databases running on my computer
mariadb on 127.0.0.1 pass:pass user:app
postgres on 127.0.0.1 pass:pass user:app
I run the ...
- 57
0
votes
0
answers
62
views
How to connect to MariaDB remotely
I rarely use Linux as I'm a .Net developer and it is my first time using Debian, I have always used Ubuntu before on rare occasions.
I'm trying to connect to MariaDB. and I succeed locally both using ...
0
votes
2
answers
122
views
Why doesn't cron run the commands in another user's crontab?
Hello everyone and thank you in advance.
I have written a job in the mysql user crontab, but it doesn't run at all. I think my code is correct, because it works properly if I execute it pointing to a ...
- 19
1
vote
0
answers
300
views
MariaDB Not Starting
I left it here, reverting to an outdated backup, as I needed to get the system up and running. If there are new answers and things to try, I will try so that the issue can be resolved. I shut down the ...
0
votes
1
answer
291
views
Mysqldump max_allowed_packet issue
I need to migrate a database that was managed by someone who left the company.
The source server is MariaDB 1:10.5.5, the destination MariaDB 1:10.5.19.
The existing backup scripts use the following ...
- 5
0
votes
0
answers
237
views
Docker Debian: ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (111)
On a Debian 12 container: I have the ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (111).
The mariadb service is started but doesn't works.
This is my ...
- 1
0
votes
0
answers
276
views
CDR not working with asterisk & odbc
I had ODBC working with asterisk to write to my CDR then recently needed to check my CDR to realise nothing had been written for about 6 months. I had a look at my config, nothing seamed to have ...
- 23
0
votes
0
answers
108
views
SQL Error (1114): The table 'global_priv' is full
I can no longer add users to my database. I only get the error:
SQL Error (1114): The table 'global_priv' is full
I researched this issue, and the my.ini config for innodb_data_file_path did not have ...
- 111
1
vote
1
answer
151
views
TeamCity upgrade fails with "Can't take exclusive lock when db lock is not held"
When upgrading to TeamCity 2023.05 (using the Docker image), I received the error "Can't take exclusive lock when db lock is not held" and the detailed instruction:
<pre>java.lang....
- 891
0
votes
1
answer
223
views
How to back up mysql/mariadb database as mysql root when using unix socket for sql access in a bash script?
I am running Ubunutu Server 20.04. I have secured mariadb by using the unix socket for authentication, which means, I need to enter sudo mysql to be able to access mysql as root.
1)
If I enter
mysql -...
- 103
0
votes
0
answers
59
views
How do I analyze the workload of a mariaDB instance?
I'm not a server admin, so sorry if my questions are a bit basic, but I couldn't find anything by googling.
We have a locally hosted MariaDB (not SkySQL) on a windows server and I'd like to see how it'...
- 113
0
votes
0
answers
43
views
How to insert audit filters into community edition?
When it comes to auditing, majority of documentation I find pertains to enterprise edition, not community. It is a different plugin and as such not all information I read matches up.
Running MariaDB ...
- 111
1
vote
2
answers
146
views
Bad configuration MariaDB / MySQL
I currently have a LAMP on a dedicated server but with serious problems with MariaDB (MySQL).
I have installed a website with 100k daily pageviews and due to the need for the queries it is necessary ...
0
votes
1
answer
68
views
Setting up Slack Alerts for Monit monitoring MySQL
Trying to set up Slack alerts for Monit and MySQL/MariaDB but stuck in writing a MySQL check script. I have the monit successfully working if MySQL is stopped and receive email alerts - but want the ...
- 109
0
votes
1
answer
441
views
MariaDB 11.0.2 fails to start after upgrade from 10.11.4
I am on Debian Bullseye and just upgraded (or at least attempted to upgrade) MariaDB from 10.11.4 to 11.0.2.
Unfortunately, the service fails to start now. All I'm getting through systemctl status ...
- 51
1
vote
2
answers
758
views
List all users of a MariaDB
How can I list all users in my MariaDB?
Teh Internet is full of
SELECT user FROM mysql.user;
in all its variations, but this does not work on MariaDB (I'm on version 10.5.19 if that matters), rather ...
- 21
0
votes
1
answer
51
views
Synchronizing load balanced Linux servers
I want to load-balance two dedicated linux servers, I'm planning to do that using round robin DNS, but I can't find a way to synchronize the servers to be identical.
The servers are running a perl ...
-1
votes
1
answer
185
views
MariaDB - Emulate MySQL 5.7 version number?
I have been running MariaDB 5.5 on a linux server for several years.
Yesterday, I upgraded to MariaDB 10.11.3.
Now, my backup software has stopped backing up the databases, reporting an error that &...
- 1,013
0
votes
2
answers
159
views
Starting MySQL standalone works but as windows service it fails
I have an xampp-portable directory that contains mysql/mariadb. The xampp directory is located directly on d:, so path is d:\xampp and mysql is d:\xampp\mysql I want to run mysql as windows service so ...
- 103
0
votes
1
answer
86
views
How to add a new database on replication?
I have a mysql replication with two servers.
There are actually 3 databases on it.
On master :
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days ...
0
votes
0
answers
361
views
Kolla-Ansible fails to deploy Openstack because of MariaDB liveness step failing
I'm having issues when deploying Openstack via kolla-ansible on virtual machines that are running inside Proxmox, across three nodes. Both "kolla-ansible -i multinode bootstrap-servers" and &...
1
vote
0
answers
56
views
Replicate mysql database when target server is MariaDB 10.5 (where mysql.user is a view)
I have a sync script that does a mysqldump on the mysql database on a source server, then imports that dump on the target server, followed by privelege flush. Systems are CentOS 7.
In MariaDB 10.5, ...
- 249
0
votes
1
answer
129
views
Mariadb creates a subprocess after crash
We recently had a crash on our Mariadb server (10.6.5) on a Debian 9 VM. The process was restarted without error but now there's a second mariadb process like so :
mysql 26718 5.1 42.4 15062644 ...
- 323