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
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