>>>>> On Thu, 05 Nov 2009 12:25:45 +0100, Marek Simon said:
> 
> Hi,
> I am currently solving some performance issues with my instance of 
> bacula, so I need to see some statistics of recent jobs. But now I saw 
> some jobs with negative duration (WTF!?) I zoom at them and I see all of 
> them starts or end at 2009-10-25 between 2-3 am. Daylight saving time 
> change. The postgres does the substraction OK, if the time zone is ok in 
> the data, but I see the data type of the job.starttime and job.endtime 
> is timestamp without time zone and probably of all timestamp data in 
> bacula are without time zone as well!
> It seems ok because servers usualy do not move between time zones, but 
> in Europe does time zones move over the server twice a year (the 
> daylight saving time change). And there could arise a big problem not 
> only with job statistics but with retention times and of course with 
> planning a schedule between 2-3 am.
> 
> I consider that as bug and I am going to report it.
> My version is 2.4.4 and I searched the documentation of version 3 and 
> there is nothing abot time zone.
> 
> Does anybody have got this problem too?

It is very difficult to solve all of the problems, unless all schedules are
written in UCT (which would be inconvenient).

My advice is to never schedule a job to start between 2-3 am (or whenever dst
changes in your country).

__Martin

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users