Bug 1272473

Summary: Confusing error shown in UI wizard when creating big bundle on oracle and hitting ORA-01691: unable to extend lob segment
Product: [JBoss] JBoss Operations Network Reporter: Filip Brychta <fbrychta>
Component: Database, UI, UsabilityAssignee: Josejulio Martínez <jmartine>
Status: CLOSED ERRATA QA Contact: Filip Brychta <fbrychta>
Severity: medium Docs Contact:
Priority: low    
Version: JON 3.3.4CC: jmartine, spinder
Target Milestone: ER01Keywords: Triaged
Target Release: JON 3.3.6   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-07-27 15:31:05 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:
Attachments:
Description Flags
wizard screenshot
none
server.log none

Description Filip Brychta 2015-10-16 13:28:13 UTC
Created attachment 1083648 [details]
wizard screenshot

Description of problem:
This issue happens only on default oracle when creating big bundle.
When creating new big bundle user will hit ORA-01691: unable to extend lob segment but wizard shows java.lang.NumberFormatException: null
which is saying nothing about root cause.

Version-Release number of selected component (if applicable):
Version :	
3.3.0.GA Update 04
Build Number :	
e9ed05b:aa79ebd

How reproducible:
Always

Steps to Reproduce:
1. Install JON using oracle db
2. create following bundle:
tmpDir="`mktemp -d`"

cat >"${tmpDir}"/deploy.xml <<EOF
<?xml version="1.0"?>
<project name="largeFile"
         default="main"
         xmlns:rhq="antlib:org.rhq.bundle">
  <target name="main" />

  <rhq:bundle name="Large File Test Bundle"
              version="1.0"
              description="A sample bundle consisting of a single large file">
    <rhq:deployment-unit name="files"
                         compliance="filesAndDirectories">
EOF

mkdir "${tmpDir}"/files
for file in {001..001}; do
    echo "This is File #${file}." > "${tmpDir}/files/file-${file}.txt"
    dd if=/dev/urandom of="${tmpDir}/files/file-${file}.bin" bs=30M count=10
    echo '      <rhq:file name="files/file-'"${file}"'.txt" destinationFile="files/file-'"${file}"'.txt" replace="true" />' >> "${tmpDir}"/deploy.xml
    echo '      <rhq:file name="files/file-'"${file}"'.bin" destinationFile="files/file-'"${file}"'.bin" replace="true" />' >> "${tmpDir}"/deploy.xml
done

cat >>"${tmpDir}"/deploy.xml <<EOF
    </rhq:deployment-unit>
  </rhq:bundle>
</project>
EOF
(cd "${tmpDir}" && zip -r /tmp/large-bundle.zip .)
rm -rf "${tmpDir}"
ls -al /tmp/large-bundle.zip
3. try to create new bundle using large-bundle.zip

Actual results:
See attached screenshot.
Shown error is:
java.lang.NumberFormatException: null
which is saying nothing about root cause.

Expected results:
Real root cause should be shown which is ORA-01691: unable to extend lob segment

Additional info:
server.log and screenshot attached.
This issue can be resolved by using AUTOEXTEND ON for tablespace SYSTEM.

Comment 1 Filip Brychta 2015-10-16 13:28:55 UTC
Created attachment 1083649 [details]
server.log

Comment 3 Josejulio Martínez 2016-06-06 22:08:25 UTC
commit c9290a45439b707decdbedeb568bdaae0abb5109
Merge: 0e594dc 5188ed4
Author: Michael Burman <yak>
Date:   Mon Jun 6 23:26:41 2016 +0300

    Merge pull request #266 from josejulio/bugs/1272473
    
    Bug 1272473 - Confusing error shown in UI wizard when creating big bu…


commit 5188ed48a4cbff194970cdc3f9feaf86c8fc7253
Author: Josejulio Martínez <jmartine>
Date:   Fri Jun 3 23:35:26 2016 -0500

    Bug 1272473 - Confusing error shown in UI wizard when creating big bundle on oracle and hitting ORA-01691: unable to extend lob segment
    
     Don't swallow ORA-* exceptions.

Comment 5 Simeon Pinder 2016-07-07 08:23:02 UTC
Moving to ON_QA as available to test with the following build:
https://brewweb.engineering.redhat.com/brew/buildinfo?buildID=502442

Note: 	jon-server-patch-3.3.0.GA.zip maps to JON 3.3.6(jon-server-3.3.0.GA-update-06.zip)

Comment 7 errata-xmlrpc 2016-07-27 15:31:05 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHSA-2016-1519.html