oozie git commit: OOZIE-2155 Incorrect DST Shifts are occurring based on the Database timezone (rkanter)

[rk...@apache.org]

Repository: oozie
Updated Branches:
  refs/heads/master cb6fb2fbf -> 781716e8d


OOZIE-2155 Incorrect DST Shifts are occurring based on the Database timezone (rkanter)


Project: http://git-wip-us.apache.org/repos/asf/oozie/repo
Commit: http://git-wip-us.apache.org/repos/asf/oozie/commit/781716e8
Tree: http://git-wip-us.apache.org/repos/asf/oozie/tree/781716e8
Diff: http://git-wip-us.apache.org/repos/asf/oozie/diff/781716e8

Branch: refs/heads/master
Commit: 781716e8d72e95a961abcbaca4b2a84e423e936b
Parents: cb6fb2f
Author: Robert Kanter <rk...@cloudera.com>
Authored: Fri Mar 6 14:46:38 2015 -0800
Committer: Robert Kanter <rk...@cloudera.com>
Committed: Fri Mar 6 14:46:38 2015 -0800

----------------------------------------------------------------------
 docs/src/site/twiki/AG_Install.twiki | 8 ++++++++
 release-log.txt                      | 1 +
 2 files changed, 9 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/oozie/blob/781716e8/docs/src/site/twiki/AG_Install.twiki
----------------------------------------------------------------------
diff --git a/docs/src/site/twiki/AG_Install.twiki b/docs/src/site/twiki/AG_Install.twiki
index 2e478ec..f911412 100644
--- a/docs/src/site/twiki/AG_Install.twiki
+++ b/docs/src/site/twiki/AG_Install.twiki
@@ -138,6 +138,14 @@ line tool.
 If using MySQL, Oracle, or SQL Server, the corresponding JDBC driver JAR file mut be copied to Oozie's =libext/= directory and
 it must be added to Oozie WAR file using the =bin/addtowar.sh= or the =oozie-setup.sh= scripts using the =-jars= option.
 
+*IMPORTANT:* It is recommended to set the database's timezone to GMT (consult your database's documentation on how to do this).
+Databases don't handle Daylight Saving Time shifts correctly, and may cause problems if you run any Coordinators with actions
+scheduled to materialize during the 1 hour period where we "fall back".  For Derby, you can add '-Duser.timezone=GMT'
+to =CATALINA_OPTS= in oozie-env.sh to set this.  Alternatively, if using MySQL, you can have Oozie use GMT with MySQL without
+setting MySQL's timezone to GMT by adding 'useLegacyDatetimeCode=false&serverTimezone=GMT' arguments to the JDBC
+URL, =oozie.service.JPAService.jdbc.url=.  Be advised that changing the timezone on an existing Oozie database while Coordinators
+are already running may cause Coordinators to shift by the offset of their timezone from GMT once after making this change.
+
 The SQL database used by Oozie is configured using the following configuration properties (default values shown):
 
 <verbatim>

http://git-wip-us.apache.org/repos/asf/oozie/blob/781716e8/release-log.txt
----------------------------------------------------------------------
diff --git a/release-log.txt b/release-log.txt
index 4b51bbd..ad383fd 100644
--- a/release-log.txt
+++ b/release-log.txt
@@ -1,5 +1,6 @@
 -- Oozie 4.2.0 release (trunk - unreleased)
 
+OOZIE-2155 Incorrect DST Shifts are occurring based on the Database timezone (rkanter)
 OOZIE-2156 override hive.querylog.location in hive-site.xml (ryota)
 OOZIE-2153 modify HCatCredentialHelper to use HCatClient (ryota)
 OOZIE-2132 FS actions are not retried (ryota)