6:10 p.m.
hi
we are running ovirt 3.5.1 and we are trying to setup the dwh part
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 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 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_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 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_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 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)
12:24 p.m.
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 table on 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(a)analytics.brusselsairport.be>
To: users(a)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 part
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 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 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_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 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_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 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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
5:42 p.m.
On 1-2-2015 10:24, Shirly Radco wrote:
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 table on 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';
I suspect I have the same problem. Upgraded (3.5.0->3.5.1) my test
instance at home at look at some reports but saw no new data. Thought is
was just me and had no time to check things out but will do when I have
a bit of time and report back.
Regards,
Joop
11:32 a.m.
Hi,
I am also facing the same issue with ovirt reports and DWH....still didn't
find any way to solve it....is there any body from community can help...
On Sun, Feb 1, 2015 at 10:42 PM, Joop <jvdwege(a)xs4all.nl> wrote:
On 1-2-2015 10:24, Shirly Radco wrote:
> 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 table on 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';
>
>
I suspect I have the same problem. Upgraded (3.5.0->3.5.1) my test
instance at home at look at some reports but saw no new data. Thought is
was just me and had no time to check things out but will do when I have
a bit of time and report back.
Regards,
Joop
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
1:59 p.m.
Hi,
After researching this issue it seams that this is a one time error that should be
resolved after a minute.
Can you please share with me:
1. if you keep getting this error after a minute ?
2. if you can currently log to your ovirt-engine-history database and see if you see in
the vm_samples_history table new up to date samples?
Thank you for sharing and helping with this issue.
Best regards,
---
Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
----- Original Message -----
From: "Punit Dambiwal" <hypunit(a)gmail.com>
To: "Joop" <jvdwege(a)xs4all.nl>
Cc: users(a)ovirt.org
Sent: Monday, February 2, 2015 10:32:21 AM
Subject: Re: [ovirt-users] dwh not receiving any data
Hi,
I am also facing the same issue with ovirt reports and DWH....still didn't
find any way to solve it....is there any body from community can help...
On Sun, Feb 1, 2015 at 10:42 PM, Joop < jvdwege(a)xs4all.nl > wrote:
On 1-2-2015 10:24, Shirly Radco wrote:
> 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 table on 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';
>
>
I suspect I have the same problem. Upgraded (3.5.0->3.5.1) my test
instance at home at look at some reports but saw no new data. Thought is
was just me and had no time to check things out but will do when I have
a bit of time and report back.
Regards,
Joop
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
2:04 p.m.
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(a)redhat.com>
To: "David van zeebroeck" <david(a)analytics.brusselsairport.be>
Cc: users(a)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 table on 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(a)analytics.brusselsairport.be>
> To: users(a)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 part
> 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 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 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_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 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_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 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(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
3:25 p.m.
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 the issue.
Best regards,
---
Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
----- Original Message -----
From: "Shirly Radco" <sradco(a)redhat.com>
To: "David van zeebroeck" <david(a)analytics.brusselsairport.be>
Cc: users(a)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(a)redhat.com>
> To: "David van zeebroeck" <david(a)analytics.brusselsairport.be>
> Cc: users(a)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 table on 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(a)analytics.brusselsairport.be>
> > To: users(a)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 part
> > 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 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 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_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 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_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 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(a)ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> >
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
4:34 a.m.
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(a)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 the issue.
Best regards,
---
Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
----- Original Message -----
> From: "Shirly Radco" <sradco(a)redhat.com>
> To: "David van zeebroeck" <david(a)analytics.brusselsairport.be>
> Cc: users(a)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(a)redhat.com>
> > To: "David van zeebroeck" <david(a)analytics.brusselsairport.be>
> > Cc: users(a)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 table on
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(a)analytics.brusselsairport.be>
> > > To: users(a)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 part
> > > 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 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 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_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 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_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 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(a)ovirt.org
> > > http://lists.ovirt.org/mailman/listinfo/users
> > >
> > _______________________________________________
> > Users mailing list
> > Users(a)ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> >
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
6:50 a.m.
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(a)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(a)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 the
> issue.
>
> Best regards,
> ---
> Shirly Radco
> BI Software Engineer
> Red Hat Israel Ltd.
>
>
> ----- Original Message -----
> > From: "Shirly Radco" <sradco(a)redhat.com>
> > To: "David van zeebroeck" <david(a)analytics.brusselsairport.be>
> > Cc: users(a)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(a)redhat.com>
> > > To: "David van zeebroeck"
<david(a)analytics.brusselsairport.be>
> > > Cc: users(a)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 table on
> 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(a)analytics.brusselsairport.be>
> > > > To: users(a)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 part
> > > > 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 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 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_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 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_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 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(a)ovirt.org
> > > > http://lists.ovirt.org/mailman/listinfo/users
> > > >
> > > _______________________________________________
> > > Users mailing list
> > > Users(a)ovirt.org
> > > http://lists.ovirt.org/mailman/listinfo/users
> > >
> > _______________________________________________
> > Users mailing list
> > Users(a)ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> >
>
8:56 a.m.
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(a)gmail.com>
To: "Shirly Radco" <sradco(a)redhat.com>
Cc: "David van zeebroeck" <david(a)analytics.brusselsairport.be>,
"Joop" <jvdwege(a)xs4all.nl>, users(a)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(a)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(a)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 the
>> issue.
>>
>> Best regards,
>> ---
>> Shirly Radco
>> BI Software Engineer
>> Red Hat Israel Ltd.
>>
>>
>> ----- Original Message -----
>> > From: "Shirly Radco" <sradco(a)redhat.com>
>> > To: "David van zeebroeck"
<david(a)analytics.brusselsairport.be>
>> > Cc: users(a)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(a)redhat.com>
>> > > To: "David van zeebroeck"
<david(a)analytics.brusselsairport.be>
>> > > Cc: users(a)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 table
on
>> 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(a)analytics.brusselsairport.be>
>> > > > To: users(a)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
part
>> > > > 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
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 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_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 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_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 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(a)ovirt.org
>> > > > http://lists.ovirt.org/mailman/listinfo/users
>> > > >
>> > > _______________________________________________
>> > > Users mailing list
>> > > Users(a)ovirt.org
>> > > http://lists.ovirt.org/mailman/listinfo/users
>> > >
>> > _______________________________________________
>> > Users mailing list
>> > Users(a)ovirt.org
>> > http://lists.ovirt.org/mailman/listinfo/users
>> >
>>
>
>
9:31 a.m.
Hi Shirly,
Please find the attached log files...
On Tue, Feb 3, 2015 at 1:56 PM, Shirly Radco <sradco(a)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(a)gmail.com>
> To: "Shirly Radco" <sradco(a)redhat.com>
> Cc: "David van zeebroeck" <david(a)analytics.brusselsairport.be>,
"Joop" <
jvdwege(a)xs4all.nl>, users(a)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(a)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(a)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 the
> >> issue.
> >>
> >> Best regards,
> >> ---
> >> Shirly Radco
> >> BI Software Engineer
> >> Red Hat Israel Ltd.
> >>
> >>
> >> ----- Original Message -----
> >> > From: "Shirly Radco" <sradco(a)redhat.com>
> >> > To: "David van zeebroeck"
<david(a)analytics.brusselsairport.be>
> >> > Cc: users(a)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(a)redhat.com>
> >> > > To: "David van zeebroeck"
<david(a)analytics.brusselsairport.be>
> >> > > Cc: users(a)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
table
on
> >> 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(a)analytics.brusselsairport.be
>
> >> > > > To: users(a)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
part
> >> > > > 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
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
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_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
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_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
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(a)ovirt.org
> >> > > > http://lists.ovirt.org/mailman/listinfo/users
> >> > > >
> >> > > _______________________________________________
> >> > > Users mailing list
> >> > > Users(a)ovirt.org
> >> > > http://lists.ovirt.org/mailman/listinfo/users
> >> > >
> >> > _______________________________________________
> >> > Users mailing list
> >> > Users(a)ovirt.org
> >> > http://lists.ovirt.org/mailman/listinfo/users
> >> >
> >>
> >
> >
>
9:38 a.m.
Please attach all logs under the mentioned folders.
Best,
---
Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
----- Original Message -----
From: "Punit Dambiwal" <hypunit(a)gmail.com>
To: "Shirly Radco" <sradco(a)redhat.com>
Cc: "David van zeebroeck" <david(a)analytics.brusselsairport.be>,
"Joop" <jvdwege(a)xs4all.nl>, users(a)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(a)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(a)gmail.com>
> > To: "Shirly Radco" <sradco(a)redhat.com>
> > Cc: "David van zeebroeck" <david(a)analytics.brusselsairport.be>,
"Joop" <
> jvdwege(a)xs4all.nl>, users(a)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(a)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(a)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 the
> > >> issue.
> > >>
> > >> Best regards,
> > >> ---
> > >> Shirly Radco
> > >> BI Software Engineer
> > >> Red Hat Israel Ltd.
> > >>
> > >>
> > >> ----- Original Message -----
> > >> > From: "Shirly Radco" <sradco(a)redhat.com>
> > >> > To: "David van zeebroeck"
<david(a)analytics.brusselsairport.be>
> > >> > Cc: users(a)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(a)redhat.com>
> > >> > > To: "David van zeebroeck"
<david(a)analytics.brusselsairport.be>
> > >> > > Cc: users(a)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 table
> on
> > >> 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(a)analytics.brusselsairport.be
> >
> > >> > > > To: users(a)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
> part
> > >> > > > 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
> 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
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_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
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_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
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(a)ovirt.org
> > >> > > > http://lists.ovirt.org/mailman/listinfo/users
> > >> > > >
> > >> > > _______________________________________________
> > >> > > Users mailing list
> > >> > > Users(a)ovirt.org
> > >> > > http://lists.ovirt.org/mailman/listinfo/users
> > >> > >
> > >> > _______________________________________________
> > >> > Users mailing list
> > >> > Users(a)ovirt.org
> > >> > http://lists.ovirt.org/mailman/listinfo/users
> > >> >
> > >>
> > >
> > >
> >
>
9:44 a.m.
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(a)redhat.com> wrote:
Please attach all logs under the mentioned folders.
Best,
---
Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
----- Original Message -----
> From: "Punit Dambiwal" <hypunit(a)gmail.com>
> To: "Shirly Radco" <sradco(a)redhat.com>
> Cc: "David van zeebroeck" <david(a)analytics.brusselsairport.be>,
"Joop" <
jvdwege(a)xs4all.nl>, users(a)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(a)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(a)gmail.com>
> > > To: "Shirly Radco" <sradco(a)redhat.com>
> > > Cc: "David van zeebroeck"
<david(a)analytics.brusselsairport.be>,
"Joop" <
> > jvdwege(a)xs4all.nl>, users(a)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(a)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(a)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
the
> > > >> issue.
> > > >>
> > > >> Best regards,
> > > >> ---
> > > >> Shirly Radco
> > > >> BI Software Engineer
> > > >> Red Hat Israel Ltd.
> > > >>
> > > >>
> > > >> ----- Original Message -----
> > > >> > From: "Shirly Radco" <sradco(a)redhat.com>
> > > >> > To: "David van zeebroeck"
<david(a)analytics.brusselsairport.be>
> > > >> > Cc: users(a)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(a)redhat.com>
> > > >> > > To: "David van zeebroeck"
<david(a)analytics.brusselsairport.be
>
> > > >> > > Cc: users(a)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
table
> > on
> > > >> 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(a)analytics.brusselsairport.be
> > >
> > > >> > > > To: users(a)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
> > part
> > > >> > > > 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
> > 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
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_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
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_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
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(a)ovirt.org
> > > >> > > > http://lists.ovirt.org/mailman/listinfo/users
> > > >> > > >
> > > >> > > _______________________________________________
> > > >> > > Users mailing list
> > > >> > > Users(a)ovirt.org
> > > >> > > http://lists.ovirt.org/mailman/listinfo/users
> > > >> > >
> > > >> > _______________________________________________
> > > >> > Users mailing list
> > > >> > Users(a)ovirt.org
> > > >> > http://lists.ovirt.org/mailman/listinfo/users
> > > >> >
> > > >>
> > > >
> > > >
> > >
> >
>
2:29 p.m.
The logs seem ok, is there a chance you simply don't have activity after
17:00?
try to hover around the bottom of the graph a tool tip should appear if
the value and if it's 0%.
On 02/03/2015 08:31 AM, Punit Dambiwal wrote:
Hi Shirly,
Please find the attached log files...
On Tue, Feb 3, 2015 at 1:56 PM, Shirly Radco <sradco(a)redhat.com
<mailto: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(a)gmail.com
<mailto:hypunit@gmail.com>>
> To: "Shirly Radco" <sradco(a)redhat.com
<mailto:sradco@redhat.com>>
> Cc: "David van zeebroeck" <david(a)analytics.brusselsairport.be
<mailto:david@analytics.brusselsairport.be>>, "Joop"
<jvdwege(a)xs4all.nl <mailto:jvdwege@xs4all.nl>>, users(a)ovirt.org
<mailto: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(a)gmail.com <mailto: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(a)redhat.com <mailto: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 the
> >> issue.
> >>
> >> Best regards,
> >> ---
> >> Shirly Radco
> >> BI Software Engineer
> >> Red Hat Israel Ltd.
> >>
> >>
> >> ----- Original Message -----
> >> > From: "Shirly Radco" <sradco(a)redhat.com
<mailto:sradco@redhat.com>>
> >> > To: "David van zeebroeck"
<david(a)analytics.brusselsairport.be
<mailto:david@analytics.brusselsairport.be>>
> >> > Cc: users(a)ovirt.org <mailto: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(a)redhat.com
<mailto:sradco@redhat.com>>
> >> > > To: "David van zeebroeck"
<david(a)analytics.brusselsairport.be
<mailto:david@analytics.brusselsairport.be>>
> >> > > Cc: users(a)ovirt.org <mailto: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 table on
> >> 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(a)analytics.brusselsairport.be
<mailto:david@analytics.brusselsairport.be>>
> >> > > > To: users(a)ovirt.org <mailto: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 part
> >> > > > 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 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
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_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
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_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
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(a)ovirt.org <mailto:Users@ovirt.org>
> >> > > > http://lists.ovirt.org/mailman/listinfo/users
> >> > > >
> >> > > _______________________________________________
> >> > > Users mailing list
> >> > > Users(a)ovirt.org <mailto:Users@ovirt.org>
> >> > > http://lists.ovirt.org/mailman/listinfo/users
> >> > >
> >> > _______________________________________________
> >> > Users mailing list
> >> > Users(a)ovirt.org <mailto:Users@ovirt.org>
> >> > http://lists.ovirt.org/mailman/listinfo/users
> >> >
> >>
> >
> >
>
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
--
Yaniv Dary
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109
Tel : +972 (9) 7692306
8272306
Email: ydary(a)redhat.com
IRC : ydary
2:30 p.m.
Also is there a chance the vm was shutdown?
On 02/03/2015 01:29 PM, Yaniv Dary wrote:
The logs seem ok, is there a chance you simply don't have
activity
after 17:00?
try to hover around the bottom of the graph a tool tip should appear
if the value and if it's 0%.
On 02/03/2015 08:31 AM, Punit Dambiwal wrote:
> Hi Shirly,
>
> Please find the attached log files...
>
> On Tue, Feb 3, 2015 at 1:56 PM, Shirly Radco <sradco(a)redhat.com
> <mailto: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(a)gmail.com
> <mailto:hypunit@gmail.com>>
> > To: "Shirly Radco" <sradco(a)redhat.com
<mailto:sradco@redhat.com>>
> > Cc: "David van zeebroeck" <david(a)analytics.brusselsairport.be
> <mailto:david@analytics.brusselsairport.be>>, "Joop"
> <jvdwege(a)xs4all.nl <mailto:jvdwege@xs4all.nl>>, users(a)ovirt.org
> <mailto: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(a)gmail.com <mailto: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(a)redhat.com <mailto: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 the
> > >> issue.
> > >>
> > >> Best regards,
> > >> ---
> > >> Shirly Radco
> > >> BI Software Engineer
> > >> Red Hat Israel Ltd.
> > >>
> > >>
> > >> ----- Original Message -----
> > >> > From: "Shirly Radco" <sradco(a)redhat.com
> <mailto:sradco@redhat.com>>
> > >> > To: "David van zeebroeck"
> <david(a)analytics.brusselsairport.be
> <mailto:david@analytics.brusselsairport.be>>
> > >> > Cc: users(a)ovirt.org <mailto: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(a)redhat.com
> <mailto:sradco@redhat.com>>
> > >> > > To: "David van zeebroeck"
> <david(a)analytics.brusselsairport.be
> <mailto:david@analytics.brusselsairport.be>>
> > >> > > Cc: users(a)ovirt.org <mailto: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 table on
> > >> 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(a)analytics.brusselsairport.be
> <mailto:david@analytics.brusselsairport.be>>
> > >> > > > To: users(a)ovirt.org <mailto: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 part
> > >> > > > 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 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
> 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_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
> 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_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
> 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(a)ovirt.org <mailto:Users@ovirt.org>
> > >> > > > http://lists.ovirt.org/mailman/listinfo/users
> > >> > > >
> > >> > > _______________________________________________
> > >> > > Users mailing list
> > >> > > Users(a)ovirt.org <mailto:Users@ovirt.org>
> > >> > > http://lists.ovirt.org/mailman/listinfo/users
> > >> > >
> > >> > _______________________________________________
> > >> > Users mailing list
> > >> > Users(a)ovirt.org <mailto:Users@ovirt.org>
> > >> > http://lists.ovirt.org/mailman/listinfo/users
> > >> >
> > >>
> > >
> > >
> >
>
>
>
>
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
--
Yaniv Dary
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109
Tel : +972 (9) 7692306
8272306
Email: ydary(a)redhat.com
IRC : ydary
4:33 a.m.
Hi,
VM is up and running and to make the graph....i manually make some dd and
cpu stress on the VM....
I created the dump with Ovirt backup tool....
engine-backup --mode=backup --scope=db --file=BACKUP_FILE --log=LOG_FILE
I also communicated with ovirt-china community...they found that there is
some time difference between postgres and jdk...
[image: Inline image 1]
Thanks,
Punit
Thanks,
Punit
On Tue, Feb 3, 2015 at 7:30 PM, Yaniv Dary <ydary(a)redhat.com> wrote:
Also is there a chance the vm was shutdown?
On 02/03/2015 01:29 PM, Yaniv Dary wrote:
> The logs seem ok, is there a chance you simply don't have activity after
> 17:00?
> try to hover around the bottom of the graph a tool tip should appear if
> the value and if it's 0%.
>
>
> On 02/03/2015 08:31 AM, Punit Dambiwal wrote:
>
>> Hi Shirly,
>>
>> Please find the attached log files...
>>
>> On Tue, Feb 3, 2015 at 1:56 PM, Shirly Radco <sradco(a)redhat.com <mailto:
>> sradco(a)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(a)gmail.com
>> <mailto:hypunit@gmail.com>>
>> > To: "Shirly Radco" <sradco(a)redhat.com
<mailto:sradco@redhat.com>>
>> > Cc: "David van zeebroeck"
<david(a)analytics.brusselsairport.be
>> <mailto:david@analytics.brusselsairport.be>>, "Joop"
>> <jvdwege(a)xs4all.nl <mailto:jvdwege@xs4all.nl>>, users(a)ovirt.org
>> <mailto: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(a)gmail.com <mailto: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(a)redhat.com <mailto: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 the
>> > >> issue.
>> > >>
>> > >> Best regards,
>> > >> ---
>> > >> Shirly Radco
>> > >> BI Software Engineer
>> > >> Red Hat Israel Ltd.
>> > >>
>> > >>
>> > >> ----- Original Message -----
>> > >> > From: "Shirly Radco" <sradco(a)redhat.com
>> <mailto:sradco@redhat.com>>
>> > >> > To: "David van zeebroeck"
>> <david(a)analytics.brusselsairport.be
>> <mailto:david@analytics.brusselsairport.be>>
>> > >> > Cc: users(a)ovirt.org <mailto: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(a)redhat.com
>> <mailto:sradco@redhat.com>>
>> > >> > > To: "David van zeebroeck"
>> <david(a)analytics.brusselsairport.be
>> <mailto:david@analytics.brusselsairport.be>>
>> > >> > > Cc: users(a)ovirt.org <mailto: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 table on
>> > >> 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(a)analytics.brusselsairport.be
>> <mailto:david@analytics.brusselsairport.be>>
>> > >> > > > To: users(a)ovirt.org
<mailto: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 part
>> > >> > > > 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 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
>> 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_
>> 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
>> 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_
>> 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
>> 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(a)ovirt.org <mailto:Users@ovirt.org>
>> > >> > > > http://lists.ovirt.org/mailman/listinfo/users
>> > >> > > >
>> > >> > > _______________________________________________
>> > >> > > Users mailing list
>> > >> > > Users(a)ovirt.org <mailto:Users@ovirt.org>
>> > >> > > http://lists.ovirt.org/mailman/listinfo/users
>> > >> > >
>> > >> > _______________________________________________
>> > >> > Users mailing list
>> > >> > Users(a)ovirt.org <mailto:Users@ovirt.org>
>> > >> > http://lists.ovirt.org/mailman/listinfo/users
>> > >> >
>> > >>
>> > >
>> > >
>> >
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users(a)ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
>
>
--
Yaniv Dary
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109
Tel : +972 (9) 7692306
8272306
Email: ydary(a)redhat.com
IRC : ydary
2:11 p.m.
About this issue, our best practice is to use UTC time for all the
machines and sync them with nfp.
We have a bug open on moving to ISO time to resolve some issues with
date pattern, but it's not in yet.
Yaniv
On 02/04/2015 03:33 AM, Punit Dambiwal wrote:
Hi,
VM is up and running and to make the graph....i manually make some dd
and cpu stress on the VM....
I created the dump with Ovirt backup tool....
engine-backup --mode=backup --scope=db --file=BACKUP_FILE --log=LOG_FILE
I also communicated with ovirt-china community...they found that there
is some time difference between postgres and jdk...
Inline image 1
Thanks,
Punit
Thanks,
Punit
On Tue, Feb 3, 2015 at 7:30 PM, Yaniv Dary <ydary(a)redhat.com
<mailto:ydary@redhat.com>> wrote:
Also is there a chance the vm was shutdown?
On 02/03/2015 01:29 PM, Yaniv Dary wrote:
The logs seem ok, is there a chance you simply don't have
activity after 17:00?
try to hover around the bottom of the graph a tool tip should
appear if the value and if it's 0%.
On 02/03/2015 08:31 AM, Punit Dambiwal wrote:
Hi Shirly,
Please find the attached log files...
On Tue, Feb 3, 2015 at 1:56 PM, Shirly Radco
<sradco(a)redhat.com <mailto:sradco@redhat.com>
<mailto:sradco@redhat.com <mailto: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(a)gmail.com
<mailto:hypunit@gmail.com>
<mailto:hypunit@gmail.com <mailto:hypunit@gmail.com>>>
> To: "Shirly Radco" <sradco(a)redhat.com
<mailto:sradco@redhat.com> <mailto:sradco@redhat.com
<mailto:sradco@redhat.com>>>
> Cc: "David van zeebroeck"
<david(a)analytics.brusselsairport.be
<mailto:david@analytics.brusselsairport.be>
<mailto:david@analytics.brusselsairport.be
<mailto:david@analytics.brusselsairport.be>>>, "Joop"
<jvdwege(a)xs4all.nl <mailto:jvdwege@xs4all.nl>
<mailto:jvdwege@xs4all.nl <mailto:jvdwege@xs4all.nl>>>,
users(a)ovirt.org <mailto:users@ovirt.org>
<mailto:users@ovirt.org <mailto: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(a)gmail.com <mailto:hypunit@gmail.com>
<mailto:hypunit@gmail.com <mailto: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(a)redhat.com <mailto:sradco@redhat.com>
<mailto:sradco@redhat.com <mailto: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 the
> >> issue.
> >>
> >> Best regards,
> >> ---
> >> Shirly Radco
> >> BI Software Engineer
> >> Red Hat Israel Ltd.
> >>
> >>
> >> ----- Original Message -----
> >> > From: "Shirly Radco" <sradco(a)redhat.com
<mailto:sradco@redhat.com>
<mailto:sradco@redhat.com <mailto:sradco@redhat.com>>>
> >> > To: "David van zeebroeck"
<david(a)analytics.brusselsairport.be
<mailto:david@analytics.brusselsairport.be>
<mailto:david@analytics.brusselsairport.be
<mailto:david@analytics.brusselsairport.be>>>
> >> > Cc: users(a)ovirt.org <mailto:users@ovirt.org>
<mailto:users@ovirt.org <mailto: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(a)redhat.com
<mailto:sradco@redhat.com>
<mailto:sradco@redhat.com <mailto:sradco@redhat.com>>>
> >> > > To: "David van zeebroeck"
<david(a)analytics.brusselsairport.be
<mailto:david@analytics.brusselsairport.be>
<mailto:david@analytics.brusselsairport.be
<mailto:david@analytics.brusselsairport.be>>>
> >> > > Cc: users(a)ovirt.org
<mailto:users@ovirt.org>
<mailto:users@ovirt.org <mailto: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 table on
> >> 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(a)analytics.brusselsairport.be
<mailto:david@analytics.brusselsairport.be>
<mailto:david@analytics.brusselsairport.be
<mailto:david@analytics.brusselsairport.be>>>
> >> > > > To: users(a)ovirt.org
<mailto:users@ovirt.org> <mailto:users@ovirt.org
<mailto: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 part
> >> > > > 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 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
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_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
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_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
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(a)ovirt.org
<mailto:Users@ovirt.org>
<mailto:Users@ovirt.org <mailto:Users@ovirt.org>>
> >> > > >
http://lists.ovirt.org/mailman/listinfo/users
> >> > > >
> >> > > _______________________________________________
> >> > > Users mailing list
> >> > > Users(a)ovirt.org <mailto:Users@ovirt.org>
<mailto:Users@ovirt.org <mailto:Users@ovirt.org>>
> >> > > http://lists.ovirt.org/mailman/listinfo/users
> >> > >
> >> > _______________________________________________
> >> > Users mailing list
> >> > Users(a)ovirt.org <mailto:Users@ovirt.org>
<mailto:Users@ovirt.org <mailto:Users@ovirt.org>>
> >> > http://lists.ovirt.org/mailman/listinfo/users
> >> >
> >>
> >
> >
>
_______________________________________________
Users mailing list
Users(a)ovirt.org <mailto:Users@ovirt.org>
http://lists.ovirt.org/mailman/listinfo/users
--
Yaniv Dary
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109
Tel : +972 (9) 7692306 <tel:%2B972%20%289%29%207692306>
8272306
Email: ydary(a)redhat.com <mailto:ydary@redhat.com>
IRC : ydary
--
Yaniv Dary
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109
Tel : +972 (9) 7692306
8272306
Email: ydary(a)redhat.com
IRC : ydary
5:15 a.m.
Hi,
I have solve this issue by manually updated the time of the "lastHourAggr"
in the ovirt_engine_history database...as it was running with wrong
time....after update it's ok....
--------------
ovirt_engine_history=> update history_configuration set var_datetime = 'Thu
Feb 5 10:10:00 HKT 2015' where var_name = 'lastHourAggr';
--------------
Thanks,
Punit
On Wed, Feb 4, 2015 at 7:11 PM, Yaniv Dary <ydary(a)redhat.com> wrote:
About this issue, our best practice is to use UTC time for all the
machines and sync them with nfp.
We have a bug open on moving to ISO time to resolve some issues with date
pattern, but it's not in yet.
Yaniv
On 02/04/2015 03:33 AM, Punit Dambiwal wrote:
> Hi,
>
> VM is up and running and to make the graph....i manually make some dd and
> cpu stress on the VM....
>
> I created the dump with Ovirt backup tool....
>
> engine-backup --mode=backup --scope=db --file=BACKUP_FILE --log=LOG_FILE
>
> I also communicated with ovirt-china community...they found that there is
> some time difference between postgres and jdk...
>
> Inline image 1
>
> Thanks,
> Punit
>
> Thanks,
> Punit
>
> On Tue, Feb 3, 2015 at 7:30 PM, Yaniv Dary <ydary(a)redhat.com <mailto:
> ydary(a)redhat.com>> wrote:
>
> Also is there a chance the vm was shutdown?
>
>
>
> On 02/03/2015 01:29 PM, Yaniv Dary wrote:
>
> The logs seem ok, is there a chance you simply don't have
> activity after 17:00?
> try to hover around the bottom of the graph a tool tip should
> appear if the value and if it's 0%.
>
>
> On 02/03/2015 08:31 AM, Punit Dambiwal wrote:
>
> Hi Shirly,
>
> Please find the attached log files...
>
> On Tue, Feb 3, 2015 at 1:56 PM, Shirly Radco
> <sradco(a)redhat.com <mailto:sradco@redhat.com>
> <mailto:sradco@redhat.com <mailto: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(a)gmail.com
> <mailto:hypunit@gmail.com>
> <mailto:hypunit@gmail.com
<mailto:hypunit@gmail.com>>>
> > To: "Shirly Radco" <sradco(a)redhat.com
> <mailto:sradco@redhat.com> <mailto:sradco@redhat.com
> <mailto:sradco@redhat.com>>>
> > Cc: "David van zeebroeck"
> <david(a)analytics.brusselsairport.be
> <mailto:david@analytics.brusselsairport.be>
> <mailto:david@analytics.brusselsairport.be
> <mailto:david@analytics.brusselsairport.be>>>,
"Joop"
> <jvdwege(a)xs4all.nl <mailto:jvdwege@xs4all.nl>
> <mailto:jvdwege@xs4all.nl <mailto:jvdwege@xs4all.nl>>>,
> users(a)ovirt.org <mailto:users@ovirt.org>
> <mailto:users@ovirt.org <mailto: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(a)gmail.com <mailto:hypunit@gmail.com>
> <mailto:hypunit@gmail.com <mailto: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(a)redhat.com <mailto:sradco@redhat.com>
> <mailto:sradco@redhat.com <mailto: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 the
> > >> issue.
> > >>
> > >> Best regards,
> > >> ---
> > >> Shirly Radco
> > >> BI Software Engineer
> > >> Red Hat Israel Ltd.
> > >>
> > >>
> > >> ----- Original Message -----
> > >> > From: "Shirly Radco"
<sradco(a)redhat.com
> <mailto:sradco@redhat.com>
> <mailto:sradco@redhat.com
<mailto:sradco@redhat.com>>>
> > >> > To: "David van zeebroeck"
> <david(a)analytics.brusselsairport.be
> <mailto:david@analytics.brusselsairport.be>
> <mailto:david@analytics.brusselsairport.be
> <mailto:david@analytics.brusselsairport.be>>>
> > >> > Cc: users(a)ovirt.org
<mailto:users@ovirt.org>
> <mailto:users@ovirt.org <mailto: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(a)redhat.com
> <mailto:sradco@redhat.com>
> <mailto:sradco@redhat.com
<mailto:sradco@redhat.com>>>
> > >> > > To: "David van zeebroeck"
> <david(a)analytics.brusselsairport.be
> <mailto:david@analytics.brusselsairport.be>
> <mailto:david@analytics.brusselsairport.be
> <mailto:david@analytics.brusselsairport.be>>>
> > >> > > Cc: users(a)ovirt.org
<mailto:users@ovirt.org>
> <mailto:users@ovirt.org <mailto: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 table on
> > >> 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(a)analytics.brusselsairport.be
> <mailto:david@analytics.brusselsairport.be>
> <mailto:david@analytics.brusselsairport.be
> <mailto:david@analytics.brusselsairport.be>>>
> > >> > > > To: users(a)ovirt.org
> <mailto:users@ovirt.org> <mailto:users@ovirt.org
> <mailto: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 part
> > >> > > > 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 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
> 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_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
> 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_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
> 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(a)ovirt.org
<mailto:Users@ovirt.org>
> <mailto:Users@ovirt.org <mailto:Users@ovirt.org>>
> > >> > > >
http://lists.ovirt.org/mailman/listinfo/users
> > >> > > >
> > >> > >
_______________________________________________
> > >> > > Users mailing list
> > >> > > Users(a)ovirt.org
<mailto:Users@ovirt.org>
> <mailto:Users@ovirt.org <mailto:Users@ovirt.org>>
> > >> > >
http://lists.ovirt.org/mailman/listinfo/users
> > >> > >
> > >> > _______________________________________________
> > >> > Users mailing list
> > >> > Users(a)ovirt.org <mailto:Users@ovirt.org>
> <mailto:Users@ovirt.org <mailto:Users@ovirt.org>>
> > >> > http://lists.ovirt.org/mailman/listinfo/users
> > >> >
> > >>
> > >
> > >
> >
>
>
>
>
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org <mailto:Users@ovirt.org>
> http://lists.ovirt.org/mailman/listinfo/users
>
>
>
> -- Yaniv Dary
> Red Hat Israel Ltd.
> 34 Jerusalem Road
> Building A, 4th floor
> Ra'anana, Israel 4350109
>
> Tel : +972 (9) 7692306 <tel:%2B972%20%289%29%207692306>
> 8272306
> Email: ydary(a)redhat.com <mailto:ydary@redhat.com>
> IRC : ydary
>
>
>
--
Yaniv Dary
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109
Tel : +972 (9) 7692306
8272306
Email: ydary(a)redhat.com
IRC : ydary
10:52 a.m.
On 6-2-2015 3:15, Punit Dambiwal wrote:
Hi,
I have solve this issue by manually updated the time of the
"lastHourAggr" in the ovirt_engine_history database...as it was
running with wrong time....after update it's ok....
-
I'm sorry but I seem to have no problem after all. If I look at the
report @09:00 then I'll see that it plots data upto about 07:00 and that
is what threw me off. I checked the reports about an hour after upgrading.
Joop
11:12 a.m.
Yes...you are right but earlier my server date is behind the
lasthouraggr.....such as the server time is "3:00" AM but when i check the
"lasthouraggr" in the database it was 14:00..it should be 1:00 AM...that's
why i manually updated it...
As name suggested lasthouraggr that means it should be lower then your
current server time...
Thanks,
Punit
On Fri, Feb 6, 2015 at 3:52 PM, noc <noc(a)nieuwland.nl> wrote:
On 6-2-2015 3:15, Punit Dambiwal wrote:
> Hi,
>
> I have solve this issue by manually updated the time of the
> "lastHourAggr" in the ovirt_engine_history database...as it was
> running with wrong time....after update it's ok....
>
> -
I'm sorry but I seem to have no problem after all. If I look at the
report @09:00 then I'll see that it plots data upto about 07:00 and that
is what threw me off. I checked the reports about an hour after upgrading.
Joop
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
9:25 a.m.
Hi Punit,
We are aware of time issue with the way China time is being dealt differently in Postgres
and Java and will work to fix this.
This is the reason we recommend for now to use UTC time for the servers.
Best regards,
---
Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
----- Original Message -----
From: "Punit Dambiwal" <hypunit(a)gmail.com>
To: "noc" <noc(a)nieuwland.nl>
Cc: users(a)ovirt.org
Sent: Friday, February 6, 2015 10:12:38 AM
Subject: Re: [ovirt-users] dwh not receiving any data
Yes...you are right but earlier my server date is behind the
lasthouraggr.....such as the server time is "3:00" AM but when i check the
"lasthouraggr" in the database it was 14:00..it should be 1:00 AM...that's
why i manually updated it...
As name suggested lasthouraggr that means it should be lower then your
current server time...
Thanks,
Punit
On Fri, Feb 6, 2015 at 3:52 PM, noc < noc(a)nieuwland.nl > wrote:
On 6-2-2015 3:15, Punit Dambiwal wrote:
> Hi,
>
> I have solve this issue by manually updated the time of the
> "lastHourAggr" in the ovirt_engine_history database...as it was
> running with wrong time....after update it's ok....
>
> -
I'm sorry but I seem to have no problem after all. If I look at the
report @09:00 then I'll see that it plots data upto about 07:00 and that
is what threw me off. I checked the reports about an hour after upgrading.
Joop
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
3575
days inactive
3585
days old
20 comments
6 participants
participants (6)
-
David van zeebroeck -
Joop -
noc -
Punit Dambiwal -
Shirly Radco -
Yaniv Dary