Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1244154

Summary:	Column "v_dedicated_vm_for_vds" does not exist
Product:	Red Hat Enterprise Virtualization Manager	Reporter:	David Caro <dcaroest>
Component:	ovirt-engine	Assignee:	Dudi Maroshi <dmaroshi>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Nikolai Sednev <nsednev>
Severity:	high	Docs Contact:
Priority:	urgent
Version:	3.6.3	CC:	amureini, dfediuck, eedri, gklein, istein, lpeer, lsurette, mgoldboi, pmatyas, rbalakri, rgolan, Rhev-m-bugs, srevivo, ykaul
Target Milestone:	ovirt-3.6.0-rc	Keywords:	AutomationBlocker, Triaged
Target Release:	3.6.0
Hardware:	x86_64
OS:	Linux
Whiteboard:
Fixed In Version:	3.6.0-4 alpha3	Doc Type:	Bug Fix
Doc Text:	Cause: ovirt engine setup failed Consequence: postgres version doesn't support the syntax used for the stored procedure Fix: fix the procedure setup to use the supported syntax Result: ovirt engine setup succeeds.	Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-04-20 01:38:29 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	SLA	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Comment 1 Allon Mureinik 2015-07-19 07:35:27 UTC

The usage of v_dedicated_vm_for_vds was recently added by the SLA team, so setting that as the whiteboard for them to investigate.

I've also tried reproducing on the current master (0a4e1592e00dbaa990a46a5e152c92429b9fc9e9), and was unable to.

Comment 2 Yedidyah Bar David 2015-07-20 14:30:04 UTC

*** Bug 1244630 has been marked as a duplicate of this bug. ***

Comment 3 Eyal Edri 2015-07-21 06:06:36 UTC

This is currently failing all CI on 3.6, since setup isn't working,
please provide an urgent fix or revert the change.

thanks.

Comment 4 Dudi Maroshi 2015-07-22 08:31:26 UTC

Reason for the bug:
1. Using stored procedure with SQL language. The norm is PLPGSQL language
2. Stored procedure with SQL language have different argument referencing.
3. Not detected by DAO tests.

Solution:
Make the stored procedure use  PLPGSQL language.

Comment 5 Nikolai Sednev 2015-09-06 14:49:50 UTC

Please provide more steps for reproduction, link http://jenkins-ci.eng.lab.tlv.redhat.com/view/0%20Unstable%203.6/job/rhevm_3.6_el6-engine_el7-host_automation_coretools_two_hosts_restapi_vms_nfs_rest_factory/1310/ 
returns "HTTP ERROR 404

Problem accessing /view/0%20Unstable%203.6/job/rhevm_3.6_el6-engine_el7-host_automation_coretools_two_hosts_restapi_vms_nfs_rest_factory/1310/. Reason:

    Not Found
Powered by Jetty://
"

Comment 6 Dudi Maroshi 2015-09-07 06:21:28 UTC

(In reply to Nikolai Sednev from comment #5)
> Please provide more steps for reproduction, link
> http://jenkins-ci.eng.lab.tlv.redhat.com/view/0%20Unstable%203.6/job/rhevm_3.
> 6_el6-engine_el7-
> host_automation_coretools_two_hosts_restapi_vms_nfs_rest_factory/1310/ 
> returns "HTTP ERROR 404
> 
> Problem accessing
> /view/0%20Unstable%203.6/job/rhevm_3.6_el6-engine_el7-
> host_automation_coretools_two_hosts_restapi_vms_nfs_rest_factory/1310/.
> Reason:
> 
>     Not Found
> Powered by Jetty://
> "

Greetings,
Steps to reproduce the problem.
1. Create VM with no storage.
2. Add a dedicated/preferred host for the VM to start on. Set migration to manual or automatic. 
3. Save the VM.
4. Modify dedicated/preferred to another host for the VM to start on.
5. Save the VM.
Save fails with error message about database failure.

Comment 7 Nikolai Sednev 2015-09-07 13:10:02 UTC

Works for me on these components:
ovirt-host-deploy-java-1.4.0-0.0.5.master.el6ev.noarch
qemu-guest-agent-0.12.1.2-2.479.el6.x86_64
ovirt-host-deploy-1.4.0-0.0.5.master.el6ev.noarch
ovirt-vmconsole-proxy-1.0.0-0.0.1.master.el6ev.noarch
rhevm-3.6.0-0.13.master.el6.noarch
ovirt-engine-extension-aaa-jdbc-0.0.0-6.el6ev.noarch
ovirt-vmconsole-1.0.0-0.0.1.master.el6ev.noarch
Linux version 2.6.32-573.el6.x86_64 (mockbuild.eng.bos.redhat.com) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-16) (GCC) ) #1 SMP Wed Jul 1 18:23:37 EDT 2015


libvirt-client-1.2.17-6.el7.x86_64
mom-0.5.0-1.el7ev.noarch
ovirt-vmconsole-host-1.0.0-0.0.1.master.el7ev.noarch
sanlock-3.2.4-1.el7.x86_64
qemu-kvm-rhev-2.3.0-22.el7.x86_64
vdsm-4.17.5-1.el7ev.noarch
ovirt-vmconsole-1.0.0-0.0.1.master.el7ev.noarch
Linux version 3.10.0-306.0.1.el7.x86_64 (mockbuild.eng.bos.redhat.com) (gcc version 4.8.3 20140911 (Red Hat 4.8.3-9) (GCC) ) #1 SMP Wed Aug 19 16:06:58 EDT 2015


For reproduction I followed the reproduction instructions shared in comment #6 and also I then tried to start the VM in all 3 variations, while my setup had 2 hosts and remote VM based engine. I've tried to set to H1 and then to start the VM-PASS, powered off->set to H2->powered on->PASS, then powered off->set to both H1&H2->powered on->PASS.