Opened 7 years ago
Closed 7 years ago
Last modified 6 years ago
#13096 closed Bug Report - General (fixed)
Previously Recorded' screen is only showing ancient history
Reported by: | Owned by: | Peter Bennett | |
---|---|---|---|
Priority: | minor | Milestone: | 29.1 |
Component: | MythTV - General | Version: | Master Head |
Severity: | medium | Keywords: | |
Cc: | Ticket locked: | no |
Description
My main mythbox says it is running frontend
Revision: v30-Pre-v30-Pre-3-g538f99e
locally built for SL7 using an rpm specfile based on that from rpmfusion.
I recently noticed that the Manage Recordings > Previously Recorded screen lists only recordings made between Jan 2005 and Nov 2014, with one exception from Mar 2015. I remember that it used to show a detailed list of recent stuff too, but I don't know when I lost that.
I have before-and-after DB backups from Nov 2014 when I started using this hardware, and it seems quite likely that I messed up a hostname change then. I've also imported a few recordings from other boxes, using MythArchive? native mode, perhaps with mismatched Myth versions; they never appeared in this screen.
The system still knows about at least some of the 'missing' recordings. It finds them with select > Edit > Schedule info > Previously recorded.
Another independent box, Fedora 25, same revision, seems ok but isn't showing the list of recent unrecorded repeats etc that I used to see.
This looks a likely suspect; from 'mythfrontend -v database'
2017-06-16 23:45:18.924742 I MSqlQuery::exec(DBManager2) SELECT oldrecorded.chanid, starttime, endtime, title, subtitle, description, season, episode, category, seriesid, programid, inetref, channel.channum, channel.callsign, channel.name, findid, rectype, recstatus, recordid, duplicate FROM oldrecorded LEFT JOIN channel ON oldrecorded.chanid = channel.chanid WHERE oldrecorded.future = 0 LIMIT 20000 <<<< Took 161ms, Returned 20000 row(s)
I tried 'select starttime from oldrecorded ;' and got 44596 rows. 'recorded' gave 862 rows.
But I only noticed the change in the page very recently.
The above is largely copied, with a little updating, from posts on mythusers in mid-June 2017. I was afraid that the problem might result from some form of database abuse.
Attachments (1)
Change History (9)
comment:1 Changed 7 years ago by
Owner: | set to Peter Bennett |
---|---|
Status: | new → assigned |
comment:2 Changed 7 years ago by
Milestone: | needs_triage → 30.0 |
---|
comment:3 Changed 7 years ago by
This affects people with more than 20000 items previously recorded. Short term fix in attached patch, does 2 things -
- Shows the most recent 20000 items instead of a random 20000 items.
- Adds a setting which can be used to override the default of 20000. Increasing it can be done by those with large histories they want to look at, but at the risk of slow responses and large memory use. Decreasing it can be useful for those with small low powered frontends.
Long term fix is to redesign the previously recorded screen.
comment:4 Changed 7 years ago by
Thank you. I have this in fc25, 30pre39 - but this test-box has only 144 recordings, so doesn't provide a meaningful test. I don't think I shall be able to build for el7 until the repos get back in sync with el7.4. On that box, oldrecorded now has 46000 rows.
I'm afraid it wasn't immediately obvious how nLimit was to be set, but this seems to work:
mythfrontend --override-setting PrevRecLimit=120
comment:5 Changed 7 years ago by
Milestone: | 30.0 → 29.1 |
---|
I am changing the milestone to 29.1 for the short-term fix, and will aim for 30.0 for the redesign of the previously recorded screen. That will be a separate ticket.
comment:6 Changed 7 years ago by
Resolution: | → fixed |
---|---|
Status: | assigned → closed |
comment:8 Changed 6 years ago by
Owner: | changed from Peter Bennett to Peter Bennett |
---|
see https://lists.gt.net/mythtv/users/609048#609048