[mythtv-users] Some weird issues

[Harry Devine]

OK, so I have Mythbuntu 8.10 running and its been great for a while 
now.  However, I do have some weird issues going on.  First, I noticed 
that some recordings that were set for tonight didn't get recorded, and 
they didn't show up in "Upcoming Recordings".  I started getting some 
errors in Mythweb about some PHP failures, so I decided to reboot the 
machine.

After the reboot, when everything came back, I noticed in Mythweb that a 
few tables were marked as crashed, so I clicked on "Repair Tables".  
That worked, however, I no longer see anything under "Upcoming 
Recordings", and in my "Backend Logs" page in Mythweb, I notice that 
both tuners on my HDHR show up as failed.  The 2 tuners on my pcHDTV 
5500 card show up fine.

Any ideas on where I can figure out what's messed up?  And how to get 
everything back to a somewhat normal state?

I do see some errors like this in the backend log:

2009-06-15 22:28:17.178 Data Refresh because we are unable to query the 
data for day @ offset 1 to determine how much we should have for offset 
day 2.
2009-06-15 22:28:17.180 DB Error (Updating channel callsign):
Query was:

No error type from QSqlError?  Strange...
2009-06-15 22:28:17.180 Updating source #1 (Analog) with grabber 
schedulesdirect1
2009-06-15 22:28:17.249 Refreshing data for Mon Jun 15 2009
2009-06-15 22:28:17.357 Can't get a channel count for source id 1
2009-06-15 22:28:17.384
2009-06-15 22:28:17.383 This DataDirect listings source is shared by 3 
MythTV lineups
2009-06-15 22:28:17.383 DB Error (Querying minimum chanid):
Query was:

No error type from QSqlError?  Strange...
2009-06-15 22:28:17.384 Checking day @ offset 0, date: Mon Jun 15 2009
2009-06-15 22:28:17.388 We should keep data around after this one
2009-06-15 22:28:17.408 DB Error (Querying Recorders):
Query was:
SELECT cardid, hostname FROM capturecard ORDER BY cardid
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

2009-06-15 22:28:17.429 Data Refresh because we are unable to query the 
data for day @ offset -1 to determine how much we should have for offset 
day 0.
2009-06-15 22:28:17.507 Refreshing data for Mon Jun 15 2009
2009-06-15 22:28:17.526 This DataDirect listings source is shared by 3 
MythTV lineups
2009-06-15 22:28:17.528 We should keep data around after this one
2009-06-15 22:28:17.529 New DB DataDirect connection
QSqlQuery::exec: database not open
2009-06-15 22:28:17.599 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
QSqlQuery::exec: database not open
2009-06-15 22:28:17.620 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2009-06-15 22:28:17.558 Unable to connect to database!
2009-06-15 22:28:17.624 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2)


I'm suspecting that I need to repair or compact the mythconverg 
database.  Is this right or is something else gone wrong here?

Thanks,
Harry