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