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

[Tom Dexter]

On 10/31/18, Will Dormann <wdormann at gmail.com> wrote:
> On 10/31/18 2:56 PM, Tom Dexter wrote:
>>     obj = super(datetime, cls).fromtimestamp(float(timestamp), tz)
>> ValueError: timestamp out of range for platform time_t
>>
>> I'm pretty sure that the limit for that time_t may be 2147483647 on
>> x86 and 67768036191676795 on 64 bit systems(?). Has anyone here ever
>> used that option on a 32 bit system?
>
>
> I don't suspect that this is a 32-bit vs. 64-bit thing.   A 32-bit
> system can handle any timestamp that may be associated with a recording.
>   It's possible that you have a recording with an invalid timestamp.
>
> I'd replace line 129:
>
>                     rec.delete(True, True)
>
> With:
>                     try:
>                         rec.delete(True, True)
>                     except ValueError:
>                         print('Error deleting %s' % rec)
>
> And perhaps report back here if there's a single (or few) problematic
> recording, of if it's for all of them.
>
>
> -WD

I agree that it should be able to handle an epoch value as a
timestamp, but I have a feeling it's doing something else there that
is in fact causing a problem. The error I reported above was done with
a brand new recording where I moved the video file as a test. No
question it had perfectly valid times. I just tried another:

./find_orphans.py
Recordings with missing files
  mythback: Judge Judy - Random Vandalism or Hilary Clinton Attack?
       1021_20181031203000.ts

           Count:           1
Orphaned snapshots
  mythback: /video/recordings/1021_20181031203000.ts.png
                        1.7MB

           Total:       1.7MB
Please select from the following
 1. Delete orphaned recording entries
 2. Delete orphaned snapshots
 3. Refresh list
> 1
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