On 08/21/2013 04:10 PM, Dafna Ron wrote:
there is a is an exception in the log related to a quota calculation
2013-08-21 17:52:32,694 ERROR [org.ovirt.engine.core.utils.timer.SchedulerUtilQu artzImpl] (DefaultQuartzScheduler_Worker-7) failed to invoke sceduled method upd ateQuotaCache: java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor175.invoke(Unknown Source) [:1.7.0 _25] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) [rt.jar:1.7.0_25] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25] at org.ovirt.engine.core.utils.timer.JobWrapper.execute(JobWrapper.java: 60) [scheduler.jar:] at org.quartz.core.JobRunShell.run(JobRunShell.java:213) [quartz.jar:] at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j ava:557) [quartz.jar:] Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCal lback; bad SQL grammar [select * from calculateallstorageusage()]; nested excep tion is org.postgresql.util.PSQLException: ERROR: column "quota_limitation.quota _id" must appear in the GROUP BY clause or be used in an aggregate function Where: PL/pgSQL function "calculateallstorageusage" line 3 at RETURN QUERY
in any case this is a bug. I'm adding Doron to this mail, perhaps this was reported in the past and already solved in later versions. if not it should be reported and fixed.
Dafna
If I'm not mistaken, it looks like this bug: https://bugzilla.redhat.com/show_bug.cgi?id=905891 Greg
On 08/21/2013 05:26 PM, Yura Demchenko wrote:
21.08.2013 19:18, Dafna Ron пишет:
from the logs it appears to be a quota issue. do you have quota enabled?
Yes, quota in "enforced" mode. But VMs/disks in question belongs to "unlimited" quota (defined quota policy with no limits on storage/cpu/ram)
On 08/21/2013 03:20 PM, Yuriy Demchenko wrote:
Hi,
I've recently encountered a problem with removing disks from iscsi domain in my test lab - just cant remove any. Remove operation fails with message "User admin@internal failed to initiate removing of disk pg-slave1_opt from domain iscsi-store" and re-elections of SPM. After that - disk is marked as "illegal" in ovirt webinterface, however, it is _in fact_ removed from storage - lvdisplay doesn't show it and free space is updated correctly. And this happens with just about every disk/vm i try to remove.
ovirt 3.2.2-el6 centos 6.4 vdsm-4.10.3-17.el6 lvm2-2.02.98-9.el6
Any tips? logs in attach
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users