[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