Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1215151

Summary:	021-rhnServerNetwork-trigger.sql.oracle: IF EXISTS isn't Oracle syntax
Product:	[Community] Spacewalk	Reporter:	Grant Gainey <ggainey>
Component:	Installation	Assignee:	Grant Gainey <ggainey>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	2.3	CC:	michael.kromer
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	spacewalk-schema-2.4.4-1 , spacewalk-schema-2.3.44-1	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2015-04-27 18:04:58 UTC	Type:	Bug
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:	1484117

Description Grant Gainey 2015-04-24 12:28:00 UTC

"IF EXISTS does not exist on oracle. This fails the upgrade from 2.2 to 2.3. Removing IF EXISTS part does work and lets upgrade run smoothly."

See https://github.com/spacewalkproject/spacewalk/pull/250

Comment 1 Grant Gainey 2015-04-24 12:29:53 UTC

NOTE: needs to be fixed and released to 2.3, as it blocks installation with external-oracle

Comment 2 Grant Gainey 2015-04-27 14:32:46 UTC

spacewalk.github commit ebc6c3b43690242bd512611ea456013739339244

Comment 3 Grant Gainey 2015-04-27 14:35:36 UTC

spacewalk.github SPACEWALK-2.3 f24c98274c87cf30796eb01a57e19b5d0f0f3bdc

Comment 4 Grant Gainey 2015-04-27 18:04:58 UTC

Updated 021*postgresql to have sha1 of oracle change

master:        052c514818e76ad214867793fe961fb368dae060
SPACEWALK-2.3: 0955ef5a2e487d5c75601fedcca61d946f0508af

Comment 5 Eric Herget 2017-09-28 18:10:06 UTC

This BZ closed some time during 2.5, 2.6 or 2.7.  Adding to 2.7 tracking bug.