<div dir="ltr"><div>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.</div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div><br></div><div>Steve Greene<br>(301) 842-8923</div><div><a href="http://historicity.co" target="_blank">historicity.co</a><br></div>An independent archival professional specializing in still photography, moving images and recorded sound.You <br></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jan 5, 2022 at 10:46 AM Roland Ernst <<a href="mailto:rcrernst@gmail.com">rcrernst@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 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" target="_blank">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>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote></div>