4:22 a.m.
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,
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 !
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
6:31 p.m.
------=_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(a)gmail.com>
To: Devel(a)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(a)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
<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(a)gmail.com&gt;<br><b>To:
</b>Devel(a)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;"=
<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=
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;"=
<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=
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--
3694
days inactive
3695
days old
1 comments
2 participants
participants (2)
-
Yaniv Dary -
张亚琪