<div dir="ltr"><div>Hi,</div><div><br></div><div>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....</div><div><br></div><div>--------------</div><div>ovirt_engine_history=> update history_configuration set var_datetime = 'Thu Feb 5 10:10:00 HKT 2015' where var_name = 'lastHourAggr';<br></div><div>--------------</div><div><br></div><div>Thanks,</div><div>Punit</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Feb 4, 2015 at 7:11 PM, Yaniv Dary <span dir="ltr"><<a href="mailto:ydary@redhat.com" target="_blank">ydary@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">About this issue, our best practice is to use UTC time for all the machines and sync them with nfp.<br>
We have a bug open on moving to ISO time to resolve some issues with date pattern, but it's not in yet.<br>
<br>
<br>
<br>
Yaniv<span class=""><br>
<br>
<br>
On 02/04/2015 03:33 AM, Punit Dambiwal wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
Hi,<br>
<br>
VM is up and running and to make the graph....i manually make some dd and cpu stress on the VM....<br>
<br>
I created the dump with Ovirt backup tool....<br>
<br>
engine-backup --mode=backup --scope=db --file=BACKUP_FILE --log=LOG_FILE<br>
<br>
I also communicated with ovirt-china community...they found that there is some time difference between postgres and jdk...<br>
<br></span><span class="">
Inline image 1<br>
<br>
Thanks,<br>
Punit<br>
<br>
Thanks,<br>
Punit<br>
<br></span><span class="">
On Tue, Feb 3, 2015 at 7:30 PM, Yaniv Dary <<a href="mailto:ydary@redhat.com" target="_blank">ydary@redhat.com</a> <mailto:<a href="mailto:ydary@redhat.com" target="_blank">ydary@redhat.com</a>>> wrote:<br>
<br>
Also is there a chance the vm was shutdown?<br>
<br>
<br>
<br>
On 02/03/2015 01:29 PM, Yaniv Dary wrote:<br>
<br>
The logs seem ok, is there a chance you simply don't have<br>
activity after 17:00?<br>
try to hover around the bottom of the graph a tool tip should<br>
appear if the value and if it's 0%.<br>
<br>
<br>
On 02/03/2015 08:31 AM, Punit Dambiwal wrote:<br>
<br>
Hi Shirly,<br>
<br>
Please find the attached log files...<br>
<br>
On Tue, Feb 3, 2015 at 1:56 PM, Shirly Radco<br>
<<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a> <mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>><br></span><span class="">
<mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a> <mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>>>> wrote:<br>
<br>
Hi Punit,<br>
<br>
Please send me first the logs so we can see if this is<br>
still the<br>
same issue.<br>
/var/log/ovirt-engine<br>
/var/log/ovirt-engine-dwh<br>
/var/log/ovirt-engine-reports<br>
<br>
Best regards,<br>
---<br>
Shirly Radco<br>
BI Software Engineer<br>
Red Hat Israel Ltd.<br>
<br>
<br>
----- Original Message -----<br>
> From: "Punit Dambiwal" <<a href="mailto:hypunit@gmail.com" target="_blank">hypunit@gmail.com</a><br>
<mailto:<a href="mailto:hypunit@gmail.com" target="_blank">hypunit@gmail.com</a>><br></span><span class="">
<mailto:<a href="mailto:hypunit@gmail.com" target="_blank">hypunit@gmail.com</a> <mailto:<a href="mailto:hypunit@gmail.com" target="_blank">hypunit@gmail.com</a>>>><br>
> To: "Shirly Radco" <<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a><br></span><span class="">
<mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>> <mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a><br>
<mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>>>><br>
> Cc: "David van zeebroeck"<br>
<<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a><br>
<mailto:<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a>><br></span>
<mailto:<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a><span class=""><br>
<mailto:<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a>>>>, "Joop"<br>
<<a href="mailto:jvdwege@xs4all.nl" target="_blank">jvdwege@xs4all.nl</a> <mailto:<a href="mailto:jvdwege@xs4all.nl" target="_blank">jvdwege@xs4all.nl</a>><br></span>
<mailto:<a href="mailto:jvdwege@xs4all.nl" target="_blank">jvdwege@xs4all.nl</a> <mailto:<a href="mailto:jvdwege@xs4all.nl" target="_blank">jvdwege@xs4all.nl</a>>>>,<br>
<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a> <mailto:<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a>><br>
<mailto:<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a> <mailto:<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a>>><span class=""><br>
> Sent: Tuesday, February 3, 2015 5:50:57 AM<br>
> Subject: Re: [ovirt-users] dwh not receiving any data<br>
><br>
> Hi Shirly,<br>
><br>
> It seems resolved but actually not....again after 12<br>
hours it<br>
stopped<br>
> working...<br>
><br>
> [image: Inline image 1]<br>
> [image: Inline image 3]<br>
><br>
> It stopped working after 5:00 AM....yesterday (2nd<br>
Feb) started<br>
at evening<br>
> 17:00 PM...and stopped today 3rd Feb 5:00 AM....<br>
><br>
> [image: Inline image 4]<br>
><br>
> Please let me know how i can take the dump of engine<br>
and dwh to<br>
you....<br>
><br>
> Thanks,<br>
> Punit<br>
><br>
> On Tue, Feb 3, 2015 at 9:34 AM, Punit Dambiwal<br>
<<a href="mailto:hypunit@gmail.com" target="_blank">hypunit@gmail.com</a> <mailto:<a href="mailto:hypunit@gmail.com" target="_blank">hypunit@gmail.com</a>><br></span><span class="">
<mailto:<a href="mailto:hypunit@gmail.com" target="_blank">hypunit@gmail.com</a> <mailto:<a href="mailto:hypunit@gmail.com" target="_blank">hypunit@gmail.com</a>>>> wrote:<br>
><br>
> > Hi,<br>
> ><br>
> > My issue resolved by remove the dwh and reports<br>
and reinstall<br>
> > again......also i found that my server time was<br>
correct and<br>
updated but the<br>
> > postgresql time was different form the server<br>
time.....above<br>
two changes<br>
> > made it work...<br>
> ><br>
> > Thanks,<br>
> > punit<br>
> ><br>
> > On Mon, Feb 2, 2015 at 8:25 PM, Shirly Radco<br>
<<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a> <mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>><br></span><span class="">
<mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a> <mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>>>> wrote:<br>
> ><br>
> >> Hi,<br>
> >><br>
> >> If any of you can send me the engine and<br>
ovirt_engine_dwh dump,<br>
> >> I will upload them in my development environment<br>
and see what<br>
is the<br>
> >> issue.<br>
> >><br>
> >> Best regards,<br>
> >> ---<br>
> >> Shirly Radco<br>
> >> BI Software Engineer<br>
> >> Red Hat Israel Ltd.<br>
> >><br>
> >><br>
> >> ----- Original Message -----<br>
> >> > From: "Shirly Radco" <<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a><br>
<mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>><br></span><span class="">
<mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a> <mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>>>><br>
> >> > To: "David van zeebroeck"<br>
<<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a><br>
<mailto:<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a>><br></span><span class="">
<mailto:<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a><br>
<mailto:<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a>>>><br>
> >> > Cc: <a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a> <mailto:<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a>><br></span>
<mailto:<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a> <mailto:<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a>>><span class=""><br>
> >> > Sent: Monday, February 2, 2015 1:04:24 PM<br>
> >> > Subject: Re: [ovirt-users] dwh not receiving<br>
any data<br>
> >> ><br>
> >> > Hi David,<br>
> >> ><br>
> >> > Please update me on what you found.<br>
> >> ><br>
> >> > Best regards,<br>
> >> > ---<br>
> >> > Shirly Radco<br>
> >> > BI Software Engineer<br>
> >> > Red Hat Israel Ltd.<br>
> >> ><br>
> >> ><br>
> >> > ----- Original Message -----<br>
> >> > > From: "Shirly Radco" <<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a><br>
<mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>><br></span><span class="">
<mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a> <mailto:<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>>>><br>
> >> > > To: "David van zeebroeck"<br>
<<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a><br>
<mailto:<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a>><br></span><span class="">
<mailto:<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a><br>
<mailto:<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a>>>><br>
> >> > > Cc: <a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a> <mailto:<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a>><br></span>
<mailto:<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a> <mailto:<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a>>><div><div class="h5"><br>
> >> > > Sent: Sunday, February 1, 2015 11:24:10 AM<br>
> >> > > Subject: Re: [ovirt-users] dwh not receiving<br>
any data<br>
> >> > ><br>
> >> > > Hi David,<br>
> >> > ><br>
> >> > > It means that for some reason user with user_id<br>
> >> > > ab932902-cead-4435-a2b6-<u></u>8b88576feab6<br>
> >> > > was not added to users_details_history.<br>
> >> > > And this is why the etl can't update the<br>
vm_samples_history table on<br>
> >> the<br>
> >> > > ovirt_engine_history database.<br>
> >> > ><br>
> >> > > Please check if this user_id<br>
ab932902-cead-4435-a2b6-<u></u>8b88576feab6<br>
> >> exists in<br>
> >> > > the "dwh_users_history_view" or in the users<br>
table in the<br>
engine<br>
> >> database.<br>
> >> > ><br>
> >> > > Select * From dwh_users_history_view<br>
> >> > > Where user_id =<br>
'ab932902-cead-4435-a2b6-<u></u>8b88576feab6';<br>
> >> > ><br>
> >> > > Best regards,<br>
> >> > > ---<br>
> >> > > Shirly Radco<br>
> >> > > BI Software Engineer<br>
> >> > > Red Hat Israel Ltd.<br>
> >> > ><br>
> >> > ><br>
> >> > > ----- Original Message -----<br>
> >> > > > From: "David van zeebroeck"<br>
<<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a><br>
<mailto:<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a>><br></div></div><span class="">
<mailto:<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a><br>
<mailto:<a href="mailto:david@analytics.brusselsairport.be" target="_blank">david@analytics.<u></u>brusselsairport.be</a>>>><br>
> >> > > > To: <a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a><br></span><div><div class="h5">
<mailto:<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a>> <mailto:<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a><br>
<mailto:<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a>>><br>
> >> > > > Sent: Thursday, January 29, 2015 5:10:01 PM<br>
> >> > > > Subject: [ovirt-users] dwh not receiving<br>
any data<br>
> >> > > ><br>
> >> > > > hi<br>
> >> > > > we are running ovirt 3.5.1 and we are<br>
trying to setup<br>
the dwh part<br>
> >> > > > install and setup appears to run fine but<br>
when starting<br>
the service<br>
> >> we<br>
> >> > > > see<br>
> >> > > > following error in the log file :<br>
> >> > > ><br>
> >> > > > 2015-01-29 16:06:26|ETL Service Started<br>
> >> > > > Exception in component tJDBCOutput_5<br>
> >> > > > org.postgresql.util.<u></u>PSQLException: ERROR:<br>
insert or<br>
update on table<br>
> >> > > > "vm_samples_history" violates foreign key<br>
constraint<br>
> >> > > > "vm_samples_history_current_<u></u>user_id_fkey"<br>
> >> > > > Detail: Key<br>
> >><br>
(current_user_id)=(ab932902-<u></u>cead-4435-a2b6-8b88576feab6) is<br>
> >> > > > not<br>
> >> > > > present in table "users_details_history".<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.core.v3.<u></u>QueryExecutorImpl.<u></u>receiveErrorResponse(<u></u>QueryExecutorImpl.java:2062)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.core.v3.<u></u>QueryExecutorImpl.<u></u>processResults(<u></u>QueryExecutorImpl.java:1795)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.core.v3.<u></u>QueryExecutorImpl.execute(<u></u>QueryExecutorImpl.java:257)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.jdbc2.<u></u>AbstractJdbc2Statement.<u></u>execute(<u></u>AbstractJdbc2Statement.java:<u></u>479)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.jdbc2.<u></u>AbstractJdbc2Statement.<u></u>executeWithFlags(<u></u>AbstractJdbc2Statement.java:<u></u>367)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.jdbc2.<u></u>AbstractJdbc2Statement.<u></u>executeUpdate(<u></u>AbstractJdbc2Statement.java:<u></u>321)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>statisticssync_3_5.<u></u>StatisticsSync.tJDBCInput_<u></u>10Process(StatisticsSync.java:<u></u>10482)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>statisticssync_3_5.<u></u>StatisticsSync$6.run(<u></u>StatisticsSync.java:17437)<br>
> >> > > > Exception in component tJDBCOutput_6<br>
> >> > > > org.postgresql.util.<u></u>PSQLException: ERROR:<br>
current<br>
transaction is<br>
> >> aborted,<br>
> >> > > > commands ignored until end of transaction block<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.core.v3.<u></u>QueryExecutorImpl.<u></u>receiveErrorResponse(<u></u>QueryExecutorImpl.java:2062)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.core.v3.<u></u>QueryExecutorImpl.<u></u>processResults(<u></u>QueryExecutorImpl.java:1795)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.core.v3.<u></u>QueryExecutorImpl.execute(<u></u>QueryExecutorImpl.java:257)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.jdbc2.<u></u>AbstractJdbc2Statement.<u></u>execute(<u></u>AbstractJdbc2Statement.java:<u></u>479)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.jdbc2.<u></u>AbstractJdbc2Statement.<u></u>executeWithFlags(<u></u>AbstractJdbc2Statement.java:<u></u>367)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.jdbc2.<u></u>AbstractJdbc2Statement.<u></u>executeUpdate(<u></u>AbstractJdbc2Statement.java:<u></u>321)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>statisticssync_3_5.<u></u>StatisticsSync.tJDBCInput_<u></u>12Process(StatisticsSync.java:<u></u>12689)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>statisticssync_3_5.<u></u>StatisticsSync$7.run(<u></u>StatisticsSync.java:17483)<br>
> >> > > > Exception in component tJDBCOutput_7<br>
> >> > > > org.postgresql.util.<u></u>PSQLException: ERROR:<br>
current<br>
transaction is<br>
> >> aborted,<br>
> >> > > > commands ignored until end of transaction block<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.core.v3.<u></u>QueryExecutorImpl.<u></u>receiveErrorResponse(<u></u>QueryExecutorImpl.java:2062)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.core.v3.<u></u>QueryExecutorImpl.<u></u>processResults(<u></u>QueryExecutorImpl.java:1795)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.core.v3.<u></u>QueryExecutorImpl.execute(<u></u>QueryExecutorImpl.java:257)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.jdbc2.<u></u>AbstractJdbc2Statement.<u></u>execute(<u></u>AbstractJdbc2Statement.java:<u></u>479)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.jdbc2.<u></u>AbstractJdbc2Statement.<u></u>executeWithFlags(<u></u>AbstractJdbc2Statement.java:<u></u>367)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.jdbc2.<u></u>AbstractJdbc2Statement.<u></u>executeUpdate(<u></u>AbstractJdbc2Statement.java:<u></u>321)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>statisticssync_3_5.<u></u>StatisticsSync.tJDBCInput_<u></u>18Process(StatisticsSync.java:<u></u>14806)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>statisticssync_3_5.<u></u>StatisticsSync$8.run(<u></u>StatisticsSync.java:17529)<br>
> >> > > > Exception in component tJDBCOutput_4<br>
> >> > > > org.postgresql.util.<u></u>PSQLException: ERROR:<br>
current<br>
transaction is<br>
> >> aborted,<br>
> >> > > > commands ignored until end of transaction block<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.core.v3.<u></u>QueryExecutorImpl.<u></u>receiveErrorResponse(<u></u>QueryExecutorImpl.java:2062)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.core.v3.<u></u>QueryExecutorImpl.<u></u>processResults(<u></u>QueryExecutorImpl.java:1795)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.core.v3.<u></u>QueryExecutorImpl.execute(<u></u>QueryExecutorImpl.java:257)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.jdbc2.<u></u>AbstractJdbc2Statement.<u></u>execute(<u></u>AbstractJdbc2Statement.java:<u></u>479)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.jdbc2.<u></u>AbstractJdbc2Statement.<u></u>executeWithFlags(<u></u>AbstractJdbc2Statement.java:<u></u>367)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
org.postgresql.jdbc2.<u></u>AbstractJdbc2Statement.<u></u>executeUpdate(<u></u>AbstractJdbc2Statement.java:<u></u>321)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>statisticssync_3_5.<u></u>StatisticsSync.tJDBCInput_<u></u>8Process(StatisticsSync.java:<u></u>7788)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>statisticssync_3_5.<u></u>StatisticsSync$5.run(<u></u>StatisticsSync.java:17391)<br>
> >> > > > 2015-01-29<br>
> >> > > ><br>
> >><br>
16:07:04|kGEf8p|YhA1NE|VVdF7H|<u></u>OVIRT_ENGINE_DWH|<u></u>StatisticsSync|Default|6|Java<br>
> >> > > ><br>
Exception|tJDBCOutput_7|org.<u></u>postgresql.util.PSQLException:<u></u>ERROR:<br>
> >> current<br>
> >> > > > transaction is aborted, commands ignored<br>
until end of<br>
transaction<br>
> >> block|1<br>
> >> > > > 2015-01-29<br>
> >> > > ><br>
> >><br>
16:07:04|kGEf8p|YhA1NE|VVdF7H|<u></u>OVIRT_ENGINE_DWH|<u></u>StatisticsSync|Default|6|Java<br>
> >> > > ><br>
Exception|tJDBCOutput_5|org.<u></u>postgresql.util.PSQLException:<u></u>ERROR:<br>
> >> insert<br>
> >> > > > or<br>
> >> > > > update on table "vm_samples_history"<br>
violates foreign<br>
key constraint<br>
> >> > > > "vm_samples_history_current_<u></u>user_id_fkey"<br>
> >> > > > Detail: Key<br>
> >><br>
(current_user_id)=(ab932902-<u></u>cead-4435-a2b6-8b88576feab6) is<br>
> >> > > > not<br>
> >> > > > present in table "users_details_history".|1<br>
> >> > > > 2015-01-29<br>
> >> > > ><br>
> >><br>
16:07:04|kGEf8p|YhA1NE|VVdF7H|<u></u>OVIRT_ENGINE_DWH|<u></u>StatisticsSync|Default|6|Java<br>
> >> > > ><br>
Exception|tJDBCOutput_6|org.<u></u>postgresql.util.PSQLException:<u></u>ERROR:<br>
> >> current<br>
> >> > > > transaction is aborted, commands ignored<br>
until end of<br>
transaction<br>
> >> block|1<br>
> >> > > > 2015-01-29<br>
> >> > > ><br>
> >><br>
16:07:04|kGEf8p|YhA1NE|VVdF7H|<u></u>OVIRT_ENGINE_DWH|<u></u>StatisticsSync|Default|6|Java<br>
> >> > > ><br>
Exception|tJDBCOutput_4|org.<u></u>postgresql.util.PSQLException:<u></u>ERROR:<br>
> >> current<br>
> >> > > > transaction is aborted, commands ignored<br>
until end of<br>
transaction<br>
> >> block|1<br>
> >> > > > Exception in component tRunJob_5<br>
> >> > > > java.lang.RuntimeException: Child job<br>
running failed<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>samplerunjobs_3_5.<u></u>SampleRunJobs.tRunJob_<u></u>5Process(SampleRunJobs.java:<u></u>1598)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>samplerunjobs_3_5.<u></u>SampleRunJobs.tRunJob_<u></u>6Process(SampleRunJobs.java:<u></u>1412)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>samplerunjobs_3_5.<u></u>SampleRunJobs.tRunJob_<u></u>1Process(SampleRunJobs.java:<u></u>1197)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>samplerunjobs_3_5.<u></u>SampleRunJobs.tRunJob_<u></u>4Process(SampleRunJobs.java:<u></u>982)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>samplerunjobs_3_5.<u></u>SampleRunJobs.tJDBCConnection_<u></u>2Process(SampleRunJobs.java:<u></u>762)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>samplerunjobs_3_5.<u></u>SampleRunJobs.tJDBCConnection_<u></u>1Process(SampleRunJobs.java:<u></u>641)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>samplerunjobs_3_5.<u></u>SampleRunJobs$2.run(<u></u>SampleRunJobs.java:2560)<br>
> >> > > > 2015-01-29<br>
> >> > > ><br>
> >><br>
16:07:04|VVdF7H|YhA1NE|XpLXfK|<u></u>OVIRT_ENGINE_DWH|<u></u>SampleRunJobs|Default|6|Java<br>
> >> > > ><br>
Exception|tRunJob_5|java.lang.<u></u>RuntimeException:Child<br>
job running<br>
> >> failed|1<br>
> >> > > > Exception in component tRunJob_1<br>
> >> > > > java.lang.RuntimeException: Child job<br>
running failed<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>sampletimekeepingjob_3_5.<u></u>SampleTimeKeepingJob.tRunJob_<u></u>1Process(SampleTimeKeepingJob.<u></u>java:5941)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>sampletimekeepingjob_3_5.<u></u>SampleTimeKeepingJob.<u></u>tJDBCInput_2Process(<u></u>SampleTimeKeepingJob.java:<u></u>5707)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>sampletimekeepingjob_3_5.<u></u>SampleTimeKeepingJob.<u></u>tJDBCConnection_1Process(<u></u>SampleTimeKeepingJob.java:<u></u>4340)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>sampletimekeepingjob_3_5.<u></u>SampleTimeKeepingJob.<u></u>tJDBCConnection_2Process(<u></u>SampleTimeKeepingJob.java:<u></u>4219)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>sampletimekeepingjob_3_5.<u></u>SampleTimeKeepingJob.<u></u>tRowGenerator_2Process(<u></u>SampleTimeKeepingJob.java:<u></u>4092)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>sampletimekeepingjob_3_5.<u></u>SampleTimeKeepingJob.<u></u>tJDBCInput_3Process(<u></u>SampleTimeKeepingJob.java:<u></u>3505)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>sampletimekeepingjob_3_5.<u></u>SampleTimeKeepingJob.<u></u>tJDBCInput_5Process(<u></u>SampleTimeKeepingJob.java:<u></u>2877)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>sampletimekeepingjob_3_5.<u></u>SampleTimeKeepingJob.<u></u>tJDBCInput_4Process(<u></u>SampleTimeKeepingJob.java:<u></u>2191)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>sampletimekeepingjob_3_5.<u></u>SampleTimeKeepingJob.<u></u>tJDBCConnection_3Process(<u></u>SampleTimeKeepingJob.java:<u></u>1537)<br>
> >> > > > at<br>
> >> > > ><br>
> >><br>
ovirt_engine_dwh.<u></u>sampletimekeepingjob_3_5.<u></u>SampleTimeKeepingJob$2.run(<u></u>SampleTimeKeepingJob.java:<u></u>9546)<br>
> >> > > ><br>
> >> > > ><br>
> >> > > > ______________________________<u></u>_________________<br>
> >> > > > Users mailing list<br>
> >> > > > <a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a> <mailto:<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a>><br></div></div>
<mailto:<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a> <mailto:<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a>>><span class=""><br>
> >> > > > <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/<u></u>mailman/listinfo/users</a><br>
> >> > > ><br>
> >> > > ______________________________<u></u>_________________<br>
> >> > > Users mailing list<br>
> >> > > <a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a> <mailto:<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a>><br></span>
<mailto:<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a> <mailto:<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a>>><span class=""><br>
> >> > > <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/<u></u>mailman/listinfo/users</a><br>
> >> > ><br>
> >> > ______________________________<u></u>_________________<br>
> >> > Users mailing list<br>
> >> > <a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a> <mailto:<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a>><br></span>
<mailto:<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a> <mailto:<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a>>><span class=""><br>
> >> > <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/<u></u>mailman/listinfo/users</a><br>
> >> ><br>
> >><br>
> ><br>
> ><br>
><br>
<br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a> <mailto:<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a>><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/<u></u>mailman/listinfo/users</a><br>
<br>
<br>
<br></span><span class="">
-- Yaniv Dary<br>
Red Hat Israel Ltd.<br>
34 Jerusalem Road<br>
Building A, 4th floor<br>
Ra'anana, Israel 4350109<br>
<br></span>
Tel : <a href="tel:%2B972%20%289%29%207692306" value="+97297692306" target="_blank">+972 (9) 7692306</a> <tel:%2B972%20%289%29%<u></u>207692306><br>
8272306<br>
Email: <a href="mailto:ydary@redhat.com" target="_blank">ydary@redhat.com</a> <mailto:<a href="mailto:ydary@redhat.com" target="_blank">ydary@redhat.com</a>><br>
IRC : ydary<br>
<br>
<br>
</blockquote><div class="HOEnZb"><div class="h5">
<br>
-- <br>
Yaniv Dary<br>
Red Hat Israel Ltd.<br>
34 Jerusalem Road<br>
Building A, 4th floor<br>
Ra'anana, Israel 4350109<br>
<br>
Tel : <a href="tel:%2B972%20%289%29%207692306" value="+97297692306" target="_blank">+972 (9) 7692306</a><br>
8272306<br>
Email: <a href="mailto:ydary@redhat.com" target="_blank">ydary@redhat.com</a><br>
IRC : ydary<br>
<br>
</div></div></blockquote></div><br></div>