
Hi Shirly, There are lots of log files in three folders,please let me know which you want...or you want all ?? [root@ccr01 ~]# ll /var/log/ovirt-engine total 70152 -rw-r--r-- 1 ovirt ovirt 503 Feb 3 14:23 boot.log -rw-r--r-- 1 ovirt ovirt 0 Feb 3 14:22 console.log drwxr-xr-x 2 ovirt ovirt 4096 Jan 30 00:41 dump -rw-r--r-- 1 ovirt ovirt 67187380 Feb 3 14:41 engine.log drwxr-xr-x 2 ovirt ovirt 4096 Jan 30 00:41 host-deploy drwxr-xr-x 2 ovirt ovirt 4096 Jan 30 00:41 notifier drwxr-xr-x 2 root root 4096 Jan 20 17:09 ovirt-image-uploader drwxr-xr-x 2 root root 4096 Feb 1 03:19 ovirt-iso-uploader -rw-r--r-- 1 ovirt ovirt 4606447 Feb 3 14:24 server.log drwxr-xr-x 2 root root 4096 Feb 3 14:17 setup [root@ccr01 ~]# ll /var/log/ovirt-engine-dwh/ total 36 -rw-r--r-- 1 ovirt ovirt 29588 Feb 3 14:23 ovirt-engine-dwhd.log [root@ccr01 ~]# ll /var/log/ovirt-engine-reports/ total 516 -rw-r--r-- 1 ovirt ovirt 503 Feb 3 14:23 boot.log -rw-r--r-- 1 ovirt ovirt 0 Feb 3 14:23 console.log -rw-r--r-- 1 ovirt ovirt 49693 Feb 3 13:00 jasperserver.log -rw-r--r-- 1 ovirt ovirt 0 Feb 2 14:36 reports.log -rw-r--r-- 1 ovirt ovirt 466838 Feb 3 14:23 server.log [root@ccr01 ~]# On Tue, Feb 3, 2015 at 2:38 PM, Shirly Radco <sradco@redhat.com> wrote:
Please attach all logs under the mentioned folders.
Best, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd.
From: "Punit Dambiwal" <hypunit@gmail.com> To: "Shirly Radco" <sradco@redhat.com> Cc: "David van zeebroeck" <david@analytics.brusselsairport.be>, "Joop" < jvdwege@xs4all.nl>, users@ovirt.org Sent: Tuesday, February 3, 2015 8:31:42 AM Subject: Re: [ovirt-users] dwh not receiving any data
Hi Shirly,
Please find the attached log files...
On Tue, Feb 3, 2015 at 1:56 PM, Shirly Radco <sradco@redhat.com> wrote:
Hi Punit,
Please send me first the logs so we can see if this is still the same issue. /var/log/ovirt-engine /var/log/ovirt-engine-dwh /var/log/ovirt-engine-reports
Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd.
----- Original Message -----
From: "Punit Dambiwal" <hypunit@gmail.com> To: "Shirly Radco" <sradco@redhat.com> Cc: "David van zeebroeck" <david@analytics.brusselsairport.be>, "Joop" < jvdwege@xs4all.nl>, users@ovirt.org Sent: Tuesday, February 3, 2015 5:50:57 AM Subject: Re: [ovirt-users] dwh not receiving any data
Hi Shirly,
It seems resolved but actually not....again after 12 hours it stopped working...
[image: Inline image 1] [image: Inline image 3]
It stopped working after 5:00 AM....yesterday (2nd Feb) started at evening 17:00 PM...and stopped today 3rd Feb 5:00 AM....
[image: Inline image 4]
Please let me know how i can take the dump of engine and dwh to you....
Thanks, Punit
On Tue, Feb 3, 2015 at 9:34 AM, Punit Dambiwal <hypunit@gmail.com> wrote:
Hi,
My issue resolved by remove the dwh and reports and reinstall again......also i found that my server time was correct and updated but the postgresql time was different form the server time.....above two changes made it work...
Thanks, punit
On Mon, Feb 2, 2015 at 8:25 PM, Shirly Radco <sradco@redhat.com> wrote:
Hi,
If any of you can send me the engine and ovirt_engine_dwh dump, I will upload them in my development environment and see what is
issue.
Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd.
----- Original Message ----- > From: "Shirly Radco" <sradco@redhat.com> > To: "David van zeebroeck" <david@analytics.brusselsairport.be> > Cc: users@ovirt.org > Sent: Monday, February 2, 2015 1:04:24 PM > Subject: Re: [ovirt-users] dwh not receiving any data > > Hi David, > > Please update me on what you found. > > Best regards, > --- > Shirly Radco > BI Software Engineer > Red Hat Israel Ltd. > > > ----- Original Message ----- > > From: "Shirly Radco" <sradco@redhat.com> > > To: "David van zeebroeck" <david@analytics.brusselsairport.be
> > Cc: users@ovirt.org > > Sent: Sunday, February 1, 2015 11:24:10 AM > > Subject: Re: [ovirt-users] dwh not receiving any data > > > > Hi David, > > > > It means that for some reason user with user_id > > ab932902-cead-4435-a2b6-8b88576feab6 > > was not added to users_details_history. > > And this is why the etl can't update the vm_samples_history
the > > ovirt_engine_history database. > > > > Please check if this user_id ab932902-cead-4435-a2b6-8b88576feab6 exists in > > the "dwh_users_history_view" or in the users table in the engine database. > > > > Select * From dwh_users_history_view > > Where user_id = 'ab932902-cead-4435-a2b6-8b88576feab6'; > > > > Best regards, > > --- > > Shirly Radco > > BI Software Engineer > > Red Hat Israel Ltd. > > > > > > ----- Original Message ----- > > > From: "David van zeebroeck" < david@analytics.brusselsairport.be
> > > To: users@ovirt.org > > > Sent: Thursday, January 29, 2015 5:10:01 PM > > > Subject: [ovirt-users] dwh not receiving any data > > > > > > hi > > > we are running ovirt 3.5.1 and we are trying to setup the dwh
> > > install and setup appears to run fine but when starting the service we > > > see > > > following error in the log file : > > > > > > 2015-01-29 16:06:26|ETL Service Started > > > Exception in component tJDBCOutput_5 > > > org.postgresql.util.PSQLException: ERROR: insert or update on
on part table
> > > "vm_samples_history" violates foreign key constraint > > > "vm_samples_history_current_user_id_fkey" > > > Detail: Key (current_user_id)=(ab932902-cead-4435-a2b6-8b88576feab6) is > > > not > > > present in table "users_details_history". > > > at > > >
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
> > > at > > >
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
> > > at > > >
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> > > at > > >
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
> > > at > > >
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
> > > at > > >
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
> > > at > > >
ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_10Process(StatisticsSync.java:10482)
> > > at > > >
ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$6.run(StatisticsSync.java:17437)
> > > Exception in component tJDBCOutput_6 > > > org.postgresql.util.PSQLException: ERROR: current
aborted, > > > commands ignored until end of transaction block > > > at > > >
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
> > > at > > >
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
> > > at > > >
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> > > at > > >
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
> > > at > > >
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
> > > at > > >
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
> > > at > > >
ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_12Process(StatisticsSync.java:12689)
> > > at > > >
ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$7.run(StatisticsSync.java:17483)
> > > Exception in component tJDBCOutput_7 > > > org.postgresql.util.PSQLException: ERROR: current
aborted, > > > commands ignored until end of transaction block > > > at > > >
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
> > > at > > >
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
> > > at > > >
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> > > at > > >
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
> > > at > > >
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
> > > at > > >
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
> > > at > > >
ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_18Process(StatisticsSync.java:14806)
> > > at > > >
ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$8.run(StatisticsSync.java:17529)
> > > Exception in component tJDBCOutput_4 > > > org.postgresql.util.PSQLException: ERROR: current
----- Original Message ----- the table transaction is transaction is transaction is
aborted, > > > commands ignored until end of transaction block > > > at > > >
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
> > > at > > >
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
> > > at > > >
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> > > at > > >
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
> > > at > > >
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
> > > at > > >
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
> > > at > > >
ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_8Process(StatisticsSync.java:7788)
> > > at > > >
ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$5.run(StatisticsSync.java:17391)
> > > 2015-01-29 > > >
16:07:04|kGEf8p|YhA1NE|VVdF7H|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java
> > > Exception|tJDBCOutput_7|org.postgresql.util.PSQLException:ERROR: current > > > transaction is aborted, commands ignored until end of transaction block|1 > > > 2015-01-29 > > >
16:07:04|kGEf8p|YhA1NE|VVdF7H|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java
> > > Exception|tJDBCOutput_5|org.postgresql.util.PSQLException:ERROR: insert > > > or > > > update on table "vm_samples_history" violates foreign key constraint > > > "vm_samples_history_current_user_id_fkey" > > > Detail: Key (current_user_id)=(ab932902-cead-4435-a2b6-8b88576feab6) is > > > not > > > present in table "users_details_history".|1 > > > 2015-01-29 > > >
16:07:04|kGEf8p|YhA1NE|VVdF7H|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java
> > > Exception|tJDBCOutput_6|org.postgresql.util.PSQLException:ERROR: current > > > transaction is aborted, commands ignored until end of transaction block|1 > > > 2015-01-29 > > >
16:07:04|kGEf8p|YhA1NE|VVdF7H|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java
> > > Exception|tJDBCOutput_4|org.postgresql.util.PSQLException:ERROR: current > > > transaction is aborted, commands ignored until end of transaction block|1 > > > Exception in component tRunJob_5 > > > java.lang.RuntimeException: Child job running failed > > > at > > >
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_5Process(SampleRunJobs.java:1598)
> > > at > > >
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_6Process(SampleRunJobs.java:1412)
> > > at > > >
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_1Process(SampleRunJobs.java:1197)
> > > at > > >
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:982)
> > > at > > >
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
> > > at > > >
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
> > > at > > >
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
> > > 2015-01-29 > > >
16:07:04|VVdF7H|YhA1NE|XpLXfK|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
> > > Exception|tRunJob_5|java.lang.RuntimeException:Child job running failed|1 > > > Exception in component tRunJob_1 > > > java.lang.RuntimeException: Child job running failed > > > at > > >
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)
> > > at > > >
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)
> > > at > > >
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)
> > > at > > >
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)
> > > at > > >
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)
> > > at > > >
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)
> > > at > > >
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)
> > > at > > >
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)
> > > at > > >
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
> > > at > > >
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)
> > > > > > > > > _______________________________________________ > > > Users mailing list > > > Users@ovirt.org > > > http://lists.ovirt.org/mailman/listinfo/users > > > > > _______________________________________________ > > Users mailing list > > Users@ovirt.org > > http://lists.ovirt.org/mailman/listinfo/users > > > _______________________________________________ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users >