[ovirt-users] oVirt Reports

Fernando Fuentes ffuentes at darktcp.net
Tue Aug 16 20:39:07 UTC 2016


Yaniv,

Thanks for the reply.

Didi,

Dully noted!

Thank you all for the reply. I got it all fixed.

Regards,

--
Fernando Fuentes
ffuentes at txweather.org
http://www.txweather.org



On Tue, Aug 16, 2016, at 12:56 AM, Yaniv Dary wrote:
> This looks like a DWH, not a reports issue. Are you sure you only
> install reports remotely?
>
> Yaniv Dary Technical Product Manager Red Hat Israel Ltd. 34 Jerusalem
> Road Building A, 4th floor Ra'anana, Israel 4350109  Tel : +972 (9)
> 7692306 8272306 Email: ydary at redhat.com IRC : ydary
>
> On Tue, Aug 16, 2016 at 8:48 AM, Yedidyah Bar David
> <didi at redhat.com> wrote:
>> On Tue, Aug 16, 2016 at 12:09 AM, Fernando Fuentes
>> <ffuentes at darktcp.net> wrote:
>>  > David,
>>
>> (Actually it's "Yedidyah" or "Didi", "Bar David" is my surname)
>>
>>
>> >
>>  > After an attempt to run this remote setup something went really
>>  > wrong
>>  > and my dwh went fubar on my ovirt 4.0
>>  >
>>  > I got:
>>  >
>>  > 2016-08-15 16:03:34|ETL Service Started
>>  > ovirtEngineDbDriverClass|org.postgresql.Driver
>>  > ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:54-
>>  > 32/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidati-
>>  > ngFactory
>>  > hoursToKeepDaily|43800
>>  > hoursToKeepHourly|1440
>>  > ovirtEngineDbPassword|**********************
>>  > runDeleteTime|3
>>  > ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engi-
>>  > ne?sslfactory=org.postgresql.ssl.NonValidatingFactory
>>  > runInterleave|20
>>  > 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.2
>>  > dwhAggregationDebug|false
>>  > dwhUuid|759f3eb5-5072-4c28-9686-a363eb956077
>>  > ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
>>  > ovirtEngineHistoryDbPassword|**********************
>>  > Exception in component tJDBCInput_2
>>  > org.postgresql.util.PSQLException: ERROR: relation
>>  > "history_configuration" does not exist
>>  >   Position: 65
>>  >         at
>>  >         org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResp-
>>  >         onse(QueryExecutorImpl.java:2157)
>>  >         at
>>  >         org.postgresql.core.v3.QueryExecutorImpl.processResults(Q-
>>  >         ueryExecutorImpl.java:1886)
>>  >         at
>>  >         org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExe-
>>  >         cutorImpl.java:255)
>>  >         at
>>  >         org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstr-
>>  >         actJdbc2Statement.java:555)
>>  >         at
>>  >         org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFl-
>>  >         ags(AbstractJdbc2Statement.java:403)
>>  >         at
>>  >         org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(-
>>  >         AbstractJdbc2Statement.java:283)
>>  >         at
>>  >         ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCh-
>>  >         eck.tJDBCInput_2Process(MinimalVersionCheck.java:1574)
>>  >         at
>>  >         ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCh-
>>  >         eck.tJDBCInput_1Process(MinimalVersionCheck.java:1229)
>>  >         at
>>  >         ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCh-
>>  >         eck.tJDBCConnection_2Process(MinimalVersionCheck.java:782)
>>  >         at
>>  >         ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCh-
>>  >         eck.tJDBCConnection_1Process(MinimalVersionCheck.java:657)
>>  >         at
>>  >         ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCh-
>>  >         eck.runJobInTOS(MinimalVersionCheck.java:3089)
>>  >         at
>>  >         ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCh-
>>  >         eck.runJob(MinimalVersionCheck.java:2853)
>>  >         at
>>  >         ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Proce-
>>  >         ss(HistoryETL.java:8009)
>>  >         at
>>  >         ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryE-
>>  >         TL.java:11520)
>>  > 2016-08-15
>>  > 16:03:34|NAl0ai|349e7f|349e7f|OVIRT_ENGINE_DWH|MinimalVersionChec-
>>  > k|Default|6|Java
>>  > Exception|tJDBCInput_2|org.postgresql.util.PSQLException:ERROR:
>>  > relation
>>  > "history_configuration" does not exist
>>  >   Position: 65|1
>>  > Exception in component tRunJob_2
>>  > java.lang.RuntimeException: Child job running failed
>>  >         at
>>  >         ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Proce-
>>  >         ss(HistoryETL.java:8032)
>>  >         at
>>  >         ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryE-
>>  >         TL.java:11520)
>>  > 2016-08-15
>>  > 16:03:34|349e7f|349e7f|349e7f|OVIRT_ENGINE_DWH|HistoryETL|Default-
>>  > |6|Java
>>  > Exception|tRunJob_2|java.lang.RuntimeException:Child job running
>>  > failed|1
>>  > 2016-08-15 16:03:34|ETL Service Stopped
>>  >
>>  > Can you please help?
>>
>> Please provide setup logs on the engine and reports machines. All of
>>  /var/log/ovirt-engine/setup/* on both of them. Thanks.
>>
>>
>> >
>>  > Regards,
>>  >
>>  > --
>>  > Fernando Fuentes
>>  > ffuentes at txweather.org
>>  > http://www.txweather.org
>>  >
>>  > On Mon, Aug 15, 2016, at 10:16 AM, Fernando Fuentes wrote:
>>  >> Thanks David!
>>  >>
>>  >> Regards,
>>  >>
>>  >>
>>  >> --
>>  >> Fernando Fuentes
>>  >> ffuentes at txweather.org
>>  >> http://www.txweather.org
>>  >>
>>  >> On Mon, Aug 15, 2016, at 12:31 AM, Yedidyah Bar David wrote:
>>  >> > On Sun, Aug 14, 2016 at 6:57 PM, Fernando Fuentes
>>  >> > <ffuentes at darktcp.net>
>>  >> > wrote:
>>  >> > > David,
>>  >> > >
>>  >> > > Thats exactly what I am trying to accomplish.
>>  >> > > When I re-run the ovirt setup on my 3.6 system, I give it the
>>  >> > > IP of my
>>  >> > > ovirt 4.0 machine, Do I leave the DB to the default name? Is
>>  >> > > there a db
>>  >> > > user and password on the 4.0 machine?
>>  >> > >
>>  >> > > Sorry for so many questions... This is not documented...
>>  >> >
>>  >> > Not for 3.6 vs 4.0, but it actually is, here:
>>  >> >
>>  >> > http://www.ovirt.org/develop/release-management/features/engine/separate-reports-host/
>>  >> >
>>  >> > See also:
>>  >> >
>>  >> > http://www.ovirt.org/develop/release-management/features/engine/separate-dwh-host/
>>  >> >
>>  >> > In above, each of engine, dwh, reports is in its own machine.
>>  >> > You can do a similar thing with engine+dwh on one and reports
>>  >> > on another.
>>  >> >
>>  >> > Do not hesitate ping back if you are stuck!
>>  >> >
>>  >> > Best,
>>  >> >
>>  >> > >
>>  >> > > Thank you for all the help!
>>  >> > >
>>  >> > > Regards,
>>  >> > >
>>  >> > > --
>>  >> > > Fernando Fuentes
>>  >> > > ffuentes at txweather.org
>>  >> > > http://www.txweather.org
>>  >> > >
>>  >> > > On Sun, Aug 14, 2016, at 02:01 AM, Yedidyah Bar David wrote:
>>  >> > >> On Sat, Aug 13, 2016 at 10:38 PM, Fernando Fuentes
>>  >> > >> <ffuentes at darktcp.net>
>>  >> > >> wrote:
>>  >> > >> > Team,
>>  >> > >> >
>>  >> > >> > I got two oVirt Servers. One in 4.0.2 and one in 3.6.X
>>  >> > >> > I love the new 4.0 dashboard, But I need a way to continue
>>  >> > >> > to build
>>  >> > >> > reports with ease, 3.6 Can do this with ovirt-reports. How
>>  >> > >> > can I make my
>>  >> > >> > oVirt 4.0.2 send data for reports to my ovirt reports on
>>  >> > >> > 3.6?
>>  >> > >> >
>>  >> > >> > Thanks for the help team!
>>  >> > >>
>>  >> > >> I didn't try this myself, but pointing your reports setup to
>>  >> > >> the 4.0 dwh
>>  >> > >> database should work. If you have problems, please give more
>>  >> > >> details -
>>  >> > >> it's not clear what exactly you have on each machine.
>>  >> > >>
>>  >> > >> Generally speaking, oVirt does not currently provide tools
>>  >> > >> to make
>>  >> > >> the engine or dwh "send data" elsewhere (a 3.6 reports or
>>  >> > >> whatever).
>>  >> > >> You can try doing this yourself using generic postgresql
>>  >> > >> means/tools.
>>  >> > >>
>>  >> > >> Best
>>  >> > >> --
>>  >> > >> Didi
>>  >> >
>>  >> >
>>  >> >
>>  >> > --
>>  >> > Didi
>>  >> _______________________________________________
>>  >> Users mailing list
>>  >> Users at ovirt.org
>>  >> http://lists.ovirt.org/mailman/listinfo/users
>>  > _______________________________________________
>>  > Users mailing list
>>  > Users at ovirt.org
>>  > http://lists.ovirt.org/mailman/listinfo/users
>>
>>
>>
>>  --
>>  Didi
>>  _______________________________________________
>>  Users mailing list
>> Users at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20160816/cc6c3e27/attachment-0001.html>


More information about the Users mailing list