[mythtv-users] Latest bugfixes break timezone in 0.27
Steve Greene
sgreene59 at verizon.net
Sat Nov 16 21:52:58 UTC 2013
On Sat, 2013-11-16 at 15:26 -0600, Bill Meek wrote:
> On 11/16/2013 03:10 PM, Steve Greene wrote:
> ><edited for brevity>
> >
> > The timezone fixes won't load, and neither will my backend, after weeks
> > of working continuously. Any ideas where to go next?
>
> Hi;
>
> Did mythbackend crash (e.g. segfault) or fail to start? Could you
> pastebin a recent backend log from start to the error?
>
> If I run: mysql_tzinfo_to_sql /usr/share/zoneinfo 1>/dev/null,
> I see the errors you're probably seeing and don't think that's
> a problem.
>
> master had a fix to change the time zone tested. I updated the
> Wiki: http://www.mythtv.org/wiki/MySQL_Time_Zone_Tables , but
> didn't see that fix go into 0.27.
This problem did materialize with today's 0.27-fixes.
>From mysql command line:
mysql> SELECT CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC');
+----------------------------------------+
| CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC') |
+----------------------------------------+
| NULL |
+----------------------------------------+
1 row in set (0.00 sec.)
Last two lines of mythbackend.log:
Nov 16 15:19:07 bilbo mythbackend: mythbackend[3334]: N CoreContext
mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults
from /usr/share/mythtv//locales/en_us.xml
Nov 16 15:19:07 bilbo mythbackend: mythbackend[3334]: E CoreContext
main_helpers.cpp:547 (run_backend) MySQL time zone support is missing.
Please install it and try again. See 'mysql_tzinfo_to_sql' for
assistance.
Full mythbackend.log at http://pastebin.com/nGN1B5MN.
Thanks!
Steve
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131116/3c1a81d6/attachment.html>
More information about the mythtv-users
mailing list