Questions tagged [mariadb]
MariaDB is a drop-in replacement for Oracle(R) MySQL(TM).
867
questions
0
votes
1
answer
53
views
mariadb service: Failed with result 'exit-code'
on my subject, there are several similar questions and answers, but all of them doesn't help
MariaDb installated on a Raspberry Pi was running now more than 3 years. Unfortunately I had a power-supply-...
0
votes
0
answers
24
views
How to get MariaDB slow query logs to show up on RDS
I have a MariaDB instance on RDS which I would like to enable slow query logs for.
Following the documentation, I've created a paramter group which is assigned to the database.
When I make changes to ...
0
votes
1
answer
87
views
Internal Server Error on Nextcloud instance migration from Debian 12 to Rocky Linux 9 server
I've done everything by the book, according to the official guide, available here https://docs.nextcloud.com/server/latest/admin_manual/maintenance/migrating.html
It is not a SELinux issue. I've tried ...
0
votes
1
answer
113
views
MariaDB Replication on selected columns
I would like to ask a question that I am sure someone who is a lot smart then me can answer.
I have a main MariaDB that holds all my tables and columns etc (total of 64 tables) and this is stored on ...
0
votes
0
answers
120
views
MariaDB Crashes on Startup with Let's Encrypt Certificates
It seems I'm encountering an issue while setting up secure connections for my clients to connect to my database server on Debian 12. Every time I attempt to start MariaDB, it crashes with a Private ...
0
votes
0
answers
51
views
MariaDB 10.3 vs 10.4 performance degradation
We're migrating to a new server and noticed some weird performance degradations. Old server is Ubuntu 18.04 running MariaDB 10.3 (10.3.27-MariaDB-1:10.3.27+maria~bionic-log); new is Ubuntu 20.04 ...
0
votes
1
answer
115
views
Monit and MySQL/MariaDB Checksum
I have Monit monitoring MariaDB but when a minor MariaDB update is rolled out Monit fails to monitor as the Checksum has changed:
Checksum failed Service mysql_bin
Description: checksum failed, ...
0
votes
1
answer
51
views
Cannot connect to MariaDB through an OpenVPN tunnel
Similar to this issue Unable to connect to MariaDB through an OpenVPN tunnel
I cannot connect to the MariaDB server through OpenVPN. The setup is -
Ubuntu 20.04,
mariadb Ver 15.1 Distrib 10.3.39-...
2
votes
3
answers
303
views
MariaDB using more memory than expected
We're running MariaDB server 10.6.16 from the RPM repository https://mirror.mariadb.org/yum/10.6/rhel9-amd64/ on a AlmaLinux 9.3 system with 48 GiB memory (no swap space) and 32 CPU cores. We're ...
0
votes
0
answers
18
views
MariaDB/MySQL TDE extract/recover key from running server, when keyfile is lost?
If I have a MariaDB Server encrypted with the File Key Management Encryption Plugin (TDE / Transparent Data Encryption), is it somehow possible to extract the key from the running server?
To my ...
0
votes
0
answers
35
views
mariadb-connector-odbc v3.1.20 "t_nobigint" unit test fails for big endian
In mariadb-connector-odbc v3.1.20 under test/types.c, unit test t_nobigint fails for big endian s390x. I am pretty sure it's because of the way hex decimal(byte conversion) took place in big endian. I ...
1
vote
0
answers
69
views
Does MariaDB-Galera cluster have error tolerance function on sst_user credential?
We have done the testing and confirmed the following system behavior of MariaDB-Galera clustering:
The first-time bootstrap always needs to get everything correct, including the sst_user credentials ...
0
votes
1
answer
289
views
Tyring to access MariaDB running in a docker container on a remote machine
I can't seem to remotely connect to my database, via SSH tunnel. I'm relatively new to all this, so I was hoping someone might be able to give me some pointers.
I've got a cloud server on which I've ...
0
votes
0
answers
27
views
Live database migration MariaDB 10.5 to MySQL 8.0
I need to move a busy OLTP database from self hosted MariaDB 10.5 to Google Cloud SQL for MySQL 8.0 with minimal downtime.
The source is a self managed VM instance in Googles Cloud with replicas, ...
1
vote
0
answers
274
views
MariaDB io_uring_queue_init() failed with errno 1 with kernel version 6.2.0-1018
I am running MariaDB using the official docker hub image: mariadb:lts
(this is MariaDB 10.11.6-MariaDB-1:10.11.6+maria~ubu2204 source revision fecd78b83785d5ae96f2c6ff340375be803cd299)
When the ...
0
votes
0
answers
69
views
Backing up a MySQL/MariaDB database via ZFS snapshots without errors
So I am using zrepl to take snapshots of my production machine and replicate them to a backup server. This also includes MariaDB, it's in it's own dataset with recordsize=16k
I've been testing the ...
0
votes
0
answers
98
views
MariaDB not starting after a server restart
I'm running a LEMP stack for my websites and they were running fine. Monitoring showed that the server wasn't responding to the pings, I restarted it. Now MariaDB service isn't running, my websites ...
0
votes
0
answers
46
views
Can sleeping dockerized mysql processes cause high system load?
I'm in the process of finding out what could cause a huge system load at night. Icinga2 reports a CRITICAL state at 2:15 am:
load average: 49.23, 24.50, 10.24.
I've checked the syslog and found ...
0
votes
2
answers
119
views
Monit complains of checksum failure after MariaDB reinstall and upgrade to newer version
I have a Linode VPS running CentOS 7 and somewhat old versions of web-related services (because code I've written isn't ready for newer versions - I'm planning to build a fresh VPS with new everything ...
0
votes
0
answers
38
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....
0
votes
1
answer
184
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(11)...
1
vote
1
answer
253
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 ...
-2
votes
1
answer
273
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
148
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 ...
0
votes
1
answer
112
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 ...
0
votes
1
answer
91
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 ...
2
votes
2
answers
552
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 ...
0
votes
0
answers
189
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' (...
0
votes
1
answer
205
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 ...
2
votes
1
answer
193
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 ...
0
votes
0
answers
136
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
1k
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 ...
0
votes
1
answer
108
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
vote
1
answer
299
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 ...
2
votes
1
answer
283
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 ...
1
vote
1
answer
72
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
228
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
241
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 ...
0
votes
1
answer
192
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 ...
0
votes
0
answers
215
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....
0
votes
1
answer
639
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 ...
1
vote
0
answers
308
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 ...
2
votes
1
answer
612
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 ...
0
votes
0
answers
205
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"
# ...
0
votes
0
answers
997
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]: ...
1
vote
1
answer
172
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 ...
0
votes
0
answers
94
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 ...
0
votes
0
answers
244
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
150
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 ...
1
vote
0
answers
525
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 ...