[mythtv-users] intermittent mythbackend hang EIT?

[Stephen Robertson]

2009/3/24 David Watkins <watkinshome at gmail.com>

> > No error type from QSqlError?  Strange...
> > 2009-03-24 02:26:38.903 DB Error (Looking up chanID):
> > Query was:
>
>
> That looks like what I remember seeing when mythbackend starts and
> can't connect to the mysql server.
>
> Is it possible that your database connection has died, rather than
> there being something wrong with the query?
>
> Just a thought.


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

Thanks

Stephen

Further extract from mythbackend log:
2009-03-24 02:27:10.838 DB Error (Looking up chanID):
Query was:

No error type from QSqlError?  Strange...
2009-03-24 02:27:11.155 DB Error (Looking up chanID):
Query was:

No error type from QSqlError?  Strange...
QSqlQuery::exec: empty query
2009-03-24 02:27:11.192 DB Error (Looking up chanID):
Query was:

No error type from QSqlError?  Strange...
2009-03-24 02:27:40.928 Using runtime prefix = /usr
2009-03-24 02:27:40.933 Empty LocalHostName.
2009-03-24 02:27:40.934 Using localhost value of bressay
2009-03-24 02:27:41.601 Cannot find default UPnP backend
2009-03-24 02:27:41.614 New DB connection, total: 1
2009-03-24 02:27:41.619 Connected to database 'mythconverg' at host:
127.0.0.1

2009-03-24 02:27:41.623 Deleting UPnP client...
2009-03-24 02:27:42.421 Connected to database 'mythconverg' at host:
127.0.0.1
2009-03-24 02:27:42.424 New DB connection, total: 2
2009-03-24 02:27:42.426 Connected to database 'mythconverg' at host:
127.0.0.1
2009-03-24 02:27:42.429 Current Schema Version: 1214
Starting up as the master server.
2009-03-24 02:27:42.481 New DB connection, total: 3
2009-03-24 02:27:42.483 Connected to database 'mythconverg' at host:
127.0.0.1
2009-03-24 02:27:42.754 New DB scheduler connection
2009-03-24 02:27:42.756 Connected to database 'mythconverg' at host:
127.0.0.1
2009-03-24 02:27:42.835 MediaServer:: Loopback address specified -
127.0.0.1. Disabling UPnP
2009-03-24 02:27:42.836 Main::Registering HttpStatus Extension
2009-03-24 02:27:42.836 mythbackend version: 0.21.20080304-1 www.mythtv.org
2009-03-24 02:27:42.837 Enabled verbose msgs:  important general
2009-03-24 02:27:42.840 AutoExpire: CalcParams(): Max required Free Space:
1.0 GB w/freq: 1$
2009-03-24 02:27:45.762 Reschedule requested for id -1.
2009-03-24 02:27:46.119 Scheduled 48 items in 0.4 = 0.04 match + 0.31 place
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20090324/71ca6ea7/attachment.htm>