<div>My scheduler suddenly stopped working. I've run a <a href="http://optimize_mythdb.pl">optimize_mythdb.pl</a> and it ran fine. When I run mythbackend --testsched I get the following error:</div><div><br></div><div>
Error preparing query: CREATE TEMPORARY TABLE recordmatch SELECT * FROM recordmatch WHERE recordid IS NULL ; </div><div>Driver error was [2/1146]:</div><div>QMYSQL3: Unable to prepare statement</div><div>Database error was:</div>
<div>Table 'mythconverg.recordmatch' doesn't exist</div><div><br></div><div>I looked in the database and the table called recordmatch doesn't exist (which I think is good because it's just a temp table that gets created at the time of the query?) but for whatever reason the scheduler is hung.</div>
<div><br></div><div>I also have plenty of free disk space so I'm not sure where to look / what to do next. Any suggestions?</div><div><br></div><div>Jason</div>