[ovirt-users] Re: dashboard data empty

What do you suggest? Could concern the heap size? Il gio 20 feb 2020, 17:11 Ritesh Chikatwar <rchikatw(a)redhat.com&gt; 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&gt; 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...