Bug 1087028

Summary: Query GetStorageDomainByNameQuery failure: bad SQL
Product: Red Hat Enterprise Virtualization Manager Reporter: Ohad Basan <obasan>
Component: ovirt-engineAssignee: Barak <bazulay>
Status: CLOSED CURRENTRELEASE QA Contact: Pavel Novotny <pnovotny>
Severity: high Docs Contact:
Priority: urgent    
Version: 3.5.0CC: aberezin, amureini, bazulay, eedri, gklein, iheim, lpeer, oourfali, pnovotny, pstehlik, rbalakri, Rhev-m-bugs, yeylon
Target Milestone: ---Keywords: AutomationBlocker
Target Release: 3.5.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: infra
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-02-17 17:09:59 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1142923, 1156165    

Description Ohad Basan 2014-04-13 08:01:58 UTC 
Description of problem:
exporting a vm fails on GetStorageDomainByNameQuery:

2014-04-10 12:46:33,606 ERROR [org.ovirt.engine.core.bll.storage.GetStorageDomainByNameQuery] (ajp-/127.0.0.1:8702-3) Query GetStorageDomainByNameQuery failed. Exception message is PreparedStatementCallback; bad SQL grammar [select * from  getstorage_domain_staticbynamefiltered(?, ?)]; nested exception is org.postgresql.util.PSQLException: ERROR: function getstorage_domain_staticbynamefiltered(character varying, uuid) does not exist
Comment 3 Allon Mureinik 2014-04-24 13:32:11 UTC 
Liran,

The usage of this function was introduced by 88756e3897ba467eb50055a7dda0c1afb11295d0, which is a solution for bug 1061175 which you handled.

Can you please take a look at this?
Thanks.
Comment 4 Liran Zelkha 2014-04-24 13:43:18 UTC 
Sure. I'll fix it.
Comment 6 Pavel Novotny 2014-10-23 14:25:28 UTC 
Verified in rhevm-3.5.0-0.17.beta.el6ev.noarch (vt7).

Exporting a VM via REST API now works fine, no SQL errors were encountered.
Comment 8 Eyal Edri 2015-02-17 17:09:59 UTC 
rhev 3.5.0 was released. closing.