Skip to main content

Questions tagged [mariadb]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
18 views

WSREP_SST: [ERROR] Possible timeout in receiving first data from donor in gtid stage

I have deployed Alma Linux 9 and MariaDB 10.11.7 with Galera 4 on two AWS instances and all the ports and firewall rules are open between 2 instances, I set the proper wsrep options and I am still ...
Sandeep's user avatar
  • 121
0 votes
0 answers
38 views

Downgrade MariaDB from 10.11.8 to 10.11.6?

After upgrading MariaDB to 10.11.8, we're experiencing error 1034 when adding or modifying indexes, which is a show stopper for us. I can reliably reproduce the errors on a new table, and the same ...
Kjell Rilbe's user avatar
-1 votes
0 answers
33 views

Can not connect to remote mariadb server

I have 2 servers both running Virtualmin and I’m trying to access a database on Server A from Server B. The firewall allows port 3306 to be open for the IP address of both servers. On Server A, I have ...
Whip's user avatar
  • 258
0 votes
1 answer
108 views

How to exclude `user` column from output of `ps`?

I want to get info about running processes and pass output to script. I have line shows the running MariaDB instance but its user is mysql. Is there a way to get all of ps waxfu output excluding ...
palmasd1's user avatar
0 votes
1 answer
40 views

Mariadb - MySQL server has gone away after 1 second of sleep

I'm receiving errors from Mariadb. This is ok: $db = new mysqli(...); usleep(1000*1000); // 1 second is ok $db->query('SELECT 1'); This is not ok: $db = new mysqli(...); usleep(1001*1000); // 1....
rooobertek's user avatar
0 votes
1 answer
97 views

Postfix check_sender_access not blocking certain addresses

I keep getting spam emails from 'ional.co.uk'. I've got an address based blocking solution which handles all other emails just fine, but somehow this domain keeps getting through. Full files I can add ...
Sarazil's user avatar
2 votes
1 answer
231 views

Can't start MariaDB after replacing 5.6 with 10.4

I have an old VM I use for dev testing - it runs CentOS 7.9 with nginx, PHP, and MariaDB. The MariaDB version was really old (5.6), but it was working well enough for me until today when I wanted to ...
OsakaWebbie's user avatar
1 vote
2 answers
206 views

MariaDB consuming swap on AlmaLinux 9.4

After upgrading from AlmaLinux 9.3 to 9.4, MariaDB started consuming swap more and more on several servers. Using MariaDB 10.11.8. Having vm.swappiness = 1. MySQLTuner 2.5.3 shows: -------- ...
ivp's user avatar
  • 33
0 votes
1 answer
53 views

Mysql filling up disk space, but storage not even on this disk

Have Mysql running on a server, with data, backups and logs each on their own disk. For 2nd time recently the root disk has filled up to 100% which gets cleared the moment that MySQL restarts. This ...
Mark Walker's user avatar
0 votes
0 answers
56 views

MariaDb docker container data recovery

I am using MariaDb for the first time for new project, and I just encountered a problem with container crashing after image update. I have updated MariaDb image to latest version (11.3.2 ), but I do ...
Goran's user avatar
  • 153
0 votes
0 answers
56 views

MariaDb inistialization script

I am trying to set up MariaDB in docker-compose. When initializes, it should have the following: root allowed to connect from anywhere (%) a specific DB created a specific user created the user ...
ZorgoZ's user avatar
  • 119
0 votes
1 answer
76 views

Backup Mariadb from replica

I have cloud server with a MariaDB database that I want to backup. To avoid use the bandwith to transfer locally generated backup files from the cloud service to my backup server, one of the ...
schrodingerscatcuriosity's user avatar
2 votes
1 answer
221 views

mysql high CPU usage /usr/sbin/mariadbd

Our new VPS server for a wordpress website, have high CPU usage for mysql process, 50% CPU usage all the time. We don't have that many visitors and killing the process not working, there another new ...
Julash's user avatar
  • 21
0 votes
0 answers
97 views

mysql_upgrade to MariaDB 10.3.39 fails due to missing tables innodb_table_stats and innodb_index_stats

I recently and successfully upgraded MariaDB from version 5.6 to 10.3.39 (RHEL 7 to 8 upgrade). However, on each start of the DB I get this message: systemd[1]: Starting MariaDB 10.3 database server......
musbur's user avatar
  • 213
0 votes
1 answer
128 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
82 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
158 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
119 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
194 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
90 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
147 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
61 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
972 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
39 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
59 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
95 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
967 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
37 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
1 answer
629 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
123 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
211 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
56 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,265
0 votes
2 answers
160 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
39 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
298 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
475 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
558 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
170 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
196 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
121 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,646
2 votes
2 answers
1k 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
334 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
  • 3
0 votes
1 answer
352 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
  • 180
2 votes
1 answer
244 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
203 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
2 votes
0 answers
2k 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
122 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
564 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
403 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
89 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
2 3 4 5
18