Bug 738999
Summary: | Error deleting a virtual server profile: column "confirmed" is of type smallint but expression is of type boolean | ||||||
---|---|---|---|---|---|---|---|
Product: | [Community] Spacewalk | Reporter: | Holger Schmitt <holger.schmitt> | ||||
Component: | Server | Assignee: | Michael Mráka <mmraka> | ||||
Status: | CLOSED CURRENTRELEASE | QA Contact: | Red Hat Satellite QA List <satqe-list> | ||||
Severity: | unspecified | Docs Contact: | |||||
Priority: | unspecified | ||||||
Version: | 1.5 | CC: | slukasik | ||||
Target Milestone: | --- | ||||||
Target Release: | --- | ||||||
Hardware: | x86_64 | ||||||
OS: | Linux | ||||||
Whiteboard: | |||||||
Fixed In Version: | spacewalk-backend-1.6.39-1 | Doc Type: | Bug Fix | ||||
Doc Text: | Story Points: | --- | |||||
Clone Of: | Environment: | ||||||
Last Closed: | 2011-12-22 16:48:56 UTC | Type: | --- | ||||
Regression: | --- | Mount Type: | --- | ||||
Documentation: | --- | CRM: | |||||
Verified Versions: | Category: | --- | |||||
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
Cloudforms Team: | --- | Target Upstream Version: | |||||
Embargoed: | |||||||
Bug Depends On: | |||||||
Bug Blocks: | 723481 | ||||||
Attachments: |
|
Hi Holger, I can't reproduce the bug. What's exactly 'a virtual server'? Is it a system (registered to spacewalk) with virtualization entitlement? Or virtualization platform entitlement? Or is it a virtual guest? Should the host on which the guest is running be also managed by spacewalk? Reproducer: 1) register virtual host to spacewalk 2) register a guest running on this host 3) check Systems -> <virt-host> -> Virtualization whether spacewalk know about host<->guest relation 4) click on guest and "delete host" Fixed in spacewalk naster by commit 50eea0912d7d1fefe970968d5885f8982ff3502d 738999 - VirtualInstance.confirmed is number not boolean commit 36208823bf8ecda8f4bc1376be4e8e69f4e0f2a6 738999 - aliases in update don't work fixing [Fri Nov 11 08:38:15 2011] [error] SQL Error generated: ('column "rvii" of relation virtualinstanceinfo" does not exist\\nLINE 3: SET rvii.state=(\\n ^\\n', 0, '\\n UPDATE rhnVirtualInstanceInfo rvii\\n SET rvii.state=(\\n SELECT rvis.id \\n FROM rhnVirtual anceState rvis\\n WHERE rvis.label=%(state)s\\n )\\n WHERE\\n rvii.instance_id IN (\\n SELECT rvi.id\ FROM rhnVirtualInstance rvi\\n WHERE rvi.confir 0)\\n ') Spacewalk 1.6 has been released. |
Created attachment 523533 [details] Tomcat log When I try to delete the profile of a virtual server an internal error occurre. Version-Release number of selected component (if applicable): - Spacewalk 1.5 - on Scientific Linux 6 X86_64 - Postgresql DB How reproducible: On every try to delete the server profile Steps to Reproduce: 1. On Spacewalk web frontent click on server profile 2. Click on "delete system" 3. Confirm with "Delete Profile" Actual results: - Website: InternalServer Error - Tomcat log: ERROR: column "confirmed" is of type smallint but expression is of type boolean Expected results: - Deletion of the selected server profile Additional info: - See attachment for tomcat log