[Koha-devel] Invalid local time for date in time zone: America/Santiago

Thu Apr 28 05:40:42 CEST 2016

David,

I will review the data on date_due field.

Thanks!! for your time ! LOL time.. ;-)

tomorrow

--Larry

2016-04-28 0:35 GMT-03:00 David Cook <dcook at prosentient.com.au>:

> Hi Larry,
>
>
>
> I find time fascinating, so happy to help : ).
>
>
>
> Thanks for that pastebin. That’s really helpful.
>
>
>
> We can see the problem is with the following call:
>
>
>
> $calendar->days_between(  dt_from_string($data->{date_due}),$date_to_run );
>
>
>
> If I follow correctly, $date_to_run should be the time when you run the
> script in America/Santiago time.
>
>
>
> $data->{date_due} will be from the database… probably the issues table I
> think… and I think that’s looking OK, since the following line appears in
> the debugger:
>
>
>
> Koha::Calendar::days_between('Koha::Calendar=HASH(0x65dcf80)',
> 'DateTime=HASH(0x6507b38)', 'DateTime=HASH(0x64e7848)')
>
>
>
> We’d have an error earlier if those dates were the ones causing problems…
> so I think they’re OK since they’ve been created into objects as evidenced
> above.
>
>
>
> However… 'DateTime=HASH(0x6507b38)'  is cloned in
> Koha::Calendar::days_between() and has Koha::Calendar::is_holiday() run on
> it…
>
>
>
> --
>
>
>
> I have an urgent matter now, but that’s part of the way there. I’m
> thinking the problem is with the “date_due” from one of the overdue items!
> Possibly something from September if the debug message is correct…
>
>
>
>
>
> David Cook
>
> Systems Librarian
>
>
>
> Prosentient Systems
>
> 72/330 Wattle St
>
> Ultimo, NSW 2007
>
>
>
> Office: 02 9212 0899
>
> Direct: 02 8005 0595
>
>
>
> *From:* Larry Letelier [mailto:larry at opengeek.cl]
> *Sent:* Thursday, 28 April 2016 1:05 PM
> *To:* David Cook <dcook at prosentient.com.au>
> *Cc:* koha-devel at lists.koha-community.org
> *Subject:* Re: [Koha-devel] Invalid local time for date in time zone:
> America/Santiago
>
>
>
> Hi David,
>
>
>
> Thanks for you reply,
>
>
>
> yes your are right, Chile abolished dst, we have a minister with many
> earthquakes in him head.
>
> So,
>
>
>
> Here is the “perl -d overdue_notices.pl -t"  using "n":
>
> http://pastebin.com/ZxHkNCK3
>
>
>
> If i run again :
>
>
>
> perl overdue_notices.pl -t
>
> Invalid local time for date in time zone: America/Santiago
>
>
>
> Thanks in advance guys,
>
>
>
>
> *-- Larry Letelier N.*
>
> *F: **+56 2 3205 2737*
>
> *F: *
> *+56 9 7589 6842*
>
>
>
> 2016-04-27 23:53 GMT-03:00 David Cook <dcook at prosentient.com.au>:
>
> Oh, that’s interesting.
>
>
>
> I’ve seen this happen on other Perl projects during daylight savings time
> changes.
>
>
>
> For instance, try the following Perl code:
>
>
>
> use DateTime;
>
> my $dt = DateTime->new(
>
>     year => 2015,
>
>     month => 10,
>
>     day => 4,
>
>     hour => 2,
>
>     minute => 0,
>
>     second => 0,
>
>     time_zone => 'Australia/Sydney',
>
> );
>
>
>
> You’ll get the message:
>
>
>
> “Invalid local time for date in time zone: Australia/Sydney”
>
>
>
> If I recall correctly, it’s because 4 October 2015 2:00am Australia/Sydney
> didn’t exist. When that time was reached, the clock actually skipped
> forward, and it became 4 October 2015 3:00am Australia/Sydney. In effect,
> local time went from 1:59:59 to 3:00:00. 2:00:00 through 2:59:59 never
> existed. Fascinating, no?
>
>
>
> Wikipedia says that Chile stopped observing DST in 2015:
> https://en.wikipedia.org/wiki/Daylight_saving_time_in_the_Americas#Chile.
> However, I’m guessing that perhaps your server/the Perl module doesn’t know
> that?
>
>
>
> “Chile currently observes Daylight Saving Time (DST). Instead of turning
> the clocks back one hour on Sunday, April 26, 2015 as previously planned,
> the Chilean Government has decided to make no further changes to the clock
> in future years.” (
> http://www.timeanddate.com/news/time/chile-abolishes-dst-2015.html).
>
>
>
> Hmm… I don’t know what date is the problem…
>
>
>
> Could you run “perl -d overdue_notices.pl -t" again, but use “n” instead
> of “c”? That way, you’ll be able to see what exact call is generating this
> error.
>
>
>
> I’m guessing it might be one of the lines:
>
>
>
> my $today = DateTime->now(time_zone => C4::Context->tz );
>
>
>
> But that’s just a guess. What happens if you try running your overdues
> again? You might have had the misfortune of the overdues just running at
> the wrong time on the wrong day.
>
>
>
> Curious to hear how you go!
>
>
>
> David Cook
>
> Systems Librarian
>
>
>
> Prosentient Systems
>
> 72/330 Wattle St
>
> Ultimo, NSW 2007
>
>
>
> Office: 02 9212 0899
>
> Direct: 02 8005 0595
>
>
>
> *From:* koha-devel-bounces at lists.koha-community.org [mailto:
> koha-devel-bounces at lists.koha-community.org] *On Behalf Of *Larry Letelier
> *Sent:* Wednesday, 27 April 2016 3:09 PM
> *To:* koha-devel at lists.koha-community.org
> *Subject:* [Koha-devel] Invalid local time for date in time zone:
> America/Santiago
>
>
>
> Hi people,
>
>
>
> We have a 'little' issue with the overdue aka notifications process.
>
>
>
> # pwd
>
> /usr/share/koha/bin/cronjobs
>
>
>
> # ./overdue_notices.pl -t
>
> Invalid local time for date in time zone: America/Santiago
>
>
>
> perl -d overdue_notices.pl -t
>
>
>
> Loading DB routines from perl5db.pl version 1.33
>
> Editor support available.
>
>
>
> Enter h or `h h' for help, or `man perldebug' for more help.
>
>
>
> main::(overdue_notices.pl:278):         my $dbh = C4::Context->dbh();
>
>   DB<1> c
>
>
>
> Invalid local time for date in time zone: America/Santiago
>
>
>
>  at /usr/share/perl5/DateTime/TimeZone.pm line 198
>
>
> DateTime::TimeZone::_span_for_datetime('DateTime::TimeZone::America::Santiago=HASH(0x60cfce8)',
> 'local', 'DateTime=HASH(0x617e938)') called at
> /usr/share/perl5/DateTime/TimeZone.pm line 157
>
>
> DateTime::TimeZone::offset_for_local_datetime('DateTime::TimeZone::America::Santiago=HASH(0x60cfce8)',
> 'DateTime=HASH(0x617e938)') called at /usr/lib/perl5/DateTime.pm line 930
>
>         DateTime::_offset_for_local_datetime('DateTime=HASH(0x617e938)')
> called at /usr/lib/perl5/DateTime.pm line 375
>
>         DateTime::_calc_utc_rd('DateTime=HASH(0x617e938)') called at
> /usr/lib/perl5/DateTime.pm line 263
>
>         DateTime::_new('DateTime', 'hour', 20, 'second', 0, 'month', 9,
> 'locale', 'DateTime::Locale::en_US=HASH(0x1e7eac8)', ...) called at
> /usr/lib/perl5/DateTime.pm line 299
>
>         DateTime::_new_from_self('DateTime=HASH(0x6183808)', 'hour', 0,
> 'minute', 0, 'second', 0, 'month', 9, ...) called at
> /usr/lib/perl5/DateTime.pm line 1933
>
>         DateTime::truncate(undef, 'to', 'day') called at
> /usr/share/koha/lib/Koha/Calendar.pm line 214
>
>         Koha::Calendar::is_holiday('Koha::Calendar=HASH(0x619bc20)',
> 'DateTime=HASH(0x6192ad0)') called at /usr/share/koha/lib/Koha/Calendar.pm
> line 290
>
>         Koha::Calendar::days_between('Koha::Calendar=HASH(0x619bc20)',
> 'DateTime=HASH(0x61a5b90)', 'DateTime=HASH(0x60a7ce0)') called at
> overdue_notices.pl line 538
>
> Debugged program terminated.  Use q to quit or R to restart,
>
>   use o inhibit_exit to avoid stopping after program termination,
>
>   h q, h R or h o to get additional info.
>
>   DB<1> q
>
>
>
> This is a Koha 3.2008000
>
>
>
> In MySQL and in enviroment, tzdata, TZ='America/Santiago' is set.
>
>
>
>
>
> Any idea with this ?
>
>
>
> Thanks for read this,
>
> -Larry
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20160428/1e4afa76/attachment-0001.html>