Bug 655519

Summary:	ISE: publishing errata on spacewalk w/postgresql fails
Product:	[Community] Spacewalk	Reporter:	Luc de Louw <luc>
Component:	Server	Assignee:	Michael Mráka <mmraka>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	low	Docs Contact:
Priority:	low
Version:	1.2
Target Milestone:	---
Target Release:	---
Hardware:	x86_64
OS:	Linux
Whiteboard:
Fixed In Version:	spacewalk-java-1.3.11-1	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2011-02-08 08:41:08 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:	653453

Description Luc de Louw 2010-11-21 13:42:23 UTC

Description of problem:
When publishing an errata (with 0 packages because of https://bugzilla.redhat.com/show_bug.cgi?id=655515) one gets a ISE

Version-Release number of selected component (if applicable):
Spacewalk 1.2

How reproducible:
Always

Steps to Reproduce:
1. Select channel on https://spacewalk.example.com/rhn/errata/manage/SelectChannels.do?eid=XY
2. Click on "Publish Errata"
3. ISE
4. Erratum is actually published
  
Actual results:
ISE

Expected results:
Avoid ISE

Additional info:

Is is useless to publish an erratum w/o packages, but is is working with Orcale XE, so this is considered to be connected to POstgreSQL.

PostgreSQL log shows the following:

ov 21 13:35:00 spacewalk-pg postgres[6014]: [8-1] ERROR:  cross-database references are not implemented: pe2.evr.as_vre_simple
Nov 21 13:35:00 spacewalk-pg postgres[6014]: [8-2] STATEMENT:  SELECT P1.id,
Nov 21 13:35:00 spacewalk-pg postgres[6014]: [8-3]             PN.name,
Nov 21 13:35:00 spacewalk-pg postgres[6014]: [8-4]             PE2.evr.as_vre_simple() || '.' || PA2.label AS current_nvrea,
Nov 21 13:35:00 spacewalk-pg postgres[6014]: [8-5]             PE1.evr.as_vre_simple() || '.' || PA1.label AS new_nvrea
Nov 21 13:35:00 spacewalk-pg postgres[6014]: [8-6]      FROM rhnPackage P1,
Nov 21 13:35:00 spacewalk-pg postgres[6014]: [8-7]           rhnPackageEVR PE1,
Nov 21 13:35:00 spacewalk-pg postgres[6014]: [8-8]           rhnPackageArch PA1,
Nov 21 13:35:00 spacewalk-pg postgres[6014]: [8-9]           rhnChannelNewestPackage CNP,
Nov 21 13:35:00 spacewalk-pg postgres[6014]: [8-10]          rhnPackageEVR PE2,
Nov 21 13:35:00 spacewalk-pg postgres[6014]: [8-11]          rhnPackageArch PA2,
Nov 21 13:35:00 spacewalk-pg postgres[6014]: [8-12]          rhnPackageName PN,
Nov 21 13:35:00 spacewalk-pg postgres[6014]: [8-13]          rhnErrataPackage EP
Nov 21 13:35:00 spacewalk-pg postgres[6014]: [8-14]     WHERE EP.errata_id = $1
Nov 21 13:35:01 spacewalk-pg postgres[6014]: [8-15]       AND P1.id = EP.package_id
Nov 21 13:35:01 spacewalk-pg postgres[6014]: [8-16]       AND CNP.channel_id = $2
Nov 21 13:35:01 spacewalk-pg postgres[6014]: [8-17]       AND P1.name_id = CNP.name_id
Nov 21 13:35:01 spacewalk-pg postgres[6014]: [8-18]       AND p1.package_arch_id = CNP.package_arch_id
Nov 21 13:35:01 spacewalk-pg postgres[6014]: [8-19]       AND PE1.id = P1.evr_id
Nov 21 13:35:01 spacewalk-pg postgres[6014]: [8-20]       AND PA1.id = P1.package_arch_id
Nov 21 13:35:01 spacewalk-pg postgres[6014]: [8-21]       AND PE2.id = CNP.evr_id
Nov 21 13:35:01 spacewalk-pg postgres[6014]: [8-22]       AND PA2.id = CNP.package_arch_id
Nov 21 13:35:01 spacewalk-pg postgres[6014]: [8-23]       AND PN.id = P1.name_id
Nov 21 13:35:01 spacewalk-pg postgres[6014]: [8-24]       AND rpm.vercmp(PE1.epoch, PE1.version, PE1.release, PE2.epoch, PE2.version, PE2.release) > 0

Comment 1 Michael Mráka 2010-11-22 16:15:12 UTC

Fixed in spacewalk nightly by
commit b09afcd48c2e7826982586ae0745cb299bcf0b33
    655519 - PE2.evr.as_vre_simple() -> evr_t_as_vre_simple(PE2.evr) (PG)

Comment 2 Luc de Louw 2011-01-20 06:21:48 UTC

confirmed working, thanks

Comment 3 Michael Mráka 2011-01-20 10:14:36 UTC

Moving to VERIFIED as per comment above.

Thanks for confirmation.

Comment 4 Tomas Lestach 2011-02-08 08:41:08 UTC

This bug has been fixed in Spacewalk 1.3.