[ovirt-users] Re: hosted-engine /var full

2021-05-09 Thread matthew.st...@fujitsu.com
Appliance hosted-engine on block storage (fc,iscsi). Have you checked that you are not wasting space on the disk itself? When I setup my hosted-engine, I created a 100GB lun, and told the setup routine to make a 85GB disk, which it did, however the appliance only used 30GB of that, leaving

[ovirt-users] Re: hosted-engine /var full

2021-05-07 Thread Pascal D
For anyone who encounter the same problem I followed this thread and was able to recover 15G in my /var. I will be keeping an eye on it from now on. Thank you Juhani for your help https://lists.ovirt.org/archives/list/users@ovirt.org/message/HRTNYTZXYCRBNKVOU6DWBVQU6VIL5M7Y/

[ovirt-users] Re: hosted-engine /var full

2021-05-07 Thread Pascal D
is it safe to systemctl stop ovirt-engine-dwhd on a running hosted-engine will running subsequently dwh-vacuum reclaim any space without adding any while doing it? ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to

[ovirt-users] Re: hosted-engine /var full

2021-05-07 Thread Pascal D
I had to add a file in /etc/ld.conf.d called pgsql.conf with /opt/rh/rh-postgresql10/root/usr/lib64 to be able to run dwh_vacuum but that failed too. Maybe not enough room to clean How do I disable and remove dwh or move it to a different vm? ___ Users

[ovirt-users] Re: hosted-engine /var full

2021-05-07 Thread Juhani Rautiainen
Finding out what table is behind those files is harder. But if you want to know this should work: https://www.2ndquadrant.com/en/blog/postgresql-filename-to-table/. -Juhani On Fri, May 7, 2021 at 3:35 PM Pascal D wrote: > > Thank you. I tried engine-vacuum but that didn't do anything. I tried

[ovirt-users] Re: hosted-engine /var full

2021-05-07 Thread Pascal D
Thank you. I tried engine-vacuum but that didn't do anything. I tried also dwh-vacuum but I got libq.si.rh-postgresql10-5 cannot open shared object file. No such file or directory Those files seem to be growing every day. Not sure what they are for? -rw---. 1 postgres postgres 436M May 7

[ovirt-users] Re: hosted-engine /var full

2021-05-07 Thread Juhani Rautiainen
Hi! Those seem to be Postgres database files. You'll either destroy the database or cause serious damage to it if you remove them. If you wan't those cleared you should identify tables that can be trimmed and then vacuum the database. At first I would try to do a full vacuum of the databases.