Bug 655519 - ISE: publishing errata on spacewalk w/postgresql fails
Summary: ISE: publishing errata on spacewalk w/postgresql fails
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 1.2
Hardware: x86_64
OS: Linux
low
low
Target Milestone: ---
Assignee: Michael Mráka
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space13
TreeView+ depends on / blocked
 
Reported: 2010-11-21 13:42 UTC by Luc de Louw
Modified: 2011-02-08 08:41 UTC (History)
0 users

Fixed In Version: spacewalk-java-1.3.11-1
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-02-08 08:41:08 UTC
Embargoed:


Attachments (Terms of Use)

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.


Note You need to log in before you can comment on or make changes to this bug.