[mythtv-users] mythfilldatgabase failure

Thu Mar 16 17:21:22 UTC 2023

~ is homedir; if no user is provided, it is 'the current logged in user'
~user is homedir of user
~mythtv is mythtv's homedir wherever that may be, and this path is
expandable as such:
echo ~mythtv

The .xmltv directory inside mythtv user's homedir should then contain a
sqlite database file named SchedulesDirect.DB.

Mike

On Thu, Mar 16, 2023 at 10:59 AM Daryl McDonald <darylangela at gmail.com>
wrote:

>
>
> 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.
>
> _______________________________________________
> 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/20230316/c4c71ca9/attachment.htm>