I have an issue with my 4.3 hosted-engine. The /var is full. The directory taking 20G is /var/opt/rh/rh-postgresql10/lib/pgsql/data/base/data/16398 some of those files have size over 1GB. Can they be safely removed? TIA
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. This might free some disk space. There should be an engine-vacuum and a dwh-vacuum commands which do this. -Juhani On Fri, May 7, 2021 at 2:53 PM Pascal D <pascal@butterflyit.com> wrote:
I have an issue with my 4.3 hosted-engine. The /var is full. The directory taking 20G is /var/opt/rh/rh-postgresql10/lib/pgsql/data/base/data/16398
some of those files have size over 1GB. Can they be safely removed?
TIA _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/7JRYG3L5BYXWFM...
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 05:31 44177767 -rw-------. 1 postgres postgres 437M May 7 05:31 44177812 -rw-------. 1 postgres postgres 438M May 7 05:30 44177398 -rw-------. 1 postgres postgres 445M May 7 05:31 44177805.1 -rw-------. 1 postgres postgres 452M May 7 05:31 44177775 -rw-------. 1 postgres postgres 455M May 7 05:31 44177401 -rw-------. 1 postgres postgres 478M May 7 05:31 44177769.2 -rw-------. 1 postgres postgres 486M May 7 05:31 44177734 -rw-------. 1 postgres postgres 498M May 7 05:31 44177772 -rw-------. 1 postgres postgres 574M May 7 05:31 44177773 -rw-------. 1 postgres postgres 589M May 7 05:31 44177399 -rw-------. 1 postgres postgres 616M May 7 05:31 44177758.1 -rw-------. 1 postgres postgres 702M May 7 05:31 44177814 -rw-------. 1 postgres postgres 776M May 7 05:31 44177774 -rw-------. 1 postgres postgres 783M May 7 05:31 44177400 -rw-------. 1 postgres postgres 1010M May 7 05:31 44177394.1 -rw-------. 1 postgres postgres 1.0G Apr 17 03:09 44177805 -rw-------. 1 postgres postgres 1.0G May 7 04:30 44177769.1 -rw-------. 1 postgres postgres 1.0G May 7 04:29 44177769 -rw-------. 1 postgres postgres 1.0G Apr 11 03:08 44177758 -rw-------. 1 postgres postgres 1.0G Apr 28 03:08 44177729 -rw-------. 1 postgres postgres 1.0G Mar 31 03:12 44177394
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 <pascal@butterflyit.com> wrote:
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 05:31 44177767 -rw-------. 1 postgres postgres 437M May 7 05:31 44177812 -rw-------. 1 postgres postgres 438M May 7 05:30 44177398 -rw-------. 1 postgres postgres 445M May 7 05:31 44177805.1 -rw-------. 1 postgres postgres 452M May 7 05:31 44177775 -rw-------. 1 postgres postgres 455M May 7 05:31 44177401 -rw-------. 1 postgres postgres 478M May 7 05:31 44177769.2 -rw-------. 1 postgres postgres 486M May 7 05:31 44177734 -rw-------. 1 postgres postgres 498M May 7 05:31 44177772 -rw-------. 1 postgres postgres 574M May 7 05:31 44177773 -rw-------. 1 postgres postgres 589M May 7 05:31 44177399 -rw-------. 1 postgres postgres 616M May 7 05:31 44177758.1 -rw-------. 1 postgres postgres 702M May 7 05:31 44177814 -rw-------. 1 postgres postgres 776M May 7 05:31 44177774 -rw-------. 1 postgres postgres 783M May 7 05:31 44177400 -rw-------. 1 postgres postgres 1010M May 7 05:31 44177394.1 -rw-------. 1 postgres postgres 1.0G Apr 17 03:09 44177805 -rw-------. 1 postgres postgres 1.0G May 7 04:30 44177769.1 -rw-------. 1 postgres postgres 1.0G May 7 04:29 44177769 -rw-------. 1 postgres postgres 1.0G Apr 11 03:08 44177758 -rw-------. 1 postgres postgres 1.0G Apr 28 03:08 44177729 -rw-------. 1 postgres postgres 1.0G Mar 31 03:12 44177394
_______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/3NKP4YSVXJLNP5...
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?
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?
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/HRTNYTZXYCRBNK...
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 55GB unused. Using basic disk tools, you can add that space to the root file-system. Use 'fdisk' to create another partition from the unused space, and tag it for Linux LVM. Use 'pvcreate' to mark it for LVM. Use 'vgextend' to add it to the volume group that hold the root file-system. Use 'lvextend' to extend the root file-system to the gained volume-group space. -----Original Message----- From: Pascal D <pascal@butterflyit.com> Sent: Friday, May 7, 2021 6:52 AM To: users@ovirt.org Subject: [ovirt-users] hosted-engine /var full I have an issue with my 4.3 hosted-engine. The /var is full. The directory taking 20G is /var/opt/rh/rh-postgresql10/lib/pgsql/data/base/data/16398 some of those files have size over 1GB. Can they be safely removed? TIA _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/7JRYG3L5BYXWFM...
participants (3)
-
Juhani Rautiainen -
Matthew.Stier＠fujitsu.com -
Pascal D