schema/spacewalk/spacewalk-schema-upgrade | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-)
New commits: commit d5ab39faf8ee6c7d6f17b9b0aaa07de8a2c87110 Author: Milan Zazrivec mzazrivec@redhat.com Date: Thu Oct 24 11:51:49 2013 +0200
fix space check for Oracle schema upgrades
This fix is to make sure the bytes will not get converted to scientific notation (for large values).
diff --git a/schema/spacewalk/spacewalk-schema-upgrade b/schema/spacewalk/spacewalk-schema-upgrade index 930a10d..91e8910 100755 --- a/schema/spacewalk/spacewalk-schema-upgrade +++ b/schema/spacewalk/spacewalk-schema-upgrade @@ -82,12 +82,12 @@ if (-f $schema_banner and -s $schema_banner) { if ($options{db_backend} eq 'oracle') { my $default_tablespace = get_default_oracle_tablespace(); my $used_space = run_query(<<EOF); - select sum(bytes) + select sum(bytes / 1048576) from user_segments where tablespace_name = '$default_tablespace'; EOF my $free_space = run_query(<<EOF); - select sum(bytes) + select sum(bytes / 1048576) from user_free_space where tablespace_name = '$default_tablespace'; EOF @@ -98,8 +98,8 @@ EOF for (1 .. 72) { $usage .= '-'; } $usage .= "\n"; $usage .= sprintf("%+15s %15.2f %15.2f %15.2f", $default_tablespace, - $used_space/1024/1024, - $free_space/1024/1024, + $used_space, + $free_space, $used_space * 100 / ($used_space + $free_space));
print <<EOF;
spacewalk-commits@lists.fedorahosted.org