Anyone know what the recordmatch table does anyway? I was looking at it and it doesn't seem very obvious. Mine is exactly 1000 records long and seems to have a lot of repetitive data but no clear indication of what it's for. Googling didn't yield any results either.<div>
<br></div><div>Jason</div><div>
<br><br><div class="gmail_quote">On Mon, May 20, 2013 at 1:05 PM, Jason Bilbrey <span dir="ltr"><<a href="mailto:jason@bilbrey.me" target="_blank">jason@bilbrey.me</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Thanks David. I restored just the recordmatch table from a backup and then the scheduler started working again and shows began recording based on my recording rules again.<div><br></div><div>Not sure how it got corrupted in the first place but that definitely fixed it.</div>
<span class="HOEnZb"><font color="#888888">
<div><br></div></font></span><div><span class="HOEnZb"><font color="#888888">Jason</font></span><div><div class="h5"><br>
<br><br><div class="gmail_quote">On Sun, May 19, 2013 at 10:24 AM, David Engel <span dir="ltr"><<a href="mailto:david@istwok.net" target="_blank">david@istwok.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div>On Sat, May 18, 2013 at 10:36:38AM -0500, Jason Bilbrey wrote:<br>
> My scheduler suddenly stopped working. I've run a <a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a> and<br>
> it ran fine. When I run mythbackend --testsched I get the following error:<br>
><br>
> Error preparing query: CREATE TEMPORARY TABLE recordmatch SELECT * FROM<br>
> recordmatch WHERE recordid IS NULL ;<br>
> Driver error was [2/1146]:<br>
> QMYSQL3: Unable to prepare statement<br>
> Database error was:<br>
> Table 'mythconverg.recordmatch' doesn't exist<br>
><br>
> I looked in the database and the table called recordmatch doesn't exist<br>
> (which I think is good because it's just a temp table that gets created at<br>
> the time of the query?) but for whatever reason the scheduler is hung.<br>
><br>
> I also have plenty of free disk space so I'm not sure where to look / what<br>
> to do next. Any suggestions?<br>
<br>
</div></div>You are misteaken about recordmatch. While --testsched uses a<br>
temporary version, the mastetbackend needs a real, permanent one in<br>
the database. You have apparently lost yours and who knows what else<br>
in your database. You will need to restore the database from your<br>
most recent backup.<br>
<span><font color="#888888"><br>
David<br>
--<br>
David Engel<br>
<a href="mailto:david@istwok.net" target="_blank">david@istwok.net</a><br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
</font></span></blockquote></div><br></div></div></div>
</blockquote></div><br></div>