Re: [ovirt-users] oVirt Manager problem
- Original Message - From: Massimo Mad mad196...@gmail.com To: users@ovirt.org Sent: Wednesday, February 25, 2015 11:14:28 AM Subject: [ovirt-users] oVirt Manager problem Hi, Here is the result of the command actually tables audit_log are very large . What can I do to prevent the file system fills up ? It seems that the total objects (tables and indices) around audit_log table is 2GB. You can control the number of entries in this table by setting a shorter period for keeping data in that table. The default is 30 days. You can check by: engine-config -g AuditLogAgingThreshold and if wish to set a smaller value for days to keep, i.e for a week: engine-config -s AuditLogAgingThreshold=7 and restart the ovirt-engine to take effect. However, I'm curious if there is some flooding of a certain event-log entry in that table which might cause this table to increase to that volume unless it reflects the actual workload of the system. psql engine -c SELECT nspname || '.' || relname AS relation, pg_size_pretty(pg_relation_size(C.oid)) AS size FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) WHERE nspname NOT IN ('pg_catalog', 'information_schema') ORDER BY pg_relation_size(C.oid) DESC LIMIT 20; relation | size --+- public.audit_log | 826 MB public.idx_audit_correlation_id | 159 MB public.idx_audit_log_job_id | 114 MB public.idx_audit_log_storage_domain_name | 114 MB public.idx_audit_log_user_name | 114 MB public.idx_audit_log_vm_name | 114 MB public.idx_audit_log_storage_pool_name | 114 MB public.idx_audit_log_vds_name | 114 MB public.idx_audit_log_vm_template_name | 113 MB public.pk_audit_log | 90 MB public.idx_audit_log_log_time | 90 MB pg_toast.pg_toast_2618 | 1336 kB public.vm_dynamic | 680 kB public.vm_statistics | 496 kB public.disk_image_dynamic | 288 kB public.vds_interface_statistics | 256 kB public.vm_device | 208 kB public.vds_dynamic | 128 kB pg_toast.pg_toast_2619 | 120 kB public.pk_disk_image_dynamic | 104 kB (20 rows) Regards Massimo ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[ovirt-users] oVirt Manager problem
Hi, Here is the result of the command actually tables audit_log are very large . What can I do to prevent the file system fills up? psql engine -c SELECT nspname || '.' || relname AS relation, pg_size_pretty(pg_relation_size(C.oid)) AS size FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) WHERE nspname NOT IN ('pg_catalog', 'information_schema') ORDER BY pg_relation_size(C.oid) DESC LIMIT 20; relation | size --+- public.audit_log | 826 MB public.idx_audit_correlation_id | 159 MB public.idx_audit_log_job_id | 114 MB public.idx_audit_log_storage_domain_name | 114 MB public.idx_audit_log_user_name | 114 MB public.idx_audit_log_vm_name | 114 MB public.idx_audit_log_storage_pool_name | 114 MB public.idx_audit_log_vds_name| 114 MB public.idx_audit_log_vm_template_name| 113 MB public.pk_audit_log | 90 MB public.idx_audit_log_log_time| 90 MB pg_toast.pg_toast_2618 | 1336 kB public.vm_dynamic| 680 kB public.vm_statistics | 496 kB public.disk_image_dynamic| 288 kB public.vds_interface_statistics | 256 kB public.vm_device | 208 kB public.vds_dynamic | 128 kB pg_toast.pg_toast_2619 | 120 kB public.pk_disk_image_dynamic | 104 kB (20 rows) Regards Massimo ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[ovirt-users] oVirt Manager problem
I have a problem on my oVirt manager, the problem is that the directory /var/lib/pgsql/data fills. Initially thinking that my file system /var/log 2Gb was too small now have increased to 4Gb and is refilled, i have increased again to 5 Gb and is refilled again. Why ? I have implemented the backup of the manager with the script backup.sh, this could be the cause of the problem ? Regards Massimo ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[ovirt-users] oVirt Manager problem
I have a problem on my oVirt manager, the problem is that the directory /var/lib/pgsql/data/base fills. Initially thinking that my file system /var/log 2Gb was too small now have increased to 4Gb and is refilled, i have increased again to 5 Gb and is refilled again. Why ? I have implemented the backup of the manager with the script backup.sh, this could be the cause of the problem ? Sorry in the script backup.sh there is this #!/bin/bash /usr/bin/engine-backup --mode=backup --scope=all --file=/root/ovirt-engine-backups/$(hostname)-backup-$(date +%A).tar.bz2 --log=/var/log/ovirt-engine-backups.log ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] oVirt Manager problem
Hi Massimo, Please check what is going on with your postgresql DB. 1) Log into the ovirt-engine VM 2) su - postgres 3) query table sizes with: psql engine -c SELECT nspname || '.' || relname AS relation, pg_size_pretty(pg_relation_size(C.oid)) AS size FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) WHERE nspname NOT IN ('pg_catalog', 'information_schema') ORDER BY pg_relation_size(C.oid) DESC LIMIT 20; Probably it's the audit_log table. On 24-02-2015 18:11, Massimo Mad wrote: I have a problem on my oVirt manager, the problem is that the directory /var/lib/pgsql/data fills. Initially thinking that my file system /var/log 2Gb was too small now have increased to 4Gb and is refilled, i have increased again to 5 Gb and is refilled again. Why ? I have implemented the backup of the manager with the script backup.sh, this could be the cause of the problem? Regards Massimo ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Ovirt Manager Problem
On Thursday, February 12, 2015 11:06:20 AM Darrell Budic wrote: Also check your auth backend, especially if you’re using the old AAA. I’ve found that with freeipa, for example, if one of my ipa hosts is down (specifically the “first” one for the ovirt engine machine), the engine GUI lags badly waiting for auth before failing over to the second ipa host. It does this for pretty much everything, unfortunately. -Darrell Also I have found that if you don't have the engine in DNS or /etc/hosts properly configured things get really slow for some reason. Make sure the engine can resolve itself. On Feb 12, 2015, at 9:31 AM, Martin Pavlík mpav...@redhat.com wrote: Hello Massimo, just a wild guess. Is it possible that engine machine has its RAM full and is forced to use SWAP? Or some other resources on it are exhausted? HTH M. On 11 Feb 2015, at 17:30, Dan Yasny dya...@gmail.com wrote: What are you using to access the manager UI on the client (OS and browser)? On Wed, Feb 11, 2015 at 11:25 AM, Massimo Mad mad196...@gmail.com wrote: Hi, i have a strange problem,my manager is very slow and with the gui I can not do anything on the vm and the host, but the vm are ok. I tried to look at the log, but I have not seen anything that would explain the problem. Regards Massimo ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Ovirt Manager Problem
Hello Massimo, just a wild guess. Is it possible that engine machine has its RAM full and is forced to use SWAP? Or some other resources on it are exhausted? HTH M. On 11 Feb 2015, at 17:30, Dan Yasny dya...@gmail.com wrote: What are you using to access the manager UI on the client (OS and browser)? On Wed, Feb 11, 2015 at 11:25 AM, Massimo Mad mad196...@gmail.com wrote: Hi, i have a strange problem,my manager is very slow and with the gui I can not do anything on the vm and the host, but the vm are ok. I tried to look at the log, but I have not seen anything that would explain the problem. Regards Massimo ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users signature.asc Description: Message signed with OpenPGP using GPGMail ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Ovirt Manager Problem
Also check your auth backend, especially if you’re using the old AAA. I’ve found that with freeipa, for example, if one of my ipa hosts is down (specifically the “first” one for the ovirt engine machine), the engine GUI lags badly waiting for auth before failing over to the second ipa host. It does this for pretty much everything, unfortunately. -Darrell On Feb 12, 2015, at 9:31 AM, Martin Pavlík mpav...@redhat.com wrote: Hello Massimo, just a wild guess. Is it possible that engine machine has its RAM full and is forced to use SWAP? Or some other resources on it are exhausted? HTH M. On 11 Feb 2015, at 17:30, Dan Yasny dya...@gmail.com wrote: What are you using to access the manager UI on the client (OS and browser)? On Wed, Feb 11, 2015 at 11:25 AM, Massimo Mad mad196...@gmail.com wrote: Hi, i have a strange problem,my manager is very slow and with the gui I can not do anything on the vm and the host, but the vm are ok. I tried to look at the log, but I have not seen anything that would explain the problem. Regards Massimo ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Ovirt Manager Problem
What are you using to access the manager UI on the client (OS and browser)? On Wed, Feb 11, 2015 at 11:25 AM, Massimo Mad mad196...@gmail.com wrote: Hi, i have a strange problem,my manager is very slow and with the gui I can not do anything on the vm and the host, but the vm are ok. I tried to look at the log, but I have not seen anything that would explain the problem. Regards Massimo ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[ovirt-users] Ovirt Manager Problem
Hi, i have a strange problem,my manager is very slow and with the gui I can not do anything on the vm and the host, but the vm are ok. I tried to look at the log, but I have not seen anything that would explain the problem. Regards Massimo ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users