Mailing List Archive

MythTV refusing to record...
This is new behavior that started recently. There were two recordings showing up in Mythweb upcoming recordings

After the first one should have recorded, I went looking for it. It was not there, and the second scheduled recording was also
gone. As a Test I went to tomorrows listing and added a show to record. It does not appear in the upcoming recordings.

One of the two shows got recorded last night at 3:00 AM

There are two episodes of this show in the listings, each one shows up 5 times at different times and on different channels, but
none of them show up on upcoming recordings.

I have verified that my tuners are working and live TV is working.

This stuff used to work. I have not messed with mythTV in months. There have been some updates to the system, but I did not see
any for MythTV go by.


I am seeing some database errors in the backend log:

JulĀ  2 23:03:10 BlackBox mythbackend: mythbackend[2892]: E Scheduler mythdbcon.cpp:843 (prepare) Error preparing query: DELETE
recordmatch FROM recordmatch, channel WHERE recordmatch.chanid = channel.chanid AND recordmatch.recordid = :RECORDID

Lots more, but I don't want to flood this e-mail with useless data. Will provide if requested.


My guess is that the database got corrupted. Is there a tool to fix this? What is the procedure to run it?


Version of all the parts of MythTV appears to be: 2:31.0+fixes.20200323.9579662cdc-0ubuntu1

System info:

System: Kernel: 5.4.0-77-generic x86_64 bits: 64 compiler: gcc v: 9.3.0 Desktop: Cinnamon 4.8.6
wm: muffin dm: LightDM Distro: Linux Mint 20.1 Ulyssa base: Ubuntu 20.04 focal
Machine: Type: Desktop Mobo: ASRock model: X570 Creator serial: <filter>
BIOS: American Megatrends v: P3.30 date: 12/01/2020
CPU: Topology: 12-Core model: AMD Ryzen 9 3900X bits: 64 type: MT MCP arch: Zen
L2 cache: 6144 KiB
flags: avx avx2 lm nx pae sse sse2 sse3 sse4_1 sse4_2 sse4a ssse3 svm bogomips: 182396
Speed: 2199 MHz min/max: 2200/3800 MHz Core speeds (MHz): 1: 2200 2: 2200 3: 2199
4: 2200 5: 2199 6: 2199 7: 2200 8: 2195 9: 2197 10: 2200 11: 2199 12: 2199 13: 2200
14: 2190 15: 2200 16: 2199 17: 2200 18: 2200 19: 2199 20: 2199 21: 2197 22: 2197
23: 2200 24: 2199
Graphics: Device-1: NVIDIA GM200 [GeForce GTX 980 Ti] vendor: Micro-Star MSI driver: nvidia
v: 460.80 bus ID: 33:00.0 chip ID: 10de:17c8
Display: x11 server: X.Org 1.20.9 driver: nvidia
unloaded: fbdev,modesetting,nouveau,vesa resolution: 3840x2160~60Hz, 2560x1600~60Hz
OpenGL: renderer: GeForce GTX 980 Ti/PCIe/SSE2 v: 4.6.0 NVIDIA 460.80
direct render: Yes
Audio: Device-1: NVIDIA GM200 High Definition Audio vendor: Micro-Star MSI
driver: snd_hda_intel v: kernel bus ID: 33:00.1 chip ID: 10de:0fb0
Device-2: AMD Starship/Matisse HD Audio vendor: ASRock driver: snd_hda_intel v: kernel
bus ID: 35:00.4 chip ID: 1022:1487
Device-3: Microsoft Microsoft LifeCam Studio type: USB
driver: hid-generic,snd-usb-audio,usbhid,uvcvideo bus ID: 7-2:3 chip ID: 045e:0811
Device-4: C-Media type: USB driver: hid-generic,snd-usb-audio,usbhid bus ID: 7-4.3:8
chip ID: 0d8c:0134
Sound Server: ALSA v: k5.4.0-77-generic
Network: Device-1: Intel I211 Gigabit Network vendor: ASRock driver: igb v: 5.6.0-k port: b000
bus ID: 28:00.0 chip ID: 8086:1539
IF: enp40s0 state: down mac: <filter>
Device-2: Intel Wi-Fi 6 AX200 driver: iwlwifi v: kernel port: b000 bus ID: 29:00.0
chip ID: 8086:2723
IF: wlp41s0 state: down mac: <filter>
Device-3: Aquantia AQC107 NBase-T/IEEE 802.3bz Ethernet [AQtion] vendor: ASRock
driver: atlantic v: 5.4.0-77-generic-kern port: a000 bus ID: 2e:00.0 chip ID: 1d6a:07b1
IF: enp46s0 state: up speed: 1000 Mbps duplex: full mac: <filter>
Drives: Local Storage: total: 25.92 TiB used: 5.73 TiB (22.1%)
ID-1: /dev/nvme0n1 vendor: Gigabyte model: GP-ASM2NE6200TTTD size: 1.82 TiB
speed: 63.2 Gb/s lanes: 4 serial: <filter>
ID-2: /dev/nvme1n1 vendor: Gigabyte model: GP-ASM2NE6200TTTD size: 1.82 TiB
speed: 63.2 Gb/s lanes: 4 serial: <filter>
ID-3: /dev/sda vendor: Western Digital model: WD100EFAX-68LHPN0 size: 9.10 TiB
speed: 6.0 Gb/s serial: <filter>
ID-4: /dev/sdb vendor: Western Digital model: WD100EFAX-68LHPN0 size: 9.10 TiB
speed: 6.0 Gb/s serial: <filter>
ID-5: /dev/sdc vendor: Western Digital model: WD15EADS-00P8B0 size: 1.36 TiB
speed: 3.0 Gb/s serial: <filter>
ID-6: /dev/sdj type: USB vendor: Seagate model: Expansion Desk size: 4.55 TiB
serial: <filter>
RAID: Device-1: md127 type: mdraid status: active Components: online: sdb~c0 sda~c1
Info: raid: mirror blocks: 9766304768 report: 2/2 UU chunk size: N/A super blocks: 1.2
Device-2: md0 type: mdraid status: active Components: online: nvme0n1p2~c0 nvme1n1p2~c1
Info: raid: mirror blocks: 1952332800 report: 2/2 UU chunk size: N/A super blocks: 1.2
Partition: ID-1: / size: 1.79 TiB used: 489.58 GiB (26.7%) fs: ext4 dev: /dev/md0p1
ID-2: /boot size: 975.9 MiB used: 410.1 MiB (42.0%) fs: ext4 dev: /dev/nvme0n1p1
Sensors: System Temperatures: cpu: 58.1 C mobo: N/A gpu: nvidia temp: 59 C
Fan Speeds (RPM): N/A gpu: nvidia fan: 0%
Repos: No active apt repos in: /etc/apt/sources.list
Active apt repos in: /etc/apt/sources.list.d/kdenlive-kdenlive-stable-focal.list
1: deb http: //ppa.launchpad.net/kdenlive/kdenlive-stable/ubuntu focal main
Active apt repos in: /etc/apt/sources.list.d/official-package-repositories.list
1: deb https: //mirrors.sonic.net/mint/packages ulyssa main upstream import backport
2: deb http: //la-mirrors.evowise.com/ubuntu focal main restricted universe multiverse
3: deb http: //la-mirrors.evowise.com/ubuntu focal-updates main restricted universe multiverse
4: deb http: //la-mirrors.evowise.com/ubuntu focal-backports main restricted universe multiverse
5: deb http: //security.ubuntu.com/ubuntu/ focal-security main restricted universe multiverse
6: deb http: //archive.canonical.com/ubuntu/ focal partner
Active apt repos in: /etc/apt/sources.list.d/skype-stable.list
1: deb [arch=amd64] https: //repo.skype.com/deb stable main
Info: Processes: 490 Uptime: 14h 10m Memory: 62.74 GiB used: 6.21 GiB (9.9%) Init: systemd
v: 245 runlevel: 5 Compilers: gcc: 9.3.0 alt: 8/9 Client: Unknown python3.8 client
inxi: 3.0.38
Re: MythTV refusing to record... [ In reply to ]
On Fri, 2 Jul 2021 23:29:35 -0700, you wrote:

