[mythtv-users] mythfilldatgabase failure

Thu Mar 16 16:58:33 UTC 2023

On Thu, Mar 16, 2023 at 10:50 AM Bill Meek <keemllib at gmail.com> wrote:

> On Thursday 16 March 2023 06:36:37 AM (-05:00), Daryl McDonald wrote:
>
> Looks like the issue:
> daryl at trieli:~$ tv_grab_zz_sdjson_sqlite --capabilities
> Command 'tv_grab_zz_sdjson_sqlite' not found, but can be installed with:
> sudo apt install xmltv-util
> daryl at trieli:~$ sudo apt install -y xmltv-util
>
> but after installing the xmltv-util we're still not quite there:
>
> daryl at trieli:~$ sudo su mythtv
> $ mythfilldatabase
> 2023-03-16 07:19:48.143231 C  mythfilldatabase version: fixes/32
> [v32.0+fixes.20220325.f69ce764b7-0ubuntu1] www.mythtv.org
> 2023-03-16 07:19:48.143241 C  Qt version: compile: 5.15.2, runtime: 5.15.3
> 2023-03-16 07:19:48.143273 I  Ubuntu 22.04.2 LTS (x86_64)
> 2023-03-16 07:19:48.143275 N  Enabled verbose msgs:  general
> 2023-03-16 07:19:48.143282 N  Setting Log Level to LOG_INFO
> 2023-03-16 07:19:48.153821 I  Added logging to the console
> 2023-03-16 07:19:48.153973 I  Setup Interrupt handler
> 2023-03-16 07:19:48.153982 I  Setup Terminated handler
> 2023-03-16 07:19:48.153986 I  Setup Segmentation fault handler
> 2023-03-16 07:19:48.153989 I  Setup Aborted handler
> 2023-03-16 07:19:48.153991 I  Setup Bus error handler
> 2023-03-16 07:19:48.153995 I  Setup Floating point exception handler
> 2023-03-16 07:19:48.153998 I  Setup Illegal instruction handler
> 2023-03-16 07:19:48.154016 I  Setup Real-time signal 0 handler
> 2023-03-16 07:19:48.154019 I  Setup Hangup handler
> 2023-03-16 07:19:48.154104 N  Using runtime prefix = /usr
> 2023-03-16 07:19:48.154106 N  Using configuration directory =
> /home/mythtv/.mythtv
> 2023-03-16 07:19:48.154132 I  Assumed character encoding: en_CA.UTF-8
> 2023-03-16 07:19:48.154381 I  Empty LocalHostName. This is typical.
> 2023-03-16 07:19:48.154384 I  Using a profile name of: 'trieli' (Usually
> the same as this host's name.)
> 2023-03-16 07:19:48.154415 I  Start up testing connections. DB localhost,
> BE , attempt 0, status dbAwake, Delay: 2000
> 2023-03-16 07:19:49.192982 N  Setting QT default locale to en_CA
> 2023-03-16 07:19:49.192999 I  Current locale en_CA
> 2023-03-16 07:19:49.193080 N  Reading locale defaults from
> /usr/share/mythtv//locales/en_ca.xml
> 2023-03-16 07:19:49.245071 I  PowerDBus: Added UPower.Device
> '/org/freedesktop/UPower/devices/keyboard_hidpp_battery_0'
> 2023-03-16 07:19:49.245705 I  Power: On AC power
> 2023-03-16 07:19:49.248229 I  PowerDBus: Added UPower.Device
> '/org/freedesktop/UPower/devices/mouse_hidpp_battery_1'
> 2023-03-16 07:19:49.293742 I  Power: Supported actions:
> Suspend,Restart,Shutdown
> 2023-03-16 07:19:49.295612 I  Loading en_ca translation for module
> mythfrontend
> 2023-03-16 07:19:49.298571 I  Current MythTV Schema Version (DBSchemaVer):
> 1376
> 2023-03-16 07:19:49.304452 I  MythCoreContext::ConnectCommandSocket():
> Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
> 2023-03-16 07:19:49.310106 I  MythCoreContext::CheckProtoVersion(): Using
> protocol version 91 BuzzOff
> 2023-03-16 07:19:49.310593 I  Opening blocking connection to master backend
> 2023-03-16 07:19:49.611505 I  Updating source #1 (antenna) with grabber
> tv_grab_zz_sdjson_sqlite
> 2023-03-16 07:19:49.612353 I  Found 37 channels for source 1 which use
> grabber
> 2023-03-16 07:19:49.613030 I  Starting process manager
> 2023-03-16 07:19:49.613228 I  Starting IO manager (read)
> 2023-03-16 07:19:49.613255 I  Starting process signal handler
> 2023-03-16 07:19:49.618288 I  Starting IO manager (write)
> 2023-03-16 07:19:50.415621 I  Grabber has capabilities: baseline
> manualconfig preferredmethod lineups apiconfig
> 2023-03-16 07:19:51.267150 I  Grabber prefers method: allatonce
> 2023-03-16 07:19:51.268351 I  XMLTV config file is:
> /home/mythtv/.mythtv/antenna.xmltv
> 2023-03-16 07:19:52.120150 E  XMLTV grabber returned error code 1
> 2023-03-16 07:19:52.770885 E  Malformed XML file, missing </tv> element,
> at line 1, Premature end of document.
> 2023-03-16 07:19:53.034614 I  Updating source #8 (intenna) with grabber
> tv_grab_zz_sdjson_sqlite
> 2023-03-16 07:19:53.035398 I  Found 36 channels for source 8 which use
> grabber
> 2023-03-16 07:19:53.872718 I  Grabber has capabilities: baseline
> manualconfig preferredmethod lineups apiconfig
> 2023-03-16 07:19:54.674329 I  Grabber prefers method: allatonce
> 2023-03-16 07:19:54.675297 I  XMLTV config file is:
> /home/mythtv/.mythtv/intenna.xmltv
> 2023-03-16 07:19:55.478235 E  XMLTV grabber returned error code 1
> 2023-03-16 07:19:55.977897 E  Malformed XML file, missing </tv> element,
> at line 1, Premature end of document.
> 2023-03-16 07:19:56.079645 E  Failed to fetch some program info
> 2023-03-16 07:19:56.079702 I  Adjusting program database end times.
> 2023-03-16 07:19:56.080286 I      0 replacements made
> 2023-03-16 07:19:56.080289 I  Marking generic episodes.
> 2023-03-16 07:19:56.359440 I      Found 0
> 2023-03-16 07:19:56.359447 I  Extending non-unique programids with
> multiple parts.
> 2023-03-16 07:19:56.518298 I      Found 0
> 2023-03-16 07:19:56.518304 I  Fixing missing original airdates.
> 2023-03-16 07:19:57.027359 I      Found 0 with programids
> 2023-03-16 07:19:57.028199 I      Found 0 without programids
> 2023-03-16 07:19:57.028203 I  Marking repeats.
> 2023-03-16 07:19:57.056135 I      Found 0
> 2023-03-16 07:19:57.056142 I  Unmarking new episode rebroadcast repeats.
> 2023-03-16 07:19:57.233117 I      Found 0
> 2023-03-16 07:19:58.067377 I  Marking episode first showings.
> 2023-03-16 07:19:59.402563 I      Found 43413
> 2023-03-16 07:19:59.402570 I  Marking episode last showings.
> 2023-03-16 07:20:00.743345 I      Found 43331
> 2023-03-16 07:20:00.755586 I
> ===============================================================
> | Attempting to contact the master backend for rescheduling.  |
> | If the master is not running, rescheduling will happen when |
> | the master backend is restarted.                            |
> ===============================================================
> 2023-03-16 07:20:00.756650 N  mythfilldatabase run complete.
> 2023-03-16 07:20:00.756726 I  PowerDBus: Closing interfaces
> 2023-03-16 07:20:00.758004 I  Waiting for threads to exit.
> 2023-03-16 07:20:00.758029 I  Exiting
> $
>
> so I did the following from the wiki:
> sudo apt update
> sudo apt install git make xmltv perl-doc
> # Note: xmltv gets the required perl modules
>
> mkdir -p build
> cd build
> git clone https://github.com/XMLTV/xmltv.git
> cd xmltv
> perl Makefile.PL
> make
> make test
> sudo make install
>
> and the mythfilldatabase still failed. do I need to continue in the wiki,
> I assumed the rest would come with the database restore?    Daryl
>
>
> I'd rerun mythfilldatabase -v xmltv and see if there are any clues.
>
> The mythconverg DB may be OK (because of lines like: Found 37 channels for
> source 1 which use grabber),
> but did you restore the SQLIte DB. The default would
> be: ~mythtv/.xmltv/SchedulesDirect.DB.
>
> --
> Bill
> I used "mythconverg_restore.pl" so, no I didn't restore the SQLite DB.
> Sorry, I'm not clear on what you mean by the default would
> be: ~mythtv/.xmltv/SchedulesDirect.DB.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230316/3cfc1719/attachment.htm>