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 <[email protected]> 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 < > [email protected]> wrote: > >> What do you suggest? Could concern the heap size? >> >> Il gio 20 feb 2020, 17:11 Ritesh Chikatwar <[email protected]> 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 <[email protected]> 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 -- [email protected] >>>> To unsubscribe send an email to [email protected] >>>> 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/[email protected]/message/XNHHCEVYDPBVJM7ZYJ6X3L7UUQ3P5I7M/ >>>> >>> _______________________________________________ >> Users mailing list -- [email protected] >> To unsubscribe send an email to [email protected] >> 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/[email protected]/message/X33EJZLCMPJIKIFG4DSE52ZKXUX7XZYJ/ >> >
_______________________________________________ Users mailing list -- [email protected] To unsubscribe send an email to [email protected] 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/[email protected]/message/TRDUPE63NHFNWNCKKPBDT7C7MRZBRUMJ/