>This is new behavior that started recently. There were two recordings showing up in Mythweb upcoming recordings
>
>After the first one should have recorded, I went looking for it. It was not there, and the second scheduled recording was also
>gone. As a Test I went to tomorrows listing and added a show to record. It does not appear in the upcoming recordings.
>
>One of the two shows got recorded last night at 3:00 AM
>
>There are two episodes of this show in the listings, each one shows up 5 times at different times and on different channels, but
>none of them show up on upcoming recordings.
>
>I have verified that my tuners are working and live TV is working.
>
>This stuff used to work. I have not messed with mythTV in months. There have been some updates to the system, but I did not see
>any for MythTV go by.
>
>
>I am seeing some database errors in the backend log:
>
>Jul? 2 23:03:10 BlackBox mythbackend: mythbackend[2892]: E Scheduler mythdbcon.cpp:843 (prepare) Error preparing query: DELETE
>recordmatch FROM recordmatch, channel WHERE recordmatch.chanid = channel.chanid AND recordmatch.recordid = :RECORDID
>
>Lots more, but I don't want to flood this e-mail with useless data. Will provide if requested.
>
>
>My guess is that the database got corrupted. Is there a tool to fix this? What is the procedure to run it?

Have you done another package update? There was a problem with the
library that MythTV uses to talk to MySQL/MariaDB. If there was no
database activity for a few hours MythTV is disconnected from the
database. It will normally automatically reconnect, but the new
library was giving it status codes it did not recognise, so it failed
to reconnect. This has all been fixed, but you do need to have all
the packages updated to get this. Your MythTV version is out of date:

