Note: This is a public test instance of Red Hat Bugzilla. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback at bugzilla.redhat.com.
Bug 1128735 - schema upgrade perl script chokes on "," float delimiter
Summary: schema upgrade perl script chokes on "," float delimiter
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Installation
Version: 2.2
Hardware: Unspecified
OS: Linux
unspecified
medium
Target Milestone: ---
Assignee: Milan Zázrivec
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space23
TreeView+ depends on / blocked
 
Reported: 2014-08-11 12:52 UTC by Mario Mikocevic
Modified: 2015-04-14 19:04 UTC (History)
3 users (show)

Fixed In Version: spacewalk-schema-2.3.10-1
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-04-14 19:04:11 UTC
Embargoed:

Attachments (Terms of Use)

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 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 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
Note You need to log in before you can comment on or make changes to this bug.