Bug 1342129

Summary: DWH service fails to start - java.lang.NumberFormatException: For input string: "0.1"
Product: [oVirt] ovirt-engine-dwh Reporter: Pavel Novotny <pnovotny>
Component: GeneralAssignee: Shirly Radco <sradco>
Status: CLOSED CURRENTRELEASE QA Contact: Lukas Svaty <lsvaty>
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 4.0.0CC: bugs, oourfali
Target Milestone: ovirt-4.0.0-rcKeywords: Regression
Target Release: 4.0.0Flags: rule-engine: ovirt-4.0.0+
rule-engine: blocker+
rule-engine: planning_ack+
sradco: devel_ack+
pnovotny: testing_ack+
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-07-05 07:46:16 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Metrics RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1324860    

Description Pavel Novotny 2016-06-02 13:39:24 UTC
Description of problem:
When staring DWH service, a Java exception is thrown and the service is then immediately stopped.

Version-Release number of selected component (if applicable):
ovirt-engine-4.1.0-0.0.master.20160601231315.git049ef04.el7.centos.noarch
ovirt-engine-dwh-4.0.0.1-0.0.master.20160531201540.git885483f.el7.centos.noarch

How reproducible:
100%

Steps to Reproduce:
1. yum install -y ovirt-engine-setup && engine-setup
2. After setup is finished, check status of the DWH service.
3.

Actual results:
Service is stopped due to an error.

Expected results:
DWH service is running.

Additional info:

ovirt-engine-dwhd.log:

2016-06-02 15:23:23|ETL Service Started
ovirtEngineDbDriverClass|org.postgresql.Driver
ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory
hoursToKeepDaily|0
hoursToKeepHourly|720
ovirtEngineDbPassword|**********************
runDeleteTime|3
ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory
runInterleave|60
limitRows|limit 1000
ovirtEngineHistoryDbUser|ovirt_engine_history
ovirtEngineDbUser|engine
deleteIncrement|10
timeBetweenErrorEvents|300000
hoursToKeepSamples|24
deleteMultiplier|1000
lastErrorSent|2011-07-03 12:46:47.000000
etlVersion|4.0.0.1
dwhAggregationDebug|false
dwhUuid|e09debf0-6a0d-4c7b-9c72-cf7b0e01e981
ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
ovirtEngineHistoryDbPassword|**********************
Exception in component tJDBCInput_1
java.lang.NumberFormatException: For input string: "0.1"
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.lang.Integer.parseInt(Integer.java:580)
        at java.lang.Integer.parseInt(Integer.java:615)
        at ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCInput_1Process(MinimalVersionCheck.java:1225)
        at ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCConnection_2Process(MinimalVersionCheck.java:782)
        at ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCConnection_1Process(MinimalVersionCheck.java:657)
        at ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.runJobInTOS(MinimalVersionCheck.java:3089)
        at ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.runJob(MinimalVersionCheck.java:2853)
        at ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Process(HistoryETL.java:8009)
        at ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryETL.java:11520)
2016-06-02 15:23:23|TWsedB|csMPKr|csMPKr|OVIRT_ENGINE_DWH|MinimalVersionCheck|Default|6|Java Exception|tJDBCInput_1|java.lang.NumberFormatException:For input string: "0.1"|1
Exception in component tRunJob_2
java.lang.RuntimeException: Child job running failed
        at ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Process(HistoryETL.java:8032)
        at ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryETL.java:11520)
2016-06-02 15:23:23|csMPKr|csMPKr|csMPKr|OVIRT_ENGINE_DWH|HistoryETL|Default|6|Java Exception|tRunJob_2|java.lang.RuntimeException:Child job running failed|1
2016-06-02 15:23:23|ETL Service Stopped

Comment 1 Red Hat Bugzilla Rules Engine 2016-06-07 06:54:46 UTC
Target release should be placed once a package build is known to fix a issue. Since this bug is not modified, the target version has been reset. Please use target milestone to plan a fix for a oVirt release.

Comment 2 Lukas Svaty 2016-06-15 09:24:16 UTC
verified in ovirt-engine-dwh-4.0.0-2.el7ev.noarch

Comment 3 Sandro Bonazzola 2016-07-05 07:46:16 UTC
oVirt 4.0.0 has been released, closing current release.