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