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

[Steven Adeff]

On 5/31/06, David Whyte <david.whyte at gmail.com> wrote:
> On 5/31/06, David Whyte <david.whyte at gmail.com> wrote:
> > On 5/31/06, David Whyte <david.whyte at gmail.com> wrote:
>
> <SNIP>
>
> > >
> > > 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)
> >
>
>
> I was close.  It seems the problem was my root partition was full!  I
> don't know how I didn't notice that sooner.
>
> The reason it was full?  My stupid bloody Benq DVD burner (the piece
> of shit it is).  The other day, the drive locked and wouldn't eject
> the DVD I burnt, so being the heavy handed brute I am, I forced it to
> eject with a paper-clip.
>
> Since then, my kern.log and syslog have both been filling up with
> message like the following:
> May 31 07:39:59 localhost kernel: [5891363.313000] hdc: ATAPI reset complete
> May 31 07:39:59 localhost kernel: [5891363.313000] hdc: status error:
> status=0x58 { DriveReady SeekComplete DataRequest }
> May 31 07:39:59 localhost kernel: [5891363.313000] ide: failed opcode
> was: unknown
> May 31 07:39:59 localhost kernel: [5891363.313000] hdc: drive not
> ready for command
> May 31 07:39:59 localhost kernel: [5891363.313000] hdc: status error:
> status=0x58 { DriveReady SeekComplete DataRequest }
> May 31 07:39:59 localhost kernel: [5891363.313000] ide: failed opcode
> was: unknown
> May 31 07:39:59 localhost kernel: [5891363.313000] hdc: drive not
> ready for command
> May 31 07:39:59 localhost kernel: [5891363.313000] hdc: status error:
> status=0x58 { DriveReady SeekComplete DataRequest }
> May 31 07:39:59 localhost kernel: [5891363.313000] ide: failed opcode
> was: unknown
> May 31 07:39:59 localhost kernel: [5891363.313000] hdc: drive not
> ready for command
>
> so much so that today, they each wrote 2.4Gig's of data.  Given
> logrotate doesn't run until tonight (cron.daily) to compress the log
> files, the partition was full.
>
> The fricken DVD burner is always locking up and has trouble reading
> certain media.  It needs a firmware upgrade I believe, but alas, Benq
> only provides a Windows based upgrader!  Anyways, that is a rant for
> another thread.
>
> Cheers,
> Whytey

What version of Myth are you running? What version of MySQL are you
running? Mysql5 has a known issue with 0.19, -fixes and svn have a
patch i believe which addresses the issue.

-- 
Steve
Before you ask, read the FAQ!
http://www.mythtv.org/wiki/index.php/Frequently_Asked_Questions
then search the Wiki, and this list,
http://www.gossamer-threads.com/lists/mythtv/
Mailinglist etiquette -
http://www.mythtv.org/wiki/index.php/Mailing_List_etiquette