> Version of all the parts of MythTV appears to be: 2:31.0+fixes.20200323.9579662cdc-0ubuntu1

My current version is:

v31.0+fixes.202106102123.0680b37c68~ubuntu20.04.1

So I would recommend running:

sudo apt update
sudo apt full-upgrade
sudo apt autoremove
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: MythTV refusing to record... [ In reply to ]
On 7/3/21 3:23 AM, Stephen Worthington wrote:
> On Fri, 2 Jul 2021 23:29:35 -0700, you wrote:
>
>
> Have you done another package update? There was a problem with the
> library that MythTV uses to talk to MySQL/MariaDB. If there was no
> database activity for a few hours MythTV is disconnected from the
> database. It will normally automatically reconnect, but the new
> library was giving it status codes it did not recognise, so it failed
> to reconnect. This has all been fixed, but you do need to have all
> the packages updated to get this. Your MythTV version is out of date:
>
>> Version of all the parts of MythTV appears to be: 2:31.0+fixes.20200323.9579662cdc-0ubuntu1
> My current version is:
>
> v31.0+fixes.202106102123.0680b37c68~ubuntu20.04.1
>
> So I would recommend running:
>
> sudo apt update
> sudo apt full-upgrade
> sudo apt autoremove
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

I ran the suggested commands. It did not find anything to upgrade, and it only found some kernel stuff to autoremove.

My MythTV version is still the same. This is the version provided by the Linux Mint repositories. Is there a PPA I can use to
force a newer version?

Thanks
Re: MythTV refusing to record... [ In reply to ]
On Sat, Jul 3, 2021, 2:38 PM Douglas Peale <Douglas_Peale@comcast.net>
wrote:

> On 7/3/21 3:23 AM, Stephen Worthington wrote:
> > On Fri, 2 Jul 2021 23:29:35 -0700, you wrote:
> >
> >
> > Have you done another package update? There was a problem with the
> > library that MythTV uses to talk to MySQL/MariaDB. If there was no
> > database activity for a few hours MythTV is disconnected from the
> > database. It will normally automatically reconnect, but the new
> > library was giving it status codes it did not recognise, so it failed
> > to reconnect. This has all been fixed, but you do need to have all
> > the packages updated to get this. Your MythTV version is out of date:
> >
> >> Version of all the parts of MythTV appears to be:
> 2:31.0+fixes.20200323.9579662cdc-0ubuntu1
> > My current version is:
> >
> > v31.0+fixes.202106102123.0680b37c68~ubuntu20.04.1
> >
> > So I would recommend running:
> >
> > sudo apt update
> > sudo apt full-upgrade
> > sudo apt autoremove
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users@mythtv.org
> > http://lists.mythtv.org/mailman/listinfo/mythtv-users
> > http://wiki.mythtv.org/Mailing_List_etiquette
> > MythTV Forums: https://forum.mythtv.org
>
> I ran the suggested commands. It did not find anything to upgrade, and it
> only found some kernel stuff to autoremove.
>
> My MythTV version is still the same. This is the version provided by the
> Linux Mint repositories. Is there a PPA I can use to
> force a newer version?
>
> Thanks
>

I use ppa:mythbuntu/31
Re: MythTV refusing to record... [ In reply to ]
On 7/3/21 3:23 AM, Stephen Worthington wrote:
> Have you done another package update? There was a problem with the
> library that MythTV uses to talk to MySQL/MariaDB. If there was no
> database activity for a few hours MythTV is disconnected from the
> database. It will normally automatically reconnect, but the new
> library was giving it status codes it did not recognise, so it failed
> to reconnect. This has all been fixed, but you do need to have all
> the packages updated to get this. Your MythTV version is out of date:
>
>> Version of all the parts of MythTV appears to be: 2:31.0+fixes.20200323.9579662cdc-0ubuntu1
> My current version is:
>
> v31.0+fixes.202106102123.0680b37c68~ubuntu20.04.1
>
> So I would recommend running:
>
> sudo apt update
> sudo apt full-upgrade
> sudo apt autoremove
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

I found this page: https://www.mythtv.org/wiki/Installing_MythTV_on_Ubuntu

and ran this command: |sudo add-apt-repository ppa:mythbuntu/31|

|The update manager then found a new version of MythTV. I have updated it, now I will restart my system to see if everything is
working again.|

|Thanks.
|
Re: MythTV refusing to record... [ In reply to ]
On 7/3/21 11:51 AM, James Abernathy wrote:
>
> I use ppa:mythbuntu/31
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

I'm now running 2:31.0+fixes.202106102123.0680b37c68~ubuntu20.04.1 Mythweb is now showing upcoming recordings again.

Thanks for the help.