Questions tagged [mariadb]

MariaDB is a drop-in replacement for Oracle(R) MySQL(TM).

Filter by
Sorted by
Tagged with
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-...
Max Müller's user avatar
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 ...
Toby Osbourn's user avatar
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 ...
nitro64's user avatar
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 ...
Andrew Gable's user avatar
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 ...
sidboy55555's user avatar
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 ...
V1pr's user avatar
  • 5
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, ...
neilgee's user avatar
  • 109
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-...
marhyno's user avatar
  • 103
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 ...
stepping stone AG's user avatar
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 ...
Nuramon's user avatar
  • 150
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 ...
shubham's user avatar
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 ...
Mike's user avatar
  • 11
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 ...
newjunkcity's user avatar
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, ...
Claus Koch's user avatar
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 ...
g.pickardou's user avatar
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 ...
Bento's user avatar
  • 101
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 ...
Ali's user avatar
  • 1
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 ...
digijay's user avatar
  • 1,215
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 ...
OsakaWebbie's user avatar
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....
Danny's user avatar
  • 1
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)...
LinuxGnut's user avatar
  • 217
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 ...
Christoforos's user avatar
-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 ...
Crypto Coupons's user avatar
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 ...
Badb0y's user avatar
  • 115
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 ...
CaptainSkyfish's user avatar
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 ...
Nick's user avatar
  • 4,656
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 ...
trejder's user avatar
  • 163
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' (...
RAN55's user avatar
  • 1
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 ...
theking2's user avatar
  • 181
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 ...
Karsten S.'s user avatar
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 ...
Tung-Han Hsieh's user avatar
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 ...
Benoît Fayolle's user avatar
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]: ...
unknown's user avatar
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 ...
Harry Potter's user avatar
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 ...
milanbalazs's user avatar
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 ...
Gregorio Pellegrino's user avatar
-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/...
dr.ipkins's user avatar
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 ...
Bert's user avatar
  • 1,066
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 ...
MeSo2's user avatar
  • 274
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....
MeSo2's user avatar
  • 274
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 ...
Clueless's user avatar
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 ...
GingkoFr's user avatar
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 ...
GingkoFr's user avatar
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" # ...
RAN55's user avatar
  • 1
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]: ...
DanRan's user avatar
  • 123
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 ...
DanRan's user avatar
  • 123
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 ...
jotyhista's user avatar
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 ...
Ashkan Mobayen Khiabani's user avatar
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 ...
Centaro's user avatar
  • 19
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 ...
Sukru Ozdemir's user avatar

1
2 3 4 5
18