Opened 2 years ago

Closed 2 years ago

Last modified 16 months ago

#13096 closed Bug Report - General (fixed)

Previously Recorded' screen is only showing ancient history

Reported by: J.Pilk@… 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)

20170908_prevrec_limit.patch (1.5 KB) - added by Peter Bennett 2 years ago.
Short term fix

Download all attachments as: .zip

Change History (9)

comment:1 Changed 2 years ago by Peter Bennett

Owner: set to Peter Bennett
Status: newassigned

comment:2 Changed 2 years ago by Stuart Auchterlonie

Milestone: needs_triage30.0

comment:3 Changed 2 years ago by Peter Bennett

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.

Changed 2 years ago by Peter Bennett

Short term fix

comment:4 Changed 2 years ago by J.Pilk@…

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 2 years ago by Peter Bennett

Milestone: 30.029.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 2 years ago by Peter Bennett <pbennett@…>

Resolution: fixed
Status: assignedclosed

In b5a5e80f140d82c02e438d7263506db128930d07/mythtv:

Fixes #13096 - Previously Recorded screen only showing ancient history

This affects people with more than 20000 items previously recorded.
Short term fix 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:7 Changed 2 years ago by Peter Bennett <pbennett@…>

In a9c1f49b0ce2bd24b0195ca0831f44c58fe16531/mythtv:

Fixes #13096 - Previously Recorded screen only showing ancient history

This affects people with more than 20000 items previously recorded.
Short term fix 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.

(cherry picked from commit b5a5e80f140d82c02e438d7263506db128930d07)

comment:8 Changed 16 months ago by Peter Bennett

Owner: changed from Peter Bennett to Peter Bennett
Note: See TracTickets for help on using tickets.