[Users] cant remove disks from iscsi domain

[Dafna Ron]

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


-- 
Dafna Ron