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

Bug 1128735

Summary:	schema upgrade perl script chokes on "," float delimiter
Product:	[Community] Spacewalk	Reporter:	Mario Mikocevic <mario.mikocevic>
Component:	Installation	Assignee:	Milan Zázrivec <mzazrivec>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	2.2	CC:	jpazdziora, mario.mikocevic, mmraka
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Linux
Whiteboard:
Fixed In Version:	spacewalk-schema-2.3.10-1	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2015-04-14 19:04:11 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:	1207293

Description Mario Mikocevic 2014-08-11 12:52:04 UTC

Description of problem:

# /usr/bin/spacewalk-schema-upgrade
Argument "551,5" isn't numeric in addition (+) at /usr/bin/spacewalk-schema-upgrade line 95.

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

# rpm -qf /usr/bin/spacewalk-schema-upgrade
spacewalk-schema-2.2.33-1.el6.noarch


Additional info:

# env | grep -i nls
# env | grep -i lang
LANG=en_US.UTF-8

Oracle server has Croatian_Croatia.UTF-8 setting.

basically perl barfs on wrong delimiter in float numbers ..

Comment 1 Jan Pazdziora (Red Hat) 2014-08-11 17:32:40 UTC

If you do

export NLS_LANG=AMERICAN_AMERICA.UTF8

before running spacewalk-schema-upgrade, will the run pass?

Comment 2 Mario Mikocevic 2014-08-12 08:02:53 UTC

No, it will not, even tried with NLS_LANG=Croatian_Croatia.UTF8,
but when I added
NLS_NUMERIC_CHARACTERS='. '
it passed schema upgrade.
So apparently it needs both env settings.

Comment 3 Jan Pazdziora (Red Hat) 2014-08-21 12:50:15 UTC

https://github.com/spacewalkproject/spacewalk/pull/143

Comment 4 Michael Mráka 2014-08-29 09:08:00 UTC

Fixed in spacewalk master by

commit 5a53d60428d50f8fde2950c904ae571235fa276c
    1128735 - force character set and numerical separators to good known defaults.

Comment 5 Grant Gainey 2015-03-23 16:59:37 UTC

Moving bugs to ON_QA as we move to release Spacewalk 2.3

Comment 6 Grant Gainey 2015-04-14 19:04:11 UTC

Spacewalk 2.3 has been released. See

https://fedorahosted.org/spacewalk/wiki/ReleaseNotes23