Shows missing from Watch Recordings > All Programs

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
zaphod
Newcomer
Posts: 6
Joined: Thu Jun 18, 2020 2:31 am
United States of America

Shows missing from Watch Recordings > All Programs

Post by zaphod » Thu Jun 18, 2020 2:37 am

I've been using mythtv since 2007. Recently, I've found that I have a lot of TV recordings that aren't accessible through the main interface and I cannot figure out why. Does anyone have suggestions? I can access the recordings in MythWeb and via the symlinks that MythPretty makes. But they don't show up in the main interface. It says I have 1274 recordings in "All Programs". But a query on the recorded table says that I have 2140.

User avatar
bill6502
Developer
Posts: 1588
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Shows missing from Watch Recordings > All Programs

Post by bill6502 » Thu Jun 18, 2020 3:12 am

The most common answer is that a Group Filter is active. From Watch Recordings,
select any title, even All Programs, then press m and Change Group Filter. All
Programs doesn't hide anything.

zaphod
Newcomer
Posts: 6
Joined: Thu Jun 18, 2020 2:31 am
United States of America

Re: Shows missing from Watch Recordings > All Programs

Post by zaphod » Thu Jun 18, 2020 11:06 am

Thanks. I wish it were that easy. I'm in the "All Programs" group filter already. The "Change Filter" menu shows "All Programs [1275 items]" at the top. This sql query though:

mysql> select count(*) from recorded;
+----------+
| count(*) |
+----------+
| 2144 |
+----------+
1 row in set (0.01 sec)

User avatar
bill6502
Developer
Posts: 1588
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Shows missing from Watch Recordings > All Programs

Post by bill6502 » Thu Jun 18, 2020 3:43 pm

My next guess would be looking in the frontend and backend logs. Starting
them with -v playback <may> help, but errors should show up without that.

I'd look at the SQL for a good recording and a bad (not displayed) one. Use
the SELECT with a trailing \G to make it easier to read (if you didn't know
that already.)

zaphod
Newcomer
Posts: 6
Joined: Thu Jun 18, 2020 2:31 am
United States of America

Re: Shows missing from Watch Recordings > All Programs

Post by zaphod » Fri Jun 19, 2020 12:25 am

Good suggestions. Thank you!

I guess the inputname changed. and maybe that's the cause of the issue. I ran some queries to "fix" it:

update recorded set inputname = 'HDHR-US 0' where inputname like "Input 1";
update recorded set inputname = 'HDHR-US 1' where inputname like "Input 2";
update recorded set inputname = 'HDHR4-2US 0.0' where inputname like "Input 3";
update recorded set inputname = 'HDHR4-2US 1.0' where inputname like "Input 4";
update recorded set inputname = 'HDHR-US 0' where inputname not like "%HDHR%"; //two shows had no input

The frontend didn't correct on that immediately, or when I restarted it. The backend is recording a show now. So, I'll restart it later. Hopefully that fixes it.

Thanks very much for your help bill6502!

zaphod
Newcomer
Posts: 6
Joined: Thu Jun 18, 2020 2:31 am
United States of America

Re: Shows missing from Watch Recordings > All Programs

Post by zaphod » Fri Jun 19, 2020 12:59 am

Well, that wasn't it after all.

It looks like maybe I've got 868 shows in deletepending. Is that a problem? If so, is there an easy fix?

Maybe it's not, and they'll just hang around until some space is needed. Right?

mysql> select count(*) from recorded where deletepending=1;
+----------+
| count(*) |
+----------+
| 868 |
+----------+
1 row in set (0.00 sec)

User avatar
bill6502
Developer
Posts: 1588
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Shows missing from Watch Recordings > All Programs

Post by bill6502 » Fri Jun 19, 2020 11:29 am

I was hoping for some other difference in the recorded table. inputname is
OK, as you saw.

Please add your MythTV version.

Try this and see if all recorded columns are in the Default recgroup
and have a matching recgroupid:

Code: Select all

