Bug 655515

Summary: ISE: Adding packages to errata on spacewalk w/postgresql fails
Product: [Community] Spacewalk Reporter: Luc de Louw <luc>
Component: ServerAssignee: 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:42:35 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:33:12 UTC
Description of problem:
When adding a package to an errata, ISE occures.

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

How reproducible:
Always

Steps to Reproduce:
1. Add an errata
2. http://spacewalk.example.com/rhn/errata/manage/Packages.do?eid=XY and click on "Add
3. Internal Server Error 500
  
Actual results:
ISE

Expected results:
Adding pkg to errata

Additional info:
POstgreSQL log shows:

Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-1] ERROR:  function decode(numeric, integer, integer, unknown) does not exist at character 148
Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-2] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-3] STATEMENT:  SELECT AC.channel_id AS ID,
Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-4]             AC.channel_name AS NAME,
Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-5]             rhn_channel.user_role_check(AC.channel_id, $1, 'subscribe') AS HAS_PERM,
Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-6]             DECODE(
Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-7]      rhn_channel.org_channel_setting(AC.channel_id, $2,'not_globally_subscribable'),
Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-8]      0,
Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-9]      1,
Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-10]     NULL
Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-11]            ) AS GLOBALLY_SUBSCRIBABLE
Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-12]       FROM rhnAvailableChannels AC
Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-13]      WHERE AC.org_id = $3
Nov 21 13:32:16 spacewalk-pg postgres[6016]: [5-14]     ORDER BY UPPER(AC.channel_name)

Comment 1 Michael Mráka 2010-11-22 16:16:02 UTC
Fixed in spacewalk nightly by
commit 16279c453c08f0eb6366e6225f1bad22d31d3028
    655515 - changed DECODE to ANSI CASE (PG)

Comment 2 Luc de Louw 2011-01-20 06:22:05 UTC
confirmed working, thanks

Comment 3 Michael Mráka 2011-01-20 10:14:38 UTC
Moving to VERIFIED as per comment above.

Thanks for confirmation.

Comment 4 Tomas Lestach 2011-02-08 08:42:35 UTC
This bug has been fixed in Spacewalk 1.3.