[mythtv-users] channel confusion

Sun Mar 7 19:53:49 UTC 2021

Thanks everyone for your responses.  Both the file system check on reboot
and the check and repair of the database happen automatically, though I'm
not sure if mythbackend knows or is forced to wait for the database repair
to complete.  I use journaled file systems (ext4 and xfs) and so the
filesystem check and repair process is a lot faster than it would otherwise
be.

To my original question, there seems to be a simple answer: the listings
are correct.  qubo and IonPlus ceased operation on Feb 28 according to
https://en.wikipedia.org/wiki/Qubo (or Feb 26 according to
https://www.xfinity.com/support/articles/ion-and-qubo-unavailable), even
though I see no sign of this on their website
https://ionmedia.com/business/qubo.  And the channel was used for other
content, Bounce being one of them.  It's unclear if that will be the case
long-term; it would be convenient for me since I generally get better
reception for 65 than 66.

Finally, I inadvertently recorded a show on 65.2 and it was the same as the
one on 66.3.

About the relative timing for myth and the database, here's the mariadb
error.log after the crash:
2021-03-05 20:02:13 0 [Note] InnoDB: Buffer pool(s) load completed at
210305 20:02:13
2021-03-05 20:02:18 41 [ERROR] mysqld: Table './mythconverg/record' is
marked as crashed and should be repaired
2021-03-05 20:02:18 41 [Warning] Checking table:   './mythconverg/record'
2021-03-05 20:02:19 42 [ERROR] mysqld: Table './mythconverg/oldrecorded' is
marked as crashed and should be repaired
2021-03-05 20:02:19 42 [Warning] Checking table:
'./mythconverg/oldrecorded'
## many more like this
2021-03-05 20:05:22 105 [ERROR] mysqld: Table
'./mythconverg/recordedartwork' is marked as crashed and should be repaired
2021-03-05 20:05:22 105 [Warning] Checking table:
'./mythconverg/recordedartwork'
2021-03-05 20:05:29 61 [ERROR] mysqld: Table './mythconverg/recordedfile'
is marked as crashed and should be repaired
2021-03-05 20:05:29 61 [Warning] Checking table:
'./mythconverg/recordedfile'

Over 3 minutes for the repairs.

Here are highlights from the mythbackend log:
2021-03-05 20:02:20.666674 I [3561/3561] CoreContext mythcontext.cpp:900
(TestDBconnection) - Start up testing connections. DB 192.168.1.10, BE ,
attempt 0, status dbAwake, Delay: 2000
# maybe next line implies some info obtained from DB?
2021-03-05 20:02:26.024289 I [3561/3561] CoreContext schemawizard.cpp:120
(Compare) - Current MythTV Schema Version (DBSchemaVer): 1350

