[mythtv-users] Mythfilldatabase taking FOREVER

Sun Jun 5 03:09:44 UTC 2022

On 6/4/22 21:45, Larry Kennedy wrote:
> en_US
> 2022-06-04 22:11:37.118754 I  Current locale en_US
> 2022-06-04 22:11:37.118779 N  Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
> 2022-06-04 22:11:37.121802 I  Loading en_us translation for module mythfrontend
> 2022-06-04 22:11:37.122930 I  Current MythTV Schema Version (DBSchemaVer): 1350
> 2022-06-04 22:11:37.124309 I  MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 192.168.1.200:6543 
> <http://192.168.1.200:6543> (try 1 of 1)
> 2022-06-04 22:11:37.125053 I  MythCoreContext::CheckProtoVersion(): Using protocol version 91 BuzzOff
> 2022-06-04 22:11:37.125480 I  Opening blocking connection to master backend
> 2022-06-04 22:11:37.191341 I  Updating source #2 (sd) with grabber tv_grab_zz_sdjson_sqlite
> 2022-06-04 22:11:37.191711 I  Found 1357 channels for source 2 which use grabber
> 2022-06-04 22:11:37.191899 I  Starting process manager
> 2022-06-04 22:11:37.192755 I  Starting IO manager (read)
> 2022-06-04 22:11:37.192886 I  Managed child (PID: 589) has started! * command=tv_grab_zz_sdjson_sqlite --capabilities, timeout=25
> 2022-06-04 22:11:37.193059 I  Starting process signal handler
> 2022-06-04 22:11:37.193097 I  Starting IO manager (write)
> 2022-06-04 22:11:37.594832 I  Managed child (PID: 589) has exited! command=tv_grab_zz_sdjson_sqlite --capabilities, status=0, result=0
> 2022-06-04 22:11:37.643913 I  Grabber has capabilities: baseline manualconfig preferredmethod lineups apiconfig
> 2022-06-04 22:11:37.644788 I  Managed child (PID: 591) has started! * command=tv_grab_zz_sdjson_sqlite --preferredmethod, timeout=15
> 2022-06-04 22:11:38.066778 I  Managed child (PID: 591) has exited! command=tv_grab_zz_sdjson_sqlite --preferredmethod, status=0, result=0
> 2022-06-04 22:11:38.094620 I  Grabber prefers method: allatonce
> 2022-06-04 22:11:38.095203 I  XMLTV config file is: /home/myuser/.mythtv/sd.xmltv
> 2022-06-04 22:11:39.365187 I  Grabber Command: nice tv_grab_zz_sdjson_sqlite --config-file '/home/myuser/.mythtv/sd.xmltv' --output /tmp/mythKBJFcR
> 2022-06-04 22:11:39.365192 I  ----------------- Start of XMLTV output -----------------
> 2022-06-04 22:11:39.366077 I  Managed child (PID: 593) has started! * command=nice tv_grab_zz_sdjson_sqlite --config-file 
> '/home/myuser/.mythtv/sd.xmltv' --output /tmp/mythKBJFcR, timeout=0
> 2022-06-04 22:11:59.161162 I  Managed child (PID: 593) has exited! command=nice tv_grab_zz_sdjson_sqlite --config-file 
> '/home/myuser/.mythtv/sd.xmltv' --output /tmp/mythKBJFcR, status=0, result=0
> 2022-06-04 22:11:59.182220 I  ------------------ End of XMLTV output ------------------
> 2022-06-04 22:12:04.736720 I  Managed child (PID: 595) has started! * command=/usr/share/mythtv/metadata/Movie/tmdb3.py -v, timeout=0
> 2022-06-04 22:12:04.777034 I  Managed child (PID: 595) has exited! command=/usr/share/mythtv/metadata/Movie/tmdb3.py -v, status=0, result=0
> 2022-06-04 22:12:04.798490 I  Managed child (PID: 597) has started! * command=/usr/share/mythtv/metadata/Television/ttvdb.py -v, timeout=0
> 2022-06-04 22:12:04.939212 I  Managed child (PID: 597) has exited! command=/usr/share/mythtv/metadata/Television/ttvdb.py -v, status=0, result=0
> 2022-06-04 22:12:10.832530 I  Cardutil: HDHomeRun Cablecard Present.
> 2022-06-04 22:12:10.851533 I  Cardutil: HDHomeRun Cablecard Present.
> 2022-06-04 22:12:10.870566 I  Cardutil: HDHomeRun Cablecard Present.
> 2022-06-04 22:12:10.873583 N  Match found for xmltvid I102337.json.schedulesdirect.org <http://I102337.json.schedulesdirect.org> to channel QVC3 
> HD (20925)
> 2022-06-04 22:12:10.875195 N  Match found for xmltvid I104089.json.schedulesdirect.org <http://I104089.json.schedulesdirect.org> to channel 
> Olympic Channel (20822)
> 2022-06-04 22:12:10.876813 N  Match found for xmltvid I114759.json.schedulesdirect.org <http://I114759.json.schedulesdirect.org> to channel AMC 
> + (20892)
> 2022-06-04 22:12:10.878373 N  Match found for xmltvid I19578.json.schedulesdirect.org <http://I19578.json.schedulesdirect.org> to channel WRCDT 
> (WRC-DT) (20804)
> 2022-06-04 22:12:10.879904 N  Match found for xmltvid I19579.json.schedulesdirect.org <http://I19579.json.schedulesdirect.org> to channel WJLADT 
> (WJLA-DT) (20807)
> 2022-06-04 22:12:10.881558 N  Match found for xmltvid I19580.json.schedulesdirect.org <http://I19580.json.schedulesdirect.org> to channel WUSADT 
> (WUSA-DT) (20809)
> 2022-06-04 22:12:10.883091 N  Match found for xmltvid I19581.json.schedulesdirect.org <http://I19581.json.schedulesdirect.org> to channel WETADT 
> (WETA-DT) (20800)
> 2022-06-04 22:12:10.884677 N  Match found for xmltvid I20367.json.schedulesdirect.org <http://I20367.json.schedulesdirect.org> to channel WTTGDT 
> (WTTG-DT) (20805)
> 2022-06-04 22:12:10.886282 N  Match found for xmltvid I26195.json.schedulesdirect.org <http://I26195.json.schedulesdirect.org> to channel WPXWDT 
> (WPXW-DT) (20813)
> 2022-06-04 22:12:10.887903 N  Match found for xmltvid I31046.json.schedulesdirect.org <http://I31046.json.schedulesdirect.org> to channel 
> MOTORTREND HD (20870)
> 2022-06-04 22:12:10.889545 N  Match found for xmltvid I32537.json.schedulesdirect.org <http://I32537.json.schedulesdirect.org> to channel NBC 
> Sports Washington HD

Do your XMLTV related files look like this:

    https://forum.mythtv.org/viewtopic.php?f=36&t=3480&start=15#p19508 ?

When running from the command line, are you doing it as the same user that runs the backend?

There should be exactly one SQLite DB, typically under ~mythtv/.mythtv/xmltv . Based on the above,
it was run as user 'myuser'. I'm wondering if there is one DB for your user and another for user
mythtv. Putting the complete log at pastebin.com is better than log snippets.

My MFDB is running normally.

-- 

Bill