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

[David Whyte]

On 5/31/06, David Whyte <david.whyte at gmail.com> wrote:
> 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
>

I should note, the other issues I put above intermittently fix
themselves as does mythTV.  I.e., one minute, the mythweb recordings
page is fine, the next refresh and it is empty (or worse, half OK,
half php/mysql errors)