2021-03-05 20:02:26.043584 N [3561/3561] CoreContext main_helpers.cpp:605
(run_backend) - MythBackend: Starting up as the master server.
# and perhaps this too?
2021-03-05 20:02:55.759209 I [3561/3561] CoreContext programinfo.cpp:2555
(CheckProgramIDAuthorities) - Found 1 distinct programid authorities
# Housekeeper DBCleanup, or maybe LogClean, sounds as if it might be about
DB repair, but clearly start after repairs are underway
2021-03-05 20:02:55.759574 I [3561/3561] CoreContext housekeeper.cpp:649
(RegisterTask) - Registering HouseKeeperTask 'LogClean'.
2021-03-05 20:02:55.759600 I [3561/4026] Scheduler mythdbcon.cpp:458
(getStaticCon) - New static DB connectionSchedCon
2021-03-05 20:02:55.806085 I [3561/3561] CoreContext housekeeper.cpp:649
(RegisterTask) - Registering HouseKeeperTask 'DBCleanup'.
# many other housekeeping tasks registered
2021-03-05 20:02:55.890349 I [3561/3561] CoreContext housekeeper.cpp:722
(Start) - Starting HouseKeeper.
2021-03-05 20:02:56.136280 I [3561/3561] CoreContext serverpool.cpp:415
(listen) - Listening on TCP 0.0.0.0:6544
2021-03-05 20:02:56.138746 I [3561/3561] CoreContext serverpool.cpp:415
(listen) - Listening on TCP [::]:6544
2021-03-05 20:02:56.138814 I [3561/3561] CoreContext serverpool.cpp:415
(listen) - Listening on TCP 0.0.0.0:6554
2021-03-05 20:02:56.138866 I [3561/3561] CoreContext serverpool.cpp:415
(listen) - Listening on TCP [::]:6554
2021-03-05 20:02:56.139662 I [3561/3561] CoreContext serverpool.cpp:415
(listen) - Listening on TCP 0.0.0.0:6549
2021-03-05 20:02:56.139728 I [3561/3561] CoreContext serverpool.cpp:415
(listen) - Listening on TCP [::]:6549
# rescheduling would seem to require DB access, although repairs are not
complete
2021-03-05 20:02:58.856573 I [3561/4026] Scheduler scheduler.cpp:2356
(HandleReschedule) - Reschedule requested for MATCH 0 0 0 - SchedulerInit
2021-03-05 20:03:00.597200 I [3561/4026] Scheduler scheduler.cpp:2472
(HandleReschedule) - Scheduled 898 items in 1.7 = 0.38 match + 1.15 check +
0.13 place
2021-03-05 20:03:00.732540 I [3561/4026] Scheduler scheduler.cpp:2530
(HandleRunSchedulerStartup) - Scheduler: AUTO-Startup assumed
2021-03-05 20:03:01.612374 C [3561/3561] CoreContext programinfo.cpp:347
(ProgramInfo) - ProgramInfo(): Failed to find recorded entry for 0.
2021-03-05 20:03:01.819030 I [3561/3561] CoreContext
bonjourregister.cpp:117 (BonjourCallback) - Bonjour: Service registration
complete: name 'Mythbackend on barley' type '_mythbackend._tcp.' domain:
'local.'
2021-03-05 20:03:01.947243 I [3561/3648] TVRecEvent tv_rec.cpp:1652
(HandlePendingRecordings) - TVRec[4]: ASK_RECORDING 4 0 0 0
2021-03-05 20:03:02.260543 I [3561/3650] TVRecEvent tv_rec.cpp:1652
(HandlePendingRecordings) - TVRec[6]: ASK_RECORDING 6 0 0 0
2021-03-05 20:03:06.800021 I [3561/4040] Commflag_18637 jobqueue.cpp:2343
(DoFlagCommercialsThread) - JobQueue: Commercial Detection Starting for
"Weather Gone Viral":"Man Versus Weather" recorded from channel 23601 at
2021-02-28T07:58:00Z
2021-03-05 20:03:06.804308 I [3561/4042] SystemManager
mythsystemunix.cpp:276 (run) - Starting process manager
2021-03-05 20:03:06.804268 I [3561/4043] SystemSignalManager
mythsystemunix.cpp:509 (run) - Starting process signal handler
2021-03-05 20:03:06.804374 I [3561/4044] SystemIOHandlerR
mythsystemunix.cpp:92 (run) - Starting IO manager (read)
2021-03-05 20:03:06.804904 I [3561/4045] SystemIOHandlerW
mythsystemunix.cpp:92 (run) - Starting IO manager (write)
2021-03-05 20:03:11.907278 I [3561/4051] Commflag_18799 jobqueue.cpp:2343
(DoFlagCommercialsThread) - JobQueue: Commercial Detection Starting for
"Hawaii Five-0":"Ka'ili Aku" recorded from channel 26501 at
2021-03-06T02:58:00Z
2021-03-05 20:03:56.077921 I [3561/3561] CoreContext housekeeper.cpp:740
(Run) - Queueing HouseKeeperTask 'DBCleanup'.
2021-03-05 20:03:56.077928 I [3561/3561] CoreContext housekeeper.cpp:740
(Run) - Queueing HouseKeeperTask 'JobQueueRecover'.
2021-03-05 20:03:56.077929 I [3561/3561] CoreContext housekeeper.cpp:740
(Run) - Queueing HouseKeeperTask 'LogClean'.
2021-03-05 20:03:56.080723 I [3561/4673] HouseKeeping housekeeper.cpp:142
(Run) - Running HouseKeeperTask 'ThemeUpdateNotifications'.
2021-03-05 20:03:57.603952 I [3561/4673] HouseKeeping
backendhousekeeper.cpp:389 (DoRun) - Loading themes for trunk
2021-03-05 20:03:57.603965 I [3561/4673] HouseKeeping housekeeper.cpp:160
(Run) - HouseKeeperTask 'ThemeUpdateNotifications' Finished Successfully.
2021-03-05 20:03:57.606269 I [3561/4673] HouseKeeping housekeeper.cpp:142
(Run) - Running HouseKeeperTask 'DBCleanup'.
2021-03-05 20:04:15.269424 N [3561/4027] Expire autoexpire.cpp:261
(CalcParams) - AutoExpire: CalcParams(): Max required Free Space: 1.0 GB
w/freq: 15 min
2021-03-05 20:04:56.100880 I [3561/4872] HouseKeeping housekeeper.cpp:142
(Run) - Running HouseKeeperTask 'JobQueueRecover'.
2021-03-05 20:04:56.102410 I [3561/4872] HouseKeeping housekeeper.cpp:160
(Run) - HouseKeeperTask 'JobQueueRecover' Finished Successfully.
2021-03-05 20:04:56.103101 I [3561/4872] HouseKeeping housekeeper.cpp:142
(Run) - Running HouseKeeperTask 'LogClean'.
2021-03-05 20:04:56.103862 I [3561/4872] HouseKeeping housekeeper.cpp:160
(Run) - HouseKeeperTask 'LogClean' Finished Successfully.
2021-03-05 20:05:21.210745 I [3561/4906] ProcessRequest mainserver.cpp:1780
(HandleAnnounce) - MainServer: MainServer::ANN Monitor
2021-03-05 20:05:21.210752 I [3561/4906] ProcessRequest mainserver.cpp:1785
(HandleAnnounce) - MainServer: adding: barley(564a68f69a10) as a client
(events: 0)
2021-03-05 20:05:21.210868 I [3561/4907] ProcessRequest mainserver.cpp:1780
(HandleAnnounce) - MainServer: MainServer::ANN Monitor
2021-03-05 20:05:21.210874 I [3561/4907] ProcessRequest mainserver.cpp:1785
(HandleAnnounce) - MainServer: adding: barley(564a68f6a490) as a client
(events: 0)
2021-03-05 20:05:21.211488 I [3561/4906] ProcessRequest mainserver.cpp:1780
(HandleAnnounce) - MainServer: MainServer::ANN Monitor
2021-03-05 20:05:21.211493 I [3561/4906] ProcessRequest mainserver.cpp:1785
(HandleAnnounce) - MainServer: adding: barley(564a68f4eaa0) as a client
(events: 1)
2021-03-05 20:05:21.211561 I [3561/4907] ProcessRequest mainserver.cpp:1780
(HandleAnnounce) - MainServer: MainServer::ANN Monitor
2021-03-05 20:05:21.211567 I [3561/4907] ProcessRequest mainserver.cpp:1785
(HandleAnnounce) - MainServer: adding: barley(564a68f65440) as a client
(events: 1)
## DBCleanup task finishes after last cleanup in maria logs
2021-03-05 20:05:29.307447 I [3561/4673] HouseKeeping housekeeper.cpp:160
(Run) - HouseKeeperTask 'DBCleanup' Finished Successfully.
# although some activity appears to have preceded the cleanup
# recording does not start until it's done.
2021-03-05 20:05:29.472933 I [3561/3647] TVRecEvent tv_rec.cpp:1091
(HandleStateChange) - TVRec[3]: Changing from None to RecordingOnly

Ross
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210307/f84e03a1/attachment.htm>