SELECT * FROM recgroups;
+------------+----------+----------------+----------+---------+
| recgroupid | recgroup | displayname    | password | special |
+------------+----------+----------------+----------+---------+
|          1 | Default  |                |          |       1 |
|          2 | LiveTV   |                |          |       1 |
|          3 | Deleted  |                |          |       1 |
|          4 | TOH      | This Old House | test     |       0 |
+------------+----------+----------------+----------+---------+
4 rows in set (0.00 sec)

zaphod
Newcomer
Posts: 6
Joined: Thu Jun 18, 2020 2:31 am
United States of America

Re: Shows missing from Watch Recordings > All Programs

Post by zaphod » Sat Jun 20, 2020 7:13 pm

More questions?

I thought that maybe this was normal (for mythbackend and mythfrontend), and it was just that MythWeb and MythPretty were defective in not filtering these out. I assume that these are shows I watched and deleted, and that maybe to give me an opportunity to recover them, they would be kept until my requirements for free space, required that something be actually deleted.

Code: Select all

mythbackend --version
Please attach all output as a file in bug reports.
MythTV Version : v29.1-13-g329c235
MythTV Branch : fixes/29
Network Protocol : 91
Library API : 29.20180316-1
QT Version : 5.9.4
Options compiled in:
 linux profile use_hidesyms using_alsa using_oss using_pulse using_pulseoutput using_backend using_bindings_perl using_bindings_python using_bindings_php using_crystalhd using_dvb using_firewire using_frontend using_hdhomerun using_vbox using_ceton using_hdpvr using_ivtv using_joystick_menu using_libcec using_libcrypto using_libdns_sd using_libfftw3 using_libxml2 using_lirc using_mheg using_opengl using_opengl_video using_opengl_themepainter using_qtwebkit using_qtscript using_qtdbus using_taglib using_v4l2 using_x11 using_xrandr using_xv using_profiletype using_systemd_notify using_systemd_journal using_bindings_perl using_bindings_python using_bindings_php using_freetype2 using_mythtranscode using_opengl using_vaapi using_vdpau using_ffmpeg_threads using_mheg using_libass using_libxml2 using_libmp3lame

Code: Select all

mysql> SELECT * FROM recgroups;
+------------+---------------+---------------+----------+---------+
| recgroupid | recgroup      | displayname   | password | special |
+------------+---------------+---------------+----------+---------+
|          1 | Default       |               |          |       1 |
|          2 | LiveTV        |               |          |       1 |
|          3 | Deleted       |               |          |       1 |
|          4 | Kids          | Kids          |          |       0 |
|          5 | PG-13+ Movies | PG-13+ Movies |          |       0 |
+------------+---------------+---------------+----------+---------+

zaphod
Newcomer
Posts: 6
Joined: Thu Jun 18, 2020 2:31 am
United States of America

Re: Shows missing from Watch Recordings > All Programs

Post by zaphod » Sun Jun 21, 2020 12:24 pm

bill6502 did you overlook my post about "deletepending=1"?

By the way, thanks for your help on this, and sorry to be a bother. I'm guessing maybe this is "normal" behavior for mythfrontend and mythbackend. I don't use MythWeb a lot, and I've only recently started using MythPretty. I do believe that when I delete shows using MythWeb, they "stay gone". But MythWeb is a different interface (from a different developer?), and it *is* actually frustratingly slow when I try to use it to delete a bunch of shows at once.

User avatar
bill6502
Developer
Posts: 1588
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Shows missing from Watch Recordings > All Programs

Post by bill6502 » Sun Jun 21, 2020 2:11 pm

deletepending=1 means exactly that. At least some of the methods that load programs
only get those with deletepending=0. It isn't (directly) referenced in the mythweb code.
It does, however, exclude items in the "Deleted" recgroup,

You'll find that if "Delete files slowly" is set, it will appear that files aren't being deleted,
but they'll go away slowly, to reduce load on the system. I'd expect the count to drop
(mine's 1 right now.)

There is no mythweb developer.

Post Reply