[pLog-svn] locked tables

[Alexander Kaiser]

hmm i really have no clue. i will do some more testing and ket you guys
know...

On 9/27/06, Jon Daley <plogworld at jon.limedaley.com> wrote:
>
>         I think I have only heard of this once or twice, and it was on a
> cheapo hoster, so we (at least I did) thought that it was probably just an
> unstable mysql daemon or something.  Since I don't think that is the case
> with you, it must be something else.
>         I guess there must be a php script that is terminating
> prematurely, and mysql/php/apache isn't cleaning up when that happens?
>
> On Wed, 27 Sep 2006, Alexander Kaiser wrote:
>
> > hey guys,
> >
> > my "_articles_comments" table gets locked very often the last week, did
> > anyone experience that kind of problem yet?
> >
> > if i repair the table, it works again. analyzing gives me the following
> > error:
> > _articles_comments      check      error      Key in wrong position at
> page
> > 3898368
> > _articles_comments     check     error     Corrupt
> >
> >
> > when i repair and optimize it, it does work again but after some hours,
> out
> > of no reasons it gets locked again.
> > i've tried everything from checking my hd(s) with smart, fsck,
> mysqlcheck
> > and myisamchk. the testing say that tables are OK and everything works.
> >
> > but then again, the error keeps coming back.
> > idea? someone?
> >
>
> --
> Jon Daley
> http://jon.limedaley.com/
>
> Those are my principles. If you don't like them I have others.
> -- Groucho Marx
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http:// devel.lifetype.net/pipermail/plog-svn/attachments/20060928/1e1160ed/attachment.html