[mythtv-users] Database corruption – I think

[Steve Greene]

Before you start messing with filesystems, you may want to verify that your
primary backend is still at the IP address in your settings. If you have
DHCP, it can change when the router renews "the lease" on the connection.
If that is the case, you should change to a dedicated IP address.

Steve Greene
(301) 842-8923
historicity.co
An independent archival professional specializing in still photography,
moving images and recorded sound.You


On Wed, Jan 5, 2022 at 10:46 AM Roland Ernst <rcrernst at gmail.com> wrote:

>
>
> On Tue, Jan 4, 2022 at 10:05 PM Barry Martin <barry3martin at gmail.com>
> wrote:
>
>>
>> Hi Folks!
>>
>>
>> Last night at the very end of watching shows on a remote Frontend had a
>> problem where the FE couldn’t find the database – show completed fine, we
>> play a game of how many hours on the Information screen (the one before the
>> one listing deleted shows) – all blank fields. At the FE exited Myth, tried
>> commandline ‘mythfrontend’ – error something like can’t find backend
>> database.
>>
>>
>> Running MythTV v30 under Ubuntu 18.04.
>>
>>
>> This morning the Backend required a manual fsck /dev/sda2. Didn’t quick
>> take so ran fsck -fy /dev/sda2 and followed that with GRUB > Recovery
>> Mode> DPKG to fix. (I’m following a post in AskUbuntu.com.)
>>
>>
>> Backend now working; tested and the recorded shows are there and play.
>> Did see an error about “is mythfilldatabase running?”; figured that would
>> resolve itself at the pre-scheduled run to SchedulesDirect later in the
>> morning. Nope.
>>
>>
>> Database error:
>>
>> Table ‘./mythconvverg/program’ is is marked as crashed and last
>> (automatic ) repair failed
>>
>>
>> Googled: tried various myisamchk options – eventually I did a find for
>> *.MYI (used iname for the case-insensitive option): no  *.MYI anywhere.
>>
>>
>> Did try service mysql status ==> active (running)
>>
>> fatal: open /etc/postfix/main.cf: no such file or directory
>>
>>
>> Later thought of
>>
>> https://www.mythtv.org/wiki/Database_Backup_and_Restore
>> Full restore of a specific backup file
>>
>> Change the directory and filename, as required:
>>
>> mythconverg_restore.pl --directory /home/mythtv --filename mythconverg-1214-20080626150513.sql.gz
>>
>> BE3 ==> /home/barry/Mythtv
>>
>> Seems mine wants the fullpath even though I’m in the correct directory.
>>
>> Here is ‘home/barry/Mythtv.
>>
>> The source filename – says “The specified backup file does not exist”.
>> (Error says stopped at line 845 if that helps any.) I pulled it in from the
>> GUI file cabinet, tried with and without the full path. ls says it’s there.
>>
>>
>> Help! Now what should I do?!
>>
>> Thanks!
>>
>> Barry
>>
>>
>>
> First, i would check if your root partition and /tmp partition on your
> backend is out of free space:
> run in terminal
> df -h
>
>
> Secondly,I would try to repair the damaged table , the program' table in
> your case:
> You may need a lot of free space on the /tmp folder.
> Note, the needed password is stored in the 'config.xml' file
> mysql -u mythtv -p<your-password> mythconverg
> MariaDB [mythconverg]>check table program;
> MariaDB [mythconverg]>repair table program;
>
> The program table holds the past and future EPG, You may need to run
> mythfilldatabase again.
>
> Roland
>
>
> _______________________________________________
> 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/20220105/3ad4621a/attachment.htm>