Re: FN-FORUM inconsistent mysql errors

date posted 19th July 2001 22:59

On Thu, Jul 19, 2001 at 12:46:54PM +0100, warren alexander wrote:
> Can anyone help?
> I've been tearing my hair out getting inconsistent errors with mysql.
> my tables keep corrupting, even when I only use very simple sql commands (eg
> 'select * from jobs').
> myisamchk finds (and 'fixes') problems, but the tables corrupt again almost
> immediately.
> I've moved the database onto another server where it seems to be working
> fine, but I cannot work out what was going wrong on the first server.
> the server in question is managed by DSVR, who claim there have been no
> errors reported in the kernel logs, so there cannot be a hardware problem,
> but I cannot think of anything else, unless mysql itself contains bugs
> (we're using 3.23.38, claimed to be stable).
>
> Anyone have any ideas?

This may well be a hard disk fault - particularly an IDE drive configured
for 32 bit access when it shouldn't be - if your second, working installation
uses the same mysql build on the same kernel version then it is highly
likely. This sort of error wouldn't necessarily put errors in the kernel
log - you'd just find things getting corrupted randomly.

If it corrupts almost immediately, you could try running the server in the
foreground and tracing what it does with strace - then finding at what stage
bad data is written out.

You might also try keeping a binlog, and seeing if that is also corrupted.