7:14 a.m.
Shirly of course I restarted the process you can find the error in the log
file in my first email. Anyway tomorrow I can also send you all the log. I
also opened a bug on bugzilla.
The problem seems related to postgres jdbc.
Il dom 23 feb 2020, 14:11 Shirly Radco <sradco(a)redhat.com> ha scritto:
Hi,
Have you tried to restart DWH ?
systemctl restart ovirt-engine-dwhd
If this doesn't work, please send me the ovirt-engine-dwhd.log.
Best,
--
Shirly Radco
BI Principal Software Engineer
Red Hat <https://www.redhat.com/>
<https://www.redhat.com/>
On Thu, Feb 20, 2020 at 7:31 PM Fabrizio Cardarello <
f.cardarello(a)gmail.com> wrote:
> What do you suggest? Could concern the heap size?
>
> Il gio 20 feb 2020, 17:11 Ritesh Chikatwar <rchikatw(a)redhat.com> ha
> scritto:
>
>> I think this because resultset is not able to map the database value to
>> entity. You can error it's bad value for the type short. I guess the the
>> value passed for short variable is more then it can store.
>>
>> On Thu, Feb 20, 2020, 2:56 PM Fabrizio <f.cardarello(a)gmail.com> wrote:
>>
>>> Hello everyone.
>>> I intalled 4 node with hosted engine, everything works fine exept the
>>> dashboard. it doesn't collect any data and is always empty of
information.
>>> searching around I found out that the problem could be the dwh service,
>>> inside the log there is an error:
>>>
>>> ## log file
>>> 2020-02-19 17:46:14|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.3.8
>>> dwhAggregationDebug|false
>>> dwhUuid|5c4ffc1b-928f-4d06-a40f-bb34ba11c7f2
>>> ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
>>> ovirtEngineHistoryDbPassword|**********************
>>> Exception in component tJDBCInput_2
>>> org.postgresql.util.PSQLException: Bad value for type short : 201905
>>> at
>>>
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getShort(AbstractJdbc2ResultSet.java:2098)
>>> at
>>>
ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCInput_2Process(OsEnumUpdate.java:2354)
>>> at
>>>
ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tRowGenerator_1Process(OsEnumUpdate.java:1921)
>>> at
>>>
ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1376)
>>> at
>>>
ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:873)
>>> at
>>>
ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:736)
>>> at
>>>
ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4396)
>>> at
>>>
ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.runJob(OsEnumUpdate.java:4099)
>>> at
>>>
ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:947)
>>> at
>>>
ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:767)
>>> at
>>>
ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:642)
>>> at
>>>
ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs$2.run(SampleRunJobs.java:2683)
>>>
>>> ## SERVICE STATUS
>>> ● ovirt-engine-dwhd.service - oVirt Engine Data Warehouse
>>> Loaded: loaded (/usr/lib/systemd/system/ovirt-engine-dwhd.service;
>>> enabled; vendor preset: disabled)
>>> Active: active (running) since Wed 2020-02-19 17:46:14 CET; 16h ago
>>> Main PID: 6425 (ovirt-engine-dw)
>>> CGroup: /system.slice/ovirt-engine-dwhd.service
>>> ├─6425 /usr/bin/python
>>> /usr/share/ovirt-engine-dwh/services/ovirt-engine-dwhd/ovirt-engine-dwhd.py
>>> --redirect-output --systemd=notify start
>>> └─6512 ovirt-engine-dwhd
>>> -Dorg.ovirt.engine.dwh.settings=/tmp/tmparNn_x/settings.properties -Xms1g
>>> -Xmx1g -classpath
>>>
/usr/share/ovirt-engine-dwh/lib/*::/usr/share/java/dom4j.jar:/usr/share/java/apache-commons-collections.jar:/usr/share/java/postgresql-jdbc.jar
>>> ovirt_engine_dwh.historyetl_4_3.HistoryETL --context=Default
>>>
>>> Feb 19 17:46:14 engine.ovirt.local systemd[1]: Starting oVirt Engine
>>> Data Warehouse...
>>> Feb 19 17:46:14 engine.ovirt.local systemd[1]: Started oVirt Engine
>>> Data Warehouse.
>>> _______________________________________________
>>> Users mailing list -- users(a)ovirt.org
>>> To unsubscribe send an email to users-leave(a)ovirt.org
>>> Privacy Statement: https://www.ovirt.org/site/privacy-policy/
>>> oVirt Code of Conduct:
>>> https://www.ovirt.org/community/about/community-guidelines/
>>> List Archives:
>>>
https://lists.ovirt.org/archives/list/users@ovirt.org/message/XNHHCEVYDPB...
>>>
>> _______________________________________________
> Users mailing list -- users(a)ovirt.org
> To unsubscribe send an email to users-leave(a)ovirt.org
> Privacy Statement: https://www.ovirt.org/site/privacy-policy/
> oVirt Code of Conduct:
> https://www.ovirt.org/community/about/community-guidelines/
> List Archives:
>
https://lists.ovirt.org/archives/list/users@ovirt.org/message/X33EJZLCMPJ...
>