0019671: Create new check with verifies that postgres timezone == system (tomcat-server) timezone

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0019671

Openbravo ERP

A. Platform

public

2012-02-06 19:31

2016-03-24 07:59

Reporter

shuehner

Assigned To

alostale

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

Target Version

Fixed in Version

3.0PR15Q3

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0019671: Create new check with verifies that postgres timezone == system (tomcat-server) timezone

Description

In case that the time (hour) reported by the dbms and the time reported by java code running inside tomcat are not in sync the application will fail in various ways.

Example: update.database triggers local changes check directly after install.source (as last_db_update timstamp is not in sync with the various created/updates timestamp of the data).

As that is difficult/time-consuming to debug the application should have a check of the environment and warn the admin/developer of that.

Example locations:
- on install.source, on update.database, each tomcat startup

Steps To Reproduce

Linux system with timezone not being UTC (i.e. gmt+1)
Reconfigure postgres to use UTC timezone (TimeZone='utc' in main config file)
do install.source
install some module (i.e. spanish comminuty localization pack)
rebuild
Notice: that update.database step will fails with 'database has local changes' message.

Proposed Solution

Additional Information