<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 09/22/2015 07:49 PM, Frank Phillips
wrote:<br>
</div>
<blockquote
cite="mid:CAADtG4hCkbovRdF8P6ccUgzp4jPXaMDuz7h9PTNX-3iQ8b2nQw@mail.gmail.com"
type="cite">
<div dir="ltr">On Tue, Sep 22, 2015 at 9:41 PM, Dick Steffens <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:dick@dicksteffens.com" target="_blank">dick@dicksteffens.com</a>></span>
wrote:<br>
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex"><snip><br>
The real problem is that when I started up the frontend
and stepped through the screens to the list of recorded
programs, that list was empty.<br>
<br>
I also used my laptop to look at MythWeb. The listing tab
still has all the channels shown, with my favorites filter
engaged. But the Upcoming Recordings and Recorded Programs
tabs are empty, except for the page headers.<br>
<br>
<snip><br>
<br>
Any clue what happened, and, more importantly, how to fix
it so the front end displays those files?<br>
<br>
Thanks for any help.<span class="HOEnZb"><font
color="#888888"><br>
<br>
</font></span></blockquote>
<div><br>
</div>
<div>You need to check on the database. Make sure mysqld is
running. </div>
</div>
</div>
</div>
</blockquote>
<br>
Yes.<br>
<br>
<blockquote
cite="mid:CAADtG4hCkbovRdF8P6ccUgzp4jPXaMDuz7h9PTNX-3iQ8b2nQw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">
<div>Check in mythweb > settings > database and see if
it needs to be repaired. </div>
</div>
</div>
</div>
</blockquote>
<br>
After several seconds I got a list with headers Name and Status.
Most of the entries under Status are "OK" but two are not. They are:<br>
<br>
oldprogram Table is marked as crashed and last repair
failed<br>
record Table is marked as crashed and last
repair failed<br>
<br>
I ran Repair Tables from MythWeb. The page repopulated with all
entries showing OK, and I can see the list of recorded programs, but
the Upcoming Recordings page is still empty. I also ran Extended
Check, but that had no effect on the Upcoming Recordings page. (I
ran these after the stuff below.)<br>
<br>
<blockquote
cite="mid:CAADtG4hCkbovRdF8P6ccUgzp4jPXaMDuz7h9PTNX-3iQ8b2nQw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">
<div>If you can, log into mysql and check the recorded table
manually to see if recordings are listed. </div>
</div>
</div>
</div>
</blockquote>
<br>
mysql> select title from recorded;<br>
+----------------------------------------+<br>
| title |<br>
+----------------------------------------+<br>
| House Hunters International |<br>
| House Hunters International |<br>
| House Hunters International Renovation |<br>
| Life on the Reef |<br>
| NFL Football |<br>
| Roadtrip Nation |<br>
| Saving America |<br>
| Saving America |<br>
| Starlight Ballroom (My Music) |<br>
| The Muppets Take Manhattan |<br>
| Ultimate Restorations |<br>
| Wild Photo Adventures |<br>
+----------------------------------------+<br>
12 rows in set (0.00 sec)<br>
<br>
A number of those are "deleted" shows which we watched last night,
so I expect them to go away after tonight, since I set that feature
to 1 day.<br>
<br>
I also tried to look at the tables record and oldprogram. Here's
what I got:<br>
<br>
mysql> describe record;<br>
ERROR 144 (HY000): Table './mythconverg/record' is marked as crashed
and last (automatic?) repair failed<br>
mysql> describe oldprogram;<br>
ERROR 144 (HY000): Table './mythconverg/oldprogram' is marked as
crashed and last (automatic?) repair failed<br>
mysql><br>
<br>
<blockquote
cite="mid:CAADtG4hCkbovRdF8P6ccUgzp4jPXaMDuz7h9PTNX-3iQ8b2nQw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">
<div>Check mythbackend log and syslog to look for the hang
and damage caused.<br>
</div>
</div>
</div>
</div>
</blockquote>
<br>
Here's some of the stuff from mythbackend.log from before I tried to
start up the frontend: <br>
<br>
-------------------------------------------------------------------------------------------<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: I
ProcessRequest mainserver.cpp:1448 (HandleAnnounce) adding:
ThinkCentre-M58p as a client (events: 1)<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdbcon.cpp:844 (prepare) Error preparing query: SELECT
NULL from record WHERE type = :FINDONE AND findid <= 0;<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdbcon.cpp:846 (prepare) Driver error was
[2/144]:#012QMYSQL3: Unable to prepare statement#012Database error
was:#012Table './mythconverg/record' is marked as crashed and last
(automatic?) repair failed<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdb.cpp:183 (DBError) DB Error
(UpdateMatches3):#012Query was:#012SELECT NULL from record WHERE
type = ? AND findid <= 0;#012Bindings were:#012:FINDONE=6#012No
error type from QSqlError? Strange...<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdbcon.cpp:844 (prepare) Error preparing query: CREATE
TEMPORARY TABLE sched_temp_record LIKE record;<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdbcon.cpp:846 (prepare) Driver error was
[2/144]:#012QMYSQL3: Unable to prepare statement#012Database error
was:#012Table './mythconverg/record' is marked as crashed and last
(automatic?) repair failed<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdb.cpp:183 (DBError) DB Error (Creating
sched_temp_record table):#012Query was:#012CREATE TEMPORARY TABLE
sched_temp_record LIKE record;#012No error type from QSqlError?
Strange...<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdbcon.cpp:844 (prepare) Error preparing query: UPDATE
recordmatch INNER JOIN sched_temp_record ON (recordmatch.recordid =
sched_temp_record.recordid) INNER JOIN program p ON
(recordmatch.chanid = p.chanid AND
recordmatch.starttime = p.starttime AND
recordmatch.manualid = p.manualid) LEFT JOIN oldrecorded ON (
sched_temp_record.dupmethod > 1 AND oldrecorded.duplicate
<> 0 AND p.title = oldrecorded.title AND p.generic =
0 AND ( (p.programid <> '' AND
p.programid = oldrecorded.programid) OR (
(p.programid = '' OR oldrecorded.programid = '') AND
(((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle
<> '' AND p.subtitle = oldrecorded.subtitle))
AND (((sched_temp_record.dupmethod & 0x04) = 0) OR
(p.description <> '' AND p.description =
oldrecorded.description)) AND
(((sched_temp_record.dupmethod & 0x08) = 0) OR
(p.subtitle <> '' AND (p.subtitle =
oldrecorded.subtitle OR (oldrecorded.subtitle = ''
AND p.subtitle = oldrecorded.description)))
OR (p.subtitle = '' AND p.description <> ''
AND (p.description = oldrecorded.subtitle
OR (oldrecorded.subtitle = '' AND
p.description = oldrecorded.description)))) ) ) ) LEFT
JOIN sched_temp_recorded recorded ON (
sched_temp_record.dupmethod > 1 AND recorded.duplicate
<> 0 AND p.title = recorded.title AND p.generic = 0
AND recorded.recgroup NOT IN ('LiveTV','Deleted') AND
( (p.programid <> '' AND p.programid =
recorded.programid) OR ( (p.programid = '' OR
recorded.programid = '') AND
(((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle
<> '' AND p.subtitle = recorded.subtitle))
AND (((sch<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdbcon.cpp:846 (prepare) Driver error was
[2/1146]:#012QMYSQL3: Unable to prepare statement#012Database error
was:#012Table 'mythconverg.sched_temp_record' doesn't exist<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdb.cpp:183 (DBError) DB Error
(UpdateDuplicates):#012Query was:#012UPDATE recordmatch INNER JOIN
sched_temp_record ON (recordmatch.recordid =
sched_temp_record.recordid) INNER JOIN program p ON
(recordmatch.chanid = p.chanid AND
recordmatch.starttime = p.starttime AND
recordmatch.manualid = p.manualid) LEFT JOIN oldrecorded ON (
sched_temp_record.dupmethod > 1 AND oldrecorded.duplicate
<> 0 AND p.title = oldrecorded.title AND p.generic =
0 AND ( (p.programid <> '' AND
p.programid = oldrecorded.programid) OR (
(p.programid = '' OR oldrecorded.programid = '') AND
(((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle
<> '' AND p.subtitle = oldrecorded.subtitle))
AND (((sched_temp_record.dupmethod & 0x04) = 0) OR
(p.description <> '' AND p.description =
oldrecorded.description)) AND
(((sched_temp_record.dupmethod & 0x08) = 0) OR
(p.subtitle <> '' AND (p.subtitle =
oldrecorded.subtitle OR (oldrecorded.subtitle = ''
AND p.subtitle = oldrecorded.description)))
OR (p.subtitle = '' AND p.description <> ''
AND (p.description = oldrecorded.subtitle
OR (oldrecorded.subtitle = '' AND
p.description = oldrecorded.description)))) ) ) ) LEFT
JOIN sched_temp_recorded recorded ON (
sched_temp_record.dupmethod > 1 AND recorded.duplicate
<> 0 AND p.title = recorded.title AND p.generic = 0
AND recorded.recgroup NOT IN ('LiveTV','Deleted') AND
( (p.programid <> '' AND p.programid =
recorded.programid) OR ( (p.programid = '' OR
recorded.programid = '') AND
(((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle
<> '' AND p.subtitle = recorded.subtitle)) <br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdbcon.cpp:844 (prepare) Error preparing query: SELECT
recordid, title, maxepisodes, maxnewest FROM sched_temp_record<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdbcon.cpp:846 (prepare) Driver error was
[2/1146]:#012QMYSQL3: Unable to prepare statement#012Database error
was:#012Table 'mythconverg.sched_temp_record' doesn't exist<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdb.cpp:183 (DBError) DB Error (CheckTooMany):#012Query
was:#012SELECT recordid, title, maxepisodes, maxnewest FROM
sched_temp_record#012Driver error was [2/1146]:#012QMYSQL: Unable to
execute query#012Database error was:#012Table
'mythconverg.sched_temp_record' doesn't exist<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdbcon.cpp:844 (prepare) Error preparing query: SELECT
record.title, record.subtitle, record.description,
record.season, record.episode,
record.category, record.chanid,
channel.channum, record.station,
channel.name, record.recgroup,
record.playgroup, record.seriesid,
record.programid, record.inetref,
record.recpriority, record.startdate,
record.starttime, record.enddate,
record.endtime, record.recordid,
record.type, record.dupin,
record.dupmethod,
record.findid, record.startoffset,
record.endoffset,
channel.commmethod FROM record INNER JOIN
channel ON (channel.chanid = record.chanid) LEFT JOIN recordmatch on
record.recordid = recordmatch.recordid WHERE (type = 1 OR type = 7)
AND recordmatch.chanid IS NULL<br>
Sep 22 19:04:06 ThinkCentre-M58p mythbackend: mythbackend[2201]: E
Scheduler mythdbcon.cpp:846 (prepare) Driver error was
[2/144]:#012QMYSQL3: Unable to prepare statement#012Database error
was:#012Table './mythconverg/record' is marked as crashed and last
(automatic?) repair failed<br>
-------------------------------------------------------------------------------------------<br>
<br>
There are more lines similar to those.<br>
<br>
<br>
syslog has stuff from after I got the machine running again.
syslog.1 has this from the time before I tried to start up the
frontend to after I got the machine started again:<br>
<br>
-------------------------------------------------------------------------------------------<br>
Sep 22 06:39:01 ThinkCentre-M58p CRON[21839]: (root) CMD ( [ -x
/usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ]
&& find /var/lib/php5/ -depth -mindepth 1 -maxdepth 1 -type
f -cmin +$(/usr/lib/php5/maxlifetime) ! -execdir fuser -s {}
2>/dev/null \; -delete)<br>
Sep 22 07:09:01 ThinkCentre-M58p CRON[21855]: (root) CMD ( [ -x
/usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ]
&& find /var/lib/php5/ -depth -mindepth 1 -maxdepth 1 -type
f -cmin +$(/usr/lib/php5/maxlifetime) ! -execdir fuser -s {}
2>/dev/null \; -delete)<br>
Sep 22 07:17:01 ThinkCentre-M58p CRON[21865]: (root) CMD ( cd /
&& run-parts --report /etc/cron.hourly)<br>
Sep 22 07:30:01 ThinkCentre-M58p CRON[21873]: (root) CMD (start -q
anacron || :)<br>
Sep 22 07:30:01 ThinkCentre-M58p anacron[21876]: Anacron 2.3 started
on 2015-09-22<br>
Sep 22 07:30:01 ThinkCentre-M58p anacron[21876]: Will run job
`cron.daily' in 5 min.<br>
Sep 22 07:30:01 ThinkCentre-M58p anacron[21876]: Jobs will be
executed sequentially<br>
Sep 22 07:35:01 ThinkCentre-M58p anacron[21876]: Job `cron.daily'
started<br>
Sep 22 07:35:01 ThinkCentre-M58p anacron[21882]: Updated timestamp
for job `cron.daily' to 2015-09-22<br>
-------------------------------------------------------------------------------------------<br>
<br>
<br>
At this point I assume that I need to reprogram the shows I want to
watch for the rest of the week.<br>
<br>
More importantly, does any of the above information point to
something that I need to address with my hardware? As you can tell
from the name of the machine, it's a ThinkCentre M58P.<br>
<pre class="moz-signature" cols="72">--
Regards,
Dick Steffens
</pre>
</body>
</html>