This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Flush logs hangs

We have a 3-node Galera cluster running with Mariadb "Server version: 10.1.22-MariaDB MariaDB Server" . running on Centos 7.

$ uname -a Linux xxxxxxxxxxxxxx 3.10.0-693.21.1.el7.x86_64 #1 SMP Wed Mar 7 19:03:37 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

When I issue a "flush logs" the statement hangs.

$ mysql -umysql_admin -p* -e 'show processlist' +---------+-------------+-----------------------+------+---------+---------+--------------------+------------------+----------+

IdUserHostdbCommandTimeStateInfoProgress

+---------+-------------+-----------------------+------+---------+---------+--------------------+------------------+----------+ ...

1593327mysql_adminlocalhostNULLQuery2748initflush logs0.000

... +---------+-------------+-----------------------+------+---------+---------+--------------------+------------------+----------+

I can't find any reason why this happens. All filesystems have enough space.

Any ideas what can cause this?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.