[ovirt-users] oVirt Reports

Yaniv Dary ydary at redhat.com
Tue Aug 16 05:56:15 UTC 2016 

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:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.
> NonValidatingFactory
> > hoursToKeepDaily|43800
> > hoursToKeepHourly|1440
> > ovirtEngineDbPassword|**********************
> > runDeleteTime|3
> > ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:
> 5432/engine?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.receiveErrorResponse(
> QueryExecutorImpl.java:2157)
> >         at
> >         org.postgresql.core.v3.QueryExecutorImpl.processResults(
> QueryExecutorImpl.java:1886)
> >         at
> >         org.postgresql.core.v3.QueryExecutorImpl.execute(
> QueryExecutorImpl.java:255)
> >         at
> >         org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
> AbstractJdbc2Statement.java:555)
> >         at
> >         org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
> AbstractJdbc2Statement.java:403)
> >         at
> >         org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(
> AbstractJdbc2Statement.java:283)
> >         at
> >         ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.
> tJDBCInput_2Process(MinimalVersionCheck.java:1574)
> >         at
> >         ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.
> tJDBCInput_1Process(MinimalVersionCheck.java:1229)
> >         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-08-15
> > 16:03:34|NAl0ai|349e7f|349e7f|OVIRT_ENGINE_DWH|
> MinimalVersionCheck|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_2Process(
> HistoryETL.java:8032)
> >         at
> >         ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryETL.
> 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/8de2388c/attachment-0001.html>

More information about the Users mailing list