8:26 a.m.
Please see answers below and let me know if you have any other questions.
Best,
--
SHIRLY RADCO
BI SENIOR SOFTWARE ENGINEER
Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
On Sun, Oct 28, 2018 at 12:55 PM fsoyer <fsoyer(a)systea.fr> wrote:
Well, I see that I'm late to give the information :) Thank you to
pointing
me to this, but I have now some other questions now...
How can I see the timezone of the DB ?
"If no time zone is stated in the input string, then it is assumed to be in
the time zone indicated by the system's TimeZone parameter, and is
converted to UTC using the offset for the timezone zone."
https://serverfault.com/questions/554359/postgresql-timezone-does-not-mat...
When it says "all machines", do you confirm that this is
physical
machines, not VMs ?
I mean the machine DWH is installed on. It can be a VM.
But I'm not saying we recommend all VMs to be set to UTC.
May I apply the solution given on access.redhat or not, as there is
no
more messages since 3AM ?
No need.
And, last question but not least, can this timezone be changed on the
machines (and DB ?) without issue ?
It is possible to update it, but its not mandatory.
The 1 hour gap / overlap is expected when moving from summer to winter and
back when not using UTC and I'm not sure if its even worth updating at this
point,
at the risk of ending up with a real bug..
--
Regards,
*Frank*
Le Dimanche, Octobre 28, 2018 11:40 CET, Shirly Radco <sradco(a)redhat.com>
a écrit:
Hi,
Please see here
https://www.ovirt.org/documentation/data-warehouse/Data_Collection_Setup_...
"It is recommended that you set the system time zone for all machines in
your Data Warehouse deployment to UTC. This ensures that data collection is
not interrupted by variations in your local time zone: for example, a
change from summer time to winter time."
What timezone is your DB configured to?
Best,
--
SHIRLY RADCO
BI SENIOR SOFTWARE ENGINEER
Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
On Sun, Oct 28, 2018 at 12:32 PM fsoyer <fsoyer(a)systea.fr> wrote:
> Hi all,
> Maybe it has already been posted, but I think I've discoverd a little
> bug. This night I had this messages :
>
> 28 oct. 2018 03:00:00
> ETL service aggregation to hourly tables has encountered an error. Please
> consult the service log for more details.
> 28 oct. 2018 02:40:27
> ETL service sampling has encountered an error. Please consult the service
> log for more details.
> 28 oct. 2018 02:33:42
> ETL service sampling has encountered an error. Please consult the service
> log for more details.
> 28 oct. 2018 02:27:42
> ETL service sampling has encountered an error. Please consult the service
> log for more details.
> 28 oct. 2018 02:22:27
> ETL service sampling has encountered an error. Please consult the service
> log for more details.
> 28 oct. 2018 02:16:37
> ETL service sampling has encountered an error. Please consult the service
> log for more details.
> 28 oct. 2018 02:11:06
> ETL service sampling has encountered an error. Please consult the service
> log for more details.
> 28 oct. 2018 02:05:06
> ETL service sampling has encountered an error. Please consult the service
> log for more details.
> 28 oct. 2018 02:00:06
> ETL service sampling has encountered an error. Please consult the service
> log for more details
> 28 oct. 2018 02:00:00
> ETL service aggregation to hourly tables has encountered an error. Please
> consult the service log for more details.
>
> and, coincidence, here in France we have change to winter hour at... 2AM
> :) So regarding this post:
> https://access.redhat.com/solutions/3338001
> speaking about a time problem, I've supposed that this is related ! No ?
> access.redhat says that the cause was not yet determined, but maybe it can
> be interesting to propose this cause ? But the bug is actually closed.
>
> Question : does this repair all alone (as there is no more messages after
> 3AM) or may I applied the solution with postgres updates (I must say that
> I'm not very enthousiast for that...) ?
>
> Regards,
>
> --
>
> *Frank*
> _______________________________________________
> Users mailing list -- users(a)ovirt.org
> To unsubscribe send an email to users-leave(a)ovirt.org
> Privacy Statement: https://www.ovirt.org/site/privacy-policy/
> oVirt Code of Conduct:
> https://www.ovirt.org/community/about/community-guidelines/
> List Archives:
>
https://lists.ovirt.org/archives/list/users@ovirt.org/message/GNGAQKTA5PD...