[mythtv-users] find_orphans.py broken on 32 bit x86?

[Jay Harbeston (ISeePeople)]

> On Oct 31, 2018, at 4:54 PM, Tom Dexter <digitalaudiorock at gmail.com> wrote:
> 
> On 10/31/18, Jay Harbeston (ISeePeople) <jharbestonus at gmail.com <mailto:jharbestonus at gmail.com>> wrote:
>> Looks like the date is getting interpreted as being in the future?
>> 
>> Maybe time zone settings are incorrect..
>> 
>> Just a theory
>> 
>>>> 
>>> The following recordings will be deleted
>>> mythback: Judge Judy - Random Vandalism or Hilary Clinton Attack?
>>>      1021_20181031203000.ts
>>> 
>>>          Count:           1
>>> Are you sure you want to continue?
>>>> yes
>>> Traceback (most recent call last):
>>> File "./find_orphans.py", line 230, in <module>
>>>   main()
>>> File "./find_orphans.py", line 214, in main
>>>   opt[1](opt[2])
>>> File "./find_orphans.py", line 129, in delete_recs
>>>   rec.delete(True, True)
>>> File "/usr/lib/python2.7/site-packages/MythTV/dataheap.py", line
>>> 375, in delete
>>>   return self.getProgram().delete(force, rerecord)
>>> File "/usr/lib/python2.7/site-packages/MythTV/dataheap.py", line
>>> 387, in getProgram
>>>   return Program.fromRecorded(self)
>>> File "/usr/lib/python2.7/site-packages/MythTV/mythproto.py", line
>>> 946, in fromRecorded
>>>   return be.getRecording(rec.chanid, rec.starttime)
>>> File "/usr/lib/python2.7/site-packages/MythTV/mythproto.py", line
>>> 647, in getRecording
>>>   return Program(res[1:], db=self.db)
>>> File "/usr/lib/python2.7/site-packages/MythTV/mythproto.py", line
>>> 875, in __init__
>>>   DictData.__init__(self, raw)
>>> File "/usr/lib/python2.7/site-packages/MythTV/altdict.py", line 148,
>>> in __init__
>>>   data = self._process(data)
>>> File "/usr/lib/python2.7/site-packages/MythTV/altdict.py", line 164,
>>> in _process
>>>   data[i] = self._trans[self._field_type[i]](v)
>>> File "/usr/lib/python2.7/site-packages/MythTV/altdict.py", line 104,
>>> in <lambda>
>>>   lambda x: datetime.fromtimestamp(x, datetime.UTCTZ())\
>>> File "/usr/lib/python2.7/site-packages/MythTV/utility/dt.py", line
>>> 304, in fromtimestamp
>>>   obj = super(datetime, cls).fromtimestamp(float(timestamp), tz)
>>> ValueError: timestamp out of range for platform time_t
>>> 
>>> Here's the record in the recorded table...nothing wrong there:
>>> 
>>> mysql> select * from recorded where title='judge judy'\G
>>> *************************** 1. row ***************************
>>>        chanid: 1021
>>>     starttime: 2018-10-31 20:30:00
>>>       endtime: 2018-10-31 20:31:00
>>>         title: Judge Judy
>>>      subtitle: Random Vandalism or Hilary Clinton Attack?
>>>   description: A stranger allegedly keys a six-foot scratch on the
>>> side of a car that has a Clinton bumper sticker on it.
>>>        season: 0
>>>       episode: 0
>>>      category: Reality
>>>      hostname: mythback
>>>      bookmark: 0
>>>       editing: 0
>>>       cutlist: 0
>>>    autoexpire: 1
>>>   commflagged: 0
>>>      recgroup: Default
>>>      recordid: 8308
>>>      seriesid: EP00188710
>>>     programid: EP001887106287
>>>       inetref:
>>>  lastmodified: 2018-10-31 16:30:00
>>>      filesize: 35206384
>>>         stars: 0
>>> previouslyshown: 0
>>> originalairdate: 2018-10-31
>>>      preserve: 0
>>>        findid: 0
>>> deletepending: 0
>>>    transcoder: 0
>>>   timestretch: 1
>>>   recpriority: 0
>>>      basename: 1021_20181031203000.ts
>>>     progstart: 2018-10-31 20:00:00
>>>       progend: 2018-10-31 20:30:00
>>>     playgroup: Default
>>>       profile: Default
>>>     duplicate: 1
>>>    transcoded: 0
>>>       watched: 0
>>>  storagegroup: Default
>>> bookmarkupdate: 0000-00-00 00:00:00
>>>    recgroupid: 1
>>>    recordedid: 5582
>>>     inputname: HDHR 1
>>> 1 row in set (0.01 sec)
>>> 
>>> Tom
> 
> You're just seeing the UTC times in the database which are correct (4
> hours after EDT here):
> 
> date
> Wed Oct 31 16:52:34 EDT 2018
> date -u
> Wed Oct 31 20:52:37 UTC 2018
> 

I agree with what you mentioned, but I bet there is still something fishy about time zone.  Would be interesting to see what happens when you try this utility in 4+ hours. I am guessing the date will be in the past and will work fine.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20181031/b946df98/attachment.html>