Bug 783197

Summary: [rhevm-reports] - When moving the database from one time zone to another many reports stop working.
Product: Red Hat Enterprise Virtualization Manager Reporter: Yaniv Lavi <ylavi>
Component: ovirt-engine-dwhAssignee: Yaniv Lavi <ylavi>
Status: CLOSED CURRENTRELEASE QA Contact: David Botzer <dbotzer>
Severity: high Docs Contact:
Priority: high    
Version: 3.0.1CC: acathrow, dyasny, ecohen, iheim, pstehlik, Rhev-m-bugs, yeylon, ykaul
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard: infra
Fixed In Version: SI7 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-12-04 19:58:43 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
exception
none
empty IC none

Description Yaniv Lavi 2012-01-19 16:27:50 UTC 
Description of problem:
The history database daily tables store their date in column defined as timestamps with timezone. This causes the date and time to shift when changing time zones as well and the time is no longer 00:00 which the reports depends on to work.

Version-Release number of selected component (if applicable):
3.0.2-2

How reproducible:
always

Steps to Reproduce:
1. start collecting a specific time zone for a few days.
2. change time zone of the server.
3. try to run reports based of daily tables.
  
Actual results:
many reports return empty result.

Expected results:
should not affect the results
Comment 1 Yaniv Lavi 2012-01-25 17:15:49 UTC 
This is fixed by upstream patch in the link:
http://gerrit.ovirt.org/1255


Yaniv
Comment 3 David Botzer 2012-08-12 13:08:55 UTC 
3.1/si13.2
When changing postgres Time Zone, DWH stop collecting data in history DB,

Please advise,
Comment 4 David Botzer 2012-08-13 06:42:04 UTC 
NOT Fixed 3.1/si13.2
Changed both OS Time Zone & Postgres,
Data is reflected correctly in history DB (via client)

-- some reports are opened with empty IC - br18, br21, br10A
-- a Reports crash (Exception)
NOT Fixed 3.1/si13.2

(See attached)
================
How I converted Time Zone
+++++++++++++++++++++++++++
RHEL6.3
ln -sf /usr/share/zoneinfo/America/Los_Angeles /etc/localtime 
/etc/sysconfig/clock file (e.g. "America/Los_Angeles")
/sbin/hwclock --systohc

Postgres
SET TIME ZONE 'America/Los_Angeles';

REBOOT
-----
v3_1_host_samples_history_view
"2012-08-12 22:59:43.776-07"
"2012-08-12 22:57:16.452-07"
"2012-08-12 22:56:17.339-07"

Return to Israel
-------------------
"2012-08-13 09:05:59.334+03"
"2012-08-13 09:04:46.312+03"
"2012-08-13 09:02:58.348+03"
Comment 5 David Botzer 2012-08-13 06:42:46 UTC 
Created attachment 603859 [details]
exception
Comment 6 David Botzer 2012-08-13 06:43:27 UTC 
Created attachment 603860 [details]
empty IC
Comment 7 David Botzer 2012-08-13 07:08:49 UTC 
Crash summary:

Error Message

java.lang.ClassCastException: org.ovirt.authentication.EngineUserDetails cannot be cast to com.jaspersoft.jasperserver.api.metadata.user.domain.User
Comment 8 Yaniv Lavi 2012-08-14 10:37:18 UTC 
This exception seems unrelated to the case.
1. verify this bug
2. open new bug with this issue and provide steps to reproduce this.



Yaniv
Comment 9 David Botzer 2012-08-14 10:43:07 UTC 
Regarding the empty IC window I have a bug - 
https://bugzilla.redhat.com/show_bug.cgi?id=847606

were u referring to this issue ?
Comment 10 Yaniv Lavi 2012-08-14 10:45:17 UTC 
"Error Message:

java.lang.ClassCastException: org.ovirt.authentication.EngineUserDetails cannot be cast to com.jaspersoft.jasperserver.api.metadata.user.domain.User"



Yaniv
Comment 11 David Botzer 2012-08-14 10:46:44 UTC 
ok
Comment 12 David Botzer 2012-08-14 11:51:21 UTC 
Fixed 3.1/si13.2
For the other issues I will open separate bugs
Fixed 3.1/si13.2