[mythtv-users] Mythfilldatabase taking FOREVER

Larry Kennedy lunchtimelarry at gmail.com
Sun Jun 5 12:14:37 UTC 2022


On Sat, Jun 4, 2022 at 11:11 PM Bill Meek <keemllib at gmail.com> wrote:

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

Bill, I get this response from that backend endpoint:

<VideoSourceList version="1.0" serializerVersion="1.1">
<AsOf>2022-06-05T12:07:03Z</AsOf>
<Version>30.20181231-1</Version>
<ProtoVer>91</ProtoVer>
<VideoSources>
<VideoSource>
<Id>2</Id>
<SourceName>sd</SourceName>
<Grabber>tv_grab_zz_sdjson_sqlite</Grabber>
<UserId/>
<FreqTable>default</FreqTable>
<LineupId/>
<Password/>
<UseEIT>false</UseEIT>
<ConfigPath/>
<NITId>-1</NITId>
</VideoSource>
</VideoSources>
</VideoSourceList>


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

The backend runs under user mythtv.  I've been running the grabber and MFDB
via a cron job from my user account.  It's been working that way without
issues for years, until recently.  Maybe that is something to address?.


> My MFDB is running normally.
>
> --
>
> Bill
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20220605/86f9b5bd/attachment.htm>


More information about the mythtv-users mailing list