← Back to team overview

maria-discuss team mailing list archive

Re: 485 GB of galera.page.xxxxx files never deleted!?

 

Because I'm on 10.6.7 under Ubuntu 22.0.4.1, I've already created a new issue: https://jira.mariadb.org/browse/MDEV-29223

I'm waiting end of business hours to restart server, possibly switching active cluster to spare one.


-----Message d'origine-----
De : Daniel Black <daniel@xxxxxxxxxxx> 
Envoyé : lundi 1 août 2022 13:37
À : Cédric Counotte <cedric.counotte@xxxxxxxxxx>
Cc : Mailing-List mariadb <maria-discuss@xxxxxxxxxxxxxxxxxxx>
Objet : Re: [Maria-discuss] 485 GB of galera.page.xxxxx files never deleted!?

Like:

https://dba.stackexchange.com/questions/306131/mariadb-galera-cluster-filling-disk-with-gcache-page-files
and linked MDEVs

I haven't followed your other thread to identify  your versions used.
If the linked MDEVs aren't relevant to your newer version, please create a new issue.

Comments on closed issues are almost always going to be forgotten.

On Mon, Aug 1, 2022 at 4:53 PM Cédric Counotte <cedric.counotte@xxxxxxxxxx> wrote:
>
> Hello all,
>
>
>
> Again, I need help with a galera cluster.
>
>
>
> One of the galera has about 3800 files named galera.page.0000xxx (not galera.cache) of 128MB each stored in /var/lib/mysql, which is about twice the size of the total DB !? and it keeps creating files every minute, never deleting any of them for 3 days.
>
>
>
> The other nodes have no such files, but only one galera.cache file of 128MB.
>
>
>
> I tried deleting some of them, but it doesn’t reclaim disk space and in about 2 days disk would be entirely filled and the server would obviously stop functioning if not the entire cluster.
>
>
>
> Can’t find any information about galera.page files but only galera.cache file so I’m not sure it’s related. As far as I could tell those are used when replicating information between node? Does that mean that the changes on that node are not replicated to others?
>
>
>
> Any help would be appreciated.
>
>
>
> C.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp

References