<div class="gmail_quote">2009/3/24 David Watkins <span dir="ltr"><<a href="mailto:watkinshome@gmail.com">watkinshome@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">> No error type from QSqlError? Strange...<br>
> 2009-03-24 02:26:38.903 DB Error (Looking up chanID):<br>
> Query was:<br>
<br>
<br>
</div>That looks like what I remember seeing when mythbackend starts and<br>
can't connect to the mysql server.<br>
<br>
Is it possible that your database connection has died, rather than<br>
there being something wrong with the query?<br>
<br>
Just a thought.</blockquote><div><br>Possibly. Certainly the times when it has not fallen over completely then the frontend still knows that the backend is there, but the watch recordings screen, for example, is empty. In this instance the backend stopped and was restarted by monit and everything seemed to carry on fine<br>
<br>Thanks<br><br>Stephen<br><br></div></div>Further extract from mythbackend log:<br>2009-03-24 02:27:10.838 DB Error (Looking up chanID):<br>Query was:<br><br>No error type from QSqlError? Strange...<br>2009-03-24 02:27:11.155 DB Error (Looking up chanID):<br>
Query was:<br><br>No error type from QSqlError? Strange...<br>QSqlQuery::exec: empty query<br>2009-03-24 02:27:11.192 DB Error (Looking up chanID):<br>Query was:<br><br>No error type from QSqlError? Strange...<br>2009-03-24 02:27:40.928 Using runtime prefix = /usr<br>
2009-03-24 02:27:40.933 Empty LocalHostName.<br>2009-03-24 02:27:40.934 Using localhost value of bressay<br>2009-03-24 02:27:41.601 Cannot find default UPnP backend<br>2009-03-24 02:27:41.614 New DB connection, total: 1<br>
2009-03-24 02:27:41.619 Connected to database 'mythconverg' at host: 127.0.0.1<br><br>2009-03-24 02:27:41.623 Deleting UPnP client...<br>2009-03-24 02:27:42.421 Connected to database 'mythconverg' at host: 127.0.0.1<br>
2009-03-24 02:27:42.424 New DB connection, total: 2<br>2009-03-24 02:27:42.426 Connected to database 'mythconverg' at host: 127.0.0.1<br>2009-03-24 02:27:42.429 Current Schema Version: 1214<br>Starting up as the master server.<br>
2009-03-24 02:27:42.481 New DB connection, total: 3<br>2009-03-24 02:27:42.483 Connected to database 'mythconverg' at host: 127.0.0.1<br>2009-03-24 02:27:42.754 New DB scheduler connection<br>2009-03-24 02:27:42.756 Connected to database 'mythconverg' at host: 127.0.0.1<br>
2009-03-24 02:27:42.835 MediaServer:: Loopback address specified - 127.0.0.1. Disabling UPnP<br>2009-03-24 02:27:42.836 Main::Registering HttpStatus Extension<br>2009-03-24 02:27:42.836 mythbackend version: 0.21.20080304-1 <a href="http://www.mythtv.org">www.mythtv.org</a><br>
2009-03-24 02:27:42.837 Enabled verbose msgs: important general<br>2009-03-24 02:27:42.840 AutoExpire: CalcParams(): Max required Free Space: 1.0 GB w/freq: 1$<br>2009-03-24 02:27:45.762 Reschedule requested for id -1.<br>
2009-03-24 02:27:46.119 Scheduled 48 items in 0.4 = 0.04 match + 0.31 place