[mythtv-users] Frontend issues. Seems to lose DB connections.

[David Whyte]

As of last night, all of my frontends seem to be suffering from a
problem whereby certain database connections are being lost or queries
are failing.

I first noticed it when mythweb showed no recordings in the 'Recorded
Programs' page.  Freaking out, I looked at the 'Listings' page to find
a bunch of php/mysql errors as follows:

datetime:  2006-05-31 22:49:06 (EST)
    errornum:  256
  error type:  User Error
error string:  SQL Error: Got error 28 from table handler [#1030]
    filename:  /usr/share/mythtv/mythweb/includes/db.php
  error line:  360

So I looked at my real frontend and the 'Watch Recordings' page is
showing 'Sorry, No recordings available' even though they do exist.

Giving up, I left the backend overnight and looking at it this
morning, it seemed to be fixed.

Then, it started happening again, so I restarted the backend and it
looked OK.  But it is doing it again so I rebooted the box but it is
still happening.

Looking at the log, nothing jumps out apart from this in the backend.log:

2006-05-31 21:55:01.000 TVRec(2): Changing from RecordingOnly to None
2006-05-31 21:55:01.231 Finished recording House "Distractions": channel 1008
2006-05-31 21:55:01.314 scheduler: Finished recording: House
"Distractions": channel 1008
2006-05-31 21:55:01.330 Reschedule requested for id 0.
2006-05-31 21:55:01.462 DB Error (AddNewRecords):
Query was:
SELECT DISTINCT channel.chanid, channel.sourceid, program.starttime,
program.endtime, program.title, program.subtitle, program.description,
channel.channum, channel.callsign, channel.name, oldrecorded.endtime
IS NOT NULL AS oldrecduplicate, program.category, record.recpriority,
record.dupin, recorded.endtime IS NOT NULL AS recduplicate,
oldfind.findid IS NOT NULL AS findduplicate, record.type,
record.recordid, program.starttime - INTERVAL record.startoffset
minute AS recsta

The really weird thing is that when this is happening, the following
issues occur:
- I cannot do any GUI Admin type stuff such as change the GDM Login
setup for example as when I confirm the sudo password in the GUI box
it returns the following Error dialog text "Failed to run gdmsetup as
user root: Unable to copy the user's Xauthorization file'
- I cannot run GVIM proper as it reports the following:
'djwhyte at myth:~$ gvim /var/log/mythtv/mythbackend.log
Error detected while processing /usr/share/vim/vimrc:
line   58:
E483: Can't get temp file name
djwhyte at myth:~$'

The backend is a default Ubuntu Breezy install.  It doesn't have
anything from outside of the standard Breezy repos other than mythTV.
The only recent updates have been pushed by the auto update tool, but
that was at least a week ago and myth has only just started to show
this issue.

I fear perhaps my main disk, which has the '/' partition on (and thus
the mysql data and the temp folder) is failing or something similar.

Does anyone else have any ideas?

Any help much appreciated,
Whytey