<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jan 4, 2022 at 10:05 PM Barry Martin <<a href="mailto:barry3martin@gmail.com">barry3martin@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p><br>
</p>
<p> </p>
<p style="margin-bottom:0in;line-height:100%">Hi Folks!</p>
<p style="margin-bottom:0in;line-height:100%"><br>
</p>
<p style="margin-bottom:0in;line-height:100%">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.</p>
<p style="margin-bottom:0in;line-height:100%"><br>
</p>
<p style="margin-bottom:0in;line-height:100%">Running MythTV v30
under Ubuntu 18.04.</p>
<p style="margin-bottom:0in;line-height:100%"><br>
</p>
<p style="margin-bottom:0in;line-height:100%">This morning the
Backend required a manual <font face="Liberation Mono, monospace">fsck
/dev/sda2</font>. Didn’t quick take so ran <font face="Liberation Mono, monospace">fsck
-fy /dev/sda2</font> and followed that with GRUB > Recovery
Mode>
DPKG to fix. (I’m following a post in AskUbuntu.com.) </p>
<p style="margin-bottom:0in;line-height:100%"><br>
</p>
<p style="margin-bottom:0in;line-height:100%">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.</p>
<p style="margin-bottom:0in;line-height:100%"><br>
</p>
<p style="margin-bottom:0in;line-height:100%">Database error:</p>
<p style="margin-bottom:0in;line-height:100%">Table
‘./mythconvverg/program’ is is marked as crashed and last
(automatic ) repair failed</p>
<p style="margin-bottom:0in;line-height:100%"><br>
</p>
<p style="margin-bottom:0in;line-height:100%">Googled: tried
various myisamchk options – eventually I did a find for *.MYI
(used
iname for the case-insensitive option): no *.MYI anywhere.</p>
<p style="margin-bottom:0in;line-height:100%"><br>
</p>
<p style="margin-bottom:0in;line-height:100%">Did try <font face="Liberation Sans Narrow, sans-serif">service
mysql status ==> active (running)</font></p>
<p style="margin-bottom:0in"><font face="Liberation Sans Narrow,
sans-serif"> fatal:
open /etc/postfix/<a href="http://main.cf" target="_blank">main.cf</a>: no such file or directory</font></p>
<p style="margin-bottom:0in;line-height:100%"><br>
</p>
<p style="margin-bottom:0in;line-height:100%">Later thought of </p>
<p style="margin-left:0.49in;margin-bottom:0in;line-height:100%">
<a href="https://www.mythtv.org/wiki/Database_Backup_and_Restore" target="_blank"><font face="Norasi"><font style="font-size:10pt" size="2">https://www.mythtv.org/wiki/Database_Backup_and_Restore</font></font></a></p>
<h4 style="margin-left:0.49in">Full restore of a
specific backup file</h4>
<p style="margin-left:0.49in">Change the directory and filename, as
required: </p>
<pre style="margin-left:0.49in;margin-bottom:0.2in"><a href="http://mythconverg_restore.pl" target="_blank">mythconverg_restore.pl</a> --directory /home/mythtv --filename mythconverg-1214-20080626150513.sql.gz</pre>
<p style="margin-left:0.49in;margin-bottom:0in;line-height:100%"> BE3 ==> /home/barry/Mythtv</p>
<p style="margin-bottom:0in;line-height:100%">Seems mine wants
the
fullpath even though I’m in the correct directory.</p>
<p style="margin-bottom:0in;line-height:100%">Here is
‘home/barry/Mythtv.</p>
<p style="margin-bottom:0in;line-height:100%">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. </p>
<p style="margin-bottom:0in;line-height:100%"><br>
</p>
<p style="margin-bottom:0in;line-height:100%">Help! Now what
should I do?!</p>
<p style="margin-bottom:0in;line-height:100%">Thanks!</p>
<p style="margin-bottom:0in;line-height:100%">Barry </p>
<p style="margin-bottom:0in;line-height:100%"><br></p></div></blockquote><div><br></div><div>First, i would check if your root partition and /tmp partition on your backend is out of free space:</div><div>run in terminal<br></div><div><span style="font-family:monospace">df -h</span></div><div><span style="font-family:monospace"><br></span></div><div><br></div><div>Secondly,I would try to repair the damaged table , the program' table in your case:</div><div>You may need a lot of free space on the /tmp folder.<br></div><div>Note, the needed password is stored in the 'config.xml' file<br></div><div><span style="font-family:monospace">mysql -u mythtv -p<your-password> mythconverg</span></div><div><span style="color:rgb(0,0,0)"><span style="font-family:monospace">MariaDB [mythconverg]>check table program; <br><span style="background-color:rgb(243,243,243)">MariaDB [mythconverg]>repair table program;</span></span></span></div><div><span style="font-family:monospace"><font color="#660066"><br></font></span></div><div><span style="font-family:monospace"><font color="#660066"><span style="color:rgb(0,0,0)"><span style="font-family:arial,sans-serif">The program table holds the past and future EPG, You may need to run mythfilldatabase again.</span></span><br></font></span></div><div><span style="font-family:arial,sans-serif"><span style="color:rgb(0,0,0)"><span style="background-color:rgb(255,255,255)"><br></span></span></span></div><div><span style="background-color:rgb(255,255,255)"><span style="font-family:monospace"><font color="#660066"><span style="font-family:arial,sans-serif"><span style="color:rgb(0,0,0)"><span style="background-color:rgb(255,255,255)">Roland</span></span></span><br> </font></span></span> </div><div><br></div><div> </div></div></div>