DWH cannot gain hourly history data from db because of the bloody time problem.
hi everybody, Recently, I have tested oVirt Reports. And I encountered a problem about some reports that cannot show data. And then I setup the DWH development environment. I found maybe this reason for missing data is the AggregationToHourly3.5. When data from datacenter_samples_history were inserted to datacenter_hourly_history, u will find nothing happened. Because the select sql before inserting data reads： "SELECT history_id,
history_datetime,
datacenter_id,
datacenter_status,
minutes_in_status,
datacenter_configuration_version
FROM datacenter_samples_history
WHERE *history_datetime >= '"+context.lastHourAggr+*"'
AND history_datetime < '"+TalendDate.addDate(context.lastHourAggr,
1,"HH")+"'
ORDER BY history_datetime,
datacenter_id,
datacenter_status"
And then I queried the table of datacenter_samples_history & history_configuration (has the field of lastHourAggr) in the db of ovirt_engine_history. The results are as follows: ovirt_engine_history=# select * from history_configuration;
var_name | var_value | var_datetime
-------------------+-----------+------------------------
MinimalETLVersion | 3.5.0 |
default_language | en_US |
firstSync | false | 2014-10-13 19:42:00+08
lastDayAggr | | 2014-11-14 00:00:00+08
* lastHourAggr | | *2014-*11-15* 06:00:00+08
HourlyAggFailed | false |
(6 rows)
ovirt_engine_history=# select *history_datetime* from
datacenter_samples_history;
history_datetime ---------------------------- 2014-*11-13* 03:07:00.23+08 2014-11-13 03:08:00.238+08 2014-11-13 03:09:00.229+08 2014-11-13 03:10:00.221+08 2014-11-13 03:11:00.229+08 2014-11-13 03:12:00.221+08 2014-11-13 03:13:00.237+08 2014-11-13 03:14:00.22+08 2014-11-13 03:15:00.221+08 2014-11-13 03:16:00.238+08 2014-11-13 03:17:00.238+08
Obviously， history_datetime < lastHourAggr , the data will never be inserted to the datacenter_hourly_history. And the place where I bold is the root cause of the error. Then , I try to update the *lastHourAggr *in the table of history_configuration. Reports works successfully. However, the lastHourAggr will change to 2014-11-15 afterwards. But u know Today is 2014-11-14 ! I have no idea about why the value of lastHourAggr is 2014-11-15. Would u help me solve this problem. Thanks a lot !
------=_Part_12172801_1403039003.1416094306838 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Are all your servers sync to the same ntp and in UTM time?=20 Can you attach logs?=20 Yaniv=20 ----- Original Message -----
From: "=E5=BC=A0=E4=BA=9A=E7=90=AA" <zhangyingyun001@gmail.com> To: Devel@ovirt.org Sent: Friday, November 14, 2014 11:22:38 AM Subject: [ovirt-devel] DWH cannot gain hourly history data from db becaus= e of the bloody time problem.
hi everybody, Recently, I have tested oVirt Reports. And I encountered a problem about = some reports that cannot show data. And then I setup the DWH development environment. I found maybe this reason for missing data is the AggregationToHourly3.5. When data from datacenter_samples_history were inserted to datacenter_hourly_history, u will find nothing happened. Beca= use the select sql before inserting data reads=EF=BC=9A
"SELECT history_id, =20 =20 history_datetime, =20 =20 datacenter_id, =20 =20 datacenter_status, =20 =20 minutes_in_status, =20 =20 datacenter_configuration_version =20 =20 FROM datacenter_samples_history =20 =20 WHERE history_datetime >=3D '"+context.lastHourAggr+ "' =20 =20 AND history_datetime < '"+TalendDate.addDate(context.lastHourAggr, 1,"HH")+"' =20 =20 ORDER BY history_datetime, =20 =20 datacenter_id, =20 =20 datacenter_status" =20 =20 And then I queried the table of datacenter_samples_history & history_configuration (has the field of lastHourAggr) in the db of ovirt_engine_history. The results are as follows:
ovirt_engine_history=3D# select * from history_configuration; =20 =20 var_name | var_value | var_datetime =20 =20 -------------------+-----------+------------------------ =20 =20 MinimalETLVersion | 3.5.0 | =20 =20 default_language | en_US | =20 =20 firstSync | false | 2014-10-13 19:42:00+08 =20 =20 lastDayAggr | | 2014-11-14 00:00:00+08 =20 =20 lastHourAggr | | 2014- 11-15 06:00:00+08 =20 =20 HourlyAggFailed | false | =20 =20 (6 rows) =20 =20 ovirt_engine_history=3D# select history_datetime from datacenter_samples_history; =20 history_datetime =20
=20 2014- 11-13 03:07:00.23+08 =20 2014-11-13 03:08:00.238+08 =20 2014-11-13 03:09:00.229+08 =20 2014-11-13 03:10:00.221+08 =20 2014-11-13 03:11:00.229+08 =20 2014-11-13 03:12:00.221+08 =20 2014-11-13 03:13:00.237+08 =20 2014-11-13 03:14:00.22+08 =20 2014-11-13 03:15:00.221+08 =20 2014-11-13 03:16:00.238+08 =20 2014-11-13 03:17:00.238+08 =20 Obviously=EF=BC=8C history_datetime < lastHourAggr , the data will never = be inserted to the datacenter_hourly_history. And the place where I bold is the root cause of the error. Then , I try to update the lastHourAggr in the table = of history_configuration. Reports works successfully. However, the lastHourA= ggr will change to 2014-11-15 afterwards. But u know Today is 2014-11-14 ! I have no idea about why the value of lastHourAggr is 2014-11-15. Would u h= elp me solve this problem. Thanks a lot !
_______________________________________________ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel ------=_Part_12172801_1403039003.1416094306838 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
<br></span></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px= 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-= left-style:solid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.= 8ex; border-left-width: 1px; border-left-color: #cccccc; border-left-style:= solid; padding-left: 1ex;"><blockquote class=3D"gmail_quote" style=3D"marg= in:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,20= 4);border-left-style:solid;padding-left:1ex" data-mce-style=3D"margin: 0px = 0px 0px 0.8ex; border-left-width: 1px; border-left-color: #cccccc; border-l= eft-style: solid; padding-left: 1ex;"><span face=3D"comic sans ms, sans-ser= if" data-mce-style=3D"font-family: 'comic sans ms', sans-serif;" style=3D"f= ont-family: 'comic sans ms', sans-serif;">"SELECT history_id,</span></block= quote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b= order-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:s=
<span style=3D"white-space:normal" data-mce-style=3D"white-space: normal;"= </span></span>minutes_in_status,</span></blockquote><blockquote class=3D"= gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border= -left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex" data= -mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-lef= t-color: #cccccc; border-left-style: solid; padding-left: 1ex;"><span face= =3D"comic sans ms, sans-serif" data-mce-style=3D"font-family: 'comic sans m= s', sans-serif;" style=3D"font-family: 'comic sans ms', sans-serif;"><span = class=3D"" style=3D"white-space:pre" data-mce-style=3D"white-space: pre;"><= span style=3D"white-space:normal" data-mce-style=3D"white-space: normal;"> = </span></span>datacenter_configuration_version</span></blockquote><blockquo= te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-widt= h:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-le= ft:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px= ; border-left-color: #cccccc; border-left-style: solid; padding-left: 1ex;"= <span face=3D"comic sans ms, sans-serif" data-mce-style=3D"font-family: 'c= omic sans ms', sans-serif;" style=3D"font-family: 'comic sans ms', sans-ser= if;">FROM datacenter_samples_history</span></blockquote><blockquote class= =3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;bo= rder-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex" = data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border= -left-color: #cccccc; border-left-style: solid; padding-left: 1ex;"><span f= ace=3D"comic sans ms, sans-serif" data-mce-style=3D"font-family: 'comic san= s ms', sans-serif;" style=3D"font-family: 'comic sans ms', sans-serif;">WHE= RE <b>history_datetime >=3D '"+context.lastHourAggr+</b>"'</span></block= quote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b= order-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:s=
<html><body><div style=3D"font-family: Arial; font-size: 10pt; color: #0000= 00"><div>Are all your servers sync to the same ntp and in UTM time?</div><d= iv>Can you attach logs? </div><div><br></div><div><br></div><div>Yaniv= </div><div><br></div><hr id=3D"zwchr"><blockquote style=3D"border-left:2px = solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:norma= l;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-s= erif;font-size:12pt;" data-mce-style=3D"border-left: 2px solid #1010FF; mar= gin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-st= yle: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif= ; font-size: 12pt;"><b>From: </b>"=E5=BC=A0=E4=BA=9A=E7=90=AA" <zhangyin= gyun001@gmail.com><br><b>To: </b>Devel@ovirt.org<br><b>Sent: </b>Friday,= November 14, 2014 11:22:38 AM<br><b>Subject: </b>[ovirt-devel] DWH cannot = gain hourly history data from db because of the bloody time problem.<br><di= v><br></div><div dir=3D"ltr"><div><span face=3D"comic sans ms, sans-serif" = data-mce-style=3D"font-family: 'comic sans ms', sans-serif;" style=3D"font-= family: 'comic sans ms', sans-serif;">hi everybody,</span></div><div><span = face=3D"comic sans ms, sans-serif" data-mce-style=3D"font-family: 'comic sa= ns ms', sans-serif;" style=3D"font-family: 'comic sans ms', sans-serif;">&n= bsp; </span></div><div><span face=3D"comic sans m= s, sans-serif" data-mce-style=3D"font-family: 'comic sans ms', sans-serif;"= style=3D"font-family: 'comic sans ms', sans-serif;"> &= nbsp; Recently, I have tested oVirt Reports. And I encountered a problem ab= out some reports that cannot show data. And then I setup the DWH developmen= t environment. I found maybe this reason for missing data is the Aggregatio= nToHourly3.5. When data from datacenter_samples_history were inse= rted to datacenter_hourly_history, u will find nothing happened. Becau= se the select sql before inserting data reads=EF=BC=9A</span></div><div><sp= an face=3D"comic sans ms, sans-serif" data-mce-style=3D"font-family: 'comic= sans ms', sans-serif;" style=3D"font-family: 'comic sans ms', sans-serif;"= olid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-= left-width: 1px; border-left-color: #cccccc; border-left-style: solid; padd= ing-left: 1ex;"><span face=3D"comic sans ms, sans-serif" data-mce-style=3D"= font-family: 'comic sans ms', sans-serif;" style=3D"font-family: 'comic san= s ms', sans-serif;"><span class=3D"" style=3D"white-space:pre" data-mce-sty= le=3D"white-space: pre;"><span style=3D"white-space:normal" data-mce-style= =3D"white-space: normal;"> </span></span>history_datetime,</span></blockquo= te><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord= er-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:soli= d;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-lef= t-width: 1px; border-left-color: #cccccc; border-left-style: solid; padding= -left: 1ex;"><span face=3D"comic sans ms, sans-serif" data-mce-style=3D"fon= t-family: 'comic sans ms', sans-serif;" style=3D"font-family: 'comic sans m= s', sans-serif;"> <span class=3D"" style=3D"white-space= :pre" data-mce-style=3D"white-space: pre;"><span style=3D"white-space:norma= l" data-mce-style=3D"white-space: normal;"> </span></span>datacenter_id,</s= pan></blockquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px = 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-l= eft-style:solid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8= ex; border-left-width: 1px; border-left-color: #cccccc; border-left-style: = solid; padding-left: 1ex;"><span face=3D"comic sans ms, sans-serif" data-mc= e-style=3D"font-family: 'comic sans ms', sans-serif;" style=3D"font-family:= 'comic sans ms', sans-serif;"> <span class=3D"" style= =3D"white-space:pre" data-mce-style=3D"white-space: pre;"><span style=3D"wh= ite-space:normal" data-mce-style=3D"white-space: normal;"> </span></span>da= tacenter_status,</span></blockquote><blockquote class=3D"gmail_quote" style= =3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(20= 4,204,204);border-left-style:solid;padding-left:1ex" data-mce-style=3D"marg= in: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: #cccccc; = border-left-style: solid; padding-left: 1ex;"><span face=3D"comic sans ms, = sans-serif" data-mce-style=3D"font-family: 'comic sans ms', sans-serif;" st= yle=3D"font-family: 'comic sans ms', sans-serif;"> <spa= n class=3D"" style=3D"white-space:pre" data-mce-style=3D"white-space: pre;"= olid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-= left-width: 1px; border-left-color: #cccccc; border-left-style: solid; padd= ing-left: 1ex;"><span face=3D"comic sans ms, sans-serif" data-mce-style=3D"= font-family: 'comic sans ms', sans-serif;" style=3D"font-family: 'comic san= s ms', sans-serif;">AND history_datetime < '"+TalendDate.addDate(context= .lastHourAggr, 1,"HH")+"'</span></blockquote><blockquote class=3D"gmail_quo= te" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-col= or:rgb(204,204,204);border-left-style:solid;padding-left:1ex" data-mce-styl= e=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: = #cccccc; border-left-style: solid; padding-left: 1ex;"><span face=3D"comic = sans ms, sans-serif" data-mce-style=3D"font-family: 'comic sans ms', sans-s= erif;" style=3D"font-family: 'comic sans ms', sans-serif;">ORDER BY history= _datetime, </span></blockquote></blockquote><blockquote class=3D"gmail= _quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left= -color:rgb(204,204,204);border-left-style:solid;padding-left:1ex" data-mce-= style=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-col= or: #cccccc; border-left-style: solid; padding-left: 1ex;"><blockquote clas= s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;b= order-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"= data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; borde= r-left-color: #cccccc; border-left-style: solid; padding-left: 1ex;"><span = face=3D"comic sans ms, sans-serif" data-mce-style=3D"font-family: 'comic sa= ns ms', sans-serif;" style=3D"font-family: 'comic sans ms', sans-serif;">&n= bsp; datacent= er_id, </span></blockquote></blockquote><blockquote class=3D"gmail_quo= te" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-col= or:rgb(204,204,204);border-left-style:solid;padding-left:1ex" data-mce-styl= e=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: = #cccccc; border-left-style: solid; padding-left: 1ex;"><blockquote class=3D= "gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;borde= r-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex" dat= a-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-le= ft-color: #cccccc; border-left-style: solid; padding-left: 1ex;"><span face= =3D"comic sans ms, sans-serif" data-mce-style=3D"font-family: 'comic sans m= s', sans-serif;" style=3D"font-family: 'comic sans ms', sans-serif;"> = <span class=3D"" style=3D"white-space:pre" data-mce-style=3D= "white-space: pre;"><span style=3D"white-space:normal" data-mce-style=3D"wh= ite-space: normal;"> datacen= ter_status"</span></span></span></blockquote></blockquote><div><br></div><d= iv><br></div><div>And then I queried the table of datacenter_samples_histor= y & history_configuration (has the field of lastHourAggr) in the db of&= nbsp;ovirt_engine_history. The results are as follows:</div><div><br></div>= <blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-= left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;p= adding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-w= idth: 1px; border-left-color: #cccccc; border-left-style: solid; padding-le= ft: 1ex;"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8= ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-sty= le:solid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; bor= der-left-width: 1px; border-left-color: #cccccc; border-left-style: solid; = padding-left: 1ex;">ovirt_engine_history=3D# select * from history_configur= ation;</blockquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0p= x 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border= -left-style:solid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0= .8ex; border-left-width: 1px; border-left-color: #cccccc; border-left-style= : solid; padding-left: 1ex;"> var_name &nb= sp;| var_value | var_datetime </blo= ckquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex= ;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style= :solid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; borde= r-left-width: 1px; border-left-color: #cccccc; border-left-style: solid; pa= dding-left: 1ex;">-------------------+-----------+------------------------<= /blockquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0= .8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-s= tyle:solid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; b= order-left-width: 1px; border-left-color: #cccccc; border-left-style: solid= ; padding-left: 1ex;"> MinimalETLVersion | 3.5.0 | = </blockquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px = 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-= style:solid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; = border-left-width: 1px; border-left-color: #cccccc; border-left-style: soli= d; padding-left: 1ex;"> default_language | en_US |= </blockquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0p= x 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border= -left-style:solid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0= .8ex; border-left-width: 1px; border-left-color: #cccccc; border-left-style= : solid; padding-left: 1ex;"> firstSync | = false | 2014-10-13 19:42:00+08</blockquote><blockquote class= =3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;bo= rder-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex" = data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border= -left-color: #cccccc; border-left-style: solid; padding-left: 1ex;"> l= astDayAggr | | 2014= -11-14 00:00:00+08</blockquote><blockquote class=3D"gmail_quote" style=3D"m= argin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204= ,204);border-left-style:solid;padding-left:1ex" data-mce-style=3D"margin: 0= px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: #cccccc; borde= r-left-style: solid; padding-left: 1ex;"><b> lastHourAggr = ; | | </b>2014-<span color=3D"#ff0= 000" data-mce-style=3D"color: #ff0000;" style=3D"color: #ff0000;"><b>11-15<= /b></span> 06:00:00+08</blockquote><blockquote class=3D"gmail_quote" style= =3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(20= 4,204,204);border-left-style:solid;padding-left:1ex" data-mce-style=3D"marg= in: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: #cccccc; = border-left-style: solid; padding-left: 1ex;"> HourlyAggFailed = | false | </blockquote><blockquote class=3D"gmail_quote"= style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:= rgb(204,204,204);border-left-style:solid;padding-left:1ex" data-mce-style= =3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: #= cccccc; border-left-style: solid; padding-left: 1ex;">(6 rows)</blockquote>= <div><br></div></blockquote><div><br></div><blockquote class=3D"gmail_quote= " style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color= :rgb(204,204,204);border-left-style:solid;padding-left:1ex" data-mce-style= =3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: #= cccccc; border-left-style: solid; padding-left: 1ex;"> </blockquote><b= lockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-le= ft-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;pad= ding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-wid= th: 1px; border-left-color: #cccccc; border-left-style: solid; padding-left= : 1ex;">ovirt_engine_history=3D# select <b>history_datetime</b> from datace= nter_samples_history;</blockquote><blockquote class=3D"gmail_quote" style= =3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(20= 4,204,204);border-left-style:solid;padding-left:1ex" data-mce-style=3D"marg= in: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: #cccccc; = border-left-style: solid; padding-left: 1ex;"> history_= datetime </blockquote><blockquote class=3D"gmail_quote"= style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:= rgb(204,204,204);border-left-style:solid;padding-left:1ex" data-mce-style= =3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: #= cccccc; border-left-style: solid; padding-left: 1ex;">---------------------= -------</blockquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0= px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);borde= r-left-style:solid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px = 0.8ex; border-left-width: 1px; border-left-color: #cccccc; border-left-styl= e: solid; padding-left: 1ex;"> 2014-<b><span color=3D"#ff0000" data-mc= e-style=3D"color: #ff0000;" style=3D"color: #ff0000;">11-13</span></b> 03:0= 7:00.23+08</blockquote><blockquote class=3D"gmail_quote" style=3D"margin:0p= x 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);bo= rder-left-style:solid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0= px 0.8ex; border-left-width: 1px; border-left-color: #cccccc; border-left-s= tyle: solid; padding-left: 1ex;"> 2014-11-13 03:08:00.238+08</blockquo= te><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord= er-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:soli= d;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-lef= t-width: 1px; border-left-color: #cccccc; border-left-style: solid; padding= -left: 1ex;"> 2014-11-13 03:09:00.229+08</blockquote><blockquote class= =3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;bo= rder-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex" = data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border= -left-color: #cccccc; border-left-style: solid; padding-left: 1ex;"> 2= 014-11-13 03:10:00.221+08</blockquote><blockquote class=3D"gmail_quote" sty= le=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(= 204,204,204);border-left-style:solid;padding-left:1ex" data-mce-style=3D"ma= rgin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: #cccccc= ; border-left-style: solid; padding-left: 1ex;"> 2014-11-13 03:11:00.2= 29+08</blockquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px= 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-= left-style:solid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.= 8ex; border-left-width: 1px; border-left-color: #cccccc; border-left-style:= solid; padding-left: 1ex;"> 2014-11-13 03:12:00.221+08</blockquote><b= lockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-le= ft-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;pad= ding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-wid= th: 1px; border-left-color: #cccccc; border-left-style: solid; padding-left= : 1ex;"> 2014-11-13 03:13:00.237+08</blockquote><blockquote class=3D"g= mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-= left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex" data-= mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left= -color: #cccccc; border-left-style: solid; padding-left: 1ex;"> 2014-1= 1-13 03:14:00.22+08</blockquote><blockquote class=3D"gmail_quote" style=3D"= margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,20= 4,204);border-left-style:solid;padding-left:1ex" data-mce-style=3D"margin: = 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: #cccccc; bord= er-left-style: solid; padding-left: 1ex;"> 2014-11-13 03:15:00.221+08<= /blockquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0= .8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-s= tyle:solid;padding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; b= order-left-width: 1px; border-left-color: #cccccc; border-left-style: solid= ; padding-left: 1ex;"> 2014-11-13 03:16:00.238+08</blockquote><blockqu= ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-wid= th:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-l= eft:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1p= x; border-left-color: #cccccc; border-left-style: solid; padding-left: 1ex;= "> 2014-11-13 03:17:00.238+08</blockquote><blockquote class=3D"gmail_q= uote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-c= olor:rgb(204,204,204);border-left-style:solid;padding-left:1ex" data-mce-st= yle=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color= : #cccccc; border-left-style: solid; padding-left: 1ex;"><br></blockquote><= blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l= eft-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;pa= dding-left:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-wi= dth: 1px; border-left-color: #cccccc; border-left-style: solid; padding-lef= t: 1ex;"> </blockquote><div><span face=3D"comic sans ms, sans-serif" d= ata-mce-style=3D"font-family: 'comic sans ms', sans-serif;" style=3D"font-f= amily: 'comic sans ms', sans-serif;"><span color=3D"#000000" data-mce-style= =3D"color: #000000;" style=3D"color: #000000;"><span style=3D"line-height:2= 4px" data-mce-style=3D"line-height: 24px;"><br></span></span></span></div><= div><span face=3D"comic sans ms, sans-serif" data-mce-style=3D"font-family:= 'comic sans ms', sans-serif;" style=3D"font-family: 'comic sans ms', sans-= serif;"><span color=3D"#000000" data-mce-style=3D"color: #000000;" style=3D= "color: #000000;"><span style=3D"line-height:24px" data-mce-style=3D"line-h= eight: 24px;">Obviously=EF=BC=8C history_datetime < lastHourAggr , the d= ata will never be inserted to the </span>datacenter_hourly_history.&nb= sp;And the place where I bold <span style=3D"line-height:24px" data-mce-sty= le=3D"line-height: 24px;">is the </span><span style=3D"line-height:24p= x" data-mce-style=3D"line-height: 24px;">root cause of the error. Then , I = try to update the </span></span><b>lastHourAggr </b>in the table of hi= story_configuration. Reports works successfully. However, the lastHourAggr = will change to 2014-11-15 afterwards. But u know Today is 2014-11-14 ! I ha= ve no idea about why the value of lastHourAggr is 2014-11-15. Would u help = me solve this problem. Thanks a lot ! </span></div></div><br>_________= ______________________________________<br>Devel mailing list<br>Devel@ovirt= .org<br>http://lists.ovirt.org/mailman/listinfo/devel</blockquote><div><br>= </div></div></body></html> ------=_Part_12172801_1403039003.1416094306838--
participants (2)
-
Yaniv Dary -
张亚琪