[Users] cant remove disks from iscsi domain

[Greg Padgett]

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 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
>>>
>>>
>>
>
>