Re: [Users] cant remove disks from iscsi domain

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

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(a)ovirt.org >>> http://lists.ovirt.org/mailman/listinfo/users >> >> >